1,774
edits
Changes
From Open Educational Resources
ICT student textbook/Columns and rows! (view source)
Revision as of 02:57, 22 November 2016
, 02:57, 22 November 2016no edit summary
{{Navigate|Prev=Numbers and patterns|Curr=Columns and rows!|Next=Inferences from plots and graphs}}
{{Navigate|Prev=Numbers and patterns|Curr=Columns and rows!|Next=Numbers_and_patterns}}
'''Columns and Rows! -Introducing spreadsheet'''
'''Columns and Rows! -Introducing spreadsheet'''
<div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;">
<div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;">
|}</div>
|}</div>
=Objectives=
===Objectives===
#Learning data input with spreadsheet
#Learning data input with spreadsheet
#Data analysis and summary with spreadsheets
#Data analysis and summary with spreadsheets
#Make plots and charts
#Make plots and charts
=What prior skills are assumed=
===What prior skills are assumed===
#Level 1 skills
#Familiarity with ICT environment
#Understanding of data organization
#
#Keyboard input
#
===Resources needed ===
=Resources needed =
#Computer lab with projection equipment
#Student generated data sets
#Student generated data sets
#Secondary data sets
#Secondary data sets
#
#Handout for [[Learn LibreOffice Calc|LibreOffice Calc]]
#
#Handout for [[Learn LibreOffice Writer|LibreOffice Writer]]
===Digital skills===
=Digital skills=
#[[Learn LibreOffice Calc|Working with spreadsheets]]
#[[Learn LibreOffice Calc|Working with spreadsheets]]
#[[Learn LibreOffice Calc|Making plots and graphs]]
#[[Learn LibreOffice Calc|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)
#Your teacher will demonstrate input of data with spreadsheet
#Discuss with your teacher what meaningful measures of data can be calculated
#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
#Your teacher will plot different graphs and discuss how different kinds of graphs can be meaningful
==Student activities==
{{font color|purple|'''sample spreadsheet will be added - show offline'''}}
====Student activities====
=Portfolio=
===Portfolio===
#Data sets
#Data sets
#Spreadsheets with analysis
#Spreadsheets with analysis
