Practice Exam Tracker And Statistics (Spreadsheet) Version Pi- The FINAL Version

[Vincezor]

Haha this is amazing! I'll probably need to spend some time working this out

It's so much more complex than my spreadsheet that I use at the moment (and for midyears). Mine only calculated the average percentage across each year and each company, as well as overall

Good work b^3, must have taken a while to make! appreciate the good work and keep it up

[onur369]

That is epic, things like this actually motivate me!

[b^3]

The attachment link disappeared. Fixed it now. Also it's good to know that it's being put to good use. Good work guys 

[pi]

The attachment link disappeared. Fixed it now. Also it's good to know that it's being put to good use. Good work guys 

This is too awesome

Brilliant work!

Would it be possible to make a tutorial on creating pages, etc. so people who do accounting, psych, etc. can add their subjects? Or better, add like a few blank subject pages (say 3-4) that are linked to all the sats and summaries so that a bit of customisation is possible for non azn-5 ppl?

Great job, again

[b^3]

Yeh i can give it a go, but not right now German Grand Prix starts in 10 mins. Probably in the next couple of days so check back, but ill leave this version here aswell. Dam, it won't be version 3.14159 (pi) anymore, hmm what could I use instead.

Just so I know, what kind of sets of questions are there for other subs, like methods has an exam on only short answer than one with MC and ER while physics has three sections and chem has MC and SA?

And just so I know Rohitpi the bold blue and red text is probably what caught your attention right?

[pi]

Dam, it won't be version 3.14159 (pi) anymore, hmm what could I use instead.

Next decimal place, 3.141592 Can never get enough pi

Just so I know, what kind of sets of questions are there for other subs, like methods has an exam on only short answer than one with MC and ER while physics has three sections and chem has MC and SA?

I'll look this up on VCAA, I'll report back here later (maybe not today though)

And just so I know Rohitpi the bold blue and red text is probably what caught your attention right?

Yep

[b^3]

Updated to Version 3.1415926535 to include customisation for more subjects. Read Original Post. http://www.atarnotes.com/forum/index.php?topic=43219.msg449701#msg449701

[taiga]

Just had a look at the revised edition, definitely more people should download it. I'll see if we can get general vce study guides/files onto the notes section of the forum as well (though there might not be that many things which can apply across the board).

[b^3]

Thanks Taiga, and it looks like there are less downloaded than actuall have, since the attachments disapperead in the update, It lost 20 or so and then everytime I update the version with a new file it resets to 0.

I'm still trying to think of new updates for it. I really wanted to make the trendline/mark predictor and vice versa work but no luck. If I can get it to work I could add say a mark range for you on a good day or a bad day with say 10% either side of the predicted mark. Also what would you guys think of say a summary paragraph for each subject that changes after every exam. Saying things like you are strong in ____ but need to improve on _____ while you are most consistant in __________. Or would it just be useless information that most of us should be able to see from the data (as most of us should know what sd and things mean).

[b^3]

Finally got the trendline and score predictor/desired score to work. Working on it now. I will update the file in the next couple of days.

[b^3]

Ok I have updated to Version approaching pi. This includes more statistics on the data, creating trendlines and predicting you scores based on how many exams you plan to do on good and bad days. Also has a 'desired score' entry to work out how many exams you need to do to acheive the score you want. For more information and to download the updated version read the original post. Practice Exam Tracker And Statistics (Spreadsheet) Version appproaching pi

Also what do you think of the updated version?

[b^3]

IGNORE THIS SORRY

[b^3]

****VERSION Pi - The Final Version****
After a lot of small/medium updates I have finally got it how I want it. This will be the FINAL version. You know don't have to manually copy down formulas, the cells clear themselves and use the relevant formula automatically. There are other small fixes here and there. Anyway, for the last time, Enjoy!

Practice Exam Tracker And Statistics (Spreadsheet) Version Pi- The FINAL Version

[Andiio]

I'm really bad with Excel haha - how do I 'sort' all the stuff on the Stats page with a Mac?

[b^3]

After a quick bit of googling I don't think there is anyway of making it work properly on a Mac, the autofitler options are the way it works are different on a mac (apparently). Sorry but I don't think I can help you there due to Mac Excel's setup. Does everything else work? As in can you still use it without ranking the subjects?