Skip to contents

General utilities for the Civic Infrastructure Assessment

These functions and data tables are used for putting data into the CIA format, and for mapping labels from their origins’ terms to the terms used by StriveTogether.

Glossaries

Tables that map from one set of definitions to another.

GLOSSARY_OF_POPS_FOR_CIA
The literal row labels for different populations that StriveTogether wants
GLOSSARY_OF_POPS_FOR_COMPS
Group population and gender classes into three comparsions for visualization
success_subtotals()
Count up successes and failures based upon
to_wide_cia_format()
Reformat a long data frame into the CIA format

Census variables

The American Community Survey contains information about post-secondary attainment and family-sustaining employment, in addition to general counts of populations.

GLOSSARY_OF_POPS_FOR_CENSUS
Mapping from Census demographic categories to StriveTogether ones
INCOME_BRACKETS
Mapping from Census income brackets to dollar values
POSTSECONDARY_BY_LANGUAGE
Variables from the US Census to describe postsecondary completion by language spoken
POSTSECONDARY_BY_POVERTY
Variables from the US Census to describe postsecondary completion by poverty status
POSTSECONDARY_BY_SEX_AND_RACE
Variables from the US Census to describe postsecondary completion by sex and race/ethnicity
POSTSECONDARY_EDUCATION_LEVELS
Values of education levels from the US Census to describe postsecondary completion

IPEDS utilities

The US Department of Education has an Integrated Postsecondary Education Database System. These tools help with wrangling those data.

GLOSSARY_OF_POPS_FOR_IPEDS
Mapping from IPEDS populations to StriveTogether ones
SEMI_JOINS_FOR_IPEDS
IPEDS fields for calculating 150% graduation counts
wrangle_local_postsecondary_completers()
Wrangle raw IPEDS graduation data for local schools into the local 150% postsecondary completion rate

Wisconsin-specific utilities

Definitions and algorithms for converting Wisconsin data into CIA format.

GLOSSARY_OF_POPS_FOR_WISEDASH
Mapping between WISEDash Public's "GROUP_BY_VALUE" and StriveTogether's "population."
GLOSSARY_OF_POPS_FOR_WISEDASH_LOCAL
A mapping from WISEDash Local labels to StriveTogether ones.
predicate_MAP_growth()
Identify which students met or exceeded their MAP growth goals
predicate_MAP_percentile()
Identify which students met or exceeded their MAP growth goals
SEMI_JOINS_FOR_FORWARD
Use this to semi-join Forward results and only get Strive-relevant data
SEMI_JOINS_FOR_WISEDASH_LOCAL
A lookup table for mapping demographic information from WISEDash Local to StriveTogether formats
SPEC_FOR_WISEDASH_LOCAL_MAP_GROWTH
Column specification for data from WISEDash about student growth in MAP scores
SPEC_FOR_WISEDASH_LOCAL_MAP_PERCENTILES
Column specification for data from WISEDash about student MAP percentile scores
map_growth_for_k8()
Import and wrangle WISEDash Local data about students' growth on MAP reading
map_percentiles_for_kg()
Import and wrangle WISEDash Local data about Kindergartners' percentile scores on MAP reading
read_wisedash_local()
Import data from WISEDash Local into a CIA-friendly format
wisedash_local_to_strive()
Compute marginal totals for the CIA from student-level data from WISEDash Local
wisedash_public_to_strive()
Wrangle WISEDash Public data into a format ready for the CIA
wrangle_wisedash_local()
Wrangle data from WISEDash Local into a CIA-friendly format