Hello, I'm in the process of doing that now with some google apps and google scripts. I've written a script that allows an automatic email and calendar invite to be sent to a faculty member who requests a class via a google form. I'm just trying to get it to sync with outlook and figure out how to have it select a librarian based on each librarians availability. Thanks, Cornel Darden Jr. MSLIS Sent from my iPhone > On Feb 3, 2014, at 2:46 PM, Kaile Zhu <[log in to unmask]> wrote: > > I am given a project whose requirements are shown below. Before I get started, I would like to check with the list. I am sure there exist quite a lot similar things, but I am looking for something easy to customize. I would prefer simple ones instead of powerful ones, so I can add or modify the functionalities to meet my own needs. Code can be written in PHP or .NET. > > Thanks. > > Kelly Zhu > 405-974-5957 > > Library instructional class scheduler > 1. Class Requester (Faculty) > Allow faculty to submit class requests on a certain date and time. Provide a list of classes scheduled or a calendar that would show the classes already scheduled during the request process. Allow faculty to upload the document needed for the class. Allow faculty to update his/her own class. After submission is completed, an email notification would send out to all involved parties (requestor (faculty), scheduler (librarian). > Allow faculty to view a list of the classes they have requested. > 2. Class Scheduler (designated librarian) > The scheduler receives email notification once the class request is completed and can edit any inaccuracies. The scheduler can assign classes to instructors (librarians) on a certain date and time, and assignment information will send to the class requester and the instructor. > The scheduler can add classes manually, and delete old or unwanted classes. > 3. Class Instructors (Librarians) > All librarians can view the list of assigned classes with assignment or any files sent from requester. > All librarians can add/upload their comments, lesson plans, or suggestions to future classes, after completion of their class if desired. > All librarians can view past comments/lesson plans/suggestions, in a manner that you can sort, search, or limit to view only the comments relevant to a particular class. > 4. Statistics and recordkeeping (Librarians) > Generate statistical reports (monthly, annually, or by semester). The reports include: total classes, total students, number of classes and students by department, number of classes taught by each librarian, etc . > > **Bronze+Blue=Green** The University of Central Oklahoma is Bronze, Blue, and Green! Please print this e-mail only if absolutely necessary! > > **CONFIDENTIALITY** This e-mail (including any attachments) may contain confidential, proprietary and privileged information. Any unauthorized disclosure or use of this information is prohibited.