I am a novice Excel user. Linked to this blog page is my data-spreadsheet-enrollment. Previously, the most work that I did on Excel was to add cells to a spreadsheet that my mother created when I was getting married! When I started this assignment, I knew very little about data management. Despite this, I chose to tackle the intermediate grouping in order to challenge myself. This was very helpful for me. It resulted in a better understanding of how the program can organize data, and help users find trends and correlations. I know that my attempt is basic, but I am very happy with the knowledge that I gained through this process.
Initially, I was trying different data sets while figuring out how to work with the rows and columns. I first narrowed down the pool to twenty-five elementary schools, because I am a third grade teacher and I wanted a smaller data set. I sorted the data and put the enrollment in descending order. Then I tried that with other columns. Ultimately, after trying different things, I focused on the relationship between schools with a higher population of free lunches distributed, and the scores of 3/4 on the New York State ELA test. After working on the sheets and figuring out how to narrow down the information, I spent time on the charts and tried to bring forth the notable trends.
Because I went to Teachers College and taught in Manhattan, I am aware of some of the schools, such as PS 006, and Manhattan New School. Therefore, it did not surprise me that similar schools had low percentages of free lunch and a high percentage of students who achieved a 3 or 4 on the ELA exam. The “Free lunch, % ELA bar graph” in orange and green clearly demonstrates the relationship between free lunches and ELA scores. As the number of free lunches increases, the percentage of students achieving 3s or 4s typically decreases. Of course, there are outliers. but this data set highlights the inverse relationship between an increased number of free lunches and the ELA test scores.