AIC College: BSBITU402 Spreadsheet Development in Hospitality

This assignment solution addresses the BSBITU402 unit, 'Develop and Use Complex Spreadsheets,' within the Advanced Diploma of Hospitality Management. Task 1 focuses on workplace ergonomics, health and safety hazards associated with computer use, and energy conservation strategies for Covers Books. It includes a checklist for workstation setup, identification of potential health hazards, exercises to reduce injury risk, and computer energy conservation settings. The assignment also requires identifying spreadsheet needs for Covers Books, suggesting data storage and backup solutions, and explaining the impact of ethical principles, privacy laws, and Work Health and Safety regulations on business operations. The solution provides detailed answers to each question, covering topics such as posture-related problems, eyesight issues, stress injuries, headaches, obesity, sleeping problems, and strategies for mitigating these risks. The solution also includes a discussion of human resources and its role in managing employees and ensuring compliance with relevant laws and regulations.

Sub
sion
Course SIT60316 Advanced Diploma of
Hospitality Management
Unit Code BSBITU402
Unit Name Develop and Use Complex
Spreadsheet
Assessor
Name
Student
Name
Student ID
Date Due
Please read and sign this
assessment coversheet
and submit it together
with your assessment to
your Assessor by the due
date.
Student Declaration
 I declare that
the work
submitted is my
own, and has
not been copied
or plagiarised
from any
person or
source.
 I have read the
Plagiarism
Policy and
Assessment
Appeal and
Reassessment
Policy in the
Student
Handbook and I
understand all
the rules and
guidelines for
undertaking

assessments.
 I understand that
by typing my
full name in the
student field this
is equivalent to a
hand-written
signature.
 I give permission for
my assessment
material to be used
for continuous
improvement
purposes.
Student
Signature
Date
Submitted
Assessment Items
Task 1 Assignment S NS
Task 2 Report S NS
Final Result for this unit C
Student Declaration: I declare that I have been
assessed in this unit, and I have been advised of my
result. I am also aware of my appeal rights.
A
s
s
e
s
s
o
r
D
e
c
l
a
r
a
t
i
o
n
:
I
d
e
c
l

a
r
e
t
h
a
t
I
h
a
v
e
c
o
n
d
u
c
t
e
d
a
f
a
i
r
,
v
a
l
i
d
,
r
e
l
i
a
b
l
e
a
n
d
f
l
e
x
i
b
l
e
a
s
s
e

s
s
m
e
n
t
w
i
t
h
t
h
i
s
s
t
u
d
e
n
t,
a
n
d
I
h
a
v
e
p
r
o
v
i
d
e
d
a
p
p
r
o
p
r
i
a
t
e
f
e
e
d
b
a
c
k

Signature Signature
Date

Educating for Excellence

Task 1
Assessment Instructions
This is an individual assessment. There are two parts in this task. If you need help understanding any questions, ask
your assessor to explain.
Part A
You are required to prepare to develop Excel spreadsheets to manage the business requirements for Covers Books
(see Appendix 1). You are required to setup or adjust your workstation in accordance with ergonomic
considerations, practical layout of necessary documents and resource conservation requirements. You are also
required to answer questions on legislative knowledge, organisational and task requirements.
To be deemed competent you will need to successfully demonstrate the following:
 You must complete and successfully answer all questions.
Question 1
Setup or adjust your workstation, desk or work area in accordance with ergonomic considerations, the practical
layout of necessary documents and Work Health and Safety requirements. Complete the checklist to setup or
adjust your work area.
Ergonomic and environmental checklist
Yes No
Are you placed under pressure to meet demanding work targets or deadlines? Yes
If yes, is the pressure a result of external sources or your own disorganization? Yes
Has there been consistency in workload recently? (this is preferable to sudden increases
in workload or working overtime)
No
Have work pauses been taken as appropriate? Yes
Is the chair easily adjusted from a seated position? Yes
Can you get close to the workstation without impediment? No
Is the seat height adjustable so that your thighs are parallel to the floor, with feet
resting on the floor or a footrest?
Yes
Is the backrest height-adjusted to fit into the small of your back and adequately support
your spine?
Yes
Is the backrest angle-adjusted so that you are sitting upright while typing? Yes
Are your forearms parallel with the floor or slightly angled downward? Yes
Is the desk height adjustable? Yes
If yes, is the adjustment easily operated?
If no, do you have a footrest?
Yes
If there is a footrest, is it large enough to support both feet and allow a change of
position?
Yes
When sitting tall and looking straight ahead, are you looking at the top edge of
the screen?
Yes
Is the screen at a comfortable reading distance? Yes
Are all characters in the display easily legible and the image stable? Yes
Can the position and contrast of the screen be adjusted by the user? Yes
Is the keyboard detached from the screen to ensure a comfortable working
position?
Yes
Is the keyboard thin enough for comfortable positioning of the arms (it should be less
than 30mm thick at the home row of keys)?
Yes
Is the keyboard matte finished to prevent irritation from glare and reflection? Yes

Yes No
Are all commonly used items within easy reach (normal arm reach with
minimal truck movement)?
Yes
Is there sufficient space for large documents, completed work or writing? Yes
Is there sufficient space for CAD furniture, equipment and hard copy materials? Yes
Is the workstation designed to prevent undue twisting of the neck and trunk? Yes
Do you find the lighting satisfactory? Yes
Do you find the noise level conducive to concentration? Yes
Do you find the temperature and airflow in the room comfortable? Yes
Question 2
List five potential health and safety hazards that could occur during the use of a computer.
Question 3
Describe two exercises and one other strategy (not exercise) that you can undertake to reduce the risk of injury
when using a computer. Explain how often you would recommend the exercises are done
Question 4
Setup or adjust the energy conservation settings on your computer using the following settings. Take a screen
shot of the settings screen showing that you have made the requested adjustments.
1. Set the monitor to turn off after 15 minutes of inactivity.
2. Set the computer to go into standby mode after 1 hour of inactivity.
Question 5
Using the information provided in Appendix 1, describe two additional ways that DJ could conserve energy or
resources at Covers Books.
Question 6
Using the information provided in Appendix 1, identify the task requirements by undertaking the following tasks.
1. Identify at least three spreadsheets Covers Books are likely to need.
2. Briefly describe the purpose or use of each spreadsheet.
Question 7
Where and how would you suggest that DJ store the business records?
Ensure that you include references to both hard (paper) and soft (electronic) storage suggestions and data back-
up options in your answer.
Question 8
Explain how each of the following may affect business operations at Covers Books:
a. Ethical principles
b. Privacy laws
c. Work Health and Safety laws and regulations.

INTRODUCTION
Human resources is a part of organisation that handles the charge of screening, recruiting and training of
employees and other job applicants. It also manages programmes that are held for employees benefits. HR plays a vital
role in supporting businesses in dealing with rapid changing business environment. Human resource is an crucial element
for every organisation. They generally have task of maximising the efficiency and productivity of employees as well as
secure the companies environment and workplace with any kind of issue related to workforce. Responsibility and duties
of HR includes benefits, compensation, recruitment and remaining update with all rules and regulation that might effect
the operations of business and employees (Anbu, 2019). This report is divided into two tasks, in task 1, analyses of health
issues and harms that can cause with use of computer and other electronic devices is discussed. And, in task 2 an excel
sheet will be prepared to identify the values of investment.
TASK 1
PART A
Question 1
Question 2
Five problem related to health and safety hazards which can occur while using computer are listed below:
Posture related problems – The neck ache, complications, and shoulder and arm ache are common place computer
associated injuries. Such muscle and joint troubles may be prompted or made worse by using terrible notebook
design, awful posture and sitting for extended intervals of time. Even though sitting requires less muscular effort
than standing, it still reasons bodily fatigue and also need to keep components of body steady for lengthy periods of
time. This reduces flow of blood in muscle tissues, bones, tendons and ligaments, every now and then leading to
stiffness and pain (Chowdhury, 2020). If a PC is not always installation well, those steady positions can put even
greater strain for your muscles and joints. The safety rules are as follow:
 To sit the comfortable chair
 Always use the ergonomic keyboard that the fingers and wrists are hold in one position.
Eyesight problem – When the eyes are constantly looking in computer for long time then it weakens eyes and eyesight
as well. The human eyes specially focuses on those things that are kept at distance of more than six meters. When
the people work on computer they give more emphasis of eye muscles. Tips to follow to prevent eyes from
straining:
The screen of the computer should not too close to eyes
The eyes should always keep maintaining a proper distance.
Stress injuries- Repetitive pressure damage results from forceful, awkward, and repetitive use of limbs, producing
broken muscular tissues, tendons, and nerves. The severity of RSI instances varies broadly. Tendonitis is the maximum
not unusual example of RSI, even as carpal tunnel syndrome is a more rare and severe disorder.
Headaches- Complications due to headache are common and may arise due to the weak muscle anxiety or ache in the
neck. Any vision related issues, or persevered pressure at the eyes also can cause complications. To reduce the headaches
individual needs always to get the eyes check up at regular interval, keep the neck in front of computer and takes the
break at regular interval (Gaudenz and et.al, 2019).
Obesity- Prolonged use of computers may also cause a common sedentary way of life that lacks in physical hobby or
workout. To reduce the obesity, the computer should be used only for maximum 8 hours.
Sleeping problems- Synthetic lighting fixtures, this is given off from laptop screens can certainly trick the mind and
suppress its release of melatonin the substance that assists sleeping styles. Before going to bed must read the novels and
stories so that person could not face problems related to sleep (Haraj and et.al, 2019).
Question 3
The two exercise and one strategy that help to reduce the risk of injury when using a computer: In the latest years, the
immoderate use of computer systems at workplaces has caused a spiralling within the paintings-related issues. Research
shows that laptop-related accidents account for nearly 70% of occupational dangers in phrases of injuries.
Side to side turning- This type of exercise to reduce the tension in neck area. The procedures are to follow:
 To rotate the head lightly to the left and right.
 The proper preserve of eyes at the horizon, aiming the chin in the direction of the shoulders.
 Consciously, attempt to recognition the eyes on something inside the distance.
 To repeat this steps into five times.
Stand up: This exercise helps to reduce the pain of neck and back. The following steps are to follow to do exercise:
 Region the heels of the fingers into the decrease again
 To go elbows lower back and down
 To maintain the head and neck regular with the chin tucked in
 Slowly arch the returned and look at the ceiling.
The best strategy that helps in reducing the risk of injury while working on the computer:

The computer screen should not shinning on the face: Bends the monitor's neck slightly to avoid reflections or glare
on eyes and face. The computer screen should not too close to the face and must keep the lightening of screen at barely
low level according to the degree of eyesight. Lessen the contrast and brightness of your screen through adjusting
controls and frequently appears far from the computer screen and attention on items that are away from eyes. The person
should regular do eyesight examinations to test that any blurring in eyesight, complications while seeing something and
other associated issues are not due to other underlying problems (Javadian and et.al, 2020)
Question 4
Question 5.
Two foremost ways through which DJ can save their scare resources and energy at Covers Books: If organisations
navigate with the uncertain time, it definitely pays to be prudent regarding the resources that are available to the business.
With the implementation of correct plans or strategies and smart leadership, business can achieve more. Some ways are
described below that will help Covers Books in conserving their resources and energy (KENAROVA-PENCHEVA and
et.al, 2018):
Assessment of behavioural fit in leadership team: Choosing and implementing the perfect strategy is very much
difficult and this whole process requires a team, not an individual is able to adapt strategy within workplace. Business
needs to ensure that they have a leadership team that can see through the new strategies. Top level of management should
take a fair and close observation a the team members and then, equipped the right set of plans to execute the strategic
priorities. It is important to find out that at which place leadership strengths lies along with the gaps in leadership
strengths and weaknesses, it becomes easy for the leader to handle the team when they have a good coordination with
team members. Leaders should have an objective with unbiased view for increasing efficiency among team otherwise
they will leave inefficiencies unchecked. If there were any cracks in the top level of management then they have strong
negative effect at bottom level also. There are various ways available through which an organisation can assess better fit.
With the use of behavioural data, management get an overview into an individual's needs and workplace drives.
Generally, team executives are innovative and creative thinkers, but if management adapt strategy that focuses on
retention of consumers then they need a team that have on people not on creative thinking (Konovalova and et.al, 2021).
Communicate changes from top level to bottom level: To be clear with priorities and tasks organisation needs a strong
and proper plan to channelize better communication on the part of top management leadership. When making some
changes within workplace, it must be done through passing regular updates down the organisation. If business seems to
do reduction in expenditures, then it is necessary to communicate the importance of consolidating tools. The more
transparency management sets with their employees, it becomes more easier to maintain trust at top to bottom level, that
leads in conserving resources through increase in efficiency and dedication towards achieving organisational objects and
goals (Langkana and et.al, 2022).
Question 6
Spreadsheets that Covers Books task requires:

Financial spreadsheets: Organisations uses spreadsheets to maintain their accounting data. It involves management of
budget such as maintaining track record of expenditures and income. Spreadsheets involves automated formatting options
for currency and option to represent negative data in red that provides a accurate presentation of business's financial
condition. Businesses uses spreadsheets to record specified aspects of their cash inflow and cash outflow such as payroll
expenditures. Many spreadsheets programs are available that allows multiple worksheets for performing conjunction with
other worksheets. This model will help in creating single sheet for all cash inflows and another for cash outflows with
balance sheet that represents total of both the sheets of income and expenses.
Small Databases: Spreadsheet is the foremost thing for maintaining regular records and daily user fires this up whenever
they require any information to be collected such as inventory data, contact list and logging custom things, spreadsheet is
a easiest way to find these data and its maintenance as well. Files of small database spreadsheets usually does not have
many formulas in their records and their content is often seems to be heavy in comparison to other spreadsheets. These
files from small database are generally small in size as their size is approximately less than 1,000 rows of data and it
includes only two-dimensional data. Usually, complicated information and data structures can be found in spreadsheets
that are user-created (Lewicka and Pec, 2018).
Multidimensional contains more than two headers in single table that commonly add a dimension and still
presented in the grid of two-dimensions.
Hierarchical reflects some rows in table that are at lower level and rolls up these rows to the higher level.
Even rational can be defined as data and information on single sheet that reflects the details of another sheet and
can be said as additional list row children of parent.
Statistical: Spreadsheets are commonly used for capturing the data, but spreadsheets provide ways to analyze and
manipulate the sets of data. Applications in spreadsheet such as excel that consists a range of pre defined formulas for
applying arithmetic and statistical calculation on sets of data. It also enables in creating own formulas for performing
these calculations and to reach at analysis that fits according to the business needs. General functions of spreadsheet often
includes sampling, averages and distribution calculations. Fundamental spreadsheet involves straight forward arithmetic
calculations such as multiplication, addition, subtraction and division.
Question 7
Requirement of maintaining business records:
Keeping business records is important for maintaining productivity in the functions of the business. An accurate record
management system is plays role as foundation that provides support to the business intelligence and capability to take
decisions that are data driven which can affect bottom line of business. However, Covers Books seeing more data, such
as some digital data and some paper based following their core of business. Organisation requires a proper document
management strategy that will provide tools and techniques for managing business records control and streamlined
(Sarumaha and et.al, 2018).
 Leverage automation to identify vital data: Maintaining all documents are not records, it totally depends on
the nature of business. Documents that are duplicates and rough drafts does not need more storage and
information management. It is also impractical and time consuming to go through each document for crucial
information. It is necessary to leverage automation such as auto detection and keyword scanners for identifying
crucial data and documents that can clearly separates important information from unnecessary data's and it also
constitutes a proper maintenance of business records.
 Integrate devices that can assist with data capture: There are various techniques available for collection
information, documents and records due to sources present such as multifunction printers, scanners and mobile
devices. Covers Books must rely on these ultra efficient multifunction devices that are able in performing various
functions at same device. Typically, these all devices available with their own software that integrates the device
with rest of offices workflows. These different devices have strong abilities such as automated transmission of
scanned document to electronic storage and can create automatic fax from email. This captured file can be
quickly shared from one place to another that is time saving and easier for the right individual to get access at
right time.
Question 8
The following terms may affect business operations:
a. Ethical principles- The ethical principles are set by the company that are follows by the employees, managers and other
staff members of an organisation. These principles included the rules, regulations and standards that dominate the
employees how to work in the enterprise. Customers known how to survive the business in dynamic environment. If the
enterprises function are conduct in proper manner, then it creates the trust within the employees. The good reputation of
an enterprise creates a loyal customer base. The various types of ethical principles that should apply in the workplace
(Shoja and et.al, 2020).
1. Develop of ethical practices- Company should always do better in the enterprise. Teal leaders should establish
code of ethics in their workplace and share with all workers.

2. Implementation of ethical practices- before developing code of ethics company should establish the rules and
regulations that are implement the polices. To implementation the polices there should be giving the practices.
3. Compliance- If the company wants to run the business smoothly then company should follow the rules and
practices that are applied in the company such as trading regulations, state level codes and ordinary building
ordinances (Silva and et.al, 2018).
b. Privacy laws- The business organisation should always aware the impact of data privacy. The manager of an
organisation focuses the customer needs. The data is the gold of the business operation. There are various principles that
help to protect the data. Each organisation makes legal framework to safe the information. These framework provides the
information how to an enterprise collect data and how to stores it. The statistics safety Act, 1998, protects touchy
information of corporations and governments by using enforcing regulations on sharing such information or facts. The
Act has several laws that you should comply with whilst you gather and percentage statistics.
c. Work health and safety laws and regulations- It plays an important role in the business organisation. It ensures that the
employees are worked on the selected tasks. These laws are support the employees, employers and the consumers with
implementing the safety rules at workplace. Healthy and safety rules mean all the employees and other staff are safe in
the workplace. There are many laws that are applied in the workplace. Traditionally, fitness and protection at paintings
has been associated with environments that pose an element of apparent threat. But, all places of work, no matter how
apparent the dangers are, want to take heed to fitness and protection rules (Tavakoli and et.al, 2018).
CONCLUSION
The purpose of the report is to highlight usage of electronic devices at workplace that could harm the potential
health of individuals working at workplace. Afterwards, to maintain an excel sheet and identify salary, age and benefits
of employees. It can be concluded from above report that, human resources is the foremost resource for every
organisation as Covers Books also and working in terms of ensuring better health condition of employees is crucial along
with conserving scare resources and energy with various methods helps Covers Books in increasing their efficiency.
Maintenance of different spreadsheets and business records helps in saving time and eliminate unnecessary operations.

REFERENCES
Books and Journals
Anbu, D., 2019. A review on human resources management (HRM) theories and effective human resource management
models. Asian Journal of Multidimensional Research (AJMR), 8(5). pp.81-93.
Chowdhury, S., 2020. The ‘4V’approach in strategic human resources management post-covid-19. International Journal
of Engineering and Management Research (IJEMR), 10(4). pp.98-105.
Gaudenz and et.al, 2019. Factors associated with care workers’ intention to leave employment in nursing homes: A
secondary data analysis of the Swiss Nursing Homes Human Resources Project. Journal of Applied
Gerontology, 38(11). pp.1537-1563.
Haraj and et.al, 2019. Impact of Strategic Planning on Human Resources Management Practices: An Empirical Study of
Iraq. The Journal of Social Sciences Research, 5(3). pp.626-633.
Javadian and et.al, 2020. Human Resources Productivity with a Structural Equation Modeling Approach in the
Organization. Urban Management Studies, 12(42). pp.71-82.
KENAROVA-PENCHEVA and et.al, 2018. THE ROLE OF INTERNAL BRANDING TO INCREASE THE
ENGAGEMENT AND MOTIVATION OF HUMAN RESOURCES. Analele Universitatii'Eftimie Murgu'Resita.
Fascicola II. Studii Economice, (25).
Konovalova and et.al, 2021. Perspectives and restraining factors of HR analytics in the conditions of digitization of
human resources management. In Socio-economic Systems: Paradigms for the Future (pp. 1015-1024). Springer,
Cham.
Langkana and et.al, 2022. Analysis of Competence Motivation and Employee Character on Public Service Quality
Through Human Resources Readiness at the Ministry of Law and Human Rights North Sumatra Regional
Office. Locus Journal of Academic Literature Review. pp.117-129.
Lewicka, D. and Pec, M., 2018. The impact of human resources management on job involvement. The mediating role of
vertical trust. Folia Oeconomica Stetinensia, 18(2). pp.34-45.
Sarumaha and et.al, 2018. Improving the Quality of Human Resources Through Local Cultural Values (The Tradition of
HomboBatu on Nias Island). Advanced Science Letters, 24(1). pp.150-153.
Shoja and et.al, 2020. Prioritization and Systematic Rview of Relationships between Dimensions of Operational Risk of
Human Resources.
Silva and et.al, 2018. Competencies and skills of site managers from the point of view of human resources professionals
and site managers. Business Management Dynamics, 7(9). p.1.
Tavakoli and et.al, 2018. Proposing a green human resource management model on the basis of human resource
management. Journal of Research in Human Resources Management, 10(1). pp.77-104.
Vyas, L., 2019. Customization in civil service training: Implications for outsourcing human resources
management. International Journal of Public Administration, 42(1). pp.41-54.