Hi,
I am a teacher and I am looking for automatic ways (macro) to grade excel based assignments because it will help us give more feedback to our students.
This is what I have so far:
1. Use two worksheets, one with the correct answers and one with the student solution.
2. Compare the cells with the answers using an if statements and spit out a 1 point for correct answer, 0 for wrong answer.
3. The IF statement includes a Formulatext so if a student only typed the answer and didn't use a function or a formula, he/she will not earn points.
My challenge is that there are clearly many ways to calculate the same thing in Excel. For example: A1 + A2 can be calculated with a simple formula =A1+A2 or =A2+A1, a SUM or =$A1$2+ A2 etc. The FORMULATEXT function doesn't accept those answers as correct answers. I could use OR but there are way too many options for answers.
Does anyone has any thoughts?
See attached file for an example.
Thank you in advance.
I am a teacher and I am looking for automatic ways (macro) to grade excel based assignments because it will help us give more feedback to our students.
This is what I have so far:
1. Use two worksheets, one with the correct answers and one with the student solution.
2. Compare the cells with the answers using an if statements and spit out a 1 point for correct answer, 0 for wrong answer.
3. The IF statement includes a Formulatext so if a student only typed the answer and didn't use a function or a formula, he/she will not earn points.
My challenge is that there are clearly many ways to calculate the same thing in Excel. For example: A1 + A2 can be calculated with a simple formula =A1+A2 or =A2+A1, a SUM or =$A1$2+ A2 etc. The FORMULATEXT function doesn't accept those answers as correct answers. I could use OR but there are way too many options for answers.
Does anyone has any thoughts?
See attached file for an example.
Thank you in advance.
Last edited: