Digital literacy workshop - Lalbagh Siddapura and Wilson garden clusters

ಕನ್ನಡದಲ್ಲಿ ಈ ಪುಟವನ್ನು ನೋಡಲು ಇಲ್ಲಿ ಕ್ಲಿಕ್ ಮಾಡಿ

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 spreadsheets, navigating and interfaces. Cells (data element), rows (records), columns, adding and deleting sheets, file saving. 2. Entering your data in a spreadsheet. 3. Providing headings (columns), formatting rows and columns(Text styles, colours, cell background, and border etc,), types of data (text, numbers and their format, date and its format), working with alignment and text wrap. 4. Adding line breaks, Merging cells, auto fill(1,2,3,....), duplicating data 5. Sorting, filtering your entered data, 6. Using basic formulas - sum, count, average, percentage 7. Creating a visual representation of data 8. Exporting - pdf and image format. 9. Installing Google Sheets(.llc) on the teacher's mobile phones following that hands-on practice.	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

1. Spreadsheet handout
2. Learn to type
3. I want to buy a laptop
4. Use this Google Form user manual to create/edit forms
5. Explore more FOSS applications for your classroom teaching

Feedback form

Click here to fill feedback form