I am creating a database of public and independent schools in Vancouver and its suburbs with specific information. ?
This will require data scraping of pdf and excel files from 2 urls which are a British Columbia school report search. ?
Delivery is data on an excel spreadsheet. ? Prefer process used is automatic rather than cut and paste. ?
## Deliverables
I am creating a database of public and independent schools in Vancouver and its suburbs with specific information. ?
This will require data scraping from these 2 urls which are a British Columbia school report search. ?
Delivery is data on an excel spreadsheet. ? Prefer process used is automatic rather than cut and paste. ? Please see attached excel template for exact format.
1) Data from these two urls:
Public schools:
<[login to view URL]>
Independent schools:
<[login to view URL]>
2) Only from these 11 cities:
Burnaby, Coquitlam, Delta, Langley, Maple Ridge - Pitt Meadows, New Westminster, North Vancouver, Richmond, Surrey, Vancouver, West Vancouver
3) Eliminate all schools with the word “Secondary?? in the name
4) Only this data needed: (Independent schools only have STUDENT STATISTICS and FOUNDATION SKILLS ASSESSMENT data)
A)
CLASS SIZE SUMMARY (PDF only available) 2009/2010
- p2
- school - average class size - kindergarten
- school - average class size - Grade 1-3
- school - average class size - Grade 4-7
B)
STUDENT STATISTICS (PDF, maybe Excel available)
- p1
- Headcount
- ESL - 2009/10 - Headcount %
- French Immersion - 2009/10 - Headcount %
C)
STUDENT STATISTICS (PDF, maybe Excel available)
- p7
- Top Ten Languages Spoken in Home % (only scrape the following language categories)
- English
- Chinese (Cantonese, Chinese, Mandarin should all come under this category)
- Punjabi
- Korean
- Vietnamese
- Tagalog (Tagalog, Philipino, and Pilipino should all come under this category)
- French
- German
- Spanish
- Hindi
D)
FOUNDATION SKILLS ASSESSMENT (PDF and Excel available)
- p1
- FSA Grade 4, Feb 2009
- Reading - All Students
- Performance Level unknown- %
- Meeting and Exceeding - %
- Writing - All Students
- Performance Level unknown- %
- Meeting and Exceeding - %
- Numeracy - All Students
- Performance Level unknown- %
- Meeting and Exceeding - %
-p2
-FSA Grade 7, Feb 2009
- Reading - All Students
- Performance Level unknown- %
- Meeting and Exceeding - %
- Writing - All Students
- Performance Level unknown- %
- Meeting and Exceeding - %
- Numeracy - All Students
- Performance Level unknown- %
- Meeting and Exceeding - %
E)
SATISFACTION SURVEYS (PDF, maybe Excel)
- p6
- Gr 3/4 results- school - 2008/09 - Do you like school? (in %)
p11
- Gr 7 results- school - 2008/09 - Do you like school? (in %)
p13
- Elementary Parents results - school - 2008/09 - Are you satisfied with what your child is learning at school? (in %)