coursera-glossary/course_item_programming_assignments.html at master · GatechVIP/coursera-glossary · GitHub

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
<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_programming_assignments</h1>

    <h2>Description</h2>
    <p>
        For each course, provide the mapping between course items and versioned programming assignments.
    </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>programming_assignment_id</td><td>This is a &#x27;course_content_id&#x27;, and is versioned. (e.g ABC@1 is version 1)</td>
        </tr>

    </table>

    <h2>SQL create statement</h2>
    <pre>
CREATE TABLE course_item_programming_assignments (
    course_id varchar
    ,course_item_id varchar
    ,programming_assignment_id varchar
);
    </pre>
</div>