mdwheeler Posted January 7, 2020 Posted January 7, 2020 Hi, Maybe I am going about things in the wrong way! I would like to turn % into grades for a set of marksheets. I know there is a % to grade formula but it seems incredibly clunky to use as I have 10 tests convert on a marksheet and I have to type in the grades manually each time (or produce a different set of gradesets for each subject and year group). So I thought I could use a lookup table for each subject as in the enclosed example. However, when I try and use this to put data into any aspect (marks/decimal, marks/integer/ grades) I get nothing. I use a column containing %s which is of type marks/decimal as the source for the calculation. I cannot see where I am going wrong? But it is probably something dumb on my part. Thanks Martyn
coolhands Posted January 7, 2020 Posted January 7, 2020 I haven't read your thread in detail but check here it walks you through it, you might spot something. I can't see a 'Gradeset' in your screenshot so could it be that? https://davidpott.com/2014/07/01/using-sims-convert-new-gcse-grades/
mdwheeler Posted January 7, 2020 Author Posted January 7, 2020 Hi Thanks, I have added more columns onto my lookup table and it is now producing some data. However, the data is being pulled from the wrong age column! A pupil who is 15 y 02 m is getting data from the 11/01 column??
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now