So, i’ve had Excel on my computer for ages but i’ve never really needed it for anything before. But now i’d like to use it to track and calculate the grades for any classes that i teach.
I tried setting up a basic spreadsheet for one class, and for the most part everything went fine. But i couldn’t work out for the life of me (even after reading the instructions and doing a web search) how to apply a formula so that it works the same for multiple rows.
Here’s the deal:
The class has four separate assignments or categories, each of which receives a grade. The final grade is determined by looking at all four of those grades. Each assignment is weighted as a certain percentage of the final grade:
Assignment 1: 10%
Assignment 2: 25%
Assignment 3: 25%
Assignment 4: 40%
For a total of 100%
So, i have a spreadsheet where Column A is Assignment 1, Column B is Assignment 2, and so on. And into each of those columns i put down a numerical representation of each student’s letter grade, where A=4, B=3, and so on.
Column E is where i want to put the students’ final grades.
Now, i know that to get the spreadsheet to calculate a final grade for the student in row 1, i need the following equation:
=(0.1A1)+(0.25B1)+(0.25C1)+(0.4D1)
This works fine, and i have no trouble getting a result. But, with my current level of knowledge, all i know how to do is repeat this operation for every single row. Surely there’s an equation i can put in somewhere so that, for every student in the class, their final grade will automatically appear in Column E once i enter all the other values.
I’m sure this is a completely remedial operation, but i swear i couldn’t find an answer after quite a lot of searching and swearing. If anyone could alleviate my ignorance and my frustration, i’d be most grateful.