RIESI, Bureaucrats, Administrators
2,852
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − 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 − + − + − + − + − + − |DAY 1 + Line 25:
Line 26: − + + − + − + − |10.30 – 11.00+ − |+ − |+ − |-+ − |3+ − |Entering data and organising data+ − + − + − − 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+ − + − + − + − − + + Line 65:
Line 66: − + − + + + + + + + + − + − + − + − + − + + − + − + − + − + − + + − + + + − 4. Creating PivotTables + − 6. Modifying PivotTable Data − + − + − + + + − |DAY 2 + Line 110:
Line 123: − + + + + + + + − + − + − + Line 124:
Line 143: + + − + − +
Workshop M.Ed students statistical analyses (view source)
Revision as of 16:38, 21 December 2018
, 16:38, 21 December 2018→Workshop Agenda
=== Objectives ===
=== 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
=== Participant information ===
All participants fill participant information form [http://tinyurl.com/pi221218 here]
=== Workshop Agenda ===
=== Workshop Agenda ===
{| class="wikitable"
{| class="wikitable"
|
|'''No'''
|Session name
|'''Session name'''
|Time
|'''Time'''
|Session details
|'''Session details'''
|Resources
|'''Resources'''
|-
|-
|
|
|'''DAY 1'''
|
|
|
|
|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. [http://tinyurl.com/pi221218 Participants information] and expectation
|Workshop page
|Workshop page
|-
|-
|2
|2
|Working with the
|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
|11.00 – 12.00
|1. Introduction to spread sheet, navigating and interfaces
3. Providing headings (columns)
2. Entering your data in spreadsheet and save
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
|[https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc#Advanced_features LibreOffice calc handout]
|[https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc#Advanced_features LibreOffice Calc handout]
|-
|-
|5
|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
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
|
|
|-
|-
|
|
|LUNCH
|LUNCH
|1.30 – 2.00
|1.30 – 2
|
|
|
|-
|3a
|Understanding data from own study
|2 - 3
|Discussing the data collected by students and learning how to enter into a spreadsheet
Exploring statistical functions using few statistical functions
|
|
|-
|-
|6
|4
|Creating formulas and functions
|Creating formulas and functions
|2.00 – 3.00
|3 – 3.30
|1. Using basic operations – sum, substraction, division
|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
|
|
|-
|-
|7
|5
|Creating charts and PivotTables
|Creating charts and Pivot Tables
|3.00 – 4.00
|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 Pivot Tables
5. Modifying Pivot Table Data
|
|
|-
|-
|8
|6
|Way forward
|Way forward
|4.00 – 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'''
|
|
|
|
|-
|-
|1
|1
|Working with data and use advance pivote table
|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
|Use different statistical functions to generate reports
|Statistics
|2.00 - 5.00
|2.00 - 5.00
|
|Use different statistical functions to generate reports
|
|
|}
|}
=== Workshop resources ===
=== Workshop resources ===
# [https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc LibreOffice Calc manual]
# [https://teacher-network.in/OER/index.php/Learn_LibreOffice_Calc LibreOffice Calc manual]
# [https://www.youtube.com/watch?v=9VSdwWRrx8k Video on using formula]
# Spoken tutorials on Calc ([https://spoken-tutorial.org/tutorial-search/?search_foss=LibreOffice+Calc+on+BOSS+Linux&search_language=English English])
=== participants feedback ===
=== Participants feedback ===
Please enter your feedback on the workshop in this form
Please enter your [https://docs.google.com/forms/d/e/1FAIpQLSeousH-96fATVWd29d-baALsFSrs79Dp-mY5PSLmbhAstqvfQ/viewform feedback on the workshop in this form]
[[Category:Workshop]]
[[Category:Workshop]]