BSBTEC302_AE_Sk3of3
docx
keyboard_arrow_up
School
TAFE NSW - Sydney Institute *
*We aren’t endorsed by this school
Course
BSBTEC302
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
34
Uploaded by ElderMoon11633
Assessment event 3 of 3: Skills
Criteria
Unit code and name
BSBTEC302 | Design and produce spreadsheets
Qualification/Course code and name
Select your Qualification/Course code and name from the dropdown
.
:
Certificate III Accounts Administration
Student details
Student name:
Student number:
Document title: BSBTEC302_AE_Sk3of3
Page 1 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Version:
20230310
Date created:
20 December 2022
© TAFE NSW 2023
RTO Provider Number 90003 | CRICOS Provider Code: 00591E
This assessment can be found in the TAFE NSW Learning Bank
.
The content in this document is copyright © TAFE NSW 2023 and should not be reproduced without the permission of TAFE NSW. Information contained in this document is correct at time of printing: 16 February 2024. For current information please refer to our website or your teacher or assessor as appropriate. Document title: BSBTEC302_AE_Sk3of3
Page 2 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Assessment instructions
Table 1 Assessment instructions
Assessment details
Instructions
Assessment event overview
The aim of this assessment is to assess your knowledge and performance in developing spreadsheets through the use of spreadsheet applications.
This assessment is in 2 parts:
Part 1: Store spreadsheets
Part 2: Plan and produce spreadsheets
And is supported by:
Checklist
Assessment feedback
Simulated organisation Gelos Enterprises
BSBTEC302_AE__Appx_Data.xlsx
Appendix: Gelos Style Guide extract
Note
: This assessment may contain links to external resources. Access to the long URL is provided via the External resources – Links and URLs
section located at the end of this document.
Unit assessment guide
Refer to the unit assessment guide (UAG) before attempting this assessment event. The UAG contains information including assessment requirements and how to achieve a satisfactory result.
Submission instructions
When you complete this assessment:
read the checklist at the end of the assessment to make sure you have completed everything
keep a copy of all the electronic and hardcopy assessments you submit to TAFE NSW
make sure you have completed the assessment declaration before you submit. Document title: BSBTEC302_AE_Sk3of3
Page 3 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Microsoft Office applications
As a TAFE student, you are entitled to a free copy of the full version
of Word, Excel, PowerPoint, and Publisher for your studies.
To access this software go to www.office.com
then:
Sign in with your TAFE credentials (TAFE email address and password).
Select Install Apps (top right hand side).
Select Microsoft Office 365.
Save the set up file.
Step through the installation process (Mac or PC version will automatically be detected).
Assessment instructions
For this assessment you will design and produce the following:
1.
Spreadsheet for Mobile phone stock on hand
2.
Spreadsheet for June property sales
Task instructions
The assessor will use the criteria outlined in the following parts to determine if you have satisfactorily completed this assessment event. Follow these instructions to ensure you demonstrate the required knowledge and skills.
Document title: BSBTEC302_AE_Sk3of3
Page 4 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Part 1: Store spreadsheets according to organisational requirements Read the instructions carefully and refer to Gelos Style Guide and Policies as required.
While completing these tasks, it is important that you adhere to the Gelos WHS Procedure – Ergonomics
policy and any other relevant legislation and codes of practice for work health and safety. Ensure your workspace and computer are set up correctly and that you take regular breaks. Task 1.1 Create folder and store files
Before you begin the assessment tasks, you will need to create a folder to store downloaded
and saved files. Instructions
1.
Create a new folder: BSBTEC302 Assessment 3
.
Figure 1 – Example screenshot of the new folder
2.
You will be using data from an existing spreadsheet. Download
the following Excel file: BSBTEC302_AE_Appx_Data.xlsx
.
(Note: You may have already downloaded the BSBTEC302_AE_Appx_Data.xlsx
spreadsheet containing the data when completing Skills Assessment 2).
Document title: BSBTEC302_AE_Sk3of3
Page 5 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Part 2: Plan and produce spreadsheets
For this part of the assessment, you will plan and then produce spreadsheets according to requirements and following the Gelos Style Guide extract
.
While completing this task, it is important that you adhere to the Gelos WHS Procedure – Ergonomics
policy and any other relevant legislation and codes of practice for work health and safety. Ensure your workspace and computer are set up correctly and that you take regular breaks. Task 2.1 Plan the phone stock on hand spreadsheet
Refer to the below scenario and mobile phone data
located in the worksheet tab A3
Sheet 1
.
Figure 2 Use data from A3 Sheet 1
Scenario
As well as administering the day-to-day activities of the office and producing business documents, you also provide support to other Gelos managers. Purchasing Manager, Rob Miller
requires a spreadsheet to display all phone stock on hand
for the current financial year. He needs this spreadsheet by Thursday morning
and has reminded you to follow the Gelos Style Guide extract
for formatting and presentation. Rob has also asked you to create a column chart
that displays the total stock on hand for each phone.
1.
Complete the following Spreadsheet Plan:
Table 2 Spreadsheet plan 1
Spreadsheet Plan What
is the purpose of the spreadsheet?
Click or tap here to enter text.
Who
will be the audience of this spreadsheet?
Click or tap here to enter text.
Document title: BSBTEC302_AE_Sk3of3
Page 6 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Spreadsheet Plan List
two organisational requirements for these tasks (Refer
to Gelos Style Guide)
Click or tap here to enter text.
Click or tap here to enter text.
What
type of chart is to be inserted?
Click or tap here to enter text.
What
would be the title
of this chart?
Click or tap here to enter text.
When
is this task due?
Click or tap here to enter text.
Task 2.2 Produce the phone stock on hand spreadsheet
Using your plan and the following instructions, design and produce the phone stock on hand spreadsheets. Instructions – Phone stock on hand spreadsheet
Table 3 Spreadsheet instructions
Spreadsheet instructions
ü
1.
Select the most appropriate software for this task.
☐
2.
Type (or copy) the A3 Sheet 1 mobile phone data to a new
spreadsheet. ☐
3.
Rename
this worksheet, ensuring that it reflects the data in the worksheet.
☐
You will be creating formulas to calculate the profit
(markup), GST
, cost price
and selling price
for each phone, as well as the total value
of each phone model. 4.
Markup and GST
:
First create labels and values for markup
and GST
. Markup is 45%
GST is 10%
. Either name
these values or
use absolute referencing
, in your formulas. ☐
Add columns, headings and formulas
into your worksheet to calculate the following:
5.
Stock Value:
This is the value of the stock on hand at cost price. For example, ☐
Document title: BSBTEC302_AE_Sk3of3
Page 7 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Spreadsheet instructions
ü
multiply the Cost Price x Quantity.
6.
Markup Value
: The markup value will be the profit you make on the item (in this case, 45% of the cost price). For example, multiply the Cost Price x Markup. (Remember to use either an absolute or
named cell
reference in this formula).
☐
7.
Cost Price (including Markup): This is the value of the Cost Price after the 45% Markup has been included. For example, add together the Cost Price + Markup
Value. ☐
8.
GST Amount:
Calculate the GST amount for each item. For example, multiply the Cost Price (including Markup) x GST. (Remember to use either an absolute or named cell
reference in this formula).
☐
9.
Selling Price:
The price that each item will sell for (including the Markup Value
and GST Amount
). For example, add together the original Cost Price + Markup Value + GST Amount.
☐
10.
Total Sell Value:
Calculate the total selling value of each product. For example, multiply the Selling Price x Quantity. ☐
11. Beneath the spreadsheet data, add labels
and formulas
to calculate:
a.
Total Value of Stock
b.
Total Sell Value
c.
Number of Products (use the Count
or CountA
function)
d.
Average Selling Price (use the Average
function)
☐
12. Insert the heading Gelos Enterprises above your data (you may need to insert a
row/s): Format as Heading 1
. Merge and centre heading across columns.
☐
13. Format Phone Stock on hand at 30 June
as Heading 2 and merge and centre across columns. ☐
14. Refer to the Gelos Style Guide extract
for spreadsheet formatting requirements and incorporate in design.
☐
15. Adjust column widths so all data is appropriately displayed and ensure wrap text has been applied as necessary. ☐
16. Apply middle alignment to all headings (so that text is centred between the top
and bottom of the cell).
☐
17. Apply cell borders to outline or separate your data and identify totals.
☐
Document title: BSBTEC302_AE_Sk3of3
Page 8 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Spreadsheet instructions
ü
18. As a separate sheet, insert a column chart
to show the Stock Value for each Model
. Add a suitable chart title (you do not need to add a legend). ☐
19. Rename both sheets with appropriate tab names. ☐
20. Orientation of both sheets to be landscape
.
☐
21.
Footer
: Insert a footer for both sheets
(following the Gelos Style Guide footer requirements). ☐
22.
Header
: Insert a header for both sheets
(following the Gelos Style Guide header requirements). ☐
23. Review the spreadsheet and task. Edit or make corrections if required.
☐
24.
Print preview
your worksheets. Ensure the contents of each sheet are balanced on the page
(centred evenly between top, bottom, left and right margins) and that each sheet would print on 1
page only.
☐
25. Save and name your file as per Gelos records and management information procedure
and store it in accordance with organisational requirements. For example GE_Phone_stock_june.xlsx
.
☐
26. Close application.
☐
Document title: BSBTEC302_AE_Sk3of3
Page 9 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task 2.3 Plan the property sales data spreadsheet
Refer to the below scenario and the property sales data
located in the worksheet tab A3
Sheet 2. Figure 3 Use data from A3 Sheet 2
Scenario
Property Manager, Myer Kingsley
requires a spreadsheet to display the June
property sales for the following three
suburbs:
Kappa, Gimmel and Lambda
. Data for each suburb will be
placed in a separate worksheet
. All worksheets will follow organisational requirements and as per the Gelos Style Guide. Myer will be presenting this spreadsheet to the Real Estate Institute and needs this spreadsheet by next Tuesday. Complete the following Spreadsheet Plan:
Table 4 Spreadsheet plan 2
Spreadsheet Plan Who
will be the audience of this spreadsheet?
Click or tap here to enter text.
What
will you name this spreadsheet file?
Click or tap here to enter text.
List
two organisational requirements for this task? (Refer to Gelos Style Guide)
1.
Click or tap here to enter text.
2.
Click or tap here to enter text.
How
many worksheets are required to store and display your data? Click or tap here to enter text.
What
is the deadline for this spreadsheet task?
Click or tap here to enter text.
Document title: BSBTEC302_AE_Sk3of3
Page 10 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Task 2.4 Produce the property sales data spreadsheet
Using your plan and the following instructions, design and produce the property sales data spreadsheet. Instructions – Property sales data spreadsheet
Table 5 Spreadsheet instructions
Spreadsheet instructions
ü
1.
Select the most appropriate software for this task.
☐
2.
Create a new blank workbook and copy the A3 Sheet 2 property sales data (or sheet) and paste to your new workbook.
☐
3.
Sort
the data by Suburb in Ascending (A-Z) order.
☐
4.
Insert
a new sheet for each of the 3
suburbs.
☐
5.
Rename
the three new sheets (each worksheet tab name
to match the suburb name. Change the tab colour
of each worksheet (Gimmel = blue
, Kappa = red
and Lambda = Green
).
☐
6.
Move
each suburb’s sales data (also copy the headings) to the appropriate worksheet.
☐
7.
Delete the original A3 Sheet 2 sheet.
☐
For each worksheet: (
Tip
: Group
sheets first)
8.
Insert the heading Gelos Enterprises above your data (you may need to insert a
row/s): Format as Heading 1
. Merge and centre across columns.
☐
9.
Insert the heading June Property Sales
as Heading 2 and merge and centre across columns. ☐
10.
Below the data, add headings
and formulas that calculate the following:
The Total Sales
Value
for each suburb
Count the Number of Sales
for each suburb.
The Highest Sale Price for each suburb.
The Lowest Sale Price for each suburb.
The Difference
in sale prices for each suburb.
☐
11.
Adjust column widths so all data is appropriately displayed.
☐
12.
Apply cell borders to outline or separate your data.
☐
13.
Orientation of all sheets to be landscape
.
☐
14.
Footer
: Insert a footer for all sheets
(following the Gelos Style Guide extract
☐
Document title: BSBTEC302_AE_Sk3of3
Page 11 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Spreadsheet instructions
ü
footer requirements). 15.
Header
: Insert a header for all sheets
(following the Gelos Style Guide extract
header requirements). ☐
Tip
: Remember to ungroup
sheets
16.
Review the spreadsheet and task. Edit or make corrections if required.
☐
17.
Print preview
your worksheets. Ensure the contents of each sheet are balanced on the page
(centred evenly between top, bottom, left and right margins) and the data and chart would print to 1
page. ☐
18.
Save and name your file as per Gelos records and management information procedure
and store it in accordance with organisational requirements. ☐
19.
Exit application
☐
Document title: BSBTEC302_AE_Sk3of3
Page 12 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Part 3: Finalise spreadsheets
Task 3.1 Finalise spreadsheets You had earlier advised Property Manager, Rob Miller that you had designed and produced the phone stock on hand
spreadsheet, and asked for his feedback (Note: you did not need to create an email to Rob Miller). Rob has responded, and provided you with the following feedback: Email
From:
Rob Miller
Sent:
Monday, 01 September 202X 10:44 AM
To:
Administrative Assistant
Subject:
Finalising Stock on Hand Spreadsheet
Dear Admin Assistant Thank you for help with the phone stock on hand spreadsheet. The spreadsheet looks great however I would like you to make a few changes to the chart:
The Stock on Hand Chart
needs to include Data Labels
to show the value of the stock on hand for each phone.
Please change the chart title
font colour to Gelos
blue-grey
I’d like you to highlight our highest stock value phone. Please change the fill colour of this column only, to Gelos
orange
.
We need to include the Gelos Logo
in this chart sheet. Again, thank you for your assistance. If you have further questions, please ask. Kind regards
Rob Miller
Product Manager
m: 0491 000 000
Document title: BSBTEC302_AE_Sk3of3
Page 13 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Instructions – Finalise spreadsheets
1.
Open your previously created June phone stock
spreadsheet and create a copy
of the chart sheet.
2.
Rename this sheet Chart 2. Make the following changes to the Chart 2
sheet:
3.
Add data labels (to the outside end of columns) showing the value of stock for each phone.
4.
Change the chart title font colour to blue-grey (refer to Gelos colour theme
).
5.
Change the column fill colour, of the highest stock value phone only, to orange (refer to Gelos colour theme).
6.
Insert the Gelos Enterprises Logo
into the top right corner area of the chart sheet (copy and paste the below logo). 7.
Save and close the file.
8.
Using the Gelos email template on the following page, write to Rob Miller confirming:
☐
that you have made the changes as requested.
☐
the amended chart still follows the Gelos Style guide, ☐
a request to confirm formulae are tested and output meets task requirements, ☐
the final spreadsheet file is attached. Document title: BSBTEC302_AE_Sk3of3
Page 14 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Email
From:
To:
Cc:
Date:
Subject:
Attachment(s):
Kind regards
Your Name
111 Business Avenue TULITZA NSW 9460 p: 02 0000 0000 e: contactus@gelosmail.com.au
Save a tree. Please do not print this email unless you really need to. This message, including any attachments, is intended for the individual to whom it is addressed. It may contain privileged or confidential information. If you are not the intended recipient, please delete it and notify the sender. You must not disclose, copy or use the information in this message. Document title: BSBTEC302_AE_Sk3of3
Page 15 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Submission checklist
Submit the following for marking:
☐
This completed Assessment event 3 of 3: Skills
☐
Phone stock on hand spreadsheet
☐
Property sales spreadsheet
Document title: BSBTEC302_AE_Sk3of3
Page 16 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Checklist
The assessor will use this checklist while observing you completing your assessment. Read the checklist to understand what skills you need to demonstrate/ items you need to complete or submit. You must meet all the criteria. Note that S = Satisfactory and U/S = Unsatisfactory.
Document title: BSBTEC302_AE_Sk3of3
Page 17 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Table 6 Checklist
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
Part 1
Task 2.1
Create a new folder: BSBTEC302 Assessment 3
☐
☐
☐
☐
Date:
Part 2
Task 2.2
1
Plan the spreadsheet by providing all relevant details in the template provided (Table 2 – Spreadsheet plan 1).
☐
☐
☐
☐
Task 2.2
1
Most appropriate software selected. ☐
☐
☐
☐
2
Data from the A3 Sheet 1
worksheet copied/typed onto new spreadsheet
☐
☐
☐
☐
3
Worksheet tab renamed to reflect data in the worksheet ☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 18 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
4
Labels for Markup
and GST
added to spreadsheet, values added and cells named or referred to in formulae using absolute referencing
☐
☐
☐
☐
5
Stock value
(at cost price) formula added using cell names
or absolute referencing
☐
☐
☐
☐
6
Markup Value formula added using cell names or absolute referencing
☐
☐
☐
☐
7
Cost Price (incl Markup) formula added using cell names
or absolute referencing
☐
☐
☐
☐
8
GST Amount formula added using cell names or absolute referencing
☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 19 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
9
Selling Price
formula added using cell names or absolute referencing
☐
☐
☐
☐
10
Total Sell Value formula added using cell names or absolute referencing
☐
☐
☐
☐
11
Beneath the spreadsheet data, add labels and formulas to calculate:
a)
Total Value of Stock
b)
Total Sell Value
c)
Number of Products (using the Count or CountA function)
d)
Average Selling Price (using the Average function)
☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 20 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
12
Heading Gelos Enterprises added above data and formatted as Heading 1
. Merged and centred across columns.
☐
☐
☐
☐
13
Heading Phone Stock on hand at 30 June
formatted as Heading 2. Merged and centred across columns
☐
☐
☐
☐
14
Gelos Style Guide for spreadsheet formatting incorporated in design
☐
☐
☐
☐
15
Column widths adjusted so all data is appropriately displayed,
wrap text applied as necessary
☐
☐
☐
☐
16
Apply middle alignment to all headings
☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 21 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
17
Apply cell borders to outline or separate data
☐
☐
☐
☐
18
Column chart
added as separate sheet to show the Stock Value for each Model
. Suitable chart title added and no legend displayed
☐
☐
☐
☐
19
Both sheets renamed
with appropriate tab names
☐
☐
☐
☐
20
Orientation of both sheets is landscape
☐
☐
☐
☐
21
Insert a footer for both sheets following the Gelos Style Guide
☐
☐
☐
☐
22
Insert a header for both sheets following the Gelos Style Guide
☐
☐
☐
☐
23
Reviewed the spreadsheet and ☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 22 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
task. Errors or corrections edited if required
24
Print preview your worksheets.
Ensure the contents of each sheet are balanced on the page
and each sheet would print to 1 page
☐
☐
☐
☐
25
Save and name file as per Gelos
records and management information procedure and store it in accordance with organisational requirements
☐
☐
☐
☐
Task 2.3
Plan the spreadsheet by providing all relevant details in the template provided (Table 4 – Spreadsheet plan 2).
☐
☐
☐
☐
Task 2.4
Most appropriate software ☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 23 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
1
selected.
2
New workbook created and copied the A3 Sheet 2 property
sales data to the new workbook
☐
☐
☐
☐
3
Sorted the data by Suburb in Ascending (A-Z) order
☐
☐
☐
☐
4
Inserted
a new sheet for each of the 3
suburbs
☐
☐
☐
☐
5
Renamed
the 3 new sheets (each worksheet tab name
to match the suburb name). Changed the tab colour
of each
worksheet (Gimmel = blue
, Kappa = red and Lambda = Green
).
☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 24 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
6
Moved
each suburb’s sales data (also copy the headings) to the appropriate worksheet.
☐
☐
☐
☐
7
Deleted the original A3 Sheet 2
sheet
☐
☐
☐
☐
8
Insert the heading Gelos Enterprises above the data and
format as Heading 1
. Merge and centre across columns
☐
☐
☐
☐
9
Insert the heading June Property Sales
as Heading 2 and merge and centre across columns.
☐
☐
☐
☐
10
Below the data, add headings
and formulas that calculate:
The Total Sales
Value
Count the Number of Sales
☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 25 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
The Highest Sale Price
The Lowest Sale Price
The Difference
in sale prices 11
Adjust column widths so that all data is appropriately displayed
☐
☐
☐
☐
12
Apply cell borders to outline or separate data
☐
☐
☐
☐
13
Change the orientation of the spreadsheet to landscape
☐
☐
☐
☐
14
Insert a footer following the Gelos Style Guide ☐
☐
☐
☐
15
Insert a header following the Gelos Style Guide ☐
☐
☐
☐
16
Reviewed the spreadsheet and task. Errors or corrections edited if required
☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 26 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
17
Print preview the worksheet. Ensure contents are balanced on the page and it will print to 1 page
☐
☐
☐
☐
18
Name your file as per Gelos records and management information procedure and store it in accordance with organisational requirements
☐
☐
☐
☐
Part 3
Task 3.1
1
Open your previously created June phone stock
spreadsheet and create a copy
of the chart sheet
☐
☐
☐
☐
2
Rename copied sheet Chart 2
☐
☐
☐
☐
3
Add data labels (to the outside end of columns) showing the value of stock for each phone
☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 27 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
4
Change the chart title font colour to blue-grey as per Gelos colour theme
☐
☐
☐
☐
5
Change the column fill colour, of the highest stock value phone only, to orange as per Gelos colour theme
☐
☐
☐
☐
6
Insert the Gelos Enterprises Logo
into the top right corner area of the chart sheet
☐
☐
☐
☐
7
Save and close the file
☐
☐
☐
☐
8
Using the Gelos email template, write to Rob Miller confirming:
that you have made the changes as requested
the amended chart still follows the Gelos Style ☐
☐
☐
☐
Document title: BSBTEC302_AE_Sk3of3
Page 28 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Task
number
Did the student do the following?
S
U/
S
S
U/
S
Assessor comments
Describe the student’s ability in demonstrating the required skills and knowledge. Record your
observations in enough detail to demonstrate your judgement of the student’s performance against the criteria required.
guide
a request to confirm formulae are tested and output meets task requirements
the final spreadsheet file is attached.
Document title: BSBTEC302_AE_Sk3of3
Page 29 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Additional evidence for verification of assessment
Assessors may ask questions to clarify your understanding during the assessment event.
You may be asked questions:
to clarify your understanding (for example, ‘Why did you select that particular piece of equipment?’)
to capture contingencies that may form part of the demonstration (for example, dealing with faults or unexpected events)
to prevent a work, health and safety incident.
If questions are required during the assessment event, these questions and your responses will be recorded in this table.
Table 7 Additional evidence Questions asked by assessor Student responses Document title: BSBTEC302_AE_Sk3of3
Page 30 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
External resources – Links and URLs Long URLs and permalinks are provided for access to content when the assessment is not used digitally, for example, not clickable. Table 8 Long URLs Resource Name Long URL The Learning Bank
https://share.tafensw.edu.au/share/home.do
Simulated organisation Gelos Enterprises
https://share.tafensw.edu.au/share/items/d0b458dc-3922-
409d-b1fe-9a2f785f4a38/0/?attachment.uuid=5f1677bf-
8296-4137-ae33-8b9e30bad1ab
BSBTEC302_AE_Appx_Data.xlsx
https://share.tafensw.edu.au/share/items/d17aa037-a71b-
4a21-8761-9fc3d7d174fe/0/?attachment.uuid=cebf4c54-
f031-4903-9b25-db0b09dc72ca
Gelos WHS Procedure – Ergonomics
https://share.tafensw.edu.au/share/file/b7f3345c-19b3-
422a-8b3c-5eb1d2950cee/1/GE_Ergonomics-
procedure_admin.pdf
Gelos records and management information procedure
https://share.tafensw.edu.au/share/file/5f1cec7b-1d03-
446a-85b7-edb42692c34e/1/GE_Records-information-
management-ICT-procedure.pdf
Document title: BSBTEC302_AE_Sk3of3
Page 31 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Appendix
Gelos Style Guide Extract
Below is an extract from the Gelos Style Guide
. For consistency in design and layout ensure all spreadsheets meet the below style guide requirements.
Spreadsheet elements will reflect the Gelos colour theme:
Spreadsheets (Extract)
Style
Requirements
Normal/Default
Font:
Calibri
Font Size:
11 pt
Font Colour:
Black
Heading 1
Font:
Georgia
Font Size:
18 pt, bold
Font Colour:
Orange (R221, G171, B94)
Heading 2
Font:
Georgia
Font Size:
14 pt, bold
Font Colour:
Turquoise (R7, G122, B153)
Column, Row and Label Headings
Font: Calibri
Font Size: 12 pt
Font Colour: White
Cell Alignment:
Centre
Cell Fill Colour: Blue-Grey (R66, G71, B84)
Margins
All margins - left, right, top and bottom:
2 cm
Layout
All data
to be centred horizontally and vertically on the page. All Document title: BSBTEC302_AE_Sk3of3
Page 32 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Style
Requirements
spreadsheets are to be reviewed via Print Preview
prior to delivery. Sustainability
Where possible
spreadsheets to fit one page
Cell alignment
Text:
left-aligned (unless column heading)
Numbers/Dates:
right-aligned
Borders
Add suitable borders to identify cells containing data
Total rows only
must be formatted with top
and double bottom
borders Number formatting
Dollar values with cents: Currency style with two decimal places eg. $21.23
All other numerical data: Zero decimal places
Header
Font: Calibri
Font Size: 9 pt
Font Colour: Black
Left: Sheet tab name
Margin: 0.8
Footer
Font: Calibri
Font Size: 9 pt
Font Colour
: Black
Left: (
Automatic
) File name
Centre
: Current date eg. 14/11/2023
Right
: Author’s name
Margin: 0.8
Chart Styles
2D column chart or pie chart
Must have an appropriate chart title at the top
If a legend is required, it should sit to the right of the chart
Axis titles and percentage (%) labels where appropriate
Chart title
Font: Calibri
Font Size: 12 pt
Font Colour: Black
Student assessment declaration
This assessment is my original work and has not been:
Document title: BSBTEC302_AE_Sk3of3
Page 33 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3 This page is not required for online assessment submissions.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
copied from any source without proper referencing
written for me by any other person except where such collaboration has been approved by a teacher or assessor.
Student signature and date
Reasonable adjustment
☐
Reasonable adjustment was in place for this assessment event. If so, please provide details of any reasonable adjustment strategies that were implemented:
[Insert reasonable adjustment strategies]
Assessment outcome
☐
Satisfactory
☐
Unsatisfactory
Comments
[Insert comments]
Assessor name, signature and date
Student acknowledgement of assessment outcome
[Would you like to make any comments about this assessment?]
Student name, signature and date
Document title: BSBTEC302_AE_Sk3of3
Page 34 of 34
Resource ID: SEN1635_BSBTEC302_AE_Sk3of3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help