Details and instructions
This is the first part of assessment task 2. You can choose to do Part A either as an individual or you can pair up with another student who is currently enrolled in the unit. For administration purposes, you must email the Unit Coordinator (UC) about your intention to work in a pair by 4pm on Friday 12 April. Please provide the following information in your notification email: both student names, student ID numbers and the campus both are enrolled at. The UC will then grant you permission to work in a pair. Please do not work in a pair unless you have received permission to do so. If you fail to email the UC by this due time and date, you will not be allowed to work in a pair. If you choose to work in a pair without the UC's permission, you will share the mark 50/50 with the student you paired with (thus you will only receive 50% of the mark awarded).
Part A is designed to help you to gain and/or improve your information technology skills. Specifically, it is designed to enhance your skills in designing and using spreadsheets. You will be required to design formulae in spreadsheets and apply links between cells within a workbook and between different worksheets.
You must use spreadsheets such as excel in Microsoft Office to answer Part A. You will lose a considerable amount of marks if you choose not to use spreadsheets and if you type in figures in the output sheets (budgets). In the past, some students have received zero for this part because they did not read and follow the details and instructions, and typed in all the figures. Please note: marks are allocated for demonstrating your ability to design and use spreadsheets, thus for links between cells and worksheets, and for designing and using formulae. If you type in figures in cells in the budgets (output sheets), you will not receive any marks, even though the figures may be correct.
As this is an advanced unit, it is assumed that students enrolled in this unit are familiar with the use of spreadsheets. If you are not familiar with using spreadsheets or some functions of a spreadsheet, please be proactive and teach yourself a few weeks before the due date of this assignment. You can become familiar with using spreadsheets by clicking on the help facilities that most spreadsheet software packages provide or you may choose to find help on the internet and/or in textbooks in most libraries. In addition to these sources, students can also seek help from the Academic Learning Centre (ALC), the lecturer and/or tutor at the local campus. Distance education students: please contact the Unit Coordinator for assistance well in advance. We can also set up zoom sessions for discussions and if needed, for excel tutorials.
Design of spreadsheets
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: Budget number followed by a brief description or abbreviation, e.g. 1 Revenue, 3 DMP, and 5 OH.
You may also use acronyms, e.g. Q1 (Quarter 1), Q2 (Quarter 2), etc.
Your output sheets 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. You do not have to 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.
High professional presentation standards that you will apply when presenting budgets to your employer in the workplace. Ensure your ‘employer’ will be able to follow your logic in the design of your worksheets.