Sunday, October 6, 2019

Assignment #2: Data Update 1


1. What dataset will you use for your final report? (describe your dataset, include a link to it and claim it at the URL above).

The dataset I will be using is derived from the official website for the Government of British Columbia and is titled “BC Schools - Class Size”.

2. Describe the dataset. What kind of data does it contain?

It examines class size information from 2006 to 2019 in BC. Furthermore, it consists of statistics of the composition of BC public school classes by Province, District, and School level and includes the average class size for kindergarten through grade 12. It also includes the number of reported classes that have assigned Education Assistants, the number of reported schools, the number of reported classes, and the number of reported classes with more than 30 students.

3. Is there anything about your data that you don’t understand? (i.e. what a column heading means). How will you find this out?

I was unsure what the “Mincode” column was referring to. To get the definition, I looked on “Definitions for Open Data – BC Schools” which defined Mincode as a “current eight-digit numerical identifier assigned to the school by the Ministry of Education”. Apart from the one heading, the dataset is very straightforward, and all of the headings are easy to understand. However, if an issue does arise, I will do my own additional research to answer any questions I may encounter.

4. What are some questions you hope to answer with your data? List at least three. (you don’t need the answers at this point)

                        i.         Which 10 cities in BC have the most schools;
                       ii.         Which 10 cities in BC have the least schools;
                      iii.         Do “Total Classes Greater than 30” exist in some of BC’s larger cities compared to smaller cities;
                      iv.         Have the average class sizes for kindergarten to grade 12 increased over the years; and
                       v.         Which cities in BC have a higher number of educational assistants in classes?

3 comments:

  1. Interesting topic, Education is one of the most important issue in every region. I am looking forward to your final graph. I am thinking the description said that it includes the classes more than 30 students, but what about less than 30?

    ReplyDelete
  2. This is an interesting topic. You also have a lot of questions that you would like to explore. It would be interesting to figure out why some BC cities have the least/most schools, and why that is the case.

    ReplyDelete
  3. Interesting topic. You have a lot of good questions. Education is very important and I am looking forward to your final graph.

    ReplyDelete