Grade 7: Math: Moving Out
Instructional Design: Nestor Sorochan, Dale Rurka, Paul Davies, Ulana Soletsky
Stage 1 - Desired Results
Grade 7 MATH - Percents/ Data management
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.
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)
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
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)
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)
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.