25:["$","title",null,{"children":"Yellowdig Pilot Dashboard | Yellowdig | Observable"}] 4b:T872,{ if (print_friendly) { return html`This dashboard is currently in print-friendly mode. Interactivity and code-inspection may be disabled, and buttons may be unresponsive. To access a fully-featured dashboard, follow the One-Time Set-Up instructions below.

Thanks for piloting Yellowdig! Your Yellowdig Pilot Dashboard is your real-time one-stop shop for pilot data and visualizations. We are an efficacy- and data-driven organization, and we're committed to providing our prospective clients with the tools they need to make informed decisions about their education technology.

To use this dashboard, you will need to (1) generate a Yellowdig API key, (2) create a free Observable account, (3) add your Yellowdig API key to your Observable account, and (4) fork this dashboard.

Don't worry; the process is quick and straightforward! We'll walk you through these steps one-by-one. Once you're done with the initial set-up, receiving and analyzing real-time data is simple. If you need any assistance along the way, reach out to us at clientsuccess@yellowdig.com.

`; } else { return html`Thanks for piloting Yellowdig! Your Yellowdig Pilot Dashboard is your real-time one-stop shop for pilot data and visualizations. We are an efficacy- and data-driven organization, and we're committed to providing our prospective clients with the tools they need to make informed decisions about their education technology.

To use this dashboard, you will need to (1) generate a Yellowdig API key, (2) create a free Observable account, (3) add your Yellowdig API key to your Observable account, and (4) fork this dashboard.

Don't worry; the process is quick and straightforward! We'll walk you through these steps one-by-one. Once you're done with the initial set-up, receiving and analyzing real-time data is simple. If you need any assistance along the way, reach out to us at clientsuccess@yellowdig.com.

`; } }4c:T7ce,html`

Step-by-step instructions

Generate a Yellowdig API key.

Inside Yellowdig, go to Account Settings → API Keys → GENERATE KEY.
Click the icon to copy your new key to your clipboard.

Create a free Observable account.

Click Sign In in the upper-right hand corner of the Observable homepage. Then, follow the prompts to create a new account.

Add your Yellowdig API key to your Observable account.

Go to this page.
Click the New secret button.
Under Key name, enter YD_API_KEY.
Under Key value, paste in your Yellowdig API key.

Fork this dashboard.

Once logged into your Observable account, click on the Fork button in the upper right-hand corner of this page.
This should take you to the Fork that you just created. A popup that says Allow this notebook to access your secrets? should appear. Click OK.

You're done! Now, whenever you access your fork of this page, all you need to do is set a few parameters into the fields below. All of the data and visualizations will update automatically. If you have any questions or concerns about this process, don't hesitate to reach out to us at clientsuccess@yellowdig.com.

`4d:T730,{ while (raw_data.progress) { return html`Yellowdig is downloading ${raw_data.progress} event records (and counting!) for ${title} (${name}). That's a lot of data. Please be patient. 🙂

This message will update when all event records have been downloaded. If you're tired of waiting, try narrowing the date range.`; } if (raw_data[0]['event/actor']['user/username'] == 'Paul Professor') { return html`For network-level data, insert your Network title, Network name (which is in your Yellowdig Organization URL), Start date, and End date in the fields below.

For community-level data, insert your Community Title, Community ID (which is in your Yellowdig Community URL), Start date, and End date.

This notebook is currently populated by demo data, which gives you a sense of what you'll see when you've successfully downloaded your data.`; } else if (raw_data.length == 25000) { return html`You succcessfully downloaded ${raw_data.length} event records, which is the limit for this dashboard. It looks like we were unable to download some events from this timeframe. You may want to narrow the date range and try again. To download larger data sets, check out our in-platform options or consume our API directly.`; } else { return html`Done! Successfully downloaded ${raw_data.length} event records. Have fun exploring your data!

To save the source data to your computer, click one of the Download buttons below.`; } }4e:T683,{ if (parseInt(name)) { return html`Out of the ${number_of_nodes} members who authored a comment at ${title || 'Yellowdig Class of 2024'} during this time frame:

The average member formed ${R.mean( connections_per_member ).toFixed(2)} connections (${R.multiply( R.divide(R.mean(connections_per_member), number_of_nodes), 100 ).toFixed(2)}%).
The most connected member has ${Math.max( ...connections_per_member )} connections.
The least connected member has ${Math.min( ...connections_per_member )} connections.
Network density (${tex`\frac{\text{number of unique connections}}{\text{number of possible unique connections}}`}) = ${network_density}.

`; } else { return html`Out of the ${number_of_nodes} members who authored a comment at ${title || 'Yellowdig Class of 2024'} during this time frame:

The average member formed ${R.mean(connections_per_member).toFixed( 2 )} connections (${R.multiply( R.divide(R.mean(connections_per_member), number_of_nodes), 100 ).toFixed(2)}%).
The most connected member has ${Math.max( ...connections_per_member )} connections.
The least connected member has ${Math.min( ...connections_per_member )} connections.

`; } }4f:[{"id":"253e23318a6de4d8b43d9f4c3a22639ec4a51e56e26fd434868a780baabf8ac8321ed33257b98e7e857266321c439f3eb64ec7dd43ea7e97feddc00703551b4b","href":"https://static.observableusercontent.com/files/253e23318a6de4d8b43d9f4c3a22639ec4a51e56e26fd434868a780baabf8ac8321ed33257b98e7e857266321c439f3eb64ec7dd43ea7e97feddc00703551b4b","name":"u-of-y-business-points.json","type":"application/json","lastModified":1626121102359.875,"size":55727},{"id":"1c2973ae1dd00f72dd62f7ea106b87e2678ab82ef78c6c2ec6c6d33b74abbf9f52e0611679187c4c731d371d0d642fbe9598e4de6b15fcdabaf04e65c35dde51","href":"https://static.observableusercontent.com/files/1c2973ae1dd00f72dd62f7ea106b87e2678ab82ef78c6c2ec6c6d33b74abbf9f52e0611679187c4c731d371d0d642fbe9598e4de6b15fcdabaf04e65c35dde51","name":"u-of-y-student-commons.json","type":"application/json","lastModified":1607383720380.468,"size":958400},{"id":"49832d01a7e8089fc5221e61abd68006e63c1a4adbc9e9d8542364f947c9eff9cab0c55dd60d01cf8a0fa64a7796875451ee7b2e26f2ddcb92c10a63a23cfcc2","href":"https://static.observableusercontent.com/files/49832d01a7e8089fc5221e61abd68006e63c1a4adbc9e9d8542364f947c9eff9cab0c55dd60d01cf8a0fa64a7796875451ee7b2e26f2ddcb92c10a63a23cfcc2","name":"yellowdig-logo.png","type":"image/png","lastModified":1606239056498.529,"size":34194}] 47:{"id":"43158aebd3be42ee","slug":"pilot-dashboard","title":"Yellowdig Pilot Dashboard","thumbnail":"223a027172879305d0bd1315b88be163e4c6058b994d464e99352127f400fc08","access_level":"public","create_time":"$D2020-11-23T22:14:25.951Z","update_time":"$D2021-10-20T18:13:07.261Z","view_time":null,"first_public_time":"$D2020-11-24T23:03:08.933Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"ed5d48fa9ee28c83","login":"yellowdig","name":"Yellowdig","avatar_url":"https://avatars-next.observableusercontent.com/e8639c767e7c55d27868c8ceee8d83256929a09b796be712cbd3864aee389a06","tier":"starter_2024","bio":"Yellowdig is a social learning platform driven by collaboration, data science, and evidence-based educational outcomes.","followed_by_you":false,"follows_you":false},"version":3440,"publish_version":3440,"role":null,"authored":false,"authors":[{"type":"individual","id":"a3c65f77e6c92f85","login":"samuelkampa","name":"Samuel Kampa","avatar_url":"https://avatars-next.observableusercontent.com/83e6e7421b41b40a6924d179dd9f68302f0f128da50a133257c1c286db7f10f4","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"a3c65f77e6c92f85","login":"samuelkampa","name":"Samuel Kampa","avatar_url":"https://avatars-next.observableusercontent.com/83e6e7421b41b40a6924d179dd9f68302f0f128da50a133257c1c286db7f10f4","tier":null,"role":"editor"},{"type":"individual","id":"caa8921c00e122ee","login":"manticarodrigo","name":"Rodrigo Mantica","avatar_url":"https://avatars-next.observableusercontent.com/0700e5938f823e72935b61f83d2ed97e461b680bd672dbbdc48103619cf23bf4","tier":null,"role":"viewer"},{"type":"team","id":"ed5d48fa9ee28c83","login":"yellowdig","name":"Yellowdig","avatar_url":"https://avatars-next.observableusercontent.com/e8639c767e7c55d27868c8ceee8d83256929a09b796be712cbd3864aee389a06","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":28,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Yellowdig Pilot Dashboard","cells":[{"id":433,"value":"md`# Yellowdig Pilot Dashboard`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"{\n if (print_friendly) {\n return md`## YELLOWDIG PILOT DASHBOARD`;\n } else {\n return html`

\n ${await FileAttachment(\"yellowdig-logo.png\").image()}\n

Pilot Dashboard

\n\n

`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":313,"value":"md`## About this Dashboard`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":426,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1423,"value":"md`## One-Time Set-Up (10 minutes)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1451,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3237,"value":"html`

Walkthrough video

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":642,"value":"{\n if (print_friendly) {\n return md`## Input Your Data Parameters (disabled in print-friendly mode)`;\n } else {\n return md`## Input Your Data Parameters`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2189,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2523,"value":"DOM.download(\n new Blob([JSON.stringify(raw_data)], { type: \"application/json\" }),\n `${name}-${start_date.toDateString()}-to-${end_date.toDateString()}.json`,\n \"Download as JSON\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2548,"value":"DOM.download(\n new Blob([data_to_csv(raw_data)], { type: \"text/csv\" }),\n `${name}-${start_date.toDateString()}-to-${end_date.toDateString()}.csv`,\n \"Download as CSV\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2889,"value":"md`### Network Title or Community Title`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2893,"value":"viewof title = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"md`### Network name or Community ID`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":645,"value":"viewof name = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1400,"value":"md`### Start date`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1391,"value":"viewof start_date_str = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1435,"value":"md`### End date`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1406,"value":"viewof end_date_str = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3027,"value":"html`

Created a total of ${number_of_posts} posts (${(\n number_of_posts / number_of_active_members\n).toFixed(2)} posts/member).
Created a total of ${number_of_comments} comments (${(\n number_of_comments / number_of_active_members\n).toFixed(2)} comments/member).
Had a conversation ratio (${tex`\\frac{\\text{number of comments}}{\\text{number of posts}}`}) of ${conversation_ratio}.\n

\nEach node is a member. Hold node to drag. Hover to see Yellowdig user ID.\n
\nEach line represents at least one comment on someone's post.\n
\nThicker line = more connections between members.\n

Accumulated ${number_of_views} post views (${(\n number_of_views / number_of_active_members\n).toFixed(2)} views/member).
Gave ${number_of_reactions} reactions to posts and comments (${(\n number_of_reactions / number_of_active_members\n).toFixed(2)} reactions/member).

Performed an average of ${avg_events_per_day.toFixed(\n 2\n)} activities per day (${(\n avg_events_per_day / number_of_active_members\n).toFixed(2)} activites/member).
Achieved a single-day high of ${max_day_events} activities (${(\n max_day_events / number_of_active_members\n).toFixed(2)} activities/member).

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2164,"value":"html`Number of Activities per Day`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3334,"value":"LineChart(events_by_day, {\n x: (d) => d.date,\n y: (d) => d.value,\n color: \"steelBlue\",\n yLabel: \"↑ Number of events\",\n width: 1000\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2264,"value":"html`Weekly Activity Heatmap`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2209,"value":"Calendar(events_by_day, {\n x: (d) => d.date,\n y: (d) => d.value,\n sunday,\n width: 1000\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3231,"value":"html`Each column represents a week`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3257,"value":"md`### What are they talking about?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3264,"value":"viewof cloud_scale = slider({\n min: 1,\n max: 15,\n step: 1,\n value: 5,\n format: \",\",\n description: \"Set font size. Lower value = more words visible.\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3256,"value":"word_cloud","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3275,"value":"{\n return parseInt(name)\n ? md`### How close are they to reaching the goal?`\n : md``;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3284,"value":"{\n return parseInt(name)\n ? html`Among the ${number_of_active_members} members who were active at ${title ||\n 'Yellowdig Class of 2024'}...\n

${(\n (number_of_perfect_grades / number_of_active_members) *\n 100\n ).toFixed(\n 2\n )}% have met or exceeded the 100% participation goal.
The median grade is ${(median_grade * 100).toFixed(2)}%.

\n`\n : html``;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3283,"value":"{\n return parseInt(name)\n ? html`Yellowdig Grades`\n : html``;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3274,"value":"{\n return parseInt(name)\n ? Plot.plot({\n x: {\n label: \"Yellowdig Grade (%) →\",\n transform: d => d * 100\n },\n y: {\n label: \"↑ Number of Community Members\",\n grid: true\n },\n marks: [\n Plot.rectY(\n points_raw_data,\n Plot.binX(\n { y: \"count\" },\n {\n rx: 8,\n x: \"points/participation_score\",\n fill: \"steelblue\",\n thresholds: \"sturges\"\n }\n )\n ),\n Plot.ruleX([1], { stroke: \"#73c378\", strokeWidth: 5 })\n ]\n })\n : html``;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3281,"value":"{\n return parseInt(name)\n ? html`Total Points Earned`\n : html``;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3293,"value":"{\n return avg_proportion_of_participation_goal !== Infinity\n ? html`\n

The average learner has earned ${(\n avg_proportion_of_participation_goal * 100\n ).toFixed(2)}% of the total participation goal.\n

`\n : html``;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3292,"value":"{\n if (\n parseInt(name) &\n (avg_proportion_of_participation_goal !== Infinity) &\n (avg_proportion_of_participation_goal > 1)\n ) {\n return html`\n

The average learner has exceeded the total participation goal by ${participation_goal_diff.toFixed(\n 0\n )} points.\n`;\n } else if (\n parseInt(name) &\n (avg_proportion_of_participation_goal !== Infinity) &\n (avg_proportion_of_participation_goal <= 1)\n ) {\n return html`
- The average learner is ${R.negate(\n participation_goal_diff.toFixed(0)\n )} points shy of the total participation goal.`;\n } else {\n return html``;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3280,"value":"viewof point_goal = parseInt(name)\n ? html``\n : Object.assign(html``, { value: null })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3279,"value":"{\n return parseInt(name)\n ? Plot.plot({\n x: {\n label: \"Number of Points Earned →\"\n },\n y: {\n label: \"↑ Number of Community Members\",\n grid: true\n },\n marks: [\n Plot.rectY(\n points_raw_data,\n Plot.binX(\n { y: \"count\" },\n {\n rx: 8,\n x: \"points/total\",\n fill: \"steelblue\",\n thresholds: \"sturges\"\n }\n )\n ),\n Plot.ruleX([point_goal ? point_goal : 0], {\n stroke: \"#73c378\",\n strokeWidth: 5\n })\n ]\n })\n : html``;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3266,"value":"html`
  `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3011,"value":"md`## Want to print this notebook to file?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3014,"value":"html`Turn on print-friendly mode by checking the box below. Then, right-click anywhere on the page; select Save As; and save as Webpage, Complete. (Nomenclature may vary depending on your browser.)\n
  
  \nYou can easily share your printed webpage with colleagues, but you cannot code-inspect or dynamically interact with your printed webpage.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3041,"value":"viewof print_friendly = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3074,"value":"html`
  `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3004,"value":"md`## Technical Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"html`If you're comfortable with JavaScript, we invite you to thoroughly investigate the \"bones\" of this report: API calls, data filters, visualization parameters, and imports from other notebooks. To ensure that you can trust the data in this report, we are exposing every step of the process from API call to final product. We believe the data should speak for itself, and we see no need for behind-the-scenes data manipulation.\n
  
  \nIf you have any questions or concerns about this report or about our data processes, please send us a note at clientsuccess@yellowdig.com.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"md`### Live Data Connection (Events)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3157,"value":"start_date = new Date(start_date_str)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3159,"value":"end_date = new Date(end_date_str)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"url = parseInt(name)\n ? `https://data.yellowdig.app/community/${name}/events?reverse=true&limit=250`\n : `https://data.yellowdig.app/network/${name}/events?reverse=true&limit=250`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":967,"value":"raw_data = {\n try {\n let data = [];\n let offset = 0;\n let end;\n do {\n let api_result = await fetch(\n url +\n `&start=${start_date.getTime()}&end=${end_date.getTime()}&offset=${offset}`,\n {\n headers: {\n 'Content-Type': 'application/json',\n apikey: Secret(\"YD_API_KEY\")\n }\n }\n ).then(response => response.json());\n offset += 250;\n end = api_result['at-end'];\n data.push(api_result.data);\n if (data[0] != undefined) {\n yield { progress: offset };\n }\n } while (end == false && data.flat().length < 25000);\n yield data.flat()[0] == undefined\n ? FileAttachment(\"u-of-y-student-commons.json\").json()\n : data.flat();\n } catch (err) {\n yield FileAttachment(\"u-of-y-student-commons.json\").json();\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3272,"value":"md`### Live Data Connection (Points)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3271,"value":"points_url = parseInt(name)\n ? `https://data.yellowdig.app/community/${name}/points?limit=250`\n : `https://data.yellowdig.app/network/${name}/points?limit=250`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3270,"value":"points_raw_data = {\n try {\n let data = [];\n let offset = 0;\n let end;\n do {\n let api_result = await fetch(points_url + `&offset=${offset}`, {\n headers: {\n 'Content-Type': 'application/json',\n apikey: Secret(\"YD_API_KEY\")\n }\n }).then(response => response.json());\n offset += 250;\n end = api_result['at-end'];\n data.push(api_result.data);\n if (data[0] != undefined) {\n yield { progress: offset };\n }\n } while (end == false && data.flat().length < 25000);\n yield data.flat()[0] == undefined\n ? FileAttachment(\"u-of-y-business-points.json\").json()\n : data.flat();\n } catch (err) {\n yield FileAttachment(\"u-of-y-business-points.json\").json();\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"md`### Modules, Imports, and Styles`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2344,"value":"md`#### Modules`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":766,"value":"R = require(\"ramda\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2668,"value":"json2csv = require('json2csv');","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3263,"value":"import { slider } from '@jashkenas/inputs'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3241,"value":"import { analytics } from '@chrispahm/simple-privacy-friendly-web-analytics'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3245,"value":"analytics(html``.href)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2347,"value":"md`#### Imported charts`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1891,"value":"import { chart as post_comment_chart } with {\n post_comment_data as data\n} from \"@d3/horizontal-bar-chart\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3412,"value":"import { BarChart } from \"@d3/horizontal-bar-chart\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3417,"value":"BarChart(post_comment_data, {\n x: (d) => d.value,\n y: (d) => d.name,\n color: \"steelBlue\",\n width: 1000\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3389,"value":"import { ForceGraph } from \"@d3/disjoint-force-directed-graph\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3347,"value":"import { BubbleChart } from \"@d3/bubble-chart\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3322,"value":"import { LineChart } from \"@d3/line-with-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3318,"value":"import { Calendar } from \"@d3/calendar-view\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3255,"value":"import { chart as word_cloud } with {\n all_words as words,\n cloud_scale as fontScale\n} from \"@d3/word-cloud\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3254,"value":"import { stopwords as stopword_set } from \"@d3/word-cloud\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2351,"value":"md`#### Chart modifications and helper functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2289,"value":"sunday = \"sunday\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2712,"value":"function data_to_csv(data) {\n const { parse } = json2csv;\n\n const fields = [\n 'db/id',\n 'event/board.db/id',\n 'event/actor.user/firstname',\n 'event/actor.user/lastname',\n 'event/actor.user/primary-email.email/text',\n 'event/receiver.db/id',\n 'event/receiver.user/firstname',\n 'event/receiver.user/lastname',\n 'event/receiver.user/primary-email.email/text',\n 'event/type',\n 'post/word-count',\n 'post/body-text',\n 'date/iso'\n ];\n const opts = { fields };\n const csv = parse(data, opts);\n return csv;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2354,"value":"md`#### Styles`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":396,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":471,"value":"md`### Data Cleaning and Visualization Mapping`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1942,"value":"number_of_active_members = {\n let member_array_with_repeats = R.map(\n R.path(['event/actor', 'db/id']),\n raw_data\n );\n let member_set = new Set(member_array_with_repeats);\n return member_set.size;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":482,"value":"md`#### Are they conversing?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1835,"value":"count_posts = R.pipe(\n R.filter(x => x['event/type'] == 'post'),\n R.length()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1862,"value":"count_comments = R.pipe(\n R.filter(x => x['event/type'] == 'comment'),\n R.length()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1837,"value":"number_of_posts = count_posts(raw_data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1869,"value":"number_of_comments = count_comments(raw_data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1874,"value":"conversation_ratio = R.divide(number_of_comments, number_of_posts).toFixed(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1899,"value":"post_comment_data = [\n { name: 'P', value: number_of_posts },\n { name: 'C', value: number_of_comments }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":484,"value":"md`#### Are they connecting?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1053,"value":"format_network_array = R.pipe(\n R.filter(x => x['event/type'] == 'comment'),\n R.map(R.paths([['event/actor', 'db/id'], ['event/receiver', 'db/id']])),\n R.reject(R.includes(undefined))\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1093,"value":"network_array = format_network_array(raw_data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1200,"value":"links_array = R.map(x => Object({ source: x[0], target: x[1] }), network_array)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1337,"value":"nodes_array = {\n let commenters = R.pluck(0, network_array);\n let posters = R.pluck(1, network_array);\n let commenters_and_posters = Array.from(\n new Set(R.concat(commenters, posters))\n );\n return R.map(x => Object({ id: x }), commenters_and_posters);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"network_graph_data = Object({ nodes: nodes_array, links: links_array })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1679,"value":"connections_per_member = {\n let nodes = R.pluck('id', network_graph_data.nodes);\n let connections_per_member = [];\n for (let i = 0; i < nodes.length; i++) {\n let temp = [];\n for (let n = 0; n < network_graph_data.links.length; n++) {\n if (nodes[i] == network_graph_data.links[n].source) {\n temp.push(network_graph_data.links[n].target);\n }\n }\n connections_per_member.push(new Set(temp).size);\n }\n return connections_per_member;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1712,"value":"number_of_nodes = nodes_array.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1745,"value":"number_of_unique_edges = {\n let edges = R.map(x => R.pair(x.source, x.target), network_graph_data.links);\n let edges_stringified = edges.map(JSON.stringify);\n let edges_deduped = Array.from(new Set(edges_stringified), JSON.parse);\n return edges_deduped.length;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1780,"value":"network_density = (\n number_of_unique_edges /\n (number_of_nodes * (number_of_nodes - 1))\n).toFixed(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":486,"value":"md`#### Are they listening?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1916,"value":"count_views = R.pipe(\n R.filter(x => x['event/type'] == 'view'),\n R.length()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1923,"value":"count_reactions = R.pipe(\n R.filter(x => x['event/type'] == 'reaction'),\n R.length()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1929,"value":"number_of_views = count_views(raw_data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1932,"value":"number_of_reactions = count_reactions(raw_data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2004,"value":"listening_data = [\n { name: 'Number of Posts', value: number_of_posts, group: 'Sharing' },\n { name: 'Number of Comments', value: number_of_comments, group: 'Sharing' },\n { name: 'Number of Post Views', value: number_of_views, group: 'Listening' },\n {\n name: 'Number of Reactions',\n value: number_of_reactions,\n group: 'Listening'\n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2013,"value":"(listening_data.columns = ['name', 'value'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":488,"value":"md`#### Are they engaging?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2032,"value":"group_by_day = R.groupBy(function(x) {\n let full_date = new Date(x['date/iso']);\n let year = full_date.getFullYear();\n let month = full_date.getMonth();\n let day = full_date.getDate();\n return new Date(year, month, day);\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2048,"value":"data_grouped_by_day = group_by_day(raw_data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2077,"value":"events_by_day = {\n let events = new Object({});\n R.forEach(\n x => (events[x] = data_grouped_by_day[x].length),\n Object.keys(data_grouped_by_day)\n );\n let final = [];\n let dates = Object.keys(events);\n for (let i = 0; i < dates.length; i++) {\n final.push(\n new Object({\n date: new Date(dates[i]),\n value: events[dates[i]]\n })\n );\n }\n return final;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2781,"value":"avg_events_per_day = R.mean(R.pluck('value', events_by_day))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2789,"value":"max_day_events = Math.max(...R.pluck('value', events_by_day))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3253,"value":"md`#### What are they talking about?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3252,"value":"pluck_words = R.pipe(\n R.filter(x => x['event/type'] == 'post' || x['event/type'] == 'comment'),\n R.pluck('post/body-text'),\n R.join(' '),\n R.split(' '),\n R.map(R.toLower),\n R.reject(R.includes(R.__, stopwords))\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3251,"value":"stopwords = Array.from(stopword_set)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3250,"value":"all_words = pluck_words(raw_data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3278,"value":"md`#### How close are they to reaching the goal?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3277,"value":"median_grade = R.median(R.pluck('points/participation_score', points_raw_data))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3276,"value":"number_of_perfect_grades = R.filter(\n x => x >= 1,\n R.pluck('points/participation_score', points_raw_data)\n).length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3291,"value":"avg_proportion_of_participation_goal = R.mean(\n R.pluck('points/total', points_raw_data)\n) / point_goal","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3290,"value":"participation_goal_diff = R.mean(R.pluck('points/total', points_raw_data)) -\n point_goal","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4f","stdlib":"1"}} 24:null