Post by: b^3 on July 15, 2011, 11:36:35 pm
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
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).
(http://img193.imageshack.us/img193/2476/prt1.png)
(http://img41.imageshack.us/img41/5945/stastupdated.png)
(http://img151.imageshack.us/img151/1388/predictions.png)
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
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.
Post by: taiga on July 15, 2011, 11:46:35 pm
To general VCE and sticky, what do ya think? :)
Post by: b^3 on July 15, 2011, 11:49:29 pm
Post by: taiga on July 15, 2011, 11:51:54 pm
Post by: b^3 on July 15, 2011, 11:52:51 pm
Post by: Romperait on July 15, 2011, 11:54:50 pm
Post by: enwiabe on July 15, 2011, 11:56:03 pm
Post by: b^3 on July 15, 2011, 11:58:05 pm
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.
Post by: Andiio on July 16, 2011, 12:05:38 am
Post by: sam.utute on July 16, 2011, 12:39:10 am
A must have for all students!
Good job mate!
Post by: Lasercookie on July 16, 2011, 12:50:04 am
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 :).
Post by: b^3 on July 16, 2011, 12:58:07 am
Post by: TrueTears on July 16, 2011, 01:20:52 am
Post by: b^3 on July 16, 2011, 01:27:40 am
Post by: b^3 on July 17, 2011, 11:23:53 pm
Post by: Vincezor on July 20, 2011, 09:11:27 pm
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 :D
Good work b^3, must have taken a while to make! appreciate the good work and keep it up :D
Post by: onur369 on July 20, 2011, 09:20:46 pm
Post by: b^3 on July 24, 2011, 01:31:35 pm
Post by: pi on July 24, 2011, 09:45:15 pm
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 :)
Post by: b^3 on July 24, 2011, 09:50:38 pm
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?
Post by: pi on July 24, 2011, 09:56:56 pm
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 :D
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 :)
Post by: b^3 on July 25, 2011, 01:41:17 pm
Post by: taiga on July 30, 2011, 01:30:24 pm
Post by: b^3 on July 30, 2011, 01:42:01 pm
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).
Post by: b^3 on August 04, 2011, 11:30:44 pm
Post by: b^3 on August 05, 2011, 05:26:12 pm
Also what do you think of the updated version?
Post by: b^3 on August 08, 2011, 05:27:08 pm
Post by: b^3 on August 08, 2011, 05:29:07 pm
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
Post by: Andiio on August 13, 2011, 02:45:48 pm
Post by: b^3 on August 13, 2011, 03:12:11 pm
Post by: tigerfan11 on September 03, 2011, 12:14:20 pm
After i clear the cells using the tabs down the bottom and entering my subjects in the setup page, what is the next step ? I think i have to assign grade distributions for each subject but not entirely sure.
Thanks in advance
Post by: b^3 on September 03, 2011, 01:47:06 pm
2006: http://www.vcaa.vic.edu.au/vce/statistics/2006/statssect3.html
2007: http://www.vcaa.vic.edu.au/vce/statistics/2007/statssect3.html
2008: http://www.vcaa.vic.edu.au/vce/statistics/2008/statssect3.html
2009: http://www.vcaa.vic.edu.au/vce/statistics/2009/statssect3.html
2010: http://www.vcaa.vic.edu.au/vce/statistics/2010/statssect3.html
Next to do is to start filling in the practice exams as you do them. Only enter data in the ( ) marks and ( ) total columns, everything else should work itself.
Post by: b^3 on September 03, 2011, 01:59:51 pm
(http://i54.tinypic.com/2gt3q86.png)
(http://i55.tinypic.com/2h4jpts.png)
Post by: tigerfan11 on September 03, 2011, 07:58:17 pm
Post by: b^3 on September 06, 2011, 04:55:46 pm
NOTE: I will no longer be offering to create custom spreadsheets as it takes too much time to fix up everything. Hopefully the built in customisation can do the job for you guys.
Post by: Daniel15 on September 22, 2011, 11:33:53 pm
Post by: elul on September 28, 2011, 11:42:40 pm
Post by: ExamStorm on September 29, 2011, 11:15:54 pm
Post by: abzzzz on October 01, 2011, 11:42:20 pm
Post by: thatisanote on October 05, 2011, 07:50:09 pm
Any chance you could add a sheet for english? I think most people would find that useful :)
Post by: b^3 on October 05, 2011, 07:56:03 pm
Post by: b^3 on October 05, 2011, 08:02:56 pm
Post by: chrisjb on October 05, 2011, 11:03:49 pm
AND i've started to notice wierd trends, like in every one of my subects that I've done 5 or more exams for, the 4th exam is done badly (In english, Economics and International studies they all got worse in the 4th exam, then got better again on the 5th)
GO B^3!! WOOOH!
Post by: b^3 on October 05, 2011, 11:07:26 pm
b^3, this thing is so freakin cool! It's so much fun to do an exam then put the numbers in! and I've colour coded the collumns that I put the exams in, the first 5 or so are blue to signifiy that I'm just getting into the groove, then the next 5-6 are green which is where I want to be getting A+s by, then the next ones after that are gold to signify the point at which I would like to reach my target score.Good to know that you are having fun with it and analysing your exam trends as much as I have been. Keep it the good work :).
AND i've started to notice wierd trends, like in every one of my subects that I've done 5 or more exams for, the 4th exam is done badly (In english, Economics and International studies they all got worse in the 4th exam, then got better again on the 5th)
GO B^3!! WOOOH!
Post by: sk1595 on April 04, 2012, 01:09:33 pm
B^3, amazing job. It works brilliantly. The only question I have is, how can I add a 6th subject to spreadsheets??
Post by: b^3 on April 04, 2012, 07:56:15 pm
The reason why I only made 5 slots is because of English, kinda because I didn't fell that I would get enough english exams done to make it worth putting it in, that was me though, didn't account for it. So if it doesn't fit, then I'd suggest excluding english in one and say, making another copy of the file, clearing each sheet out and just filling one up for english. Sorry about that. Also note that the predicition is just a prediction, there is no guarentee, its more there just to see if you are improving or staying the same, and too see which sub jects you need to work on more.
Hope that helps :)
Post by: InsaneMcFries on April 05, 2012, 02:35:58 am
Post by: Bill Ding on April 21, 2012, 12:00:14 pm
Post by: Yohann on September 06, 2014, 09:26:36 pm
Thanks very much
Post by: LiquidPaperz on September 06, 2014, 11:34:12 pm
just downloaded this thing and am really confused on how to use it so could someone explain how to use this thing in simple language
Thanks very much
same here haha
Post by: SE_JM on January 19, 2015, 04:53:33 pm
When you type in desired score on the Predictions tab (i'm referring to the methods exam 1 and 2 subjects)
Do you type in the marks (160 downwards for exam 2 and 80 downwards for exam 1) or the percentage (100% downwards?)
I'm kinda confused. If i type in the marks for exam 2, it seems to work alright but not when i type in marks for exam 1
Thanks
I really hope someone finds this and answers. Apparently, this topic hasn't been posted for more than 30 days... :o