How to use the Flubaroo Add-on for Google Sheets

Free Up Time With The Flubaroo Add-on For Google Sheets

Google Sheets is an awesome tool for teachers. You can use it to track grades, attendance, contact information, and even to distribute homework or announcements to parents. Wow! Google Sheets is a powerful tool on its own, but you can use 3rd party add-ons to get even more out of sheets. Add-ons are created by developers to boost the capabilities of your spreadsheets, giving you teacher superpowers you never imagined could exist pre-Google Sheets!

There are so many great add-ons available for Google Sheets. One of our favorites is the Flubaroo add-on. Flubaroo is an add-on that allows teachers to transform the way they grade online homework, quizzes, and other assessments. They have reached nearly a million users, and report that more than 400,000 assignments are graded each month! This add-on is more than just a basic grading tool. You can also send grades with comments to students or parents from within the spreadsheet, either via email or Google Drive.

Flubaroo provides the average grade, a histogram of scores, and identifies which questions students miss most often. So, not only do you free up time by automating part of your grading process, you have a clear identifier of where your students need extra help or you might need to improve your teaching methods.

Use that extra time to do the things that matter—like planning dynamic activities to engage your students. Flubaroo is ideal for educators in elementary, secondary, or high learning institutions. Today we will show you how to use the Flubaroo add-on for Google Sheets!

How to access Flubaroo

It is really simple to get add-ons for Sheets! The fastest way to get Flubaroo is to click this link to go directly to the web store. Simply click the Free button and the add-on will be added to your Google Sheets account.

Alternatively, you can get the add-on by following these steps:

1. Open a spreadsheet
2. Click the add-ons button in the navigation menu
3. Click the Get Add-ons button
4. A window will pop up for you to browse
5. Type “Flubaroo” in the search box.
6. Click the Free button to get the add-on

How to Use Flubaroo

Click Add-ons → Flubaroo →  the toolbar will run within your sheet. You are ready to start using Flubaroo!

Flubaroo was designed to make teachers lives easier—so of course—it is easy and intuitive to get started using it.

First, you need to get the grades into your spreadsheet. Hopefully, you are already harnessing the power of Google Forms and Sheets to give students online homework and assessments. If not, check out a guide on how to set up a Forms survey from within Sheets. The best practice is to have the first row underneath the categories be your answer key. Later you will need to identify this as your answer key within the add-on so that it can properly grade the submissions.

Once your Form is set up correctly, students submissions will input right into the spreadsheet, and look like these sample grades provided by Flubaroo.

Now it is time for grading magic! Click Add-ons → Flubaroo → Grade Assignment.

You will then have the option to double-check your preferences for each field and indicate the answer key.

Flubaroo may need to run for a few minutes depending on your class size.

The add-on creates a new spreadsheet with the final grades represented by total points and a percentage. Students with a failing score are highlighted in red, so you can quickly identify which students may need more help.

How to share grades with Flubaroo

One of Flubaroo’s great features is the ability to share grades easily with your students or their parents from right within the spreadsheet. You can either send the grades by email, Google Drive, or both!

Next click Add-ons → Share Grades.

Now you can choose to add a custom message to your students, or give out a “sticker” to all or just the passing students!

How to view the histogram

Flubaroo offers a simple visual report to help you gain insight into your students’ performance. Simply click Add-ons → View Grade Report and the add-on will generate your histogram. View it at a glance or email to yourself for your records.

Wrapping up

So that’s about it! Flubaroo is straightforward and intuitive to use! It’s another great add-on to have in your teacher toolkit. Flubaroo has advanced features if you want to grade more complicated things, like quizzes with more than one right answer, or tests with essay questions that require you to combine auto-grading and grading by hand. You can customize your account by clicking Add-ons → Advanced or reading Flubaroo’s advanced user tips. Happy grading! 

موقع يساعدك في الشروح

https://sites.google.com/site/monjighanem/tutorials

How To Use The autoCrat

How To Use The autoCrat Add-on For Google Sheets

What is autoCrat?

AutoCrat is another add-on for Google Sheets that is changing the face of education. At first glance, it might not seem like that interesting of a tool, but it’s many applications make this a super valuable add-on! autoCrat is another neat invention of CloudLab, one of the leading innovators in the add-ons for Education developer space. autoCrat is an add-on that allows you to merge information from your spreadsheets into other formats, like documents or PDFs. It has a simple user interface that makes formatting, storing, and sharing information a breeze.

Who is Using Autocrat?

Anyone who uses Google Sheets as access to autoCrat, it is a free merge tool that is available in the add-ons store. Although autoCrat was designed for teachers and administrators, just about anyone can use it to automate processes. It is also loved by students, researchers, and businesses.

What Can You Do With autoCrat

With autoCrat, you can take information stored in spreadsheets and easily convert it into a Google Doc, PDF, or even a slideshow! It sounds simple, but many people are taking this tool and using it to enhance their workflows so they can free up time for more important tasks!

How to Access autoCrat

It is really simple to get add-ons for Sheets! The fastest way to get autoCrat is to click this link that will take you directly to the add-on store.

Simply click the Install button and the add-on will be added to your Google Sheets account.

Alternatively, you can get the add-on by following these steps:

1. Open a spreadsheet
2. Click the add-ons button in the navigation menu
3. Click the Get add-ons button
4. A window will pop up for you to browse
5. Type “autoCrat” in the search box.
6. Click the Free button to get the add-on

You are ready to start using autoCrat!

Get Started

First, click add-ons → autoCrat → Open

AutoCrat will load, and prompt you to create your first merge job! There is no sidebar in autoCrat anymore, they got rid of it and swapped it for a dialogue box that takes you step-by-step through the process of each merge.

Step 1:

Click New Job, then you will be prompted to give your first merge job a name! After naming the job, click Next.

Step 2:

In this step, you will need to choose a template for your merge. Today we will choose to have autoCrat create an example template for us. When you create your own templates, you can save them to and select them from your drive.

In the past, autoCrat only worked with Google Docs, but now it also integrates with Google Slides. This is really exciting for users who want to create custom presentations from within spreadsheets.

Step 3:

In this step, you need to map the source data from the spreadsheet to its correct place in the template. You can choose from standard text, hyperlinks, or images. You will need to create a corresponding tag for each area of the Doc or Slide you want the information to be populated into.

Step 4:

Next, give a file name for the output document that the add-on will create.

Step 5:

Select a folder in your Google Drive that the document will be inserted into.

Step 6:

(Optional) Choose a folder reference.

Step 7:

(Optional) Set conditional rules for your merge. For example. If you are sending out a letter about grades from a student roster, you may choose to only send out letters to students who are receiving failing grades within the course.

Step 8:

Next, we will select editing/commenting and sharing settings for our merge, and then send out any emails to anyone we may want to share the Doc or Slideshow with.

Step 9:

For the last step of the merge set-up, we have the option to choose if we want this merge to run based on any specific triggers, like a form submission or at a designated time interval. Some users can fully automate certain processes using these triggers. For example, you can have students submit essay questions via Google Forms, and their answers will populate into a Google Sheet. Reading these answers within a sheet cell could obviously be quite cumbersome! You can set a trigger so that the students submissions are merged right into a PDF or Doc, that go into a specific class folder. Use automatically generated Docs to for grading, commenting, or even peer review! After specifying triggers, press Save.

Final step! Ok—that does it! Your first autoCrat merge has been set up, and will now be displayed as an existing job when you run the add-on. Click the play button symbol to start the merging sequence. You will see your Google Sheet change a bit—now there will be a cell with a link to the Doc that was created for this demo.