search

dssg / after-hours

2 stars 3 forks source link

Generate GPA and course failure out of transcript files #22

Open nsmader opened 11 years ago

nsmader commented 11 years ago

Using conversion of A = 4.0, B = 3.0, C = 2.0, D = 1.0, F = 1.0, calculate GPA for each time period for students using data/raw-data/transcript files. The applicable time period is indicated in the file name.

Create GPA by "overall", and "core" vs "non-core" subjects.

Also create variable for number of courses failed.

breannam commented 11 years ago

In this data, is there any notion of taking a class that is worth more credits than another class? Should the GPA be a weighted average?

breannam commented 11 years ago

There are possible values for the variable mark that are "/" and "P". How should these be recoded for GPA calculations?

ejette commented 11 years ago

@breannam and I worked on this today. We have the function written that recodes the GPA letters into numbers and calculates the mean for each student. We need to implement this for every file and also talk about restructuring code, so it is more modular.