33:T4c3,VegaLite({ data: {values: govermentGrant}, vconcat: [ { mark: { type: "point",filled: "true"}, encoding: { x: {timeUnit: "year", field: "Year", type: "temporal"}, y: {field: "Grant", type: "quantitative"}, tooltip: [{field: "Year", timeUnit: "year", type:"temporal"}, {field: "Institution"}, {field: "Grant"} ], color: { condition: { field: "Institution", selection: "click", scale: {scheme: "dark2"}, type: "nominal" }, value: "lightgrey" }, size: {field: "Grant", type: "quantitative"}, }, width: 500, height: 700, selection: {brush: {encodings: ["x"], type: "interval"}} }, { encoding: { color: { condition: { field: "Institution", selection: "click", type: "nominal" }, value: "lightgray" }, x: {field:"Grant",aggregate: "sum", type: "quantitative"}, y: {field: "Institution", type: "nominal"} }, width: 500, height:400, mark: "bar", selection: {click: {encodings: ["color"], type: "multi"}}, transform: [{filter: {selection: "brush"}}] } ] })34:T95f,embed({ "$schema": "https://vega.github.io/schema/vega-lite/v3.json", "data": { "url": "https://gist.githubusercontent.com/szechaun/974986ce21216c9614f75c2cbbcb37ba/raw/29e060665dfa362c26f0b837a6e4361db954b1e9/ExpendictureFixed.csv", "format": { "type": "csv", "parse": { "date": "date" } } }, "width": 600, "height": 400, "layer": [ { "encoding": { "x": {"field": "Year", "type": "temporal", "timeUnit": "yearmonthdate"}, "y": {"field": "Expenditures", "type": "quantitative"}, "color": {"field": "Type of expenditures", "type": "nominal"} }, "layer": [{ "mark": "line" },{ "selection": { "label": { "type": "single", "nearest": true, "on": "mouseover", "encodings": [ "x" ], "empty": "none" } }, "mark": "point", "encoding": { "opacity": { "condition": { "selection": "label", "value": 1 }, "value": 0 } } }] }, { "transform": [ { "filter": { "selection": "label" } } ], "layer": [{ "mark": { "type": "rule", "color": "gray" }, "encoding": { "x": { "type": "temporal", "field": "Year" } } }, { "encoding": { "text": { "type": "quantitative", "field": "Expenditures" }, "x": { "type": "temporal", "field": "Year" }, "y": { "type": "quantitative", "field": "Expenditures" } }, "layer": [{ "mark": { "type": "text", "stroke": "white", "strokeWidth": 2, "align": "left", "dx": 5, "dy": -5 } }, { "mark": { "type": "text", "align": "left", "dx": 5, "dy": -5 }, "encoding": { "fill": { "type": "nominal", "field": "Type of expenditures" } } }] }] } ], "config": {} })35:[] 32:{"title":"Assignment 5","cells":[{"id":0,"value":"md`# Assignment 5`","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"md `## Reference`","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"VegaLite = require('@observablehq/vega-lite')","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"dfjs = require('https://bundle.run/dataframe-js@1.3.2')","pinned":false,"hidden":false,"mode":"ojs"},{"id":407,"value":"embed = require(\"vega-embed@3\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":72,"value":"bcTuitionHeadcount = d3.csv(\"https://gist.githubusercontent.com/Jongwonim/be124c1d9841d74bd3c4ff6ec709f625/raw/449ec9b1045b542843b5b3e79fb3420c0f0d5268/BC%2520tuition%2520and%2520headcount.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":136,"value":"govermentGrant= d3.csv(\"https://gist.githubusercontent.com/szechaun/fa1d6cc164fb683bc613970f94145d22/raw/9a19601bdbc087fbc9b33d5684517d28e46ebc28/GrantFixed.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":401,"value":"expenditure = d3.csv(\"https://gist.githubusercontent.com/szechaun/974986ce21216c9614f75c2cbbcb37ba/raw/29e060665dfa362c26f0b837a6e4361db954b1e9/ExpendictureFixed.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":340,"value":"md`## Our Dataset`","pinned":false,"hidden":false,"mode":"ojs"},{"id":342,"value":"md`We have multiple datasets. Our first dataset came from https://catalogue.data.gov.bc.ca/dataset/tuition-fees-for-arts-programs-at-b-c-public-post-secondary-institutions and it shows the tuition fees for a year at an arts programs for all B.C. public post-secondary institution over the years.

\nSecond dataset is from https://catalogue.data.gov.bc.ca/dataset/international-tuition-fees-at-public-post-secondary-institutions-by-economic-development-region and it is the same as the first but for international students.

\nThird dataset is from https://catalogue.data.gov.bc.ca/dataset/operating-grants-at-b-c-public-post-secondary-institutions and it shows the operation grant for BC post secondary institutes over the years`","pinned":false,"hidden":false,"mode":"ojs"},{"id":454,"value":"md`We have multiple datasets. Our first dataset came from https://catalogue.data.gov.bc.ca/dataset/tuition-fees-for-arts-programs-at-b-c-public-post-secondary-institutions and it shows the tuition fees for a year at an arts programs for all B.C. public post-secondary institution over the years.

\nSecond dataset is from https://catalogue.data.gov.bc.ca/dataset/international-tuition-fees-at-public-post-secondary-institutions-by-economic-development-region and it is the same as the first but for international students.

\nThird dataset is from https://catalogue.data.gov.bc.ca/dataset/operating-grants-at-b-c-public-post-secondary-institutions and it shows the operation grant for BC post secondary institutes over the years.

\nFor our last dataset we got it from https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3710002701. In it you could find the expendicture off all degree granting universiteis and colleges over the years in Canada.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":344,"value":"md`## Out Question: Why is school getting so expensive?`","pinned":false,"hidden":false,"mode":"ojs"},{"id":346,"value":"md`It just feels like school is getting really expensive over the years and we want to find out why`","pinned":false,"hidden":false,"mode":"ojs"},{"id":348,"value":"md`### Domestic and International student tuition fee over the years in an arts program in BC public post-secondary`","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"VegaLite({\n height: 400,\n width: 600,\n data: {values: bcTuitionHeadcount},\n mark:\n {type: \"bar\"}\n , \n encoding: { \n y: {field: \"Domestic tuition\", type: \"quantitative\"},\n x: {field: \"Year\", type: \"temporal\", timeUnit:\"year\", scale: {domain: [2008, 2017]}},\n color:{field: \"Sector\", type: \"nominal\"},\n tooltip: [{field: \"Year\", timeUnit: \"year\", type:\"temporal\",title:\"Year\"},{field: \"Sector\"}, {field: \"Domestic tuition\"}]\n }\n \n\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"VegaLite({\n height: 400,\n width: 600,\n data: {values: bcTuitionHeadcount},\n mark: {type: \"bar\"}, \n encoding: { \n y: {field: \"International tuition\", type: \"quantitative\"},\n x: {field: \"Year\", type: \"temporal\", timeUnit:\"year\", scale: {domain: [2008, 2017]}},\n color:{field: \"Sector\", type: \"nominal\"},\n tooltip: [{field: \"Year\", timeUnit: \"year\", type:\"temporal\",title:\"Year\"},{field: \"Sector\"}, {field: \"Institution\"}, {field: \"International tuition\"}]\n }\n\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":354,"value":"md`We can see the trend that tuition fees are going up for both domestic and international students.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":350,"value":"md`### Goverment grant for BC public post-secondary over the years`","pinned":false,"hidden":false,"mode":"ojs"},{"id":138,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":450,"value":"md`Here we coudl clearly see the trend that the goverment grant has for the most part been increasing every year.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":429,"value":"md`### Expenditure of post secondary over the years`","pinned":false,"hidden":false,"mode":"ojs"},{"id":397,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":452,"value":"md`Here we see that expenditure is increasing every year for all post-secondary.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":445,"value":"md` We reference one of the vegalite interactive example for this graph: https://vega.github.io/vega-lite/examples/interactive_multi_line_label.html`","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W35","stdlib":"1","titling":"auto"}