Workshop M.Ed students statistical analyses

Objectives

1. Basic digital literacy
2. Familiarity with spreadsheet (LibreOffice Calc)
3. Learn to use spreadsheet to input data collected from (M.Ed.) research
4. Analyse the collected data and prepare reports using a test case
5. Input, tabulate, analyse and produce reports for their M.Ed research project/assignment

Participant information

All participants fill participant information form here

Workshop Agenda

	Session name	Time	Session details	Resources
DAY 1
1	Introduction to workshop	10.00 – 10.30	1. Introduction to the workshop 2. Go through detailed Agenda 3. Participants expectation	Workshop page
2	Entering data and organising data	10.30 – 12.00	1. Introduction to spread sheet, navigating and interfaces 2. Entering your data in spreadsheet and save 3. Providing headings to the date 4. Formatting rows, columns, cells, and data 5. Adjusting rows and columns 6. Working with alignment and text wrap	LibreOffice calc handout
3	Formatting our spreadsheet and make your data more meaningful	12.00 – 1.30	1. Finding and replacing data, Freeze Panes 2. Use some basic short cut keys to make your work fast 3. Sorting, filtering your entered data 4. Formatting Numbers like date, currency 5. Inserting, naming and deleting sheets 6. Printing and sharing worksheets - with headers and footers
	LUNCH	1.30 – 2.15
4	Creating formulas and functions	2.15 – 3.30	1. Using basic operations – sum, substraction, division 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 PivotTables	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 PivotTables 5. Modifying PivotTable Data
6	Way forward	4.30 – 5.00
DAY 2
1	Working with data and use advance pivote table	10.00 - 1.00
2	Use different statistical functions to generate reports	2.00 - 5.00

Workshop resources

1. LibreOffice Calc manual
2. Video on using formula

participants feedback

Please enter your feedback on the workshop in this form