Please enable JavaScript.
Coggle requires JavaScript to display documents.
College rewards program website (User Problems (Users (Brett Toombs (Needs…
College rewards program website
Client problem
Constraints
Copyright & legal: reference code sources
6-8 weeks work period
Multi-media presentation
Excel spreadsheet currently used
User interface
Homepage with login option
Data displays for logged in user
Links to school and volunteer company's website
User Problems
Existing solution
Excel spreadsheet
Physical paper tables
Users
Michael Blue
Uses smartphone to access web services
Year 12 student wanting to get involved (requires information)
Requires the ability to edit volunteer sessions based on changing schedules
Brett Toombs
Needs a notification system to track students' progress
Able to use pre-existing solution, computer literate
Coordinates student service program
Needs to be able to upload and manage permission forms
Needs to be able to all students who are participating in specific sessions
Claudia Pudelko
Works at Rosies, needs an web application where she can confirm and add service hours to the database for different students
Requires a verifiable teacher account where she can add notes to a student's profile
Computer literate, uses smartphone to access web services
The college wants to reward students for community service
Requires a a simple to use website to handle all aspects of program
Developer Problem
Data handling
Database
Use a central database in Access to store data
Use SQL to retrieve data
Allow verified users to update the database
Separate database for storing user login details
Users able to change their own login details
Should store name, password, email of users
Storing user data
Student name, last name, email, number of community service hours, location, signature of confirmation
Protecting the data of users
Use a username/password system to authenticate users and prevent unauthorized access to information
2 factor authentication when a person signs in on a new device
Privacy policy on website
User Interface
Option on homepage for users to register
Validate email address- code sent to email
Button linking to login form
Ability to contact supervisors
Usability
Website safety
Ease of access
CARP principles
Ability to check student progress at a glance (dashboard)
Automated email reminder to students
Coding required
CSS for website design
SQL for retrieving and updating data
HTML for website layout