Skip to content

Instantly share code, notes, and snippets.

View sfentress's full-sized avatar

Sam Fentress sfentress

16 followers · 0 following
  • Concord Consortium
View GitHub Profile
@sfentress
sfentress / query.json
Created May 15, 2017 18:36
Log Manager query for individual pages in LARA
{
"filter": [
{
"key": "page_id",
"list": [
"4611",
"4629"
],
"remove": false,
"filter_type": "string"
@sfentress
sfentress / query.json
Created May 15, 2017 18:25
Log Manager query for individual models in LARA
{
"filter": [
{
"key": "interactive_url",
"list": [
"https://lab.concord.org/embeddable.html#interactives/water/water-1.json",
"https://lab.concord.org/embeddable.html#interactives/water/water-4.json"
],
"remove": false,
"filter_type": "string"
@sfentress
sfentress / Geniverse Log Data query.json
Created May 10, 2017 20:05
Export logs from http://cc-log-manager.herokuapp.com/data_interactive/export
{
"filter": [
{
"key": "activity",
"list": [
"allele-5drakes-tutorial",
"allele-targetMatch-visible-simpleDom",
"allele-targetMatch-hidden-simpleDom"
],
"remove": false,
@sfentress
sfentress / logmanager.json
Created April 26, 2017 17:57
{
"filter": [
{
"key": "run_remote_endpoint",
"list": [
"https://has.portal.concord.org/dataservice/external_activity_data/643e9dc6-8fc4-4123-bbe2-936867db8102",
"https://has.portal.concord.org/dataservice/external_activity_data/9a1e9c2c-3384-4528-afcb-b7240ab1b96f"
],
"remove": false,
"filter_type": "string"
@sfentress
sfentress / filtering.md
Created April 7, 2017 20:35

Filtering on school alone (students in school 1 or 2)

SELECT `report_learners`.* FROM `report_learners` WHERE `report_learners`.`school_id` IN (1,2)

Filtering on permission form alone (students who signed 1 or 2)

@sfentress
sfentress / gist:bf4cd725e30bf98fb6b8ad8a44fdee98
Created April 7, 2017 20:32
== Filtering on school alone (students in school 1 or 2) ==
SELECT `report_learners`.* FROM `report_learners` WHERE `report_learners`.`school_id` IN (1,2)
----
== Filtering on permission form alone (students who signed 1 or 2) ==
SELECT `report_learners`.`id` AS t0_r0, `report_learners`.`learner_id` AS t0_r1, `report_learners`.`student_id` AS t0_r2, `report_learners`.`user_id` AS t0_r3, `report_learners`.`offering_id` AS t0_r4, `report_learners`.`class_id` AS t0_r5, `report_learners`.`last_run` AS t0_r6, `report_learners`.`last_report` AS t0_r7, `report_learners`.`offering_name` AS t0_r8, `report_learners`.`teachers_name` AS t0_r9, `report_learners`.`student_name` AS t0_r10, `report_learners`.`username` AS t0_r11, `report_learners`.`school_name` AS t0_r12, `report_learners`.`class_name` AS t0_r13, `report_learners`.`runnable_id` AS t0_r14, `report_learners`.`runnable_name` AS t0_r15, `report_learners`.`school_id` AS t0_r16, `report_learners`.`num_answerables` AS t0_r17, `report_learners`.`num_answered` AS
@sfentress
sfentress / sparks-authoring.html
Created August 9, 2016 18:32
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Projects: SPARKS : Breadboard Activity Authoring</title>
<link rel="stylesheet" href="styles/site.css" type="text/css" />
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
@sfentress
sfentress / Sparks-Authoring.md
Created August 9, 2016 18:09

Our new breadboard activities all support authoring the entire content from an online authoring system.

The authoring database can be found here: [http://couchdb.cosmos.concord.org/_utils/database.html?sparks]

New activity files can be created quickly, and given an id. That id then instantly becomes a url where you can find the activity you have been authoring. This is designed to be a nice, quick, iterative authoring setup.

If you give an activity the id X, it can be found at [https://sparks-activities.concord.org/sparks-content/activities.html#X]. So, for example, the activity file with the id series-interpretive, for instance, which can be found here: [http://couchdb.cosmos.concord.org/_utils/document.html?sparks/series-interpretive], will instantly create an activity which can be found at [https://sparks-activities.concord.org/sparks-content/activities.html#series-interpretive]

Note: We now can author both "Activities" and "Sections" (or "Levels"). One activity is made up of several sections. Most o

@sfentress
sfentress / Current keywords
Last active July 12, 2016 16:06
Sample Actor-Action-Target Log, and list of current existing keywords
Actors:
USER - actions triggered directly by user
SYSTEM - actions triggered by system (e.g. "started session")
Actions:
STARTED
NAVIGATED
ADVANCED
CHANGED
SUBMITTED
@sfentress
sfentress / index.html
Last active June 16, 2016 18:51
<html>
<head>
</head>
<body>
<h1 id="message">Nothing here</h1>
<script>
var message = window.location.hash.substr(1);
if (message) {
document.getElementById("message").innerHTML = message;