IKEA HaparandaTornio employ some two-hundred people in its furniture retail store.
Keeping track of staff statistics and employee information has previously been achieved
through the use of a basic Microsoft Office Excel spreadsheet. The store’s human resources
department requested an upgrade to this system with the hope of speeding up and
simplifying the administrative process, as well as to make it easier to monitor HR-related
target statistics. The following report documents the development process of that upgrade as
carried out by the author. The project draws on research in usability design and cognitive
psychology to develop a user-friendly interface. Particular focus has been put on features
related to the administration of employee information, including adding, editing and
deleting personnel entries, as well as a clean and informative statistical interface. The result
is an Excel-based information system that uses VBA programming to achieve said goals.
The vast majority of planned features were implemented, although some were revised or
scaled-down due to limitations in Excel. Overall the project goal was reached, but work will
continue in order to enhance the final result.
2012. , 26 p.