- This topic has 4 replies, 4 voices, and was last updated 4 years ago by
.
- Posts
Hi Trephena
Long time since I last used the forum! Your help has been invaluable.
I am not sure if there is already a topic for this area but I couldn’t find it. I am just finalising the rap. Please could you explain how to reference the excel spread sheets. I have created graphs using info from the Annual statements of both companies. The graph has been copied and pasted in the Rap. I have referred to the appropriate excel sheet ie appendix 1, under the graph. In the excel spread sheet how do I reference the numerical financial information from the annual reports. At the moment I have just written “XYZ 2011, XYZ 2012” etc at the bottom of the spread sheet underneath the tables and graphs as the in-text citation, is that OK. Also do I have to reference all these citations to the reference list in the main report (rap).
Also what type of spread sheet document do you upload for the project, is it in read only format etc. Thanks for your help.Fatema
@Fatema Please see for details:
https://opentuition.com/topic/what-to-reference-in-graphs-and-tables/You must include all references in your reference list including the Annual reports.
The file formats are shown in the Information Pack and you need to demonstrate some spreadsheet skills so the marker should be able to see the formulae you have used and that you have made the graphs from your spreadsheets (so that is why pdf files are not permissible). I don’t think making them read only affects the ability for a reader so see this information so either format is appropriate.
(BTW I think there is a way of listing answers you need to refer to frequently under ‘favorites’. I’ve never used it myself but if you click on the avatar and then forums I think it brings it up. If you have a problem then email the OT Team or let me know and I’ll ask them to explain how it is done but that way I think you can include all the answers that you may need at a later date
@bassaniobroke – have you ever used this facility by any chance?)I visited that link but could not find anything. Can you please tell me how I refer my excel work in following scenario of my research report.
i.g. ” ABC’s revenue was 100 Million in 2017, Increased 14% from last year”
Do I have to write only (Appendix 1, 2020) or something like that ?
Thanks in advance.
Hello mishukkazi, im not @trephena, but allow me to chip in.
You should arrange your spreadsheet workbook in a logical manner, for example, have one sheet for financial statements which could be called appendix 1, another sheet for ratios or kpis used which could be called appendix 2 etc.
you dont have to reference absolute figures like revenue in 20xx $20m, tax expense in 20xx $5m or eps in 20xx $1.3 per share, as the examiner will know these figures are from the financial statements of the organisation(s) you have refrenced in your spreadsheet.
However if you find that you will be making variance comparisons of key FS items like profit,assets, expenses etc. It will be a good practice to calculate their yearly increase/ decrease in a seperate spreadsheet (e.g Appendix 4). so that you can reference ‘(Appendix 4)’ after such remarks.
- You must be logged in to reply to this topic.