Technology workshop for the Bengaluru south-3 CRPs - June 29th 2024
From Karnataka Open Educational Resources
The workshop is scheduled on June 29th 2024 at the Vijaya Teachers College (VTC) computer lab.
Google map link for the location: https://goo.gl/maps/8a8XuxQ7nCcNuJBU9.
Objectives of the workshop
- Introduce Information & Communication Technologies (ICT) to the group of BRPs/CRPs
- Develop familiarity with IT for Change initiatives and the TIEE project
- Understand the importance of Free and Open Source Software (FOSS) and Open Educational Resources (OER) in Education
- Explore digital tools to support CRPs in their routine work
- Access and make use of available resource repositories
Agenda of the workshop
Timings | Session title | Session details | Resources |
---|---|---|---|
10.00 AM- 10.45 AM | Introduction to the workshop | 1. Overview of the workshop | |
2. Expectation from the Workshop | |||
3. Discussing the challenges | |||
4. ICT in Education (brief) | |||
10.45 AM – 11.30 AM | Exploring some useful FOSS tools and
Connecting to the word |
1. Accessing the existed information/resources from the Internet | |
2. Looking for copyrighted resources and Understanding of OER | |||
3. Useful websites – subject wise and administration related | |||
4. Going through useful FOSS tools – PDF shuffler, Okular, Image editing | |||
5. Exploring useful mobile apps – Collabora, ad-blocker, freetube | |||
11.30 AM to 11.45 AM | TEA BREAK | ||
11.45 AM – 1.00 PM | About our work and 24-25 TIEE action plan presentation | 1. About ITFC projects in the state (S3 work KLEAP, Blr North and Adolescent program) | |
2. Sharing subject wise resource modules – Lang, science and math (KOER pages, story rep) | |||
3. Collect inputs from CRPS and seeking their support for the effective work in the block | |||
1.00 PM to 1.45 PM | LUNCH | ||
1.45 to 2.00 PM | Using SATS platform and UDISE data port, and open-house sessions | Open-house session, addressing if there are any issues | |
2.00 PM – 3.00 PM | Collecting and Handling different kind of data through | 1. Access Google Drive and google apps – filling the dummy form by CRPS | Google Drive handout |
2. Use Google form - to create forms and collect information. | |||
3. Using conditions based questions and setting up a restrictions. | |||
4. Exporting responses into a spreadsheet. | |||
5. Accessing form from the Mobile. | |||
3.00 PM to 4.15 PM | Handling different kind of data and processing | 1. Understanding the spreadsheet interface and Google sheet | LibreOffice Calc Handout |
2. Using office suite to process the data and organizing it | |||
3. Spreadsheet formatting features - Renaming, freez, wrap cell, number formats, worksheets, orint range | |||
4. Using pivot, sort, advance filter options | |||
5. Basic formula and using Pivot table to analyses data | |||
4.15 PM to 4.30 PM | Concluding the workshop | Way forward – support and resources sharing, technical support for CRPs | |
Feedback form |
Resources
- KSPSTADK https://kspstadk.com/
- Role of BRC and CRC centres
- CRP from Annagere, Dharwad - https://nammashikshakarigagi.blogspot.com/
- Mahamad Bhasha - https://www.nammasarakarishaale.com
- Mathesh T Martalli - https://yelige.blogspot.com/
Technology resources
- Getting comfortable to use Mozilla firefox
- LibreOffice Calc (to work with spreadsheets)
- LibreOffice writer (to create word document)
- Video tutorials on other FOSS tools
- What is copyright and what is OER