BSBTEC302 — Design and produce spreadsheets

Generate a complete, audit-ready assessment tool for this unit in minutes: candidate assessment, assessor guide with model answers, and a coverage matrix mapped to every component below. Reviewed and approved by your qualified person, exported under your branding.

Generate BSBTEC302 free See a real sample

Every new account includes a free credit — no card, no subscription.

What an assessment for BSBTEC302 must cover

31 assessable components: 5 elements (16 performance criteria), 7 performance evidence and 4 knowledge evidence requirements, plus 4 foundation skills. An audit-defensible tool maps every question and task back to these — that mapping is the coverage matrix Auditori generates alongside the assessment.

Elements & performance criteria

1 Select and prepare resources

1.1Identify task purpose and audience
1.2Identify task requirements according to data entry, storage, output, timeline and presentation format
1.3Select most appropriate application to produce spreadsheet, according to available resources and organisational policies and procedures

2 Plan spreadsheet design

2.1Design spreadsheet design to suit purpose, audience and information requirements of task
2.2Confirm spreadsheet is designed to enhance readability and appearance, and is in accordance with organisational and task requirements
2.3Use available application functions and confirm consistency of design and layout, adhering to organisational and task requirements

3 Create spreadsheet

3.1Enter data, check and amend to maintain consistency of design and layout, in accordance with organisational and task requirements
3.2Format spreadsheet using application functions, according to organisational policies and procedures and presentation requirements
3.3Consult with relevant stakeholders and confirm formulae are tested and output meets task requirements
3.4Use required help functions and action issues as required

4 Produce charts

4.1Select chart type and design that offers analysis of numerical data, and meets organisational and task requirements
4.2Create charts using required data range in spreadsheet
4.3Modify chart type and layout using formatting features, adhering to organisational and task requirements

5 Finalise and present spreadsheets

5.1Review and edit final spreadsheet and accompanying charts, and prepare for delivery according to task requirements
5.2Deliver document to required stakeholders according to organisational requirements, policies and procedures
5.3Name and store spreadsheet according to organisational requirements and exit application

Performance evidence

plan, design, produce and finalise a spreadsheet on at least four occasions.
produce spreadsheet documents that align to document purpose and appropriate to target audience
design spreadsheets using: formulas and functions with: addition, subtraction, division, multiplication; brackets
design spreadsheets that address a range of data and organisational requirements
use software functions to create spreadsheets that adhere to organisational requirements relating to style and presentation
use relevant help functions to rectify document issues
produce spreadsheet document in appropriate format for review, including ability to create and modify intermediate-level charts that analyse the dataset.

Knowledge evidence

key elements of formatting of spreadsheets appropriate to workplace documents, including the ability to calculate: sum totals, averages, counts of values
key features of spreadsheet applications, both cloud-based and non-cloud based
key features of organisational guidelines on spreadsheet design and use
organisational requirements for ergonomics, work periods and breaks, and sustainability in relation to spreadsheet production.

Foundation skills

Reading: Recognises and interprets numerical and textual information to determine organisational and task requirements
Writing: Inputs numerical and key reporting information when creating and finalising spreadsheets. Uses format, layout, style guides and standard naming conventions to organise data according to purpose and audience
Numeracy: Uses mathematical equations to create simple formulae and validate numerical data
Teamwork: Collaborates with others to achieve joint outcomes

Unit content sourced from training.gov.au — © Commonwealth of Australia, licensed under CC BY 4.0. Auditori is not affiliated with the Department of Employment and Workplace Relations.

See what you get before you start

Real, unedited Auditori output (RIIHAN201E shown), branded for a sample RTO:

Questions about assessing BSBTEC302

What does an assessment tool for BSBTEC302 need to cover?

To satisfy the Principles of Assessment and Rules of Evidence, an assessment for BSBTEC302 needs to address all 31 unit components: 5 elements with 16 performance criteria, 7 performance evidence requirements, 4 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 BSBTEC302?

Auditori pulls the current release of BSBTEC302 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 BSBTEC302 — with no card and no subscription required. After that it's pay-as-you-go per unit.

Can I check my existing BSBTEC302 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 BSBTEC302, showing exactly what's covered and what's missing. Mapping costs a quarter of a credit.

Related units

Your BSBTEC302 assessment tool, in minutes.

First unit free. No card, no RTO registration, no subscription.

Generate BSBTEC302 free