October 23, 2019, 07:28:14 pm

### AuthorTopic: Practice Exam Tracker And Statistics (Spreadsheet) Version Pi- The FINAL Version  (Read 20107 times) Tweet Share

0 Members and 1 Guest are viewing this topic.

#### b^3

• Honorary Moderator
• ATAR Notes Legend
• Posts: 3530
• Respect: +627
• School: Western Suburbs Area
##### Practice Exam Tracker And Statistics (Spreadsheet) Version Pi- The FINAL Version
« on: July 15, 2011, 11:36:35 pm »
+32
Ok now before you mods move this, this has a right to be here since the methods students are the one who will use it most, spamming trial exams. It would have been posted in the notes section but the file types accepted is only .doc and .pdf not .xlsx.

A little while back I made a spreadsheet to keep track of my progress of practice exams in the lead up to mid year exams, I did post it up here somewhere. Anyway as a way of procrastination I altered it and now I give to you version $\pi$! It lets you enter in your marks for each practice exam you do and it will calculate and rank your subjects depending on your scores. It now has a score predictor based on a trendline that is generated as well as predictions for good and bad days. Anyway I thought it might be useful for some of you guys who spam practice exams, although alot of you probably have already started a while ago.

Feedback on the accuracy of the predictions are welcomed. It sucessfully predicted both of my midyear results for Chemistry - A and Physics - A+.

****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 now 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!

Ok now before you read on I would like to remind you that you should throughly understand the content of the course before you start practice exams. Also there is no point in doing a load of exams if you do not learn from your mistakes, go through each question you got wrong, work out why you got it wrong and do it again.

If you have any questions don't be afraid to ask, just make a post in this topic.
Any ideas for any new features are also welcome.

Here are a couple of screenshots (using made up data).

Note: If you are not a member you may need to register to download the file.
http://www.atarnotes.com/register.php

***NOTE***
There may be issues if run on a MAC, unfortunately I cannot find a fix for the issues but it is still functional, just not entirely.

Note: This spreadsheet and it's creator does not endorse illegally obtaining exams. Use at your own will.

Previous Versions Information
*********Version $\to \pi$ (approaching pi)*********
Ok guys, I finally worked out how to get the trendline equation work correctly. You can now enter in how many more exams you plan on doing and it will give a prediction based on the trendline of your score (percentage not study score) on a good, normal or bad day. Also there is an option to put in your desired score and it will calculate (again based on the trendline) how many more exams you need to do to acheive that score. Have fun guys & girls.

**********Version 3.1415926535 - More than just the Asian five**********
Ok here is the latest version. It has been updated so there is a quick rename of subjects and exam sections allowing you to change from just the asian five subjects. Also added is a comparison of the means and sd of the section of each exam relative to each other. NOTE: Not all the subjects you do may fit so if you cannot make everything work or run out of sheets with the right number of sections.

**********Version 3.14159**********
Ok now I have altered the Exam tracker. The version jumps version 3 because I think I kinda over did it on that one. It did have a trendline on each graph for each subject which you could use to predict your score after so many exams, and how many exams you would need to do to obtain that score but it was getting too complicated and was making too many things for you, the user to enter and change. So thats got the axe. For version 3.14159 I have added 3 charts, one to track the amount of exams for each subject, and two for the subjects split into science and maths. Also added is the automatic counting of the number of exams completed but to make the graphs scale you will need to do a sort of "refresh" on the summary page. Anyway this should be the last version so enjoy!

V2.01: Slight change to instructions to stop colour rating system malfunction.

DISCLAIMER: This is only a prediction of your result on the day based off your previous results. A variety of different factors plays a part in your performance on the day, so do not rely on this prediction.
« Last Edit: October 01, 2013, 12:05:46 am by b^3 »
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES:

Co-Authored AtarNotes' Maths Study Guides

I'm starting to get too old for this... May be on here or irc from time to time.

#### taiga

• Honorary Moderator
• ATAR Notes Legend
• Posts: 4104
• Respect: +585
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #1 on: July 15, 2011, 11:46:35 pm »
0
I love you and this idea

To general VCE and sticky, what do ya think?
vce: english, methods, spesh, chemistry, physics, geography.

tutoring in any vce maths.

2010: Melbourne High School (VCE)
2011 - 2016: Monash University BComm/BEng (Hons)

If you guys have any concerns/suggestions for making ATARNotes a better place, don't hesitate to PM me.

#### b^3

• Honorary Moderator
• ATAR Notes Legend
• Posts: 3530
• Respect: +627
• School: Western Suburbs Area
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #2 on: July 15, 2011, 11:49:29 pm »
0
I would say sticky it but do you think it will get more traffic on general vce or here on methods? anyway its your choice.
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES:

Co-Authored AtarNotes' Maths Study Guides

I'm starting to get too old for this... May be on here or irc from time to time.

#### taiga

• Honorary Moderator
• ATAR Notes Legend
• Posts: 4104
• Respect: +585
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #3 on: July 15, 2011, 11:51:54 pm »
0
Well it applies to everyone, and Gen VCE gets more traffic I believe
vce: english, methods, spesh, chemistry, physics, geography.

tutoring in any vce maths.

2010: Melbourne High School (VCE)
2011 - 2016: Monash University BComm/BEng (Hons)

If you guys have any concerns/suggestions for making ATARNotes a better place, don't hesitate to PM me.

#### b^3

• Honorary Moderator
• ATAR Notes Legend
• Posts: 3530
• Respect: +627
• School: Western Suburbs Area
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #4 on: July 15, 2011, 11:52:51 pm »
0
Ok then it'll be good to move it and sticky. Go ahead.
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES:

Co-Authored AtarNotes' Maths Study Guides

I'm starting to get too old for this... May be on here or irc from time to time.

#### Romperait

• Victorian
• Posts: 511
• Respect: +51
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #5 on: July 15, 2011, 11:54:50 pm »
0
Very nice!

#### enwiabe

• Putin
• ATAR Notes Legend
• Posts: 4424
• Respect: +528
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #6 on: July 15, 2011, 11:56:03 pm »
0
Great work! Very impressed.

#### b^3

• Honorary Moderator
• ATAR Notes Legend
• Posts: 3530
• Respect: +627
• School: Western Suburbs Area
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #7 on: July 15, 2011, 11:58:05 pm »
0
Thanks guys, see what happens when I continually put chemistry off, procrastination has it's positives (srs though I have to get it done). Oh well there is always tomorrow. I have put the work off all holidays, instead doing practice exams for methods.

If i need something else to do, i'll work on v3.0. What I have planned is adding graphs and working out say the trendline for the last couple of exams you did for each subject and then using the gradient to see whether you are heading in the right direction, where you are improving the most and what you need to work on, say mc section or whatever. Anyway i'll see if I get bored one day.
« Last Edit: July 16, 2011, 12:02:21 am by b^3 »
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES:

Co-Authored AtarNotes' Maths Study Guides

I'm starting to get too old for this... May be on here or irc from time to time.

#### Andiio

• Victorian
• Part of the furniture
• Posts: 1211
• Respect: +14
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #8 on: July 16, 2011, 12:05:38 am »
0
I love you; I'm so bad with Excel.
2010: Chinese SL [43]
2011: English [47] | Mathematical Methods CAS [41]| Specialist Mathematics [38] | Chemistry [40] | Physics [37]
ATAR: 99.55

#### sam.utute

• Victorian
• Part of the furniture
• Posts: 1412
• Connecturer.
• Respect: +46
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #9 on: July 16, 2011, 12:39:10 am »
0
Very, very nice!
A must have for all students!
Good job mate!

• Honorary Moderator
• ATAR Notes Legend
• Posts: 3174
• Respect: +323
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #10 on: July 16, 2011, 12:50:04 am »
0
This is pure awesome work.

I'll probably make a few changes to suit my preferences rather than use it as is. I focus a bit more on questions that I got wrong rather than going through and looking at percentages. I'm also lazy and can't be bothered typing in the names of the trial exams. So yeah, my additions would be along the lines of an easier to use, more automated interface and keeping track of the type of errors I make. I should have about 3 weeks of doing boring learning to use excel work in ITA so this should count as legitimate work to do for that .

#### b^3

• Honorary Moderator
• ATAR Notes Legend
• Posts: 3530
• Respect: +627
• School: Western Suburbs Area
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #11 on: July 16, 2011, 12:58:07 am »
0
Do whatever works for you, as for focussing on questions you got wrong, what I am doing is I have another book that after each exam every question and that means every question I get wrong, even if it was a silly mistake like 1+1=3 or just I was on the wrong track, I redo it and get it right. I was trying to write a macro into it so that it would resort the subjects in terms of rank as soon as you opened that sheet. And also could add an automatic letter grade depending on the grade distributions, which would require a year column. Anyway I'm sure i'll need a breal at some point before exams so it'll probably get changed.
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES:

Co-Authored AtarNotes' Maths Study Guides

I'm starting to get too old for this... May be on here or irc from time to time.

#### TrueTears

• TT
• Honorary Moderator
• Great Wonder of ATAR Notes
• Posts: 16365
• Respect: +654
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #12 on: July 16, 2011, 01:20:52 am »
0
this looks mad, how long did it take you to make on excel?
Currently studying: PhD in economics at MIT.

Interested in financial economics, econometrics, and asset pricing.

#### b^3

• Honorary Moderator
• ATAR Notes Legend
• Posts: 3530
• Respect: +627
• School: Western Suburbs Area
##### Re: Practice Exam Tracker And Statistics (Spreadsheet)
« Reply #13 on: July 16, 2011, 01:27:40 am »
0
Well I originally whipped up only the physics and chem unit 3 pages for the mid years exams a month or two ago which took idk 30mins. Then this holidays I added the methods page, everything else, the stats and other subjetcs I added tonight, well it is yesterday now. Setting everything else up took 1-2 hours since I had to set everything up and copy the grade distributions over. I wasted 1 hour of that two hours on trying to get the stupid macro to work and still didn't get it in the end.
« Last Edit: September 03, 2011, 01:49:56 pm by b^3 »
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES:

Co-Authored AtarNotes' Maths Study Guides

I'm starting to get too old for this... May be on here or irc from time to time.

#### b^3

• Honorary Moderator
• ATAR Notes Legend
• Posts: 3530
• Respect: +627
• School: Western Suburbs Area