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

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

Accounting

Share With

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