I am creating a spreadsheet to track students through the course and was wondering if anybody know how the UMS scores are calculated. I've worked out that for Unit 1 the raw mark out of 40 is multiplied by 1.5 to give a mark out of 60. However, I am unsure about how this works with Unit 2 and 3. Unit 2 external assessment carries a maximum raw mark of 64 but looking at the UMS information the maximum mark is 120 (83 foundation) and similarly Unit 3 carries a UMS mark of 120 but the raw mark is 96 (48 for S&L and 48 Spoken Language and writing tasks). I realise there is a spreadsheet already available on the Edexcel website however I am going to require more detail in the spreadsheet I am creating. Many thanks for any insight or support.