User Login: User ID: Password:     Not registered? Register Now Forget your password? Get It Now

Instructor Login: ID Password

Course Project Requirements

Each group will be assigned slightly different tasks according to the group letter. The division is as follows;

TASK A: Groups A,C,E,H,J,L,N,P,R,T,V,X,Z.

TASK B: Groups B,D,G,I,K,M,O,Q,S,U,W,Y,

The deadline is: June 3rd, 2007 It will NOT be delayed to allow enough time for marking the projects properly. Marking will be according to two criteria; a. That the necessary function works b. That it does what is required. Functions that do not work, will NOT receive partial grades because it is difficult to check the cause of error in runtime code.

Task A:

You will have the student control panel as your main task. You will find part of the structure of the tables in the database already uploaded into your database system.

Write a setup.php program that creates a table with the following structure. Table name: Total_grades. Fields, Student ID, Student Name, Average Assignments, Average Quizzes, Midterm, Project, Final, Total, letter grade. Make sure your numerical fields are all 'double', the student number is 11 in length and integer. The name field must be varchar(40).

Read the scripts that have already been written for your panel, and adjust as follows;

1. When displaying the user profile modify the layout of the data displayed in the page to make it more interesting to read including the functions. Change the layout from the one adopted for the course but keep blue as the main color for the site.
2. Make sure that all the existing functions work by reading the code and fixing them if they require it.
3. Password change screen: This screen should ask for "The current password", "Your new password" "Your new password again". Make sure you compare the two passwords to each other before submitting it to the database. The current system may have already been amended to include double hashing, so if this is the case please keep the double hashing.
4. The email screen will display the old email address and ask for the new email address. Once a student enters the new email address, it will automatically send an email to that address and take the student to a new screen that says that the email has been sent and display a link to go back to the main panel.
5. The assignments grade will show up to ten assignment columns in a table with each column containing the assignment grade for that assignment. This will then be followed by the average of the assignments, that were entered (meaning assignments that are not entered will not be assumed zero)
6. The project grade will be divided into; project functions,project general presentation, delay penalty, then total project grade.
7. There will be no choice for exam grade as students are not allowed to see this grade. It will be replaced with course letter grade, that will be displayed if the date obtained from the server is equal to or past the date approved by the instructure. The authorization date field should be added to the section table.
8. Write an extra function to "Generate total grades" for students that will display to them two rows of the total_grades table; the first contains their data; student id, student name, etc, without including the final grade or the total grade, but including the letter grade if already entered or not null. The second row will contain the class average for all the given fields.
9. When you display the student's grades display a button on that screen that asks students if they wish to export the data to excel format. If they click on the button, then export to csv for excel format and display it on the screen.
10. Add a function to upload an assignment to the server for submission and make sure it is stored in a folder called assignments with the student number and underscore followed by the assignment number (you ask the student to insert this through a form).
11. Once a student uploads an assignment the form takes that student to another page that displays uploaded assignments to date and the student can download any of them.
12. A student can send an email to any of the instructors of the course through a specific form that sends his/her email address in the reply to field and his/her student number and name in the subject.

Task B:

You will have the instructor control panel as your main task. You will find part of the structure of the tables in the database already uploaded into your database system.

Write a setup.php program that creates a table with the following structure. Table name: Total_grades. Fields, Student ID, Student Name, Average Assignments, Average Quizzes, Midterm, Project, Final, Total, letter grade. Make sure your numerical fields are all 'double', the student number is 11 in length and integer. The name field must be varchar(40).

Read the scripts that have already been written for your panel, and adjust as follows;

1. Change the overall layout of the control panel as you wish.
2. Make sure that all existing functions work properly and fix any functions that are not doing what they're supposed to.
3. The pending student list, allows to accept students, reject students, or ignore student. Accepting will copy them to the student table.
4. Password change screen: This screen should ask for "The current password", "Your new password" "Your new password again". Make sure you compare the two passwords to each other before submitting it to the database. The current system may have already been amended to include double hashing, so if this is the case please keep the double hashing.
5. The email screen will display the old email address and ask for the new email address. Once a student enters the new email address, it will automatically send an email to that address and take the student to a new screen that says that the email has been sent and display a link to go back to the main panel.
6. The assignments grade will show up to ten assignment columns in a table with each column containing the assignment grade for that assignment. This will then be followed by the average of the assignments, that were entered (meaning assignments that are not entered will not be assumed zero). An instructor can change any of the grades displayed so the display is done through a form.
7. The project grade will be divided into; project functions,project general presentation, delay penalty, then total project grade. All fields are displayed as fields in a form so that an instructor can change or add grades to any student.
8. Remove the add assignment, add project, add exam and upload lectures links.
9. Add a function called "Generate total grades" that will request if the grades are for a specific section or for all. The result will be a diplay of student id, student name, assignment average, quiz average, midterm theoretical, midterm, practical, project, final. This page will allow an instructor to enter letter grades and for this to be saved in the new table.
10. When you display the student's grades display a button on that screen that asks instructors if they wish to export the data to excel format. If they click on the button, then export to csv for excel format and display it on the screen.
11. Add a function for instructors called "submitted assignments". This will ask an instructor to select the section required and then display a list of student numbers, student names, and buttons that allow that instructor to download submitted assignments
12. An instructor can also change a password or change an email address. Once any of these is done an email is automatically sent to the email address of the instructor to inform the instructor of the change.
13. Notice that an instructor can only see sections that instructor teaches (this is already there). An instructor can also see a list of all students with all their assignment/project/etc grades even if they do not have grade entries (how else can an instructor add grades if only those who already have grades are displayed)

For All Students

• If you wish to know which group you belong to look at the following list (it has not been uploaded yet)
• The page to visit your site is located at g{replace this with your group letter}.jenoa.org
• The control panel of your site is located at yourpage/cpanel
• Your user name is group{your group letter}
• All files should be placed in the File Manage after clicking on the Public_HTML or WWW folder
• You can see what your database contains by visiting MYSQL Databases icon

Grading:

Main functions	Maximum Grade
Fixing any errors that previously existed	20 marks
Email Change Function	5 marks
Password Change Function	5 marks
Display Assignment grades	5 marks
Display Midterm grades	5 marks
Display Project grades	5 marks
Display Letter grades	5 marks
Generate total grade display	10 marks
Generate total grade excel	10 marks
Upload assignments	10 marks
Download assignments	10 marks
Overall functionality of the project	10 marks
Total Grade	100 marks

Extra Information:

1. If you wish to learn more about password hashing, go to this site. Then click on Articles then click on password hashing to see the article
2. Go here to get a more detailed description of the project functions.