Block Two : Analyzing A-F Accountability Data: Pivot Tables 101

jul 25, 2019: 1:15 p.m. - 2:45 p.m.

Designed to support school and district leaders in data-driven decision making, this introductory Excel workshop provides an overview of Excel Pivot Tables and how to use them for data analysis that drives program and instructional goal setting, planning and decision-making. Prior to the training, participants should download the A-F Static data file from the Arizona Department of Education's ADE Connect, sample data will be available to participants who do not have access to this data file to ensure their participation.

To maximize learning and participation, a laptop is essential for participants to work with their data.

Participants will utilize A-F accountability data to:

1. Analyze proficiency and growth data using Excel Pivot Tables.

2. Create visual displays of results to share with teachers and other stakeholders using Pivot Charts.

3. Create SMART goals that address school wide and subgroup population needs


Dr. Ildi Lazcko-Kerr