Difference between revisions of "Digital literacy workshop - Lalbagh Siddapura and Wilson garden clusters"

From Karnataka Open Educational Resources
Jump to navigation Jump to search
 
(16 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
'''Objectives :'''
+
[https://karnatakaeducation.org.in/KOER/index.php/Special:ShortUrl/630 ಕನ್ನಡದಲ್ಲಿ  ಈ ಪುಟವನ್ನು ನೋಡಲು ಇಲ್ಲಿ ಕ್ಲಿಕ್ ಮಾಡಿ]
  
 +
=== Objectives ===
 
* Learning to use spreadsheets on mobile and desktop computers
 
* Learning to use spreadsheets on mobile and desktop computers
 
* Using spreadsheet for planning and scheduling classroom lesson transactions
 
* Using spreadsheet for planning and scheduling classroom lesson transactions
Line 6: Line 7:
 
* Using Google forms for collecting, consolidating  and analysing students/school related data
 
* Using Google forms for collecting, consolidating  and analysing students/school related data
  
−
 
+
=== Session plan: ===
−
Session plan:
 
 
{| class="wikitable"
 
{| class="wikitable"
−
|Sl. No.
+
|'''Sl. No.'''
−
|Topic/ Activity
+
|'''Topic/ Activity'''
−
|Description/ Process
+
|'''Description/ Process'''
−
|Resources/Materials
+
|'''Resources/Materials'''
−
|Duration
+
|'''Duration'''
−
|Who
+
|'''Details'''
−
|Comments
 
−
|Observation Points
 
−
|-
 
−
| colspan="8" rowspan="1" |Day 1
 
 
|-
 
|-
 
|1
 
|1
 
|Introduction
 
|Introduction
−
|programe overview and linking to teachers expectations
+
|Program overview and linking to teachers expectations
 
|Slides
 
|Slides
 
|10:00 to 10:30AM
 
|10:00 to 10:30AM
−
|AS
 
 
|About TIEE (2-3 slides)
 
|About TIEE (2-3 slides)
−
|
 
 
|-
 
|-
 
|2
 
|2
Line 34: Line 28:
 
|Sample files
 
|Sample files
 
|10.30 to 11am
 
|10.30 to 11am
−
|GMP
 
 
|Sample files:
 
|Sample files:
 
1. Student assessment,
 
1. Student assessment,
Line 40: Line 33:
 
3. Time table and School annual plan,
 
3. Time table and School annual plan,
 
4. Other data collections
 
4. Other data collections
−
|
 
 
|-
 
|-
 
|3
 
|3
 
|Using Spreadsheet for different task
 
|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
+
|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
 
|Sample data and files
 
|11 am to 1.30 pm
 
|11 am to 1.30 pm
−
|GMP, AY
 
 
|
 
|
−
|.
 
 
|-
 
|-
−
| colspan="8" rowspan="1" |Lunch (1.30  to 2:00PM)
+
| colspan="6" rowspan="1" |Lunch (1.30  to 2:00PM)
 
|-
 
|-
−
|2
+
|4
 
|Use Google form to collect data (mobile)
 
|Use Google form to collect data (mobile)
 
|1. Creating a Google form on mobile,
 
|1. Creating a Google form on mobile,
 
2. Introducing different question types,
 
2. Introducing different question types,
−
3. Duplicating and deleting question
+
 
−
4. Rearranging questions and options
+
3. Duplicating and deleting questions,
−
5. Saving the form and sharing the URL
+
 
−
6. Accessing form responses and exporting it  
+
4. Rearranging questions and options,
−
7. Analysing responses on spredsheet
+
 
 +
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
 
|2 pm to 3.30 pm
−
|AS, GMP
 
−
|
 
 
|
 
|
 
|-
 
|-
−
| colspan="8" rowspan="1" |4
+
|5
−
|-
 
−
|
 
 
|Feedback forms
 
|Feedback forms
 
|Teachers are made to fill the form
 
|Teachers are made to fill the form
 
|
 
|
 
|3.30 to 3.45 PM
 
|3.30 to 3.45 PM
−
|AY
 
−
|
 
 
|
 
|
 
|-
 
|-
−
|
+
|6
 
|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
−
|
 
 
|
 
|
 
|
 
|
 
|Subject to availability of time
 
|Subject to availability of time
−
|
 
 
|-
 
|-
−
|
+
|7
 
|Way forward
 
|Way forward
 
|Consolidation of the workshop learnings and COP
 
|Consolidation of the workshop learnings and COP
 
|
 
|
 
|3.45 to 4:00 PM
 
|3.45 to 4:00 PM
−
|AY
 
−
|
 
 
|
 
|
 
|}
 
|}
−
Resources:
 
  
−
Reference links:
+
=== Resources reference links ===
 +
 
 +
#[https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc Spreadsheet handout]
 +
#Learn to [https://teacher-network.in/OER/index.php/Learn_Tux_Typing type]
 +
#I want to [[Buy your ICT device|buy a laptop]]
 +
#[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]
  
−
Feedback form:
+
[[Category:TIEE]]
 +
[[Category:Workshop]]
 +
[[Category:Digital literacy]]

Latest revision as of 07:29, 31 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 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

Retrieved from "https://karnatakaeducation.org.in/KOER/en/index.php?title=Digital_literacy_workshop_-_Lalbagh_Siddapura_and_Wilson_garden_clusters&oldid=40876"