search

dssg / after-hours

2 stars 3 forks source link

Categorize transcript data by course #21

Open nsmader opened 11 years ago

nsmader commented 11 years ago

In raw-data/transcript, collect unique course titles and recode them to "math", "science", etc as appropriate. Ultimately, it may be more useful to categorize these by academic vs. non-academic (e.g. exclude physical education), and core (math, english, science, social studies) vs. non-core subjects (all other).

To easily summarize the fields from the command line, can do e.g.: cut -d "," -f6 sys2012_final.csv | sort | uniq > unique-course-values_sy2012.txt (where the 6th column has course titles).

breannam commented 11 years ago

Not sure what KG stands for. It appears the courses starting with KG (e.g., "KG DRAMA") are only in the _sy2012.txt file, and not in the .csv file. Could you explain why?

nsmader commented 11 years ago

Kindergarten? Can be checked by examining the grades of all students enrolled in those classes.

On Mon, Jul 22, 2013 at 2:44 PM, breannam notifications@github.com wrote:

Not sure what KG stands for. It appears the courses starting with KG (e.g., "KG DRAMA") are only in the _sy2012.txt file, and not in the .csv file. Could you explain why?

— Reply to this email directly or view it on GitHubhttps://github.com/dssg/after-hours/issues/21#issuecomment-21370266 .

Nicholas Mader, PhD Senior Researcher Chapin Hall at the University of Chicago 1313 E 60th St., Chicago, IL 60637 W: 773-256-5195, C: 608-332-1029 http://www.chapinhall.org