-->
Today is: Tuesday,23 October,2018 09:59:20 PM

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 7: Math: Moving Out






Instructional Design: Nestor Sorochan, Dale Rurka, Paul Davies, Ulana Soletsky


Stage 1 - Desired Results




Established Goals:
Specific Outcomes:
Grade 7  MATH - Percents/ Data management

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.

General Outcomes:
Understanding Percents, convert numbers to a percent, estimate and calculate Sales Tax , GST. and Total Cost.  
Use a Spreadsheet to create a budget, calculate discounts using percents.
Use a spreadsheet to interpret and draw  different types of graphs to illustrate changes and comparisons,  ( calculate mean, median, mode, range, gaps, clusters)

Essential Questions:

Students will know:
Basics of spreadsheets
The concept of sales tax and GST
Collect data for different measures of Data Distribution.

Students will be able to:
Input data to create their own spreadsheet.
Use data from spreadsheet to create graphs.



Stage 2 - Assessment Evidence






Performance Task(s)
You are asked to leave your present home and you must set up your first apartment.  You have been given $5000 to spend on the furnishings.  You do not need to purchase a stove or fridge; those appliances will be supplied.  You will need to provide yourself with everything else you need to live.  (bed, couch, utensils, dishes, pots, drapes, small appliances, etc. etc. etc.)  You will provide all of your information on spreadsheets, and you will also draw graphs to  present your information.

Other Evidence (Quizzes, test, etc)


Self Assessment
Student self-assessment (which will be done at the end of this project)



Stage 3 - Learning Plan






Teaching and Learning Activities
1.  Rudiments of Spreadsheets (Practice assignment)

2. Understanding Percents, convert numbers to a percent, estimate and calculate Sales Tax and G.S.T.., Total        Cost,

3. Make a list with pictures and prices of all of the things one wishes to purchase.

4.Use a Spreadsheet to create a budget, calculate discounts using percents, calculate taxes, calculate totals.

5. Interpret and Draw Graphs

6.Use a spreadsheet to interpret and draw  different types of graphs to illustrate changes and comparisons

7.Collect data for different measures of Data Distribution. ( calculate mean, median, mode, range, gaps, clusters

8.   Input data so that technology  calculates mean, median, mode, range, gap and clusters.

9.  Present project on hard copy  to teacher.

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)



Rubric(s)






Click to download Rubric RubricMovingOut.jpg

Rubric.jpg



Student Exemplars







The following exemplars represent an excellent and limited student samples. Please click on the exemplar to download a copy.  NB - You will need Appleworks 6 and Word installed on your computer to view.



        


 Last Modified: 18 April,2006