UPM Institutional Repository

Development of a spreadsheet-based initial ergonomics risk assessment tool using a design thinking approach


Citation

Tan, Daryl Liang Xue (2021) Development of a spreadsheet-based initial ergonomics risk assessment tool using a design thinking approach. Masters thesis, Universiti Putra Malaysia.

Abstract

This study intends to develop an Initial Ergonomics Risk Assessment (IERA) spreadsheet in Microsoft Excel using a design thinking approach. This study is divided into three phases. In the first phase, this involves the first and second stage of the design thinking approach which is to empathize and define the problem. This is done through a focus group discussion involving seven groups, with a total of 35 participants. The second phase involves the ideation and prototyping of the spreadsheet tool. This is done through drafts and sketches of the spreadsheet-based IERA tool to generate ideas based on the users’ requirements. A prototype was then developed on Microsoft Excel using formulas to automate the calculation of ergonomics risk factors. The final phase involves the testing of the IERA spreadsheet. This was done through comparing the level of agreement of the developed tool against the traditional pen and paper approach in performing an IERA at four different companies in Malaysia covering a total of 20 different work units with different ergonomics risk. Feedback on the tool is obtained from the participants of the focus group discussion to determine if the developed spreadsheet fulfils the user requirements. The first phase determined a total of 21 different types of issues which can roughly be grouped into two large categories which are the needs for convenience and the needs for validity. This information is used to develop the spreadsheet tool in the second phase. The second phase involves using the output of the first objective to design and develop an assessment tool using Microsoft Excel to perform an Initial Ergonomics Risk Assessment. This development covers the Ideate and Prototyping stage of the Design Thinking approach. The spreadsheet developed was developed based on the 19 points raised during the focus group discussion and was incorporated in the spreadsheet. In the third phase, the tool was evaluated at a total of four sites with a total of 20 work units and it was found that the reliability for the IERA spreadsheet was found to be in perfect agreement with the pen and paper method through kappa statistics, and the hypothesis is accepted. Feedback from 7 participants is obtained and it was found that in general the user requirements which were discussed in the focus group previously is fulfilled. Findings in this study indicates that the IERA tool which was developed can be used to perform an IERA assessment. The Design Thinking approach used in the development of the tool provides an early understanding of user requirements which is then built into the design of the tool which results in positive feedback on the spreadsheet developed. However, further research work should be considered to address the limitation as reported in the study.


Download File

[img] Text
116915.pdf

Download (1MB)
Official URL or Download Paper: http://ethesis.upm.edu.my/id/eprint/18299

Additional Metadata

Item Type: Thesis (Masters)
Subject: Risk Assessment - methods
Subject: Information Technology - statistics & numerical data
Subject: Human engineering - Data processing
Call Number: FPSK (m) 2021 51
Chairman Supervisor: Professor Shamsul Bahri Mohd Tamrin , PhD
Divisions: Faculty of Medicine and Health Science
Depositing User: Ms. Rohana Alias
Date Deposited: 27 May 2025 03:17
Last Modified: 27 May 2025 03:17
URI: http://psasir.upm.edu.my/id/eprint/116915
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item