-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
64 lines (50 loc) · 3.53 KB
/
index.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
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="chrome=1">
<title>SQL Grader for Sabermetrics MOOC</title>
<link rel="stylesheet" href="stylesheets/styles.css">
<link rel="stylesheet" href="stylesheets/pygment_trac.css">
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
<!--[if lt IE 9]>
<script src="//html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
</head>
<body>
<div class="wrapper">
<header>
<h1>SQL Grader</h1>
<p></p>
<p class="view"><a href="https://github.com/bu-ist/edx-sql-grader">View the Project on GitHub <small>bu-ist/edx-sql-grader</small></a></p>
<ul>
<li><a href="https://github.com/bu-ist/edx-sql-grader/zipball/master">Download <strong>ZIP File</strong></a></li>
<li><a href="https://github.com/bu-ist/edx-sql-grader/tarball/master">Download <strong>TAR Ball</strong></a></li>
<li><a href="https://github.com/bu-ist/edx-sql-grader">View On <strong>GitHub</strong></a></li>
</ul>
</header>
<section>
<h3>
<h3>Approach</h3>
<p>For the SQL queries, we will not be developing any “front end” customizations to the edX platform; we will be relying solely upon the platform to provide an interface for managing questions and answers, and for handling all student interactions with the questions and answers.</p>
<p>Students are presented with a question and provided a text area to enter their answer in the form of a SQL query. </p>
<div><img src="media/ui.png"></div>
<p>When the student clicks or taps the button to submit his or her answer, edX submits the response to the XQueue interface, which queues the response until our custom grader processes it. </p>
<p>A canonical “answer” query for the question will also be submitted along with the student response. The canonical query is part of the question definition and is managed using the edX LMS, i.e. the course instructors enter the canonical query along with the question.</p>
<p>When the grader processes a student response, it compares the result set of the canonical query to the result set of the query that the student submitted, i.e. it compares the result of the query that is known to generate the desired result to the result of the query that the student thinks will generate the desired result.</p>
<p>Initially, the grader will perform a simple, binary comparison of the two results. The student’s query will either generate a correct result, or it will not. Additional analysis may be added to the grader if time permits.</p>
<p>The grader then generates a response to be sent back to the edX platform. The response will contain:</p>
<ol>
<li> The “grade”, from 0 to 1. Initially, this will be either a 0 (result did not match expected) or a 1 (result did match expected)</li>
<li> A HTML table representing the output of the student’s query</li>
<li> A HTML table representing the desired output</li>
</ol>
</section>
<footer>
<p>This project is maintained by <a href="https://github.com/bu-ist">bu-ist</a></p>
<p><small>Hosted on GitHub Pages — Theme by <a href="https://github.com/orderedlist">orderedlist</a></small></p>
</footer>
</div>
<script src="javascripts/scale.fix.js"></script>
</body>
</html>