-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcourse_item_grades.html
93 lines (74 loc) · 3.3 KB
/
course_item_grades.html
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<head>
<style>
div {
font-family: monospace;
}
table, th, td {
border: 1px solid black;
border-collapse: collapse;
}
tr:nth-child(odd) {
background-color: #FFFFFF;
}
tr:nth-child(even) {
background-color: #EBF2F2;
}
th, td {
text-align: left;
padding: 5px 10px 5px 5px;
}
</style>
</head>
<div>
<h1>course_item_grades</h1>
<h2>Description</h2>
<p>
Grades of user for each of the items in the course
</p>
<h2> Columns </h2>
<table>
<tr><th>Name</th><th>Description</th></tr>
<tr>
<td>course_id</td><td>22 character unique string identifying an individual course</td>
</tr>
<tr>
<td>course_item_id</td><td>5 character alphanumeric string identifying an individual item within a course.
Items that have the same id that are in different branches of the same course are considered to be the same for the purposes of progress and grade computations. For example, if you complete item xxxxx in branch A, then you have completed it in branch B even if item xxxxx in branch B is very different from item xxxxx in branch A.</td>
</tr>
<tr>
<td>gatech_user_id</td><td>Encrypted Coursera user id for gatech data.</td>
</tr>
<tr>
<td>course_item_grade_ts</td><td>The timestamp for when an item was graded.</td>
</tr>
<tr>
<td>course_item_passing_state_id</td><td>Each item in a course can be in one of three "states": 0 means the learner has not passed it, 1 means the learner has passed it but not verified their identity, and 2 means the learner has passed it and verified their identity.</td>
</tr>
<tr>
<td>course_item_grade_overall</td><td>The grade a learner received on an item in the course.</td>
</tr>
<tr>
<td>course_item_grade_verified</td><td>The grade a learner received on an item in the course, while also verifying their identity. If a learner verify's their identity when competing an item, the "course_item_grade_overall" and "course_item_grade_verified" will be the same. If the learner does not verify their identity when completing an item, the achieved grade will be found in "course_item_grade_overall" while "course_item_grade_verified" will be "0".</td>
</tr>
<tr>
<td>course_item_grade_pending</td><td>True if the learner identity is pending verification.
</td>
</tr>
</table>
<h2>SQL create statement</h2>
<pre>
CREATE TABLE course_item_grades (
course_id varchar
,course_item_id varchar
,gatech_user_id VARCHAR(50) NOT NULL
,course_item_grade_ts timestamp
,course_item_passing_state_id int4
,course_item_grade_overall float4
,course_item_grade_verified float4
,course_item_grade_pending float4
,PRIMARY KEY (course_id, course_item_id, gatech_user_id, course_item_grade_ts)
,FOREIGN KEY (course_id, course_item_id) REFERENCES course_items(course_id, course_item_id)
,FOREIGN KEY (course_item_passing_state_id) REFERENCES course_item_passing_states(course_item_passing_state_id)
);
</pre>
</div>