A New Awakening - Final Exams done Right with Google Forms & Star Wars Protects Student Privacy3/30/2016 For the final examination in eCampusLive Biology 12, I wanted to do something different, something that I'd never been done before and in a galaxy not so far away, my class. 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. :)
28 Comments
GERARDO. A. CABERA
3/16/2020 03:23:00 pm
exams
Reply
9/11/2022 02:01:06 pm
Really informative article, I had the opportunity to learn a lot, thank you. https://kurma.website/
Reply
9/12/2022 02:44:30 am
Really informative article, I had the opportunity to learn a lot, thank you. https://odemebozdurma.com/
Reply
9/14/2022 03:19:01 pm
Really informative article, I had the opportunity to learn a lot, thank you. https://bit.ly/site-kurma
Reply
9/30/2022 06:13:37 am
It's great to have this type of content. Good luck with your spirit. Thank you. https://bit.ly/site-kurma
Reply
10/4/2022 12:40:16 pm
I think this post is useful for people. It has been very useful for me. Looking forward to the next one, thank you. https://escortnova.com/escort-ilanlari/denizli-escort/acipayam-escort/
Reply
10/5/2022 09:54:37 am
It was a post that I found very successful. Good luck to you. https://escortnova.com/escort-ilanlari/bingol-escort/yedisu-escort/
Reply
10/6/2022 03:08:26 am
I follow your posts closely. I can find it thanks to your reliable share. Thank you. https://escortnova.com/escort-ilanlari/mugla-escort/marmaris-escort/
Reply
10/6/2022 06:45:58 am
I support your continuation of your posts. I will be happy as new posts come. Thank you. https://escortnova.com/escort-ilanlari/isparta-escort/yalvac-escort/
Reply
10/7/2022 09:01:11 am
I think the content is at a successful level. It adds enough information. Thank you. https://escortnova.com/escort-ilanlari/konya-escort/huyuk-escort/
Reply
10/7/2022 04:03:03 pm
Thank you for your sharing. I must say that I am successful in your content. https://escortnova.com/escort-ilanlari/agri-escort/diyadin-escort/
Reply
10/8/2022 12:39:14 pm
Thoughtful and real content is shared. Thank you for these shares. https://escortnova.com/escort-ilanlari/bursa-escort/orhaneli-escort/
Reply
11/21/2022 08:48:46 pm
Tıkla evde calismaya basla: https://sites.google.com/view/evden-ek-is/
Reply
12/9/2022 08:03:51 pm
Uygun fiyatlardan takipçi satın al: https://takipcialdim.com/
Reply
12/9/2022 11:03:21 pm
instagram beğeni satın al: https://takipcialdim.com/instagram-begeni-satin-al/
Reply
12/9/2022 11:05:10 pm
Garantili Tiktok takipçi satın al: https://takipcialdim.com/tiktok-takipci-satin-al/
Reply
12/15/2022 05:55:10 pm
takipçi satın al ve sitemizi ziyaret et: https://takipcim.com.tr/
Reply
12/19/2022 09:25:56 pm
İnstagram takipçi satın almak istiyorsan tıkla.
Reply
1/5/2023 04:31:57 am
100 tl deneme bonusu veren siteleri öğrenmek istiyorsan tıkla.
Reply
Leave a Reply. |
Archives
November 2016
AuthorWelcome to the eCampusLive blog. I'm Jerry Bleecker. I teach Biology, Science, Information Technology, Computer Arts, and more. It's an exciting year to share our experiences with our flipped classroom endeavour. Categories |