| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST1600/Resources/Notes/Archive/ |
Upload File : |
Sample data:
StudentId StudentName SP Lab01 Lab02 Lab03 Lab04 Lab05 Lab06 Lab07 Lab08 Lab09 Total Final IP
Points: 5 10 5 10 10 15 10 15 15 15 110 Grade Grade
84228748 Lael Abbott 4 10 5 9 ns 3 10 ns ns ns 41 F F
44107438 Bruce Acosta 5 10 5 10 10 15 10 15 15 ns 95 B- A
21479092 Coby Fox 5 10 5 10 10 15 10 ng ns ns 65 F A
42683650 Mira Gentry 5 10 5 10 10 14 10 ns ns ns 64 F A
83681840 Hayes Gibson 5 10 5 9 10 ns ns ns ns ns 39 F C-
40208573 Ethan Gomez 5 10 5 ns ns ns ns 15 ns ns 35 F F
83312932 Xerxes Hayes 5 10 5 ns ns ns ns ns ns ns 20 F F
34673656 Avram Hinton 5 10 5 8 2 ns ns ns ns ns 30 F F
98159249 Caleb Madden 5 10 5 10 10 15 10 ng ns ns 65 F A
94086534 Kristen Maxwell 5 10 5 10 10 15 10 ng ns ns 65 F A
25357066 Amos McCarthy 5 10 5 ng 10 ns 10 ng ns ns 40 F C
55593577 Harper Mcmahon 5 10 5 10 10 5 10 ng ns ns 55 F B
12755860 Nissim Moreno 5 7 ns ns ns ns ns 12 ns ns 24 F F
99496218 Jena Sosa 5 10 5 9 4 ns ns ns ns ns 33 F F
49622000 Colette Valentine 5 5 5 9 10 3 10 ns ns ns 47 F C-
Letter grades: A:93%+, A-:90%+, B+:87%+, B:83%+, B-:80%+, C+:77%+, C:73%+, C-:70%+, F:<70%.
Field descriptions:
StudentId is the unique identifier for each student.
StudentName is the student's first and last name.
SP is the grade for the student's profile.
Lab01 thru Lab09 is the grade each student has received for that lab.
ng = not graded.
ns = not submitted.
You need not store ng or ns grades as they are calculated.
Final Grade is the letter grade for student ( total points / Total points ).
In progress (IP) Grade is the letter grade for student ( total points / total points of graded labs ).
Total, Final Grade, and IP Grade are calculated fields.
UNF:
studentgrades(StudentId*, StudentName, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP)
grades(LetterGrade1, Percentage1, LetterGrade2, Percentage2, LetterGrade3, Percentage3, LetterGrade4, Percentage4, LetterGrade5, Percentage5, LetterGrade6, Percentage6, LetterGrade7, Percentage7, LetterGrade8, Percentage8, LetterGrade9, Percentage9)
Table changes:
New table/field name Original name Description
3NF:
Three data rows: