NTISthis.com

Evidence Guide: MSTGN4014 - Produce and analyse spreadsheets

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

MSTGN4014 - Produce and analyse spreadsheets

What evidence can you provide to prove your understanding of each of the following citeria?

Create spreadsheet

  1. Ensure data is entered, checked and amended to maintain consistency of design and layout
  2. Format spreadsheet using software functions to adjust page and cell layout to meet information requirements
  3. Ensure formulas are tested and used to confirm output that meets task requirements
  4. Use manuals, user documentation and online help to support best practice in spreadsheet design and production
Ensure data is entered, checked and amended to maintain consistency of design and layout

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Format spreadsheet using software functions to adjust page and cell layout to meet information requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Ensure formulas are tested and used to confirm output that meets task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use manuals, user documentation and online help to support best practice in spreadsheet design and production

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Produce charts

  1. Select chart type and design that enable valid representation of numerical data to show cost, performance and activity
  2. Create charts using required data range in spreadsheet
  3. Modify chart type and layout using formatting features
Select chart type and design that enable valid representation of numerical data to show cost, performance and activity

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create charts using required data range in spreadsheet

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Modify chart type and layout using formatting features

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Analyse data

  1. Consolidate data with standard reporting format to report cost, performance and activity
  2. Analyse trends in data to identify inventory and cost outcomes
  3. Review and update spreadsheet components to match projected outcomes
  4. Report outcome of analysis to management
Consolidate data with standard reporting format to report cost, performance and activity

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Analyse trends in data to identify inventory and cost outcomes

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Review and update spreadsheet components to match projected outcomes

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Report outcome of analysis to management

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Select and prepare resources

  1. Determine job requirements from specifications, job sheets and work instructions
Determine job requirements from specifications, job sheets and work instructions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify spreadsheet task requirements in relation to data entry, storage, output and presentation

  1. Ensure data is entered, checked and amended to maintain consistency of design and layout
Ensure data is entered, checked and amended to maintain consistency of design and layout

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Format spreadsheet using software functions to adjust page and cell layout to meet information requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Ensure formulas are tested and used to confirm output that meets task requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use manuals, user documentation and online help to support best practice in spreadsheet design and production

  1. Select chart type and design that enable valid representation of numerical data to show cost, performance and activity
Select chart type and design that enable valid representation of numerical data to show cost, performance and activity

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create charts using required data range in spreadsheet

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Modify chart type and layout using formatting features

  1. Consolidate data with standard reporting format to report cost, performance and activity
Consolidate data with standard reporting format to report cost, performance and activity

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Analyse trends in data to identify inventory and cost outcomes

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Review and update spreadsheet components to match projected outcomes

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Report outcome of analysis to management

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Required Skills and Knowledge