Difference between revisions of "Workshop M.Ed students statistical analyses"

From Karnataka Open Educational Resources
Jump to: navigation, search
(Created page with "Objectives 1. basic DL (for those who have not used computers before) 2. to help BU MEd students to learn how to use spreadsheet to input data collected from research, analyse...")
 
Line 1: Line 1:
Objectives
+
=== Objectives ===
1. basic DL (for those who have not used computers before)
+
1. Basic Digital Literacy (for those who have not used computers before)
2. to help BU MEd students to learn how to use spreadsheet to input data collected from research, analyse it and produce reports
+
 
3. actually input, tabulate, analyse and produce reports for their M.Ed research project/assignment
+
2. To help MEd students to learn how to use spreadsheet to input data collected from research
Participant information
+
 
Workshop Agenda
+
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
 +
 
 +
=== Participant information ===
 +
 
 +
=== Workshop Agenda ===
 +
{| class="wikitable"
 +
|
 +
|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
 +
|Working with the
 +
|10.30 – 11.00
 +
|
 +
|
 +
|-
 +
|3
 +
|Entering data and organising data
 +
|11.00 – 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
 +
|
 +
|-
 +
|5
 +
|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.00
 +
|
 +
|
 +
|-
 +
|6
 +
|Creating formulas and functions
 +
|2.00 – 3.00
 +
|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
 +
|
 +
|-
 +
|7
 +
|Creating charts and PivotTables
 +
|3.00 – 4.00
 +
|1. Different types of charts
 +
2. Use your data to create charts
 +
3. Use update Chart to customise your charts, labels
 +
4. Creating PivotTables
 +
6. Modifying PivotTable Data
 +
|
 +
|-
 +
|8
 +
|Way forward
 +
|4.00 – 5.00
 +
|
 +
|
 +
|-
 +
|DAY 2
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|Working with data and use pivote table
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}

Revision as of 10:26, 17 December 2018

Objectives

1. Basic Digital Literacy (for those who have not used computers before)

2. To help MEd 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

Participant information

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 Working with the 10.30 – 11.00
3 Entering data and organising data 11.00 – 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

5 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.00
6 Creating formulas and functions 2.00 – 3.00 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

7 Creating charts and PivotTables 3.00 – 4.00 1. Different types of charts

2. Use your data to create charts 3. Use update Chart to customise your charts, labels 4. Creating PivotTables 6. Modifying PivotTable Data

8 Way forward 4.00 – 5.00
DAY 2
Working with data and use pivote table