Spreadsheets_and_Database by shitingting

VIEWS: 1 PAGES: 20

									Crash ED 6346

Spreadsheets and Databases
   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
    access spreadsheet software
   Students will individually use the same Web-
    based spreadsheet to determine “best buy for
    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)
   Gnumeric (spreadsheets)
   K-Spread (spreadsheets)
   Resolver One (spreadsheets for programmers and
       nonprogrammers)
   Z Cubes (online spreadsheets)
   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
    perform task
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)
   http://www.koffice.org/kspread/
   (Retrieved July 10, 2010)
   http://www.resolversystems.com/
   (Retrieved July 10, 2010)
   http://home.zcubes.com/
   (Retrieved July 10, 2010)
   http://www.lessonplanspage.com/CISSCreatingADatabaseOn
    Africa45.htm/
   (Retrieved July 11, 2010)
    http://www.lessonplanspage.com/CIUsingGoogleDocsTutoria
    l712.htm
   (Retrieved July 11, 2010)

								
To top