coursera-glossary/assessment_math_expression_patterns.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
65
66
67
68
69
70
71
72
73
74
75
<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>assessment_math_expression_patterns</h1>

    <h2>Description</h2>
    <p>
        the patterns of the answers to a math assessment question
    </p>

    <h2> Columns </h2>
    <table>
        <tr><th>Name</th><th>Description</th></tr>

        <tr>
          <td>assessment_question_id</td><td>unique question id of an assessment</td>
        </tr>

        <tr>
          <td>assessment_pattern_id</td><td>No column description available</td>
        </tr>

        <tr>
          <td>assessment_pattern_display</td><td>The JSON blob containing the question prompt. This is written in a custom Coursera markup language. The actual prompt text is encapsulated within key named &quot;value.&quot;</td>
        </tr>

        <tr>
          <td>assessment_pattern_feedback</td><td>The text that is displayed to learners upon answering a question that matches the pattern.</td>
        </tr>

        <tr>
          <td>assessment_pattern_correct</td><td>For math expression type questions, instructors can insert both correct and incorrect answer patterns in order to provide learners with tailored feedback based on common solutions or misconceptions. This field indicates whether the pattern was one that corresponded to a correct solution (t) or an incorrect solution (f).</td>
        </tr>

    </table>

    <h2>SQL create statement</h2>
    <pre>
CREATE TABLE assessment_math_expression_patterns (
    assessment_question_id VARCHAR(50)
    ,assessment_pattern_id VARCHAR(50)
    ,assessment_pattern_display VARCHAR(20000)
    ,assessment_pattern_feedback VARCHAR(20000)
    ,assessment_pattern_correct BOOL
    ,PRIMARY KEY (assessment_question_id, assessment_pattern_id)
    ,FOREIGN KEY (assessment_question_id) REFERENCES assessment_questions(assessment_question_id)
);
    </pre>
</div>