ICT student textbook/Columns and rows!

From Open Educational Resources
Revision as of 03:32, 22 November 2016 by Ranjani (talk | contribs)
Jump to navigation Jump to search
ICT student textbook
Data representation and processing level 2 Columns and rows! Numbers and patterns

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. Familiarity with ICT environment
  2. Understanding of data organization
  3. Keyboard input

Resources needed

  1. Computer lab with projection equipment
  2. Student generated data sets
  3. Secondary data sets
  4. Handout for LibreOffice Calc
  5. Handout for LibreOffice Writer

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
  2. Discuss with your teacher what meaningful measures of data can be calculated
  3. Your teacher will plot different graphs and discuss how different kinds of graphs can be meaningful

sample spreadsheet will be added - show offline

Student activities

Portfolio

  1. Data sets
  2. Spreadsheets with analysis