Dibatalkan

Teacher/Student database needed from ground up for school

Overview

Company connects private students with teachers. All student payments are administered through Company. Students pay for a certain amount of lesson credit in advance. After the teacher teaches a lesson, they log this online. The idea of the program below is that they will log a lesson and it will automatically subtract from the students current lesson credit. Various emails will be automatically sent out as well as a paypal invoice when the student's lesson credit is 0. There are 3 pages as follows….

Teacher Login Page –

Teacher logs in with a secure password. The page displays name and contact of each student they have, how many lessons they have left with the student, and lessons history by date.

On this page there is also a form where they log that they have taught a lesson or the student canceled a lesson, or student canceled without 24 hours notice. (as well as a few other options) If it is option 1 or 3, after they have submitted the form this will automatically deduct a lesson credit next the appropriate student as well as add the submitted date into the lesson history.

An email will then go out to the student notifying them the date of the lesson they took and how many credits they have left. If this is their last lesson, an email will go out to the student with a paypal link to pay for lesson. Also, an email will go out to admin notifying that

Student Login Page –

Student logs in with a secure password. Displays student name, teacher name, how many lessons they have left, lesson history by date and payment history.

Admin Login Page-

Place to add/edit teachers, students. Add invoices/lesson credits, view teacher logs sorted by date and/or teacher.

More Detailed Overview
------------------------------

Overview
Company connects private students with teachers. This software will automate virtually all aspect of business including student registration, teacher registration, connecting students with teacher, updating account balance, billing etc. Students fill out a form on our website which automatically creates an account where their information is stored and the student is emailed a password and username with which they are able to login to the student page. The student account goes through various statuses, until finally the student is billed automatically. Students pay for a certain amount of lesson credit in advance. After the teacher teaches a lesson, they log this online through the teacher login page. When they log a lesson it will automatically subtract from the students current lesson credit. When the student's lesson credit is 0, the student is billed again.
An important feature of this software is that there are 2 modes to it which can be designated by the admin. The first mode is that when a student registers, all of the teachers for that appropriate instrument receive an email that there is an available student. The first teacher to claim student, it become their student. The other mode is when this automatic match it turned off, the admin will match a particular student with a specific teacher.
The developer must also have the ability to design the forms and pages in such a way that is easily viewable by the users.

Table of Contents
1- Status flow Chart and descriptions
2- Student registration Form
3- Student Login page
4- Teacher Registration Form
5- Teacher Login page
6- Lesson Log Form
7- Admin Registration Form
8- Admin Page and Functions
9- Billing
10- Automatic Match Function
Status Flow Chart/Descriptions
When a student registers, they have a choice to either select to have a 60 minute lesson right away, which they have to pay for before they meet the teacher or to have a 30 minute introductory lesson which they meet the teacher and only pay if they want to continue. They can also choose to be contacted by an admin first. For each of these choices, there is a slightly different process. Please see exhibit 1a for a visual flowchart of the process and 1b for a description of each status and what actions occur as a result.

Student Registration form
Once this form is filled out, the students information is saved in the database and account is created. Login info and Password is automatically created by system. Student only receives this information when their status has become “lesson scheduled”. See exhibit 2A for a description of student form

Student Login Page
After student received their login info. They will be able to go to our business homepage an login using the password and username that was generated for them. On this page they will be able to:
1- See teachers Contact Information
2- See companies contact and send a question/note where their status then become “student question”
3- See Lesson History/Current Balance
4- See billing history with invoice dates and amounts
5- Update Contact info –(email will always be required)


Teacher Registration Form
The teachers will be sent a link to a registration page where they will fill out all appropriate info. All this information will be stored.

Teacher Login Page
On this page the teacher will be able to see all of their current students and current lesson credits for each student as well as student history by month. On this page there will also be a form where they log lessons that they have taught. There will also be a section where they can update their contact info and see if there are any students currently available for them and elect to accept the student or not accept. There will also be a place where teachers are able to contact the company as well as a place where the teacher can read notes from the company.

Lesson Log Form
Within the teacher login page, there is a log form where teacher log lessons. Here is a list of the form options and their function:
1)60 Min Lesson Taught – credit gets deducted by one, student gets emailed saying they have taken a lesson with the date, their current balance and if they have no credit left, they are sent a invoice. Both the teacher login page and the student login page is updated. Only one lesson can be taught, per student, per day.
2)Trial Lesson Taught –Status gets updated in admin page, Invoice goes out to student.
3)30 Min Lesson Taught - student gets emailed saying they have taken a lesson with the date, their current balance and they are sent a invoice. Both the teacher login page and the student login page is updated. Only one lesson can be taught, per student, per day.
4)Missed lesson (24 hours notice not given) credit gets deducted by one, student gets emailed saying they have missed a lesson with the date, their current balance and if they have no credit left, they are sent a invoice. Both the teacher login page and the student login page is updated. Only one lesson can be taught, per student, per day.
5)Hour lesson scheduled (no introductory lesson) – Student is emailed with login information and invoice and that they have scheduled a lesson and must pay beforehand.
6)30 Min Trial lesson scheduled – Status is updated
7)Missed Lesson-24 hours notice given-gets logged in all appropriate places.

Admin Registration Form
This is where admin registers username and password as well as specify what kind of emails they elect to receive. The options are…


Admin Page and Functions
The admin page will have the following:
1) Ability to view and edit all student information and statuses
2) Ability To view/edit all teachers information and students
3) Ability to view companies profit by month
4) Ability to print/view out all of teachers lessons by month for payroll
5) Ability to process all billing (see below)
6) Ability to assign students to teachers both automatically and manually depending on mode (see automated billing below).


Billing
There are 2 ways that student will be billed; Automated and Manually. Automated is the default method. However, if a student needs a price change the admin can send out an invoice with the click of a button. There is a default price for all students. However, the admin has the ability to set different prices for students. In the admin page, under each student, the admin is able to select a different payment amount. The admin will input the payment total and how much each credit is worth. All of these different amounts will just be saved paypal links. If there is a better option other than paypal, we are open to this idea.
Bills are automatically sent out:
1) When the student credit reaches 0
2) After the 30 minute introductory lesson taught is logged by the teacher
3) After the first 60 minute lesson scheduled log is sent out by the teacher.

If students do not pay 24 hours before next lesson (or 5 days after last lesson date). They are automatically sent a reminder. The teacher is also sent a note.

Automated Matching
In the admin panel, there are two functions for how students are matched with teachers; Automatic and Manual. With automatic, the process is almost the same except that when a student registers for lessons, all of the teachers of a certain type are automatically emailed that they a possible student. The first teacher to accept becomes the teacher and the process jumps to “match confirmed” (see flow chart). With the manual way to match, the registered student goes into a cue where the admin will assign them to only one teacher.

Kemahiran: PHP

Lihat lebih lanjut: teacher student database, student teacher example database, student database sample, teacher teachers, teacher teacher, teachers pay teachers, private lessons online, private lesson online, php lessons online, online c++ lessons, logs for company, teacher student data base, php database teacher, php mysql teacher student add course, teacher student database design, php mysql teacher student, student database erd, sample student database, teacher student databases, student database example, teachers students database, student account database program, erd students database, invoice school database, teacher student account balance software

Tentang Majikan:
( 0 ulasan ) Brooklyn, United States

ID Projek: #365775

59 pekerja bebas membida secara purata $1099 untuk pekerjaan ini

sanjay2004

Placeholder bid:We have gone through the additional specs and ready to start.

$1500 USD dalam 0 hari
(490 Ulasan)
9.4
lightcresent

Expertise in doing this sort of work... Thanks

$950 USD dalam 15 hari
(481 Ulasan)
9.0
webexpertz

Dear Sir, I am interested in your project and can be done with your 100% satisfaction. I request you to check your PM for our quality work. 35 Days development + 10 Days for testing + Bug Fixing. Progress Lagi

$1500 USD dalam 45 hari
(115 Ulasan)
8.5
varun8211

refer pmb for details

$1500 USD dalam 50 hari
(20 Ulasan)
8.0
VALUEONWEB

We have developed same type of project. We are very interested to develop this project for you.

$1200 USD dalam 20 hari
(211 Ulasan)
7.9
Indexpage

Hello Sir, Kindly check your PMB for more details Thanks

$1500 USD dalam 40 hari
(54 Ulasan)
7.9
A2Design

We can develop this system. Take a look on our portfolio at [url removed, login to view]

$1500 USD dalam 45 hari
(40 Ulasan)
7.8
rockerstech

Please check reference work!

$999.99 USD dalam 20 hari
(78 Ulasan)
7.6
becomeexpert

Please have a look at our profile ( to know why We're best for your project ) and reviews ( to know what our performance is ). I think it'll help you a lot to choose the winning bidder. Thanks, Tonmay

$1500 USD dalam 45 hari
(130 Ulasan)
7.6
CrossBiz

Please view PMB

$1500 USD dalam 30 hari
(60 Ulasan)
7.4
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Lagi

$750 USD dalam 45 hari
(55 Ulasan)
7.3
ranganathp

Can help... check my reviews... costs more...

$1500 USD dalam 21 hari
(39 Ulasan)
6.6
radhikafofalia

Please see PMB for details. Thanks

$1450 USD dalam 30 hari
(19 Ulasan)
6.7
freeworks

Please check my PM

$1000 USD dalam 20 hari
(83 Ulasan)
6.4
websoftinfo

Hi, we are very [url removed, login to view] have gone through with the requirements you described in your detail. We can easily do it with our expertise. we will provide your project with required language. we will provide you regul Lagi

$1250 USD dalam 30 hari
(66 Ulasan)
6.4
contentguru

Please see PMB for details of our bid. Thank you.

$750 USD dalam 30 hari
(28 Ulasan)
6.3
sajjj

hi sdcstudio, please check PM for bid details. thanks sajjj

$1200 USD dalam 30 hari
(26 Ulasan)
6.1
Webcruise

We have successfully completed over 1000 websites in the past with not even a single dissatisfied client. We can help you in making your web business better. We look forward to work we are looking for a long term relat Lagi

$1000 USD dalam 30 hari
(1 Ulasan)
6.0
h114

Hi Please have a look at your PMB. - Regards! Neelima

$1000 USD dalam 25 hari
(22 Ulasan)
6.0
majormf

i am ready

$750 USD dalam 30 hari
(42 Ulasan)
5.6