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.
- Charts
- formulas
- formated cells
- data
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
- Animal Speeds
- Attendance
- Budget Spreadsheet
- Checking Account
- Computer Points
- Concession Candy
- Family Budget
- Family Budget Done
- Gradebook Done
- Linked Gradebooks
- Pizza
- PTA Pizza
- Reading Marathon
- Science Fair Letter
- Students Information
- Teddy Bear Chart
Web sites
- http://www.internet4classrooms.com/on-line_excel.htm
- http://www.uen.org/Lessonplan/preview.cgi?LPid=7753
- The book Mike used.
- http://dotxls.com/free-excel-templates/free-excel-templates---education-and-teaching Microsoft Links
- http://www.learnmicrosoftexcel.com/free_tutorials/free_tutorials_with_video.htm?gclid=CLjv1bH4uqoCFadgTAodUyCm6A
- http://www.techteachers.com/spreadsheets.htm