• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

Graphs in Excel

V

Viki2010

Member
Hi, so the question is whether one can get marked down for not including the source of data on the same tab as the graph in the excel model.

I normally have all my calculations and results in other tabs and a graph on a different tab.

In fact, during the preparation day we were advised to keep the Graph on a separate tab.

However, on my Mock A exam for CA2, I am being advised to keep the results (data source for the chart) and the chart on the same tab.

Would not having results on the same tab as a chart loose any marks? I'm only asking because the production of numbers into the additional tab where the chart sits may take extra time as as we know the time pressure of the exam may not offer this type of luxury.
 
No, you wouldn't lose marks for that. There are marks for the graphs themselves, and the layout /flow of the spreadsheet. So if your graph is in a place which is misleading, you might be penalised, but there's nothing wrong with a separate sheet, provided this is shown in the audit trail.
 
Thank you.
Can I also please check if the same principles apply to CP3 as to CA2 for the presentation of graphs/ charts? I think for CP3 we should not label numerical values on the e.g. bar charts to avoid cluttering the graphs. Is the approach the same for CA2?
 
I'm not familiar with the requirements of CP3, but the key for CA2 is communication and clarity. If you need numerical values to get the point across adequately, then they're fine. If the graph communicates the result without them, then you're better off leaving them out. I'd say that in more than 90% of cases, there's no need for numerical labels - I'd recommend them only if some of the elements are so similar that you can't tell them apart by sight.

Hopefully that makes sense.
 
You must log in or register to reply here.
Back
Top