Sparklines Scatterplots and Slicers meet SWD Gain insight

Sparklines, Scatterplots and Slicers meet SWD Gain insight into your decision making with Excel 2010 charts and data analysis tools. Jackie Mc. Cann & Linda Curry Middle GA GLRS 478 -475 -8630 jmccann@mgresa. us, lcurry@mgresa. us

Our goals for Today: • Examine the new Excel 2010 features: sparklines, slicers and data bars • Examine the uses of conditional formatting to add meaning to tables • Examine the Scatterplot feature with Chart Labels • Examine the uses of Slicers, new with Excel 2010, on Pivot tables • Examine ways that Pivot Tables can make data analysis easier. Middle GA GLRS 2

Sparklines – Focus on Systems – Focus on Schools – Focus on Students – Choose students for CRCT-m with Sparklines – Look at student trends with Sparklines – Customizing Sparklines – Examples – Activity: Create Sparklines for SWD Math students Middle GA GLRS 3

Middle GA GLRS 4

Middle GA GLRS 5

Conditional Formatting Adds Meaning to Tables • • Setting the rules Using preset rules Examples Activity: Use conditional formatting on a set of student level data. Middle GA GLRS 6

CRCT Score Range Format color 650 -789 Red 790 -810 Yellow 811 -849 Clear 850 -950 Green Middle GA GLRS 7

Scatterplots with Chart Labels Non-SWD and SWD • • Focus on Systems Focus on Schools Focus on Grade Levels Installing the XY Chart. Labeler: http: //www. appspro. com/Utilities. htm Using custom markers Activity: Create a scatterplot for Grade 3 students SWD and Non-SWD Middle GA GLRS 8

CRCT 2010 Reading vs. Math Grade 3 100 Sys. E Sys. C Sys. B Sys. D Georgia Math % Meets or Exceeds 90 80 Sys. A 70 60 Sys. C SWD Sys. G Georgia SWD 50 Sys. E SWD Sys. F Sys. D SWD Sys. B SWD 40 30 Sys. G SWD Sys. F SWD 20 70 75 80 85 90 Reading % Meets or Exceeds Middle GA GLRS 95 100 9

Sorting and filtering with Pivot Tables • Disaggregate your data in a hurry with pivot tables and charts • Use the Slicer function to focus data from system to schools • Helps you to understand root cause • Leads you to the right intervention • Measure results after intervention • Examples • Activity: Create a pivot table and use the slicer to analyze system wide Math data Middle GA GLRS 10

Pivot Table Data Middle GA GLRS 11

Pivot Table and Chart with Grade, Ethnicity, and Gender Middle GA GLRS 12

Pivot Table and Charts with Slicers for Class Teachers Middle GA GLRS 13

Middle GA GLRS 14

Production Tips • Creating Templates to save time • Creating series of tables and charts with Pivot Tables • Using chart templates to add charts to your tables Middle GA GLRS 15

Lexiles and Line Charts • • Lexiles and Line Charts Look at domains with Line Charts The importance of comparison to GA Examples Middle GA GLRS 16

Average Lexile Score CRCT 2010 GA Avg. Lexile GA SWD Avg. Lexile RESA Sys. AVG. 1400 1200 Average Lexile Score 1000 800 600 400 200 0 GR 1 GA Avg. Lexile 144 GA SWD Avg. Lexile 31 RESA Sys. AVG. 200 GR 2 421 193 500 GR 3 656 507 750 GR 4 778 608 850 GR 5 870 692 950 GR 6 941 755 1000 GR 7 998 839 1100 GR 8 1109 921 1200 Grade Level Middle GA GLRS 17

Average Lexile Score CRCT 2010 GA Avg. Lexile GA SWD Avg. Lexile 1200 Average Lexile Score 1000 800 600 400 200 0 GA Avg. Lexile GA SWD Avg. Lexile GR 1 144 31 GR 2 421 193 GR 3 656 507 GR 4 778 608 GR 5 870 692 GR 6 941 755 GR 7 998 839 GR 8 1109 921 Grade Level Middle GA GLRS 18

LRE passes the bar • • LRE bar charts for systems LRE bar charts for schools Examples Activity: Create a LRE bar chart from Data Warehouse Data Middle GA GLRS 19

MIDDLE GEORGIA RESA SWD Environment % of Time in Classroom Student Count Less Than 40 Percent Between 40 and 79 Percent Over 80 Percent 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 2010 2009 2008 Over 80 Percent 97, 766 102, 569 99, 563 Between 40 and 79 Percent 39, 811 35, 419 32, 838 Less Than 40 Percent 34, 664 28, 540 26, 766 2007 99, 049 31, 653 25, 036 Middle GA GLRS 2010 2, 545 1, 300 639 2009 2, 790 989 598 2008 2, 766 913 536 0% 2007 2, 620 881 544 20

Our goals for Today: • Examine the new Excel 2010 feature, sparklines • Examine the uses of conditional formatting to add meaning to tables • Examine the Scatterplot feature with Chart Labels • Examine the uses of Slicers, new with Excel 2010, on Pivot tables • Examine ways that Pivot Tables can make data analysis easier. Middle GA GLRS 21

Sparklines, Scatterplots and Slicers meet SWD Jackie Mc. Cann & Linda Curry Middle GA GLRS 478 -475 -8630 jmccann@mgresa. us lcurry@mgresa. us