Easy Grader for Google Sheets

Making using google sheets as a gradebook a little bit easier.

[su_youtube url=”https://www.youtube.com/watch?v=SOImg-iwT6c”]

[su_button url=”https://chrome.google.com/webstore/detail/easy-grader-add-on/bkloilagbahbeblhjgkojapenendkkpk” target=”blank” style=”flat” background=”#0c1790″ color=”#ffffff” size=”8″ wide=”yes” center=”yes” radius=”0″ icon=”icon: pencil-square-o” text_shadow=”0px 0px 0px #000000″]Find out more in the chrome web store…[/su_button]

I enjoy using spreadsheets to hold a lot of grades. There are many services that will send you reports in spreadsheet files, so it just makes sense to keep you other grades in that format.

The thing that started to frustrate me was entering grades from classwork. I created this add-on to try and alleviate those struggles.

After you install the add-on, open it inside of the spreadsheet where you want to enter grades.

tutorial-open

The sidebar is fairly straightforward. The select box at the top allows you change which column your grades will go into. Use the settings at the bottom to change which columns the Easy Grader will consider as grade columns.

tutorial-overview

Once you are setup, just select the box for student name. It will use the first three columns as its search field. Just type a few letters of the name and it should appear. Hit enter, then tab, type the grade, hit enter again. The grade will automatically appear in the spreadsheet and the focus will return to the student name box ready for you to enter the next grade.

tutorial-tab-power

As always, I appreciate feedback! Let me know how I can make this better.

 

Unit By Design Template for Google Documents

In my department we use the Unit by Design Template (UBD) to do our unit plans. It takes the top-down approach of starting with your objectives and planning from there.  In order to speed up my planning process, I thought it would be a good idea to create a template that I could customize each time I put a unit plan together.

The result of that goal is:

Unit By Design Template

Feel free to download this add-on and play around with it. There is just a little bit of setup required.

ubd-howto-setup-2

First, you need to create a spreadsheet similar to the one seen above. This will have all of your objectives in it. The spreadsheet should have 3 columns.

  1. The first column is a category for the objective.
  2. The second column is a title for the objective.
  3. The third column is a longer description completing the “Students will be able to…”

Once you have finished building your list of objectives, you need to copy the key of the spreadsheet. This key is highlighted in the image above.

ubd-howto-setup

Open a new document and install the add-on. Click on ‘Add-ons > Unit By Design Template > Setup’ to open a setup window. Copy that key into the input box and save. Now you are ready to create a new unit!

You can get an example objective spreadsheet here:

https://docs.google.com/spreadsheets/d/1c_vwNSKbW9V22zi8JBw_-Gp_CM6va_T_X6FYL88N0QM/edit?usp=sharing

The key is: 1c_vwNSKbW9V22zi8JBw_-Gp_CM6va_T_X6FYL88N0QM

ubd-howto-1

Notice the two buttons ‘Go back a stage’ and ‘Move to the next stage’. The allow you to go back and forth between the stages of the process. Complete the fields and move to the next stage.

ubd-howto-2

Select one or more of the objectives. These fields are populated from the spreadsheet that YOU created. They will be used when the template is generated. To select multiple objectives, hold down the ‘CTRL’ key.

ubd-howto-3

You can add some other information that will be used for Stage 1 of the UBD. These fields are all optional. You must hit the RETURN key after each statement that you want separated in the plan.

ubd-howto-4

Once again, you can select mulitple options from this list. Just hold down CTRL while you select.

ubd-howto-5

How many individual lessons will you have in this unit? The number you select will be used to create lesson planning blocks in your plan. Click on SUBMIT THE FORM to start building the plan!

Next steps…

Go back through the plan that is generated and make final changes. There is always more that you can add to a unit plan! Also, if you go back to the add-ons menu, you can build individual lesson plans directly into your plan. Give it a try!