Build a Website

Basic idea - We want to build a website that: - allows users to enter data, - stores the data, and - produces a short report on that data. The users are language teachers. The data that they enter is data on the performance of a student at a particular lesson. The report shows that data in an easy to read format for the students to review. Some of the data in the report is an average of all the students' performance scores (which is why we need to store the data to a database). Details on input interface: There will be two sections on a single html page: 1. "Register a lesson" section at the top. In this section, a user can register an upcoming lesson. The input fields will be: - Student's name (text) - Lesson date (calendar drop down) - Lesson time (calendar drop down) - Lesson name (retrieved from a small selection in the database). - Lesson level (drop down choice of "Pre-Intermediate", "Intermediate", "Upper-Intermediate", "Advanced"). 2. "Create a report" section. This section will display a list of previously Registered Lessons (from the previous section), and updates the list if a new lesson is registered. For each Registered Lesson, there are 4 buttons: 2.1 "Speaking feedback" button When the user clicks this button, the fields shown in the [login to view URL] file (attached) appear in the area below the registered lesson (i.e. this displays dynamically, and does not load a new .html page). 2.2 "Writing feedback" button When the user clicks this button, the fields shown in the [login to view URL] file (attached) appear in the area below the registered lesson (i.e. this displays dynamically, and does not load a new .html page). 2.3 "View Report as .html" button Displays the Report as html. 2.4 "View Report as .pdf" button Creates a .pdf that the user can download. Details on Report: The .html report and .pdf report will have the same data and layout. A sample .pdf report is attached. - <Student's name>, <Date and time>, and <Lesson name> are all retrieved from the database for the corresponding Registered Lesson. - The first table in the report (the one showing "Comprehension", "Clarity", etc... in the first row) contains the data inputted into the "Speaking feedback" form. The "Total" column is the sum of the data divided by 5. - The first graph in the report (the one showing "Comprehension", "Clarity", etc... on the x-axis) contains the data inputted into the "Speaking feedback" form AND also contains an average of all previous data inputted for the same <Lesson name> and <Lesson level> (that's important, so please read the last sentence carefully!). - The second table in the report (the one showing "Phrase Used" and "Correct Phrase" in the first row) contains the data inputted into the "Speaking feedback" form into the "Mistake" and "Correction" fields. - the third table in the report is similar to the first table, but for Writing feedback, not Speaking feedback. - the second graph in the report is similar to the first graph, but for Writing feedback, not Speaking feedback. - the fourth table in the report is similar to the first table, but for Writing feedback, not Speaking feedback. - The file name of the .pdf report is composed of <Student's name> and <Date> from the corresponding Registered Lesson. Details on Login / Logout: Users can login /logout with their Facebook or Google account. Details on design: Design is not an important aspect of this project, except for some logos and nice fonts. The focus is on usability.