Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1: −
{{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;">
Line 7: Line 7:  
|}</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
'''Hardware, software, Files'''
   
#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'''}}
For different data sets, enter the data and make plots and graphs.
+
====Student activities====
 +
 
   −
=Portfolio=
+
===Portfolio===
 
#Data sets  
 
#Data sets  
 
#Spreadsheets with analysis
 
#Spreadsheets with analysis

Navigation menu