Not only is the SUMPRODUCT formula cleaner, it also updates automatically if you choose to change the weight of a grade. SUMPRODUCT: On the first sheet of the Master Gradebook (‘Master’), I calculated weighted grades using the SUMPRODUCT function rather than a basic mathematical formula – i.e.If, however, you’re learning Sheets/Excel as you go (like me), here are some of the nifty formulas that make things work in the spreadsheet. If you’re comfortable with Google Sheets/Excel, feel free to download and open up the grade books and start adjusting them to suit your own needs. There is a “Master Gradebook” that compiles the grades of all students and an “Individual Grades” template that can be endlessly reproduced and adjusted depending on the number of students you have. These are particular to the needs of my class, but should provide a decent foundation that can be customized for any classroom. The files below can be used as templates. As my dissertation project touches on the Internet’s potential to produce collaboration and encourage transparency about how ideas, objects, and knowledge are produced, I thought I’d share what I’ve made in the hopes of demystifying the process and improving it through collaboration with yet-unknown others. In the end, I cobbled something together using basic functions in Google Sheets. (Javascript is, unfortunately, a bit beyond me at the moment.)
In particular, I found some elements’ of Anthony’s Google Sheet/Script Editor app helpful (the code is, alas, too buggy to use) and I appreciated the assistance of a few good souls at Stack Overflow who suggested fixes for the code. I didn’t quite find what I was looking for, but I did find lots of piecemeal instructions that allowed me to create what I needed. I hoped to use Google sheets, as I already run activities and assignments through Google Forms in class and I’m encouraging the use of Google Docs for students’ group writing projects this semester. I was looking for something intuitive (for me) and accessible by individual students (obviously I don’t want them to see everyone’s grades). Over the weekend, I went hunting for a gradebook to incorporate in my class website.
0 kommentar(er)
