For this assignment, I created a quiz using Google Forms and learned how to apply formulas to allow it to grade itself. After creating five test questions, I selected the first empty cell to the right of the questions in row one, and inserted the formula (=IF(B3=B$2, 100,0)). Rather than having to repeat the formula for each row per student, I simply dragged it to the empty cells. This formula creates a "grade" for each cell (basically informing me if the answer is right or wrong) but it does not give me a total average. To find the average of all of the answers per student, I used the formula (=SUM(I3:M3)/5) and inserted it to the empty spaces to the right of the other formula. The formulas will make more sense after you view my spreadsheet.
I am SO happy I learned how to do this, because it will save a lot of time only having to plug in one formula as opposed to manually grading several quizzes. The only obstacle I can foresee is not having enough laptops for every student to take the quiz. However, I like being able to implement technology whenever I can, and if I can find a way to make quizzes even a little interesting for students, I'm all about it. Not to mention the time saving aspects since they would be self graded.
To test your knowledge on basic sonnet forms, click here or take the quiz below!
No comments:
Post a Comment