GA SCORE ESTIMATOR / STUDY SCORE ESTIMATOR

[Mao]

SS ESTIMATOR/GA ESTIMATOR


GA SCORE ESTIMATOR - 31/10/2008
I cant sleep, so I made this.

this spreadsheet approximates [VERY ROUGHLY] what you need to achieve in a GA to get a desired SS. I should've made it earlier in the year, but hell, it's here now. you can now set realistic exam goals during last minute revision

so here's the steps:

1) http://www.vcaa.vic.edu.au/vce/statistics/2009/statssect3.html - find your subject*
2) get to the page of the GA you want [exams are typically the last GA(s)]
3) put in the relevant info into the spreadsheet
4) look at the score it spits out, now study hard [if you want to know what grade that is, double it and refer back to the grade assessment table]
5)
6) PROFIT!!!


EDIT: I've added SS estimation from grades because I'm bored. (31/10/2008)

1) http://www.vcaa.vic.edu.au/vce/statistics/2009/statssect3.html - find your subject*
2) get to the page of the GA you want [exams are typically the last GA(s)]
3) put in the relevant info into the spreadsheet (this time, info on all three GAs)
4) put in the relative weighting of each GA. If you do not know how your subject's assessments are weighted, consult the study guide [can be found from http://www.vcaa.vic.edu.au/vce/studies/index.html] or ask someone.
5) look at the score it spits out, now study hard
6)
7) PROFIT!!!

enjoy =]


DISCLAIMER: this thing is not entirely accurate. Please don't assume it is...

* Note, for mid-year subjects use the current year grade distribution (found in the current-year statistics page)

[PS, I love you enwiabe, I've slapped a vcenotes.com link on it, haha]

[PPS: this thing has no error handling capabilities whatsoever, so if you put in a stupid number, it will give you a stupid result. simple garbage in, garbage out.]

[PPPS: someone sticky this this will solve all the "I GOT A+ A+ A, WHAT SS IS THAT???" questions (i hope), but it will also probably put the fellow SS-ESTIMATORs out of jobs...]

[PPPPS: I've had a few complaints over compatibility, so here's both office 2007 .xlsx and 2003.xls versions, and protection has been relaxed a bit]

[danieltennis]

Cool

[enwiabe]

... Mao, this is ridiculous. I love you too, man

[humph]

Go to bed!

[enwiabe]

Mao does EL, not normal English.

[bucket]

he does normal english too

[enwiabe]

Nah he dropped it... or so he told me. I hope I'm not imagining that...

[dekoyl]

This is pretty nice. There's the ENTER Calc and now this too.
Great work Mao.
Thanks and good luck.

[psychlaw]

I think he still planned to do the normal english exam

[NE2000]

Now this needs to be merged with the ENTER calculator to have a complete, 'enter your marks and here's your ENTER' calculator...

[Mao]

Now this needs to be merged with the ENTER calculator to have a complete, 'enter your marks and here's your ENTER' calculator...

thought about it, but I do not have the proficiency in java to do that.... nor am I familiar with daniel's source code so it might take a while [if not impossible]

though I'm thinking about it... might be something to do when I'm bored and waiting for offers

[in the meanwhile, I'm working on another excel spreadsheet to predict SS from grades, the accuracy of this would be even more atrocious, haha]

[NE2000]

I made something similar a couple of months back using the mean and standard deviations. Basically, you feed in results and statistics for each GA and then establish a standard score based on your results that is essentially how many standard deviations off the mean your scores are. Then just average the results. The problem is I think it doesn't work the same on all subjects, because after you get your standard score VCAA ranks your standard score again to get a new mean and standard deviation. For subjects like biology where the A+ mark has traditionally been low, there is greater potential for a higher standard score...whether the people that get 50 max out that potential is a different matter I guess.

Anyway, then the standard scores would optimally be calibrated against known results and corresponding study scores. The problem with that is that few people get their statement of marks at the end of the year. All I know is a standard score of around 1.40 can get you a 40 and a standard score of 2.00 can get you a 50....If there are more real-life examples you could develop a good study score calculator that is quite accurate.

[excal]

Now this needs to be merged with the ENTER calculator to have a complete, 'enter your marks and here's your ENTER' calculator...

thought about it, but I do not have the proficiency in java to do that.... nor am I familiar with daniel's source code so it might take a while [if not impossible]

though I'm thinking about it... might be something to do when I'm bored and waiting for offers

[in the meanwhile, I'm working on another excel spreadsheet to predict SS from grades, the accuracy of this would be even more atrocious, haha]

It's PHP and JavaScript (for DHTML)

[Mao]

I made something similar a couple of months back using the mean and standard deviations. Basically, you feed in results and statistics for each GA and then establish a standard score based on your results that is essentially how many standard deviations off the mean your scores are. Then just average the results. The problem is I think it doesn't work the same on all subjects, because after you get your standard score VCAA ranks your standard score again to get a new mean and standard deviation. For subjects like biology where the A+ mark has traditionally been low, there is greater potential for a higher standard score...whether the people that get 50 max out that potential is a different matter I guess.

Anyway, then the standard scores would optimally be calibrated against known results and corresponding study scores. The problem with that is that few people get their statement of marks at the end of the year. All I know is a standard score of around 1.40 can get you a 40 and a standard score of 2.00 can get you a 50....If there are more real-life examples you could develop a good study score calculator that is quite accurate.

umm, for study scores, mean = 30, sd = 7

[NE2000]

I made something similar a couple of months back using the mean and standard deviations. Basically, you feed in results and statistics for each GA and then establish a standard score based on your results that is essentially how many standard deviations off the mean your scores are. Then just average the results. The problem is I think it doesn't work the same on all subjects, because after you get your standard score VCAA ranks your standard score again to get a new mean and standard deviation. For subjects like biology where the A+ mark has traditionally been low, there is greater potential for a higher standard score...whether the people that get 50 max out that potential is a different matter I guess.

Anyway, then the standard scores would optimally be calibrated against known results and corresponding study scores. The problem with that is that few people get their statement of marks at the end of the year. All I know is a standard score of around 1.40 can get you a 40 and a standard score of 2.00 can get you a 50....If there are more real-life examples you could develop a good study score calculator that is quite accurate.

umm, for study scores, mean = 30, sd = 7

But if it were that simple then wouldn't an average standard score of 2.0 only get you a 44 because it simply means you were two standard deviations of the mean? If that's the case then it isn't that simple :S