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 |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |} |