Create an on-line Sign-Up form for college labs with calendar

Completed Posted Aug 13, 2006 Paid on delivery
Completed Paid on delivery

Create an on-line system to allow college students to sign-up for required labs and work calls for a performing arts dept. This is a program of “work calls?? for students to come help build the sets, hang the lights, etc. for theater productions the dept. puts on. Each student in required to put in a certain number of “lab?? or shop hours per semester. Keeping track of the student’s hours has become overwhelming. I am looking for a calendar based form system that the students can use to sign up for crew work calls. Searching the net, I’ve found several “event?? organization sites and one school that come close to what I need. My current site is being run via Joomla and has MySQL and PHP running. Examples of sites that come close: [url removed, login to view] This site charges per person who signs up by taking a percentage of the fee charged. The problem is that my needs do NOT include taking any fee. [url removed, login to view] This one comes very close. They even offer one free “event.?? The problem is that my whole semester is a single “event?? with dozens of meeting times. Many of the “meetings?? involve only a few students. [url removed, login to view] This one is the best. I love the fact that you can click on the link that shows you the “next?? available date. This would be great for students who are looking for a date to fulfill their crew hours. The issue here is cost and the fact that they also deal with taking fees based on people’s use of a credit card. Details of what I would really like to accomplish are included in the attached doc. Thanks, Scott

## Deliverables

Besides the usual boilerplate, here are my thoughts on this project. A technical theater program consists of classroom sessions with a combination of lecture and hands-on demonstrations, "lab" sessions that are held in the scene shop for hands-on experience and building time, additional crew calls as needed for given productions. Each student is required to attend all lecture periods as scheduled within their normal academic program. Students also sign up for a weekly lab time consisting of two hours each. The additional crew call/building times are to fill the students additional crew hour requirement. The crew requirements consist of: Serving as a running crewmember. On one large production which averages 65 hours. Serving as a running crewmember on two smaller productions, which average approximately 40 hours each. If students are involved in totally unavoidable conflicts that preclude them from working on a show, alternative crew service can be arranged. This would consist of approximately 65 hours of crew work during a semester. Upperclassmen are exempt from the running crew requirement. They are required to fulfill a total of 12 hours of crew work time. These 12 hours can be accomplished by attending posted crew calls, which usually run between four and six hours each. These crew calls consist of: construction work calls, paint calls, strike calls, working in the costume shop, working as ushers and during performances, working on the House crew for performances, and other miscellaneous work calls. The major challenge to the entire process is keeping track of what students have completed various hours. What students are required to perform how many hours. Which students have completed their hours. How many hours does each student still need to complete for the semester? In this desired system to allow students to sign up online to complete their crew requirements, I'm looking for the following. A calendar system that lists our productions, and their respective crew calls associated with them. Each production has a set list of running crew positions that need to be filled. Some productions, many have either more or less positions of responsibility, depending on the show. This calendar would show each performance and have the appropriate slots available in a clickable format so that students may sign up for the open slots. Some of these positions are for the entire run of the show. Clicking one of these slots would come up with a warning that the student is signing up for the entire run; the form would then fill in the students named on each day/slot that is linked to that particular position. However, this warning window would allow a student to back out and choose a different assignment. Some positions would need the approval of the faculty supervisors, while other positions can be marked to simply accept the student at that point. For students who are only required to fill the 12 hours of crew time for a semester, the calendar would need to have individual crew calls listed. An example of how a student may accomplish the completion of the 12 hour crew requirement could be: serving on two four hour work calls and a four hour strike call; serving on one eight hour crew call and a four hour strike call; assisting the shop supervisor in supervising a two-hour lab six times during a semester; working as an usher for a show, which requires approximately 3 hours of time per evening; other options are available as well. The ability to list a crew call and give the details of what kind of work will be done. The ability to list needed positions for said crew call. For example, a building call would necessitate having a stage craft type supervisor, and a collection of workers. Some building calls may require rigging capabilities. A paint call would need a paint supervisor who has some experience with painting, and the rest of the crew would need to be willing participants. The calendar should have the ability to interact with other calendar formats. For example, Google's online calendar, or some other software that can be accessed/synchronize. So that we do not have to enter this semester's information repeatedly. Different crew call listings should be capable of e-mailing different people when someone signs up. For example, each production has its own stage manager and other student supervisory personnel, while the department technical director is in charge of all the productions. Additionally, each crew call will likely have its own supervisor, to which updated crew call attendance sheets should be e-mailed. Database details: desired reports include information for the following reasons (in no particular order at the moment). Continually updated reports on the crew hour requirement standing of each student in the department. Certain positions on a productions running crew require the inclusion in of the student's name in the production playbill. Therefore, the names of students who sign up for these positions should be e-mailed to the person responsible for creating the playbills. The ability for supervisors to enter anecdotal information on student performance during crew calls. The ability to ask the database, how many hours we have left of possible crew involvement for the remainder of a semester. This would necessitate entering the number of students and the number of hours each one is required to fulfill. The ability for the database to send out e-mails to the students reminding them of their responsibility and giving them an update accounting of what they've done. Once the crew call supervisor has entered attendance, the program should e-mail people who did not show up with a cautionary note and e-mail the people who did show up with a note of thanks. These systems should allow varying levels of access permissions. Certain students would be granted accessed in relationship to the responsibility position that they hold. Error checking. If a student's name is entered too many times or in attendance sheet has not been entered, etc. then a notice should be sent to the appropriate supervisors for further action. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Server is on Godaddy.com... PHP, MySQL. I use WinXP on my machine. Having good import/export of the signup info is a must.

Database Administration Engineering MySQL PHP Project Management Software Architecture Software Testing SQL Web Hosting Website Management Website Testing

Project ID: #3721965

About the project

3 proposals Remote project Active Aug 19, 2006

Awarded to:

asbtechsolutions

See private message.

$236.51 USD in 25 days
(15 Reviews)
4.0

3 freelancers are bidding on average $2303 for this job

colorragevw

See private message.

$2975 USD in 25 days
(201 Reviews)
7.0
FORTUNEINFOCOMM

See private message.

$3697.5 USD in 25 days
(9 Reviews)
6.5