An Improved Microsoft Excel Grade Book

• Charles G. Moseley ^[1]
  1. [1] Ohio State University at Lima

     Ohio State University at Lima

     City of Lima, Estados Unidos

     
• Localización: Journal of chemical education, ISSN 0021-9584, Vol. 73, Nº 1 (January), 1996, págs. 62-62
• Idioma: inglés
• Texto completo no disponible (Saber más ...)
• Resumen

  • I use a Microsoft Excel spreadsheet gradebook to record and calculate student grades for each of my chemistry students. In designing the gradebook, I found that the functions in Excel allowed me to easily average grades, calculate a running percentage of possible points for each student, drop the minimum grade from a list of quizzes or other grades, and assign a letter grade for trhe course. However, there is no built-in function in Excel Version 4.0 that would allow me to drop the lowest two quiz grades out of seven. This article reports a simple method for dropping the lowest two of seven grades using an Excel spreadsheet gradebook.