eSchool Creator

hello i'd like to create an online school generator. the site would be used to create online school websites for organizations and providing them the capacity to handle online registration for their classes, keeping their admin, teacher, and student records, their course records, creating their online courses, and teaching their online courses in an an online classroom. the site must also support the capacity for multiple languages, so that when an online school is being generated/created, it can be assigned a default language. please review these websites, they will give you a good idea of the type of website i am trying to create: [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], and [login to view URL] to summarize, i want to create a website that will allow me to create online schools for organizations - so i will need a back end for my administration for creation of the online school sites as well as back end for the admins of the online school sites i create. of course there will need to be a front end for the generator site as well as front ends for any online school website that is created. there will also need to be a robust permissions system developed to make sure items/pages are presented to users based on their roles. i want the site to be user friendly and have a web 2.0 feel to it - very interactive and friendly easy to use and look good too, i will give some guidance as far as layout and design and navigation, but it will be up to you to actually take those suggestions and develop the site's templates. I do not want to use joomla or wordpress - i would consider platforms such as ruby on rails. this is the initial start of a larger plan, if all goes well with the development, there will be 3 more phases of development over the next 6-9 months. ## Deliverables here is an example of a possible specification for the course management function... the idea is that an online school would be created for an organization, and then that organization would create a list of instructors, classroom locations, categories, classes, and courses. the system would generate a course catalog webpage for that organiztion, sorted by categories with courses listed under each category, where students could register for a class. admins could monitor registrations to see which courses were filling up and could download (excel?) files with course enrollments and/or other data. ------------- table info ------------- tbl preferences (this might eventually belong in the website management module, but i was thinking of it here for now? also see note below about combining tables) - admin userid - password - salutation - fname - lname - phone - paypal id - skype id - picture i suppose we could have one generic table for all users? admin, staff, instructors, students, and other roles since in the long run these tables will have similar information and include some type of role identification field. there is potential complication when a person may have more than one role, and then when they are moving through the system we'll need some way for them to identify which role they are assuming so the system will know how to present the items/pages to the user based on their role/permisisons. tbl instructors - userid - password - email - salutation - fname - lname - phone - skype id - paypal id - biography - picture tbl locations - location name - location phone - location address1 - location address2 - location city - location state - location zip - location description - location map (url) tbl topics - name - description - parent (choose from other topics - this gives us sub topics for the purpose of sorting/displaying) tbl classes - display name - internal name - display numeric designation - internal numeric designation - description - topic (choose from topics) - prerequisites (lists of other classes needed before taking this class) tbl courses - class (choose from list) - internal course code (perhaps it is auto generated?) - start date (date picker) - end date (date picker) - meeting dates/times (not sure how to identify these in an easy and efficient method, i will try and look at some existing examples) - location (choose from list - "Online" should be added as an additional choice to locations) - max enrollment - general notes - registration thank you note (for inclusion in email thank you after registering) tbl registrations - courseid - studentid - payment status - notes