Thus, I leave the space blank for someone who did not take the test. Took the test and scored a zero, versus someone who did not take the test. Unfortunately, In my gradebook I like to distinguish between someone who This can be accomplished throughĮxcel's 'MIN' function which will find the lowest score in a set of scores. In my example gradebook, I have several midterm exams, of which the I then will 'Fill Right' (Command-R) when I enterĢ) How do I get Excelto automatically drop a test score?

Under the column of test scores, I have a series of functions that calculate

Score (MAX), the low score (MIN), the # of students taking the test (COUNT), I use Excelto find the AVERAGE, Standard Deviation (STDEV), the high The students that they will be allowed to drop their lowest quiz scoreġ) How do I get Excelto do standard Statistics? Several quizzes and midterm exams, in addition to a final exam. There are columns for each graded assignment. This unformatted text to columns in the gradebook. I took this list and pasted it into Excel and used the 'Text to Columns' command found under the 'Data' tab to fit Luckily for me, I can download a list of students and ID#s Me find them in the gradebook when I can't read their writing. I have them write their ID#s on their tests which helps I set-up my gradebook with the standard columns identifying the students Please download my example gradebook which incorporates examples illustratingĬlick Here to download: sample_gradebook.xls To automate processes such as dropping midterm exam scores and automatically Please send comments to spent some time trying to figure out how to manage myįreshman Chemistry class grades in Microsoft Excel. Ritchie, Associate Professor of Chemistry How to use Microsoft Excel as a gradebook (especially in large college classes like Freshman Chemistry) How to use Microsoft Excel as a Gradebook

How to use microsoft excel effectively