What I Did
I applied the skills used in creating a form and spreadsheet from the last assignment to creating a quiz for art students. Please take my very short quiz so that I can complete the self-grading codes and post the results. Thanks!
I ended up completing the quiz myself and varying the answers so that I could have a more interesting summary. What a great tool to use for classes! Also an easy way to get students to take exams without having to make them up later if they are out sick!
A couple of issues:
First, I couldn't get the formulas to work like the youtube video showed. I kept getting numbers that weren't averages out of 100, so I had to play with the point value of the questions. I also used an average formula instead of the "SUM" formula. I don't know how the guy in the video came up with averages using "SUM." You can view my spreadsheet here. Is there a way to make the data summary available to students while keeping the names confidential?
Secondly, I am worried about the results/test summaries that are influenced by the "key." It shows one more "student" getting 100% than actually did, so the data is not reflecting the true outcome. However, the key is needed in order to type in the formula for the self-grading. What happens if I get rid of the "key" row?... It messes up the numbers and averages...thank God for the "back" button! I am not sure how to remedy this problem.
No comments:
Post a Comment