Microsoft Excel
Lesson Plan

OBJECTIVE: Students will learn to use Microsoft Excel, spreadsheets in the course of this series.  They will be able to use the skills they learn in this project to apply to any spreadsheet application that they may encounter once they leave high school.  The ability to manipluate numbers and make charts to back up those numbers is becoming more important daily.  

OUTCOME COMPONENT:

1. Vocabulary associated with spreadsheets
2.  Prepare spreadsheets using both 'hard' numbers as well as functions
3.  Preparing  spreadsheets using different input data
4.  Incorporating charts into spreadsheets
5.  Spreadsheet project is in the form of a modified webquest

 

 SUCCESS INDICATORS:

  1. Students gain knowledge of vocabulary
  2. Students can manipulate data provided
  3. Students understand Taxes and the effects of changing values
  4. Students show skill in different charts options

CONTEXT/TEACHING METHODS:

Context

Students thrugh the webquest learn how to prepare several different types of spreadsheets, using examples found at the grocery store, fast food places, and most importantly how it effects occupations found here on the pueblo.  Students prepare real life spreadsheets that they can use at home, in assisting their parents or relatives on prices need to adaquetly charge for their work, see fetiches .  They learn how the prices of silver or gold will impact profits or losses

Students will have a rubric to follow that will be used to grade their efforts.

Teaching

STUDENT ACTIVITIES:

  1. Research places and items 
  2. Decide which ones they will do
  3. Become familiar with Excel 
  4. Prepare their spreadsheets
  5. Explain what they did in the spreadsheets
  6. Journal entry of experiences

ASSESSMENTS (AT LEAST 3 TYPES):

  1. Teacher Observation
  2. Research  
  3. Mastering skills
  4. Spreadsheets

CORRECTIVES AND ENRICHMENT:

Corrective-

Additional spreadsheets may be prepared.  

Enrichment:

Different topics and / or subject areas explored for spreadsheets. 

 

 

.