ICT student textbook/Columns and rows!

Columns and Rows! -Introducing spreadsheet

Objectives

1. Learning data input with spreadsheet
2. Data analysis and summary with spreadsheets
3. Make plots and charts

What prior skills are assumed

1. Level 1 skills

Resources needed

Hardware, software, Files

1. Student generated data sets
2. Secondary data sets

Digital skills

1. Working with spreadsheets
2. Making plots and graphs

Description of activity with detailed steps

Teacher led activity

1. Your teacher will demonstrate input of data with spreadsheet (Rainfall data)
2. Discuss with your teacher what meaningful measures of data can be calculated
3. 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

1. Data sets
2. Spreadsheets with analysis