The grading scale for
this class is as follows:
|
[95%, ∞] = A |
|
[90%, 95%) = A- |
|
[87%, 90%) = B+ |
|
[83%, 87%) = B |
|
[80%, 83%) = B- |
|
[77%, 80%) = C+ |
|
[73%, 77%) = C |
|
[70%, 73%) = C- |
|
[67%, 70%) = D+ |
|
[63%, 67%) = D |
|
[60%, 63%) = D- |
|
[-∞, 60%) = F |
IMPORTANT:
If you think (1) your achievements were not graded fairly, or (2) I made a
mistake in my calculations, please inform me by e-mail immediately.
Grades
so far:
|
NIC |
Hmrk 1 |
Hmrk 2 |
Test 1 |
Hmrk3 |
Hmrk4 |
Hmrk5 |
Test 2 |
SQL Hmwrk |
Test 3 |
Project |
Final |
NIC |
FINAL SCORE |
FINAL GRADE |
|
107 |
100.0 |
100.0 |
95.0 |
9.2 |
84.0 |
8.5 |
97.1 |
92.9 |
100.0 |
98.0 |
100.0 |
107 |
95 |
A |
|
!BA |
100.0 |
100.0 |
90.0 |
9.0 |
82.0 |
8.0 |
90.0 |
97.0 |
100.0 |
105.0 |
92.4 |
!BA |
94 |
A- |
|
CES |
100.0 |
100.0 |
100.0 |
9.7 |
92.0 |
9.5 |
98.2 |
100.0 |
98.6 |
100.0 |
99.5 |
CES |
97 |
A |
|
CHU |
100.0 |
100.0 |
75.0 |
9.0 |
91.0 |
8.0 |
87.6 |
89.4 |
67.9 |
104.0 |
94.9 |
CHU |
89 |
B+ |
|
CRA |
100.0 |
100.0 |
100.0 |
9.5 |
89.0 |
9.0 |
100.0 |
98.0 |
100.0 |
95.0 |
100.0 |
CRA |
96 |
A |
|
HAI |
100.0 |
100.0 |
100.0 |
0.0 |
80.0 |
7.0 |
52.9 |
79.8 |
81.4 |
0.0 |
0.0 |
HAI |
40 |
F |
|
HOS |
0.0 |
100.0 |
90.0 |
7.6 |
0.0 |
0.0 |
43.5 |
27.8 |
55.7 |
104.0 |
92.9 |
HOS |
67 |
D+ |
|
INI |
0.0 |
100.0 |
90.0 |
9.9 |
99.0 |
7.5 |
92.4 |
90.4 |
72.9 |
96.0 |
94.9 |
INI |
89 |
B+ |
|
ITM |
0.0 |
100.0 |
80.0 |
9.5 |
91.0 |
9.5 |
96.5 |
97.5 |
67.1 |
97.0 |
90.9 |
ITM |
87 |
B+ |
|
JEW |
0.0 |
0.0 |
85.0 |
9.2 |
68.0 |
8.0 |
60.6 |
0.0 |
0.0 |
0.0 |
0.0 |
JEW |
19 |
W |
|
KUR |
100.0 |
100.0 |
75.0 |
9.9 |
84.5 |
7.5 |
85.3 |
78.8 |
61.4 |
0.0 |
0.0 |
KUR |
41 |
F |
|
OMN |
34.0 |
100.0 |
75.0 |
9.0 |
49.0 |
6.5 |
82.4 |
70.2 |
63.6 |
90.0 |
84.8 |
OMN |
76 |
C |
|
RAC |
100.0 |
100.0 |
65.0 |
0.0 |
76.0 |
8.5 |
80.6 |
89.9 |
71.4 |
97.0 |
92.9 |
RAC |
84 |
B |
|
RED |
100.0 |
100.0 |
65.0 |
9.0 |
81.0 |
8.5 |
60.0 |
0.0 |
0.0 |
0.0 |
0.0 |
RED |
21 |
W |
|
SIN |
0.0 |
100.0 |
65.0 |
8.6 |
72.0 |
7.0 |
51.8 |
92.9 |
61.4 |
96.0 |
75.3 |
SIN |
74 |
C |
|
SNW |
0.0 |
100.0 |
60.0 |
8.4 |
62.0 |
6.0 |
72.9 |
78.8 |
0.0 |
0.0 |
0.0 |
SNW |
26 |
F |
|
SQL |
34.0 |
100.0 |
85.0 |
9.0 |
80.0 |
7.5 |
88.2 |
75.8 |
85.7 |
100.0 |
87.4 |
SQL |
87 |
B+ |
|
VER |
100.0 |
100.0 |
100.0 |
8.5 |
74.0 |
7.0 |
86.5 |
93.4 |
100.0 |
98.0 |
98.5 |
VER |
93 |
A- |
|
Z |
100.0 |
100.0 |
15.0 |
8.5 |
50.0 |
7.5 |
40.0 |
91.4 |
84.3 |
97.0 |
87.4 |
Z |
75 |
C |
|
MIN |
0.0 |
0.0 |
15.0 |
0.0 |
0.0 |
0.0 |
40.0 |
0.0 |
0.0 |
0.0 |
0.0 |
MIN |
19.0 |
|
|
MAX |
100.0 |
100.0 |
100.0 |
9.9 |
99.0 |
9.5 |
100.0 |
100.0 |
100.0 |
105.0 |
100.0 |
MAX |
97.0 |
|
|
AVG |
61.5 |
94.7 |
79.5 |
8.1 |
73.9 |
7.4 |
77.2 |
76.0 |
66.8 |
72.5 |
68.0 |
AVG |
71.0 |
|
|
MED |
100.0 |
100.0 |
85.0 |
9.0 |
80.0 |
7.5 |
85.3 |
89.9 |
71.4 |
97.0 |
90.9 |
MED |
84.2 |
|
|
% OF FINAL GRADE |
1.0 |
1.0 |
5.0 |
1.0 |
8.0 |
1.0 |
15.0 |
8.0 |
15.0 |
25.0 |
20.0 |
|
|
|
Test 1 Grades (5% of your final grade):
|
NIC |
Part 1 |
Part 2 |
Part 3 |
Total |
|
107 |
3 |
4 |
2.5 |
9.5 |
|
!BA |
3.5 |
3 |
2.5 |
9 |
|
CES |
3.5 |
4 |
2.5 |
10 |
|
CHU |
2.5 |
4 |
1 |
7.5 |
|
CRA |
3.5 |
4 |
2.5 |
10 |
|
HAI |
3.5 |
4 |
2.5 |
10 |
|
HOS |
3.5 |
3 |
2.5 |
9 |
|
INI |
3.5 |
3 |
2.5 |
9 |
|
ITM |
3 |
4 |
1 |
8 |
|
JEW |
3.5 |
4 |
1 |
8.5 |
|
KUR |
3.5 |
1.5 |
2.5 |
7.5 |
|
OMN |
1.5 |
3.5 |
2.5 |
7.5 |
|
RAC |
3.5 |
2 |
1 |
6.5 |
|
RED |
1.5 |
4 |
1 |
6.5 |
|
SIN |
3.5 |
2 |
1 |
6.5 |
|
SNW |
1.5 |
3.5 |
1 |
6 |
|
SQL |
3.5 |
4 |
1 |
8.5 |
|
VER |
3.5 |
4 |
2.5 |
10 |
|
Z |
0.5 |
0 |
1 |
1.5 |
|
MIN |
0.5 |
0 |
1 |
1.5 |
|
MAX |
3.5 |
4 |
2.5 |
10 |
|
AVG |
2.92 |
3.24 |
1.79 |
7.95 |
|
MED |
3.5 |
4 |
2.5 |
8.5 |
|
% OF TOTAL |
35 |
40 |
25 |
100 |
Music DB ER Design Grades (1% of your final grade):
|
NIC |
Total |
|
107 |
9.2 |
|
!BA |
9.0 |
|
CES |
9.7 |
|
CHU |
9.0 |
|
CRA |
9.5 |
|
HAI |
0.0 |
|
HOS |
7.6 |
|
INI |
9.9 |
|
ITM |
9.5 |
|
JEW |
9.2 |
|
KUR |
9.9 |
|
OMN |
9.0 |
|
RAC |
0.0 |
|
RED |
9.0 |
|
SIN |
8.6 |
|
SNW |
8.4 |
|
SQL |
9.0 |
|
VER |
8.5 |
|
Z |
8.5 |
|
MIN |
0.0 |
|
MAX |
9.9 |
|
AVG |
8.1 |
|
MED |
9.0 |
ER Diagrams Grades (8% of your final grade):
|
NIC |
3.21 |
3.23 |
3.24 |
3.25 |
Total |
|
107 |
24 |
13 |
24 |
23 |
84 |
|
!BA |
18 |
20 |
23 |
21 |
82 |
|
CES |
17 |
25 |
25 |
25 |
92 |
|
CHU |
23 |
23 |
23 |
22 |
91 |
|
CRA |
22 |
24 |
18 |
25 |
89 |
|
HAI |
16 |
20 |
23 |
21 |
80 |
|
HOS |
0 |
0 |
0 |
0 |
0 |
|
INI |
24.5 |
24.5 |
25 |
25 |
99 |
|
ITM |
21 |
25 |
20 |
25 |
91 |
|
JEW |
17 |
24 |
6 |
21 |
68 |
|
KUR |
18 |
20.5 |
23 |
23 |
84.5 |
|
OMN |
15 |
19 |
0 |
15 |
49 |
|
RAC |
22 |
13 |
20 |
21 |
76 |
|
RED |
18 |
13 |
25 |
25 |
81 |
|
SIN |
15 |
14 |
18 |
25 |
72 |
|
SNW |
17 |
11 |
19 |
15 |
62 |
|
SQL |
15 |
17 |
25 |
23 |
80 |
|
VER |
17 |
12 |
20 |
25 |
74 |
|
Z |
15 |
19 |
9 |
7 |
50 |
|
MIN |
0 |
0 |
0 |
0 |
0 |
|
MAX |
24.5 |
25 |
25 |
25 |
99 |
|
AVG |
17.61 |
17.74 |
18.21 |
20.37 |
73.92 |
|
MED |
17 |
19 |
20 |
23 |
80 |
Music ER Mapping Grades (1% of your final grade):
|
NIC |
Total |
|
107 |
8.5 |
|
!BA |
8.0 |
|
CES |
9.5 |
|
CHU |
8.0 |
|
CRA |
9.0 |
|
HAI |
7.0 |
|
HOS |
0.0 |
|
INI |
7.5 |
|
ITM |
9.5 |
|
JEW |
8.0 |
|
KUR |
7.5 |
|
OMN |
6.5 |
|
RAC |
8.5 |
|
RED |
8.5 |
|
SIN |
7.0 |
|
SNW |
6.0 |
|
SQL |
7.5 |
|
VER |
7.0 |
|
Z |
7.5 |
|
MIN |
0.0 |
|
MAX |
9.5 |
|
AVG |
7.4 |
|
MED |
7.5 |
Test 2 Grades (15% of your final grade):
|
NIC |
Part 1 |
Exe.1 |
Exe.2.1 |
Exe.2.2 |
Exe.2.3 |
Exe.3.1 |
Exe.3.2 |
Exe.3.3 |
Part 2 - Total |
Total |
Total CURVED |
NIC |
|
107 |
3.5 |
26.0 |
4.5 |
12.0 |
10.0 |
4.5 |
10.0 |
12.0 |
79.0 |
82.5 |
97.1 |
107 |
|
!BA |
2.0 |
25.0 |
4.5 |
12.0 |
10.0 |
5.0 |
9.5 |
8.5 |
74.5 |
76.5 |
90.0 |
!BA |
|
CES |
15.5 |
23.0 |
5.0 |
4.0 |
10.0 |
5.0 |
9.0 |
12.0 |
68.0 |
83.5 |
98.2 |
CES |
|
CHU |
6.5 |
24.0 |
4.0 |
6.0 |
9.0 |
5.0 |
10.0 |
10.0 |
68.0 |
74.5 |
87.6 |
CHU |
|
CRA |
14.0 |
30.0 |
4.5 |
12.0 |
10.0 |
5.0 |
10.0 |
11.0 |
82.5 |
96.5 |
100.0 |
CRA |
|
HAI |
0.5 |
16.0 |
4.5 |
2.0 |
5.0 |
4.5 |
7.5 |
5.0 |
44.5 |
45.0 |
52.9 |
HAI |
|
HOS |
3.0 |
8.0 |
1.0 |
1.0 |
1.0 |
5.0 |
9.0 |
9.0 |
34.0 |
37.0 |
43.5 |
HOS |
|
INI |
6.5 |
27.0 |
4.5 |
7.5 |
10.0 |
1.0 |
11.0 |
11.0 |
72.0 |
78.5 |
92.4 |
INI |
|
ITM |
9.0 |
27.0 |
5.0 |
9.0 |
10.0 |
5.0 |
8.0 |
9.0 |
73.0 |
82.0 |
96.5 |
ITM |
|
JEW |
0.0 |
28.0 |
2.5 |
2.0 |
1.0 |
2.0 |
5.0 |
11.0 |
51.5 |
51.5 |
60.6 |
JEW |
|
KUR |
2.0 |
23.0 |
5.0 |
10.5 |
10.0 |
3.0 |
9.0 |
10.0 |
70.5 |
72.5 |
85.3 |
KUR |
|
OMN |
8.0 |
22.0 |
5.0 |
5.0 |
6.0 |
5.0 |
10.0 |
9.0 |
62.0 |
70.0 |
82.4 |
OMN |
|
RAC |
2.0 |
25.0 |
4.5 |
8.0 |
10.0 |
5.0 |
9.0 |
5.0 |
66.5 |
68.5 |
80.6 |
RAC |
|
RED |
0.5 |
20.0 |
4.5 |
6.0 |
0.0 |
5.0 |
9.0 |
6.0 |
50.5 |
51.0 |
60.0 |
RED |
|
SIN |
0.0 |
23.0 |
3.0 |
0.0 |
0.0 |
1.0 |
9.0 |
8.0 |
44.0 |
44.0 |
51.8 |
SIN |
|
SNW |
-1.5 |
20.0 |
4.5 |
9.0 |
8.0 |
4.0 |
10.0 |
8.0 |
63.5 |
62.0 |
72.9 |
SNW |
|
SQL |
4.5 |
27.0 |
3.0 |
9.0 |
10.0 |
4.5 |
10.0 |
7.0 |
70.5 |
75.0 |
88.2 |
SQL |
|
VER |
3.5 |
24.0 |
4.5 |
9.0 |
8.0 |
5.0 |
9.0 |
10.5 |
70.0 |
73.5 |
86.5 |
VER |
|
Z |
-4.5 |
16.0 |
4.5 |
3.0 |
6.0 |
1.0 |
2.0 |
6.0 |
38.5 |
34.0 |
40.0 |
Z |
|
MIN |
-4.5 |
8.0 |
1.0 |
0.0 |
0.0 |
1.0 |
2.0 |
5.0 |
34.0 |
34.0 |
40.0 |
MIN |
|
MAX |
15.5 |
30.0 |
5.0 |
12.0 |
10.0 |
5.0 |
11.0 |
12.0 |
82.5 |
96.5 |
100.0 |
MAX |
|
AVG |
3.9 |
22.8 |
4.1 |
6.7 |
7.1 |
4.0 |
8.7 |
8.8 |
62.3 |
66.2 |
77.2 |
AVG |
|
MED |
3.0 |
24.0 |
4.5 |
7.5 |
9.0 |
5.0 |
9.0 |
9.0 |
68.0 |
72.5 |
85.3 |
MED |
SQL Grades (8% of your final grade):
|
NIC |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
TOTAL |
TOTAL CURVED |
|
107 |
4 |
4 |
3 |
4 |
4 |
4 |
4 |
4 |
2.5 |
4 |
4 |
2.5 |
4 |
4 |
4 |
4 |
4 |
3 |
4 |
3 |
4 |
4 |
2.5 |
3.5 |
4 |
92 |
92.9 |
|
!BA |
3 |
3 |
4 |
4 |
4 |
4 |
4 |
4 |
2.5 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
3.5 |
4 |
96 |
97.0 |
|
CES |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
3 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
99 |
100.0 |
|
CHU |
4 |
3 |
4 |
4 |
4 |
4 |
4 |
4 |
2.5 |
4 |
4 |
3 |
2.5 |
4 |
4 |
4 |
4 |
3 |
4 |
3 |
3 |
4 |
3.5 |
4 |
1 |
88.5 |
89.4 |
|
CRA |
4 |
3 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
2.5 |
3.5 |
4 |
97 |
98.0 |
|
HAI |
3 |
2 |
4 |
4 |
4 |
4 |
4 |
2 |
4 |
2 |
4 |
3 |
0 |
4 |
1.5 |
4 |
4 |
3 |
4 |
3 |
2.5 |
4 |
2 |
3 |
4 |
79 |
79.8 |
|
HOS |
3 |
2 |
2 |
4 |
4 |
4 |
4 |
2 |
2.5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
27.5 |
27.8 |
|
INI |
3 |
4 |
3.5 |
4 |
4 |
4 |
4 |
4 |
2 |
4 |
4 |
2.5 |
4 |
3.5 |
4 |
4 |
4 |
3 |
2 |
4 |
4 |
3 |
3 |
4 |
4 |
89.5 |
90.4 |
|
ITM |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
3 |
3 |
4 |
4 |
3.5 |
4 |
4 |
4 |
4 |
3 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
96.5 |
97.5 |
|
JEW |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0.0 |
|
KUR |
3 |
3 |
2 |
4 |
4 |
4 |
4 |
4 |
2.5 |
2 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
2 |
4 |
3 |
2.5 |
4 |
1.5 |
3.5 |
4 |
78 |
78.8 |
|
OMN |
3 |
2 |
3.5 |
4 |
4 |
4 |
4 |
2 |
2.5 |
4 |
4 |
2 |
0 |
4 |
1.5 |
0 |
1.5 |
3 |
2 |
3 |
4 |
3 |
1 |
3.5 |
4 |
69.5 |
70.2 |
|
RAC |
3 |
3 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
2 |
4 |
3 |
3 |
4 |
4 |
4 |
4 |
3 |
4 |
3 |
4 |
4 |
2.5 |
2.5 |
4 |
89 |
89.9 |
|
RED |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0.0 |
|
SIN |
3 |
3 |
3.5 |
4 |
4 |
4 |
4 |
4 |
3 |
4 |
4 |
3.5 |
4 |
4 |
4 |
4 |
4 |
3 |
2 |
4 |
4 |
3 |
4 |
4 |
4 |
92 |
92.9 |
|
SNW |
3 |
3 |
2 |
4 |
4 |
4 |
4 |
4 |
2.5 |
2 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
2 |
4 |
3 |
2.5 |
4 |
1.5 |
3.5 |
4 |
78 |
78.8 |
|
SQL |
4 |
2 |
4 |
4 |
4 |
3.5 |
4 |
3 |
1 |
2 |
4 |
3 |
3 |
3 |
2 |
4 |
4 |
3.5 |
2 |
3 |
3 |
2.5 |
1.5 |
2 |
3 |
75 |
75.8 |
|
VER |
3 |
3 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
3 |
4 |
4 |
4 |
4 |
4 |
4 |
4 |
3 |
2 |
4 |
4 |
4 |
2.5 |
4 |
4 |
92.5 |
93.4 |
|
Z |
4 |
4 |
3.5 |
4 |
4 |
4 |
4 |
4 |
3 |
4 |
4 |
3 |
2.5 |
4 |
4 |
4 |
4 |
3 |
2 |
4 |
4 |
4 |
3 |
2.5 |
4 |
90.5 |
91.4 |
|
MIN |
3.0 |
2.0 |
2.0 |
4.0 |
4.0 |
3.5 |
4.0 |
2.0 |
1.0 |
2.0 |
3.0 |
2.0 |
0.0 |
3.0 |
1.5 |
0.0 |
1.5 |
2.0 |
2.0 |
3.0 |
2.5 |
2.5 |
1.0 |
2.0 |
1.0 |
0.0 |
0.0 |
|
MAX |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
99.0 |
100.0 |
|
AVG |
3.4 |
3.1 |
3.5 |
4.0 |
4.0 |
4.0 |
4.0 |
3.6 |
2.9 |
3.3 |
3.9 |
3.2 |
3.0 |
3.8 |
3.4 |
3.6 |
3.7 |
3.0 |
3.3 |
3.5 |
3.6 |
3.7 |
2.7 |
3.4 |
3.8 |
75.2 |
76.0 |
|
MED |
3.00 |
3.00 |
4.00 |
4.00 |
4.00 |
4.00 |
4.00 |
4.00 |
2.50 |
4.00 |
4.00 |
3.00 |
3.25 |
4.00 |
4.00 |
4.00 |
4.00 |
3.00 |
4.00 |
3.50 |
4.00 |
4.00 |
2.50 |
3.50 |
4.00 |
89.00 |
89.9 |
Test 3 Grades (15% of your final grade):
|
NIC |
Part 1 |
Exe.1.1 |
Exe.1.2 |
Exe.1.3 |
Exe.2 |
Exe.3 |
Part 2 - Total |
Total |
Total CURVED |
NIC |
|
107 |
6.5 |
14.0 |
15.0 |
19.0 |
25.0 |
10.0 |
83.0 |
89.5 |
100.0 |
107 |
|
!BA |
7.5 |
10.0 |
7.0 |
20.0 |
18.0 |
10.0 |
65.0 |
72.5 |
100.0 |
!BA |
|
CES |
8.0 |
12.0 |
7.0 |
18.0 |
14.0 |
10.0 |
61.0 |
69.0 |
98.6 |
CES |
|
CHU |
3.5 |
10.0 |
7.0 |
20.0 |
7.0 |
0.0 |
44.0 |
47.5 |
67.9 |
CHU |
|
CRA |
6.0 |
15.0 |
7.0 |
19.5 |
25.0 |
0.0 |
66.5 |
72.5 |
100.0 |
CRA |
|
HAI |
8.0 |
10.0 |
10.0 |
0.0 |
19.0 |
10.0 |
49.0 |
57.0 |
81.4 |
HAI |
|
HOS |
-5.0 |
14.0 |
7.0 |
7.0 |
16.0 |
0.0 |
44.0 |
39.0 |
55.7 |
HOS |
|
INI |
-1.0 |
12.0 |
5.0 |
16.0 |
19.0 |
0.0 |
52.0 |
51.0 |
72.9 |
INI |
|
ITM |
-2.0 |
10.0 |
10.0 |
10.0 |
16.0 |
3.0 |
49.0 |
47.0 |
67.1 |
ITM |
|
JEW |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
JEW |
|
KUR |
3.5 |
13.5 |
15.0 |
5.0 |
6.0 |
0.0 |
39.5 |
43.0 |
61.4 |
KUR |
|
OMN |
-1.0 |
13.5 |
12.0 |
6.0 |
8.0 |
6.0 |
45.5 |
44.5 |
63.6 |
OMN |
|
RAC |
3.0 |
14.0 |
10.0 |
10.0 |
13.0 |
0.0 |
47.0 |
50.0 |
71.4 |
RAC |
|
RED |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
RED |
|
SIN |
0.0 |
10.0 |
3.0 |
13.0 |
17.0 |
0.0 |
43.0 |
43.0 |
61.4 |
SIN |
|
SNW |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
SNW |
|
SQL |
7.0 |
11.0 |
7.0 |
19.0 |
11.0 |
5.0 |
53.0 |
60.0 |
85.7 |
SQL |
|
VER |
5.5 |
15.0 |
7.0 |
17.0 |
23.0 |
5.0 |
67.0 |
72.5 |
100.0 |
VER |
|
Z |
1.0 |
15.0 |
7.0 |
17.0 |
14.0 |
5.0 |
58.0 |
59.0 |
84.3 |
Z |
|
MIN |
-5.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
MIN |
|
MAX |
8.0 |
15.0 |
15.0 |
20.0 |
25.0 |
10.0 |
83.0 |
89.5 |
100.0 |
MAX |
|
AVG |
2.7 |
10.5 |
7.2 |
11.4 |
13.2 |
3.4 |
45.6 |
48.3 |
66.9 |
AVG |
|
MED |
3.0 |
12.0 |
7.0 |
13.0 |
14.0 |
0.0 |
49.0 |
50.0 |
71.4 |
MED |
Projects Grades (25% of your final grade):
|
PROJECT |
System Requirements |
Contextual DFD |
ER in Min, Max notation |
Rationale for DBMS |
Normalized &
Implementation-ready Models |
Data Dictionary |
SQL |
Documentation |
Presentation |
Bonus for NON-PROFIT |
TOTAL |
|
Restaurant |
15 |
4 |
20 |
4 |
25 |
5 |
12 |
5 |
5 |
|
95 |
|
Daycare |
14 |
5 |
19 |
4 |
25 |
5 |
15 |
5 |
5 |
|
97 |
|
MMORPG |
15 |
4 |
20 |
4 |
25 |
5 |
15 |
5 |
5 |
|
98 |
|
WSC |
15 |
5 |
20 |
5 |
25 |
5 |
15 |
5 |
5 |
5 |
105 |
|
CORONA |
15 |
5 |
20 |
4 |
25 |
5 |
15 |
5 |
5 |
5 |
104 |
|
Blood Drive |
13 |
5 |
20 |
0 |
25 |
5 |
12 |
5 |
5 |
|
90 |
|
Clinic |
15 |
5 |
20 |
5 |
25 |
5 |
12 |
5 |
4 |
|
96 |
|
Quiz Sys. |
15 |
5 |
20 |
5 |
25 |
5 |
15 |
5 |
5 |
|
100 |
|
Hockey |
15 |
5 |
20 |
5 |
25 |
5 |
12 |
5 |
5 |
|
97 |
|
MIN |
13.0 |
4.0 |
19.0 |
0.0 |
25.0 |
5.0 |
12.0 |
5.0 |
4.0 |
5.0 |
90.0 |
|
MAX |
15.0 |
5.0 |
20.0 |
5.0 |
25.0 |
5.0 |
15.0 |
5.0 |
5.0 |
5.0 |
105.0 |
|
AVG |
14.7 |
4.8 |
19.9 |
4.0 |
25.0 |
5.0 |
13.7 |
5.0 |
4.9 |
5.0 |
98.0 |
|
MED |
15.0 |
5.0 |
20.0 |
4.0 |
25.0 |
5.0 |
15.0 |
5.0 |
5.0 |
5.0 |
97.0 |
Final Exam Grades (20% of your final grade):
|
NIC |
Part 1 |
Exe. 5 |
Exe. 6 |
Exe. 7 |
Exe. 8.a |
Exe. 8.b |
Exe. 8.c |
Exe. 8.d |
Part 2 - Total |
Total |
Total CURVED |
NIC |
|
107 |
16.0 |
20.0 |
20.0 |
10.0 |
5.0 |
5.0 |
11.0 |
12.0 |
83.0 |
99.0 |
100.0 |
107 |
|
!BA |
12.0 |
17.5 |
20.0 |
10.0 |
5.0 |
5.0 |
10.0 |
12.0 |
79.5 |
91.5 |
92.4 |
!BA |
|
CES |
16.0 |
18.5 |
20.0 |
10.0 |
5.0 |
5.0 |
12.0 |
12.0 |
82.5 |
98.5 |
99.5 |
CES |
|
CHU |
12.0 |
19.5 |
18.5 |
10.0 |
5.0 |
5.0 |
12.0 |
12.0 |
82.0 |
94.0 |
94.9 |
CHU |
|
CRA |
16.0 |
20.0 |
19.5 |
10.0 |
5.0 |
5.0 |
12.0 |
12.0 |
83.5 |
99.5 |
100.0 |
CRA |
|
HAI |
|
|
|
|
|
|
|
|
0.0 |
0.0 |
HAI |
|
|
HOS |
12.0 |
19.5 |
18.5 |
10.0 |
5.0 |
5.0 |
12.0 |
10.0 |
80.0 |
92.0 |
92.9 |
HOS |
|
INI |
12.0 |
18.5 |
19.5 |
10.0 |
5.0 |
5.0 |
12.0 |
12.0 |
82.0 |
94.0 |
94.9 |
INI |
|
ITM |
16.0 |
19.0 |
20.0 |
5.0 |
5.0 |
5.0 |
10.0 |
10.0 |
74.0 |
90.0 |
90.9 |
ITM |
|
JEW |
|
|
|
|
|
|
|
|
0.0 |
0.0 |
JEW |
|
|
KUR |
|
|
|
|
|
|
|
|
0.0 |
0.0 |
KUR |
|
|
OMN |
12.0 |
18.0 |
17.5 |
10.0 |
4.5 |
5.0 |
7.0 |
10.0 |
72.0 |
84.0 |
84.8 |
OMN |
|
RAC |
16.0 |
17.5 |
19.5 |
10.0 |
5.0 |
5.0 |
7.0 |
12.0 |
76.0 |
92.0 |
92.9 |
RAC |
|
RED |
|
|
|
|
|
|
|
|
0.0 |
0.0 |
RED |
|
|
SIN |
4.0 |
15.5 |
16.0 |
10.0 |
4.5 |
5.0 |
8.5 |
11.0 |
70.5 |
74.5 |
75.3 |
SIN |
|
SNW |
|
|
|
|
|
|
|
|
0.0 |
0.0 |
SNW |
|
|
SQL |
8.0 |
17.0 |
17.5 |
10.0 |
5.0 |
5.0 |
12.0 |
12.0 |
78.5 |
86.5 |
87.4 |
SQL |
|
VER |
16.0 |
19.0 |
18.5 |
10.0 |
5.0 |
5.0 |
12.0 |
12.0 |
81.5 |
97.5 |
98.5 |
VER |
|
Z |
12.0 |
18.0 |
17.5 |
10.0 |
5.0 |
5.0 |
7.0 |
12.0 |
74.5 |
86.5 |
87.4 |
Z |
|
MIN |
4.0 |
15.5 |
16.0 |
5.0 |
4.5 |
5.0 |
7.0 |
10.0 |
0.0 |
0.0 |
0.0 |
MIN |
|
MAX |
16.0 |
20.0 |
20.0 |
10.0 |
5.0 |
5.0 |
12.0 |
12.0 |
83.5 |
99.5 |
100.0 |
MAX |
|
AVG |
12.9 |
18.4 |
18.8 |
9.6 |
4.9 |
5.0 |
10.3 |
11.5 |
57.9 |
67.3 |
68.0 |
AVG |
|
MED |
12.0 |
18.5 |
19.0 |
10.0 |
5.0 |
5.0 |
11.5 |
12.0 |
76.0 |
90.0 |
90.9 |
MED |