Assessment Task 2
This is the second assessment for this unit. It consists of six parts.
This assessment should be done before you proceed to session 5.
This assessment should take about three hours to complete.
Your submissions should follow the style guide.
When you are confident that you have met all requirements for this assessment, upload all six parts to the Study Smart site for this unit for marking purposes. Make sure your name is on every file so that they are identifiable as your work.
You will be notified as soon as possible about your results for this assessment.

SGA1036 Applied Computing (Spreadsheets) Workbook
Assessment Task 2
Task analysis and specification design
PART A
Requirements
1) Download the samples folder from Study Smart.
These three files are available for you to analyse and consider the design and efficiency components (if any).
a) BillingStatement
b) GartnerGroupHelpDeskCommonMetrics 2012
c) PersonalMonthlyBudget
This next file is a good example of what can be done with spreadsheets. The content may be a bit daunting but the design is excellent.
d) statsamp
Choose one of the sample files studied. Use this file to write about the design specifications and efficiencies contained in the file. What improvements would you make to the file, if any, and why?
Word length: 200 words.
PART B
Your friend has opened a small retail shop that also sells take-away coffee and cake and has asked you to help set up a spreadsheet that can keep track of sales and expenses for each month for January, February and March 20XX.
Requirements
1) Design the file structure for storage of these documents and create a file and sheet naming convention that is logical and easy to understand.
2) Include a logo and business details to be on the summary sheet for the solution.
52 © Study Group Australia Pty Limited, SGA1036-L6/03/14-V1
3) Your need to develop a document titled: ‘Design Specification’ to assist a new user with the following:
• formulae and functions
• data entry or import
• storage – sheet, file and folder naming
• output – printing and screen layout
• reporting
• presentation requirements – as per scenario for retail shop.
• authorised access
• file naming conventions
• filing locations
• organisational policy for backing up files
• organisational policy for filing hard copies of spreadsheets
• security
• storage in folders and sub-folders
• storage on a disk, USB or server
You will be implementing your design in the next section so make sure you understand exactly how you are going to deliver the requirements.
PART C
As per your design specifications in PART B, implement your solution.
Your solution must contain:
• formulae and functions that are relevant and correct for the given problem
• data entry or import instructions where required
• correct linking between summary and detail sheets
• correct use of at least one absolute reference – this scenario has a ‘natural candidate’
• appropriate storage – sheet, file and folder naming
• output – printing views saved as A4
• reporting – A4 print and screen views
• presentation requirements – as with the scenario for the retail shop.
SGA1036 Applied Computing (Spreadsheets) Workbook
PART D
Macros could include printing sections of a spreadsheet.
Templates may include:
• font types and sizes
• forms
• headers and footers
• headings
• page formats
• reports
Essentially we are looking at using macro(s) and template(s) to increase efficiency.
Analyse your spreadsheet file for opportunities to achieve increases in efficiency using a macro and a template.
1. Implement a macro and a template into your spreadsheet file that will increase efficiency.
PART E
1. Use the template and/or macros developed to establish the spreadsheet set for the next quarter.
PART F
1. Use your Spreadsheet file to create two or more graphical representations of the data.
2. Make sure your graphs suit the information being represented and you use labels and titles.
When you have completed this assessment upload your file/s using Study Smart for this subject (refer to the link ‘How to submit an assessment’ in the Study Smart home page).
54 © Study Group Australia Pty Limited, SGA1036-L6/03/14-V1
Criteria
PARTS A-B (Word document)
• The learner has provided a sufficient response to the individual questions in PART A and developed a specification document in PART B.
PARTS B-F (Spreadsheet document)
• The learner has created an appropriate file structure and file using file name conventions as per industry standards.
• A suitable logo and business details are displayed on the summary sheet.
• The spreadsheet file includes sufficient formula and links to successfully process data.
• A macro and a template are developed for the next quarter.
• A minimum of two diagrams/charts of the data are produced.