John Kongsvold's Downloads

• A gradebook sheet complete with student names and all formulas.
• An attendance sheet with student names and dates for all class sessions.
• A mid-term sheet to help calculate partial semester grades.
• A student info sheet with names, addresses, phone numbers, etc.
• A ReadMe sheet with info on using the gradebook
• A Quiz sheet to serve as an example for incorporating more grades into the gradebook.
• The GB Builder now works for summer school courses too.
• The GB Builder now works in Excel 2007 too.
• The GB Builder now creates a cell with an Entire Class group of email addresses that can be easily pasted into the BCC box of most email services including the HCC Outlook Web Access web service.
• The GB Builder now works in Excel 2010 too.

Download the latest GradeBook Builder file: GB Builder v2011d.xls to automatically build your HCC GradeBook.

Download a GradeBook Template for use at other schools but where you would need to manually enter student names and course information.

• Calculate student scores for True/False or Multple Choice tests and quizzes
• Summarize the class answers for each question
• Allow you to enter 'Extra Credit' or 'Other' points to be included in the total score
• Summarize how many scores were in the A, A-, B+, etc. ranges
• Allow you to curve student scores if necessary
• Enable automatic links to workbooks created with GB Builder

Download the Scoring and Analysis workbook: !ScoreTests 2008v1

This Course Search with Filtering workbook will place the Course Search Web Data in an Excel Spreadsheet that will allow

• Filtering courses by subject or times or days or instructors or rooms.
• Sorting the sequence of courses by time, capacity, enrollment, or locations.
• Print courses in filtered or sorted view.
• Sum and average enrolllments and courses.

Download the Course Search with Filtering workibook: !Course Info v2011a.xls