Self Marking Assessment Using Google FormsWhen you've finished testing, does it take you ages to collect the data, input it into a spreadsheet and then analyse it to work out where each student is with their learning? I've just started using a really productive system that takes a lot of the hard work out of the post-test analysis using Google Forms, Google Sheets and a super little add-on called Flubaroo.

Google Forms is a web based app that allows you to collect information in a Google Spreadsheet. In this example, it has been used to collect information from a test that I have prepared. The test is then made accessible to my students online and they can then input all their answers into the form, which can be validated as they type. When all of the answers have been submitted, the test is then marked automatically for me and I can see the analysis of the test results.

A working example of the form is below:

The results and analysis from this are below:

Please note that the analysis is on the "Grades" tab but may not reflect the data in the first tab as it is dependent on me recalculating when a new test has been completed for this demonstration.

The example I have used is the UK Primary School Year 5 mental maths test (I know it should be audible but its just an example) but it can be used for many other types of tests, for any subject.

The process I used to set up the test and analysis is as follows:

1. Set up the form

You'll need a Google Account for this. Once you have one, log in to Google Drive and select New Google Form. (Make sure that you're in the correct folder where you want the forms and responses to be saved)

You'll then have an interface similar to this:

You'll notice that the tick box at the top says "Allow ..... login to view this form". If you have a Google account for each student that is taking the test, then you can restrict access to just these students, but if you don't just unselect this tick. Unselecting the tick will mean that other people can access the form, but if they don't know the URL then it is unlikely.

Make sure you give the form a relevant name and you can then start adding questions. An screen shot of the example form you've seen is below:

When you click on the Add Item link, you can choose from one of the following question types:

  • Text
  • Paragraph text
  • Multiple choice
  • Tick boxes
  • Choose from a list

There are more advanced items too, such as time, date, scale and grid which may be useful for you depending on the type of test/quiz that you are using.

You can also add other elements to the form/test such as a page break to break the test up into sections, a section header, images and videos.

For my test, I ticked the Required Option box as I wanted to make sure that the children filled in each question. I also clicked on the advanced link and selected Numbers as I wanted to make sure that only numbers were typed in. This makes checking the answers easier as they were not allowed to type in ml, for example. Therefore my answer would just be the value, not the units.

I'd suggest creating a dummy quiz first and playing with the different elements first to see what works for you.

2. Publish the test

When you're ready to run the test, click on the "Send Form" button in the top right hand corner. This then generates a link to the form which can be sent to students via email or placed in your shared area (Windows shortcut, intranet, etc) for the students to access. The students then simply click on the link and take the test. When they have completed the test, the "Responses" menu item in your form has a number after it to show how many children have taken the test.

When all students have taken the test, you are then ready to analyse the results.

3. Add the answers to your results spreadsheet

Next, create a row in the spreadsheet which contains the answers. I inserted mine at the top and then coloured them red so that I could differentiate them from the answers that the students gave.

You can set multiple correct responses for open-ended questions in which the students type their answers. To do so, enter one response, then space, then enter %or (no spaces between % and "or"), space again, then enter the next right response. Do this between each correct response when you complete the assessment to make the key. This will avoid students getting marked wrong because one capitalized the first letter and the other didn't or because there are two legitimately correct responses.

4. Add the Flubaroo add-on and analyse the data

An add-on called Flubaroo is then used to mark the responses. In your results spreadsheet, click on the Add-ons menu item and then select Get Addons. In the search box, search for Flubaroo and then add it to your spreadsheet.

In Addons -> Flubaroo select the Grade Assignment option and Flubaroo will run you through a wizard as follows:

First, select the values for each of the answers:

As you can see, I have set my values to one point for each question, but you could set them to whatever you wanted. For example, if you were creating a KS2 SATs test you could assign 1,2 or 3 mark questions depending on the difficulty of each question.

Next, choose which of the rows is your answer row. As I called mine "Answers" it is easy to recognise:

Flubaroo then analyses your data and creates a new tab on your spreadsheet called "Grades". This generates statistics for each of the students, identifying which questions they've got right and wrong. The results come back in a color-coded spreadsheet. Students' names that are in red ink are those who scored below 75%. Columns that are highlighted in orange are questions for which 75% of the class (or more) did not get the right answer. You can also see average points, how many people took the test and which were the low scoring questions so that these topics can be addressed.

As you can see below, Flubaroo gives you a number of other options including generating reports from the statistics and emailing results to the recipients (if they have signed in using their Google account).

When your test has finished, you can turn it "off" by selecting Responses from the menu and then clicking on "Accepting Responses".


comments powered by Disqus