Staff Rota Management System

Software	Language with good GUI tools, DBMS, probably HTML/CSS
Covers	Programming, interface design, databases
Skills Required	Programming
Challenge	Conceptual ? Technical ?? Programming ??

Brief Description

Based on a project idea by Marcus Kerr.

Many companies and other organisations need to manage their staff rotas, to make sure that they have enough staff on duty at particular times. The aim of this project is to develop a database system that enables a manager in an organisation to allocate staff to particular shifts, and enables members of staff to see when their shifts are. It should offer a graphic overview of the staff deployment for a particular day, or a few days, and a graphic view of the shifts allocated to one particular staff member over a longer time.

Desirable features the system could have include:

The ability to create shift allocations for multiple days or weeks in one go, so that Laura is scheduled to work every Thursday evening, etc.
The ability to specify and display staff deployments in particular locations, for organizations that can assign staff to work in different places or on specific tasks.
The ability to associate members of staff with specific competences, and specify how many people with which competences are needed on a particular shift, so that the manager and other interested and authorised parties can see whether a shift is fully staffed, and if not, which competences are needed.
The ability to record and display members of staff preferences for which shifts they want to work, and which they don't, and whether staff have committed to work particular shifts or whether they haven't, so that managers can attempt to accommodate the desires of their staff, and can see whether allocations are firm or provisional.
Enabling the system administrator to specify who has how much access to the system so that the organization can choose whether to restrict full overview over the rotas to the managers, or to allow staff to sign up or withdraw from shifts themselves, or have the degree of access that's appropriate to the company.

Back to