This module will provide guidance on completing section IX of PI 1303-F,
Non-Compliance with Core Indicators in state and federal initiatives.
When you are ready to begin completing the form,
click on the Non-Compliance tab.
You should then see the form itself.
The first thing you want to do is select the correct fiscal agent
and then save the workbook using the proper naming conventions.
To select the fiscal agent, select the pull-down arrow
from the Fiscal Agent cell, find and select the correct fiscal agent.
For the purposes of this demonstration, I've selected CESA 5.
Once the fiscal agent is selected, it’s time to save the workbook
using the required naming convention.
You can do this most easily by using the embedded macro.
To do this, first click on the Developer tab in the top menu bar.
Then click on the Macros icon.
The Macros menu will open.
If it looks like this, you will want to change the macros that you are seeing
to just those in this workbook.
Click on the Macros in pull-down arrow and select This Workbook.
Then select File_Save_As and click Run.
You should then get the Save As menu.
Select the location to which you want to save the workbook and click Save.
Typically, the default folder is Downloads,
so you'll need to browse to find the desired folder.
Now you’re ready to begin completing the form.
Begin by completing the Participating District(s) cell.
Since this module is for consortiums and CESAs,
all the following instructions are only for consortiums and CESAs.
If you are a single district, please watch that corresponding module.
You can key in the districts or use the macros built into the workbook.
A tip box pops up that notes a keystroke shortcut when you click in this cell,
but these don't seem to always work properly.
The best option is to use the Macro menu.
Whether using the keystroke shortcut or Macro menu,
start by going to the 13-CI-LEA-DB tab of the workbook.
The LEA tab provides a filterable and sortable list
of all districts along with their compliance status
for all core indicators and state and federal initiatives.
To isolate the districts in your consortium or CESA,
begin by applying a filter to column A.
Begin by clicking the pull-down menu arrow in cell 1A.
Click the (Select All) checkbox to deselect all the districts.
Then find and click on the checkbox for your fiscal agent.
For this demonstration, I’ll continue to use CESA 5.
Then click OK.
You should then be left with all the districts in your CESA or consortium
along with the compliance result for each core indicator
and state initiative for each district.
The next step will allow you to paste all the districts
into the Participating District(s) cell of the form.
You will want to work through all these steps at one time.
If you switch to another application or delay too long
in completing the process, you might have problems.
If that happens, just work through all these steps again.
Begin by selecting the cells with the district names in column B.
Select PD_Copy_to_Word and select Run from the Run Macros menu.
If all district cells are highlighted, meaning they have been selected, click OK.
Note instructions and click OK.
When a Word document opens, use keystroke Ctrl-M,
which means hold the Control key and press M.
If the Word document doesn't open, make sure you have saved
the Word document from the application website
into the same folder as the workbook.
If you haven't done that, go back, complete that step,
and then try to re-run the macro.
You should see the districts pop up in the Word document
but then return to the Excel workbook in the Non-Compliance tab.
This will all happen automatically, and the Word document will then close.
Make sure you have clicked in the Participating District(s) cell.
Then click on the Macros icon.
Select Paste_CSV_Format and click Run.
If you haven't already, make sure you select
the Participating District(s) cell, then click OK.
The list of participating districts should then appear in the cell.
This same macro process will be used to cut and paste the appropriate districts
into the respective non-compliance cells after filtering them.
To begin identifying the districts that are not in compliance
for each core indicator and state initiative,
return to the 13-CI-LEA-DB tab of the workbook.
From the filtered list of consortium or CESA districts,
you can now filter for non-compliant districts
for each core indicator and state initiative.
This is done similar to the way the districts themselves were filtered.
There is a column that corresponds to each core indicator.
These could be filtered to list only those districts
not in compliance with each standard.
If there are no Nos in the column, you can move to the next column.
Click on the pull-down arrow at the top of the column.
Make sure only the No box is checked, and then click OK.
What will be left are those districts from the consortium or CESA
that are not in compliance for that standard.
If it is a single district, such as in this example,
you can copy the district name, then switch over to the non-compliance tab,
and paste the district name into the corresponding cell of the form.
Or you can type the name into the form.
Then repeat this process for each of the standards.
Make sure to go back to the previous column and turn off the filter
by checking the (Select All) box and clicking OK.
That should return you to the full list of consortium or CESA districts.
Then filter each of the remaining columns that contain at least one No.
When there are multiple districts not in compliance, you can repeat
the macro process used previously to cut and paste the districts into the form.
Remember to save regularly so you don't lose your work.
Once you get the districts into the appropriate cells,
you can proceed to complete the strategies
and indicate the corresponding Cluster_POS and Activity Number
that will work to address the non-compliance.
Once parts A, B, and C have been completed, Part D needs to be completed.
Part D provides information to address any cells in the 13-CI-LEA-DB tab
that had a code other than Yes, No, N/A, or asterisks.
The purpose of part D is to ensure districts are trying to identify
why they didn't have the data needed to determine the status
of a given core indicator or state priority and then to explain what steps
will be taken to ensure that data is available and correct in future years.
There are typically understandable reasons for this to occur,
but we do need to know what those reasons are and how they will be addressed.
To see what each code means, go to the Directions tab
and scroll down toward the bottom, beginning at row 153.
As you complete this section of the grant, remember its purpose is primarily
to explain how districts will work toward compliance
with required federal core indicators and state initiatives.
[ Silence ]