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.
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 plnnr.net 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.
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:
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.
- The first column is a category for the objective.
- The second column is a title for the objective.
- 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!
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!
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!
Any suggestions on how to improve this?
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.