book

Report

Use only Javascript and SVG to produce a data analysis / visualization report.

Authors

This report is prepared by

Zhili Yang
Caleb Hsu
Andrew Linenfelser
Andrey Shprengel
Andrew Berumen

What is the enrollment across colleges?[top]

Viz

<rect x="0"
      y="0"
      height="20"
      width="597.815"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="605.815" y="17">
    AS: 119563
</text>
<rect x="0"
      y="35"
      height="20"
      width="87.615"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="95.615" y="52">
    BU: 17523
</text>
<rect x="0"
      y="70"
      height="20"
      width="15.99"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="23.990000000000002" y="87">
    EB: 3198
</text>
<rect x="0"
      y="105"
      height="20"
      width="135.235"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="143.235" y="122">
    EN: 27047
</text>
<rect x="0"
      y="140"
      height="20"
      width="5.885"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="13.885" y="157">
    GR: 1177
</text>
<rect x="0"
      y="175"
      height="20"
      width="14.91"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="22.91" y="192">
    JR: 2982
</text>
<rect x="0"
      y="210"
      height="20"
      width="25.83"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="33.83" y="227">
    LW: 5166
</text>
<rect x="0"
      y="245"
      height="20"
      width="35.17"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="43.17" y="262">
    MB: 7034
</text>
<rect x="0"
      y="280"
      height="20"
      width="2.795"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="10.795" y="297">
    XX: 559
</text>
<rect x="0"
      y="315"
      height="20"
      width="1.92"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="9.92" y="332">
    undefined: 384
</text>
<rect x="0"
      y="350"
      height="20"
      width="7"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="15" y="367">
    AP: 1400
</text>

Solution: SVG Template

<rect x="${d.x}"
      y="${d.y}"
      height="${d.height}"
      width="${d.width}"
      style="fill:${d.color};
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="${d.width + 8}" y="${d.y + 17}">
    ${d.label}: ${d.count}
</text>

Solution: Javascript

var groups = _.groupBy(data, function(d){
    return d['CrsPBAColl']
})

var count = _.mapValues(groups, function(g) {
    return _.sum(_.pluck(g, 'N.ENROLL'))
})

var keys = _.keys(count)

var final = _.map(keys, function(key) {
    return {"name": key, "enroll": count[key]}
})

console.log(final)

/* SVG Functions */
function computeX(d, i) {
    return 0
}

function computeHeight(d, i) {
    return 20
}

function computeWidth(d, i) {
    return d.enroll / 200
}

function computeY(d, i) {
    return 35 * i
}

function computeColor(d, i) {
    return 'teal'
}

function computeLabel(d, i) {
    return d.name
}

function computeLabel2(d, i) {
    return d.enroll
}

var viz = _.map(final, function(d, i){
    return {
        x: computeX(d, i),
        y: computeY(d, i),
        height: computeHeight(d, i),
        width: computeWidth(d, i),
        color: computeColor(d, i),
        label: computeLabel(d, i),
        count: computeLabel2(d, i)
    }
 })
console.log(viz)

var result = _.map(viz, function(d){
         // invoke the compiled template function on each viz data
         return template({d: d})
     })
return result.join('\n')

Console

[{"name":"AS","enroll":119563},{"name":"BU","enroll":17523},{"name":"EB","enroll":3198},{"name":"EN","enroll":27047},{"name":"GR","enroll":1177},{"name":"JR","enroll":2982},{"name":"LW","enroll":5166},{"name":"MB","enroll":7034},{"name":"XX","enroll":559},{"name":"undefined","enroll":384},{"name":"AP","enroll":1400}]

[{"x":0,"y":0,"height":20,"width":597.815,"color":"teal","label":"AS","count":119563},{"x":0,"y":35,"height":20,"width":87.615,"color":"teal","label":"BU","count":17523},{"x":0,"y":70,"height":20,"width":15.99,"color":"teal","label":"EB","count":3198},{"x":0,"y":105,"height":20,"width":135.235,"color":"teal","label":"EN","count":27047},{"x":0,"y":140,"height":20,"width":5.885,"color":"teal","label":"GR","count":1177},{"x":0,"y":175,"height":20,"width":14.91,"color":"teal","label":"JR","count":2982},{"x":0,"y":210,"height":20,"width":25.83,"color":"teal","label":"LW","count":5166},{"x":0,"y":245,"height":20,"width":35.17,"color":"teal","label":"MB","count":7034},{"x":0,"y":280,"height":20,"width":2.795,"color":"teal","label":"XX","count":559},{"x":0,"y":315,"height":20,"width":1.92,"color":"teal","label":"undefined","count":384},{"x":0,"y":350,"height":20,"width":7,"color":"teal","label":"AP","count":1400}]

What is the average GPA across colleges?[top]

Viz

<rect x="0"
      y="184.99620018535657"
      height="215.00379981464343"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="0" y="184.99620018535657">AS</text>
<rect x="50"
      y="195.24629629629615"
      height="204.75370370370385"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="50" y="195.24629629629615">BU</text>
<rect x="100"
      y="145.33093525179848"
      height="254.66906474820152"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="100" y="145.33093525179848">EB</text>
<rect x="150"
      y="172.33507853403134"
      height="227.66492146596866"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="150" y="172.33507853403134">EN</text>
<rect x="200"
      y="149.70196078431366"
      height="250.29803921568634"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="200" y="149.70196078431366">GR</text>
<rect x="250"
      y="163.071875"
      height="236.928125"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="250" y="163.071875">JR</text>
<rect x="300"
      y="197.0795454545454"
      height="202.9204545454546"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="300" y="197.0795454545454">LW</text>
<rect x="350"
      y="154.233195020747"
      height="245.766804979253"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="350" y="154.233195020747">MB</text>
<rect x="400"
      y="141.77000000000004"
      height="258.22999999999996"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="400" y="141.77000000000004">XX</text>
<rect x="450"
      y="169.69999999999996"
      height="230.30000000000004"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="450" y="169.69999999999996">undefined</text>
<rect x="500"
      y="169.82833333333332"
      height="230.17166666666668"
      width="20"
      style="fill:red;
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="500" y="169.82833333333332">AP</text>

Solution: SVG Template

<rect x="${d.x}"
      y="${d.y}"
      height="${d.height}"
      width="${d.width}"
      style="fill:${d.color};
             stroke-width:3;
             stroke:rgb(0,0,0)" />
<text x="${d.x}" y="${d.y}">${d.label.name}</text>

Solution: Javascript

var groups=_.groupBy(data, function(group){
	return group['CrsPBAColl']
})
var avgJson=_.mapValues(groups, function(group){
    return _.sum(group, function(e){
    	return e["AVG_GRD"]
    })/_.size(group)
})
var keys=_.keys(avgJson)
var avgList=_.map(keys, function(key){
	return {"name": key, "AvgGPA": avgJson[key]}
})
console.log(avgList)

function computeX(d, i) {
    return 50*i
}

function computeHeight(d, i) {
    return d['AvgGPA']*70
}

function computeWidth(d, i) {
    return 20 
}

function computeY(d, i) {
    return 400-d['AvgGPA']*70
}

function computeColor(d, i) {
    return 'red'
}

var viz = _.map(avgList, function(d, i){
            return {
                x: computeX(d, i),
                y: computeY(d, i),
                height: computeHeight(d, i),
                width: computeWidth(d, i),
                color: computeColor(d, i),
                label: d
            }
         })
console.log(viz)

var result = _.map(viz, function(d){
         // invoke the compiled template function on each viz data
         return template({d: d})
     })
return result.join('\n')

Console

[{"name":"AS","AvgGPA":3.071482854494906},{"name":"BU","AvgGPA":2.925052910052912},{"name":"EB","AvgGPA":3.638129496402879},{"name":"EN","AvgGPA":3.2523560209424094},{"name":"GR","AvgGPA":3.575686274509805},{"name":"JR","AvgGPA":3.3846875},{"name":"LW","AvgGPA":2.898863636363637},{"name":"MB","AvgGPA":3.5109543568464714},{"name":"XX","AvgGPA":3.688999999999999},{"name":"undefined","AvgGPA":3.2900000000000005},{"name":"AP","AvgGPA":3.2881666666666667}]

[{"x":0,"y":184.99620018535657,"height":215.00379981464343,"width":20,"color":"red","label":{"name":"AS","AvgGPA":3.071482854494906}},{"x":50,"y":195.24629629629615,"height":204.75370370370385,"width":20,"color":"red","label":{"name":"BU","AvgGPA":2.925052910052912}},{"x":100,"y":145.33093525179848,"height":254.66906474820152,"width":20,"color":"red","label":{"name":"EB","AvgGPA":3.638129496402879}},{"x":150,"y":172.33507853403134,"height":227.66492146596866,"width":20,"color":"red","label":{"name":"EN","AvgGPA":3.2523560209424094}},{"x":200,"y":149.70196078431366,"height":250.29803921568634,"width":20,"color":"red","label":{"name":"GR","AvgGPA":3.575686274509805}},{"x":250,"y":163.071875,"height":236.928125,"width":20,"color":"red","label":{"name":"JR","AvgGPA":3.3846875}},{"x":300,"y":197.0795454545454,"height":202.9204545454546,"width":20,"color":"red","label":{"name":"LW","AvgGPA":2.898863636363637}},{"x":350,"y":154.233195020747,"height":245.766804979253,"width":20,"color":"red","label":{"name":"MB","AvgGPA":3.5109543568464714}},{"x":400,"y":141.77000000000004,"height":258.22999999999996,"width":20,"color":"red","label":{"name":"XX","AvgGPA":3.688999999999999}},{"x":450,"y":169.69999999999996,"height":230.30000000000004,"width":20,"color":"red","label":{"name":"undefined","AvgGPA":3.2900000000000005}},{"x":500,"y":169.82833333333332,"height":230.17166666666668,"width":20,"color":"red","label":{"name":"AP","AvgGPA":3.2881666666666667}}]

What's the average instructors' grading across CS department?[top]

Viz

<rect x="0"
      y="0"
      height="8"
      width="159.39999999999998"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="167.39999999999998" y="10" font-size="10">
    LEWIS, CLAYTON H
</text>
<rect x="0"
      y="10"
      height="8"
      width="187.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="195.5" y="20" font-size="10">
    LAMARCHE, JEFFREY STEVEN
</text>
<rect x="0"
      y="20"
      height="8"
      width="236.99999999999997"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="244.99999999999997" y="30" font-size="10">
    HOENIGMAN, RHONDA OLCOTT
</text>
<rect x="0"
      y="30"
      height="8"
      width="244.50000000000003"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="252.50000000000003" y="40" font-size="10">
    WHITE, ELIZABETH K.
</text>
<rect x="0"
      y="40"
      height="8"
      width="244.50000000000003"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="252.50000000000003" y="50" font-size="10">
    HAN, RICHARD YEHWHEI
</text>
<rect x="0"
      y="50"
      height="8"
      width="230.16666666666669"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="238.16666666666669" y="60" font-size="10">
    JESSUP, ELIZABETH R
</text>
<rect x="0"
      y="60"
      height="8"
      width="286.3333333333333"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="294.3333333333333" y="70" font-size="10">
    BLACK, JOHN
</text>
<rect x="0"
      y="70"
      height="8"
      width="122.50000000000001"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="130.5" y="80" font-size="10">
    BAKER, JAMES EDWARD
</text>
<rect x="0"
      y="80"
      height="8"
      width="141.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="149.5" y="90" font-size="10">
    MCBURNETT, NEAL
</text>
<rect x="0"
      y="90"
      height="8"
      width="196.12500000000003"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="204.12500000000003" y="100" font-size="10">
    KING, ROGER A
</text>
<rect x="0"
      y="100"
      height="8"
      width="228.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="236.5" y="110" font-size="10">
    CORRELL, NICOLAUS J
</text>
<rect x="0"
      y="110"
      height="8"
      width="178.16666666666669"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="186.16666666666669" y="120" font-size="10">
    STAFFORD, JUDITH ALYCE
</text>
<rect x="0"
      y="120"
      height="8"
      width="287.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="295.5" y="130" font-size="10">
    DEHUS, MARK D
</text>
<rect x="0"
      y="130"
      height="8"
      width="277"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="285" y="140" font-size="10">
    SCHREUDER, WILLEM A
</text>
<rect x="0"
      y="140"
      height="8"
      width="226.75"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="234.75" y="150" font-size="10">
    GOLDBERG, DEBRA S
</text>
<rect x="0"
      y="150"
      height="8"
      width="236"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="244" y="160" font-size="10">
    HAUSER, THOMAS A
</text>
<rect x="0"
      y="160"
      height="8"
      width="254.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="262.5" y="170" font-size="10">
    YEH, PEI HSIU
</text>
<rect x="0"
      y="170"
      height="8"
      width="245.00000000000003"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="253.00000000000003" y="180" font-size="10">
    TUFO, HENRY
</text>
<rect x="0"
      y="180"
      height="8"
      width="250.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="258.5" y="190" font-size="10">
    CLAUSET, AARON JULIAN
</text>
<rect x="0"
      y="190"
      height="8"
      width="247.75"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="255.75" y="200" font-size="10">
    EHRENFEUCHT, ANDRZEJ
</text>
<rect x="0"
      y="200"
      height="8"
      width="241.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="249.5" y="210" font-size="10">
    CHANG, BOR-YUH EVAN
</text>
<rect x="0"
      y="210"
      height="8"
      width="283"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="291" y="220" font-size="10">
    SANKARANARAYANAN, SRIRAM
</text>
<rect x="0"
      y="220"
      height="8"
      width="245.83333333333334"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="253.83333333333334" y="230" font-size="10">
    MISHRA, SHIVAKANT
</text>
<rect x="0"
      y="230"
      height="8"
      width="255.50000000000003"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="263.5" y="240" font-size="10">
    MARTIN, JAMES H
</text>
<rect x="0"
      y="240"
      height="8"
      width="289.75"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="297.75" y="250" font-size="10">
    PALEN, LEYSIA A
</text>
<rect x="0"
      y="250"
      height="8"
      width="250.75000000000003"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="258.75" y="260" font-size="10">
    MOZER, MICHAEL C
</text>
<rect x="0"
      y="260"
      height="8"
      width="116.75"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="124.75" y="270" font-size="10">
    CACCAMISE, DONNA J
</text>
<rect x="0"
      y="270"
      height="8"
      width="254.25"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="262.25" y="280" font-size="10">
    BOESE, ELIZABETH SUGAR
</text>
<rect x="0"
      y="280"
      height="8"
      width="251.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="259.5" y="290" font-size="10">
    GRUNWALD, DIRK C
</text>
<rect x="0"
      y="290"
      height="8"
      width="138"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="146" y="300" font-size="10">
    OKOYE, IFEYINWA U.
</text>
<rect x="0"
      y="300"
      height="8"
      width="264"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="272" y="310" font-size="10">
    HUGHES, DANA THURSTON
</text>
<rect x="0"
      y="310"
      height="8"
      width="276"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="284" y="320" font-size="10">
    NIES, ZACH T
</text>
<rect x="0"
      y="320"
      height="8"
      width="176.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="184.5" y="330" font-size="10">
    WILDER, MATTHEW H.
</text>
<rect x="0"
      y="330"
      height="8"
      width="231.5"
      style="fill:teal;
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="239.5" y="340" font-size="10">
    WAGER, TOR DESSART
</text>

Solution: SVG Template

<rect x="${d.x}"
      y="${d.y}"
      height="${d.height}"
      width="${d.width}"
      style="fill:${d.color};
             stroke-width:1;
             stroke:rgb(0,0,0)" />
<text x="${d.width + 8}" y="${d.y + 10}" font-size="10">
    ${d.label}
</text>

Solution: Javascript

var list=_.filter(data, function(e){
    return e['Subject'] == 'CSCI'
})
console.log(list)
var listInstructors = _.flatten(_.map(list, function(course){
  var instructors=course['Instructors']
  var avgGrd=course['AvgInstructor']
  return _.map(instructors, function(instructor){
    return {"instructor": instructor['name'], "avgGRD": avgGrd}
  })
})
)
var groups=_.groupBy(listInstructors, function(instructor){
    return instructor['instructor']
})
var avgGroups=_.mapValues(groups, function(group){
    return _.sum(group, function(course){
        return course['avgGRD']
    })/_.size(group)
})
var keys=_.keys(avgGroups)
var avgList=_.map(keys, function(key){
    return {"name": key, "avgGRD": avgGroups[key]}
})
console.log(avgList)



function computeX(d, i) {
    return 0
}

function computeHeight(d, i) {
    return 8
}

function computeWidth(d, i) {
    return d.avgGRD *50
}

function computeY(d, i) {
    return 10 * i
}

function computeColor(d, i) {
    return 'teal'
}

function computeLabel(d, i) {
    return d.name
}

var viz = _.map(avgList, function(d, i){
            return {
                x: computeX(d, i),
                y: computeY(d, i),
                height: computeHeight(d, i),
                width: computeWidth(d, i),
                color: computeColor(d, i),
                label: computeLabel(d, i)
            }
         })
console.log(viz)

var result = _.map(viz, function(d){
         // invoke the compiled template function on each viz data
         return template({d: d})
     })
return result.join('\n')

Console

[{"AVG_GRD":3.37,"Activity_Type":"LEC - Lecture","AvgCourse":3.78,"AvgInstructor":5.02,"Course":"1000","CourseTitle":"Computer Science as a Field of Work and Study","CrsLvlNum":"1XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":1,"Instruction_Mode":"P - In Person","Level":"Lower","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":81,"EOT":75,"GRADE":75,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":50},"PCT":{"A":0.71,"B":0.15,"C":0.07,"C_MINUS_OR_BELOW":0.12,"D":0.01,"DF":0.08,"F":0.07,"GRADE":1,"INCOMP":0,"WDRAW":0.07},"RAP":"0","Section":"001","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"0-3","Raw":"1.15"},"YearTerm":"20137","Instructors":[{"group":"1 TTT","name":"LEWIS, CLAYTON H","title":"PROFESSOR"}]},{"AVG_GRD":2.42,"Activity_Type":"LEC - Lecture","AvgCourse":3.8,"AvgInstructor":3.75,"Course":"1300","CourseTitle":"Computer Science 1: Starting Computing","CrsLvlNum":"1XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":4,"Instruction_Mode":"P - In Person","Level":"Lower","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":148,"EOT":128,"GRADE":126,"INCOMP":2,"NOCRED":0,"PASS":0,"Ret":85},"PCT":{"A":0.31,"B":0.27,"C":0.18,"C_MINUS_OR_BELOW":0.31,"D":0.09,"DF":0.24,"F":0.15,"GRADE":0.98,"INCOMP":0.02,"WDRAW":0.14},"RAP":"0","Section":"010","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"3.30"},"YearTerm":"20137","Instructors":[{"group":"4 TA Cred","name":"LAMARCHE, JEFFREY STEVEN","title":"GRAD PART-TIME INSTRUCTOR"}]},{"AVG_GRD":2.89,"Activity_Type":"LEC - Lecture","AvgCourse":4.77,"AvgInstructor":4.77,"Course":"1300","CourseTitle":"Computer Science 1: Starting Computing","CrsLvlNum":"1XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":4,"Instruction_Mode":"P - In Person","Level":"Lower","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":355,"EOT":332,"GRADE":331,"INCOMP":1,"NOCRED":0,"PASS":0,"Ret":174},"PCT":{"A":0.47,"B":0.23,"C":0.15,"C_MINUS_OR_BELOW":0.2,"D":0.07,"DF":0.16,"F":0.09,"GRADE":1,"INCOMP":0,"WDRAW":0.06},"RAP":"0","Section":"100","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"2.78"},"YearTerm":"20137","Instructors":[{"group":"2 Other reg","name":"HOENIGMAN, RHONDA OLCOTT","title":"INSTRUCTOR"}]},{"AVG_GRD":3.01,"Activity_Type":"LEC - Lecture","AvgCourse":4.91,"AvgInstructor":5.14,"Course":"2270","CourseTitle":"Computer Science 2: Data Structures","CrsLvlNum":"2XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":4,"Instruction_Mode":"P - In Person","Level":"Lower","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":85,"EOT":73,"GRADE":73,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":43},"PCT":{"A":0.45,"B":0.29,"C":0.15,"C_MINUS_OR_BELOW":0.15,"D":0.05,"DF":0.11,"F":0.05,"GRADE":1,"INCOMP":0,"WDRAW":0.14},"RAP":"0","Section":"010","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"10-12","Raw":"3.82"},"YearTerm":"20137","Instructors":[{"group":"2 Other reg","name":"WHITE, ELIZABETH K.","title":"INSTRUCTOR"}]},{"AVG_GRD":2.96,"Activity_Type":"LEC - Lecture","AvgCourse":4.77,"AvgInstructor":4.94,"Course":"2270","CourseTitle":"Computer Science 2: Data Structures","CrsLvlNum":"2XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":4,"Instruction_Mode":"P - In Person","Level":"Lower","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":112,"EOT":103,"GRADE":102,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":69},"PCT":{"A":0.42,"B":0.29,"C":0.2,"C_MINUS_OR_BELOW":0.15,"D":0.02,"DF":0.09,"F":0.07,"GRADE":0.99,"INCOMP":0,"WDRAW":0.08},"RAP":"0","Section":"100","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"3.47"},"YearTerm":"20137","Instructors":[{"group":"2 Other reg","name":"WHITE, ELIZABETH K.","title":"INSTRUCTOR"}]},{"AVG_GRD":2.87,"Activity_Type":"LEC - Lecture","AvgCourse":4.2,"AvgInstructor":4.19,"Course":"2400","CourseTitle":"Computer Systems","CrsLvlNum":"2XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":4,"Instruction_Mode":"P - In Person","Level":"Lower","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":135,"EOT":128,"GRADE":127,"INCOMP":1,"NOCRED":0,"PASS":0,"Ret":83},"PCT":{"A":0.24,"B":0.5,"C":0.2,"C_MINUS_OR_BELOW":0.08,"D":0.03,"DF":0.06,"F":0.03,"GRADE":0.99,"INCOMP":0.01,"WDRAW":0.05},"RAP":"0","Section":"010","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"10-12","Raw":"3.87"},"YearTerm":"20137","Instructors":[{"group":"1 TTT","name":"HAN, RICHARD YEHWHEI","title":"ASSOCIATE PROFESSOR"}]},{"AVG_GRD":3,"Activity_Type":"LEC - Lecture","AvgCourse":3.31,"AvgInstructor":3.17,"Course":"2820","CourseTitle":"Linear Algebra with Computer Science Applications","CrsLvlNum":"2XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Lower","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":48,"EOT":46,"GRADE":46,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":36},"PCT":{"A":0.35,"B":0.43,"C":0.13,"C_MINUS_OR_BELOW":0.11,"D":0.07,"DF":0.09,"F":0.02,"GRADE":1,"INCOMP":0,"WDRAW":0.04},"RAP":"0","Section":"001","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"2.63"},"YearTerm":"20137","Instructors":[{"group":"1 TTT","name":"JESSUP, ELIZABETH R","title":"PROFESSOR"}]},{"AVG_GRD":3.56,"Activity_Type":"LEC - Lecture","AvgCourse":3.68,"AvgInstructor":3.93,"Course":"2824","CourseTitle":"Discrete Structures","CrsLvlNum":"2XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Lower","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":104,"EOT":101,"GRADE":100,"INCOMP":1,"NOCRED":0,"PASS":0,"Ret":76},"PCT":{"A":0.71,"B":0.21,"C":0.05,"C_MINUS_OR_BELOW":0.03,"D":0.01,"DF":0.03,"F":0.02,"GRADE":0.99,"INCOMP":0.01,"WDRAW":0.03},"RAP":"0","Section":"001","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"4-6","Raw":"2.01"},"YearTerm":"20137","Instructors":[{"group":"2 Other reg","name":"HOENIGMAN, RHONDA OLCOTT","title":"INSTRUCTOR"}]},{"AVG_GRD":3.43,"Activity_Type":"LEC - Lecture","AvgCourse":5.46,"AvgInstructor":5.77,"Course":"3104","CourseTitle":"Algorithms","CrsLvlNum":"3XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":4,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":67,"EOT":63,"GRADE":63,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":52},"PCT":{"A":0.54,"B":0.38,"C":0.06,"C_MINUS_OR_BELOW":0.02,"D":0,"DF":0.02,"F":0.02,"GRADE":1,"INCOMP":0,"WDRAW":0.06},"RAP":"0","Section":"010","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"2.89"},"YearTerm":"20137","Instructors":[{"group":"1 TTT","name":"BLACK, JOHN","title":"ASSOCIATE PROFESSOR"}]},{"AVG_GRD":3.64,"Activity_Type":"PRA - Practicum","Course":"3112","CourseTitle":"Human-Centered Computing Professional Development","CrsLvlNum":"3XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":1,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":1,"NIntrFCQ":"","N":{"ENROLL":57,"EOT":56,"GRADE":56,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":""},"PCT":{"A":0.79,"B":0.18,"C":0.02,"C_MINUS_OR_BELOW":0.04,"D":0,"DF":0.02,"F":0.02,"GRADE":1,"INCOMP":0,"WDRAW":0.02},"RAP":"1","Section":"801","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"","Raw":""},"YearTerm":"20137","Instructors":[{"group":"1 TTT","name":"LEWIS, CLAYTON H","title":"PROFESSOR"}]},{"AVG_GRD":3.36,"Activity_Type":"LEC - Lecture","AvgCourse":2.55,"AvgInstructor":2.45,"Course":"3155","CourseTitle":"Principles of Programming Languages","CrsLvlNum":"3XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":4,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":73,"EOT":69,"GRADE":69,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":44},"PCT":{"A":0.57,"B":0.33,"C":0.07,"C_MINUS_OR_BELOW":0.06,"D":0,"DF":0.03,"F":0.03,"GRADE":1,"INCOMP":0,"WDRAW":0.05},"RAP":"0","Section":"010","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"3.40"},"YearTerm":"20137","Instructors":[{"group":"3 Supp","name":"BAKER, JAMES EDWARD","title":"LECTURER"}]},{"AVG_GRD":3.78,"Activity_Type":"LEC - Lecture","AvgCourse":3.34,"AvgInstructor":2.83,"Course":"3202","CourseTitle":"Introduction to Artificial Intelligence","CrsLvlNum":"3XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":72,"EOT":70,"GRADE":70,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":29},"PCT":{"A":0.89,"B":0.06,"C":0.03,"C_MINUS_OR_BELOW":0.04,"D":0.01,"DF":0.03,"F":0.01,"GRADE":1,"INCOMP":0,"WDRAW":0.03},"RAP":"0","Section":"001","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"2.86"},"YearTerm":"20137","Instructors":[{"group":"3 Supp","name":"MCBURNETT, NEAL","title":"LECTURER"}]},{"AVG_GRD":3.22,"Activity_Type":"LEC - Lecture","AvgCourse":2.55,"AvgInstructor":2.73,"Course":"3287","CourseTitle":"Database and Information Systems","CrsLvlNum":"3XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":2,"NIntrFCQ":1,"N":{"ENROLL":69,"EOT":68,"GRADE":65,"INCOMP":3,"NOCRED":0,"PASS":0,"Ret":11},"PCT":{"A":0.38,"B":0.48,"C":0.12,"C_MINUS_OR_BELOW":0.02,"D":0,"DF":0.02,"F":0.02,"GRADE":0.96,"INCOMP":0.04,"WDRAW":0.01},"RAP":"0","Section":"001","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"4-6","Raw":"1.73"},"YearTerm":"20137","Instructors":[{"group":"1 TTT","name":"KING, ROGER A","title":"PROFESSOR"}]},{"AVG_GRD":3.44,"Activity_Type":"LEC - Lecture","AvgCourse":4.57,"AvgInstructor":4.57,"Course":"3302","CourseTitle":"Introduction to Robotics","CrsLvlNum":"3XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":2,"NIntrFCQ":1,"N":{"ENROLL":18,"EOT":17,"GRADE":17,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":14},"PCT":{"A":0.65,"B":0.29,"C":0,"C_MINUS_OR_BELOW":0.06,"D":0,"DF":0.06,"F":0.06,"GRADE":1,"INCOMP":0,"WDRAW":0.04},"RAP":"0","Section":"010","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"2.92"},"YearTerm":"20137","Instructors":[{"group":"1 TTT","name":"CORRELL, NICOLAUS J","title":"ASST PROFESSOR"}]},{"AVG_GRD":3.28,"Activity_Type":"LEC - Lecture","AvgCourse":3.12,"AvgInstructor":3.12,"Course":"3308","CourseTitle":"Software Engineering Methods and Tools","CrsLvlNum":"3XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":122,"EOT":120,"GRADE":119,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":77},"PCT":{"A":0.45,"B":0.45,"C":0.1,"C_MINUS_OR_BELOW":0.03,"D":0,"DF":0.01,"F":0.01,"GRADE":0.99,"INCOMP":0,"WDRAW":0.02},"RAP":"0","Section":"010","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"3.41"},"YearTerm":"20137","Instructors":[{"group":"2 Other reg","name":"STAFFORD, JUDITH ALYCE","title":"SENIOR INSTRUCTOR"}]},{"AVG_GRD":3.34,"Activity_Type":"LEC - Lecture","AvgCourse":5.43,"AvgInstructor":5.75,"Course":"4113","CourseTitle":"Unix System Administration","CrsLvlNum":"4XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":2,"NIntrFCQ":1,"N":{"ENROLL":35,"EOT":34,"GRADE":34,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":28},"PCT":{"A":0.71,"B":0.12,"C":0.09,"C_MINUS_OR_BELOW":0.12,"D":0,"DF":0.09,"F":0.09,"GRADE":1,"INCOMP":0,"WDRAW":0.03},"RAP":"0","Section":"001","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"10-12","Raw":"3.65"},"YearTerm":"20137","Instructors":[{"group":"2 Other reg","name":"DEHUS, MARK D","title":"INSTRUCTOR"}]},{"AVG_GRD":3.75,"Activity_Type":"LEC - Lecture","AvgCourse":5.21,"AvgInstructor":5.46,"Course":"4229","CourseTitle":"Computer Graphics","CrsLvlNum":"4XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":2,"NIntrFCQ":1,"N":{"ENROLL":78,"EOT":78,"GRADE":78,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":48},"PCT":{"A":0.87,"B":0.08,"C":0.03,"C_MINUS_OR_BELOW":0.03,"D":0.01,"DF":0.03,"F":0.01,"GRADE":1,"INCOMP":0,"WDRAW":0},"RAP":"0","Section":"001","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"10-12","Raw":"3.77"},"YearTerm":"20137","Instructors":[{"group":"3 Supp","name":"SCHREUDER, WILLEM A","title":"ASST PROFESSOR ADJUNCT"}]},{"AVG_GRD":3.15,"Activity_Type":"LEC - Lecture","AvgCourse":4.84,"AvgInstructor":4.96,"Course":"4273","CourseTitle":"Network Systems","CrsLvlNum":"4XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":3,"NIntrFCQ":1,"N":{"ENROLL":71,"EOT":69,"GRADE":68,"INCOMP":1,"NOCRED":0,"PASS":0,"Ret":25},"PCT":{"A":0.35,"B":0.44,"C":0.19,"C_MINUS_OR_BELOW":0.03,"D":0.01,"DF":0.01,"F":0,"GRADE":0.99,"INCOMP":0.01,"WDRAW":0.03},"RAP":"0","Section":"001","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"10-12","Raw":"4.21"},"YearTerm":"20137","Instructors":[{"group":"1 TTT","name":"HAN, RICHARD YEHWHEI","title":"ASSOCIATE PROFESSOR"}]},{"AVG_GRD":3.63,"Activity_Type":"LEC - Lecture","AvgCourse":4.11,"AvgInstructor":3.84,"Course":"4308","CourseTitle":"Software Engineering Project 1","CrsLvlNum":"4XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":4,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":1,"NIntrFCQ":1,"N":{"ENROLL":71,"EOT":71,"GRADE":71,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":37},"PCT":{"A":0.7,"B":0.28,"C":0,"C_MINUS_OR_BELOW":0.01,"D":0.01,"DF":0.01,"F":0,"GRADE":1,"INCOMP":0,"WDRAW":0},"RAP":"0","Section":"010","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"10-12","Raw":"3.54"},"YearTerm":"20137","Instructors":[{"group":"2 Other reg","name":"STAFFORD, JUDITH ALYCE","title":"SENIOR INSTRUCTOR"}]},{"AVG_GRD":3.82,"Activity_Type":"LEC - Lecture","AvgCourse":3.8,"AvgInstructor":4.37,"Course":"4314","CourseTitle":"Algorithms for Molecular Biology","CrsLvlNum":"4XXX","CrsPBAColl":"EN","CrsPBADept":"CSCI","Honors":"0","Hours":3,"Instruction_Mode":"P - In Person","Level":"Upper","NComb":5,"NIntrFCQ":1,"N":{"ENROLL":39,"EOT":37,"GRADE":37,"INCOMP":0,"NOCRED":0,"PASS":0,"Ret":30},"PCT":{"A":0.89,"B":0.08,"C":0.03,"C_MINUS_OR_BELOW":0,"D":0,"DF":0,"F":0,"GRADE":1,"INCOMP":0,"WDRAW":0.05},"RAP":"0","Section":"001","Subject":"CSCI","Subject_Label":"Computer Science","Workload":{"Hrs_Wk":"7-9","Raw":"2.85"},"YearTerm":"20137","Instructors":[{"group":"1 TTT","name":"GOLDBERG, DEBRA S","title":"ASST PROFESSOR"}]},"... 43 more"]

[{"name":"LEWIS, CLAYTON H","avgGRD":3.1879999999999997},{"name":"LAMARCHE, JEFFREY STEVEN","avgGRD":3.75},{"name":"HOENIGMAN, RHONDA OLCOTT","avgGRD":4.739999999999999},{"name":"WHITE, ELIZABETH K.","avgGRD":4.890000000000001},{"name":"HAN, RICHARD YEHWHEI","avgGRD":4.890000000000001},{"name":"JESSUP, ELIZABETH R","avgGRD":4.6033333333333335},{"name":"BLACK, JOHN","avgGRD":5.726666666666667},{"name":"BAKER, JAMES EDWARD","avgGRD":2.45},{"name":"MCBURNETT, NEAL","avgGRD":2.83},{"name":"KING, ROGER A","avgGRD":3.9225000000000003},{"name":"CORRELL, NICOLAUS J","avgGRD":4.57},{"name":"STAFFORD, JUDITH ALYCE","avgGRD":3.563333333333334},{"name":"DEHUS, MARK D","avgGRD":5.75},{"name":"SCHREUDER, WILLEM A","avgGRD":5.54},{"name":"GOLDBERG, DEBRA S","avgGRD":4.535},{"name":"HAUSER, THOMAS A","avgGRD":4.72},{"name":"YEH, PEI HSIU","avgGRD":5.09},{"name":"TUFO, HENRY","avgGRD":4.9},{"name":"CLAUSET, AARON JULIAN","avgGRD":5.01},{"name":"EHRENFEUCHT, ANDRZEJ","avgGRD":4.955},"... 14 more"]

[{"x":0,"y":0,"height":8,"width":159.39999999999998,"color":"teal","label":"LEWIS, CLAYTON H"},{"x":0,"y":10,"height":8,"width":187.5,"color":"teal","label":"LAMARCHE, JEFFREY STEVEN"},{"x":0,"y":20,"height":8,"width":236.99999999999997,"color":"teal","label":"HOENIGMAN, RHONDA OLCOTT"},{"x":0,"y":30,"height":8,"width":244.50000000000003,"color":"teal","label":"WHITE, ELIZABETH K."},{"x":0,"y":40,"height":8,"width":244.50000000000003,"color":"teal","label":"HAN, RICHARD YEHWHEI"},{"x":0,"y":50,"height":8,"width":230.16666666666669,"color":"teal","label":"JESSUP, ELIZABETH R"},{"x":0,"y":60,"height":8,"width":286.3333333333333,"color":"teal","label":"BLACK, JOHN"},{"x":0,"y":70,"height":8,"width":122.50000000000001,"color":"teal","label":"BAKER, JAMES EDWARD"},{"x":0,"y":80,"height":8,"width":141.5,"color":"teal","label":"MCBURNETT, NEAL"},{"x":0,"y":90,"height":8,"width":196.12500000000003,"color":"teal","label":"KING, ROGER A"},{"x":0,"y":100,"height":8,"width":228.5,"color":"teal","label":"CORRELL, NICOLAUS J"},{"x":0,"y":110,"height":8,"width":178.16666666666669,"color":"teal","label":"STAFFORD, JUDITH ALYCE"},{"x":0,"y":120,"height":8,"width":287.5,"color":"teal","label":"DEHUS, MARK D"},{"x":0,"y":130,"height":8,"width":277,"color":"teal","label":"SCHREUDER, WILLEM A"},{"x":0,"y":140,"height":8,"width":226.75,"color":"teal","label":"GOLDBERG, DEBRA S"},{"x":0,"y":150,"height":8,"width":236,"color":"teal","label":"HAUSER, THOMAS A"},{"x":0,"y":160,"height":8,"width":254.5,"color":"teal","label":"YEH, PEI HSIU"},{"x":0,"y":170,"height":8,"width":245.00000000000003,"color":"teal","label":"TUFO, HENRY"},{"x":0,"y":180,"height":8,"width":250.5,"color":"teal","label":"CLAUSET, AARON JULIAN"},{"x":0,"y":190,"height":8,"width":247.75,"color":"teal","label":"EHRENFEUCHT, ANDRZEJ"},"... 14 more"]

Use the warmup exercise as the template to produce an answer here. Remove this question if you work as a unit of two.