15,946,988 members
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

## Solution 1

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[^]