Diagrama de flujo
DT House App Flow Chart FINAL
Contenido del diagrama
Data fixing/filtering queries run
User is at beginning form with button options
Data base is launched
User presses "Age" button
autoexe Macro is launched
Boarder capital fixing
Female Naming to "F"
Male Naming to "M"
User is promted to enter minimum age
User is shown "Age" query showing students from the minimum to maximum age from chosen house via embedded macro
User presses "Gender" button
User is shown "Gender" query showing students of selected gender from selected house via embedded macro
User presses "Duplicated Surnames" button
User is shown "Surname" query showing list of students with duplicate surnames (this means they have family members) from all houses via embedded macro
User presses "Individual Student Finder" button
User is shown "Student Finder" form via embedded macro
User presses "Reset Data" button
Macro runs deletion query
User gives location of excel file with information
Data is deleted. Macro now promts user to give location of the new, or old excel file with data for importation
Macro inserts data into the main information table's fields
User presses "Input Students to Events" button
User is shown "Student Input Students to Events" form via embedded macro
User inputs student, then events alongside points; saved automatically to a table. Simple combo box filter from student full name (first name and surname) will find student
User presses "Gender distribution" button
User is promted to enter an gender
User is shown "Gender distribution" query showing the total of the selected gender in all houses via an embedded macro
User presses "Count of age groups" button
User is promted to enter an age
User is shown "Count of Age group" query showing the total amount of students from the selected age in all houses via an embedded macro
User inputs full name (first name and surname) into a simple combo box filter. Text boxes will now show the students information
Deletes student event input information via embedded macro
Deletes raw student information table
Age calculation
User presses "Input Events to Students" button
User is shown "Student Input Events to Students" form via embedded macro
Users inputs event, then adds student ID, alongside points to said events. Saved automatically to a table
User is promted to enter maximum age
User is promted to enter a house code
User is promted to enter a house code
User is promted to enter male or female
User presses "Find Specific Surname" button
User is promted to enter a surname
User is shown "Surname" query showing students with given surname via embedded macro
User is shown "Boarder Status" query showing boarder status (e.g boarders or scrags) from chosen house via embedded macro
User presses "Boarder Status" button
User is promted to enter borader or scrags
User presses "Year Levels" button
User is shown "Year Levels" query showing students from the minimum to maximum year level from chosen house via embedded macro
User is promted to enter a house code
User is promted to enter a minimum year level
User is promted to enter a maximum year
User is promted to enter a house code
User presses "Count of year levels" button
User is promted to enter an year level
User is shown "Count of Year Level" query showing the total amount of students in the selected year level in all houses via an embedded macro
User presses "Individual points earned by students
User is shown "Individual points earned by students" query showing the points students have earned from given house via embedded macro (sorted from highest points earned to lowest)
User presses "House Points Summary"
User is shown "House Points Summary" report showing for each house the total amount of events participated in, points earned, and average points awarded to each students. Also counts all pointed earned by all houses and events particpated in. Opened via an embedded macro.
User presses "Total points earned by year level" button
User is promted to enter an year level
User is shown "Total points earned by year level" query showing points earned from selected year level in all houses via an embedded macro
User presses "Delete Student Entries" button
User is promted to enter a house code
Información
- Descripción
- my god. you cant even save this, why? do you enjoy my suffering?
- Creado por
- Simon Bazalicki
- Visitas
- 1
- Historial
-
- Creado por Simon Bazalicki · 26 jul 2019
- Copiado por Simon Bazalicki · 29 ago 2019
- Copiado por Simon Bazalicki · 29 ago 2019
- Copiado por Simon Bazalicki · 18 sep 2019
- Copiado por Simon Bazalicki · 22 sep 2019
- Valoración