For a bit of context, in Biology, final exams are always printed on paper in black and white. Dull... Colour copying is too expensive for a one-time test, and students always seem to draw on the pages. Without colour though, diagrams of circulatory system lack the ability to convey meaningful information about oxygenation. Also, differentiating green chloroplasts from other cellular organelles becomes a real chore. Those mitochondria typically depicted in red, lose their lustre. Let's face it, diagrams are impaired.
Why not move beyond diagrams, I pondered? Google Forms, in case you haven't tried them, let you create multiple choice questions and place images AND video preceding responses. That's right -- video in the form of small YouTube windows. Absolutely perfect in conveying moving processes like peristaltic waves of the digestive system, I was hooked. I had to include this kind of material in my final exam.
So, many hours later in constructing my Google Form (similar to the link in the video) with uploaded and online images, as well as questions with embedded YouTube content, the final exam was finished.
Okay, so it was amazing. With a DNA image as the background to the form, Google automatically matched the blue tones, providing a light-blue background. I was impressed.
So how does StarWars factor into my Biology 12 final exam? Look closely in the image above at the first question "Enter the Star Wars name provided to you..." To protect student privacy with Google Forms, I provided each student with a Star Wars name on the day of the final. No student knew what their name would be. And FIPPA-compliant, neither would the Internet... [Cheers and applause...]
As an added touch, I discovered how to program Google Forms' spreadsheet to automatically grade the exam. You see, Google Forms saves response data as a spreadsheet. Using spreadsheet formulas, each answer in the final was compared to the correct answers I provided. When the exam was finished, the scores for each Star Wars student automatically displayed in the spreadsheet. Now if you're interested in seeing how this is done, here's how it is done.
I know what're likely thinking -- how did you transplant all those final exam questions? Well, in part I copied and pasted data from PDF's of the exams. Then, there was a lot of typing and web searches for better colour diagrams and video content for questions. It was admittedly a sizeable task, but completely worth it.
On the day of the exam, when students received their Star Wars identities, I was a bit nervous. I provided the URL for the Google Form, highly classified data until the day of the test. I was worried there wouldn't be complications. For example, if students pressed enter, it automatically completed the form. Luckily, Google Forms has an option for the test-taker to return to the form and continue completing entries is this is the case. It's an important option to include when creating the form. I'll post more about that later.
Suffice it to say, the students completed the exam and had nothing but positive things to say. The test was completed in the school's PC wired lab, so there was little chance of flaky wifi-ness.
Post-exam, I matched students' Star Wars name to their score and was amazed I could analyze responses of all students. You see, Google Forms creates a Summary of Responses as pie graphs. This enabled me to see what students had answered for each question. I was understandably happy with the result.
So, if you're looking to create online Google Forms assessments, I highly encourage it. Check the links in this post if you're eager to get started. Later this spring, I'll post a YouTube clip explaining much more. But for now, I wanted to blog about how well the experience went. Will I create a Google Forms eCampusLive Biology 11 Final Exam? It's a secret and don't tell anyone, but the answer is HECK yes. :)