Thanks everyone. Well if it isn’t totally obvious, I made this system for myself. I got fed up with the deficiencies of BCeSIS and the bugs in MyEdBC / Aspen. I noticed that a LOT of teachers keep two copies of their marks, a spreadsheet (or paper/pen markbook) and then migrate those marks over to their SIS when its time. Everyone likes like power and near unlimited possibilities of a spreadsheet. My idea was, well why not make my own SIS that IS a spreadsheet? Actually it started off as a coding experiment, I just wanted to learn how to use Google Apps Script. But it turned into something a lot bigger.
Thats not all either, I also made an online test system based on Google Forms and a spreadsheet, it marks it for you too and emails the student their result. 🙂