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

Participant information

All participants fill participant information form here

Workshop Agenda

No	Session name	Time	Session details	Resources
	DAY 1
1	Introduction to workshop	11.30 – 12.00	1. Introduction to the workshop 2. Go through detailed Agenda 3. Participants information and expectation	Workshop page
2	Basic digital literacy 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 3. Providing headings (columns) 4. Formatting rows, columns, cells, and data 5. Adjusting rows and columns. Hiding and showing columns 6. Working with alignment and text wrap. Header / Footer 7. Moving across sheet using CTRL keys	LibreOffice Calc handout
3	Formatting our spreadsheet and make your data more meaningful	25/05/2023 11.30 – 1.30	1. Finding and replacing data, Freeze Panes 2. Use some basic short cut keys to make your work fast 3. Sorting, filtering the data 4. Formatting Numbers like date, currency 5. Inserting, naming and deleting sheets 6. Printing and sharing worksheets - with headers and footers
	05/06/2023	11:30-1:30
3a	Understanding data from own study		Discussing the data collected by students and learning how to enter into a spreadsheet Exploring statistical functions using few statistical functions
	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
5	Creating charts and Pivot Tables	3.30 – 4.30	1. Different types of charts 2. Use your data to create charts 3. Use update Chart to customise your charts, labels 4. Creating Pivot Tables 5. Modifying Pivot Table Data
6	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

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