student database presentation 1.14.10
TRANSCRIPT
![Page 1: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/1.jpg)
1月 2010年
![Page 2: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/2.jpg)
Executive Summary
Project Goal:
Develop a student database in order to facilitate: Improved student care
-Database allows teachers and managers to better know their students Quick and easy access to key student information for teachers and managers Smooth transitions for new teachers
-Imperative due to the high teacher turnover inherent in the industry -New teachers can more quickly get to know their students -Prior teacher’s notes and knowledge are institutionalized
Program features: Dynamic internationalization (User can switch between English and Japanese) Password protected areas to control the dissemination of confidential information Advanced search for all tables All reports have the option to:
-View Report -Export to Excel -Export to .PDF
*All student and financial data (names, figures, etc.) used in this presentation are hypothetical and shown for example purposes only
1
![Page 3: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/3.jpg)
Database Architecture
Architecture Overview:
A unique instance of the program will reside on each school’s local system to comply with the laws regarding the protection and confidentiality of student information
No student information will leave the school server
School A School B Student data is contained
within the school’s system
2
![Page 4: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/4.jpg)
Opening the Program – Main Window
This is the Main Window of the application. From here, the user can either access the Database to enter or edit information, or the user can access various Reports.
The program features dynamic internationalization; the user can switch between English and Japanese at any time from the Main Window.
3
![Page 5: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/5.jpg)
Student Editor
The Student Editor is where the user can input, update and manage all of the student data
There are 6 separate editors associated with a student (2 shown here): Class Enrollment Editor Counseling Editor Level Editor (not shown) Purpose Editor (not shown) Self-Study Editor (not shown) TOEIC Test Editor (not shown)
The other 4 editors can be accessed using the scroll bar
4
![Page 6: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/6.jpg)
Student Editor
The Class Enrollment Editor is where the user manages the student’s classes; which class(es) they signed up for as well as the contract length and starting date
The Level Editor allows the user to quickly input the student’s level across 11 different categories (Listening, Grammar, etc.) based on the AEON Step Scale (1 = KickOff to 11 = Talking Point +)
The Counseling Editor allows the user to track the student’s progress with notes as well as the type of counseling (i.e. Initial, Educational, Final)
5
![Page 7: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/7.jpg)
Student Editor
The Purpose Editor is where the user inputs information regarding the student’s purpose for studying English
The TOEIC Test Editor allows the user to input the student’s TOEIC test results
The Self-Study Editor manages any Self-Study programs that the student participates in
6
![Page 8: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/8.jpg)
Teacher Editor
The Teacher Editor is where the user can input, update and manage all of the teacher and manager data
The Teacher Editor is accessed from the Main Window
7
![Page 9: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/9.jpg)
Class Editor
The Class Editor is where the user can input, update and manage all data regarding classes
The Class Editor is accessed from the Main Window
8
![Page 10: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/10.jpg)
Self-Study Editor
The Self-Study Editor is where the user can input, update and manage all data regarding Self-Study courses
The Self-Study Editor is accessed from the Main Window
9
![Page 11: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/11.jpg)
Prospective Editor
The Prospective Editor is where the user can input, update and manage all data regarding prospective students
The Prospective Editor is accessed from the Main Window
10
![Page 12: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/12.jpg)
Financial Editor
The Financial Editor is password protected
The Financial Editor is accessed from the Main Window
11
The Financial Editor is where the user can input, update and manage all data regarding the school’s finances
![Page 13: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/13.jpg)
Reports
The Reports section is accessed from the Main Window and contains 3 submenus
12
![Page 14: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/14.jpg)
Report – Current Students
The Current Students Report details the name, nickname, date of birth and gender of all the current students at your school
13
All reports have the option to: 1) View Report 2) Export to Excel 3) Export to .PDF
![Page 15: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/15.jpg)
Report – Single Student
The Single Students Report details the complete history of a student including: -Class Enrollment -Counseling -Level Check -Purpose -TOEIC Test Scores -Self-Study
14
![Page 16: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/16.jpg)
Report – All Students
The All Students Report details the name, nickname, date of birth and gender of all the current and past students at your school
15
![Page 17: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/17.jpg)
Report – Self-Study
The Self-Study Report details all of the Self-Study programs a student has taken
16
The Self-Study Report will be extremely useful for teachers and managers as they prepare for the launch of a new Self-Study program and decide which Self-Study materials to recommend to their different students
![Page 18: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/18.jpg)
Report – Monthly Financial Report
Select the month you would like to view
17
The Monthly Financial Report is password protected
The Monthly Financial Report gives a breakdown of the monthly revenues and expenses of your school
![Page 19: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/19.jpg)
Report – Summary Financial Report
18
The Summary Financial Report is password protected
The Summary Financial Report gives a breakdown of the annual revenues and expenses of your school as well as your school’s performance in regards to spirits both on a monthly basis as well as a cumulative basis.
![Page 20: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/20.jpg)
Report – Current Teachers
The Current Teachers Report details the name, nickname, date of birth and gender of all the current teachers at your school
19
![Page 21: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/21.jpg)
Report – All Teachers
The All Teachers Report details the name, nickname, date of birth and gender of all the current and past teachers at your school
20
![Page 22: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/22.jpg)
Report – Prospective
The Prospective Report details the name of the prospective, the date of visit, whether the prospective signed up or not, as well as any notes that the manager or teacher took
21
![Page 23: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/23.jpg)
Report – Prospective (Date)
The Prospective (Date) Report is in the same format as the Prospective Report; however, it allows the user to choose a starting date for the data in the report (i.e. all prospectives that visited after December 1st, 2009)
22
![Page 24: Student Database Presentation 1.14.10](https://reader033.vdocuments.us/reader033/viewer/2022052900/555db8b1d8b42a68328b54f5/html5/thumbnails/24.jpg)
Report – School Overview
The School Overview Report contains summary statistics about the school’s students
23