VIEWS: 1 PAGES: 20

• pg 1
```									Crash ED 6346

   Mr. Borodin wants to
use a technology-
based tool to teach
students a life skill of
costing the purchase
of a car

   Concepts maximized

   Mathematical
calculations
minimized
   Technology for      Tools students
knowledge            can learn with
construction
   Tools that interpret
and organize
information
   Time & efficiency       Production of
   Accuracy                 information charts
   Rapid calculations      Visualization of
   Entries can be           impact of change
added or deleted        instant feedback
   Automatic
   Students will learn terms & concept of
amortization
   Students will learn connection between
concepts and loan length on monthly
payments
   Students will learn why, where, and how to
   Students will individually use the same Web-
their buck” given specs on 3 cars (authentic
scenario)
   Students will research in pairs
   Formative -individual checklist of
spreadsheet skills and loan analysis terms
(borrowing rate, principal, interest, beginning
balance, monthly payment, & amortization)
   Formative -Pair work costing several
scenarios
   Summative -Pair car costing assignment
(cloze activity)

   Purpose of lesson – students learn variables
of car cost
   Preview new vocabulary and review concepts
while creating the Excel spreadsheet with
students
   Demonstrate - input car #1 specs to create
monthly payment
   Life Challenges Cards
   Collectively input new specs
   Discuss results
   Pair practice with cars # 2 & #3
   Exit ticket
 mathematical           save time for
problem solving         teachers preparing
(Inclusion)               materials and
 organizing and          tracking results
tracking of data       provide for visual
 storing and             demonstrations
analyzing data         acquisition of 21st
(critical thinking)       Century skills
   MS Excel (software suite)
   Google Docs (Web based software suite)
   iWork by Apple (integrated package)
   OpenOffice.org Calc (open-source software)
   Resolver One (spreadsheets for programmers and
nonprogrammers)
   Mr. David wants to
use a technology-
based tool to compile
and synthesize
information on the
past 5 prime
ministers

   Software tools

   Organization of class

   Assessment
   Teacher               Student
organization of        organization of
research,              research,
management of          management of
information, and       information, and
comparison of          comparison of
information            information
Benefits
   Reducing data
redundancy
   Saving time locating
and updating
information
   Users can store,      Allowing
organize, and          comparisons of
manipulate             information through
information            searches across
files
   Revealing
relationships within
data
   Review research         Develop a database
skills through          Pose and test
database                 hypothesis
(information bank)      Data mining
instruction
   Research
information
through prepared
databases
Research Group 1
MacDonald & MacKenzie

Research Group 2
Abbott & Thompson

Research Group 3
Tupper & King
   Inventorying and        Research
locating resources
   Data mining for         Input
planning and
reporting               Present
   Using information
to respond to
questions or
Group Work
Rubric

   Final product
& presentation
   Individual
group
   Participation
in group
discussions
   Participation
in class
discussions
NETS-S
   Visual
1. Communication &
   Kinesthetic        collaboration
   Production      2. Critical thinking,
   Collaborative      problem solving,
learning           and decision
making
3. Technology
operations &
concepts
   Roblyer, M.D., & Doering, A.H. (2010). Integrating educational
technology into teaching. Montreal, Canada: Allyn & Bacon.
   http://projects.gnome.org/gnumeric/functions.shtml
(Retrieved July 10, 2010)
   (Retrieved July 10, 2010)
   http://www.resolversystems.com/
   (Retrieved July 10, 2010)
   http://home.zcubes.com/
   (Retrieved July 10, 2010)