The goal of this assignment is for you to take educational data, display it in a quantitative fashion, analyze the data, and make a prediction of what education may be like ten years from now.
You will demonstrate your quantitative reasoning skills by collecting and analyzing data from The National Assessment of Educational Progress (NAEP)–also known as the “Nation’s Report Card” — available through the National Center for Educational Statistics website:
It takes a little “clicking” around to gain all the information you will need, so each time you find information you need, write it down before moving on to a comparison. You will need to use all the data to create your graph and make predictions about education ten years from now. Please follow the 23 steps given:
1.https://nces.ed.gov/nationsreportcard/assessments/
2.Scroll down to the squares and click on Mathematics OR Reading
3.Scroll down to the Publications at the bottom of the page and click on REPORT RELEASE of The Nation’s Report Card: 2019 for your subject.
4.Scroll down to locate “State Results” in the center of a gray box and click on “Student Group Scores.”
5.Choose Grade 4 OR Grade 8
6.Next, choose California for the state you will begin with.
7.Click on the square for White.
8.Record scores on a notepad for 2003, 2007, 2011, 2015, and 2019. Based on these scores, make a personal prediction for the year 2030. Making a table may be more helpful as you will be using this data in a spreadsheet in Excel or other program. You will then be creating a time series graph for this data.
9.Now click on the square for Black.
10.Record scores on a notepad for 2003, 2007, 2011, and 2015, and 2019. Based on these scores, make a personal prediction for the year 2030, and include that point on your time series graph.
11.Now click on the square for Hispanic.
12.Record scores on a notepad for 2003, 2007, 2011, and 2015, and 2019. Based on these scores, make a personal prediction for the year 2030, and include that point on your time series graph.
13.Then while on California, click on the dropdown menu for “Status as Students with Disabilities.”
14.Record scores on a notepad for 2003, 2007, 2011, and 2015, and 2019. Based on these scores, make a personal prediction for the year 2030, and include that point on your time series graph.
15.Then while on California, click on the dropdown menu for “Status as English Language Learners.”
16.Record scores on a notepad for 2003, 2007, 2011, and 2015, and 2019. Based on these scores, make a personal prediction for the year 2030, and include that point on your time series graph.
17.Now repeat the process of Steps #6-16 above for another state of your choice. Make sure to record the data on your notepad. Creating a table may help you as you will be inputting this data into Excel or another spreadsheet program. Please do not choose a state with limited data. Find a state that has data for all subgroups. It is permissible to have a year or two that might not have been reported.
18.Finally, repeat the process of Steps #6-16 above one more time for another state of your choice. Make sure to record the data on your notepad. Creating a table may help you as you will be inputting this data into Excel or another spreadsheet program. Please do not choose a state with limited data. Find a state that has data for all subgroups. It is permissible to have a year or two that might not have been reported.
19.Next, you will enter this data in a spreadsheet on Excel, Google Sheets, or another spreadsheet program. You will create one time series graph for each state separately. Therefore, you will have three graphs. Depending on your version of Excel, you will click on “insert” and then choose the chart that looks like lines to create a time series graph. Personally, I think Google Sheets is very user-friendly.
20.You should now have three complete graphs, one for each state, with six data points: 2003, 2007, 2011, 2015, 2019, and 2030, and lines for White, Black, Hispanic, Students with Disabilities, and English Language Learners. Make sure the titles on the graphs show the name of the state with the subject and grade you are showcasing.
21.Now in several paragraphs, explain your graphs for each state. You can copy and paste your graphs in a Word document and then write your paragraphs under each one. Be sure to include for each state an explanation of the data you found for ELL and SpEd populations. Do you feel the needs of the English Language Learners and Special Education students are being met? Are their scores in line with the scores for Whites, Blacks, and/or Hispanics? You must explain all subgroups with details in your analysis paragraphs for each state. Make sure to explain why you chose the 2030 predictions that you did.
22.Almost done: Choose ONE of the four following prompts that correlates with your choices above and then answer each question within your choice. Place your answers in one large paragraph that addresses all of the questions. Make sure to demonstrate that you have researched about NCLB and ESSA with explanations about each policy.
1.Has the educational achievement gap (between Whites, Blacks, and Hispanics) in Readingfor Grade 4 narrowed since the implementation of No Child Left Behind in 2002? Compare California to two other states to see who is being more successful in narrowing the educational achievement gap among races? Do you feel the ESSA Act of 2015 will make a difference?
2.Has the educational achievement gap (between Whites, Blacks, and Hispanics) in Readingfor Grade 8 narrowed since the implementation of No Child Left Behind in 2002? Compare California to two other states to see who is being more successful in narrowing the educational achievement gap among races? Do you feel the ESSA Act of 2015 will make a difference?
3.Has the educational achievement gap (between Whites, Blacks, and Hispanics) in Mathematicsfor Grade 4 narrowed since the implementation of No Child Left Behind in 2002? Compare California to two other states to see who is being more successful in narrowing the educational achievement gap among races? Do you feel the ESSA Act of 2015 will make a difference?
4.Has the educational achievement gap (between Whites, Blacks, and Hispanics) in Mathematicsfor Grade 8 narrowed since the implementation of No Child Left Behind in 2002? Compare California to two other states to see who is being more successful in narrowing the educational achievement gap among races? Do you feel the ESSA Act of 2015 will make a difference?