Saturday, November 23, 2024

The Fascinating Trends: Classroom Sizes in British Columbia

 

My original dataset and data slices are here.

Lead


    In 2023/2024, kindergarten classes in British Columbia averaged 18 students, 22% lower than the provincial average of 23. This data from the Government of B.C. supports how kindergarten students can benefit from smaller class sizes, such as having quality one-on-one time with their teacher.


Summary and Findings


    Throughout the semester, I analyzed data on the average class sizes from 2006/2007 to 2023/2024 in the Lower Mainland and Vancouver Island. In my last data update, I found out that the school year 2020/2021 saw the lowest average class size over the last 18 years due to the COVID-19 pandemic. I did further analysis to see if there were any other reasons for a decline in classroom sizes before 2020/2021. I did some digging and found an article. I found out that due to increased funding for B.C. schools from the government, there has been a decrease in class sizes. In the 2017/2018 school year, money was finally put into B.C. schools after a long stretch. This money helped to solve the more significant class size problem caused by the Liberal Party's decision in 2002. (Rozworski, 2018). 


    Yes, the COVID-19 pandemic and funding saw a decrease in classroom sizes. However, I wanted to find out why kindergarten classes in British Columbia had a much smaller classroom size in the year 2023/2024 than the average provincial size in the same year. I discovered that a Supreme Court Decision in 2016 was a win for the B.C. Teachers Federation. This legal battle dates back to 2002, and since the B.C. Teachers Federation won, the government has had to fund and "provide resources for class size and composition that date back to levels from when the legal dispute began" (Zussmann, 2016). Ultimately, this decision had a part in the lower kindergarten classroom sizes we now see in 2023/2024. You can find the CBC News article about the win here. 


    In a Globe & Mail article, it states that "[t]eachers have long called for more librarians, teaching aides and smaller class sizes" (Stueck et al., 2016). 


    While a Supreme Court ruling and increased funding have contributed to fewer students in kindergarten classes, kindergarten students still need more one-on-one time with teachers to promote growth and success. Having a smaller classroom size where teachers can give individual time to each student is beneficial to their learning. I found a document containing twelve case studies about the effects of a full day of kindergarten compared to only a half day. In this document, one teacher talks about having a lot more time to connect and engage with her students, "I am able to participate and be more involved in their learning. I can play more with students" adding, "I definitely know the children's strengths and needs better" (Mort, 2011). Parent feedback was a crucial part of these studies, and while there was much positive feedback, parents wanted to see that "the teacher has enough help/staff aide for high-functioning children with larger number class sizes" (Mort, 2011). So yes, smaller class sizes give positive outcomes for kindergarten students, but work still needs to be done.


Feedback


    In my third data update, I was instructed to change the title and subtitle of my Datawrapper chart. The original title I had tells the audience that there was a gradual decline in class sizes, but the Datawrapper chart does not reflect that gradual decline. I changed both the title and subtitle to complement the line chart. In my last data update, I focused on one specific year, but I was encouraged to explore the decline in the years before the COVID-19 pandemic and what other factors led to the gradual decline. You can see that explanation in my summary above. I also included another Datawrapper chart in my report that reflects the patterns of class sizes over the years for just kindergarten. This has allowed for further analysis and comparison of the average class sizes of all grades to the average kindergarten class sizes in each school year. 

Wednesday, November 6, 2024

Data Update #3




Chart



Question

Why did the biggest decline in classroom sizes in British Columbia happen in the school year 2020/2021?

Link & Brief Summary

CTV News article is here.

From 2006/2007 to 2023/2024, the 2020/2021 British Columbia school year had the lowest average class of 21.3. Comparing the 2006/2007 school year, I was surprised that classroom sizes were bigger in that year compared to the later years of 2020/2021. 2021/2022, 2022/2023, and 2023/2024. The COVID-19 pandemic that hit British Columbia is a huge reason why we see a low average classroom size in 2020/2021. This CTV news article examines the guidelines put into place in B.C. schools in the 2020/2021 school year, and how those guidelines are changing for 2021/2022 as a new variant of COVID-19 is rising in the province. This article was published in August 2021 and refers to the safety guidelines of last year, which I take as the 2020/2021 school year. Smaller classroom size is one of the ways British Columbia dealt with the COVID-19 pandemic in that school year, indicating why my data shows that classroom size declined for 2020/2021. 


New Data Slice

The new data slice is here.

Link to the original dataset

The original dataset is here.

Saturday, October 26, 2024

Data Update #2: British Columbia Classroom Sizes (2006/2007 to 2023/2024)

 

Lead

West Vancouver has an average class size of 25, 14% higher than the provincial district average, according to B.C. government data.

I used a provincial data set about school sizes in British Columbia instead of my original dataset, which only focused on the size of the Surrey school. I was able to compare class sizes from school districts all across the province, which led to some exciting findings. The provincial dataset had a more extensive data set, which made for deeper analysis. I used hyperlinks to link my datasets instead of copying and pasting the entire URL.

Excel Workbook Link and Explanation

The link to the raw data is here.

Here is the link to the data slice. This slice shows the school years from 2006/2007 to 2023/2024 and examines the average class size of all grades each year. I included the overall average of all the years so you know where I got the average class size of 25, which is in my lead. I used the AVERAGE formula in Excel to calculate the average. This slice also shows the school years from 2006/2007 to 2023/2024 and the district-wide average class size for each school year. I included the overall average class sizes for all the years. I used the AVERAGE formula in Excel to calculate the average.

The calculation I used to determine the 14% difference mentioned in my lead is:

(New Value-Old Value)/Old Value x 100

Original Dataset Link

The link to the original dataset is here.



Sunday, September 29, 2024

Data Update #1: Surrey School Class Size 2022-2023

 


1. What dataset will you use for your final report?

I will use a data set from the City Of Surrey Open Portal for my final report. The dataset is called Surrey School Class Size 2022-2023. 

Link: https://data.surrey.ca/dataset/fa402532-3a19-4913-affc-97b67a13d7e9/resource/d562837e-7d6d-486d-985f-ecf71aa8b4d9/download/surrey_school_class_size2022-2023.xlsx

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

This data set lists all the schools in the Surrey School District and compares them by their class sizes. It compares the 2006/2007 school year and includes elementary and secondary schools. The data set shows the names of the elementary and secondary schools and the total number of classes at each school. Then, it shows the number of classes with a class size of 30 plus students. The set also has columns that show the average class size at each school for all grades (Kindergarten to Grade 12). Basic information like the district name and if the schools are public or private are also included. 

3. Is there anything about your data that you don’t understand? How will you find this out? 

The only part of my data I did not understand was what it meant by an independent school. There is a column that tells me if the school is public or independent. I typed in the definition of independent school on Google and found out that it is another name for private school.

4. What are some questions you hope to answer with your data? List at least three.

The questions I hope to answer with my data.

1) Which Surrey school has the largest and smallest average class size? (Everything from kindergarten to grade 12).

2) Which Surrey school has the largest amount of EAs in their classrooms?

3) Which Surrey school has the highest amount of classrooms?

4) Which Surrey school has the most and least classes with 30 plus students?




Friday, September 13, 2024

Data Analysis

 


                                                                       Data Analysis

                                    Percentage of back-to-back women plays by station
 
                                                                     Link to bar chart 




          This bar chart shows 29 country radio stations in the United States, listing the percentage of back-to-back plays of women for each station. Those percentages were ranked from highest to lowest. While the bar chart is easy to follow and clear to understand, some weaknesses stand out. 


When I first saw this bar chart, my eyes immediately went to any bar that had colour on it. The bar with colour was from the radio station in San Antonio (KCYY-FM). The chart highlights the percentage of back-to-back women plays by each station. If my data was specifically looking at the station in San Antonio, that would be a great use of colour. Still, because we are looking at all the stations, it would have been nice to see a different colour representing the percentages, even though a line separates each one. The lines separating each percentage should be thicker and darker so it stands out to the audience looking at the chart. The San Antonio station was highlighted only because the data analyzed earlier in the article came from San Antonio. If it had just been San Antonio being highlighted, I would have changed the title to reflect that. 

I can clearly distinguish between the highest percentage of radio plays versus the lowest percentage of radio plays. The Los Angeles radio station has the highest rate of back-to-back radio plays. In contrast, the Cincinnati radio station has the lowest percentage of back-to-back radio plays for women. This bar chart needs to clearly tell us the period for which this data is for. Just from looking at the data, there is no clear indication in the title or in the chart that tells me the period. This bar chart represents 29 radio stations and their percentages, which is a lot of data that can get overwhelming. This chart simplifies all that overwhelming information and makes it straightforward for people to read and understand. Overall, this chart did an excellent job of explaining the data clearly, but some tweaks need to be made to it. This data is separated into categories, so the bar chart is the best way to represent that data.

This bar chart was not interactive. A drop-down button with the options to show the highest percentage, lowest percentage, or a specific radio station made the chart more valuable and interactive.
















































Sunday, February 27, 2022

FOI Request

 



Kristina Gardner 
5138 215th street
Langley, B.C., V3A 6C6
kristina.gardner1@email.kpu.ca
(604)358-8825


March 1st, 2022


Freedom of Information Coordinating Office
The British Columbia Hydro and Power Authority
333 Dunsmuir St.
Vancouver, B.C., V6B 5R3
FOI.Requests@bchydro.com


To whom it may concern,

Under the Freedom of Information and Protection of Privacy Act, I would like to request:

- A copy of all power outages caused by car accidents versus motorcycle accidents and how long those outages lasted in the Langley Township between November 2020 and November 2021. 

Please forward all documents you can release in PDF format. 
You can email those documents to: kristina.gardner1@email.kpu.ca.
You can reach me with any questions or concerns at (604)358-8825. 

Please let me know when the documents are ready for release.

Sincerely, 

Kristina Gardner





BC Hydro accepts FOI requests, but they do not have a specific name or coordinator linked to their FOI request address. Therefore, the request goes to their coordinating office. The link is here. 

I made this FOI request to BC Hydro because a couple of months ago, a power outage at my house was caused by a nearby motorcycle accident. The power outage affected only mine and a few other homes on the block, and it lasted for quite a while. The outage lasted for approximately 24 hours. Usually, power outages are caused by a storm or car accident in my area, but this outage was caused by a motorcycle accident. That made me curious if outages caused by motorcycle accidents are common in my room. I also requested to see the duration of these power outages because I hope to find out if motorcycle accident-induced outages last longer than car accident-induced ones. The outage at my house lasted close to 24 hours, so I am curious to find out if lengthy outages are familiar with motorcycle accidents or not. 

The Fascinating Trends: Classroom Sizes in British Columbia

  My original dataset and data slices are here. Lead      In 2023/2024, kindergarten classes in British Columbia averaged 18 students, 22% l...