Please enable JavaScript.
Coggle requires JavaScript to display documents.
Digital Solution Using Alumni Data Set - Coggle Diagram
Digital Solution Using Alumni Data Set
Data
Main Data Source - Clayfield College Alumni Data Set
first name
last name
maiden name
date of birth
occupation
gender
house
enrollment year
alumni year
alumni id number
Data from Joining Alumni
first name
last name
maiden name
enrollment year
date of birth
alumni year
occupation
gender
house
alumni id number
Login Credentials Data
Email
Username
Password
Data for Past Principals
year started
principal first name
no. of principal
princpal last name
principal title
Functionality
PROCESS: search function
INPUT: search criteria
OUTPUT: records that meet the criteria
PROCESS: Submit button on alumni form
INPUT: clicks button
OUTPUT: information is uploaded to database
PROCESS: search function using buttons
INPUT: click button
OUTPUT: records meeting the criteria specified
PROCESS: alumni completes form
INPUT: personal details/ answers to questions in the form
OUTPUT: thank you/ confirmation of completion page
PROCESS: Admin adds a record
INPUT: details of new record
OUTPUT: new record is recorded in the existing alumni database
PROCESS: Admin deletes a record
INPUT: admin selects record to delete with button
OUTPUT: warning message and confirmation button
INPUT: admin clicks ok or cancel
OUTPUT: if ok, record is deleted. if cancel process is discontinued.
PROCESS: Admin edits an existing record
PROCESS:
Coding Tools
Using Pycharm Software to build webapp
Using SQLite to build database
Using Adobe XD to build mockups
Using Python - Flask and WTForms imports
User (refer to User mindmap)