Excel is a spreadsheet application developed by Microsoft Office. This program has the basic features of all spreadsheets, plus numerous features that I am unaware of. Hopefully, someday before my time is up I can figure all of the attributes out! Today, I installed the Data Analysis Tool Pack in Excel. I also learned how to analyze the state comparisons data from the NCES website by using descriptive details, sorting, and number stuff.
Before I analyzed the data, it was actually hard to figure out where West Virginia stood in rank. However, after analyzing the data I found that West Virginia, in relation to the other states, is not doing the best. We are at the low end of the totem pole for 4th grade reading in public schools. Specifically we are ranked 43 out of the 52 jurisdictions. Therefore, there are 43 jurisdictions above us and 9 jurisdictions below us. The states that fall below us include Hawaii, Nevada, Arizona, California, Louisiana, Mississippi, New Mexico, Alaska, and capital District of Columbia. Data showed me that there is a large difference between the scale scores of boys and girls in the state of WV. In addition, I found that we were unfortunately below the national public average.
Descriptive Statistics Total Scores
State Comparisons
State Comparisons Continued
(Not included #1 Massachusetts)
Scatterplot
This activity was beneficial for me as a teacher. It helped seeing the activities I completed in excel and especially the scatter plot chart. I now realize how important it is to put 100% effort in my teaching. I know that it will be difficult for one person to change these statistics, but we have to strive to start somewhere.
This activity relates to the ISTE NETS T standard 2: Design and Develop Digital-Age Learning Experiences and Assessments. This standard is about designing, developing, and evaluating assessments and digital age tools. By using Microsoft Excel, teachers can analyze assessments and other information. It would be great to insert your grade-book into Excel. This would be beneficial because we can easily identify which students are understanding and excelling in specific subjects, as well as students who are struggling. Also, Excel could be used as a tool to teach math skills, as well as other subjects to the students.