Excel  for Teachers

 

For 2 hours you must complete 12 hours of outside practice. For three credit hours you must also complete the following project.  

 

Project

 

  Create 8 complete useful worksheets. Worksheets should contain the following elements.

 

 

Grading for project:

A project that contains these elements will receive a grade of A.

 

Lesser quality or incomplete projects will be graded using the following scale:

90%-100%      = A

80%-89%        = B

70%-79%        = C

60%-69%        = D

0%-59%          = F

 

Email your finished project to instructor within one week of completion of course.

 

Practice files

 

  1. Animal Speeds
  2. Attendance
  3. Budget Spreadsheet
  4. Checking Account
  5. Computer Points
  6. Concession Candy
  7. Family Budget
  8. Family Budget Done
  9. Gradebook Done
  10. Linked Gradebooks
  11. Pizza
  12. PTA Pizza
  13. Reading Marathon
  14. Science Fair Letter
  15. Students Information
  16. Teddy Bear Chart

Web sites

  1. http://www.internet4classrooms.com/on-line_excel.htm
  2. http://www.uen.org/Lessonplan/preview.cgi?LPid=7753
  3. The book Mike used.
  4. http://dotxls.com/free-excel-templates/free-excel-templates---education-and-teaching Microsoft Links
  5. http://www.learnmicrosoftexcel.com/free_tutorials/free_tutorials_with_video.htm?gclid=CLjv1bH4uqoCFadgTAodUyCm6A
  6. http://www.techteachers.com/spreadsheets.htm