As a class, we brainstormed and came up with a long list of further questions we can ask based on the FCQ data. Out of these questions, our team chose to tackle on the following questions. Each member on our team is reponsible for one question.
var grps = _.groupBy(data, function(c){return c.Subject})
var grades = _.mapValues(grps, function(grp){return _.compact(_.pluck(grp, 'AVG_GRD'))})
var grades = _.mapValues(grades, function(group){
var total = 0
_.map(group, function(n){
//console.log()
total += n
return total
}
)
return total/(_.size(group))})
grades = _.map(grades, function(value, key){
return {"subject": key, "grade":value}})
return _.sortBy(grades, "grade").reverse()[
{
"subject": "CSVC",
"grade": null
},
{
"subject": "TMUS",
"grade": null
},
{
"subject": "CONV",
"grade": null
},
{
"subject": "MUSM",
"grade": 3.946
},
{
"subject": "EMUS",
"grade": 3.923809523809524
},
{
"subject": "KREN",
"grade": 3.9166666666666665
},
{
"subject": "EHON",
"grade": 3.8840000000000003
},
{
"subject": "HONR",
"grade": 3.8329999999999997
},
{
"subject": "EDUC",
"grade": 3.773880597014925
},
{
"subject": "FRSI",
"grade": 3.75
},
{
"subject": "PRLC",
"grade": 3.75
},
{
"subject": "PMUS",
"grade": 3.7189285714285716
},
{
"subject": "MILR",
"grade": 3.715555555555556
},
{
"subject": "AIRR",
"grade": 3.6816666666666666
},
{
"subject": "INVS",
"grade": 3.6772727272727277
},
{
"subject": "NAVR",
"grade": 3.6722222222222225
},
{
"subject": "EVEN",
"grade": 3.665
},
{
"subject": "TLEN",
"grade": 3.657916666666667
},
{
"subject": "EMEN",
"grade": 3.6478260869565218
},
{
"subject": "HUEN",
"grade": 3.6348648648648645
},
{
"subject": "BADM",
"grade": 3.597
},
{
"subject": "MBAX",
"grade": 3.5700000000000003
},
{
"subject": "CWCV",
"grade": 3.57
},
{
"subject": "DNCE",
"grade": 3.566612903225807
},
{
"subject": "ATLS",
"grade": 3.535681818181818
},
{
"subject": "ARTS",
"grade": 3.5344230769230762
},
{
"subject": "RSEI",
"grade": 3.5300000000000002
},
{
"subject": "GEEN",
"grade": 3.504761904761904
},
{
"subject": "ASEN",
"grade": 3.4920833333333348
},
{
"subject": "MUSC",
"grade": 3.473297872340425
},
{
"subject": "CVEN",
"grade": 3.4629870129870133
},
{
"subject": "CSCI",
"grade": 3.459206349206347
},
{
"subject": "ENVS",
"grade": 3.4509999999999996
},
{
"subject": "ARSC",
"grade": 3.42875
},
{
"subject": "LDSP",
"grade": 3.4250000000000003
},
{
"subject": "SLHS",
"grade": 3.406857142857143
},
{
"subject": "LING",
"grade": 3.4019354838709677
},
{
"subject": "LAWS",
"grade": 3.4013333333333327
},
{
"subject": "CESR",
"grade": 3.3971428571428572
},
{
"subject": "GSAP",
"grade": 3.393333333333333
},
{
"subject": "JOUR",
"grade": 3.384687499999998
},
{
"subject": "FILM",
"grade": 3.3837499999999987
},
{
"subject": "ENGL",
"grade": 3.381199999999998
},
{
"subject": "HEBR",
"grade": 3.3720000000000008
},
{
"subject": "LEAD",
"grade": 3.36
},
{
"subject": "ETHN",
"grade": 3.359545454545455
},
{
"subject": "COMR",
"grade": 3.356666666666667
},
{
"subject": "ENVD",
"grade": 3.3503448275862073
},
{
"subject": "NRSC",
"grade": 3.346470588235294
},
{
"subject": "ATOC",
"grade": 3.334000000000001
},
{
"subject": "MCDB",
"grade": 3.332346938775511
},
{
"subject": "MUEL",
"grade": 3.3315909090909104
},
{
"subject": "LIBB",
"grade": 3.3200000000000003
},
{
"subject": "THTR",
"grade": 3.314242424242425
},
{
"subject": "NRLN",
"grade": 3.31
},
{
"subject": "MBAC",
"grade": 3.308333333333333
},
{
"subject": "AREN",
"grade": 3.30695652173913
},
{
"subject": "MGMT",
"grade": 3.2863157894736834
},
{
"subject": "MCEN",
"grade": 3.283908045977012
},
{
"subject": "IAFS",
"grade": 3.2694999999999994
},
{
"subject": "FARR",
"grade": 3.2638461538461536
},
{
"subject": "JPNS",
"grade": 3.261875
},
{
"subject": "BAKR",
"grade": 3.2566666666666664
},
{
"subject": "WRTG",
"grade": 3.2564179104477615
},
{
"subject": "CHEN",
"grade": 3.252083333333333
},
{
"subject": "CLAS",
"grade": 3.2325925925925922
},
{
"subject": "HUMN",
"grade": 3.215882352941177
},
{
"subject": "CHIN",
"grade": 3.214
},
{
"subject": "BSLW",
"grade": 3.2100000000000004
},
{
"subject": "ARTH",
"grade": 3.2061538461538457
},
{
"subject": "HIND",
"grade": 3.2
},
{
"subject": "GEOG",
"grade": 3.1867857142857132
},
{
"subject": "ECEN",
"grade": 3.1852238805970154
},
{
"subject": "ANTH",
"grade": 3.1845283018867936
},
{
"subject": "FREN",
"grade": 3.1663333333333328
},
{
"subject": "RLST",
"grade": 3.161666666666667
},
{
"subject": "RUSS",
"grade": 3.1587499999999995
},
{
"subject": "ASTR",
"grade": 3.154347826086956
},
{
"subject": "GEOL",
"grade": 3.1308108108108113
},
{
"subject": "WMST",
"grade": 3.1286206896551736
},
{
"subject": "ARAB",
"grade": 3.128
},
{
"subject": "SEWL",
"grade": 3.1199999999999997
},
{
"subject": "PSYC",
"grade": 3.113559322033898
},
{
"subject": "ESBM",
"grade": 3.110416666666666
},
{
"subject": "PACS",
"grade": 3.1075
},
{
"subject": "PSCI",
"grade": 3.106752136752137
},
{
"subject": "REAL",
"grade": 3.102727272727273
},
{
"subject": "SPAN",
"grade": 3.0959259259259273
},
{
"subject": "HIST",
"grade": 3.090897435897436
},
{
"subject": "EBIO",
"grade": 3.058318584070797
},
{
"subject": "MKTG",
"grade": 3
If the professor has a rating less than two standard deviations away, he's not a good one.
var professors = _.chain(data)
.map(function(obj) {
return _.map(obj.Instructors, function(inst) {
return {"name": inst.name,
"rating": obj.AvgInstructor}
})
}).flatten()
.filter(function(obj) {
return obj.rating;
})
.value();
var rating_avg = _.reduce(professors, function(p, n) {
return (p + n.rating);
}, 0) / professors.length;
var rating_stddev = Math.sqrt(_.reduce(professors, function(p, n) {
return (p + Math.pow(n.rating - rating_avg, 2));
}, 0) / professors.length);
return [rating_avg, rating_stddev,
_.chain(professors)
.filter(function(obj) {
return (obj.rating < (rating_avg - (2 * rating_stddev)));
}).map(function(obj) {
return obj.name + ", " + obj.rating.toString();
}).uniq()
.value()];[ "BEKOFF, ANNE C, 2.83", "GRABOWSKI, ALENA MARIE, 3.63", "BAOUCHI, ABDEL WAHAB, 3.59", "DOUTHITT, CAMERON BENNETT, 1.94", "ANGEL, EITAN M, 3.8", "ANGEL, EITAN M, 3.7", "ROY, MICHAEL D, 3.27", "ROY, MICHAEL D, 2.94", "LIU, FAAN TONE, 3.62", "LIU, FAAN TONE, 3.59", "LIU, FAAN TONE, 3.82", "SPINA, ALEJANDRO, 3.82", "HENRY, SHAWN JEREMY, 2.67", "FARSI, CARLA, 2.67", "GUSTAFSON, KARL E, 2.56", "MONK, JAMES DONALD, 2.21", "SPINA, ALEJANDRO, 2.74", "ELLIS, HOMER G, 2.69", "SARRIA, ALEJANDRO, 2.69", "KUZNETSOV, SERGEI EUGENIEVITCH, 2.23", "FOX, JEFFREY S, 2.23", "MUIR, CARRIE BESS, 3.7", "FARSI, CARLA, 3.18", "SHI, JIA, 3.33", "KRAUTER, KENNETH S, 3.81", "TOOLEY, MICHAEL, 3.84", "HUEMER, MICHAEL, 3.36", "BETTERTON, MEREDITH D, 3.53", "LEE, MINHYEA, 3.53", "KEMPF, SASCHA, 2.75", "ANDERSON, DANA Z, 3.26", "RASCHKE, MARKUS B, 3.8", "BAIRD, VANESSA ANNE, 3.29", "RICHARDSON, LINDSEY, 3.72", "RICHARDSON, LINDSEY, 3.55", "HINK, GARY M, 2.1", "KUNCE, CATHERINE, 3.38", "CHARTERIS, FRANCES, 3.6", "RACHEL, NAOMI R, 2.43", "HINK, GARY M, 3", "HINK, GARY M, 2.09", "DUPLER, DOUGLAS J., 3.61", "ADAMS, SHARON MAR, 3.36", "RAMSBERGER, GAIL, 3.09", "MOORE, SUSAN M, 3.71", "YOSHINAGA-ITANO, CHRISTINE, 2.55", "MOJOLA, SANYU AMIMO, 3.63", "HAWKINS, LAURIE E., 3.65", "GODFREY, ALTHEA ELAINE, 3.84", "ZAHROUNI, RAFIKA, 3.37", "KEOGH, XIMENA L., 3.65", "HERBOZO DUARTE, JOSE MIGUEL, 3.58", "DABNEY, KAREN MICHELLE, 3.6", "HALL, RENEE ARLENE, 3.85", "CLARK, LISA A, 2.89", "MADIGAN, GERALD JOSEPH, 3.67", "MADIGAN, GERALD JOSEPH, 3.85", "MADIGAN, GERALD JOSEPH, 3.36", "STUTZER, MICHAEL J., 3.58", "URROZ-KORORI, SOUSAN, 3.35", "WENGER, PAULA, 3.34", "AGNEW, DAVID B, 3.57", "PLATIKANOVA-GROSS, KREMENA STOEVA, 2.89", "PLATIKANOVA-GROSS, KREMENA STOEVA, 2.63", "PLATIKANOVA-GROSS, KREMENA STOEVA, 3.85", "WILLIAMS, LAWRENCE EDWIN, 3.83", "HOTCHKISS, JACQUELINE SUZANNE, 3.53", "WHITCOMB, JENNIFER A, 3.25", "TAYLOR, EDWARD VINCENT, 3.25", "BACA, ROSALINDA L, 2.94", "BIRINGEN, SEDAT, 3.58", "EMERY, WILLIAM J, 3.58", "NAGPAL, PRASHANT, 3.54", "YOUNG, WENDY MORES, 3.8", "LAMARCHE, JEFFREY STEVEN, 3.75", "JESSUP, ELIZABETH R, 3.17", "BAKER, JAMES EDWARD, 2.45", "MCBURNETT, NEAL, 2.83", "KING, ROGER A, 2.73", "STAFFORD, JUDITH ALYCE, 3.12", "STAFFORD, JUDITH ALYCE, 3.84", "PAO, LUCY Y, 3.85", "MATHYS, PETER, 3.28", "HAUSER, JOHN, 3.28", "MATHYS, PETER, 3.5", "PLESZKUN, ANDREW R, 3.5", "GASIEWSKI, ALBIN J., 3.67", "STITES, NICK A., 3.65", "MONTOYA, LUPITA DEL CARMEN, 3.73", "ENNIS, TANYA, 3.83", "HANNIGAN, MICHAEL P., 3.04", "BORDEN, MARK A, 3.85", "RUBEN, SHALOM D, 3.55", "WANG, BINGLIAN, 3.2", "KUSTAS, FRANK M, 3.75", "HUSSEIN, MAHMOUD ISMAIL, 3.19", "PUTRI, ULLY DAMARI, 3.59", "MORITZ, MARGUERITE, 3.5", "WEED, MICHAEL PRESTON, 2.8", "CHEN, MING HSU, 3.77", "MACK, NATALIE M, 3.64", "CALHOUN, EMILY M, 3.19", "STRICKLIN, CLIFFORD, 3.83", "SKAGGS, DAVID, 3.75", "FELLMAN, KENNETH S., 3.73", "SIMMONS, JAMES DAVID, 3.27", "MILLER, JEFFREY L, 3.44", "DEALWIS, MALKANTHI LISA, 3.15", "RENAUD, KENNETH JOSEPH, 3.8", "KAMBIC, KATHLEEN NICOLE, 3.33", "MCCALL, RAYMOND, 3.67", "ALHADEFF, ALBERT, 3.85", "HENDERSON, RILEY MCDAVID, 3.56", "CHONG, ALBERT, 3.07", "GUTIERREZ, GERARDO, 2.43", "HUGHES, MIMI ROSE ABEL, 3.83", "CLARK, CHRISTINA OELFKE, 3.85", "NOONE, DAVID CHRISTOPHER, 2.84", "KOCH, TAD H, 2.25", "KOCH, TAD H, 3.8", "KOCH, TAD H, 3.64", "KOCH, TAD H, 3.82", "SKERSKI, JAMIE L, 1.92", "SKERSKI, JAMIE L, 3.25", "SKERSKI, JAMIE L, 3", "JACKSON, MICHELE HORNER, 2.74", "SZABO, AMANDA L, 3.85", "SZABO, AMANDA L, 3.83", "RHODES, MATTHEW ELLIOT, 3.79", "GRAVES, PHILIP E, 3.79", "ZHENG, TIANXIAO, 3.74", "LEE, SOOYOUNG, 3.85", "WALDMAN, DONALD M, 3.65", "KIM, JIN-HYUK, 3.65", "ROBERTSON, BENJAMIN JOHN, 3.53", "WRIGHT, NICOLE M, 3.5", "PEREZ, EMMA MARIE, 3.33", "SEGAL, SHIRA BAT AMI, 3.36", "CARTER, ROGER C., 2.89", "CARTER, ROGER C., 3.3", "AUSTIN, RACHEL E., 3.69", "PUGLIESE, ANNUNZIATA, 3.6", "GOLDMAN, MARA JILL, 3.06", "SKEETS, BREANNA ALISYA, 3.57", "CATES, NICOLE LISA, 3.59", "SENDEROVICH, ALEKSANDR M, 3.63", "AHMED, ALAA ABDALLA, 2.74", "STADLBAUER, SUSANNE MARION, 3.33", "JACKSON, HANNAH L, 3.64", "BAOUCHI, ABDEL WAHAB, 3.5", "DOUTHITT, CAMERON BENNETT, 2.67", "DOUTHITT, CAMERON BENNETT, 3.07", "ROONEY, MARTHA MARIE, 2.89", "ANGEL, EITAN M, 2.85", "ANGEL, EITAN M, 2.76", "ROY, MICHAEL D, 3.3", "ROY, MICHAEL D, 3.12", "ENGLANDER, JANOS, 3.5", "FOX, JEFFREY S, 3.41", "POWER, JOY M, 3.5", "FILLMAN, CHRISTY L., 3.83", "WAIDLER, KATHARYN D, 3.7", "DESSAU, DANIEL S, 3.64", "RITZWOLLER, MICHAEL H, 3.64", "DESSAU, DANIEL S, 3.46", "RITZWOLLER, MICHAEL H, 3.46", "DESSAU, DANIEL S, 3.85", "RITZWOLLER, MICHAEL H, 3.85", "FORD, WILLIAM T, 3.62", "FORD, WILLIAM T, 3.71", "UZDENSKY, DMITRI ANATOLJEVICH, 3.64", "POLLOCK, STEVEN J, 3.64", "SMALYUKH, IVAN I, 3.2", "ZIMMERMAN, ERIC, 3.5", "DE ALWIS, SENARATH P, 3
var grps = _.groupBy(data, 'Subject')
var myvar = _.mapValues(grps, function(group){
var rating = [0,0]
_.map(group, function(n){
if (n.AvgCourse != null) {
rating[0] += n.AvgCourse
rating[1] += 1}
return rating
})
return rating[0]/rating[1]
})
return myvar{
"HIST": 4.925072463768115,
"HONR": 5.470909090909092,
"HUMN": 5.012,
"IAFS": 5.123157894736842,
"IPHY": 4.85851851851852,
"LING": 4.667096774193548,
"MATH": 4.388229665071771,
"MCDB": 4.716605504587155,
"BAKR": null,
"PHIL": 4.8359459459459435,
"PHYS": 4.4928947368421035,
"PSCI": 4.870480769230768,
"NRSC": 5.050588235294118,
"PSYC": 5.013545454545456,
"WRTG": 4.717683923705725,
"RLST": 4.6259999999999994,
"SLHS": 4.837968750000001,
"SOCY": 4.8045599999999995,
"ARAB": 4.519,
"PORT": 5.494285714285714,
"SPAN": 4.90142857142857,
"COMR": null,
"FARR": null,
"GSAP": null,
"INVS": 5.563000000000001,
"PACS": 4.7925,
"SEWL": null,
"DNCE": 5.242142857142857,
"THTR": 4.9603174603174605,
"WMST": 4.866153846153848,
"ACCT": 4.809545454545455,
"BADM": 5.087419354838711,
"BCOR": 4.491132075471699,
"BSLW": 4.836666666666666,
"BUSM": 4.876666666666667,
"CESR": 5.111428571428571,
"ESBM": 5.062173913043478,
"FNCE": 4.682272727272728,
"INBU": 4.441428571428571,
"MBAC": 4.481000000000001,
"MBAX": 4.898064516129031,
"MGMT": 4.945263157894737,
"MKTG": 4.555405405405404,
"REAL": 5.245454545454546,
"EDUC": 4.912290076335878,
"ASEN": 4.900625000000001,
"CHEN": 4.424782608695652,
"CSCI": 4.554,
"AREN": 4.61090909090909,
"CVEN": 4.9444155844155855,
"ECEN": 4.5656923076923075,
"EMEN": 4.969130434782609,
"EHON": 5.468000000000001,
"GEEN": 4.681967213114754,
"EVEN": 4.6899999999999995,
"HUEN": 5.367058823529412,
"MCEN": 4.479772727272726,
"TLEN": 4.818695652173913,
"ATLS": 5.064047619047618,
"MUSM": 4.848000000000001,
"RSEI": 5.655,
"JOUR": 4.892823529411764,
"LAWS": 4.9584375,
"CONV": null,
"EMUS": 5.364642857142856,
"MUEL": 4.9253124999999995,
"MUSC": 4.76109756097561,
"PMUS": 5.523636363636362,
"TMUS": null,
"AIRR": 5.155833333333333,
"MILR": 5.27,
"NAVR": 5.315555555555555,
"CSVC": null,
"LDSP": null,
"NRLN": 5.67,
"PRLC": 5.333333333333333,
"ARCH": 4.57,
"ENVD": 4.955116279069768,
"ARTH": 4.896666666666666,
"ARTS": 5.010625,
"CAMW": 4.54,
"CWCV": null,
"LGBT": 5,
"LIBB": null,
"CHIN": 4.966,
"FRSI": 4.44,
"HIND": 4.56,
"JPNS": 5.398124999999999,
"KREN": 5.03,
"ANTH": 4.8636585365853655,
"APPM": 4.736530612244898,
"ASTR": 4.913913043478261,
"ARSC": 5.20125,
"ATOC": 4.632083333333334,
"CHEM": 4.597166666666667,
"CLAS": 5.213703703703704,
"COMM": 4.664933333333331,
"EBIO": 4.720860215053764,
"ECON": 4.526666666666667,
"ENGL": 4.9946610169491485,
"ENVS": 5.0736842105263165,
"ETHN": 5.203499999999999,
"FILM": 5.059666666666667,
"FREN": 4.881666666666666,
"ITAL": 5.281875000000001,
"GEOG": 4.8403846153846155,
"GEOL": 4.8985714285714295,
"GRMN": 5.05,
"HEBR": 5.138,
"RUSS": 5.051874999999999,
"SCAN": 5.3575,
"SWED": 5.54,
"LEAD": 5.68
}
return "[answer]"return _.filter(data, function(c){return c.Subject == 'CONV'})[
{
"Activity_Type": "LEC - Lecture",
"Course": "1990",
"CourseTitle": "Convocation Recitals",
"CrsLvlNum": "1XXX",
"CrsPBAColl": "MB",
"CrsPBADept": "MUSC",
"Honors": "0",
"Instruction_Mode": "P - In Person",
"Level": "Lower",
"NComb": 1,
"NIntrFCQ": 1,
"N": {
"ENROLL": 38,
"EOT": 35,
"GRADE": "",
"INCOMP": 0,
"NOCRED": 0,
"PASS": 23,
"Ret": 0
},
"PCT": {
"A": "",
"B": "",
"C": "",
"C_MINUS_OR_BELOW": "",
"D": "",
"DF": "",
"F": "",
"GRADE": "",
"INCOMP": "",
"WDRAW": ""
},
"RAP": "0",
"Section": "001",
"Subject": "CONV",
"Subject_Label": "Convocation Music",
"Workload": {
"Hrs_Wk": "",
"Raw": ""
},
"YearTerm": "20137",
"Instructors": [
{
"group": "1 TTT",
"name": "BRODY, JAMES M",
"title": "ASSOC DEAN-FACULTY"
}
]
},
{
"Activity_Type": "LEC - Lecture",
"Course": "1990",
"CourseTitle": "Convocation Recitals",
"CrsLvlNum": "1XXX",
"CrsPBAColl": "MB",
"CrsPBADept": "MUSC",
"Honors": "0",
"Instruction_Mode": "P - In Person",
"Level": "Lower",
"NComb": 1,
"NIntrFCQ": 1,
"N": {
"ENROLL": 31,
"EOT": 31,
"GRADE": "",
"INCOMP": 0,
"NOCRED": 0,
"PASS": 21,
"Ret": 0
},
"PCT": {
"A": "",
"B": "",
"C": "",
"C_MINUS_OR_BELOW": "",
"D": "",
"DF": "",
"F": "",
"GRADE": "",
"INCOMP": "",
"WDRAW": ""
},
"RAP": "0",
"Section": "001",
"Subject": "CONV",
"Subject_Label": "Convocation Music",
"Workload": {
"Hrs_Wk": "",
"Raw": ""
},
"YearTerm": "20141",
"Instructors": [
{
"group": "1 TTT",
"name": "AUSTIN, JAMES R",
"title": "DEAN"
}
]
}
]