Bug #3519


Proof of concept: Demographic data incorporation

Added by ben leinfelder over 15 years ago. Updated over 15 years ago.

Target version:
Start date:
Due date:
% Done:


Estimated time:


In lieu of providing an interface for importing [variable] demographic data, we can prescribe a table structure for the demographic data, upload it to the server (manually) and then reference it when joining assessment data and metadata.

Actions #1

Updated by ben leinfelder over 15 years ago

added a menu option to select a csv and add it as another data file in the edml package.
we need to determine exactly what fields (and the order) this file should contain. so far i've only defined it as:

-minimal file checking (make sure it conforms or nearly conforms to the expected structure)
-encrypting the studentId such that it can match the assessment response data when joining the two data files

Actions #2

Updated by ben leinfelder over 15 years ago

after soliciting advice from our FIRST group, this is a proposal for the structure of the demographic data:

student_id - Student ID
term - Semester/Quarter (when the data was pulled)
major - Major
gpa - GPA
citizenship - Citizenship (country)
ethnicity - Ethnicity
gender - Gender
dob - Date of birth
high_school - Name of high school
hs_zip - ZIP code of high school
hs_graduation_year - Year of high school graduation
hs_gpa - High school grade point
SAT_type - SAT Test Type
SAT_score - SAT Test Score
ACT_english_score - ACT English Test Score
ACT_math_score - ACT Math Test Score
ACT_reading_score - ACT Reading Test Score
ACT_science_score - ACT Science Test Score
ACT_composite_score - ACT Composite Test Score
AP_type - AP Test Type
AP_score - AP Test Score
other_test_type - Any other institution-specific Test Type
other_test_score - AP Test Score

Actions #3

Updated by ben leinfelder over 15 years ago

student_id is now sharing the same encryption method used for importing assessment data.

Actions #4

Updated by ben leinfelder over 15 years ago

as a proof-of-concept, this works. you can attach a standard demographic data file to an assessment data package and upload that with the student data.
on the server side, you are given the option to include that data in the download if it is present for the datapackage[s]

Actions #5

Updated by Redmine Admin about 11 years ago

Original Bugzilla ID was 3519


Also available in: Atom PDF