Qazser's Practice Exam Tracker - Based on B^3's spreadsheet

[qazser]

Qazser's Exam Tracker

Firstly, thanks to B^3 for the spreadsheet. The original spreadsheet was out of date so I've given it a little bit of an update. Sorry in advance, this post is quite rushed, bit busy, will update soon

Original Features of B^3's Spreadsheet
1.Exam Statistics
2.Exam Predictor
3.Standard Exam Tracker

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

New Features of Qazser's Mod
1. Exam Timetable
2. Automation of Data
3. Updated VCAA Grade Distributions
4. Minor Tweaks to Grade predicting algorithms
5. Type of Errors
6. Weighting of exam scores(English/Methods/Specialist Maths)
6. Exam Organiser
7. Change in Interface colours and fonts

Exam Timetable
Basically time of Exam, Duration of Exam,Date

Automation of Data
In the old spreadsheet, grades and subject names/stats had to be manually entered. In the modded version, these have been automated. Simply enter your score and the rest of the spreadsheet will be automatically filled as such.

Tweaks to Prediction Algorithm
The old spreadsheet had several unnecessarily long code for predictions, slowing the spreadsheet functionality down. They have been changed so that the spreadsheet will function quicker and more efficiently. Additionally, scores on good/bad days have been  adjusted as well, drawing from the last 5 exams attempted and hence deriving a score. The algorithm to predict the expected score, score on good day and score on bad day have been 'nerfed' to mimic stress and other factors on the day of the VCAA exam. Their relative scores will not be as high as the scores you have been achieving for the exams you've recently completed as such.

Type of Errors
So far, they have only been implemented into Methods and Specialist Maths Spreadsheets. 3 types of errors have been categorised - Time, Content,Silly. Upon the completion of every exam you do, enter the marks lost to these mistakes and these will be visually depicted, in the form of Pie Charts,in the 'Maths Summary' spreadsheet.

Weighting of Exam Scores
Some companies write harder exams and hence standardising your scores from these exams to VCAA standard difficulty will give you a better insight on your progress.

English - Optional implementation. Enter company name and allocated difficulty into table. Ensure that company name entered into table matches company name in 'Exam' Column or algorithm will not work.

Methods/Spesh - Compulsory Integration. Exam companies and allocated difficulty have been pre-programmed into the spreadsheet. Integration will be changed to optional and customised in the next update, alike English.

Relative Exam Difficulties
VCAA - 1
Heffernan - 1
Insight - 1.1
NEAP/TSSM/MAV - 1.15
Itute/Kilbaha - 1.2

These difficulties have been 'chosen' based on the results of ~5 old exam trackers from past VCE students, consisting of ~200 exams or each exam in total.

Exam Organiser
Basic organiser for Methods/Spesh has been integrated. Consists of - Printed, Completed,Marked, Recorded - cells. Change to 'Y' if completed, making the cell turn green, 'P' if partially completed, making the cell turn yellow (I think) and leave it blank, turns red, if not yet completed.

Colour/Font Selection


Assuming that most of us will be using this spreadsheet at night, colours have been changed to minimise blue-light  exposure, allowing you to sleep better (How Thoughtful?). Colours have been changed to a less neon/shiny colour(Eg.Gray). Yet to change all tabs, will be implemented in next update.

Impending Updates
1. To finish Chemistry and Physics Spreadsheet
2. Days to Exam countdown
3. Additional Resources Spreadsheet
4. Implementation of other subjects (Suggestions welcome)
5. Colour change


The spreadsheet is unfinished at the moment and i will try to complete it as soon as possible, but here's a beta version for those that want to check it out:
https://mega.nz/#!HpEDFIhT!rG-EDK8Kw7y5IjUqOLUmMHdkXwD1QLkZFcGRXJUS-qs

Feel free to raise suggestions for further improvement/Errors found.


***ATARNOTES does not condone any illegal means of obtaining these practice exams. Please obtain these exams from your school. Alternatively, purchase them from the respective companies.

[clarke54321]

Great idea Qazser! 

[sweetiepi]

Brilliant stuff, qaser!

[Aaron]

Pretty neat stuff mate. Well done

[MightyBeh]

I love spreadsheet geekery. Excellent work Qaz. 

[qazser]

Thanks guys <3.

What other subjects should be implemented?

[MightyBeh]

Thanks guys <3.

What other subjects should be implemented?

I think further maths would be quite popular. Other than that, I have no clue

Also I think you made a few typos with the legal notice; it should say that 'ATARNOTES does not condone illegal means of obtaining practice exams'.

Seriously though great work, this is pretty awesome.

[HopefulLawStudent]

***ATARNOTES condones any illegal means of obtaining these practice exams.

Ermmmm...

EDIT: Just realised MightyBeh's already pointed it out. Whoops.

[Sine]

Thanks guys <3.

What other subjects should be implemented?

Biology seems the most logical since heaps of people do it in year 11 and have the chance of completing heaps of exams.