Difference between revisions of "Digital literacy workshop - Lalbagh Siddapura and Wilson garden clusters"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
|'''Resources/Materials''' | |'''Resources/Materials''' | ||
|'''Duration''' | |'''Duration''' | ||
| − | |''' | + | |'''Details''' |
| − | |||
|- | |- | ||
|1 | |1 | ||
| Line 22: | Line 21: | ||
|Slides | |Slides | ||
|10:00 to 10:30AM | |10:00 to 10:30AM | ||
| − | |||
|About TIEE (2-3 slides) | |About TIEE (2-3 slides) | ||
|- | |- | ||
| Line 30: | Line 28: | ||
|Sample files | |Sample files | ||
|10.30 to 11am | |10.30 to 11am | ||
| − | |||
|Sample files: | |Sample files: | ||
1. Student assessment, | 1. Student assessment, | ||
| Line 49: | Line 46: | ||
|Sample data and files | |Sample data and files | ||
|11 am to 1.30 pm | |11 am to 1.30 pm | ||
| − | |||
| | | | ||
|- | |- | ||
| − | | colspan=" | + | | colspan="6" rowspan="1" |Lunch (1.30 to 2:00PM) |
|- | |- | ||
|4 | |4 | ||
| Line 70: | Line 66: | ||
| | | | ||
|2 pm to 3.30 pm | |2 pm to 3.30 pm | ||
| − | |||
| | | | ||
|- | |- | ||
| Line 78: | Line 73: | ||
| | | | ||
|3.30 to 3.45 PM | |3.30 to 3.45 PM | ||
| − | |||
| | | | ||
|- | |- | ||
| Line 84: | Line 78: | ||
|Resource sharing | |Resource sharing | ||
|Sharing Phet sims(Maths and Sciecne), Language Lab and learn page | |Sharing Phet sims(Maths and Sciecne), Language Lab and learn page | ||
| − | |||
| | | | ||
| | | | ||
| Line 94: | Line 87: | ||
| | | | ||
|3.45 to 4:00 PM | |3.45 to 4:00 PM | ||
| − | |||
| | | | ||
|} | |} | ||
| − | + | === Resources reference links === | |
| − | # [https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc | + | #[https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc Spreadsheet handout] |
| − | # [https://teacher-network.in/OER/index.php/Learn_Google_Form | + | #[https://teacher-network.in/OER/index.php/Learn_Google_Form Use this Google Form user manual to create/edit forms] |
| + | # [https://teacher-network.in/OER/index.php/Explore_an_application Explore more FOSS applications for your classroom teaching] | ||
| − | + | === Feedback form === | |
[https://forms.gle/DfQDZJ96KxsvmLNcA Click here to fill feedback form] | [https://forms.gle/DfQDZJ96KxsvmLNcA Click here to fill feedback form] | ||
[[Category:TIEE]] | [[Category:TIEE]] | ||
[[Category:Workshop]] | [[Category:Workshop]] | ||
Revision as of 04:46, 22 December 2023
ಕನ್ನಡದಲ್ಲಿ ಈ ಪುಟವನ್ನು ನೋಡಲು ಇಲ್ಲಿ ಕ್ಲಿಕ್ ಮಾಡಿ
Objectives
- Learning to use spreadsheets on mobile and desktop computers
- Using spreadsheet for planning and scheduling classroom lesson transactions
- Using spreadsheet for tracking and analysing student grades and progress
- Using Google forms for collecting, consolidating and analysing students/school related data
Session plan:
| Sl. No. | Topic/ Activity | Description/ Process | Resources/Materials | Duration | Details |
| 1 | Introduction | Program overview and linking to teachers expectations | Slides | 10:00 to 10:30AM | About TIEE (2-3 slides) |
| 2 | Context setting | What and why of spreadsheet and Google form, samples use cases demo, | Sample files | 10.30 to 11am | Sample files:
1. Student assessment, 2. Session Planning, 3. Time table and School annual plan, 4. Other data collections |
| 3 | Using Spreadsheet for different task | 1. Introduction to spreadsheet, navigating and interfaces. Cells (data element), rows (records), columns, types of data (text, numbers and its format, date and its format).
2. Entering your data in spreadsheet. 3. Providing headings (columns), formatting rows and columns, working with alignment and text wrap. 4. Sorting, filtering your entered data, 5. Using basic operations with formulas 6. Creating visual representation of data |
Sample data and files | 11 am to 1.30 pm | |
| Lunch (1.30 to 2:00PM) | |||||
| 4 | Use Google form to collect data (mobile) | 1. Creating a Google form on mobile,
2. Introducing different question types, 3. Duplicating and deleting questions, 4. Rearranging questions and options, 5. Saving the form and sharing the URL, 6. Accessing form responses and exporting it, 7. Analysing responses on spreadsheet |
2 pm to 3.30 pm | ||
| 5 | Feedback forms | Teachers are made to fill the form | 3.30 to 3.45 PM | ||
| 6 | Resource sharing | Sharing Phet sims(Maths and Sciecne), Language Lab and learn page | Subject to availability of time | ||
| 7 | Way forward | Consolidation of the workshop learnings and COP | 3.45 to 4:00 PM | ||
Resources reference links
- Spreadsheet handout
- Use this Google Form user manual to create/edit forms
- Explore more FOSS applications for your classroom teaching