PAI-Group

Student Wellbeing Project The university is exploring ways to better understand and support student wellbeing. At present, data such as lecture attendance, coursework submissions, and optional weekly wellbeing surveys are collected separately, but there is no single system to combine or analyse these data sources. The Student Wellbeing Office has therefore asked your development team to design and implement a small prototype system. The system should:

1. Collect and store data according to your requirement analysis – e.g. weekly attendance, submission deadlines, survey responses (e.g. stress levels 1–5, hours slept).
2. Provide simple analytics – e.g. calculate average attendance per student, identify weeks with higher stress levels, or visualise changes over time.
3. Allow the authorised users to create, read, update and delete (CRUD) the data. The prototype does not need to be production-ready. Still, it should demonstrate how such a system could be developed in Python, with a relational database backend, and include some simple data analysis and visualisation features.

Installation

To set up the project locally, follow these steps:

1. Clone the repository or download the source code.
2. Create a virtual environment:

   python3 -m venv .venv

3. Activate the virtual environment:
   • On macOS/Linux:

     source .venv/bin/activate

   • On Windows:

     .venv\Scripts\activate

4. Install dependencies:

   pip install -r requirements.txt

5. Seed the database:

   python seed_db.py

Usage

To run the application:

streamlit run app.py

To run the tests:

pytest