Difference between revisions of "Workshop for ITEP students on statistical analyses"
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...") |
|||
| Line 5: | Line 5: | ||
# Analyse the collected data and prepare reports using a test case | # Analyse the collected data and prepare reports using a test case | ||
# Input, tabulate, analyse and produce reports for their B.Ed research project | # Input, tabulate, analyse and produce reports for their B.Ed research project | ||
| − | |||
| − | |||
| − | |||
=== Workshop Agenda === | === Workshop Agenda === | ||
| Line 18: | Line 15: | ||
|- | |- | ||
| | | | ||
| − | |'''DAY 1''' | + | | colspan="4" |'''DAY 1 - 24/05/2023''' |
| − | |||
| − | |||
| − | |||
|- | |- | ||
|1 | |1 | ||
| Line 30: | Line 24: | ||
2. Go through detailed Agenda | 2. Go through detailed Agenda | ||
| − | 3. | + | 3. Expectation from participants |
|Workshop page | |Workshop page | ||
|- | |- | ||
|2 | |2 | ||
| − | | | + | |Entering data and organising data |
| + | |12.00 – 1.30 | ||
| + | |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 | |
| − | |||
| − | |||
| − | |||
| − | 2. Types of data (text, numbers, date). | ||
3. Providing headings (columns) | 3. Providing headings (columns) | ||
| Line 46: | Line 38: | ||
4. Formatting rows, columns, cells, and data | 4. Formatting rows, columns, cells, and data | ||
| − | 5. Adjusting rows and columns. | + | 5. Adjusting rows and columns. |
| − | 6. Working with alignment and text wrap. | + | 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="4" |'''DAY 2 - 25/05/2023''' | ||
|- | |- | ||
|3 | |3 | ||
| − | |Formatting our spreadsheet and make your data | + | |Formatting our spreadsheet and make your data more meaningful |
| − | | | + | |11.30 – 1.30 |
| − | |1. Finding and replacing data, Freeze Panes | + | |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 | |
| | | | ||
|- | |- | ||
| | | | ||
| − | |05/06/2023 | + | | colspan="4" |'''DAY 3 - 05/06/2023''' |
| − | |||
| − | |||
| − | |||
|- | |- | ||
| − | | | + | |4 |
| − | |Understanding data from | + | |Understanding data from a research data |
| − | | | + | |11:30-12:00 |
| − | | | + | |Reading and understanding the data |
| − | |||
| | | | ||
|- | |- | ||
| − | | | + | |5 |
|Creating formulas and functions | |Creating formulas and functions | ||
| − | | | + | |12:00-1:30 |
| − | |1. Using basic operations – sum, subtraction, | + | |1. Using basic operations – sum, subtraction,division and applying it to the research study |
| − | 2. Searching for formulas from the formula | + | 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, | + | 4. Working with worksheets – move, copy,hiding worksheets |
| | | | ||
| + | |- | ||
| + | | | ||
| + | | colspan="4" |'''DAY 4 - 06/06/2023''' | ||
|- | |- | ||
|5 | |5 | ||
|Creating charts and Pivot Tables | |Creating charts and Pivot Tables | ||
| − | | | + | |11.30 – 1.30 |
| − | |1. | + | |1. Using different charts in your spreadsheet |
| − | |||
| − | |||
| − | + | 2. Creating Pivot Tables | |
| − | + | 3. Modifying Pivot Table Data | |
| − | + | 4. Use different statistical functions to generate reports | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
|} | |} | ||
Revision as of 05:00, 24 May 2023
Objectives
- Basic digital literacy
- Familiarity with spreadsheet (LibreOffice Calc)
- Learn to use spreadsheet to input data collected from (B.Ed.) research
- Analyse the collected data and prepare reports using a test case
- Input, tabulate, analyse and produce reports for their B.Ed research project
Workshop Agenda
| No | Session name | Time | Session details | Resources |
| DAY 1 - 24/05/2023 | ||||
| 1 | Introduction to workshop | 11.30 – 12.00 | 1. Introduction to the workshop
2. Go through detailed Agenda 3. Expectation from participants |
Workshop page |
| 2 | Entering data and organising data | 12.00 – 1.30 | 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 |
| DAY 2 - 25/05/2023 | ||||
| 3 | Formatting our spreadsheet and make your data more meaningful | 11.30 – 1.30 | 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 |
|
| DAY 3 - 05/06/2023 | ||||
| 4 | Understanding data from a research data | 11:30-12:00 | Reading and understanding the data | |
| 5 | Creating formulas and functions | 12:00-1:30 | 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 |
|
| DAY 4 - 06/06/2023 | ||||
| 5 | Creating charts and Pivot Tables | 11.30 – 1.30 | 1. Using different charts in your spreadsheet
2. Creating Pivot Tables 3. Modifying Pivot Table Data 4. Use different statistical functions to generate reports |
|
Workshop resources
- LibreOffice Calc manual
- Video on using formula
- Spoken tutorials on Calc (English)
Participants feedback
Please enter your feedback on the workshop in this form