To see a demo of this Self Grading Spreadsheet go to this website:
This is a self- grading Excel file. There is an example picture of the spreadsheet that students will need to create. Students follow that picture to create the spreadsheet.
Student type in the data and modify the cells and columns as shown in the example picture. They can check their work at any time by clicking the Grading Key. The grading program will highlight the cells that are wrong with a red shade. In this way, students can receive instant feedback. Student will have to pay attention to details, because the program only tells them if the cell is wrong, and doesn't tell them what is wrong with the cell. Students will have to look at all of the requirements to make sure that what they did fits with what the directions ask for.
There are also some hints built into the grading feature that will allow students to get some help if they are stuck. Before students ask you a question they should look at the tips in the Grading Key. Students should be able to work independently on this Excel Spreadsheet.
In this spreadsheet students will enter data including numbers and text. Students will need to use the Average function and the If function. Student will also need to be able to format a cell with formats such as bold, italic, color, and alignment. Once again, there are hints given to students, showing them how to do these things.
NOTE: The grading program works with a PC, but has not been tested on a Mac. The code for the grading program expires in June of 2017
This works best if each students has a computer where they can open their own file. Put the Excel Grade Spreadsheet file into a read only folder. Have students open up the file. When they open it up for the first time, there will be a message box pop up in the top left reading, “Enable Content?” Student should click “Enable Content” and then hit “Yes”. Now students can use the grading feature of the spreadsheet. Do make sure that students save their work into their own folder.
NOTE: The grading program works with a PC, but has not been tested on a Mac. The code for the grading program expires in June of 2017.