![]() ![]() |
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Classroom Control & Web Site |
![]() |
Bidding Time: |
14/12/2005 20:03 - 29/12/2005 20:03 |
Budget: |
N/A |
Status: |
Closed |
|
|
|
Job Type: |
|
Description: |
We would like to create an online application and corporate web site (online and offline) that will allow us to control a dance/music academy, and show our students and what we're offering. This application should be written in Spanish and English, but since we'll be probably created by a non-spanish freelancer, we should have an easy way to translate all options into Spanish. The backend should be in Spanish, translation to Spanish will be on our side. We need to have full control of student's access to our academy, courses they are subscribed to, teachers teaching them, who's paying and who is not, etc. I'll describe what we need just below: STUDENTS MANAGEMENT. We need to create a database of students, their personal names and surnames, address, city, telephone, email, upload photo, courses they are subscribed to, their teachers, attendance to classes, qualifications made by teacher, notes, etc. COURSES. We need to have options to add current courses (we have theater, music, instruments, dancing, etc), so we need to create categories and subcategories), associate courses to students, delete/update info, description and duration of the course, assign teacher or teachers to the course, daily/weekly/monthly attendance by students and teachers. We should be able to visually create a quadrant with all courses, class where the course is being taken, students in this course, and the teacher or teachers in this course. RECEIPTS. The application should calculate how much each student needs to pay per month/class, there will be fix monthly prices or on a per hour attendance. We should be able to print these receipts (with a bar code, and read the bar code), make the receipts double, and give one piece to the student as proof of payment. We must know who paid and who didn't, have reports of these payments/users, print these reports, and search students receipts. We should have a list to select payment method, cash, wire transfer, etc. EMPLOYEES MANAGEMENT. We need a database similar to students, but for teachers, we also need to know which teachers are assigned to each course and what students has each teacher and viceversa, how many hours and days does the teacher teachs, if he didn't come, assign a fix, % or monthly amount of money to each hour of class, calculate how much money we need to pay each teacher (print these reports and payrolls). We need to have a database of alternative teachers we can call to substitute one who is not coming a specific day, so if a piano teacher is not coming we should be able to select other available ones or that ever gave as a curriculum. We should have an option to gather and store all curriculums delivered by teachers applying for a job, next to a profile of that teacher. We need to have a quadrant of each teacher, what classes they have each day, week and month and what classroom he'll be in in each class. CLASSROOM CONTROL. We need to have a quadrant with all classrooms that we have. We have 2 storeys, with some classrooms on the ground floor and others on the basement, so we need a nice layout to know which classes are busy and which are free, what days and what hours, etc. We will need a more visual means to show the classroom's availability, maybe having a map, with different colors depending on availability, and also when we click on the classroom, we'll get a timetable of busy/free hours per day/week/month, teachers and courses assigned to it. We should be able to reserve specific hours or ranges of hours (and days) in any classroom, specifying who did the reserve, for what reason and a small description. SEARCH. We need to make all kind of searches, courses, students, teachers, students by name, surname, city, age, gender, etc, with Boolean operators. We should be able to search for students who did pay, those who didn't, those who didn't come last week/month/last months, teachers phone numbers, etc. REPORTS. We need all kind of reports: students by class, by hour, those who didn't pay, those who paid this month, those who didn't come this month or the last ones, students by ages, name, gender, city, those who are subscribed to 1-2-3+ courses, attendance of students per day/week/month, and calculation of monthly payment (with the possibility of sending an SMS to student's mobile) NEWSLETTER/NOTIFICATIONS. We should be able to send students or their parents and email with notifications and a SMS with the amount of money they need to pay a specific month. We need to send periodic newsletters with info on new courses or news, so we need to create an email list with personal names and have the application mange this list and send newsletters every week/month. STUDENTS/TEACHERS ACCESS CONTROL. We need to create students/teachers cards so that we track who came and who didn't. So, we need a bar code reader to be able to read the bar code on the user's card every time they come to class, and when we want them to pay. So, when we read the bar code, we locate user and select what we'd like to do with it (came to his class today, he wants to pay, etc). What bar code reader hardware should we go for? Or, is there any other idea that we can use? We need to create this application so that it works online and offline. If we lose our internet connection we should be able to work offline and then one there is connection or we click on synchronize, data should be transferred and synched. So, what do you propose? What technology would you use? I would love PHP+MySQL, but how can we have an offline edition like that? Is that possible? Or should we create a desktop application together with the online edition? What is your recommendation? WEB SITE. We're planning to build a web site around this application, which will connect some of the features in it with a few pages. We would need to create a web site with info about all courses in the academy, timetables, description of place, where we are, there will be a few sections in the site explaining what we do (in 2 languages: english and spanish). This site will have quite a few pages but based on similar templates that you create, and they should be easily managed and updated from a CMS admin area. We should be able to add new pages easily to different menu sections on the site. We'll have a selection of dancing courses, playing instruments courses, theater, makeup, etc. We'll add photos, descriptions, have timetables of each classroom and each course, etc. We need to be able to add new courses to specific categories, in 2 languages and have the site updated real time. So, we need to categorize all these pages and make a nice dynamic menu nagivation. CSS is very important for this site. So, what do you propose? What technology would you use? I would love PHP+MySQL, but how can we have an offline edition like that? Is that possible? Or should we create a desktop application together with the online edition? What is your recommendation? Please, send me a PMB with your comments and references, and a brief of what you'd do, and how you'd implement it. Please, only qualified and serious bidders with experience. Additional Info (Added 12/15/2005 at 3:11 EST)... We'll have 2 points of scan for bar codes on the school, one on This project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
Linux |
Database System: |
MySQL |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2008 ProjectsList.biz /1.287 |