Grade : 5/6
Stage 1 - Desired Results
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.
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.
-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.
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
-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
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
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
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.
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.
Canadian Statistics from Statistics Canada
-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)
Click to download Rubric
The following exemplars represent an excellent, adequate and limited student samples. Please click on the exemplar to download a copy.