ACCT19060 | Accounting Assessment Task 2 | Accounts
Design of spreadsheets
ACCT19060 Accounting Assessment Task 2 Accounts. To receive maximum marks for designing the spreadsheets and workbooks, you must adhere to the following requirements:
• Only have one input sheet which must be the only source for entering all numeric values/data. The purpose of the input sheet is to ensure that you do not type any figures or data in the output sheets (i.e. budgets). The input sheet must only contain raw data. Please do not do your calculations in your input sheet, but link the raw data from your input sheet to the output sheets and use formulae in the output sheets to calculate the figures in each budget.
• When you have calculated figures in an output sheet and those figures are used in a subsequent output sheet, link these figures to the previous output sheet and do not link these figures to the input sheet.
• Each budget (i.e. output sheet) must be in its own worksheet.
• Name each worksheet appropriately as follows: a Budget number followed by a brief description or abbreviation, e.g. 1 Revenue, 3 DMP, and 5 DML.
• You may also use acronyms, e.g. Q1 (Quarter 1), Q2 (Quarter 2), etc.
• The cells in your output sheets that contain figures (calculations) must only contain formulae and links to either the input sheet or previous output sheets if the figure was calculated in a previous budget. Do not type any figures in the cells of your output sheets.
• In essence, ensure you formulate the cells containing figures in all the output worksheets (budgets) in such a way that when you change a numeric value in the input sheet, then the calculations are done automatically in the output sheets.
• Unless advised otherwise, use and show two (2) decimal places in calculations where appropriate. Please do not show decimal places when there are no cents or fractions in figures. For example, show the figure 0.08 with 2 decimal places but do not show the figure 1 as 1.00.
• Ensure you meet high professional presentation standards that you will apply when presenting budgets to your employer in the workplace. Ensure your budgets are presented in a sensible way so that your ‘employer’ will be able to follow your logic in the design of your worksheets. Also, ensure that the font size is big enough for your ‘employer’ to read on a computer and that each budget can be read on one screen.
ACCT19060 Accounting Assessment Task 2 Accounts:
The following requirements are necessary to enhance the marking process and save time to mark the assignments. Please note: three (3) marks are allocated for complying with the design and formatting requirements.
• Due to time constraints with marking, only certain cells will be selected for marking. Marks are awarded for using the correct link and/or formula in cells and not the correct figures. The marking team may use the following marking legends to indicate which cells were marked and where you have received marks or where you have lost marks:
– Legend: a cell highlighted in red indicates the link and/or formula is incorrect and hence you lost the relevant mark
– Legend: a cell highlighted in green indicates the link and/or formula is correct and hence you received the relevant mark
• To assist with the marking and the use of the colored legends above, please do not highlight any texts in your worksheets.
• Once all the assignments have been marked and returned, a marking criteria sheet will be uploaded to Moodle. The purpose of this sheet is to show you which cells were marked and what was marked (e.g. link or formula). The sheet will also show the correct figures. To understand your mark, please compare your marked assignment with this marking criteria sheet.
• Include a column for “marks” on the right-hand side of each worksheet and formulate this column as follow: font color = red; and number format = number. Ensure the marker can use this column to show your awarded mark. If you receive full marks, the marker may choose to leave the ‘marks’ column blank. Only use one decimal place in this column.
• Ensure the presentation of each worksheet is of a high professional standard, that it provides all the required information and proper descriptions of figures calculated, is sensible, and can be marked easily.
• Ensure all columns in your worksheets are wide enough so that your figures do not display as #### in the cell. These #### cannot be marked and the marker will not widen the column width to see the figures.
• Leave each workbook on 100%.
• Show your calculations as far as practical in each worksheet. It is not necessary to show the calculations of each and every figure, as that will be impractical and not sensible. For the calculations, you choose to show, please include a reference column to the left of the figures and show the calculation at the bottom of the worksheet (as shown in the example below). Showing calculations will enable the marker to provide you partial marks where appropriate. Without showing the calculations, no partial marks can be provided.
• Delineate figures with appropriate commas. For example, show 20,000 and not 20000. Further, show $2,420,000 and not $2420000.