Difference between revisions of "ICT student textbook/Columns and rows!"

From Open Educational Resources
Jump to navigation Jump to search
Line 26: Line 26:
  
 
=Digital skills=
 
=Digital skills=
#Working with spreadsheets
+
#[[Learn LibreOffice Calc|Working with spreadsheets]]
#Making plots and graphs
+
#[[Learn LibreOffice Calc|Making plots and graphs]]
  
 
=Description of activity with detailed steps=
 
=Description of activity with detailed steps=

Revision as of 14:12, 18 October 2016

ICT student textbook
Numbers and patterns Columns and rows! Inferences from plots and graphs

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