Difference between revisions of "ICT student textbook/Columns and rows!"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
=Objectives= | =Objectives= | ||
| − | # | + | #Learning data input with spreadsheet |
| − | # | + | #Data analysis and summary with spreadsheets |
| − | # | + | #Make plots and charts |
| − | |||
=What prior skills are assumed= | =What prior skills are assumed= | ||
| − | # | + | #Level 1 skills |
# | # | ||
# | # | ||
| Line 27: | Line 26: | ||
=Digital skills= | =Digital skills= | ||
| − | # | + | #Working with spreadsheets |
| − | # | + | #Making plots and graphs |
| − | |||
| − | |||
=Description of activity with detailed steps= | =Description of activity with detailed steps= | ||
==Teacher led activity== | ==Teacher led activity== | ||
| − | # | + | #Your teacher will demonstrate input of data with spreadsheet (Rainfall data) |
| − | # | + | #Discuss with your teacher what meaningful measures of data can be calculated |
| − | # | + | #Discuss what kinds of graphs can be meaningful to generate and draw the plots |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Student activities== | ==Student activities== | ||
| + | For different data sets, enter the data and make plots and graphs. | ||
=Portfolio= | =Portfolio= | ||
| − | # | + | #Data sets |
| − | # | + | #Spreadsheets with analysis |
| − | |||
Revision as of 11:14, 17 October 2016
Columns and Rows! -Introducing spreadsheet
Objectives
- Learning data input with spreadsheet
- Data analysis and summary with spreadsheets
- Make plots and charts
What prior skills are assumed
- Level 1 skills
Resources needed
Hardware, software, Files
- Student generated data sets
- Secondary data sets
Digital skills
- Working with spreadsheets
- Making plots and graphs
Description of activity with detailed steps
Teacher led activity
- Your teacher will demonstrate input of data with spreadsheet (Rainfall data)
- Discuss with your teacher what meaningful measures of data can be calculated
- Discuss what kinds of graphs can be meaningful to generate and draw the plots
Student activities
For different data sets, enter the data and make plots and graphs.
Portfolio
- Data sets
- Spreadsheets with analysis