Assessment Task 2: Part A - Spreadsheet Design And Functionality Essay.

Details and instructions
This is the first part of assessment task 2. Similar to Part B, you can choose to do Part B either as an individual or you can pair up with another student currently enrolled in the unit. For administration purposes, you must email the Unit Coordinator (UC) if you intend to work in a pair by 4pm on Monday 13 August for Part A. 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).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.