1,537
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − Line 6:
Line 5: − + − − + − + − + − + − + − + − + − + − |- − | colspan="8" rowspan="1" |Day 1 Line 44:
Line 40: − + + + + + + + + Line 57:
Line 60: − + − + − + − + − + + + + + + Line 95:
Line 103: − Resources: − + + + + + + − +
Digital literacy workshop - Lalbagh Siddapura and Wilson garden clusters (view source)
Revision as of 10:48, 21 December 2023
, 10:48, 21 December 2023no edit summary
'''Objectives :'''
=== '''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
* 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
|'''Who'''
|Comments
|'''Comments'''
|Observation Points
|'''Observation Points'''
|-
|-
|1
|1
|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 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
|Sample data and files
|11 am to 1.30 pm
|11 am to 1.30 pm
|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
|
|
|}
|}
Reference links:
=== Resources ===
==== Reference links ====
# [https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc Learn LibreOffice Calc]
# [https://teacher-network.in/OER/index.php/Learn_Google_Form Learn Google Form]
Feedback form:
==== Feedback form ====