Login

Welcome, Guest. Please login or register.

March 28, 2024, 07:28:32 pm

Author Topic: Practice Exam Tracker And Statistics (Spreadsheet) Version Pi- The FINAL Version  (Read 28383 times)  Share 

0 Members and 1 Guest are viewing this topic.

tigerfan11

  • Victorian
  • Trailblazer
  • *
  • Posts: 37
  • Respect: 0
0
Awesome program except im having trouble adding my specific subjects to it.
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

b^3

  • Honorary Moderator
  • ATAR Notes Legend
  • *******
  • Posts: 3529
  • Overloading, just don't do it.
  • Respect: +631
  • School: Western Suburbs Area
  • School Grad Year: 2011
0
Once the cells are cleared you can, if you want to put the grade distributions in. They are not completely necessary they are just their to see what grade you would of gotten for that year (based off VCAA exams, difficulty of exams over different companies varies). If you want the grade distributions they can be found here.
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.
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES: METH, SPESH

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: 3529
  • Overloading, just don't do it.
  • Respect: +631
  • School: Western Suburbs Area
  • School Grad Year: 2011
0
I probably should be more clear, you can enter the names and year of the exams in the left columns aswell. In the image below the columns that have a red border are the ones you can enter in. You can change the grade distributions too if you want.







2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES: METH, SPESH

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.

tigerfan11

  • Victorian
  • Trailblazer
  • *
  • Posts: 37
  • Respect: 0
0
cheers mate

b^3

  • Honorary Moderator
  • ATAR Notes Legend
  • *******
  • Posts: 3529
  • Overloading, just don't do it.
  • Respect: +631
  • School: Western Suburbs Area
  • School Grad Year: 2011
0
Ok xtremeownage, here is the customised version for you, for further, IT Apps, pysch and Geography. It isn't completely fixed up but it will do the trick. I haven't had time to change all the names of the button that jump to the other pages so just use the tabs at the bottom of the sheet. You can still change the names of the buttons by right clicking on them. I filled in some of the grade distributions but haven't had time to fill them all in, so again if you want them, click the link provided in the file and fill them in. Sorry that I couldn't completely fix it all up but I have to start work for tonight, it was taking too long to fix the entire thing up.

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.
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES: METH, SPESH

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.

Daniel15

  • is awesome
  • Victorian
  • Forum Leader
  • ****
  • Posts: 600
  • Maintainer of the ATAR Calculator
  • Respect: +28
+1
Wow, very impressive :)
Estimate your ATAR (ENTER)! VCE ATAR Calculator

2005: Cisco CCNA Units 1+2
2006: Info Systems [39 → 36.93]
2007: Specialist [33 → 43.13], Methods [39 → 44.48], Physics [34 → 37.38], English [23 → 19.91], Chem [26]
ENTER: 84.95

2008-2011: Professional Software Development, Swinburne Uni.

elul

  • Victorian
  • Adventurer
  • *
  • Posts: 6
  • Respect: 0
  • School Grad Year: 2011
0
Definately have been using this these hols! So helpful, good work  ;)
I'm not crazy, my mother had me tested :)

ExamStorm

  • Victorian
  • Trailblazer
  • *
  • Posts: 43
  • Respect: 0
0
Practice exams are just so vital for VCE success!!

abzzzz

  • Victorian
  • Forum Obsessive
  • ***
  • Posts: 302
  • Respect: +15
  • School: aia
  • School Grad Year: 2011
so hard to use lmao
B4i√U,RU/18QTπ

thatisanote

  • Victorian
  • Forum Obsessive
  • ***
  • Posts: 210
  • Respect: +7
This thing is amazing.

Any chance you could add a sheet for english? I think most people would find that useful :)
2010: Eco 46
2011: Eng 45 MMM 47 MFM 50 Phy 44 MUEP Comp Systems 5.5
2012: Stanford University :)

(selling SAT/american college books, pm me)

b^3

  • Honorary Moderator
  • ATAR Notes Legend
  • *******
  • Posts: 3529
  • Overloading, just don't do it.
  • Respect: +631
  • School: Western Suburbs Area
  • School Grad Year: 2011
Sorry about that, I kinda omitted english because well, lets just say I 'dislike' english. For the alternative if you want to add english in, in place of something else then you could replace one of the methods or spesh exam 1's if you want just to put in the overall score. Or if you want to seperate it into the 3 sections then replacing one of the physics (probably unit 3 since it has already passed) slots and putting it all in there. Just make sure you change the text on the setup page, it will do most of the work for you in switching things around.
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES: METH, SPESH

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: 3529
  • Overloading, just don't do it.
  • Respect: +631
  • School: Western Suburbs Area
  • School Grad Year: 2011
After this year is done and I've had a bit of a break I am thinking of another update to this, with a couple of knew features thrown in, but It is all just ideas at this stage. I would lof liked to added them for you guys before we actually do the exams but I'm sorry, I just don't have the time right now. Any suggestions besides additional slots?
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES: METH, SPESH

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.

chrisjb

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1047
  • ROAR
  • Respect: +64
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.


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!
2011: 96.35
2012: http://www.thegapyear2012.com/
2013: Arts (Global) Monash
2016: Juris Doctor (somewhere)

b^3

  • Honorary Moderator
  • ATAR Notes Legend
  • *******
  • Posts: 3529
  • Overloading, just don't do it.
  • Respect: +631
  • School: Western Suburbs Area
  • School Grad Year: 2011
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.


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!
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 :).
2012-2016: Aerospace Engineering/Science (Double Major in Applied Mathematics - Monash Uni)
TI-NSPIRE GUIDES: METH, SPESH

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.

sk1595

  • Victorian
  • Fresh Poster
  • *
  • Posts: 4
  • Respect: 0
  • School: Melbourne High School
Bringing back an old stick to life, but I need you help!
B^3, amazing job. It works brilliantly. The only question I have is, how can I add a 6th subject to spreadsheets??