In ekholme-ccps/ccpsr: Tools for Working with CCPS Data

ccpsr

ccpsr contains useful functions for working with and presenting chesterfield County Public Schools data.

Stuff

Misc

• set_con: connect to CCPS Research and Eval databases.

Data Ingest

• fetch_attendance: fetch days present, days enrolled, and % of days present for each student in a given year. Requires user to specify if regular schools or year-round schools.
• fetch_all_attendance: wrapper around fetch_attendance to retrieve attendance for regular schools and year-round schools.
• fetch_discipline: fetch student-level discipline data for a given year.
• fetch_grades: fetch student course & marking period grade data for a given year.
• fetch_school_demos: fetch demographic compositions for each school for a given year.
• fetch_src_ids: fetch the CCPS ids of students represented in a given sRC submission. Note that this addition deprecates the fetch_fm_ids function.

Data Cleaning

• recode_ethnicity: recode ethnicity to more interpretable values.
• recode_demos: recode demographics into values more amenable to pivoting.

Aggregation

• calc_gpa: calculate students' gpa (and number of classes contributing to gpa) for a given year. Note that this addition deprecates the calc_unweighted_gpa function.
• summarize_disposition_days: calculate the total number of disposition days for each student in a given year.

Data

• core_school_codes: school codes for elementary, middle, and high schools. Excludes alternative, technical, and regional schools.
• secondary_school_codes: school codes for middle, high, alternative, and regional programs.
• elementary_school_codes: school codes for elementary schools.
• middle_school_codes: school codes for middle schools.
• high_school_codes: school codes for high schools.
• grading_lookup: lookup table for ccps grading -- letter/numeric/grade points.
• course_codes_lookup: crosswalk for course code prefixes and content areas.
• booth_school_codes: school codes for elementary schools overseen by Booth.
• foglesong_school_codes: school codes for elementary schools overseen by Foglesong.
• stefanko_school_codes: school codes for elementary schools overseen by Stefanko.

Templates

• CCPS ORE Distill: a default template for CCPS ORE articles using {distill}

Installation

You can install {ccpsr} from Github by running the following command:

#install.packages("remotes") if you do not have {remotes} installed already
remotes::install_github("ccps-research-eval/ccpsr")

ekholme-ccps/ccpsr documentation built on Aug. 17, 2021, 10:01 p.m.