NAT Brochure 2015
Published on: Mar 3, 2016
Transcripts - NAT Brochure 2015
Division of Educational Services
Assessment and Accountability Services
Local Control and Accountability Plan (LCAP)
Needs Assessment Tool
“I have been struck by how important measurement is to improving the human condition.
You can achieve incredible progress if you set a clear goal and find a measure
that will drive progress toward that goal.”
- Bill Gates
The LCAP Needs Assessment Tool (NAT) is a Microsoft Excel-based
dashboard that displays LCAP metrics grouped by state priority and
disaggregated by subgroup. The purpose of the NAT is to improve
student achievement by identifying the students with the greatest
The NAT is designed to:
Simplify LCAP needs analysis.
Identify district and subgroup performance across all LCAP metrics
Display historical trends by subgroup.
Highlight underperforming subgroups.
Prioritize and target actions and services.
Monitor yearly progress.
All LCAP metrics are displayed in a single concise format.
Each cell displays three years of trend data for comprehensive analysis.
Cell format and stoplight indicators highlight performance.
Cell comments provide inline help.
Extra rows and columns can be unhidden to add additional metrics and subgroups.
Interpreting Cell Data
Identify the three-year trends for each metric by
The numeric value in the cell is a percent value
(i.e., 50.0 = 50.0%).
The numeric value displayed in the cell
corresponds to the year displayed in the Year
The trend line displays three years of data.
The third trend line marker corresponds to the value displayed in the cell.
The first two trend line markers display the previous two years of data.
The cell height is the y-axis for the trend line.
- The top of the cell represents 100%.
- The bottom of the cell represents 0%.
Assess the relative performance of subgroups
compared to the district mean.
The pink cell shading indicates that the
subgroup’s value is below the district value for
that specific metric.
The stoplights indicate overall subgroup
performance for a given state priority relative to
the district mean.
Green: All metrics with data are above the district
Yellow: Greater than 50% or more metrics are
above the district mean.
Red: 50% or less metrics are above the district
Measure the impact of your actions and services with the growth report.
Monitor the difference between the current year and the previous for each metric and subgroup.
NAT Data Population
We can populate your NAT with your data.
Commonly Asked Questions
Is the Needs Assessment Tool free?
The blank NAT is free and ready to populate.
Where can I get the NAT?
The NAT can be found at:
For additional information, please contact:
Steve Ayon, Coordinator
Assessment and Acountability Services