Difference between revisions of "Workshop for ITEP students on statistical analyses"
| Line 10: | Line 10: | ||
|'''No''' | |'''No''' | ||
|'''Session name''' | |'''Session name''' | ||
| − | |||
|'''Session details''' | |'''Session details''' | ||
|'''Resources''' | |'''Resources''' | ||
|- | |- | ||
| | | | ||
| − | | colspan=" | + | | colspan="3" | |
|- | |- | ||
|1 | |1 | ||
|Introduction to workshop | |Introduction to workshop | ||
| − | |||
|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 | ||
| − | |||
|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=" | + | | colspan="3" | |
|- | |- | ||
|3 | |3 | ||
|Formatting our spreadsheet and make your data more meaningful | |Formatting our spreadsheet and make your data more meaningful | ||
| − | |||
|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=" | + | | colspan="3" | |
|- | |- | ||
|4 | |4 | ||
|Understanding data from a research data | |Understanding data from a research data | ||
| − | |||
|Reading and understanding the data | |Reading and understanding the data | ||
| | | | ||
| Line 78: | Line 73: | ||
|5 | |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 | ||
| Line 89: | Line 83: | ||
|- | |- | ||
| | | | ||
| − | | colspan=" | + | | colspan="3" | |
|- | |- | ||
|6 | |6 | ||
|Creating charts and Pivot Tables | |Creating charts and Pivot Tables | ||
| − | |||
|1. Using different charts in your spreadsheet | |1. Using different charts in your spreadsheet | ||
| Line 103: | Line 96: | ||
| | | | ||
|- | |- | ||
| − | | | + | | colspan="4" |'''Open discussion''' |
| − | |'''Open discussion''' | ||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Revision as of 07:12, 15 June 2023
Objectives
- Action research processes (Understanding data)
- Familiarity with spreadsheet (LibreOffice Calc)
- Learn to use spreadsheet to input data
- Analyse the data and prepare reports
- 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
- LibreOffice Calc manual
- Video on using formula
- Spoken tutorials on Calc (English)
Practice sheet
Participants feedback
Please enter your feedback on the workshop in this form