Just one sec...
Hey! Sign in to get help with your study questionsNew here? Join for free to post

UMS Calculator - Work Out What Grades You Need!

Announcements Posted on
Take our short survey, £100 of Amazon vouchers to be won! 23-09-2016
    • Thread Starter
    Offline

    2
    ReputationRep:
    I got this from somebody last year on TSR I think, but people keep asking for it so I thought it would be helpful to post it!

    Basically you just put ur unit marks in and it tells you what AS grade and A2 grade you are on, and how many you need to get each A2 grade, really useful and usually reassuring as people realise they aren't under as much pressure as they thought they were.

    It wouldn't let me upload the new Excel format, but I've got the old one on there, and that will work on anyone's computer with Micrsoft Office, any version, and if you want to save space just resave it as the new version and it's about half as much file space.
    Attached Files
  1. File Type: xls UMS Calculator.xls (66.5 KB, 34599 views)
    Offline

    0
    ReputationRep:
    Ah thanks!

    I'm being a div though, I've put in my AS grades but where should I be looking to see what UMS I need to get an A overall?
    Offline

    0
    ReputationRep:
    Thanks, this will be very helpful.
    Offline

    2
    ReputationRep:
    This scares me
    Offline

    2
    ReputationRep:
    Just me that has a spreadsheet of all there results and grades already worked out ?
    Offline

    0
    ReputationRep:
    (Original post by ChrisLincoln)
    Just me that has a spreadsheet of all there results and grades already worked out ?
    Nope - I do too. =]] Except for chemistry because I'm doing two retakes anyway, so it's a bit pointless.
    Offline

    0
    ReputationRep:
    That was so easy to make! I made one for myself last year when I was doing A-levels!
    Offline

    2
    ReputationRep:
    (Original post by SophieSomething)
    Nope - I do too. =]] Except for chemistry because I'm doing two retakes anyway, so it's a bit pointless.
    Phew not alone! Yeah, i'm trying to think of a clever way to incorporate my resits into the spreadsheet neatly :p:
    • Thread Starter
    Offline

    2
    ReputationRep:
    (Original post by ChrisLincoln)
    Just me that has a spreadsheet of all there results and grades already worked out ?
    Well it's my copy and I couldn't be bothered to delete everything incase I forgot the grades to put back in lol...but just delete them and change the tap names (like law, maths etc). Shouldn't make any diff to you tbh.

    (Original post by lily_blue3)
    Ah thanks!

    I'm being a div though, I've put in my AS grades but where should I be looking to see what UMS I need to get an A overall?
    One the right-hand side where it says A, B, C, D, E vertically with a number next to each one.

    (Original post by ChrisLincoln)
    Phew not alone! Yeah, i'm trying to think of a clever way to incorporate my resits into the spreadsheet neatly :p:
    Lol I have just played around with them a bit, like trying best and worst case scenarios that I think I've got in them (as I've sat both resits now).
    Offline

    0
    ReputationRep:
    Wow really helpful, thanks!! Made me fell alot better about my exams that r coming up now, +Rep for you
    Offline

    0
    ReputationRep:
    so right..im confused lol

    what if your UMS marks are weighted differently??
    Offline

    0
    ReputationRep:
    (Original post by anna_spanner89)
    so right..im confused lol

    what if your UMS marks are weighted differently??
    You know at the top where it says /120 /90 /90 etc? You can change that, just type the write number over it and the tables will change.
    • Thread Starter
    Offline

    2
    ReputationRep:
    (Original post by anna_spanner89)
    so right..im confused lol

    what if your UMS marks are weighted differently??
    Change the weighting where it says 90/90/120 or 100/100/100 and the percentages and boundaries will change themselves. Note that I have already got different module marks on there, for example maths is all out of 100, whilst law is marked 90,90,120,90,90,120.

    Let me know if you can't do it.
    Offline

    0
    ReputationRep:
    cheers

    btw does anyone know the UMS for PYA6, the courswork component??

    e.g the raw marks into UMS
    • Thread Starter
    Offline

    2
    ReputationRep:
    (Original post by anna_spanner89)
    cheers

    btw does anyone know the UMS for PYA6, the courswork component??

    e.g the raw marks into UMS
    Well on page 8 of this grade boundary report from Jan 08, it has an A capped at 52/60, and goes down in raw mark scores of 4, until an E at 36/60. So therefore:
    52/60=80
    48/60=70
    44/60=60
    40/60=50
    36/60=40
    Offline

    0
    ReputationRep:
    wow mate thats really good spreadhsheet. cheers.
    Offline

    0
    ReputationRep:
    Help guys I don't know how to use it!
    Offline

    0
    ReputationRep:
    Thanks for the spreadsheet..it scared me a tad..lol but has motivated me to work harder, you will get rep later
    Offline

    0
    ReputationRep:
    Can someone help me use it?

    Or someone do it for me :shy:

    I got for unit 1 80/100 Unit 2 77/100 and Unit 3 I got 90/100 and unit 6 is coursework and got 52/60- That is is for one subject

    The other subject is

    Unit 1 72/80 Unit 2 86/120

    Could someone please work out what marks I need to get an A for both subjects. Who ever tells me, will get a rep. Thanks in advance
    • Thread Starter
    Offline

    2
    ReputationRep:
    (Original post by Zak)
    Can someone help me use it?

    Or someone do it for me :shy:

    I got for unit 1 80/100 Unit 2 77/100 and Unit 3 I got 90/100 and unit 6 is coursework and got 52/60- That is is for one subject

    The other subject is

    Unit 1 72/80 Unit 2 86/120

    Could someone please work out what marks I need to get an A for both subjects. Who ever tells me, will get a rep. Thanks in advance
    Have you opened the file? If so I'll tell you where to put the bits and bobs.
 
 
 
Write a reply…

Reply

Submit reply

Register

Thanks for posting! You just need to create an account in order to submit the post
  1. this can't be left blank
    that username has been taken, please choose another Forgotten your password?
  2. this can't be left blank
    this email is already registered. Forgotten your password?
  3. this can't be left blank

    6 characters or longer with both numbers and letters is safer

  4. this can't be left empty
    your full birthday is required
  1. Oops, you need to agree to our Ts&Cs to register
  2. Slide to join now Processing…

Updated: June 4, 2014
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

Poll
Who is going to win Bake Off?
Help with your A-levels

All the essentials

The adventure begins mug

Student life: what to expect

What it's really like going to uni

Rosette

Essay expert

Learn to write like a pro with our ultimate essay guide.

Uni match

Uni match

Our tool will help you find the perfect course for you

Study planner

Create a study plan

Get your head around what you need to do and when with the study planner tool.

Study planner

Resources by subject

Everything from mind maps to class notes.

Hands typing

Degrees without fees

Discover more about degree-level apprenticeships.

A student doing homework

Study tips from A* students

Students who got top grades in their A-levels share their secrets

Study help links and info

Can you help? Study help unanswered threadsRules and posting guidelines

Sponsored content:

HEAR

HEAR

Find out how a Higher Education Achievement Report can help you prove your achievements.

Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.