Difference between revisions of "Workshop M.Ed students statistical analyses"
Line 65: | Line 65: | ||
| | | | ||
|LUNCH | |LUNCH | ||
− | |1.30 – 2. | + | |1.30 – 2.15 |
| | | | ||
| | | | ||
Line 71: | Line 71: | ||
|4 | |4 | ||
|Creating formulas and functions | |Creating formulas and functions | ||
− | |2. | + | |2.15 – 3.30 |
|1. Using basic operations – sum, substraction, division | |1. Using basic operations – sum, substraction, division | ||
2. Searching for formulas from the formula sections | 2. Searching for formulas from the formula sections | ||
Line 82: | Line 82: | ||
|5 | |5 | ||
|Creating charts and PivotTables | |Creating charts and PivotTables | ||
− | |3. | + | |3.30 – 4.30 |
|1. Different types of charts | |1. Different types of charts | ||
2. Use your data to create charts | 2. Use your data to create charts | ||
Line 89: | Line 89: | ||
4. Creating PivotTables | 4. Creating PivotTables | ||
− | + | ||
+ | 5. Modifying PivotTable Data | ||
| | | | ||
|- | |- | ||
|6 | |6 | ||
|Way forward | |Way forward | ||
− | |4. | + | |4.30 – 5.00 |
| | | | ||
| | | |
Revision as of 07:43, 20 December 2018
Objectives
1. Basic Digital Literacy for the students who have not used computers before
2. To help M.Ed students to learn how to use spreadsheet to input data collected from research
4. Learn how to analyse the collected data and produce reports
3. Actually input, tabulate, analyse and produce reports for their M.Ed research project/assignment
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
participants feedback
Please enter your feedback on the workshop in this form