SOW+4th+Grade

Framework for Unit Plan

Children learn to enter numbers, labels and simple formulae into a spreadsheet and to use the data to calculate totals |||||||||| Essential Questions: Can children understand what a spreadsheet grid is? Can children understand what a formula is? || Enter text and numbers to produce tables, calculations and charts. || Use a spreadsheet to produce a table of data. |||||||| **Should**: Use a spreadsheet to carry out calculations. |||||| **Could**: Use a spreadsheet to carry out calculations; explore the effects of changing the data in a spreadsheet. || Identified in each lesson. || Math and Geography ||  Reinforcement
 * Subject/ Curriculum Area: ICT |||||||||||| Theme/Topic: Introduction to spreadsheets ||
 * <span style="font-family: Verdana,sans-serif;">Grade/Group: 4th Grade |||||||||||| <span style="font-family: Verdana,sans-serif;">Time frame: Cal 1 ||
 * <span style="font-family: Verdana,sans-serif;">1 |||||| Main Idea:
 * <span style="font-family: Verdana,sans-serif;">2 |||||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Learning Intentions: (To Understand, be able to do and to know plus attitudes to encourage)
 * <span style="font-family: Verdana,sans-serif;">3 |||||||||||||||| <span style="font-family: Verdana,sans-serif;">QCA Learning Intentions Differentiated: ||
 * || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">**Must**:
 * <span style="font-family: Verdana,sans-serif;">4 |||||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Assessment: || <span style="font-family: Verdana,sans-serif; font-size: 8pt;">Enter Numbers || <span style="font-family: Verdana,sans-serif; font-size: 8pt;">Create Table || <span style="font-family: Verdana,sans-serif; font-size: 8pt;">Calculate Totals || <span style="font-family: Verdana,sans-serif; font-size: 8pt;">Format Data || <span style="font-family: Verdana,sans-serif; font-size: 8pt;">Create Graphs || <span style="font-family: Verdana,sans-serif; font-size: 8pt;">Carry out advance calculations ||
 * <span style="display: block; font-family: Verdana,sans-serif; font-size: 8pt; text-align: center;">1 || <span style="display: block; font-family: Verdana,sans-serif; font-size: 8pt; text-align: center;">1 || <span style="display: block; font-family: Verdana,sans-serif; font-size: 8pt; text-align: center;">2 || <span style="display: block; font-family: Verdana,sans-serif; font-size: 8pt; text-align: center;">2 || <span style="display: block; font-family: Verdana,sans-serif; font-size: 8pt; text-align: center;">2 || <span style="display: block; font-family: Verdana,sans-serif; font-size: 8pt; text-align: center;">2 ||  ||
 * <span style="font-family: Verdana,sans-serif;">5 |||||||||||||||| <span style="font-family: Verdana,sans-serif;">Learning activities:
 * |||||||| Learning about learning opportunities: |||| <span style="font-family: Verdana,sans-serif;">Language focus:
 * <span style="font-family: Verdana,sans-serif;">spreadsheet
 * <span style="font-family: Verdana,sans-serif;">cell
 * <span style="font-family: Verdana,sans-serif;">formula
 * <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Sigma
 * <span style="font-family: Verdana,sans-serif;">sum
 * <span style="font-family: Verdana,sans-serif;">calculate |||| <span style="font-family: Verdana,sans-serif;">Cross-curricular links:
 * |||||||| <span style="font-family: Verdana,sans-serif;">Code:

<span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #00ff00 none repeat scroll 0% 0%;"> <span style="font-family: Verdana,sans-serif;">Challenge |||| <span style="font-family: Verdana,sans-serif;">Material and info sources: MS Excel |||| <span style="font-family: Verdana,sans-serif;">Ideas for celebration of learning & display: Public recognition of their piece of work Print and display || <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #00ff00 none repeat scroll 0% 0%;"> <span style="font-family: Verdana,sans-serif;">Format data. <span style="font-family: Verdana,sans-serif;"> ||  || <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #ffff00 none repeat scroll 0% 0%;"> <span style="font-family: Verdana,sans-serif;">Personal discussion. <span style="font-family: Verdana,sans-serif;"> <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #00ff00 none repeat scroll 0% 0%;">  <span style="font-family: Verdana,sans-serif;">Analyse data. <span style="font-family: Verdana,sans-serif;"> || || <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #00ff00 none repeat scroll 0% 0%;">  <span style="font-family: Verdana,sans-serif;">Analyse data. <span style="font-family: Verdana,sans-serif;"> ||  || <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #ffff00 none repeat scroll 0% 0%;"> <span style="font-family: Verdana,sans-serif;">Personal modelling. <span style="font-family: Verdana,sans-serif;"> ||  ||
 * <span style="font-family: Verdana,sans-serif;">Week 1 + 2 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Save a file in MS Excel. Recognize rows and columns. Enter numbers to add/subtract in different ways. Create a table. Rename sheets. ||   ||
 * <span style="font-family: Verdana,sans-serif;">Week 3+4 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Save a file in MS Excel. Children will create their own touristic table with information provided by the teacher. Enter country, categories, prices and format table.
 * <span style="font-family: Verdana,sans-serif;">Week 5 +6 |||||||||||||| <span style="font-family: Verdana,sans-serif;">Analyse data. Calculate the totals in different ways. Rename sheet as Total Expenses. Copy/paste table and carry out advanced calculations. Rename sheet as calculations.
 * <span style="font-family: Verdana,sans-serif;">Week 7+8 |||||||||||||| <span style="font-family: Verdana,sans-serif;">Children will create graphs to find out which of the countries is the least/most expensive to travel.
 * <span style="font-family: Verdana,sans-serif;">Week 9+10 |||||||||||||| <span style="font-family: Verdana,sans-serif;">Add borders to table, landscape. Decide which country they are going to visit and insert pictures of the country. Add WordArt. Print

▪ <span style="font-family: Verdana,sans-serif;">save a file ▪ <span style="font-family: Verdana,sans-serif;">enter numbers ▪ <span style="font-family: Verdana,sans-serif;">create a table || <span style="font-family: Verdana,sans-serif;">Student can (with help) ▪ <span style="font-family: Verdana,sans-serif;">create a table ▪ <span style="font-family: Verdana,sans-serif;">calculate totals || <span style="font-family: Verdana,sans-serif;">Student can (with some help) ▪ <span style="font-family: Verdana,sans-serif;">create a table ▪ <span style="font-family: Verdana,sans-serif;">calculate totals ▪ <span style="font-family: Verdana,sans-serif;">format data || <span style="font-family: Verdana,sans-serif;">Student can (with some help) ▪ <span style="font-family: Verdana,sans-serif;">create a table ▪ <span style="font-family: Verdana,sans-serif;">calculate totals ▪ <span style="font-family: Verdana,sans-serif;">format data ▪ <span style="font-family: Verdana,sans-serif;">analyse numbers || ▪ <span style="font-family: Verdana,sans-serif;">create a table ▪ <span style="font-family: Verdana,sans-serif;">carry out advanced calculations ▪ <span style="font-family: Verdana,sans-serif;">format data ▪ <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">analyse data. ||  ||   ||   || Version:1.0 StartHTML:0000000167 EndHTML:0000019410 StartFragment:0000000613 EndFragment:0000019394 <span style="font-family: Verdana,sans-serif;">Framework for Unit Plan
 * <span style="display: block; font-family: Verdana,sans-serif; text-align: center;">**Rubric** ||
 * <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Unit 5D: Introduction to spreadsheets ||
 * <span style="font-family: Verdana,sans-serif;">Must 1 || <span style="font-family: Verdana,sans-serif;">Must 2 || <span style="font-family: Verdana,sans-serif;">Should 1 || <span style="font-family: Verdana,sans-serif;">Should 2 ||
 * <span style="font-family: Verdana,sans-serif;">5.0 || <span style="font-family: Verdana,sans-serif;">6.5 || <span style="font-family: Verdana,sans-serif;">7.0-7.5 || <span style="font-family: Verdana,sans-serif;">8.0-8.5 ||
 * <span style="font-family: Verdana,sans-serif;">Student can (with extra help)
 * <span style="font-family: Verdana,sans-serif;">Student can (with extra help)
 * <span style="font-family: Verdana,sans-serif;">Could ||  ||   ||   ||
 * <span style="font-family: Verdana,sans-serif;">9.0-10.0 ||  ||   ||   ||
 * <span style="font-family: Verdana,sans-serif;">Student can (without any help)

<span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Subject/ Curriculum Area: ICT |||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Theme/Topic: Controlling devices || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Grade/Group: 4 <span style="font-family: Verdana,sans-serif;">th <span style="font-family: Verdana,sans-serif;"> Grade |||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Time frame: Cal 3 || <span style="font-family: Verdana,sans-serif;">1 |||||||| About this unit: <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">In this unit children learn how to control simple devices, such as buzzers, small motors and lights, using basic control boxes. They learn how to control devices by turning them on and off according to a set of instructions. |||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Where this unit fits in: <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">T <span style="font-family: Verdana,sans-serif;">his unit assumes that children: ▪ <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">understand procedures || <span style="font-family: Verdana,sans-serif;">2 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">All objectives: <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Children should learn: <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">to control simple devices, such as small motors, light bulbs, buzzers, by giving direct instructions. <span style="font-family: Verdana,sans-serif;">to create a sequence of instructions which can control a number of output devices || <span style="font-family: Verdana,sans-serif;">3 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">QCA Expectations Differentiated: || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">**Must** <span style="font-family: Verdana,sans-serif;">: <span style="font-family: Verdana,sans-serif;">design and create a simple advertising display which produces a limited number of events; need help to write simple procedures and design the display |||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">**Should** <span style="font-family: Verdana,sans-serif;">: <span style="font-family: Verdana,sans-serif;">design and create a simple advertising display which produces a combination of events; write simple procedures and be able to link output devices together; amend their procedures to get a desired outcome |||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">**Could** <span style="font-family: Verdana,sans-serif;">: <span style="font-family: Verdana,sans-serif;">design and create an imaginative advertising display which produces a combination of events; write, correct and improve procedures to link output devices together; realise the limitations of the system || <span style="font-family: Verdana,sans-serif;">4 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Assessment: <span style="font-family: Verdana,sans-serif;">     || <span style="font-family: Verdana,sans-serif;"> Control two lights  || <span style="font-family: Verdana,sans-serif;"> Traffic light  || <span style="font-family: Verdana,sans-serif;"> Sounds and lights  || <span style="font-family: Verdana,sans-serif;"> Dashboard  || <span style="font-family: Verdana,sans-serif;"> Final Project  || <span style="font-family: Verdana,sans-serif;">**2** || <span style="font-family: Verdana,sans-serif;">**2** || <span style="font-family: Verdana,sans-serif;">**2** || <span style="font-family: Verdana,sans-serif;">**2** || <span style="font-family: Verdana,sans-serif;">**2** || || <span style="font-family: Verdana,sans-serif;">5 |||||||||||||| <span style="font-family: Verdana,sans-serif;">All activities: <span style="font-family: Verdana,sans-serif;">Control a set of virtual lights <span style="font-family: Verdana,sans-serif;">Control a virtual electric bell <span style="font-family: Verdana,sans-serif;">Control a virtual electronic advert || Learning about learning opportunities: |||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Technical vocabulary: ▪ <span style="font-family: Times New Roman,serif;"><span style="font-family: Tahoma,sans-serif;">switch ▪ <span style="font-family: Times New Roman,serif;"><span style="font-family: Tahoma,sans-serif;">pushbutton ▪ <span style="font-family: Times New Roman,serif;"><span style="font-family: Tahoma,sans-serif;">module ▪ <span style="font-family: Tahoma,sans-serif;">procedure ▪ <span style="font-family: Tahoma,sans-serif;">device ▪ <span style="font-family: Tahoma,sans-serif;">advert || <span style="font-family: Verdana,sans-serif;">Cross-curricular links: <span style="font-family: Verdana,sans-serif;">Science || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Code: <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #ffff00 none repeat scroll 0% 0%;"> <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Reinforcement

<span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #00ff00 none repeat scroll 0% 0%;"> <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Challenge |||||||| <span style="font-family: Verdana,sans-serif;">Resources: <span style="font-family: Verdana,sans-serif;">(Software) <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Junior Control Insight 2 || <span style="font-family: Verdana,sans-serif;">Ideas for celebration of learning & display: <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Recognise relevant pieces of work. Print their works. || <span style="font-family: Verdana,sans-serif;">Week 1+2 |||||||||||||| <span style="font-family: Verdana,sans-serif;">Control a set of virtual lights <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #ffff00 none repeat scroll 0% 0%;"> <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Personal modelling <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #00ff00 none repeat scroll 0% 0%;"> <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Create modifications to the system || <span style="font-family: Verdana,sans-serif;">Week 3+4 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Control a traffic light <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #ffff00 none repeat scroll 0% 0%;"> <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Personal modelling <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #00ff00 none repeat scroll 0% 0%;"> <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Make it sound || <span style="font-family: Verdana,sans-serif;">Week 5+6 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Control a set of virtual lights and sounds || <span style="font-family: Verdana,sans-serif;">Week 7+8 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Control a virtual dashboard. <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #ffff00 none repeat scroll 0% 0%;"> <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Personal modelling <span style="-moz-background-clip: border; -moz-background-inline-policy: continuous; -moz-background-origin: padding; background: #00ff00 none repeat scroll 0% 0%;"> <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Include different devices || <span style="font-family: Verdana,sans-serif;">Week 9+10 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Control a virtual kitchen. ||