This re-usable scoresheet supports 3 classes and 10 Multiple Choice Questions. I WILL HELP YOU SET UP YOUR TEMPLATE FOR YOU. For your first use, you can send me your answer key, and I will set the rest up for you. Add your student names (copy and paste). Then,simply go to Cells P2 to Y2 and in the formula bar, change the "a" to the answer for your question. Note: letter answers must be enclosed in quotation marks, while numbers should not. Copy the new answer key, and paste it down for each row containing student data. Be sure to avoid pasting into cells with color, as they contain additional data analysis formulas.
As soon as you enter the responses for your students, you have item analysis and a graph to assist in your data-driven instruction.