- Creating a Google Spreadsheet with multiple sheets
- Using data validation to create drop-down menus
- Using the VLOOKUP formula
- Installing and using a free mail merge apps script
- Hiding columns
While this may already sound like a daunting task, the investment of time to create the first spreadsheet will certainly pay off as it can easily be copied and tweaked for additional rubrics. In addition, the added bonus of being able to collaborate on Google Spreadsheets allows multiple teachers to work together to build their working rubrics.
Below are the tutorials I put together to demonstrate this process.