Workshop for ITEP students on statistical analyses

Objectives

1. Basic digital literacy
2. Familiarity with spreadsheet (LibreOffice Calc)
3. Learn to use spreadsheet to input data collected from (B.Ed.) research
4. Analyse the collected data and prepare reports using a test case
5. 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

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

Participants feedback

Please enter your feedback on the workshop in this form