Saturday, November 20, 2010

Interactive Worksheets

Ever wondered how people make interactive quizzes and worksheets for others to fill out tab by tab on the computer and get immediate results on their progress? Me too.

Little did I know, but Microsoft Excel has the capability to create just such a document! I always considered Excel to be completely useless to me, because I was never interested in creating a spreadsheet or bar graph or any of that lame stuff. This is actually useful though, and could be integrated into any classroom where students may have computer access. I most likely wouldn't use it during my art classes, but I'd like to have a class website to post images of student work and answer questions outside of class time, so the option to have study worksheets on terminology and definitions could definitely be integrated.

Here is an image of my Principles of Design worksheet:

As you can see I've provided a little information in the blanks already. There is a space where students can add their name and the date, then just hit Enter or Tab and automatically start answering questions. There is a word bank and image representing radial symmetry. As shown in the picture, when students answer a question correctly the form reflects the fact with "Correct!" and awards the student 10 points. If a question is answered incorrectly they receive 0 points and the message "Try Again". A cumulative total at the bottom shows how many points the student has at the moment, with the maximum being of course 100.

This type of interactive spreadsheet layout is super helpful and allows students to study for quizzes and tests by granting them the ability to go back and re-do questions they missed. The only downside I found with the activity is that the answers are case-sensitive and basically have to be EXACTLY like the answer provided in the making of the form. Other than that this is a very useful resource that I might actually use in the future!

No comments:

Post a Comment