-
Notifications
You must be signed in to change notification settings - Fork 0
/
assessment_text_exact_match_patterns.html
75 lines (59 loc) · 2.21 KB
/
assessment_text_exact_match_patterns.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
<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_text_exact_match_patterns</h1>
<h2>Description</h2>
<p>
[No table description available]
</p>
<h2> Columns </h2>
<table>
<tr><th>Name</th><th>Description</th></tr>
<tr>
<td>assessment_question_id</td><td>The id that uniquely identifies a question in 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 "value."</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 regular 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_text_exact_match_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>