After opening the prediction thread to find multiple people asking for full sets of subjects, I snapped and decided to write an excel spreadsheet to calculate things for people because tbh it's a lot less effort lol**How to use the spreadsheet:**Right now, it's set to view permissions so nobody breaks it. At the top, click "File>Make a Copy" to make a copy of it to your own Google account. You can edit the spreadsheet there. Also, some of you might not be used to sheet terminology - when I say "cell", I'm referring to those rectangle-like boxes you can write things into.

From there, everything you need to do is in the first tab - titled "Study Score Calculator"

In the red cells, list your subjects. As you start to write your subject, it should appear on the list - select your subject from that list. You can also just click each arrow on the right of the cell and select your subject from the drop-down list. If your subject isn't there, I haven't added it yet. See below for why

In the green cells, list your subject scores

**AS PERCENTAGES**. If you don't, it won't work. Note that the first column should have graded assessment 1, the second column should have graded assessment 2, and the third should have graded assessment 3. If you don't know what these are, look them up, they'll be listed in the study design of the subject - just open it up, and ctrl+f "graded" and it should pop up. Usually, GA1 is unit 3 SACs, GA2 is unit 4 SACs, and GA3 is the exam - but this is not always the case, particularly for subjects with multiple exams.

Finally, your predicted study score should appear in the blue cells.

I've included some examples on the calculator so you can see how things should be entered.

GA1 for mathematics subjects is slightly different and stupid, so see the second calculator in the yellow cells for how to calculate GA1 for a maths subject

**Let it be known - it was taking far too long to do every single subject that VCAA offers, so I decided to just do a few I've seen being asked and left it at that. If there's a subject you want added, post below, and I will add it. But also, it's not hard to do, so feel free to add your own subjects yourself in the tab titled "Subject Grade Distributions 2019". You'll find the data you need in the 2019 grade distributions to fill everything out. The spreadsheet should be able to handle everything from there. (I'm likely still adding subjects as you're reading this topic lol)****How the spreadsheet works:**All of VCE basically operates on a bell curve. No, really, all of it. The reason for this is because of a statistical phenomena called "Central Limit Theorem". It's actually kinda really cool.

If we use the grade distribution data, we can then convert your graded assessments so that we know where you lie on the bell curve. This is called a "z-score"

By multiplying each z-score by their appropriate weightings and adding them together, this tells us where you'd lie on the subject's final z-score.

From there, we just multiply the final z-score by the mean and standard deviation of the raw study score (this is 30 and 7 for all subjects), and this gives you a predicted raw score.

Fun fact: this is almost the exact method VCAA uses to calculate your study scores. The only difference is they re-distribute your score after finding your final z-score, instead of just converting it to the raw score distribution like I do.

**Limitations of this spreadsheet:**Nobody has pinpoint prediction accuracy. Even though this calculator will give you an exact score, take it with a grain of salt - expect it to be off by up to 3 points in any direction.

This method particularly has issues at the upper-end. This is because the graded distributions aren't true normal distributions, because they're cut off at 100%. To highlight these, you'll notice the Accounting example actually has 100% listed for every GA - and comes out with a final study score of 43. Ooft.

This method assumes your SAC scores won't change. The good news is, if you're rank 1, and your exam scores are higher than your SACs, your SAC scores likely won't scale down. However, if you're not rank 1, then it depends on how good your school is. If you're in the top 50%, and your school usually averages a raw score of more than 30 in that subject, your score likely won't go down. If you're not in the top 50%, or your school usually averages below 30 - that doesn't mean your SACs will go down, but I can't guarantee they won't go down. Sorry about that.

Like my fifth subject calculations that I recently posted - this spreadsheet uses data from 2019. This will change from year to year, so even if my calculator nails what your 2019 score would've been, if the distribution for your subject changes too much in 2020, then this score will be completely different to what your 2019 score was.

Finally, this spreadsheet is basically only for checking you're on track. Remember it's flawed, and if you're doing particularly well it's likely underestimating your score (for real - if you get 100% in all of your scores, and they don't change, you will get a 50 - not a 43).

(also, people who did VCE last year and have your scores saved somewhere, I'd love to use them to benchmark the spreadsheet to see how accurate/precise it actually is - send me a PM! And if the spreadsheet ends up being particularly bad, I'll make another post in this topic telling you all to stop using it)

Important to note: This spreadsheet is for 2020 use ONLY. The weightings are based on the ones in the 2020 study designs, which were changed because of COVID. Future years will require me to fix that part of the spreadsheet