Google Forms and Flubaroo

 Google Forms and Flubaroo 

22nd June, 2016

 

Will provides a short run through of one way to use Google Forms to quickly collect, mark and grade assessment data.

As a pre-service teacher, I am sure you have heard about or engaged with Google Forms before. They are becoming increasingly popular in the classroom and I have seen 4th and 5th grade students use them effectively. This post will share just one way to use Google Forms as a pre/post assessment tool that I have found extremely helpful.

I am not going to discuss how to actually make a Google Form test – this is self-explanatory and there are numerous tutorials already available. I enjoy the flexibility of the types of questions – short/long answer, multiple choice, checked boxes, drop down menu and more.

You want to make the first two questions of your test “What is your first name?” and “What is your surname?”. Once the test is created, you need to complete the test with the correct answers. You are now ready for students to complete the test. After they have finished, you want to click the Responses tab and the View Responses in Sheets button. 

Once in Sheets, you need to download the Add-on that will automatically mark the test for you. This is called Flubaroo and can be found under Add-ons > Get Add-ons. Once you have this installed, head to: Add-ons > Fulbaroo > Grade Assignment

Step 1: The first questions (What is your name/surname?) can be used to identify the student. Other options allow you to change the value of each question but the default is 1 point per answer. A new feature is manual grading for those questions that you need to read individually before marking. 

Step 2: You now chose a person’s response to grade all the other submissions from. This is where you select your response which will have the correct answers. Once you continue, Flubaroo will work its magic. It will produce a new sheet with some valuable data for analysis including:

• There is a nice little summary at the top. A good place to see how many students completed the test, the average score and summative grades can be recorded.

• Vertically you can see student names with their score and percentage. Flubaroo goes the extra step by highlighting in red any students who scored below 70%. This is excellent data to see the range of student abilities on the topic and help in forming focus groups.

• Horizontally every question is listed with the answers. Boxes are highlighted orange if they were poorly answered across the group. This can be used for key concepts to focus on in future lessons. For example, students may easily answer a multiplication question with 2-digit numbers but struggle with a question using a 3-digit number.

At the end of a unit, complete the same test and compare students’ before/after scores and clearly identify questions/concepts that they are still struggling with.

I encourage you to try out Google Forms and Flubaroo. This was just a short introduction to some powerful software that is valuable for assessment practices in the 21st century classroom.

- Will

Hmm, how am I going to get this job?

Hmm, how am I going to get this job? 

5th May, 2016

Aaron explores the weird and often confronting concept of self-promotion when applying for jobs post-university.

In my position at my place of employment I spend a good chunk of my time looking through job applications for potential childcare workers, and also take part in the interview process for new hires. I’ve been working for the same company now for quite a while, in the industry for a little over 10 years, and haven’t really needed a good job application or display of my previous work recently as I’ve just moved between different companies to get to where I am. In light of this, some recent assessment tasks we have been set with at University have required a lot of creative thinking on my behalf to build up my portfolio for the future if I intend on getting into the field of teaching and learning how to promote myself as an effective teacher – without sounding like a total jerk.

One thing I’ve found is the need to set aside the judgments we all unconsciously place on ourselves, and look at our work output and personal perspective from an objective standpoint. This doesn’t mean to take your personality out of what you are creating, but more to allow yourself to look at your application/portfolio/resume as someone who is looking to employ people at their place of work.  Now, I should also add, I am not a school Principal, I don’t have a perfect sense of what each individual will think when looking at my work, but as someone who has sifted through quite a lot of job applications in recent years, I can say there are some definite things to keep in mind.

I could write a big list of things to write or to leave out, but I think what’s more pertinent here is the approach you take to what is being written. Look at your efforts during your time at University, what are you proud of? What helped you develop a greater understanding of the world you are studying? What will prove that you have developed as a person during your time spent sitting in lecture theatres and staring at computer screens late at night? We can all remember the things that we place value on, so use that, even if it doesn’t sound like the perfect quip for a job, it is your honest reflection on your achievements, and being confident and proud of what you recognize as a strength will show in your chosen written format for job acquisition, and will show in your explanation and reasoning in your formal interview.

We’ve all heard stories of people who have lied their way into jobs, and heard stories of people who have been caught out on those lies. Don’t start off on the wrong path, or let self-doubt get in the way. Self-confidence isn’t something that comes naturally to everyone; so using the objective eye is a great way to move past that. If you were looking at this application and this portfolio of achievements, would you be impressed? Is this believable, and does it show growth and merit in the field you’re applying to work in? If you think ‘YES!’ then you’re on the right track. Believe in yourself, c’mon, just try it.

- Aaron Osborne