Line 1: |
Line 1: |
| + | [https://karnatakaeducation.org.in/KOER/index.php/Special:ShortUrl/630 ಕನ್ನಡದಲ್ಲಿ ಈ ಪುಟವನ್ನು ನೋಡಲು ಇಲ್ಲಿ ಕ್ಲಿಕ್ ಮಾಡಿ] |
| + | |
| === Objectives === | | === Objectives === |
| * Learning to use spreadsheets on mobile and desktop computers | | * Learning to use spreadsheets on mobile and desktop computers |
Line 12: |
Line 14: |
| |'''Resources/Materials''' | | |'''Resources/Materials''' |
| |'''Duration''' | | |'''Duration''' |
− | |'''Who''' | + | |'''Details''' |
− | |'''Comments'''
| |
− | |'''Observation Points'''
| |
| |- | | |- |
| |1 | | |1 |
Line 21: |
Line 21: |
| |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 30: |
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 36: |
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). | + | |1. Introduction to spreadsheets, navigating and interfaces. Cells (data element), rows (records), columns, adding and deleting sheets, file saving. |
− | 2. Entering your data in spreadsheet. | + | 2. Entering your data in a spreadsheet. |
| | | |
− | 3. Providing headings (columns), formatting rows and columns, working with alignment and text wrap. | + | 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. Sorting, filtering your entered data, | + | 4. Adding line breaks, Merging cells, auto fill(1,2,3,....), duplicating data |
| | | |
− | 5. Using basic operations with formulas 6. Creating visual representation of 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) |
| |- | | |- |
| |4 | | |4 |
Line 72: |
Line 74: |
| | | | | |
| |2 pm to 3.30 pm | | |2 pm to 3.30 pm |
− | |AS, GMP
| |
− | |
| |
| | | | | |
| |- | | |- |
Line 81: |
Line 81: |
| | | | | |
| |3.30 to 3.45 PM | | |3.30 to 3.45 PM |
− | |AY
| |
− | |
| |
| | | | | |
| |- | | |- |
Line 88: |
Line 86: |
| |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 | | |7 |
Line 99: |
Line 95: |
| | | | | |
| |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 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 Learn Google Form] | + | #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 ====
| + | === 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:Workshop]] |
| + | [[Category:Digital literacy]] |