- This topic has 2 replies, 2 voices, and was last updated 2 months ago by
.
- Posts
Hello again,
My understanding is that calculations in the APM exam are intended to be relatively straightforward, as complex calculations are not the main focus of assessment.
With that in mind, I would appreciate some clarification on the level of detail expected when presenting calculations in the spreadsheet. Specifically, how detailed do our workings need to be for examiners to award marks?
For example, if I am calculating a final figure using inputs such as:
number of tags attached per staff member
number of staff
total salary cost
is it necessary to clearly label each step within the spreadsheet (e.g. separate cells to show the steps to reach an answer ), or is it acceptable to show the workings but assume the examiner can click into cells to see how the figure was derived?
Just conscious that fully splitting out every step with headings could be quite time-consuming.
Thank you
Many workings can be contained within the cell formulae. However, this also acts as a form of concealment from you which can lead to errors. It can also lead your to doing many calculations on the calculator and using the spreadsheet as little more than a wordprocessor.
So, if to work out wage costs for 5 workers, each with the different hourly rates and different hours, at some point you have to type in hours x rate for each. Better to enter a row of five, then a row of hours, then a row for the wage amounts.. Little work is saved by effectively entering hours*rate five times.
- The topic ‘Calculation workings’ is closed to new replies.