Line 4: |
Line 4: |
| # Learn to use spreadsheet to input data collected from (M.Ed.) research | | # Learn to use spreadsheet to input data collected from (M.Ed.) research |
| # Analyse the collected data and prepare reports using a test case | | # Analyse the collected data and prepare reports using a test case |
− | # Input, tabulate, analyse and produce reports for their M.Ed research project/assignment | + | # Input, tabulate, analyse and produce reports for their M.Ed research project |
| | | |
| === Participant information === | | === Participant information === |
Line 30: |
Line 30: |
| 2. Go through detailed Agenda | | 2. Go through detailed Agenda |
| | | |
− | 3. Participants information and expectation | + | 3. [http://tinyurl.com/pi221218 Participants information] and expectation |
| |Workshop page | | |Workshop page |
| |- | | |- |
Line 51: |
Line 51: |
| | | |
| 7. Moving across sheet using CTRL keys | | 7. Moving across sheet using CTRL keys |
− | |LibreOffice calc handout | + | |[https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc#Advanced_features LibreOffice Calc handout] |
| |- | | |- |
| |3 | | |3 |
Line 71: |
Line 71: |
| | | | | |
| |LUNCH | | |LUNCH |
− | |1.30 – 2.15 | + | |1.30 – 2 |
| | | | | |
| + | | |
| + | |- |
| + | |3a |
| + | |Understanding data from own study |
| + | |2 - 3 |
| + | |Discussing the data collected by students and learning how to enter into a spreadsheet |
| + | Exploring statistical functions using few statistical functions |
| | | | | |
| |- | | |- |
| |4 | | |4 |
| |Creating formulas and functions | | |Creating formulas and functions |
− | |2.15 – 3.30 | + | |3 – 3.30 |
| |1. Using basic operations – sum, subtraction, division and applying it to the research study | | |1. Using basic operations – sum, subtraction, division and applying it to the research study |
| | | |
Line 137: |
Line 144: |
| # [https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc LibreOffice Calc manual] | | # [https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc LibreOffice Calc manual] |
| # [https://www.youtube.com/watch?v=9VSdwWRrx8k Video on using formula] | | # [https://www.youtube.com/watch?v=9VSdwWRrx8k Video on using formula] |
| + | # Spoken tutorials on Calc ([https://spoken-tutorial.org/tutorial-search/?search_foss=LibreOffice+Calc+on+BOSS+Linux&search_language=English English]) |
| | | |
− | === participants feedback === | + | === Participants feedback === |
| Please enter your [https://docs.google.com/forms/d/e/1FAIpQLSeousH-96fATVWd29d-baALsFSrs79Dp-mY5PSLmbhAstqvfQ/viewform feedback on the workshop in this form] | | Please enter your [https://docs.google.com/forms/d/e/1FAIpQLSeousH-96fATVWd29d-baALsFSrs79Dp-mY5PSLmbhAstqvfQ/viewform feedback on the workshop in this form] |
| [[Category:Workshop]] | | [[Category:Workshop]] |