SLP Case Manager

Individual MVP project. This web app allows speech-language pathologists to keep track of their caseload, including student data and due dates for paperwork. It also allows SLPs to take and record data and session notes.

Features

The app has two pages. On the Caseload page:

• There is a form where the speech therapist can add new students to their student list.
• The speech therapist can see a table listing all of the students on their caseload and their data, including their first and last names, date of birth, the number of minutes of speech therapy they receive per month, and the dates that their annual review and triennial reevaluations are due.
• Each column of the table is sortable in ascending and descending order. The clinician can easily locate students and see which paperwork is due soon by clicking on the column header.

On the Progress page, the speech pathologist can take and record session data:

• There is a list of students in the sidebar listed in alphabetical order by last name.
• Upon clicking on a student's name in the sidebar, a component appears which shows:
  • the selected student's name, speech goal, a form for adding new sessions
  • the student's speech goal
  • a calculator that the clinician can use in real time to track student trials
  • a form for taking and recording session data
  • a list of summaries of previous sessions, where the most recent session is at the top and the oldest at the bottom

Set-up Instructions

Dependencies

• Open a new terminal window
• Run npm install in the project's root folder to install Node/Express dependencies
• Open a new terminal window
• Enter cd client to navigate to the client folder
• Run npm install to install React dependencies

Database Setup

• Open a new terminal window
• Run mysql -u root -p to access MySQL
• Create a .env file in the project's root folder and enter the following:

DB_USERDB_HOST=localhost
DB_USER=root
DB_NAME=speech
DB_PASS=your_password
DB_TIMEZONE="+00:00"

• In a new terminal, in the project directory, run npm run migrate to create tables

Development

• Run npm start in the root folder to start the Express server on port 5001.
• Run npm start in the client folder to start the server on port 3000.

MySQL Database Schema

API Routes

Frontend

Wireframes

User Flow

React Components

This is a student project that was created at CodeOp, a full stack development bootcamp in Barcelona.