Report Cards: Released

With report cards out on the 1st of December, we're going to use what we've learned and some new information about Excel to create a layout for our marks over the next three terms. This will help us see where we're at right now in terms of reaching our goals, and how we'll reach them in time.

Thus far in our journey towards conquering Excel we've always been given the question, we just had to find the answers. However for this assignment WE had to create the questions. Remembering that excel will give the answers as long as you can come up with the correct questions to ask.

So to start off we made a column with our Subjects, and Marks in the First term. Then we went on and decided our goals for our Final mark (Term1, 2, 3 average) in a separate column. To see what we had to get in the second and third term to achieve our goal as the Final mark we had to create a formula in both the columns, Term 2 and 3.

This was TRICKY STUFF! In the end though after moving numbers around and doing the 'dummy' test, I came up with good formulas for both columns.

Term 2: Take your goal, and subtract the 1st term mark from it. It should look something like this (E4 - B2). Remember though that there are three terms, so divide your term 1 marks by 3.
=(E4-(B2/3). This should give you the percent remaining to make your goal, we have two more terms left to follow through with that percent so we'll divide the formula so far by 2 =((E4-(B2/3))/2). Now we have the percent remaining in both terms, however we need to convert this into a mark for the second term so we'll just multiply the whole formula by 3 cancelling out the percentage and giving us our 2nd term mark. =((C4-(B2/3))/2)*3

Term 3: This time we'll take our 2nd term marks and subtract them from our goal. We'll follow exactly the same steps done in term two except we'll replace term 1's marks with term 2.
It should end up looking like this: =((E4-(C2/3))/2)*3

Dummy Column: use 100 as the goal and the first term mark, if your formula gets 100 in the other two terms your formula works!

There's still a lot to be learned! Ganbatte Ne~?

--Amna