MSTGN4014 — Produce and analyse spreadsheets

1 Select and prepare resources

• 1.1Determine job requirements from specifications, job sheets and work instructions
• 1.2Identify spreadsheet task requirements in relation to data entry, storage, output and presentation

2 Create spreadsheet

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

3 Produce charts

• 3.1Select chart type and design that enable valid representation of numerical data to show cost, performance and activity
• 3.2Create charts using required data range in spreadsheet
• 3.3Modify chart type and layout using formatting features

4 Analyse data

• 4.1Consolidate data with standard reporting format to report cost, performance and activity
• 4.2Analyse trends in data to identify inventory and cost outcomes
• 4.3Review and update spreadsheet components to match projected outcomes
• 4.4Report outcome of analysis to management

What does an assessment tool for MSTGN4014 need to cover?

To satisfy the Principles of Assessment and Rules of Evidence, an assessment for MSTGN4014 needs to address all 22 unit components: 4 elements with 13 performance criteria, 1 performance evidence requirements, 5 knowledge evidence requirements, and the foundation skills. A coverage matrix mapping each question and task to these components is what an auditor looks for.

How does Auditori generate an assessment tool for MSTGN4014?

Auditori pulls the current release of MSTGN4014 from training.gov.au and generates a complete package: candidate assessment, assessor guide with model answers and observation criteria, and a coverage matrix mapping every component. A suitably qualified person then reviews and approves the draft in a built-in workflow — consistent with ASQA's guidance on AI use in VET — before export as branded PDF and editable Word.

Is the first assessment tool really free?

Yes. Every new account includes one free credit — enough to generate the complete assessment tool for MSTGN4014 — with no card and no subscription required. After that it's pay-as-you-go per unit.

Can I check my existing MSTGN4014 assessment instead of generating a new one?

Yes — upload your existing assessment or learner guide and Auditori maps it against every element, performance criterion, PE and KE of MSTGN4014, showing exactly what's covered and what's missing. Mapping costs a quarter of a credit.