Tag Archive for: Google Docs

Analysing data from a self-marking quiz using Google Forms with Flubaroo

Having recently published a guide to creating a self-marking quiz using Google Forms we thought it would be useful to share some next steps that are worth exploring.

To begin with, we’ll look at a useful plugin to analyse the data generated by students completing a multiple choice quiz. The screenshot below shows an example of what the add-on we will use can do. As you can see, the whole class and individual data is analysed. The question in orange menas less than 60% of students go the answer wrong. Students in red have achieved less than 70%. This feedback can then be used to identify misconceptions or gaps in learning which can then be addressed in class.

Analysis

Analysis of data

Towards the end of the creating a self-marking quiz using Google Forms guide, we showed you how to create a spreadsheet containing results. As a reminder, simply go to your quiz form and click the Google Sheets icon.

Click the Google Sheets icon

Click the Google Sheets icon

You are then given the option to Create a new spreadsheet or Use and existing spreadsheet. You could either maintain seperate spreadsheets for each quiz or have one dedicated spreadsheet with multiple sheets for your quizzes. This will be a personal choice to do what works for you.

Create a new spreadsheet or Select existing spreadsheet

Create a new spreadsheet or Select existing spreadsheet

Once you’ve selected the option, clicking the Google Sheet icon now opens the spreadsheet showing the result. We are now going to install a plug in on your spreadsheet that will automate analysing the results. A plug in is a programme that adds features to your Google Sheet.

Open your Google Sheet then click Add-ons then Get Add-ons.

Get add-ons

Get add-ons

A window will pop-up as shown below. Select flubaroo. If it is not shown in the window then do a search for it. Click the icon, then click Install. Press continue and agree to the terms and conditions. Click done once the plug-in is installed.

Select the flubaroo plug-in

Select the flubaroo plug-in

Return to your Google Sheet. You will not notice any difference to the spreadsheet at this stage.

Next, go to the live form and complete it as a student would, ensuring all the correct answers are selected. Be sure to enter your name too, so you can identify this entry later on as the answer key. Click submit.

Next, return to your Google Sheet. Go to Add-ons > Flubaroo > Grade Assignment.

Grade assignment

Grade assignment

Flubaroo will ask you a few questions, such as:

  • If any questions should not be graded.
  • Which questions are for the purpose of student identification (e.g. name, student id, email).
  • Which submission should be used as the answer key.

Be sure to select skip grading for the score, otherwise this will be added to the scores to the individual questions.

Grading Step 1

Grading Step 1

Once answered, Flubaroo will grade your assignment. This process should take less than a minute.

A new sheet is created displaying individual and group performance data. If less than 60% of students got a question correct, the question will be highlighted in orange to alert you. Additionally, students who scored less than 70% on the assignment will be highlighted in red.

Analysis

Analysis of data

Create a self-marking quiz using Google Forms

Creating a self-marking quiz using Google Forms is easy. Not only can students complete the quiz using any device but the quiz is self-marking, saving you time. This tutorial takes you through the steps needed to create a quiz like this basic example for coastal erosion.

To get started, head over to your Google Drive and click the New button in the top left corner. Next, click More then click Google Forms.

Open Google Forms

Open Google Forms

When your form is open, click the settings icon (cog) then select the Quizzes tab. This allows you to allocate points to the quiz and allow grading should you want it. Next, click Save.

Turn on quiz

Turn on quiz

Give your quiz a title, by clicking Untitled form and adding a title.

You now need to add fields to your quiz, which can include first name, surname and email address. To begin with type first name into the first question field. Then, select short answer from the answer dropdown. Make sure you click the required slider otherwise students could submit a quiz without adding their name. You can duplicate the question to add surname and email address.

Adding name fields

Adding name fields

When you’ve added the email address field you will have the option to collect email addresses. Click the link to enable this.

Your form will look something like the example below.

Collecting details for your quiz

Collecting details for your quiz

Next, you need to add your questions. You can add multiple choice questions, multiple answer questions and short answers.

Below is an example of a multiple-choice question. Remember to select Required so that students ahve to answer the question.

Example multiple-choice question

Example multiple-choice question

Once your written your multiple-choice question, click ANSWER KEY. Next, identify the correct answer and allocate the number of points available for correctly answering it. You can choose to add answer feedback too if you wish to.

Identify the correct answer and allocate points

Identify the correct answer and allocate points

Add the remaining questions you want to ask.

When you are ready to test your quiz click the preview icon at the top of the screen. This will take you to the live quiz (you can copy the web address and share it with students – if you are not sharing this electronically you might want to shorten the web address (URL) by visiting TinyUrl.

Once you have shared the quiz you can check results by clicking the Responses tab. You can review the performance of your students by exploring the options. If you want the results in a spreadsheet format, just click the Sheets icon below Total points. This will create a spreadsheet containing all the responses.

Responses

Responses

Did you know? If you subscribe to Internet Geography Plus you’ve got access to a number of multiple-choice question booklets. You can copy and paste questions and answers from these booklets to create digital versions of the multiple-choice resources. Please note, if you use our questions please don’t share the quizzes with people or students outside of your classes if you have an individual subscription or your school if you have a department subscription.

Have you seen our quizzes on Internet Geography? Save time creating your own by using ours!

Next Steps
Once you’ve set up your quiz installing a simple add-on lets you analyse the data you have collected. Take a look at this post to find out how: Analysing data from a self-marking quiz using Google Forms with Flubaroo.

Create a proportional circles map in Google Sheets

Auto Feed Forward

Ecosystems Independent Revision