Line 10: |
Line 10: |
| # Access and make use of available resource repositories | | # Access and make use of available resource repositories |
| | | |
| + | == Agenda of the workshop == |
| {| class="wikitable" | | {| class="wikitable" |
| !'''''Timings''''' | | !'''''Timings''''' |
Line 71: |
Line 72: |
| |5. Accessing form from the Mobile. | | |5. Accessing form from the Mobile. |
| |- | | |- |
− | | colspan="2" |'''''3.00 to 3.15'''''
| + | | colspan="1" rowspan="5" |''3 PM to 4.15 PM'' |
− | | colspan="2" |'''TEA BREAK'''
| + | | colspan="1" rowspan="5" |Handling different kind of data and processing |
− | |-
| + | |1. Understanding the spreadsheet interface and Google sheet |
− | | colspan="1" rowspan="5" |''3.15 to 4.00'' | |
− | | colspan="1" rowspan="5" |Creating with ICT – text resources 2 | |
− | |1. Understanding the spreadsheet interface and opening spreadsheets downloaded from G-form | |
− | | rowspan="5" |[https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc LibreOffice Calc] [https://teacher-network.in/OER/index.php/Learn_Google_Drive handout]
| |
− | |-
| |
− | |2. Creating and entering data in a new spreadsheet, saving and exporting to share it with others
| |
| |- | | |- |
− | |3. Spreadsheet basic formatting - Inserting, Renaming, and Deleting Worksheets | + | |2. Using office sute to process the data and organising it |
| |- | | |- |
− | |4. Formatting spreadsheet to make data more readable | + | |3. Spreadsheet formatting features - Renaming, freez, wrap cell, number formats, worksheets, orint range |
| |- | | |- |
− | |5. Basic formula and using Pivot table to analyses data | + | |4. Using piovt, sort, advance filter options |
| |- | | |- |
− | | colspan="1" rowspan="4" |''4.00 to 4.30'' | + | |5. Basic formula and using Pivot table to analyses data |
− | | colspan="1" rowspan="4" |Exploring mobile apps and settings
| |
− | |1. Setting up WhatsApp and about group settings, broadcast
| |
− | |
| |
| |- | | |- |
− | |2. Accessing google drive and the form through phone | + | | colspan="1" rowspan="2" |''4.15 to 4.30 PM'' |
− | | | + | | colspan="1" rowspan="2" |Concluding the workshop |
| + | |Way forward – support and resources sharing, technical support for CRPs |
| |- | | |- |
− | |3. Using Google translator, Voice to text and dictionaries | + | |Feedback form |
− | |[https://play.google.com/store/apps/details?id=com.google.android.apps.translate Google translator]
| |
| |- | | |- |
− | |4. exploring ad blocker and file manager apps
| |
− | |[https://blokada.org/ Blokada]
| |
− | |-
| |
− | | colspan="4" |Participants need to fill the feedback form
| |
| |} | | |} |
− |
| |
− | == Agenda of the workshop ==
| |
− |
| |
| | | |
| == Resources == | | == Resources == |