Chapter 4Chapter 4 TIE into Practice TIE into Practice

Tammy Boudreau Kevin Reed Paulette Goguen Monique Dupuis Susan Smidt Paula Gaudet

Can you Afford Your Dream Car?Making use of spreadsheets in the classroom

What are the decision variables when making a large purchase ?

Ms. Kiley’s class

Select a car to purchase and complete background research on it, including its price, loan, and features.

Use a spreadsheet to answer questions on loan payments and various interest rates and time periods.

Do a final report to present your findings and say how you will pay for the car.

Car loans

Uses of Spreadsheets Uses of Spreadsheets in the classroom in the classroom

““Educational Technology into Teaching” Page121-122Educational Technology into Teaching” Page121-122

Teaching Visual Teaching

DemonstrationsTeach Problem Solving

Store and Analyze Data

Supporting student products

Projecting Grades

Strategies Concepts involving

numbers: X, %, graphs Arithmetic functions,

higher level concepts Keep track and

organize data, save and edit

Create timelines, charts and graphs

Keep track of grades “What if?”

excel spreadsheet

Possible Problems

Forgetting to highlight cells to be formattedDifficulty in developing formulas

Phase 2- Advantages?

VisualBasic calculations done

quicklySaves timeEnter and delete data

easily, save and edit Comparison shoppingGraphingSort and analyzeProblem solving Neatness

Phase 3 –What Elements would you assess on your Rubric?Technology Elements:

Use information in a spreadsheetCreate a spreadsheetCreate a graph

Content Elements:Research and information gatheringMathematical problem solvingMake inferences from spreadsheet

Presentation Elements:Ideas and contentOrganizationPresentationLanguage and Conventions

Phase 4 – Benefits of Group work vs Individual Work?CollaborationPeer-helpingShare personal

experiencesShare prior knowledgeBuild communication

skillsTeacher can work with

students in small groups

Phase 5 –Why Individual Formative Assessment?

Correct use of technologyKeep the students on-task and on their timelineCheck for understanding of the math concepts

as this is part of her desired outcomes.Drawback of the spreadsheets is that numbers

can be put in without understanding the arithmetic behind the numbers.

Paula's wiki

Phase 6- Strategies for Improved Final Report

Podcast- present in front of another class in another province, country

WikispaceSkypeCompare modes of transportation with other

countries – Social StudiesWrite a story on their first road trip with the

new car – English Language Arts

Integrating Educational Technology page iiIntegrating Educational Technology page ii

NETS for Students

Standard 1 – Creativity and Innovation

Standard 3 -Research and Information FluencyCritical

Standard 4 – Critical Thinking and, ProblemSolving, and Decision Making

Standard 6- Technology Operations and Concepts