-->
Today is: Monday,16 July,2018 11:53:21 AM

Home Division PD St. Gabriel Search Engines
Home
Division PD
St. Gabriel
Search Engines

Learning Technology Projects
Div. I
Div. II
Div. III
Div. IV
Teacher Resources
Alberta Learning
Tutorials
Libraries & Galleries
Museums
Curriculum Web Links
English Language Arts
Science
Social Studies
Math
Religion
ICTs

Grade : 5/6






Instructional Design:
Pat Tymkow
Françoise Gamache



Stage 1 - Desired Results




Established Goals:
Acquire information from a variety of sources (electronic and print ).
Organize information gathered into a chart, diagram or graph.
Analyses results to determine trends and make predictions.
Present  findings through a multimedia presentation.

ICT Outcomes:
Below is a pdf file identifying all of the ICT outcomes touched on throughout this project. Click on the file to download it to your computer.
ICTsVGStatistics.pdf

Enduring Understandings:
-It is essential to use statistics  to gain incite into a community in order to enable the government to better meet their needs.  
-It is essential to be able to interpret and analyze statistics in order to make predictions.

Essential Questions:
What is  the value of gathering, organizing and analysing statistical data?
Why is it essential for the government to gather statistics ?

Students will know and be able to:
-Use a spreadsheet program, create graphs and charts based on the the spreadsheet
-Use the slideshow program to display collected information
-Explain and discuss results of data.




Stage 2 - Assessment Evidence






Performance Task(s)
-Gather relevant data about --St. Albert demographics (for one class) or Canada (for the other class)- from electronic or print sources.

-You will be creating a multimedia presentation explaining various types of information about the following to your classmates.

 -You will be making conclusions and or recommendations, predictions about your topic, according to the data you have.

Other Evidence (Quizzes, test, etc)
Quizzes, tests, teacher observation, etc.

Presentations , teacher observations, rubric

Self Assessment
Journal reflection
Oral discussion, etc.



Stage 3 - Learning Plan






Teaching and Learning Activities
1.  Discussion of why different groups of people and the government use statistics.
                -look at various types of statistics, analyze them
                -video on Stats Canada

2.  Lab sessions 1& 2 Exploration of Presentation and Spreadsheets(2X40min)
**See Practice_SS Document below  
                  Logon. Launch Presentation.  Make 3 slides to begin. Save as Subs.initials
Table:
     1.Title page:title+ name +add  clipping/picture from library
     2. Page 2: open a spreadsheet in the presentation. Think of Battle Ship.
     3.Type in “Sub Sale” in cell C1. Get the toolbox. Resize row. Format as you wish.
     4. In cell A2, type in Monday. Select A2 to A6. Calculate<fill special and select.
      5. Select row 2 and insert row. Format<Insert cells
      6. Type in the rest of the information in the correct cells. Format as you wish.
     7. Enter function =B3+C3+D3 in cell E3
     8. Select E3 to E7. Calculate<Fill down
     9. Select B7 and have students write in their function (=B3+B4+B5+B6+B7). Fill Right.
    10. Select E8. Select from function menu =SUM(E3..E7)
    11. Add borders and complete formatting

Graph:
   1. Select A2 to D7. Options<Make chart.
   2. Title axes. Label<change title.
   3. Format axes titles by selecting axe and format.
   4. In table cell D7 for 30. Observe and discuss changes in table and graph.
   5. Copy or cut and paste graphic on page 3 of slide show.
   6. Play slide show and show transitions.
If time:
    7. Copy and paste cells A2 to A7 lower in the SS.
    8. Copy and Paste special<values only, cells E2 to E7.
   9. Select all cells and create pie chart.
  10. Experiment with formatting


Sessions 3 to 6 Performance Task
  1. Students receive data. Selects from various presentation backgrounds from assignment folder. Begin with title page.
  2. Page 2: create table from inserted SS option. explain what table represents.
  3. Page 3: create graph from page 2 and copy to page 3. Draw conclusions.

Extensions: create a second graph and draw conclusions or make predictions.

Differentiated project: create table and graph for student. Student inserts data in slide show.. Writes up explanations and conclusions. Format slideshow.


Statistic Content
Class 5/6B
Canadian Statistics from Statistics Canada

Class 5/6A
St. Albert
-To identify the trends of the population growth of St. Albert over time, as well as growth of specific neighborhoods.

Additional Teacher Resources
These are documents for teachers and/or students that were developed to support the project.  Documents will always be available in pdf format as well as in the original format created (e.g. MS Word, AppleWorks, Inspiration, etc)
StatPresentation_sample.cwk
Spreadsheet_instructions.pdfPresentation_Instructions.pdf
Practice_SS.cwk

Slideshowtemplates




Rubric(s)






Click to download Rubric
Stat_Rubric.cwkStat_Rubric.pdf



Student Exemplars







The following exemplars represent an excellent, adequate and limited student samples. Please click on the exemplar to download a copy.
UniversityEnrolment_high.cwkStatsCan_med.cwkStatsCan_low.cwk
St_AlbertStat_high.cwkSt_AlbertStat_med.cwkSt_AlbertStat_weak.cwk


        
        



 Last Modified: 23 June,2004