Use this Excel spreadsheet to grade and analyze four quarterly benchmarks and receive immediate feedback on student performance on individual standards, strands, and areas, not only for for that assessment, but also for the entire year to date.
Enter your key down the "answers" column (up to 54 questions per benchmark) and then code them under the appropriate benchmarks by typing "=Benchmark(1-4).(question number)" (So the third question on benchmark 1 would be =Benchmark1.3, while the fifteenth question on benchmark 4 would be =Benchmark4.15) Save, and then you're ready to enter student responses. (*see below for a more detailed explanation) The spreadsheet will automatically check for correct responses and distribute points (one per question) for you. If you want to hand grade selected questions or assign more than one point to a question, you can simply manually type in those points as students earn them into the appropriate columns. Make one copy of this spreadsheet for each student, and track progress all year long.
The ELA common core standards are color coded by area with pop-out descriptors for those that don't know what the codes stand for. If you need help using this product feel free to email me; I will be uploading a step-by-step how-to with screen caps later.
This spreadsheet was written for Office 2010 and was saved for earlier versions. If there are issues with how this works on your computer, please feel free to contact me. I will also be uploading an 8th grade version.
*Each row is one question. Scroll to the objective(s) that question addresses, and in that row and under that column, type the equal sign, the word benchmark, the number of the benchmark you're on (1-4), a period, and then the question number, all without spaces, and then hit enter. Question 5 for Benchmark 2 would be typed as =benchmark2.5 in the columns that match the standard it addresses. If you're not sure, hover over the codes, and a text box will tell you what that standard's text on the common core is.