I need to track the training that we provide.
We assign numbers to the training courses we provide.
The training courses are held often.
We need to set up locations where courses are held. We need to attach these to courses.
We need to maintain a list of instructors and their credentials.
We need to attach the instructor to the course. They can be set as Primary or Adjunct.
Every course requires a primary instructor.
We collect information from the student that must be kept in the database. We must be able to search for the student when attaching them to the course.
We need to be able to pull reports on what courses the student completed.
We need to print off a .pdf certificate for each course they took.
Each certificate will have a unique ID number attached to it.
We need to email a copy of the .pdf certificate to the student when they are marked course completed.
Students will need to have a portal where they can input their email and another field and be able to access their training history.
There needs to be a page to validate certificates. The user will see a page to input the certificate ID and the website will give validation information to the user.
Ideally, there should be a QR code on the certificate that when scanned will look up and show a validation page.
We need to keep track of when we have courses by date, times, location and instructor.
We need to be able to look up a course number to see the history of when the course was held.
We need to search for courses by date range.
Courses need to be categorized as PENDING, COMPLETED or CANCELLED
We need to be able to upload scanned rosters to the course.
We need to be able to upload other documents to the course.
We need to see a list of completed courses.
We need to see a list of pending courses with the ability to edit.
Each course needs to create a survey code. Students will enter the survey code into an "ENTER SURVEY CODE" page. The results of the survey are stored with the course.
Each course may have an exam that students have to take to complete the course. We need to input the multiple choice exam into the course. During the course, the instructor can create a unique exam code that students will input into a "take exam" page. The results of the exam will be attached to the student's course profile.
We need to create an xml export. See the attached files.
We are using an Apache server that supports .php.
Here is an example.
We have a course 334-445.
We hold that course on 7 different dates during the year.
We hold the course in 3 different locations.
Each time the course is held there is a different instructor.
Each time we hold the course, students sign their name to a roster that we need to upload.
32 freelancers estão ofertando em média $1217 para esse trabalho
I have 7 years experience with Filemaker. Here is one of my work sample, [login to view URL] I will go with hourly rate for this kind of project. My hourly rate is 25 USD per hour.