| 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/uploads/20255/CST1600/41/16939843/Lab09/ |
Upload File : |
UNF:
studentgrades (StudentId*, StudentName, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP)
lettergrade (LetterGrade1, Percentage1, LetterGrade2, Percentage2, LetterGrade3, Percentage3, LetterGrade4, Percentage4, LetterGrade5, Percentage5, LetterGrade6, Percentage6, LetterGrade7, Percentage7, LetterGrade8, Percentage8, LetterGrade9, Percentage9)
possiblepoints (SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total)
1NF:
Student StudentID* StudentName
84228748 Lael Abbott
44107438 Bruce Acosta
21479092 Coby Fox
42683650 Mira Gentry
83681840 Hayes Gibson
40208573 Ethan Gomez
83312932 Xerxes Hayes
34673656 Avram Hinton
98159249 Caleb Madden
94086534 Kristen Maxwell
25357066 Amos McCarthy
55593577 Harper Mcmahon
12755860 Nissim Moreno
99496218 Jena Sosa
49622000 Colette Valentine
GradePoints LetterGrade1 Percentage1 LetterGrade2 Percentage2 LetterGrade3 Percentage3 LetterGrade4 Percentage4 LetterGrade5 Percentage5 LetterGrade6 Percentage6 LetterGrade7 Percentage7 LetterGrade8 Percentage8 LetterGrade9 Percentage9
A 93 A- 90 B+ 87 B 83 B- 80 C+ 77 C 73 C- 70 F 0
2NF:
LabGrades StudentName SP Lab01 Lab02 Lab03 Lab04 Lab05 Lab06 Lab07 Lab08 Lab09 Final
Lael Abbott 4 10 5 9 ns 3 10 ns ns ns 41
Bruce Acosta 5 10 5 10 10 15 10 15 15 ns 95
Coby Fox 5 10 5 10 10 15 10 ng ns ns 65
Mira Gentry 5 10 5 10 10 14 10 ns ns ns 64
Hayes Gibson 5 10 5 9 10 ns ns ns ns ns 39
Ethan Gomez 5 10 5 ns ns ns ns 15 ns ns 35
Xerxes Hayes 5 10 5 ns ns ns ns ns ns ns 20
Avram Hinton 5 10 5 8 2 ns ns ns ns ns 30
Caleb Madden 5 10 5 10 10 15 10 ng ns ns 65
Kristen Maxwell 5 10 5 10 10 15 10 ng ns ns 65
Amos McCarthy 5 10 5 ng 10 ns 10 ng ns ns 40
Harper Mcmahon 5 10 5 10 10 5 10 ng ns ns 55
Nissim Moreno 5 7 ns ns ns ns ns 12 ns ns 24
Jena Sosa 5 10 5 9 4 ns ns ns ns ns 33
Colette Valentine 5 5 5 9 10 3 10 ns ns ns 47
3NF:
IncompleteAssignment StudentName ns ng
Lael Abbott Lab04
Lab07
Lab08
Lab09
Bruce Acosta Lab09
Coby Fox Lab08 Lab07
Lab09
Mira Gentry Lab07
Lab08
Lab09
Hayes Gibson Lab05
Lab06
Lab07
Lab08
Lab09
Ethan Gomez Lab03
Lab04
Lab05
Lab06
Lab08
Lab09
Xerxes Hayes Lab03
Lab04
Lab05
Lab06
Lab07
Lab08
Lab09
Avram Hinton Lab05
Lab06
Lab07
Lab08
Lab09
Caleb Madden Lab08 Lab07
Lab09
Kristen Maxwell Lab08 Lab07
Lab09
Amos McCarthy Lab05 Lab03
Lab08 Lab07
Lab09
Harper Mcmahon Lab08 Lab07
Lab09
Nissim Moreno Lab02
Lab03
Lab04
Lab05
Lab06
Lab08
Lab09
Jena Sosa Lab05
Lab06
Lab07
Lab08
Lab09
Colette Valentine Lab07
Lab08
Lab09
Three data rows:
Sample data in table form:
studentgrades (StudentId*, StudentName, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP)
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-
lettergrade (LetterGrade1, Percentage1, LetterGrade2, Percentage2, LetterGrade3, Percentage3, LetterGrade4, Percentage4, LetterGrade5, Percentage5, LetterGrade6, Percentage6, LetterGrade7, Percentage7, LetterGrade8, Percentage8, LetterGrade9, Percentage9)
A, 93, A-, 90, B+, 87, B, 83, B-, 80, C+, 77, C, 73, C-, 70, F, 0
possiblepoints (SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total)
5, 10, 5, 10, 10, 15, 10, 15, 15, 15, 110
Data information:
SP is the point grade for the student's profile.
Lab01 thru Lab09 is the point 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.
Total is the total points the student has.
Final is the letter grade for student ( total points / Total points ).
IP (IIn progressP) Grade is the letter grade for student ( total points / total points of graded labs ).
Total, Final, and IP are calculated fields.