Finished entering grades with a little coding help!

I use Google Sheets a lot, and in this case I had way too many grades cluttering up my spreadsheet. I decided that I was going to take the top 4 grades and average them together to get the final grade. In order to do that I threw together a little script to make that easier.

Enjoy! Post any questions below.

Grading curves with your Easy Online Gradebook

Can we create our own functions in Google Sheets? YES!!!

Using the template that we setup in a previous post, we can add some custom functions to make grading even easier. This can seem a little intimidating since it does require looking at code. However, HAVE NO FEAR! All you need is the ability to copy and paste and you will be good to go.

I have finished my first iteration of as a full MEAN-stack web application. There are even a few of my projects linked into the app. There are still lots of things to tighten up (mobile functionality, bookmarklets page, users…) but as a basic app I am pretty proud of it.

Trheajt_planner teach1he goal of the app is to compile all of the various JavaScript projects into one easily accessible place, as well as provide a system for suggesting new projects. There are tons of ways out there to improve accessibility and functionality for teachers. I have barely begin to scratch the surface.


CopyPastaForm for Google Forms

Google Forms is a great tool, unfortunately it takes a bit of time to create one. I have had the thought that it would be much easier to have one single text box that I can type in (or copy and paste into) that will generate the entire form. This led me to create…

CopyPastaForm for Google Forms

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.


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.


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:

The key is: 1c_vwNSKbW9V22zi8JBw_-Gp_CM6va_T_X6FYL88N0QM


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.


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.


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.


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


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!

UBD Template Google Documents Add-on

Just a quick introduction to my first release of the UBD Template Addon for Google Documents. Please let me know how I can improve this for other users!

Here is a link to an example of the kind of spreadsheet you need for your objectives. Just copy the key in the URL and put it in the setup for my application.


Follow this link to the Chrome Store to install my add-on!

Advanced Javascript: Objects, Arrays, and Array-Like objects

Javascript objects and arrays are both incredibly useful. They’re also incredibly easy to confuse with each other. Mix in a few objects that look like arrays and you’ve got a recipe for confusion!

Source: Advanced Javascript: Objects, Arrays, and Array-Like objects

I found this article extremely helpful, especially when dealing with Google Scripts. It is incredibly annoying to have what I think is an array not function like an array!

Speed up the process of entering grades

I have been plugging away with but while I am at work, I come up with ways to both practice Javascript and make my job a little bit easier. This is my most recent creation. Very simple concept, and very simple code, but it has already made my life significantly easier. Uses jQuery and jQuery-UI.

Any suggestions on how to improve this?

Units By Design… the easy way!

I used the Google Scripts service to create a template for the unit plans that we have to design at my school. I am still going to work on the program a little more, so I won’t put the code up here just yet. Right now I just want to test WordPress’s ability to embed the documents in posts.