| 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/13216232/Lab09/ |
Upload File : |
UNF:
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
Lael Abbott 4 10 5 9 ns 3 10 ns ns ns 41 F F
Bruce Acosta 5 10 5 10 10 15 10 15 15 ns 95 B- A
Coby Fox 5 10 5 10 10 15 10 ng ns ns 65 F A
Mira Gentry 5 10 5 10 10 14 10 ns ns ns 64 F A
Hayes Gibson 5 10 5 9 10 ns ns ns ns ns 39 F C-
Ethan Gomez 5 10 5 ns ns ns ns 15 ns ns 35 F F
Xerxes Hayes 5 10 5 ns ns ns ns ns ns ns 20 F F
Avram Hinton 5 10 5 8 2 ns ns ns ns ns 30 F F
Caleb Madden 5 10 5 10 10 15 10 ng ns ns 65 F A
Kristen Maxwell 5 10 5 10 10 15 10 ng ns ns 65 F A
Amos McCarthy 5 10 5 ng 10 ns 10 ng ns ns 40 F C
Harper Mcmahon 5 10 5 10 10 5 10 ng ns ns 55 F B
Nissim Moreno 5 7 ns ns ns ns ns 12 ns ns 24 F F
Jena Sosa 5 10 5 9 4 ns ns ns ns ns 33 F F
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%.
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 (In progress) Grade is the letter grade for student ( total points / total points of graded labs ).
Total, Final, and IP are calculated fields.
1NF:
Students
StudentFirstName StudentLastName 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
Lael Abbott 4 10 5 9 ns 3 10 ns ns ns 41 F F
Bruce Acosta 5 10 5 10 10 15 10 15 15 ns 95 B- A
Coby Fox 5 10 5 10 10 15 10 ng ns ns 65 F A
Mira Gentry 5 10 5 10 10 14 10 ns ns ns 64 F A
Hayes Gibson 5 10 5 9 10 ns ns ns ns ns 39 F C-
Ethan Gomez 5 10 5 ns ns ns ns 15 ns ns 35 F F
Xerxes Hayes 5 10 5 ns ns ns ns ns ns ns 20 F F
Avram Hinton 5 10 5 8 2 ns ns ns ns ns 30 F F
Caleb Madden 5 10 5 10 10 15 10 ng ns ns 65 F A
Kristen Maxwell 5 10 5 10 10 15 10 ng ns ns 65 F A
Amos McCarthy 5 10 5 ng 10 ns 10 ng ns ns 40 F C
Harper Mcmahon 5 10 5 10 10 5 10 ng ns ns 55 F B
Nissim Moreno 5 7 ns ns ns ns ns 12 ns ns 24 F F
Jena Sosa 5 10 5 9 4 ns ns ns ns ns 33 F F
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%.
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.
2NF:
Students
StudentId* StudentFirstName StudentLastName 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%.
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 (In progress) Grade is the letter grade for student ( total points / total points of graded labs ).
Total, Final, and IP are calculated fields.
Labs
StudentID@ totalPoints
84228748 41
44107438 95
21479092 65
42683650 64
83681840 39
40208573 35
83312932 20
34673656 30
98159249 65
94086534 65
25457066 40
55593577 55
12755860 24
99496218 33
49622000 47
3NF:
Students
StudentId* StudentFirstName StudentLastName 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%.
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 (In progress) Grade is the letter grade for student ( total points / total points of graded labs ).
Total, Final, and IP are calculated fields.
Lab_Name* Max_Points
SP 5
Lab01 10
Lab02 5
Lab03 10
Lab04 10
Lab05 15
Lab06 10
Lab07 15
Lab08 15
Lab09 15
Student ID@ Final_Grade_Percetage
84228748 37%
44107438 86%
21479092 59%
42683650 58%
83681840 35%
40208573 31%
83312932 18%
34673656 27%
98159249 59%
94086534 59%
25357066 36%
55593577 50%
12755860 21%
99496218 30%
49622000 43%
Three data rows:
Students
StudentId* StudentFirstName StudentLastName 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