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:
PHP, Website Design, C/C++, Javascript
Description:



HostRocket.Com - 1000MB - $4.99

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
the first floor and another one in the basement, both will be connected in a
network.
We'll need the SMS feature. We have contact with a spanish provider which offers
all SMS tools integration for free, both in http and XML modes. They even can
create custom app if needed for free, and offer free support, they just charge
per SMS sent. They also have desktop tools to manage SMS. So SMS feature is very
important

Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.

Related Projects:
Basic Search/move In Php/mysql
Surf Anonymously Script
Custom C++ Plugin needed for "Angry IP Scanner" Program
Change Order programme
Myspace Friendslist

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
Linux
Database System:
MySQL
<<< back

Recent Projects Archive:

Tuesday - Monday - Sunday - Saturday - Friday - Thursday - Wednesday

View all freelance web projects

 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2008 ProjectsList.biz /1.287