Spreadsheets Assessment Tasks for BSBTEC302

This assessment task for BSBTEC302 Design and produce spreadsheets includes 10 knowledge assessment questions on formatting, spreadsheet functions, cloud-based vs non-cloud-based spreadsheets, and organizational formatting styles. The purpose is to assess the student's knowledge on intermediate-level formatting styles, key functions of spreadsheet applications, ergonomic standards, and conservation techniques. The questions also cover the importance of breaks, OOS, and budget design. The output is in JSON format.

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
ASSESSMENT TASK 1 – KNOWLEDGE ASSESSMENT
Assessment task instructions:
This is the first assessment task consisting of 10 written questions. • Successfully complete all activities
in all assessment tasks to be Competent for the unit
Purpose of the assessment task:
The purpose of this assessment task is to assess that the student hold required knowledge required to:
Perform and explain intermediate-level formatting styles appropriate to workplace documents
Understand and use key functions of spreadsheet applications, both cloud-based and non-cloud based and
follow organisational guidelines on spreadsheet design and use and;
Understand and use organisational requirements for ergonomic standards, work periods and breaks, and
conservation techniques and follow correct ergonomic, conservation requirements and relevant
organisational and statutory requirements
Assessment conditions and resources:
The student will have access to the following:
 industry software/applications for producing spreadsheets
 digital device user information
 relevant legislation and codes of practice
 relevant organisational policies and procedures
• relevant workplace documentation and resources, including style guide.
Questions
Read the questions below and provide answers in your own words. This task must be completed
individually. Your assessor will provide you with feedback. Physical factors in the workspace
affect worker’s performance and health.
1.1. List five (5) ways you could improve the layout of your workspace in an office
environment to increase work effectiveness and decrease the possibility of injuries.
(Guide: 5 points –30-50 Words)
 Arranging frequently used things in such a manner to ensure easy accessibility
without much twisting or bending.
 Avoid placing hazardous objects such as knife and heavy metallic objects close
to the computer.
 Making use of ergonomics.
 Maintaining cleanliness to avoid accidents.
 Placing monitor appropriately to avoid neck pain.
1.2. It is the responsibility of every person to try to conserve natural resources whenever
possible. What resource conserving acts would you suggest be used in an office
environment? List five (5) practices that you think may be useful.
(Guide: 5 points –30-50 Words)
 Go paperless by using programs like google Docs.
 Creation of the recycling centre by placing recycling bin for returning recyclable
products.
 Choosing energy efficient electrical appliances.
 Switch off from artificial electricity supply to solar panel.
 Turning off the devices and lights when the device or space not in use.
1.3. It is very important to have safe work practices in any workplace and adequate breaks.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 1 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
a) Explain why you need to have adequate breaks when working on a computer. (Guide:
100-120 Words)
It is very necessary to have regular breaks while working on a computer because it is
helpful in preventing the computer vision syndrome which is commonly demonstrated as
headaches or eye strain. Medical professionals usually suggest that an individual while
working on a computer for long duration must look away from the screen in a regular
interval of 20 minutes for 20 seconds and the vision should not be less than 20 feet
away. Further, it is also necessary to bring down the stress level along with resulting in
getting creative ideas to make work easier and faster. This is possible only when regular
breaks are taken to recharge and relax oneself.
b) The most common injury sustained through keyboard work is Occupational Overuse
Syndrome (OOS) also known as repetition strain injury (RSI). Research this using your
resources provided such as participant guide and explain your understanding of OOS
(Guide: 100-120 Words)
OOS is a common injury associated with elbows, fingers, wrists and hands which results in a
human body due to awkward postures and repetitive movements and accordingly it is also
referred to as a Repetitive Strain Injury. The symptoms of this injury involves weaknesses in the
joints affected by this injury, swelling and pain. There are several ways through which this injury
can be prevented such as maintenance of correct posture, using proper equipment, stop
performing activity while feeling discomfort, etc. On getting confronted with OOS, it could be
treated through exercise, stretching and pain relieving medications.
1.4. Explain what spreadsheets can be used for. In your response give an example of how you
would use spreadsheets in your personal life, classroom or work environment. (Guide:
30-50 Words)
In personal life, spreadsheets are used for managing bill payments and creating weekly or
monthly budgets.
In classroom, it is used for calculating and graphically representing the data.
At workplace, it is used for tracking inventory and performing accounting of daily transactions.
1.5. Research cloud-based and non-cloud-based spreadsheet applications. Explain the
difference between a cloud-based and non-cloud based spreadsheet and name one cloud-
based spreadsheet and non-cloud based spreadsheet. (Guide: 100-120 Words)
Cloud-based A cloud based spreadsheet application is required to have a
continuous internet connection where multiple users can work on
the same application at a time and thus facilitates higher level of
collaboration. Here the application is not downloaded in the
computer system but is accessed through internet browser. For
example, Google sheets.
Non-cloud based Here, the application is downloaded in the system and the data
within the application lives on the owned server. Accordingly, there
is a restrictive access towards the data where the server itself
decide on who can access or not. The server is managed by the
owner itself. For example, Microsoft office excel online.
1.6. Explain the key functions of spreadsheet applications including both cloud-based and non-
cloud-based applications. (Guide: 100-120 Words)
Key functions of cloud-  It assists in storing 7& sharing file, collecting data,
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 2 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
based spreadsheet performing financial accounting and managing inventory.
 Updating the value of assets in the register on real time
basis.
 It facilitates encompassing of email.
 It features an AutoSaved option through which the files get
saved on the internet which could be downloaded on the
local device that is private to the user only.
Key functions of non-cloud-
based spreadsheet
 Facilitates performance of calculation like sum, average,
etc.
 Helps in inserting graph and charts for visual presentation
of data.
 Allows for data entry and data management along with
performing analysis of the same through applying functions
such as SUM, AVERAGE, COUNT, etc.
1.7. Template Lab uses the format below for all their purchase orders. Refer to the sample
purchase order below from Template Lab and explain some of the organisational
formatting styles and guidelines used in this purchase order. (List minimum of 5)
PURCHASE
ORDER
[Company Name]
Street Address[ ] DATE 23/04/202
0
City S[ , T ZIP] PO # 110000
honeP : [phone]
aF x: [phone]
ebsite www templatelab comW : . .
VENDOR SHIP TO
Company ame[ N ] ame[N ]
Contact or Department[ ] Company ame[ N ]
Street Address[ ] Street Address[ ]
City S C[ , T P ] City S C[ , T P ]
honeP : [phone] hone[P ]
aF x: [phone]
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 3 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
SHIPPING TERMS SHIPPING
METHOD DELIVERY DATE
Cost nsurance reight, I & F DFE EX 23/05/2020
ITEM # DESCRIPTION QTY UNIT
PRICE TOTAL
12345478 Small part for S inverterFUJIT U 10 $25.00 $250.00
87654321 ighting adapterL 1 $75.00 $75.00
Comments or Special Instructions [42]
S AUBTOT L $325.00
AT X 10%
SHIPPING $1,000.00
TOTAL $1,357.50
The following organizational formatting styles and guidelines have been identified with
reference to the Template lab’s purchase order:
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 4 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Font colour: It has been found to be black for the text body while for purchase order and total
billed amount it is red. It is the colour of the text.
Text highlight: For the column and row heads and other important details it has been used
which helps in differentiating headings from other content.
Alignment: Right, left and centre alignment have been used which shows the flow of text.
Bold: It makes the text darker as compared to other content. In the above template, it has
been applied on TOTAL and Purchase order.
Font size: The size of the text body is kept as 10.
1.8. If you were working as an administrative support staff and one of your functions was to
prepare a budget, explain what would be the basic elements or key features that you
would need to ensure you follow when designing a spreadsheet for an organisation to use.
(Guide: 100-120 Words)
While designing the budget, the following elements would be used:
 Borders would be used to highlight the budget from rest of the rows and columns.
 Use of text highlighter for total amounts and balance at the end.
 Entering the numeric values in a centre alignment.
 Uses of SUM function to add the values.
 Creation of row headings and column headings for showing particulars and monthly
distribution of budget respectively.
 Applying formatting styles like Bold, text colour and alignment to the row and column
headings.
1.9. Refer to the spreadsheet below and explain the key features of following features of the
spreadsheet in the table below. (Guide: 100-120 Words)
Name Box The name of selected cell of the spreadsheet is displayed here.
Quick Access Toolbar A customized toolbar situated at the top of the window containing
set of command that are used frequently.
Formula Bar It displays the formula containing the selected cell which can be
edited to copied to other cell.
Ribbon Several features offered by spreadsheet is organized in a series of
tabs which is what indicated through ribbon.
Column Letter It is the column heading in spreadsheet displayed as A,B,C,…..
Row Number It is the row heading in spreadsheet beginning from 1,2,3,4,5,6,7,
……
Cell It is the box in which the data is entered.
Spreadsheet Tab It is rectangular tab situated at the bottom left of the sheet.
Status Bar It shows the status of the data that are selected to display the
status on the status bar situation at the bottom of the window.
Sum totals It adds up the value and displayed on the status bar. A separate
function that is SUM function or AutoSum function is also used for
the same.
averages It average out the selected cell range value through AutoSum
feature on Home tab.
Count of values By selecting the count of number option from AutoSum feature on
home tab, it displays the number of values containing the selected
cell range.
1.10. This is a practical task where you are required to
demonstrate that you are able to set up your
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 5 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
workstation to your personal requirements prior to preparing working on a computer to
develop a spreadsheet. Read the instructions below and demonstrate practical application
and understanding of workplace ergonomics. Refer to the policy and procedure attached
as Appendix A when completing this task. You will be observed by your assessor who
will provide you with feedback. Your assessor will ensure that you are able to
demonstrate this skill in an actual office environment individually. This task will take
approximately 10 minutes.
Task instructions
a) Chair – Set chair to a height where your feet are completely flat on the floor. Find a
position that feels comfortable for you. The backrest of some chairs can also be moved
forward or backwards. You should have at least two centimetres of space between the
front of the seat and the back of your knees. The backrest should exert a gentle
pressure on your lower back.
b) Desk - The surface of your desk should be just below elbow height. If you can’t adjust
your desk, consider raising your chair and using a footrest to keep your feet and legs in
the correct position. Keep the space under your desk free of clutter to ensure you have
plenty of leg space.
c) Keyboard - place the keyboard as close as possible to the front of your desk.
d) Mouse - The mouse and mouse pad should sit directly next to your keyboard on the
side you prefer to use. Your wrist should be straight and the desk, not your arm, should
support the weight of your wrist. Try to keep your wrist flat and rest your fingers on the
mouse between clicks.
e) Computer screen - The optimum position for your computer screen is to have the top
of the screen level with or slightly below eye level. To minimise the risk of radiation
exposure and eye strain, keep the screen at least 50 centimetres away from you.
Instructions to the assessor
Use this checklist to observe the student undertake this task. Ensure that each student
undertakes this task individually following the instructions above. The student should
have access to an office environment with an office chair and an office desk. Ensure that
you observe students individually therefore it is important that you take the student aside
to an office environment and assess each student separately. This is for the purpose that
each student demonstrates their skill individually and not being disadvantaged by
demonstrating the skill first. (You can use the counselling office on level 2 which can be
booked for this activity).
1.11. You have demonstrated use of ergonomics. Now list one other relevant legislation
requirement that you need to know about when working with spreadsheets in your
workplace and inserting data in the document for example: personal details for clients.
(Guide: 30-50 Words)
The privacy Act must be known while working with spreadsheets and inserting data in the
document which allows for safeguarding people’s private information through restricting
unauthorised access to personal information.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 6 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
ASSESSMENT TASK 2: PRACTICAL ACTIVITIES
Assessment task instructions:
This is the second assessment task activities to plan spreadsheet design and develop a basic spreadsheet
Successfully complete all activities in all assessment tasks to be Competent for the unit
Purpose of the assessment task:
The purpose of this assessment task is to assess that the student hold required knowledge required to:
•produce spreadsheet documents that align to document purpose and appropriate to target audience
•design spreadsheets that address a range of data and organisational requirements
•use software functions, graphics and support materials to create spreadsheets that adhere to
organisational requirements relating to style and presentation
Assessment conditions and resources:
The student will have access to the following:
 industry software/applications for producing spreadsheets
 digital device user information
 relevant legislation and codes of practice
 relevant organisational policies and procedures
• relevant workplace documentation and resources, including style guide.
Instructions to the students
This task will demonstrate that you have the knowledge and skills to plan, design and create a
spreadsheet. As part of this process you will be required to ensure that:
 The design suits the purpose and audience
 Readability and appearance are enhanced
 Organisational and task requirements for style and layout are followed.
In this activity you will be required to use a style guide attached as Appendix B. Read all
activities and complete as indicated. This task should take you approximately one and half hour
(1.5 hour). If you have any issues, please consult your assessor.
Questions:
2.1 Before you begin creating a spreadsheet it is essential that you understand the workplace
requirements for this process. Provide three examples of what could be included in an
organisational procedures and guidelines in regard to the preparation and presentation of
spreadsheets. (Guide: Small)
Setting the font size for the body, row and column heading, Determining the font style,
the colour for the title of the document.
2.2 Formatting is an important part of creating a spreadsheet. List five formatting techniques
you might use when producing a spreadsheet for the workplace
(Guide: 5 formatting techniques)
Alignment
Font size
Font colour
Resizing rows and columns
Merging cells
2.3 Scenario Activity – Uncle Dan’s Liquor
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 7 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
This is a practical task where you will be required to undertake this task individually. You
must consult with your assessor who will provide you with feedback on your design.
Scenario
You work at Uncle Dan’s Liquor as a sales assistant. Your colleague, Andrew, normally
prepares a spreadsheet at the beginning of the month for the monthly specials. He had to
leave due to family issues and could not complete the July specials spreadsheet. Wine list
for Uncle Dan’s Red July Specials are:
 Penfold’s Merlot 2009. Original price $55. Special is 20% Discount
 Oyster Bay Shiraz, 2015, Original price $39. Special is 10% Discount
 Tempus Two Merlot 2015, Original price $39. Special is 15% Discount
 Hardy’s Merlot 2016, Original price $21. Special is 10% Discount
 Tyrrells Rose 2015, Original price $26. Special is 20% Discount
 Wolf Blass Cabernet Sauvignon 2016, Original price $31. Special is 15% Discount
 Taylors Shiraz 2010, Original price $36. Special is 5% Discount
As you have been working at the business for a few months and know the store well, your
manager Roger has asked you to design the spreadsheet. Andrew left some instructions
which Roger passed on to you to get you to prepare the monthly specials.
The July specials gets released end of June therefore your manager asked you to finalise
the July specials by the 20th of June.
Roger asked you to create the spreadsheet and save it on the company’s folder called
“Monthly Specials” and to name the file as “July Specials”
Roger also asked you see if you can make the spreadsheet attractive and readable by
inserting images and graphics however Roger left it to you to come up with the initial
design but to meet with him before finalising the spreadsheet. Roger however would like
to insert company name and company details such as address and contact details which is
Uncle Dan’s Liquor, 123 Donnison Street, Gosford, NSW 2250, Contact No. 02 945 5060
a) Read the scenario and enter the information in the table below. (Guide: 100-120 Words)
 identify the purpose of the task and who are the audience you are preparing the
spreadsheet for.
 Identify task requirements in relation to data entry, storage, timeline and what
presentation format you are going to use; and
 Select which application you are going to use to prepare the spreadsheet, how you are
going to store it and timeline.
Purpose of the task Preparation of the monthly specials for the month of July.
Who are the
audience?
The audiences are the sales person.
Task requirements To prepare the monthly special in a spreadsheet for the sales
person which includes the list of wine, their original price and
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 8 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
available discount on it.
Choose most
appropriate
application to create
spreadsheet
Microsoft excel is commonly used application for the creation of
spreadsheet which facilitate powerful data crunching.
Where will it be
saved and stored?
The July specials would be saved in monthly specials folder.
Timeline: By 20th of June.
2.4 Plan spreadsheet design
a) You are now required to plan your spreadsheet design to ensure it meets Uncle Dan’s
Liquor organisational requirements. Before creating the first design, observe workplace
ergonomics by adjusting the chair, computer screen, keyboard. You will be observed by
your assessor to ensure you are following correct workplace ergonomic requirements
prior to creating the spreadsheet. Your assessor will act as Roger.
b) You are now required to develop a basic spreadsheet design and meet with Roger to
discuss the design and whether it is appropriate for the company. In your discussion
ensure you discuss with Roger where the company logo should be placed and where the
images of the image about specials should go. You could also ask if you can insert any
other images to make the spreadsheet more attractive to customer’s
JULY WINE SPECIALS INSERT IMAGE HERE
2.5 Creating the spreadsheet
You are now required to create a spreadsheet after receiving feedback from Roger about
the design and enter data as listed below. save as Spreadsheet 2.5 and upload it to your
eLearning.
 In cell A1 type the heading of the spreadsheet called “JULY WINE SPECIALS”
 Insert heading into the following cells:
- In A3 =Brand of the wine
- B3 = Type of wine
- C3 = Original prices
- D3 = Special Discount
- E3 = Sale price
 Insert the following the cells below:
- A4 = Penfolds
- A5 = Oyster Bay
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 9 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
- A6 = Tempus Two
- A7 = Hardys Bay
- A8 = Tyrells
- A9 = Wolf Blass
- A10 = Taylors
 Insert the following the cells below:
- B4 = Merlot 2009
- B5 = Shiraz
- B6 = Merlot 2015
- B7 = Merlot 2016
- B8 = Rose 2015
- B9 = Cabernet Sauvignon 2016
- B=10 = Shiraz 2010
 In cells C4 – C10 – enter original prices ensure it is has a $ value
 In cells D4 to D10 – enter Special Discount and ensure it is having a % value
JULY WINE SPECIALS
Brand of wine Type of wine Original prices
Special
Discount Sale price
Penfolds Merlot 2009 $55 20%
Oyster Bay Shiraz $39 10%
Tempus Two Merlot 2015 $39 15%
Hardys Bay Merlot 2016 $21 10%
Tyrells Rose 2015 $26 20%
Wolf Blass
Cabernet
Sauvignon 2016 $31 15%
Taylors Shiraz 2010 $36 5%
2.6 You are now required to format the spreadsheet to as per below, save as Spreadsheet 2.6
and upload it to your eLearning. Please ensure that you follow the style guide attached as
Appendix A when creating the spreadsheet.
a) Main heading “July Wine Specials” to be font size 14 pt, font type Arial, heading bold
and in colour red or a colour of your choice and in capital letters.
b) Merge the heading from cell A1 – E1 and ensure the heading is centred
c) Heading from cells A5 to A10 – make it font size 12 pts, font type Arial, bold and in
black.
d) Headings from cells B3 to E3 – make it font size 12 pts, font type Arial, bold, in black
and in capital letters.
e) Align the cells from C3 to E3 to the right of the cell and ensure that the value of
these cells are in $ value.
f) Fill the row from A3 to E3 in a different colour of your choice
g) Fill the column from A4 to A10 in a different colour of your choice to make the wines
stand out.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 10 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
h) Insert company name and address and contact number.
JULY WINE SPECIALS
BRAND OF WINE TYPE OF
WINE
ORIGINAL
PRICES DISCOUNT SALE PRICE
Penfold’s Merlot 2009 $55.00 20%
Oyster Bay Shiraz $39.00 10%
Tempus Two Merlot 2015 $39.00 15%
Hardys Bay Merlot 2016 $21.00 10%
Tyrells Rose 2015 $26.00 20%
Wolf Blass
Cabernet
Sauvignon
2016
$31.00 15%
Taylors Shiraz 2010 $36.00 5%
Uncle Dan’s Liquor
123 Donnison Street
Gosford NSW 2250
Contact: 02 945 50 60
2.7 You are now required to calculate the sale price after taking the discount into consideration.
Meet with Roger and discuss your formula to ensure you come up with the accurate sale
price. (Roger is your assessor).
a) Insert what formula did you use below Formula used should be:
=C3-(C3*D3)
b) Using the formula calculate the sale price and insert it into the table.
JULY WINE SPECIALS
Brand of wine Type of wine Original prices Discount Sale price
Penfold’s Merlot 2009 $55.00 20% $44.00
Oyster Bay Shiraz $39.00 10% $35.10
Tempus Two Merlot 2015 $39.00 15% $33.15
Hardy’s Bay Merlot 2016 $21.00 10% $18.90
Tyrells Rose 2015 $26.00 20% $20.80
Wolf Blass Cabernet
Sauvignon 2016 $31.00 15% $26.35
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 11 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Taylors Shiraz 2010 $36.00 5% $34.20
Uncle Dan’s Liquor
123 Donnison Street
Gosford NSW 2250
Contact: 02 945 50 60
2.8 You are now required to Insert images into your spreadsheet to make it look attractive as
per Roger’s instructions.
a) You must use the “Help” function to search on how to insert an image. List the steps
below on how to use the Help function and list the answer below of the outcome of the
help function. Your trainer will observe you accessing the “Help” function. Once you
have found the information, copy the instructions in the space below. (Guide: 30-50
Words).
Selecting the place where the image is required to be inserted. Go in insert tab, click pictures,
select picture and click insert. The selected picture would be displayed in the selected cell
range.
b) Once you have found how to insert images, you are required to insert images into your
spreadsheet to make the spreadsheet more attractive. (this can be an image which you
choose from the internet e.g. wine bottle, specials image however you must choose
images which are free clipart is are copyright). Speak to your assessor if you have any
questions. Insert the completed task below or print and a copy and attach.
JULY WINE SPECIALS
BRAND OF WINE
TYPE
OF
WINE
ORIGI
NAL
PRIC
ES
DISCO
UNT
SA
LE
PRI
CE
Penfold’s Merlot
2009
$55.0
0 20% $44
.00
Oyster Bay Shiraz $39.0
0 10% $35
.10
Tempus Two Merlot
2015
$39.0
0 15% $33
.15
Hardy’s Bay Merlot
2016
$21.0
0 10% $18
.90
Tyrells Rose
2015
$26.0
0 20% $20
.80
Wolf Blass Caber
net
$31.0
0
15% $26
.35
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 12 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Sauvi
gnon
2016
Taylors Shiraz
2010
$36.0
0 5% $34
.20
Uncle Dan’s
Liquor
123
Donnison
Street
Gosford
NSW 2250
Contact: 02
945 50 60
2.9 Read the scenario below and complete this task.
Scenario Continued…
Your specials spreadsheet was used to promote July Wine specials. Roger sent you the figures
for which is shown in the spreadsheet below.
Sales for Dan’s Liquor - Red Wine July Specials. Week 1 Week 2 Week 3 Week 4
Penfold’s Merlot 2009 154 166 148 103
Oyster Bay Shiraz 2015 380 407 67 126
Tempus Two Merlot 2016 159 122 130 204
Hardy’s Merlot 2010 141 121 211 302
Tyrrells Rose 2015 85 74 119 105
Wolf Blass Cabernet Sauvignon 2016 259 219 308 391
Taylors Shiraz 2010 231 100 260 112
a) You are now required to use the “Help” function to search for help on how to calculate
the total sales for the month of July for each wine product. List the formula below.
b) Copy the spreadsheet in the next “worksheet” and calculate the Total Sales for each
wine product.
c) Calculate the total sales made for the month of July.
d) Format the spreadsheet as per your own requirements using formatting features such as
bold, font sizes and names, colours, etc.
e) Save as Spreadsheet 2.9 and upload your spreadsheet to eLearning.
Sales for Dan’s Liquor -
Red Wine July Specials. Week 1 Week 2 Week 3 Week 4 TOTAL
SALES
Penfold’s Merlot 2009 154 166 148 103 $ 571.00
Oyster Bay Shiraz 2015 380 407 67 126 $ 980.00
Tempus Two Merlot 2016 159 122 130 204 $ 615.00
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 13 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Hardy’s Merlot 2010 141 121 211 302 $ 775.00
Tyrrells Rose 2015 85 74 119 105 $ 383.00
Wolf Blass Cabernet
Sauvignon 2016 259 219 308 391 $1,177.00
Taylors Shiraz 2010 231 100 260 112 $ 703.00
Total sales for July
Total
sales
$5,204.0
0
2.10 Using the “Help” feature seek help on “How to create charts” and write instructions below.
(Guide: 30-50 Words)
Select the data for which the chart is required to be created.
Click insert
Recommended chart
Selecting the chart
Click Ok.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 14 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
ASSESSMENT TASK 3: PRACTICAL ACTIVITIES
Assessment task instructions:
This is the third assessment task produce intermediate-level spreadsheet charts Successfully complete all
activities in all assessment tasks to be Competent for the unit
Purpose of the assessment task:
The purpose of this assessment task is to assess that the student hold required knowledge required to:
•follow correct ergonomic, conservation requirements and relevant organisational and statutory
requirements
•produce spreadsheet documents that align to document purpose and appropriate to target audience
•use relevant help functions to rectify intermediate-level document issues
•produce spreadsheet document in appropriate format for review, including ability to create and modify
intermediate-level charts that analyse the dataset
•adhere to designated timelines and requirements for high accuracy.
Assessment conditions and resources:
The student will have access to the following:
 industry software/applications for producing spreadsheets
 digital device user information
 relevant legislation and codes of practice
 relevant organisational policies and procedures
• relevant workplace documentation and resources, including style guide.
Instructions to the students
In this task you are required to demonstrate your ability to create intermediate-level charts and
modify charts. Read the instructions below and complete the tasks individually. Read the scenario
below and complete the task. This task should take you around 30 to 40 minutes.
Scenario
Roger would like you to convert the sales into a chart which is easy to present to the team at the
next team meeting to show how the sales went in July. The organisation always uses two types of
charts pie chart and bar chart to present at team meetings.
3.1 Refer to the spreadsheet you created in task 2.9 and as per the organisational
requirement and convert the spreadsheet into a pie chart using appropriate data range.
Ensure that you chart should show total sales for each product.
3.2 Give the heading “July Wine Sales” in the chart, format the chart.
3.3 Format the chart choosing your own formatting style and insert the chart below
3.4 You now required to convert the pie chart into a bar chart and insert it below.
3.5 Roger needs the second spreadsheet and the charts in 15 minutes to present it to his
manager.
You are now required to review the second spreadsheet and the two charts, format and
edit it, insert company details and contact details for Uncle Dans Liquor and present it to
Roger within 15 minutes. (Roger will be your assessor).
3.6 Name the spreadsheet “July Wine Sales” followed by your student number e.g.
“July_Wine_Sales_34923 and save the file.
3.7 Close the file and exit the application.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 15 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
$571.00
$980.00
$615.00
$775.00
$383.00
$1,177.00
$703.00
July Wine Sales
enfold s MerlotP ’ 2009
yster ay ShirazO B 2015
empus wo MerlotT T 2016
ardy s MerlotH ’ 2010
yrrells RoseT 2015
olf lass CabernetW B
Sauvignon 2016
aylors ShirazT 2010
enfold s MerlotP ’ 2009
yster ay ShirazO B 2015
empus wo MerlotT T 2016
ardy s MerlotH ’ 2010
yrrells RoseT 2015
olf lass Cabernet SauvignonW B 2016
aylors ShirazT 2010
$0.00
$400.00
$800.00
$1,200.00
July Wine Sales
Sales for Dan s iquor Red ine uly Specials’ L - W J
otal SalesT
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 16 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Uncle Dan’s Liquor
123 Donnison Street
Gosford NSW 2250
Contact: 02 945 50 60
ASSESSMENT TASK 4: PROJECT
Assessment task instructions:
This is the fourth assessment task project. Successfully complete all activities in all assessment tasks to be
Competent for the unit
Purpose of the assessment task:
The purpose of this assessment task is to assess that the student hold required knowledge required to:
•follow correct ergonomic, conservation requirements and relevant organisational and statutory
requirements
•produce spreadsheet documents that align to document purpose and appropriate to target audience
•use relevant help functions to rectify intermediate-level document issues
•produce spreadsheet document in appropriate format for review, including ability to create and modify
intermediate-level charts that analyse the dataset
•adhere to designated timelines and requirements for high accuracy
Assessment conditions and resources:
The student will have access to the following:
 industry software/applications for producing spreadsheets
 digital device user information
 relevant legislation and codes of practice
 relevant organisational policies and procedures
• relevant workplace documentation and resources, including style guide.
Instructions to the students
In this task you are required to demonstrate your ability to plan, create and finalise a
spreadsheet. Read the scenario below and complete the tasks individually. Your assessor will be
observing you as you complete this task and will be completing an observation checklist. You will
have a maximum of 2 hours to complete this task.
Scenario
Roger and the management team can see that the promotion in July went quite well. They
would like to get further information to see exactly how successful it was. Roger has asked you
to prepare a spreadsheet comparing the number of sales for the month of July (during the
promotion) to the sales numbers for the months of June and August when there was no
promotion. He believes that this will give a more thorough view of how successful the sale was.
Roger has asked for you to save the completed spreadsheet to a folder called ‘Quarterly Sales
Reports’.
As the spreadsheet will be seen by the management team it is essential that the spreadsheet
complies with the company Style Guide (Appendix B). It is also important to display the
information in a way that is easy to interpret and as visual as possible.
He has provided you with the sales data as follows:
PRODUCT June Sales July Sales August Sales
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 17 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Penfold’s Merlot 2009 400 571 490
Oyster Bay Shiraz 2015 757 980 844
Tempus Two Merlot 2016 500 615 515
Hardy’s Merlot 2010 703 775 717
Tyrrells Rose 2015 115 383 198
Wolf Blass Cabernet Sauvignon 2016 800 1177 990
Taylors Shiraz 2010 650 703 659
4.1. Select and prepare resources
Based on your understanding of the scenario above, describe below in your own words each
of the following (Note: 30-50 Words answer):
 What is the purpose of the spreadsheet?
Compare the sales between months when the promotion is ongoing and when there was no
promotion.
 Who is the intended audience of the spreadsheet?
The management team is the audience of the spreadsheet.
 Where have you been asked to save the document?
In the “Quarterly Sales report” folder of the company.
 How long do you have to complete the spreadsheet?
No timeline provided but it would be in the month of September.
 Were the any special instructions given in terms of how the spreadsheet should look?
Yes, to display the information in such a way that could be easy to interpret and as
visual as possible.
 Which computer program will you use to create the spreadsheet?
Microsoft excel would be used to create the quarterly sales report.
4.2. Plan the spreadsheet
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 18 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Before you begin planning you must first consider the purpose of the document that you
have been asked to create and identify what additional information you will need the
document to contain. You are to create a plan of the spreadsheet including entering all of
the following information:
 the title of the spreadsheet –
 the column headings -
 the row headings
 a space where the charts can be placed
You must ensure that the plan meets all of the formatting requirements as set out in the
Style Guide (Appendix B). Save the document as “Task 4.2 Plan” and submit the plan to
your assessor for feedback prior to moving on with the further tasks.
WINE SALES (JULY - AUGUST)
Products June Sales July Sales August Sales Chart
Penfold’s Merlot 2009
Oyster Bay Shiraz 2015
Tempus Two Merlot 2016
Hardy’s Merlot 2010
Tyrrells Rose 2015
Wolf Blass Cabernet Sauvignon 2016
Taylors Shiraz 2010
Company name & Address
4.3. Create the Spreadsheet
You are now to enter all of the data that you have been provided with for the June, July and
August sales figures. You will need to identify the formulas that can be used within the
spreadsheet to calculate the values required. Consult with your colleagues in class (within
groups of 2 or 3) and discuss and record down below the formulas that you believe will be
necessary to calculate the following. You must ensure that you participate in this
discussion as it will form part of your assessment. Your assessor will observe your
contribution to the discussion and complete the checklist at the end of this task.
a) Write below the formula you will use to calculate the percentage increase in the
number of products sold between June and July for each individual product.
=[(July Sales for the product – June Sales for the product) / June sales for the
product] * 100
Or
=(C3 – B3) / B3 * 100
b) Write below the formula you will use to calculate the percentage decrease in the
number of products sold between July and August for each individual product. Write
below the formula you will use.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 19 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
[(August Sales for the product – July Sales for the product) / July sales for the
product] * 100
Or
=(D3-C3)/C3*100
c) Write below the formula you will use to calculate the total number of each product
sold within the quarter (June, July and August). Write below the formula you will use.
=SUM(B3:D3)
Or
=B3+C3+D3
d) You are now to enter the formulas that you have decided to use and test each to
ensure that they are producing the correct outcome. Once you are satisfied with
each you are to save the document with the formulas visible and present this to your
assessor. Save and submit the document as “Task 4.3 Formulas”
Wine sales (July - August)
Products June
Sales
July
Sale
s
Augus
t Sales
Increase in sales
from June to July
decrease in Sales
from July to
August
Penfold’s Merlot
2009
400 571 490 42.8% -14.2%
Oyster Bay Shiraz
2015
757 980 844 29.5% -13.9%
Tempus Two
Merlot 2016
500 615 515 23.0% -16.3%
Hardy’s Merlot
2010
703 775 717 10.2% -7.5%
Tyrrells Rose 2015 115 383 198 233.0% -48.3%
Wolf Blass
Cabernet
Sauvignon 2016
800 1177 990 47.1% -15.9%
Taylors Shiraz
2010
650 703 659 8.2% -6.3%
Company name & Address
Charts
If you have any concerns when working through this portion of the assessment you can
utilise the help function within the program or consult with your assessor.
4.4. Produce charts
You are to create a chart the demonstrates increases and decreases in sales between the
months of June, July and August. You can select the chart type that you think will best
visualise the data. Remember to check with the Style Guide in Appendix B to verify which
chart styles are approved for use.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 20 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Ensure that the chart is labelled and includes a chart title. Once completed you are required
to adjust the formatting to ensure that it meets the requirements of the Style Guide
(Appendix B).
400
757
500
703
115
800
650
571
980
615
775
383
1177
703
490
844
515
717
198
990
659
Wine Sales (July-August)
June Sales July Sales August Sales
Type of Wine
Sales
Uncle Dan’s Liquor
123 Donnison Street
Gosford NSW 2250
Contact: 02 945 50 60
4.5. Finalise the spreadsheet
Review and edit the final spreadsheet to ensure that it presents all of the necessary
information clearly paying attention to the printing settings to be sure that it will not run
over the page and ensuring that there are no errors. Once you have finalised the
spreadsheet you are to save it to your student drive in the folder you created
called :Quarterly Sales Reports” as ‘Task 4.5 Final Spreadsheet’.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 21 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Appendix A
WORKPLACE ERGONOMICS – POLICY AND PROCEDURE
All recommendations are based upon Australian Standard AS 3590 - Screen-based workstations,
Part 2
To a large extent the above standard still applies, but there have been significant advances in the
field of ergonomics since 1990, as per the graphic here.
Consideration should be given to the:
 accessories required to operate properly
 layout of equipment on the desk
 location of furniture in the room.
Keyboards
Place the keyboard in a position that allows the forearms to be close to the horizontal and the
wrists to be straight. That is, with the hand in line with the forearm. If this causes the elbows to be
held far out from the side of the body then re-check the work surface height.
Some people prefer to have their wrists supported on a wrist rest or the desk. Be careful not to
have the wrist extended or bent in an up position.
Chairs
Adjust the seat tilt so that you are comfortable when you are working on the keyboard. Usually,
this will be close to horizontal but some people prefer the seat tilted slightly forwards.
Your knees should be bent at a comfortable angle and greater than 90º flexion. If this places an
uncomfortable strain on the leg muscles, or if the feet do not reach the floor, then a footrest
should be used. The footrest height must allow your knees to be bent at 90º; the height of the
footrest may need to be adjustable.
Adjust the backrest so that it supports the lower back when you are sitting upright. A range of
chairs is available.
Phones
Avoid cradling the phone between your head and shoulder when answering calls. If you need to
use your computer at the same time, use a headset or the phone's hands-free/speaker-phone
capabilities if the environment is suitable.
Monitors
Set the eye-to-screen distance at the distance that permits you to most easily focus on the
screen. Usually this will be within an arm's length.
Set the height of the monitor so that the top of the screen is below eye level and the bottom of
the screen can be read without a marked inclination of the head. Usually this means that the
centre of the screen will need to be near shoulder height. Your eyes should be level with the tool
bar.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 22 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
People who wear bifocal or multi-focal lenses will need to get a balance between where they see
out of their lenses and avoid too much neck flexing. The height of the monitor can be adjusted
using a monitor riser.
Document holder
Place the document holder close to the monitor screen in the position that causes the least
twisting or inclination of the head.
Back to top
Desks
Adjust the height of the work surface and/or the height of the chair so that the work surface
allows your elbows to be bent at 90º, forearms parallel with the floor, wrist straight, shoulders
relaxed.
Place all controls and task materials within a comfortable reach of both hands so that there is no
unnecessary twisting of any part of the body. Most people prefer the document holder to be
between the keyboard and the monitor. There are many different types of document holders
available.
Lighting, glare and reflection
Lighting
Place the monitor to the side of the light source/s, not directly underneath. Try to site desks
between rows of lights. If the lighting is fluorescent strip lighting, the sides of the desks should be
parallel with the lights. Try not to put the screen near a window. If it is unavoidable ensure that
neither the screen nor the operator faces the window.
If the monitor is well away from windows, there are no other sources of bright light and prolonged
desk-work is the norm, use a low level of service light of 300 lux. If there are strongly contrasting
light levels, then a moderate level of lighting of 400-500 lux may be desirable.
Glare and reflection
It is important to detect the presence of glare and reflection. To determine whether there is glare
from overhead lights, sit down and hold an object such as a book above the eyes at eyebrow level
and establish whether the screen image becomes clearer in the absence of overhead glare.
To detect whether there are reflections from the desk surface, hold the book above the surface
and assess the change in reflected glare from the screen.
You can eliminate or reduce the influence of these reflections in a number of ways:
 Tilt the screen (top part forwards) so that the reflections are directed below eye level.
 Purchase an LCD screen.
 Cover the screen with a light diffusing surface or anti-glare screen.
 Negative contrast screen (dark characters on light background) will reduce the influence of
these reflections.
If you experience eye discomfort when using a bright screen, you should make the following
adjustments:
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 23 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
 Turn the screen brightness down to a comfortable level.
 Look away into the distance in order to rest the eyes for a short while every 10 minutes or so.
 Change the text and background colours. We recommend black characters on white or yellow
background, or yellow on black, white on black, white on blue and green on white. Avoid red
and green and yellow on white.
Using a mouse
A well-designed mouse should not cause undue pressure on the wrist and forearm muscles. A
large bulky mouse may keep the wrist continuously bent at an uncomfortable angle.
Pressure can be reduced by releasing the mouse at frequent intervals and by selecting a slim-line,
low-profile mouse. Keep the mouse as close as possible to the keyboard, elbow bent and close to
the body.
Keyboard equipment and radiation
Computer screens emit visible light that allows the characters on the screen to be seen. Weak
electromagnetic fields and very low levels of other radiation that are not visible to the human eye
can be detected by sensitive instruments. Similar emissions are produced by television receivers.
The levels of most radiations and electromagnetic fields emitted from computers are much less
than those from natural sources, such as the sun or even the human body, and are well below
levels considered to be harmful by responsible expert bodies such as the International Radiation
Protection Association (IRPA).
Posture while typing
Good posture is essential for all computer users. You should adopt a natural and relaxed position,
providing opportunity for movement, from which you can assume a number of alternative
positions.
 There is no single, rigidly defined position.
Typing technique
Typing is a physical activity, and using a keyboard requires skill, hence the need to learn correct
typing technique. Unskilled ('hunt and peck') typists are particularly at risk of "occupational
overuse injury" because they:
 often use only one or two fingers which may overload the finger tendons
 are constantly looking from keyboard to screen to keyboard, which may strain neck muscles
 often adopt a tense posture (wrists bent back and fingers 'poised to strike').
Speed of keying
The efficiency and speed of modern computers makes it possible for a skilled operator to type
extremely quickly. This capability, reinforced by workload pressures, means the potential exists
for operators to key at speeds which may cause or contribute to occupational overuse syndrome.
The role of the repetitive movement in injury is not fully understood, but is believed to interfere
with the lubrication capacity of tendons, and the ability of muscles to receive sufficient oxygen
supplies.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 24 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Ten thousand to 12,000 keystrokes per hour is considered an acceptable standard.
Length of time on the keyboard
The maintenance of a fixed posture for long periods is tiring and increases the likelihood of
muscular aches and pains. In addition, long periods of repetitive movement and sustained visual
attention can also give rise to fatigue-related complaints.
It is recommended that operators take regular postural/stretching breaks to reduce intense
periods of repetitive movement.
Employees newly engaged in keyboard work, and staff returning from an absence of two or more
weeks, need a period of adjustment. The adjustment may be achieved through reduced work
rates, or provision of alternative duties with a gradual reintroduction to keyboard work.
Jobs should be designed and organised so that either:
 computer-related tasks can be interspersed with non-computer related, or
 computer based tasks can be rotated amongst several staff (task/job sharing).
Supervisors should ensure that workload controls are exercised using the following strategies:
 planning ahead to avoid peaks, and rushed jobs
 delegating fairly to all staff not just the best workers
 considering the total workload of the individual (often comes from a number of sources)
 clearly defining each operator's workload
 implementing systems of prioritisation such as work request forms and waiting lists
 using relief staff
 applying strict tests to the use of 'urgent' labels
 discouraging 'endless' drafts
 discouraging the use of typed internal minutes and memoranda
 encouraging authors to have realistic expectations
 teaching authors keyboard skills
 teaching operators how to be assertive, and how to prioritise
 supporting operators when authors impose unrealistic expectations
 refusing illegible drafts.
Posture and environment
Change your posture at frequent intervals to minimise fatigue. Avoid awkward postures at the
extremes of the joint range, especially the wrists.
Take frequent short rest breaks rather than infrequent longer ones. Avoid sharp increases in work
rate. Changes should be gradual enough to ensure that the workload does not result in excessive
fatigue.
After prolonged absences from work the overall duration of periods of keyboard work should be
increased gradually if conditions permit
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 25 of 26

ASSESSMENT TASKS
Qualification: BSB30120 Certificate III in Business
Cluster number and name: BC3-20_5.2 Spreadsheets
Units of competency: BSBTEC302 Design and produce spreadsheets
Student’s ID: and Full Legal Name Please insert student ID this column and on all pages,
Assessor’s name: Please ensure assessor name is inserted.
Relevant Legislation
Work Health and Safety Act 2011
Appendix B
STYLE GUIDE
Uncle Dan’s Liquor
This style guide must be adhered to at all time when creating spreadsheets for the company.
 Font for the body of the text – Size 12
 Font for the headings of the columns –size 14
 Font for the Row headings – size 14
 Font style = Arial
 Company logo must appear on the bottom right corner
 Title of the document to be in red
 Graphs and charts should be inserted within the document and should be blue, orange, grey
and yellow
 Charts should be bar or pie charts.
 Any charts of graphs must have a title.
 Use images where possible to enhance the document.
C S C Assessment oolB 3-20_5.2_B BTE 302 T Version ssued un6 I 29 J 2022
ageP 26 of 26