Difference between revisions of "ICT student textbook/Columns and rows!"
Jump to navigation
Jump to search
m (→Digital skills) |
|||
Line 1: | Line 1: | ||
− | {{Navigate|Prev=Numbers and patterns|Curr=Columns and rows!|Next= | + | {{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=== |
− | # | + | #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 | + | #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 | ||
− | # | + | #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 |
Revision as of 02:57, 22 November 2016
Columns and Rows! -Introducing spreadsheet
Objectives
- Learning data input with spreadsheet
- Data analysis and summary with spreadsheets
- Make plots and charts
What prior skills are assumed
- Familiarity with ICT environment
- Understanding of data organization
- Keyboard input
Resources needed
- Computer lab with projection equipment
- Student generated data sets
- Secondary data sets
- Handout for LibreOffice Calc
- Handout for LibreOffice Writer
Digital skills
Description of activity with detailed steps
Teacher led activity
- Your teacher will demonstrate input of data with spreadsheet
- Discuss with your teacher what meaningful measures of data can be calculated
- 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
- Data sets
- Spreadsheets with analysis