Difference between revisions of "Workshop M.Ed students statistical analyses"
Gurumurthy (talk | contribs) |
Gurumurthy (talk | contribs) |
||
Line 10: | Line 10: | ||
=== Workshop Agenda === | === Workshop Agenda === | ||
− | |||
{| class="wikitable" | {| class="wikitable" | ||
− | | | + | |'''No''' |
− | |Session name | + | |'''Session name''' |
− | |Time | + | |'''Time''' |
− | |Session details | + | |'''Session details''' |
− | |Resources | + | |'''Resources''' |
|- | |- | ||
− | |||
| | | | ||
+ | |'''DAY 1''' | ||
| | | | ||
| | | | ||
Line 27: | Line 26: | ||
|Introduction to workshop | |Introduction to workshop | ||
|10.00 – 10.30 | |10.00 – 10.30 | ||
− | |1. Introduction to the workshop | + | |1. Introduction to the workshop |
+ | |||
2. Go through detailed Agenda | 2. Go through detailed Agenda | ||
− | 3. Participants expectation | + | 3. Participants information and expectation |
|Workshop page | |Workshop page | ||
|- | |- | ||
|2 | |2 | ||
− | |Entering data and organising data | + | |Basic digital literacy |
+ | |||
+ | Entering data and organising data | ||
|10.30 – 12.00 | |10.30 – 12.00 | ||
− | |1. Introduction to spread sheet, navigating and interfaces | + | |1. What is a computer? Introduction to spread sheet, navigating and interfaces. Cells (data element), rows (records), columns. |
− | 2. Entering your data in spreadsheet and save | + | |
+ | 2. Types of data (text, numbers, date). Entering your data in spreadsheet and save / working with sample data from one study | ||
− | 3. Providing headings | + | 3. Providing headings (columns) |
− | 4. Formatting rows, columns, cells, and data | + | 4. Formatting rows, columns, cells, and data |
− | 5. Adjusting rows and columns | + | 5. Adjusting rows and columns. Hiding and showing columns |
− | 6. Working with alignment and text wrap | + | 6. Working with alignment and text wrap. Header / Footer |
− | |||
+ | 7. Moving across sheet using CTRL keys | ||
+ | |LibreOffice calc handout | ||
|- | |- | ||
|3 | |3 | ||
− | |Formatting our spreadsheet and | + | |Formatting our spreadsheet and make your data more meaningful |
− | make your data more meaningful | ||
|12.00 – 1.30 | |12.00 – 1.30 | ||
|1. Finding and replacing data, Freeze Panes | |1. Finding and replacing data, Freeze Panes | ||
− | 2. Use some basic short cut keys to make your work fast | + | |
+ | 2. Use some basic short cut keys to make your work fast | ||
3. Sorting, filtering your entered data | 3. Sorting, filtering your entered data | ||
Line 62: | Line 66: | ||
5. Inserting, naming and deleting sheets | 5. Inserting, naming and deleting sheets | ||
− | 6. Printing and sharing worksheets - with headers and footers | + | 6. Printing and sharing worksheets - with headers and footers |
| | | | ||
|- | |- | ||
Line 72: | Line 76: | ||
|- | |- | ||
|4 | |4 | ||
− | |Creating formulas and functions | + | |Creating formulas and functions |
|2.15 – 3.30 | |2.15 – 3.30 | ||
− | |1. Using basic operations – sum, | + | |1. Using basic operations – sum, subtraction, division and applying it to the research study |
− | 2. Searching for formulas from the formula sections | + | |
+ | 2. Searching for formulas from the formula sections | ||
3. Password-protecting worksheets and workbooks | 3. Password-protecting worksheets and workbooks | ||
− | 4. Working with worksheets – move, copy, hiding worksheets | + | 4. Working with worksheets – move, copy, hiding worksheets |
| | | | ||
|- | |- | ||
|5 | |5 | ||
− | |Creating charts and | + | |Creating charts and Pivot Tables |
|3.30 – 4.30 | |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 | ||
− | 3. Use update Chart to customise your charts, labels | + | 3. Use update Chart to customise your charts, labels |
− | 4. Creating | + | 4. Creating Pivot Tables |
− | 5. Modifying | + | 5. Modifying Pivot Table Data |
| | | | ||
|- | |- | ||
Line 98: | Line 104: | ||
|Way forward | |Way forward | ||
|4.30 – 5.00 | |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''' | ||
| | | | ||
| | | | ||
Line 108: | Line 116: | ||
|- | |- | ||
|1 | |1 | ||
− | | | + | |Data in sheets |
+ | | | ||
+ | |Checking students data entry in spreadsheets before analyses | ||
+ | | | ||
+ | |- | ||
+ | |2 | ||
+ | |Single and multi variate tables | ||
|10.00 - 1.00 | |10.00 - 1.00 | ||
− | | | + | |Working with data and use advance pivot table |
| | | | ||
|- | |- | ||
|2 | |2 | ||
− | | | + | |Statistics |
|2.00 - 5.00 | |2.00 - 5.00 | ||
− | | | + | |Use different statistical functions to generate reports |
| | | | ||
|} | |} |
Revision as of 13:37, 21 December 2018
Objectives
- Basic digital literacy
- Familiarity with spreadsheet (LibreOffice Calc)
- Learn to use spreadsheet to input data collected from (M.Ed.) research
- Analyse the collected data and prepare reports using a test case
- Input, tabulate, analyse and produce reports for their M.Ed research project/assignment
Participant information
All participants fill participant information form here
Workshop Agenda
No | 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 information and expectation |
Workshop page |
2 | Basic digital literacy
Entering data and organising data |
10.30 – 12.00 | 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 | 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, 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
participants feedback
Please enter your feedback on the workshop in this form