Anonymous

Changes

From Karnataka Open Educational Resources
Line 10: Line 10:  
|'''No'''
 
|'''No'''
 
|'''Session name'''
 
|'''Session name'''
|'''Time'''
   
|'''Session details'''
 
|'''Session details'''
 
|'''Resources'''
 
|'''Resources'''
 
|-
 
|-
 
|
 
|
| colspan="4" |'''DAY 1 - 24 May 2023'''
+
| colspan="3" |
 
|-
 
|-
 
|1
 
|1
 
|Introduction to workshop
 
|Introduction to workshop
|11.30 – 12.00
   
|1. Introduction to the workshop
 
|1. Introduction to the workshop
   Line 29: Line 27:  
|2
 
|2
 
|Entering data and organising data
 
|Entering data and organising data
|12.00 – 1.30
   
|1. Introduction to spreadsheet, navigating and interfaces. Cells (data element), rows (records), columns.
 
|1. Introduction to spreadsheet, navigating and interfaces. Cells (data element), rows (records), columns.
   Line 46: Line 43:  
|-
 
|-
 
|
 
|
| colspan="4" |'''DAY 2 - 25 May 2023'''
+
| colspan="3" |
 
|-
 
|-
 
|3
 
|3
 
|Formatting our spreadsheet and make your data more meaningful
 
|Formatting our spreadsheet and make your data more meaningful
|11.30 – 1.30
   
|1. Hiding and showing columns, Header / Footer
 
|1. Hiding and showing columns, Header / Footer
 
2. Finding and replacing data, Freeze Panes
 
2. Finding and replacing data, Freeze Panes
Line 68: Line 64:  
|-
 
|-
 
|
 
|
| colspan="4" |'''DAY 3 - 05 June 2023'''
+
| colspan="3" |
 
|-
 
|-
 
|4
 
|4
 
|Understanding data from a research data
 
|Understanding data from a research data
|11:30-12:00
   
|Reading and understanding the data
 
|Reading and understanding the data
 
|
 
|
Line 78: Line 73:  
|5
 
|5
 
|Creating formulas and functions
 
|Creating formulas and functions
|12:00-1:30
   
|1. Using basic operations – sum, subtraction,division and applying it to the research study
 
|1. Using basic operations – sum, subtraction,division and applying it to the research study
   Line 89: Line 83:  
|-
 
|-
 
|
 
|
| colspan="4" |'''DAY 4 - 06 June 2023'''
+
| colspan="3" |
 
|-
 
|-
 
|6
 
|6
 
|Creating charts and Pivot Tables
 
|Creating charts and Pivot Tables
|11.30 – 1.00
   
|1. Using different charts in your spreadsheet
 
|1. Using different charts in your spreadsheet
   Line 103: Line 96:  
|
 
|
 
|-
 
|-
|
+
| colspan="4" |'''Open discussion'''
|'''Open discussion'''
  −
|1:00-1:30
  −
|
  −
|
   
|}
 
|}
   Line 115: Line 104:  
# Spoken tutorials on Calc ([https://spoken-tutorial.org/tutorial-search/?search_foss=LibreOffice+Calc+on+BOSS+Linux&search_language=English English])  
 
# Spoken tutorials on Calc ([https://spoken-tutorial.org/tutorial-search/?search_foss=LibreOffice+Calc+on+BOSS+Linux&search_language=English English])  
   −
=== Participants feedback ===
+
=== Practice sheet ===
Please enter your [https://docs.google.com/forms/d/e/1FAIpQLSeousH-96fATVWd29d-baALsFSrs79Dp-mY5PSLmbhAstqvfQ/viewform feedback on the workshop in this form]
+
[https://cloud.itforchange.net/s/55WSMwzbyg2rpgN/download/Sample_Data.ods Download practice sheet]
 
[[Category:Workshop]]
 
[[Category:Workshop]]
RIESI
339

edits