Monday, February 11, 2013
Market Share - Percentage Independent and Public by District by Year
Headcount Data - Sources and Notes
I'm currently interested in looking at changes in headcount over the years for the BC school system.
Data from 1994/95 to 2011/12 is found here: http://www.data.gov.bc.ca/dbc/search/detail.page?ms=url%3Aapps.gov.bc.ca&recorduid=174064&title=BC
This shows "Headcount of students by Grade, includes facility type (program, ie: distance learning, standard, continuing education". As the software I'm using to analyze the data with (the amazing Tableau Public) can't handle more than 100,000 rows of data, I've removed the grade data and just kept the year, public or independent, school code, school name, school facility type, and school total headcount.
For the 2012/13 school year, I've added school enrollment figures from here: http://www.bced.gov.bc.ca/apps/imcl/imclWeb/SchoolContacts.do
Some minor changes were made to the categorization to keep it consistent between the two sets of data.
Additionally, I've added in District number, District name, and a category for the size of district.
Totals are for for Public only, Standard Schools only, from the 2011/12 school year:
Mega - Over 50,000
Large - 20,000 to 50,000
Medium - 10,000 to 20,000
Small - 2,000 to 10,000
Micro - Under 2,000
Notes:
Data from 1994/95 to 2011/12 is found here: http://www.data.gov.bc.ca/dbc/search/detail.page?ms=url%3Aapps.gov.bc.ca&recorduid=174064&title=BC
This shows "Headcount of students by Grade, includes facility type (program, ie: distance learning, standard, continuing education". As the software I'm using to analyze the data with (the amazing Tableau Public) can't handle more than 100,000 rows of data, I've removed the grade data and just kept the year, public or independent, school code, school name, school facility type, and school total headcount.
For the 2012/13 school year, I've added school enrollment figures from here: http://www.bced.gov.bc.ca/apps/imcl/imclWeb/SchoolContacts.do
Some minor changes were made to the categorization to keep it consistent between the two sets of data.
Additionally, I've added in District number, District name, and a category for the size of district.
Totals are for for Public only, Standard Schools only, from the 2011/12 school year:
Mega - Over 50,000
Large - 20,000 to 50,000
Medium - 10,000 to 20,000
Small - 2,000 to 10,000
Micro - Under 2,000
Notes:
- School names occasionally change in the dataset. Some of these changes are trivial, some are not.
- School sizes are masked for values of under 10 - no data will appear for a year in which a school has fewer than 10 students.
- District number was derived from first digits of school code. In some years, there are distance education programs that are not attributed to a particular district, so they have been added to District named Distance Education.
Subscribe to:
Posts (Atom)