Each student is to develop and use 2 different linked spreadsheets that use advanced spreadsheet features - suitable for a construction company

Accounting Aug 03, 2020

Each student is to develop and use 2 different linked spreadsheets that use advanced spreadsheet features - suitable for a construction company.

One linked spreadsheet must calculate costing estimates for each stage of a construction job against actual expenditures and contracted revenue. Income for this task could be allocated as:

Deposit 5%
Base Stage 10%
Frame Stage 15%
Lock-up Stage 35%
Fixing Stage 25%
Completion 10%

The other linked spreadsheet may include a customer database, menus, itinerary, staff details, wages, timesheets, etc

Functions to be demonstrated must include 3 from the list below

mathematical functions (eg. square root, integer, absolute value, round)
statistical functions (eg. standard deviation, count, maximum, minimum)
basic financial functions (if available)
date functions
logical functions (eg. lookup, if, choose, true, false, conditions)
simple nested functions.

During this observation, your are to assess each candidate:

Using safe work practices
Develop a linked spreadsheet solution
Automate and standardise your spreadsheet operation (through creating, using and editing macros and templates)
Use your spreadsheet ensuring you
- Enter, check and amend each spreadsheet correctly
- Enter your data effectively
- Use manuals or user documentation (including on-line) for assistance where required
- Review, adjust and print your spreadsheet
- Name and store your spreadsheet accordingly
Represent numerical data into graph form
- Include appropriate chart type and chart features, which represents numerical data validly
- Create graphs with Labels and titles from numerical data contained in a spreadsheet file
- Save, view, adjust and print each chart