I am an administrator for a local school district. we have few hundred classes in our district spread between 7 schools from elementary to high school. I would like to create a data driven website (include graphics for 2 index pages) where each school would be able to create his own sub webpage and use Microsoft office excel spreadsheet templates in order to update the database
## Deliverables
I am an administrator for a local school district. we have few hundred classes in our district spread between 7 schools from elementary to high school. I would like to create a data driven website (include graphics for 2 index pages) where each school would be able to create his own sub webpage and use Microsoft office excel spreadsheet templates in order to update the database Each school will be able to load (to his sub page) teachers and students database (include student picture), also to load/edit Calendar of events and announcements. Each school will be able to email newsletter targeted to parents, students or teachers. Each school will be able to attach classes and students to each teacher. Teachers would be able to upload students academic grades and automatic email notification will be sent to the student parents. Parents who does not have email account will be able to open on line email account with the district (Microsoft exchange 2000) mail server. Parents will be able to send email directly to teachers. Teachers or school administrator who send emails to parents will have return read receipt. If read receipt had not been received within X days, the sender can print the email message and send by mail. I envision 5 main tables: Schools, Teachers, Students, Academics and Classes. I need 5 levels of login privileges: Visitor: (no login required) are able to view students, teachers, calendar, bus routes and other public info. 1) Student: can view only his own academic file 2) Teacher: can view all of his students academic files, upload data to his students 3) Parent: can view only their child academics 4) School: can upload teachers data and edit public info 5) Master: does everything. Upon selecting the successful bidder I will provide the fields structure for each main table, the spreadsheet format for each upload and the menu for the 2 index web pages. We can use SQL 2000 database. Each school will be able to backup his own data. For further questions you can contact me any time. Additional Description here is a possible wish list to add to the project: feature: 1) students can chat live with each other or create work groups 2) teachers can load exams for targeted students to be tested and grades will be automatically graded and posted by software to student academic file. 3) Attendance students report to be email to parents 4) Cafeteria lunch items consumed by student emailed to parents. 5) teachers can post homework. also i am attaching index page (not final) with main and sub menu. BONUS should you finish the project in 4 weeks I will reward you with a 25% bonus.'
## Platform
ASP.NET and MS SQL 2000