Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I do not want the answer to this but I would like to know how to work it out. If someone can explain it I would appreciate it.

I've got a list of grades for students that I need to get a UCAS score.
See image


Write a Python application which opens and reads in student data from a Grades.csv file filled with Access to HE student grades, calculates the final grade for the Access to HE student (Count of P,M,D each multiplied by its Credit value (see below grid) from Units 4-10 only (totalling 45 credits)), then calculates their UCAS points (https://www.ucas.com/ucas/tariff-calculator) from these values and finally saves all this data (as Student forename, Student surname, Pass Total, Merit Total, Distinction Total, UCAS Point Total) to a new “results.csv” file.

Example line of final student data written to the “results.csv” file: ‘David, Gorton, 27, 12, 21, 106’ (i.e Forename, Surname, Credit Total of Passes, Credit Total of Merits, Credit Total of Distinctions, UCAS Score (processed from only the 45 Credits of Units 4-10 (i.e. - 15 from Credit Total of Passes)). Access to HE: Computing Unit Points (IMPORTANT!) Unit 1 2 3 4 5 6 7 8 9 10 Credits 6 6 3 6 6 6 9 6 6 6 REMINDER: UCAS points are worked out from Units 4 - 10 only (Access to HE - 45 points)

What I have tried:

I'm unsure how to start as I've not done Python.
Posted
Updated 26-Jan-23 10:00am
v2

1 solution

First, learn Python. Without at the very least the basics, you will never get this done - "guessing and hoping" is not a successful development strategy!

Then think about how you would do it manually and get that sorted in your head before you even think about code. If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900