... records. This is a screen shot of the formulas used. This is a screen shot of the results of the formula. The information that I put into my spreadsheet (names, etc.) was a mixture of my friends from school, my favourite singers, and footballers. If this spreadsheet was being made and used by a teacher, then the information would be of the pupils, which would be gathered from the school records. In order to make the best markbook; it needed to include the marks the pupils obtained in each module. It also had to have the same information (e.g. Surname, forename, etc.) from the register, plus the marks from their modules, and an average, maximum, minimum, and range of the marks obtained. For the marks of the students, I chose the highest mark for the modules as 16, and gave everyone a mark out of 16. I did this with all of ...

See this essay or coursework document in full right now