swim, chem, baseball, I talk with my hands

EDU4113 – B – Microsoft Excel

Create a grade book spreadsheet in Microsoft Excel. Requirements for Grade Book:

  • Three (3) student information columns (Last Name, First Name, Student ID) for at least 10 students (real or fictitious)
  • Two grade categories with three or more assignments in each category
  • Subtotals for each category – total points, percentages
  • Total grade for each student in the class
  • Average score for each assignment and category
  • Use of the functions: CONCATENATION, SUM, AVERAGE
  • Name your file using your first and last name with the word “gradebook” (i.e. colin-quinton-gradebook)
  • Then, upload the file to Google Docs and share the spreadsheet to make it public.
  • Create an entry in your blog about how a spreadsheet could be useful in your teaching as both a colleague and a teacher. Include a linked word to the posted gradebook. (do not embed – simply post the active link)
  • In addition, explain how this tool addresses the ISTE teaching standard: Model Digital-Age Work and Learning.
    • Teachers exhibit knowledge, skills, and work processes representative of an innovative professional in a global and digital society

Submission –  Blog Post  [Title of Blog Post: Excel Gradebook] with accompanying description


This entry was posted on 2011-04-14 by in Assignments, EDU4113 and tagged , , , .


%d bloggers like this: