SOW+5th+Grade

Framework for Unit Plan

Subject/ Curriculum Area: ICT |||||||| Theme/Topic: Multimedia presentation || Grade/Group: 5 th  Grade |||||||| Time frame: Cal 1 || 1 |||||||| Main Idea: Children learn to create a multimedia presentation using text, images, and sounds |||||| Essential Questions: Can children handle multimedia elements such as animated text or animations? Can children use a microphone and speakers to produce sound files? || 2 |||||||||||||| <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Learning Intentions: <span style="font-family: Verdana,sans-serif;"> (To Understand, be able to do and to know plus attitudes to encourage) <span style="font-family: Verdana,sans-serif;">Use a multimedia presentation when communicating and presenting information from different subjects, such as: English, math, science, technology, etc <span style="font-family: Verdana,sans-serif;">This presentation will be about a United nations country. || <span style="font-family: Verdana,sans-serif;">3 |||||||||||||| <span style="font-family: Times New Roman,serif;"><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;">: <span style="font-family: Verdana,sans-serif;">Use a multimedia authoring package to assemble images, sound and text on a multimedia page. |||||||| <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;">Use a multimedia authoring program to organise, refine and present a set of linked multimedia pages, which incorporate images, sounds and text. |||| <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: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Use a multimedia package to organise, refine and present a set of linked multimedia pages, which incorporate images, <span style="font-family: Verdana,sans-serif;">sounds and text. || <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;"> Save PPP Insert Slides and Content layouts  || <span style="font-family: Verdana,sans-serif;"> Slide design and colour schemes  || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;"> Insert images, movies and sounds   || <span style="font-family: Verdana,sans-serif;"> Custom animation and slide transition  || <span style="font-family: Verdana,sans-serif;"> Special effects  || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;"> Record narration and insert video   || <span style="font-family: Verdana,sans-serif;"> 2  || <span style="font-family: Verdana,sans-serif;"> 1  || <span style="font-family: Verdana,sans-serif;"> 3  || <span style="font-family: Verdana,sans-serif;"> 1  || <span style="font-family: Verdana,sans-serif;"> 1  || <span style="font-family: Verdana,sans-serif;"> 2  || || <span style="font-family: Verdana,sans-serif;">5 |||||||||||||| <span style="font-family: Verdana,sans-serif;">Learning activities: <span style="font-family: Verdana,sans-serif;">Identified in each lesson. || Learning about learning opportunities: |||||||| <span style="font-family: Verdana,sans-serif;">Language focus: <span style="font-family: Verdana,sans-serif;">Presentation <span style="font-family: Verdana,sans-serif;">Slide <span style="font-family: Verdana,sans-serif;">Custom Animation <span style="font-family: Verdana,sans-serif;">Slide transition <span style="font-family: Verdana,sans-serif;">Animation schemes <span style="font-family: Verdana,sans-serif;">Hyperlink || <span style="font-family: Verdana,sans-serif;">Cross-curricular links: <span style="font-family: Verdana,sans-serif;">English <span style="font-family: Verdana,sans-serif;">Math <span style="font-family: Verdana,sans-serif;">Science <span style="font-family: Verdana,sans-serif;">Design <span style="font-family: Verdana,sans-serif;">Art || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Material and info sources: <span style="font-family: Verdana,sans-serif;">Info from different subjects <span style="font-family: Verdana,sans-serif;">MS PowerPoint || <span style="font-family: Verdana,sans-serif;">Ideas for celebration of learning & display: <span style="font-family: Verdana,sans-serif;">Projection of their presentations and forum || <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 PPP. Make new slides. Apply text and content layouts. Select a country and look for information. Title slide with background picture. || <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;">Insert photos. Use animated pictures and letters. || <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;">Search for movie clip in You tube. Send an email to teacher with link to the movie clip chosen. || <span style="font-family: Verdana,sans-serif;">Week 7+8 |||||||||||||| <span style="font-family: Verdana,sans-serif;">Insert sounds. Use Slide Show/Record Narration <span style="font-family: Verdana,sans-serif;">Use Insert/Movie and Sounds/Record Sound. <span style="font-family: Verdana,sans-serif;">Should have at least one form of recorded voice. || <span style="font-family: Verdana,sans-serif;">Week 9+10 |||||||||||||| <span style="font-family: Verdana,sans-serif;">Apply slide transitions. Apply custom animation to make a PPP automatic. Create special effects.

<span style="font-family: Verdana,sans-serif;">Evaluation of Unit: <span style="font-family: Times New Roman,serif;"> <span style="font-family: Verdana,sans-serif;">Presentation should move automatically and include photos, movie clip and narration. || <span style="font-family: Verdana,sans-serif;">Framework for Unit Plan

<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: <span style="font-family: Verdana,sans-serif;">**Unit 6B Spreadsheet modelling** || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Grade/Group: 5 <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: <span style="font-family: Verdana,sans-serif;"> (weeks/Lessons/Minutes) 6 weeks <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;"> CAL 2 week 1 to 5  || <span style="font-family: Verdana,sans-serif;">1 |||||||||| <span style="font-family: Verdana,sans-serif;">**Main Idea:** <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">**Key idea:** <span style="font-family: Verdana,sans-serif;"> that mathematical models can be explored using a spreadsheet In this unit children learn to use a spreadsheet to explore a mathematical model. |||| <span style="font-family: Verdana,sans-serif;">**About the unit:** <span style="font-family: Verdana,sans-serif;"> Children will be taught to use formulae in spreadsheets to answer ‘what if ...?’ questions. They will explore how changes in a spreadsheet affect results and identify simple rules. || <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:** <span style="font-family: Verdana,sans-serif;"> <span style="font-family: Verdana,sans-serif;"> (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;">**Learning Intentions Differentiated:** <span style="font-family: Verdana,sans-serif;">**Must:** <span style="font-family: Verdana,sans-serif;"> use a spreadsheet to calculate totals |||||| <span style="font-family: Verdana,sans-serif;">**Should:** <span style="font-family: Verdana,sans-serif;"> explore the effects of changing data in a spreadsheet |||| <span style="font-family: Verdana,sans-serif;">**Could:** <span style="font-family: Verdana,sans-serif;"> explore the effects of changing data in a spreadsheet; make predictions and use a spreadsheet to test them || <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;">**SPREADSHEET MODELLING** || <span style="font-family: Verdana,sans-serif;">**LESSON 1** |||| <span style="font-family: Verdana,sans-serif;">**LESSON 2** |||||| <span style="font-family: Verdana,sans-serif;">**LESSON 3** || <span style="font-family: Verdana,sans-serif;">**CAL 2** || <span style="font-family: Verdana,sans-serif;">Multipli formula || <span style="font-family: Verdana,sans-serif;">Division formula || <span style="font-family: Verdana,sans-serif;">Perimeter formula || <span style="font-family: Verdana,sans-serif;">Area Formula || <span style="font-family: Verdana,sans-serif;">Formating: header, justified, insert sheets, name sheets || <span style="font-family: Verdana,sans-serif;">Copying cells || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;"> Explore and create new formulas   || <span style="font-family: Verdana,sans-serif;">Create a graph || <span style="font-family: Verdana,sans-serif;">Enhance a graph ||^   || <span style="font-family: Verdana,sans-serif;">1 || <span style="font-family: Verdana,sans-serif;">1 || <span style="font-family: Verdana,sans-serif;">1 || <span style="font-family: Verdana,sans-serif;">1 || <span style="font-family: Verdana,sans-serif;">2 || <span style="font-family: Verdana,sans-serif;">1 || <span style="font-family: Verdana,sans-serif;">1 || <span style="font-family: Verdana,sans-serif;">1 || <span style="font-family: Verdana,sans-serif;">1 || <span style="font-family: Verdana,sans-serif;">10 || || <span style="font-family: Verdana,sans-serif;">5 |||||||||||||| <span style="font-family: Verdana,sans-serif;">**Learning activities:** <span style="font-family: Verdana,sans-serif;"> Identified in each lesson. || Learning about learning opportunities:
 * <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;"> Understand that spreadsheets can be used to explore mathematical models
 * <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;"> Children will apply what they have learnt in this unit when exploring mathematical and scientific models. <span style="font-family: Verdana,sans-serif;">   ||
 * <span style="font-family: Verdana,sans-serif;"> Children who find the work difficult could be given a prompt sheet showing cell references.
 * <span style="font-family: Verdana,sans-serif;"> More able children could try more complex formulae such as ‘=2*(10–c2)’ to find the lowest values. ||

<span style="font-family: Verdana,sans-serif;"> Application to real life situations will be discussed and brainstormed |||| <span style="font-family: Verdana,sans-serif;"> **Language focus:** <span style="font-family: Verdana,sans-serif;"> **Cross-curricular links:** <span style="font-family: Verdana,sans-serif;"> **Rubric/checklist ideas:**
 * <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: Verdana,sans-serif;"> calculate
 * <span style="font-family: Verdana,sans-serif;"> data
 * <span style="font-family: Verdana,sans-serif;"> model ||
 * <span style="font-family: Verdana,sans-serif;"> English
 * <span style="font-family: Verdana,sans-serif;"> Math
 * <span style="font-family: Verdana,sans-serif;"> Science
 * <span style="font-family: Verdana,sans-serif;"> Design
 * <span style="font-family: Verdana,sans-serif;"> Art ||

<span style="font-family: Verdana,sans-serif;"> See assessment |||| <span style="font-family: Verdana,sans-serif;"> **Material and info. Sources:** <span style="font-family: Verdana,sans-serif;"> Children will use Open Office but they will be made aware of MS Excel <span style="font-family: Verdana,sans-serif;"> Info from different subjects || <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;">Week 1 <span style="font-family: Verdana,sans-serif;">+2 || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">**technique:** <span style="font-family: Verdana,sans-serif;"> <span style="font-family: Verdana,sans-serif;"> to identify formulae and enter them into a spreadsheet  |||||||||||| * <span style="font-family: Arial,sans-serif;">  <span style="font-family: Verdana,sans-serif;">Set up an Excel workbook and name it  <span style="font-family: Verdana,sans-serif;">//__**My Book of formulas**__//  <span style="font-family: Verdana,sans-serif;"> * <span style="font-family: Verdana,sans-serif;"> Ask the children to set up a spreadsheet to work out the area and perimeter of a rectangle. The length and width of the rectangle should appear so that the values can be changed. <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">**Assessment**  <span style="font-family: Verdana,sans-serif;">: Children should produce a workbook as the one modelled by teacher which will contain the formulas for multiplication, addition, perimeter and area. <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">**Extension**  <span style="font-family: Verdana,sans-serif;">: Extra points will be given to sheets containing a new shape together with its working formula     || <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;">**technique:** <span style="font-family: Verdana,sans-serif;"> <span style="font-family: Verdana,sans-serif;"> to copy cells  |||||||||||| * <span style="font-family: Arial,sans-serif;">  <span style="font-family: Verdana,sans-serif;">Show students how to format their workbook to make it  <span style="font-family: Verdana,sans-serif;">printable (  <span style="font-family: Verdana,sans-serif;">header, justified, insert sheets, name sheets) <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">**Assessment**  <span style="font-family: Verdana,sans-serif;">: Children will be required to copy a formula and format a workbook. <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">**Extension**  <span style="font-family: Verdana,sans-serif;">: Able students will be encouraged to make up a formula and carry out its answer using different variables. || <span style="font-family: Times New Roman,serif;"><span style="font-family: Verdana,sans-serif;">Week 5 <span style="font-family: Verdana,sans-serif;">+6 || <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">**technique:**  <span style="font-family: Verdana,sans-serif;"> to use a spreadsheet to draw a graph     |||||||||||| * <span style="font-family: Verdana,sans-serif;"> Show the class how to create graphs using the spreadsheet. <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">**Assessment**  <span style="font-family: Verdana,sans-serif;">: Create a graph and prepare it for publication. <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">**Extension**  <span style="font-family: Verdana,sans-serif;">: Explore and create new formulas. || <span style="font-family: Verdana,sans-serif;">**Evaluation of Unit:** <span style="font-family: Verdana,sans-serif;">Children should feel confident to use Open Calc as a calculator. ||
 * <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">Remind children how to enter a formula into a spreadsheet, such as ‘=C2*C3’ and ‘=c2/c3’. Each formula should be written in a separate sheet.
 * <span style="font-family: Verdana,sans-serif;"> Ask the children to identify the formulae they would need to enter to calculate:
 * <span style="font-family: Verdana,sans-serif;"> the area of a rectangle;
 * <span style="font-family: Verdana,sans-serif;"> the perimeter of a rectangle.
 * <span style="font-family: Verdana,sans-serif;"> Ask the children to create a set of multiplication tables such as:
 * <span style="font-family: Arial,sans-serif;"> <span style="font-family: Verdana,sans-serif;">Ask the children to explore what happens when the data in the two  <span style="font-family: Verdana,sans-serif;"> cells is changed.
 * <span style="font-family: Verdana,sans-serif;"> Show the class how to copy formulae from one cell to another.
 * <span style="font-family: Verdana,sans-serif;"> Show students how to extend a series of numbers
 * <span style="font-family: Verdana,sans-serif;"> Ask the children to investigate graphs such as y = x2, y = 2x, y = x + 3.