Haven't you heard? Google is launching a new version of Google Sheets which is even better than before!! The new Google Sheets also supports Add-ons, which extend the capabilities of the spreadsheets. Much like apps for your smartphone, these Add-ons can be written by anyone, rated by users, and of course installed by you. And now, the Add-on for Flubaroo is available to install!
By sheer coincidence, this comes exactly 3 years after the first version of Flubaroo was released. So to celebrate the Add-on, and Flubaroo's 3rd birthday, I'm excited to introduce a brand-new logo for Flubaroo! Big thanks to Katelyn Zaleski who used her awesome creative skills to design the new logo!
You'll find that Flubaroo runs much faster in the new Google Sheets, so your grading should take even less time than before! Add-ons also only need to be installed once (not in each spreadsheet), and support auto-updates. That means you now only need to install Flubaroo once, and forever more you'll have the latest and greatest version!
If you're already using the new Google Sheets, you can install the Add-on using the button below! And while you're there, be sure to rate and review it!
If you're still using the old version of sheets for now, that's OK. You can still continue to use Flubaroo as usual by installing it from the Script Gallery. But the version of Flubaroo in the Script Gallery will no longer be updated or actively supported. So why wait? Upgrade to the new Google Sheets today!!
You can now grade numerical ranges with Flubaroo (version 3.1)! A BIG THANKS goes out to Andrew Roberts (andrewroberts.net) for coding up this latest feature for Flubaroo!
This new feature is useful for math or science assignments, in which the exact precision of the answer doesn't matter much. For example, consider this sample question:
Sample question: What is the area of a circle of radius 5cm? Give your answer in cm^2.
If a student uses 3.14 as their value for PI, then they would get an answer of 3.14 * 52 = 78.500 cm2. But if they use 3.14159, they would get: 3.14159 * 5^2 = 78.5398 cm2. As an instructor, you probably want to mark both possible answers as correct (and anything in-between).
To ensure Flubaroo does this, you can enter your answer key as:
78.5 %to 78.54
Here, the special %to operator tells Flubaroo to expect a numerical answer that falls between the numbers given. Strictly, for a range of A %to B, an answer x will be correct if A <= x <= B (note the equals signs).
But wait, there's more....
Because Flubaroo is expecting a numerical input for this question, the student could also enter 7.85e1 (shorthand for 7.85 * 101), and Flubaroo will also mark is as correct. So you see, a student can enter their answer in a variety of numerical formats, and all will be graded as correct so long as they fall within the acceptable number range. So all of the following submissions would marked as correct: 78.5, 7.58e1, 785e-1, etc....
Lastly, we all know that students make mistakes when entering answers. Specifically, a student may not realize that you're looking for just the numerical part of the answer, and might also include the units like this: 78.53cm2. Don't worry, before grading Flubaroo will throw away any text following the number, so this will be marked as correct too!
I'll be testing this out in my own physics class this quarter, and will be happy to advise on how it went for those interested.
Happy Flubaroo'ing, and thanks again to Andrew!
3. Individualized Student Feedback
4. ¿Hablas Espanol? No hay problema, so does Flubaroo!
Hi Flubaroo Users -
I've just posted a few bug fixes to Flubaroo. These are now available in Version 2.1.
The fixes are:
If you don't care about any of these fixes, you can just ignore this update. You'll get the new version the next time you install Flubaroo into a new spreadsheet.
But if you'd like to get these fixes in a spreadsheet that already has Flubaroo installed, you'll first need to uninstall the existing version of Flubaroo. Follow these instructions to uninstall. After uninstalling, you can re-install Flubaroo from the Script Gallery. Check "Flubaroo -> About Flubaroo" to ensure you have Version 2.1 installed. It will look like this:
Good luck, and Happy Flubarooing!
Happy New Year everyone! I'm excited to announce some new feature additions to Flubaroo, created in response to all the great feedback I've received. New to Flubaroo? Read the overview , or try it now.
Here's a summary of the new features, followed by instructions on how to upgrade!
Changes to Grading:
* Multiple Points: Have a question that should be weighted more than the others? No problem!
* Low-Scoring Students: Students who scored below 70% have their entry appear in red font, for easy identification.
* More than One Correct Answer: Do you have a question with more than one possible correct answer? Now Flubaroo can support this for type-in questions. For example, this question:
could have "colors" or "colours" as the correct answer (depending where you live). To have Flubaroo consider either answer as correct, just fill out the answer key like this:
The special word %or in between the answers tells Flubaroo that either answer should be considered correct. Here's another example, with 3 possible correct answers:
This can also be helpful for math questions, where you'd like to accept all these answers as correct: 1, 1.0, 1.00.
Changes to Emails:
* Inclusion of Questions: When emailing grades, Flubaroo now gives you the option to pick whether or not you want to include the questions. This change was made because some teachers were concerned about distributing copies of their tests. The box is checked by default.
* Student's Own Responses: In the emails sent to students, Flubaroo now includes the student's own response to each question when emailing grades. This is useful for students to see exactly where they went wrong in their answer, such as in a spelling quiz.
Several other minor improvements and fixes have been rolled in too!
How to Upgrade:
If you have a spreadsheet in which you've never installed Flubaroo before, just install it from the Google Script Gallery as usual (Insert -> Script).
If you have a spreadsheet that already has Flubaroo installed, then you'll need to first remove the old version of Flubaroo before upgrading. Failing to do so can cause problems. It's easy to do! Just follow these instructions and you'll be ready to go in under a minute!
You'll know you're running the latest version when you see this message pop-up on your first install, or if you see "Version 2.0" in the "About Flubaroo" box:
I hope you find these new features useful and time saving. Please keep your feedback coming so I can continue to make Flubaroo better. I'm currently working on some additional commonly requested features, which I hope to release soon.
1-5 of 5