Difference between revisions of "ICT student textbook/Numbers and patterns"

From Open Educational Resources
Jump to navigation Jump to search
Line 1: Line 1:
{{Navigate|Prev=Data representation and processing level 2|Curr=Numbers and patterns|Next=Columns and rows!}}
+
{{Navigate|Prev=Data representation and processing level 2|Curr=Numbers and patterns|Next=Text document with data analysis}}
 
'''Title of Activity'''
 
'''Title of Activity'''
 
<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===
 
#Understanding that numbers are data; they are data and they represent data
 
#Understanding that numbers are data; they are data and they represent data
 
#Working with spreadsheet to decode number patterns
 
#Working with spreadsheet to decode number patterns
 
#Working with spreadsheet to create number patterns
 
#Working with spreadsheet to create number patterns
  
=What prior skills are assumed=
+
===What prior skills are assumed===
 
#Familiarity with the ICT environment and various applications
 
#Familiarity with the ICT environment and various applications
 
#Comfort with data input methods
 
#Comfort with data input methods
=Resources needed =
+
#Entry into spreadsheets
'''Hardware, software, Files'''
+
===Resources needed ===
#Data sets created by the students
+
#Computer lab with projection equipment
#[[Learn LibreOffice Calc]]
+
#Number patterns worksheets (for students to explore, create)
#[[Learn LibreOffice Writer]]
+
#Handout for [[Learn LibreOffice Calc|LibreOffice Calc]]
 +
#Handout for [[Learn LibreOffice Writer|LibreOffice Writer]]
  
=Digital skills=
+
===Digital skills===
#Working with spreadsheets for analysis
+
#Working with spreadsheets for entering numbers
#Summarizing using text document
+
#Getting familiar with simple operations in a spreadsheet
#Inserting numeric data tables into a text document
 
  
=Description of activity with detailed steps=
+
===Description of activity with detailed steps===
==Teacher led activity==
+
====Teacher led activity====
#Number Patterns to be introduced
+
#Your teacher will show you the spreadsheet with some numbers
==Student activities==
+
#She will demonstrate how you can use the spreadsheet to understand a pattern
# Students to generate patterns with numbers
+
#She will show you how to create a given pattern
 +
====Student activities====
 +
#Individual spreadsheet patterns – Your teacher will give you some sheets for number patterns, you can create them with the spreadsheet
 +
#Group activities – Did you ever imagine a calendar can be so much fun?  In groups, create the patterns in the spreadsheet. 
  
=Portfolio=
+
===Portfolio===
#Spreadsheets created by students
+
#Your own number patterns with spreadsheets!
#
 
#
 

Revision as of 08:21, 22 November 2016

ICT student textbook
Data representation and processing level 2 Numbers and patterns Text document with data analysis

Title of Activity

Objectives

  1. Understanding that numbers are data; they are data and they represent data
  2. Working with spreadsheet to decode number patterns
  3. Working with spreadsheet to create number patterns

What prior skills are assumed

  1. Familiarity with the ICT environment and various applications
  2. Comfort with data input methods
  3. Entry into spreadsheets

Resources needed

  1. Computer lab with projection equipment
  2. Number patterns worksheets (for students to explore, create)
  3. Handout for LibreOffice Calc
  4. Handout for LibreOffice Writer

Digital skills

  1. Working with spreadsheets for entering numbers
  2. Getting familiar with simple operations in a spreadsheet

Description of activity with detailed steps

Teacher led activity

  1. Your teacher will show you the spreadsheet with some numbers
  2. She will demonstrate how you can use the spreadsheet to understand a pattern
  3. She will show you how to create a given pattern

Student activities

  1. Individual spreadsheet patterns – Your teacher will give you some sheets for number patterns, you can create them with the spreadsheet
  2. Group activities – Did you ever imagine a calendar can be so much fun? In groups, create the patterns in the spreadsheet.

Portfolio

  1. Your own number patterns with spreadsheets!