As I continue to work toward a useable gradebook in Google Sheets, I am tweaking the scripts along with it. One of the things I want this gradebook to do is to create progress reports or report cards based on 1st, 2nd, 3rd, or 4th 9 weeks, with no coding from me. To facilitate that, I have created global variables for the entire cumulative gradebook sheet. Here is an example of the code for those global variables.
The numbers correspond to column numbers in the spreadsheet. For the global variables, there are about 125 lines of code. This includes the templates for the progress reports, i.e. 1st, 2nd, etc.
My favorite part of this script is the Custom Menu. I have created a function for each of the nine weeks progress reports. Then in the menu, I have submenus which allow you to run each of the functions (separate scripts). Here's what the menu looks like:
The customizability of this function means that as a coder (VERY novice), you can create functions in Google Docs which will allow "non-techie" users to feel comfortable using them. This gets me excited! As long as I am comfortable creating (or stealing) code for some function, I can do pretty much anything I want in Google Docs.