• Course Home
  • List of Chapters

  • Topic: Thinking and Spreadsheets
    		•

    The Steps

     Look: Concepts

  • Read: Chapter Overview - Mathematics, Spreadsheets and Thinking.


  • Read: The Technology Principle of the National Council of Teachers of Mathematics is simple. Use technology.

    •  
  • Read: 6 NCTM Principles The technology principle is part of a set of six principles that undergird the practice of teaching mathematics.

    •  
  • Read: Math and the LEAP Problem Processing Model The language of mathematical problem solving fits well with the LEAP model.  Note the way that the math language complements and extends the language used in other content areas such as science.

    •  
  • What is the best question to ask in a given situation so that problem solving can succeed? To pause and think, to correctly frame the problem, whether from an ethical, a critical or a creative perspective is essential to an effective solution. For now, find, read & memorize the four higher order thinking skills for comparison, analysis, inference and evaluation provided by NorthWest Regional Labs: THINK-NorthWest Labs. Reasoning based on data is a key element of state technology competencies.

    • Optional

  • Compare three different models of higher order thinking skills by NorthWest, Bloom and Marzano

    •   Look: Technical

  • Skim NC teacher technology competencies: section 4 - Spreadsheets & Graphing Can you do these skills?

    •  
  • Handheld computers part 3, drill and practice handwriting with Giraffe and explore this style of spreadsheets.
     
  • Read and Do: GIS explanation and free software to download and explore.  

    •    Optional

  • Web sites-sec02 in progress

  • Middle Level Math ideas.
  • Web site that helps teach the math in many math textbooks
  • Reports of Reviews of Educational Math Software (Add your own contributions too)
  • DataSpaceWeb
  • Lab for Advanced Computing
  • ESRI's GIS systems
  • Install and explore Google Earth

    •  

    Evoke

  • Read and complete: Spreadsheet Tutorial activities and assignments. In the spreadsheet tutorial, a number of questions about different spreadsheets must be answered and some questions created. Further, three spreadsheets must also be created and and graphs produced.

    •  

  • Using the model questions and the sample spreadsheets in the spreadsheet tutorial, create and put 3 questions on a web page. Link that page to the computers.html file. The database questions that will be created in the later chapter on databases can go on the same web page. Also, complete the three spreadsheets introduced in the Spreadsheet Tutorial, the first two of which go in the appropriate places in the unit plan.

    •  
  • Complete: Relevant week activities for the unit plan and update sections VII, & IX.
    • with links to spreadsheet compositions.
     
  • Extra credit: Post a question and answer related to using ArcExplorer to the same page that contains your spreadsheet questions. Use the practice data sets that come with the educational version. Demonstrate your Q & A to your instructor.
    		•

    Assess

    • Reflect on the experiences of the chapter, adding a new posting to your blog site.
    • Elluminate (Calendar. Synchronous: live online text, audio, video,whiteboard, file transfer, and screen displays)

     

    Publish

  • In Unit Plan section III add sub-objectives
  • In VII put links to the versions of the comparison spreadsheet (#1 in tutorial assignment).
  • In Unit Plan section IX find the places to put links to the versions of the gradebook spreadsheet (#2 in tutorial).
  • Link page with 3 spreadsheet questions based on set of spreadsheets given.

    • Overview of Assignments Due for Next Week

  • Finish chapter reading.
  • Finish publishing activities to web site.
  • Complete "May's equation" spreadsheet.

    •  
  • Ch4 Lab Grade Evaluation Rubric

    •  

     
     
      Printer friendly view of the Chapter Four Index


    Page author: Bob Houghton, 2004