BSBTEC302 Project Portfolio Tejas

Australian Harbour International College
RTO ID: 41338 CRICOS Provider Code: 03449J

ABN: 74 603 036 102
T: 02 9268 0085
E: admissions@ahic.edu.au
W: www.ahic.edu.au
A: Level 4, 114-120 Castlereagh Street
Sydney NSW 2000 Australia
First published 2021
RTO Works
www.rtoworks.com.au
hello@rtoworks.com.au
0452 157 557
© 2021 RTO Works
This resource is copyright. Apart from any fair dealing for the purposes of private study, research, criticism or review as
permitted under the Copyright Act 1968, no part may be reproduced by any process without written permission as
expressed in the RTO Works License Agreement.
The information contained in this resource is, to the best of the project team’s and publisher’s knowledge true and correct.
Every effort has been made to ensure its accuracy, but the project team and publisher do not accept responsibility for any
loss, injury or damage arising from such information.
While every effort has been made to achieve strict accuracy in this resource, the publisher would welcome notification of
any errors and any suggestions for improvement. Readers are invited to write to us at hello@rtoworks.com.au.
Business Works is a series of training and assessment resources developed for qualifications within the Business Services
Training Package.
Australian Harbour International College, 114-120 Castlereagh Street, Sydney NSW 2000, Australia
|RTO NO: 41338 | CRICOS Provider Code: 03449J
Version V2.0/ July 2022 Page 1 of 38

BSBTEC302 Design and produce spreadsheets
ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Contents
Section 1: Planning and preparation 5

Section 2: Create a spreadsheet 13
Section 3: Review 25
Section 4: File management 33

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Student name: Tejas Tamrakar-AHI2001235
Assessor: A J Mubbashar
Date: 21/07/2022
Business this assessment is King Edward VII College

based on:
Spreadsheet 1:
 Student Assessment Marks Term 1 for maths. This

spreadsheet provides total marks for each student
 the average mark for each assessment and an average for
the total along with bar chart of total students
 This spreadsheet 1 is attached
Spreadsheet 2:  Students Sports results. This spreadsheet provides average

result of each student
 The highest result out of each event and each student with 2
decimal cell formatted is placed along with a bar chart of the
comparison of each students in each events
Spreadsheet 3:  Students attending camp for each year group. This

spreadsheet provides total percentage of student attending
the camp
 The total percentage of student attending the camp along with

the bar chart
Spreadsheet 4: Students Assessment Marks term 1. This spreadsheet provides total

percentage of each assessment for each student.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Section 1: Planning and preparation
Spreadsheet 1
The purpose of this spreadsheet in term 1 is Student

Identify the purpose and
Assessment Marks Term 1 for maths.
audience
What is the main purpose of This spreadsheet provides total marks for each student and
the task you have been asked average mark for each assessment and an average for the
total along with bar chart of total for each student.
to do?
Who will be the audience (i.e.,
Teacher Mr Son Kim and academic manager
the people using the
spreadsheet)?
Confirm the task requirements  Standard font is: Black Arial 10 pt. Standard college colours are
dark blue and green.
You need to clearly list the
task requirements.  Use portrait page layout format.
Include the data that needs to  Layout data in an easy-to-read format, use formatting styles to
be entered, what needs to be support presentation.
output, the deadlines and
presentation format.  The name of the college should be included in a footer along
with page numbers. Footers must be in size 8, italic.
 Use border styles to differentiate data.
 Distinguish headings from data using formatting tools.
 Charts must be correctly labelled and presented on the same

worksheet as the data.
 The formatting must follow the standard college colours. The

chart must accurately represent the dataset.
 Rename each worksheet with a relevant and appropriate sheet

name.
 No figures are to be used in formulae only cell references.


ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
name.
Identify the most appropriate I used Ms. Excel as application based on the instruction to complete
application and resources
This must be an application
that you have access to and
that can produce a
spreadsheet.
Provide a design of the This spread sheet it is attached. It is created based on the design
spreadsheet provided by simulation pack
Your design must suit the
purpose, audience and
information provided on the
task in your Simulation Pack.
Ensure that the design
enhances the readability and
appearance of the data being
presented and follows any
organisational and task
requirements as provided in
your Simulation Pack.
Attach: Submit the spreadsheet design for feedback

Spreadsheet design submitted and feedback received in ☐
the class from teacher

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 2
Identify the purpose and The purpose of this spreadsheet is to provide average results for
audience each student for each event.
What is the main purpose of This spreadsheet shows the highest and average result out of each
the task you have been asked event for each event for each student which is been formatted in 2
to do? decimal places along with appropriate chart which displays
comparison of each student’s results in each event.
Who will be the audience (i.e.,
the people using the Teacher Sonia Worthington and academic manager will be the
spreadsheet)? audience.
 Standard font is: Black Arial 10 pt. Standard college colours

Confirm the task requirements
are dark blue and green.
You need to clearly list the  Use portrait page layout format.
task requirements.  Layout data in an easy-to-read format, use formatting styles
to support presentation.
Include the data that needs to
 The name of the college should be included in a footer along
be entered, what needs to be with page numbers. Footers must be in size 8, italic.
output, the deadlines and  Use border styles to differentiate data.
presentation format.  Distinguish headings from data using formatting tools.
 Rename each worksheet with a relevant and appropriate
sheet name.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Identify the most appropriate I used Ms. Excel as application based on the instruction to complete.
that can produce a
spreadsheet.


ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 3
Identify the purpose and The purpose of spreadsheet 3 is to provide data of students attending
audience the camp on different year
What is the main purpose of The main purpose is to make comparisons for students attending in
the task you have been asked camp for each year group with percentage along with appropriate
to do? chart.
Who will be the audience (i.e., Teacher Miss Sara Jeffery and academic manager will be the
the people using the audience
spreadsheet)?
 Standard font is: Black Arial 10 pt. Standard college colours

Confirm the task requirements
are dark blue and green.
You need to clearly list the  Use portrait page layout format.
task requirements.  Layout data in an easy-to-read format, use formatting styles
to support presentation.
Include the data that needs to
 The name of the college should be included in a footer along
be entered, what needs to be with page numbers. Footers must be in size 8, italic.
output, the deadlines and  Use border styles to differentiate data.
presentation format.  Distinguish headings from data using formatting tools.
 Rename each worksheet with a relevant and appropriate
sheet name.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Identify the most appropriate I used Ms. Excel as application based on the instruction to complete.
that can produce a
spreadsheet.


ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 4
Identify the purpose and The purpose of spreadsheet 4 is display the highest mark in the class
audience for each assessment
What is the main purpose of It provides percentage of the total students for the two assessments
the task you have been asked which will displays the highest percentage mark in the class along
to do? with appropriate chart.
Who will be the audience (i.e., Teacher Kaye Wilder and academic manager will be the people using
the people using the the spreadsheet.
spreadsheet)?
Confirm the task requirements  Standard font is: Black Arial 10 pt. Standard college colours are
dark blue and green.
You need to clearly list the
task requirements.  Use portrait page layout format.
Include the data that needs to  Layout data in an easy-to-read format, use formatting styles to
be entered, what needs to be support presentation.
output, the deadlines and
presentation format.  The name of the college should be included in a footer along
with page numbers. Footers must be in size 8, italic.
 Use border styles to differentiate data.
 Distinguish headings from data using formatting tools.



name.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Identify the most appropriate I used Ms. Excel as application based on the instruction to complete
that can produce a
spreadsheet.

the class from teacher attached

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Section 2: Create a spreadsheet
Spreadsheet 1
Enter data provided Data provided entered in the spreadsheet. 4 spreadsheet provided
ensuring consistency of design and layout, meeting the requirement
Using only the information
of the style guide as the per the simulation pack.
provided, enter in the required
data.
You will be creating four
spreadsheets so ensure that
the first one is finalised before
creating the next three. Then
check back and ensure that
each maintains consistency of
design and layout, meeting
the requirements of the style
guide for spreadsheet
document production
provided in your Simulation
Pack.
Enter the required formulae Please refer to the attached spreadsheet appropriate formulae as
required or entered to produce the calculation as stated in case study
You will need to enter in any
information.
formula required to make the
calculations as stated in the
case study information.
Use formatting to present the Please refer to the attached spreadsheet the formatted according to
data the organisational requirements as set out in the simulation pack.
Ensure that the spreadsheet
is formatted according to the

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
organisational requirements
as set out in the Simulation
Pack.
Use the application functions
of the spreadsheet application
to carry out any formatting.
Test the data Please refer to the attached spreadsheet. The data is tested for
accuracy of data and formula
You will need to provide some
dummy data for the student
marks to test the formula and
accuracy of the data.
Create an appropriate chart Please refer to the attached spreadsheet. The Charts that accurately
represent the data are appropriately created following the
Insert a chart that accurately
organizational style guide.
represents the data.
Format the chart
appropriately including
following the organisational
style guide.
Use help functions The help function in the spreadsheet was excess. Please refer to the
screenshot attached for using the help function
During the course of your
spreadsheet design you
should use any help
functions, including dealing

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
with any actions or errors that

the spreadsheet returns.
Take screenshots of using the
help function during two
ocassions. Include the
screenshots as an
attachment.
Confirm that the spreadsheet Please refer to the spreadsheet to attached which need the
meets requirements requirements. The spreadsheet were reviewed and tested for
accuracy and compliance with the task requirements as Identify in
You are to draft an email,
section 1.
confirming that the
spreadsheet meets the task
requirements.
You must show that the
spreadsheet has been tested
with the dummy data and the
results meet the task
requirements as identified in
Section 1.
You must gain feedback from
the head of department (your
assessor).
Attach: Spreadsheet file attached ☐
Screenshots attached ☐

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 2
Enter data provided The data provided is entered in the spreadsheets. Four spreadsheet
is created ensuring consistency of design and layout by the meeting
the requirement of the style guide for spreadsheet as per simulation
pack.
data.
document production
Pack.
information.
Pack.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Format the chart

style guide.
should use any help
screenshots as an

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
attachment.
section 1.
confirming that the
requirements.
Section 1.
assessor).
Screenshots. attached ☐

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 3
pack.
data.
document production
Pack.
information.
Pack.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Format the chart
style guide.
should use any help
screenshots as an

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
attachment.
section 1.
confirming that the
requirements.
Section 1.
assessor).

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 4
pack.
data.
document production
Pack.
information.
Pack.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Format the chart
style guide.
should use any help
screenshots as an

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
attachment.
section 1.
confirming that the
requirements.
Section 1.
assessor).

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Section 3: Review
Spreadsheet 1
Ensure that the spreadsheet Please refer to the attached checklist created to ensure that all task
meets the task requirements requirements as set out in simulation pack
Create a checklist that you
can use to ensure that you
have met all the task
requirements as set out in
Go through and review your
spreadsheet formatting,
formula and charts to ensure
that it meets all the task
requirements.
Ensure that the spreadsheet Please refer to the attached spreadsheet and checklist.
follows organisational
requirements
have met all the
as set out in your Simulation
Pack.
that it meets all the
organisational requirements.
Make any edits and save as a Please refer to the attached spreadsheet and checklist. Which has
final version been reviewed for task and organizational requirements.
After you have reviewed the
task and organisational
requirements and made any
modifications or changes to

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
finalise the spreadsheet, save

as a final version as per the
organisational guidelines in
Send an email to the teachers Email to the teacher

TO: Teacher Mr A J Mubbashar
Draft an email to the
teachers, with the From: Tejas Tamrakar
spreadsheet as an
Date: 15/07/2022
attachment.
Subject: Spreadsheets of Maths Assessments
Hi, A J Mubbashar
I have prepared 4 spreadsheets based on the style, data and layout
provided in the simulation pack. The spreadsheet is link to the
students assessment for mathematics for term 1
I have attached these spreadsheets for your review and feedback
Please contact me if you have any question
Regards
Tejas Tamrakar
Attach: Spreadsheet file with the final version number. attached

☐
Please refer to the attached spread sheet. attached

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 2
requirements.
requirements
have met all the
Pack.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au

spreadsheet as an
Date: 15/07/2022
attachment.
Subject: Sports event results
Hi, A J Mubbashar
provided in the simulation pack. The spreadsheet is link to the Sports
even results
Regards
Tejas Tamrakar
Attach:
Spreadsheet file with the final version number. attached ☐

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 3
requirements.
requirements
have met all the
Pack.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au

spreadsheet as an
Date: 15/07/2022
attachment.
Subject Comparision for students attending camp for each year group
Hi, A J Mubbashar
comparison for students attending camp for each year group
Regards
Tejas Tamrakar
Attach:

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 4
requirements.
requirements
have met all the
Pack.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Make any edits and save as a

final version

spreadsheet as an
Date: 15/07/2022
attachment.
Subject: Displaying highest mark in the class for each assessment.
Hi, A J Mubbashar
displaying highest mark in the class for each assessment
Regards
Tejas Tamrakar
Attach:

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Section 4: File management
Spreadsheet 1
Correctly naming each The files have been named appropriately. A screenshot of a folder is
document attached.
You will need to create a
screenshot to show that you
have named each document
with an appropriate and
relevant filename.
Correctly filing each document Please refer to the screenshot attached.

have filed each document in a
folder with an appropriate
name.

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Correctly exiting the Excel application is correctly exited

application
timed screenshot to show that
you know how to correctly exit
the application.
Attach: Spreadsheet file with the final version number attached ☐
Screenshot of file save attached ☐
Screenshot of folder path attached ☐
Screenshot capture of exiting application attached ☐

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 2
document attached.
relevant filename.

name.

application
the application.
Attach: Spreadsheet file with the final version number. attached ☐


ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au

ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au
Spreadsheet 4
document attached.
relevant filename.

name.

application
the application.
Attach: Spreadsheet file with the final version number. attached ☐


ABN: 74 603 036 102
T: 02 9268 0085
W: www.ahic.edu.au


BSBTEC302 Project Portfolio Tejas

Uploaded by

Copyright:

Available Formats

BSBTEC302 Project Portfolio Tejas

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

BSBTEC302 Project Portfolio Tejas

Uploaded by

Copyright:

Available Formats

Australian Harbour International College

RTO ID: 41338 CRICOS Provider Code: 03449J

First published 2021

0452 157 557

© 2021 RTO Works

Version V2.0/ July 2022 Page 1 of 38

Section 1: Planning and preparation 5

Version V2.0/ July 2022 Page 3 of 38

Student name: Tejas Tamrakar-AHI2001235

Business this assessment is King Edward VII College

 Student Assessment Marks Term 1 for maths. This

Spreadsheet 2:  Students Sports results. This spreadsheet provides average

 This spreadsheet 2 is attached

Spreadsheet 3:  Students attending camp for each year group. This

 The total percentage of student attending the camp along with

 This spreadsheet 3 is attached

Spreadsheet 4: Students Assessment Marks term 1. This spreadsheet provides total

Version V2.0/ July 2022 Page 4 of 38

Section 1: Planning and preparation

The purpose of this spreadsheet in term 1 is Student

 Use border styles to differentiate data.

 Distinguish headings from data using formatting tools.

 Charts must be correctly labelled and presented on the same

 The formatting must follow the standard college colours. The

 Rename each worksheet with a relevant and appropriate sheet

 No figures are to be used in formulae only cell references.

 Rename each worksheet with a relevant and appropriate sheet

Version V2.0/ July 2022 Page 5 of 38

 No figures are to be used in formulae only cell references.

Attach: Submit the spreadsheet design for feedback

Version V2.0/ July 2022 Page 6 of 38

 Standard font is: Black Arial 10 pt. Standard college colours

Version V2.0/ July 2022 Page 7 of 38

Attach: Submit the spreadsheet design for feedback

Version V2.0/ July 2022 Page 8 of 38

 Standard font is: Black Arial 10 pt. Standard college colours

Version V2.0/ July 2022 Page 9 of 38

Attach: Submit the spreadsheet design for feedback

Version V2.0/ July 2022 Page 10 of 38

 Use border styles to differentiate data.

 Distinguish headings from data using formatting tools.

 Charts must be correctly labelled and presented on the same

 The formatting must follow the standard college colours. The

 Rename each worksheet with a relevant and appropriate sheet

 No figures are to be used in formulae only cell references.

Version V2.0/ July 2022 Page 11 of 38

Attach: Submit the spreadsheet design for feedback

Version V2.0/ July 2022 Page 12 of 38

Section 2: Create a spreadsheet

Version V2.0/ July 2022 Page 13 of 38

Version V2.0/ July 2022 Page 14 of 38

with any actions or errors that

Attach: Spreadsheet file attached ☐

Version V2.0/ July 2022 Page 15 of 38

Version V2.0/ July 2022 Page 16 of 38

to carry out any formatting.

Format the chart

Version V2.0/ July 2022 Page 17 of 38

Attach: Spreadsheet file attached ☐

Version V2.0/ July 2022 Page 18 of 38