-
Notifications
You must be signed in to change notification settings - Fork 0
/
course_progress.html
76 lines (60 loc) · 2.27 KB
/
course_progress.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
<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_progress</h1>
<h2>Description</h2>
<p>
Contains a log of when and how a user progresses in one course item of a course, with one of two progress states: 'started' or 'completed'
</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_progress_state_type_id</td><td>value of 1 is the `started` state, where value of 2 is the `completed` state</td>
</tr>
<tr>
<td>course_progress_ts</td><td>The timestamp for when a learner's progress on a course item has changed. </td>
</tr>
</table>
<h2>SQL create statement</h2>
<pre>
CREATE TABLE course_progress (
course_id varchar
,course_item_id varchar
,gatech_user_id VARCHAR(50) NOT NULL
,course_progress_state_type_id int4
,course_progress_ts timestamp
,PRIMARY KEY (course_id, course_item_id, gatech_user_id, course_progress_state_type_id, course_progress_ts)
,FOREIGN KEY (course_progress_state_type_id) REFERENCES course_progress_state_types(course_progress_state_type_id)
);
</pre>
</div>