Difference between revisions of "Workshop for ITEP students on statistical analyses"

From Karnataka Open Educational Resources
Jump to navigation Jump to search
(Created page with "=== Objectives === # Basic digital literacy # Familiarity with spreadsheet (LibreOffice Calc) # Learn to use spreadsheet to input data collected from (B.Ed.) research # Analys...")
 
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
=== Objectives ===
 
=== Objectives ===
# Basic digital literacy
+
# Action research processes (Understanding data)
 
# Familiarity with spreadsheet (LibreOffice Calc)
 
# Familiarity with spreadsheet (LibreOffice Calc)
# Learn to use spreadsheet to input data collected from (B.Ed.) research
+
# Learn to use spreadsheet to input data  
# Analyse the collected data and prepare reports using a test case
+
# Analyse the data and prepare reports  
# Input, tabulate, analyse and produce reports for their B.Ed research project
+
# Input, tabulate, analyse and produce reports (includes pivots and chart)
 
 
=== Participant information ===
 
All participants fill participant information form [http://tinyurl.com/pi221218 here]
 
  
 
=== Workshop Agenda ===
 
=== Workshop Agenda ===
Line 13: Line 10:
 
|'''No'''
 
|'''No'''
 
|'''Session name'''
 
|'''Session name'''
|'''Time'''
 
 
|'''Session details'''
 
|'''Session details'''
 
|'''Resources'''
 
|'''Resources'''
 
|-
 
|-
 
|
 
|
|'''DAY 1'''
+
| colspan="3" |
|
 
|
 
|
 
 
|-
 
|-
 
|1
 
|1
 
|Introduction to workshop
 
|Introduction to workshop
|11.30 – 12.00
 
 
|1. Introduction to the workshop
 
|1. Introduction to the workshop
  
 
2. Go through detailed Agenda
 
2. Go through detailed Agenda
  
3. [http://tinyurl.com/pi221218 Participants information] and expectation
+
3. Expectation from participants
 
|Workshop page
 
|Workshop page
 
|-
 
|-
 
|2
 
|2
|Basic digital literacy
+
|Entering data and organising data
 
+
|1. Introduction to spreadsheet, navigating and interfaces. Cells (data element), rows (records), columns.
Entering data and organising data
 
|24/05/2023  12.00 – 1.30
 
|1. What is a computer? Introduction to spread sheet, navigating and interfaces. Cells (data element), rows (records), columns.
 
  
2. Types of data (text, numbers, date). Entering your data in spreadsheet and save / working with sample data from one study
+
2. Types of data (text, numbers, date). Entering your data in spreadsheet
  
 
3. Providing headings (columns)
 
3. Providing headings (columns)
Line 46: Line 35:
 
4. Formatting rows, columns, cells, and data
 
4. Formatting rows, columns, cells, and data
  
5. Adjusting rows and columns. Hiding and showing columns
+
5. Adjusting rows and columns.  
  
6. Working with alignment and text wrap. Header / Footer
+
6. Working with alignment and text wrap.  
  
 
7. Moving across sheet using CTRL keys
 
7. Moving across sheet using CTRL keys
 
|[https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc#Advanced_features LibreOffice Calc handout]
 
|[https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc#Advanced_features LibreOffice Calc handout]
 +
|-
 +
|
 +
| colspan="3" |
 
|-
 
|-
 
|3
 
|3
|Formatting our spreadsheet and make your data more meaningful
+
|Formatting our spreadsheet and make your data more meaningful
|25/05/2023 11.30 – 1.30
+
|1. Hiding and showing columns, Header / Footer
|1. Finding and replacing data, Freeze Panes
+
2. Finding and replacing data, Freeze Panes
  
2. Use some basic short cut keys to make your work fast
+
3. Use some basic short cut keys to make your work fast
  
3. Sorting, filtering the data
+
4. Sorting, filtering your entered data
  
4. Formatting Numbers like date, currency
+
5. Formatting Numbers like date, currency
  
5. Inserting, naming and deleting sheets
+
6. Inserting, naming and deleting sheets
  
6. Printing and sharing worksheets - with headers and footers
+
7. Printing and sharing worksheets - with headers and footers  
 +
 
 +
8. Understanding and using basic formulas and charts in spreadsheet
 
|
 
|
 
|-
 
|-
 
|
 
|
|05/06/2023
+
| colspan="3" |
|11:30-1:30
 
|
 
|
 
 
|-
 
|-
|3a
+
|4
|Understanding data from own study
+
|Understanding data from a research data
|
+
|Reading and understanding the data
|Discussing the data collected by students and learning how to enter into a spreadsheet
 
Exploring statistical functions using few statistical functions
 
 
|
 
|
 
|-
 
|-
|
+
|5
 
|Creating formulas and functions
 
|Creating formulas and functions
|
+
|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
 
  
2. Searching for formulas from the formula sections
+
2. Searching for formulas from the formula sections
  
 
3. Password-protecting worksheets and workbooks
 
3. Password-protecting worksheets and workbooks
  
4. Working with worksheets – move, copy, hiding worksheets
+
4. Working with worksheets – move, copy,hiding worksheets
 
|
 
|
 
|-
 
|-
|5
+
|
 +
| colspan="3" |
 +
|-
 +
|6
 
|Creating charts and Pivot Tables
 
|Creating charts and Pivot Tables
|3.30 – 4.30
+
|1. Using different charts in your spreadsheet
|1. Different types of charts
 
  
2. Use your data to create charts
+
2. Creating Pivot Tables
  
3. Use update Chart to customise your charts, labels
+
3. Modifying Pivot Table Data
  
4. Creating Pivot Tables
+
4. Use different statistical functions to generate reports
 
 
5. Modifying Pivot Table Data
 
 
|
 
|
 
|-
 
|-
|6
+
| colspan="4" |'''Open discussion'''
|Way forward
 
|4.30 – 5.00
 
|Expectations of students (complete data input before workshop 2), in spreadsheet.
 
 
 
Creating a telegram group for discussions and questions before workshop 2
 
|
 
|-
 
|
 
|'''DAY 2'''
 
|
 
|
 
|
 
|-
 
|1
 
|Data in sheets
 
|
 
|Checking students data entry in spreadsheets before analyses
 
|
 
|-
 
|2
 
|Single and multi variate tables
 
|10.00 - 1.00
 
|Working with data and use advance pivot table
 
|
 
|-
 
|2
 
|Statistics
 
|2.00 - 5.00
 
|Use different statistical functions to generate reports
 
|
 
 
|}
 
|}
  
Line 146: 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]]

Latest revision as of 07:25, 15 June 2023

Objectives

  1. Action research processes (Understanding data)
  2. Familiarity with spreadsheet (LibreOffice Calc)
  3. Learn to use spreadsheet to input data
  4. Analyse the data and prepare reports
  5. Input, tabulate, analyse and produce reports (includes pivots and chart)

Workshop Agenda

No Session name Session details Resources
1 Introduction to workshop 1. Introduction to the workshop

2. Go through detailed Agenda

3. Expectation from participants

Workshop page
2 Entering data and organising data 1. Introduction to spreadsheet, navigating and interfaces. Cells (data element), rows (records), columns.

2. Types of data (text, numbers, date). Entering your data in spreadsheet

3. Providing headings (columns)

4. Formatting rows, columns, cells, and data

5. Adjusting rows and columns.

6. Working with alignment and text wrap.

7. Moving across sheet using CTRL keys

LibreOffice Calc handout
3 Formatting our spreadsheet and make your data more meaningful 1. Hiding and showing columns, Header / Footer

2. Finding and replacing data, Freeze Panes

3. Use some basic short cut keys to make your work fast

4. Sorting, filtering your entered data

5. Formatting Numbers like date, currency

6. Inserting, naming and deleting sheets

7. Printing and sharing worksheets - with headers and footers

8. Understanding and using basic formulas and charts in spreadsheet

4 Understanding data from a research data Reading and understanding the data
5 Creating formulas and functions 1. Using basic operations – sum, subtraction,division and applying it to the research study

2. Searching for formulas from the formula sections

3. Password-protecting worksheets and workbooks

4. Working with worksheets – move, copy,hiding worksheets

6 Creating charts and Pivot Tables 1. Using different charts in your spreadsheet

2. Creating Pivot Tables

3. Modifying Pivot Table Data

4. Use different statistical functions to generate reports

Open discussion

Workshop resources

  1. LibreOffice Calc manual
  2. Video on using formula
  3. Spoken tutorials on Calc (English)

Practice sheet

Download practice sheet