This video walks you through downloading the spreadsheet, completing the spreadsheet, and submitting points.
CCRI Instructional Video – Per SBE, the minimum n-count has been changed to 10 students in cohort 2018 who meet the modified “FAY” definition below
Frequently Asked Questions
On May 8th, the self-report spreadsheet for Career and College Readiness Indicators was released on ADEConnect. There is a minimum n-count of 10 students in order to be eligible for College and Career Readiness points.
The submission application, “Accountability—A-F CCRI Self-Reporting Score,” is now open. This is where schools submit points they earned on the College and Career Ready indicator to ADE. The Entity Administrators will be given the rights to grant access to the new role of “Accountability—A-F CCRI Self-Reporting” and will assign the role to the Superintendent, Principal, and/or Assistant Principal. Ultimately, the Superintendent and Principal will be held accountable for whomever enters the score for the school. The Superintendent and Principal hereby attest to the accuracy and completeness of the “Points Earned” entered on the website. Any person who knowingly makes, uses, or causes to be made or used, a false record is subject to criminal and civil penalties.
To access the application, login to ADEConnect and select “Accountability—A-F CCRI Self-Reporting Score.” If you do not see this option, you will need to request that your entity administrator assign the appropriate role to you.
Included below are some of the most common technical difficulties and questions we have received for the CCRI spreadsheet in ADEConnect. Questions on reporting, retaining, and business rules were provided by the State Board of Education. This FAQ document is a living document and will also be posted on our website along with instructions for the submission application. It will be updated as we receive answers from the SBE. For general instructions, select the first worksheet within the Excel spreadsheet or view instructions here.
Spreadsheet Technical Difficulties
I’m only able to enter 11 students. After that, the page won’t scroll down. What do I do? Check to make sure you are on the correct worksheet within excel. The first worksheet is the instructions page. This will only allow you to enter 11 students as it was only intended to be used as an example. Select the second worksheet on the bottom left of the screen titled “Self Reporting.” If the problem persists, email [email protected] and include screenshots of the issue you are having so we can better assist you.
I can’t view the columns under the indicator to enter my SSIDs. How do I fix my view? If you already have an Excel worksheet open, it may have automatically minimized both worksheets. Click the expand button at the top corner of your screen.
When I open the spreadsheet, all these comments pop up and I can’t see that actual spreadsheet. How do I get these pop-ups to minimize? Select “File” in the top left corner, select “Options,” select “Advanced,” scroll down to “Display” and make sure under “For cells with comments, show:” the second option is selected “Indicators only, and comments on hover.”
If you have any other technical difficulties, please email [email protected] In your email let us know what version of Excel you have and provide a screenshot of the issue, where applicable.
**New: Who should I include in the spreadsheet/who counts as a senior? Schools should include cohort 2018 students that entered their school by October 1 and stayed enrolled until May 1 or students that are part of cohort 2018 and graduated early. This is basically a modified “FAY” definition for CCRI purposes only and includes early graduates as long as they belong to the 2018 cohort. Students that are 5-, 6-, and 7-year seniors should not be included in the spreadsheet.
Is the “School increases the percent or has 85% of postsecondary enrollment and/or military service of prior year’s graduates” based on FY 18 graduates? Should we compare FY 18 to FY 17? Separate to the rest of the spreadsheet, this indicator is based on FY 17 (and FY 16, if you are comparing both years) data.
How do I collect military enlistment data and what do I need to maintain for my records? Use your best efforts and the records should reflect accurate information. There is no prescribed form or record, however, the calculation needs to be verifiable.
Can we use National Clearinghouse or other aggregated data for this indicator or do we need data at the student level? If the National Clearinghouse or other aggregated data gives you the information you need to calculate this measure, use it.
Can we use ADEConnect’s Postsecondary Enrollment Report for this indicator? Per ADE—The report in ADEConnect can be used, but keep in mind it is not a static file and may change over time. This data has also not been updated recently and may not reflect current enrollment data.
What is the cut-off date to complete the 120 hours of an internship? All data must be entered by July 13, 2018. All internships should be completed prior to this date.
The number of cohort 2018 students at my school is less than the minimum n-size (10). Do I still need to fill out the spreadsheet and submit the self-reported CCRI points earned? No, you do not. In ADEConnect, there is a submission option of “NA” or “Not Available” that should be entered to identify that your school does not meet the minimum requirement. If you do not enter “NA,” we will have to assume you did not calculate your grade and assign your school 0/20 points instead of being ineligible for the points and being rated out of 80 total points.
What do I do if I serve high school grades but don’t graduate students/don’t currently have any cohort 2018 students? Do I miss out on these points? If you do not graduate students, you will not be eligible for the CCRI points. See the business rules document to see which model will be used for your school if you do not serve grade 12. The business rules document is available under the “A-F School Accountability” on the State Board of Education website. Your school will be rated out of 80 points assuming you meet the minimum n-count for all other indicators. However, if you are not graduating students you will not meet the Graduation Rate indicator either and your school will not be eligible for 80 points and will not be rated this year.
What are the ABOR 16 credit requirements? The 16 program of study requirements are 4 high school credits in English, 4 high school credits in college preparatory mathematics (including Algebra I and II, Geometry, and culminating in 1 credit of advanced mathematics for which Algebra II is a prerequisite), 3 high school credits in Laboratory Science courses, 2 high school credits in the same Foreign Language, 2 high school credits in Social Science courses, and 1 high school credit in Fine Arts or Career or Technical education.
Is WritePlacer included in the Accuplacer English indicator? Yes, this test has been included for FY 18.
What counts as a “Nationally Recognized placement exam” under the COMPASS Indicator? If schools have any specific exams they would like to have included under this indicator, they should email [email protected] with the name of the exam and it will be forwarded to the Board for review/consideration.
If students pass with a “P,” can they be included in indicators that require a passing grade? Yes, the student can be included.
Helpful Guides on How/Where to Get Data
CCRI Self-Report Notice and General Instructions
On April 24th, the Arizona State Board of Education adopted a new A-F Accountability plan which will be used to issue letter grades for the 2016-17 school year. Detailed information on the new accountability models can be found on the State Board website. The 9-12 model contains a College and Career Readiness Indicator (CCRI) to assess graduates’ readiness to successfully participate in postsecondary opportunities. The CCRI counts as 20% of a high school’s letter grade and contains multiple indicators for which students can earn points. As the Arizona Department of Education does not collect data for many of these indicators, each school/district will need to self-report the CCRI points earned for cohort 2018 students. To assist LEAs in this process, a CCRI Self-Report Spreadsheet has been created.
The CCRI Self-Report Spreadsheet will be available to download through ADEConnect on May 9th. To access the spreadsheet, logon to ADEConnect and select “Accountability” under the menu. If you do not see “Accountability,” you will need to request permission from your entity administrator. Under “State and Federal Accountability Applications,” select “A-F College and Career Readiness Indicator Self Reporting Spreadsheet.” Select the link to download the CCRI Self-Report Spreadsheet and instructions.
Schools serving grades 9-12 will be able to download and complete the spreadsheet in order to calculate the number of points earned toward the CCRI portion of their letter grade. At a later date, a separate application will open in ADEConnect that will allow schools/districts to report the number of CCRI points earned for their school. Important dates for the CCRI are listed in the table below. Please note: the window for submitting CCRI points extends beyond the final date for verifying all other data in AzEDS used to calculate final letter grades. All data within AzEDS must still be finalized by July 13th, 2018.
Instructions for completing the spreadsheet are available on the first worksheet tab (titled “Instructions”) within the excel document and also included below.
|CCRI Self-Report Spreadsheet Available||May 8th, 2018|
|CCRI Self-Report Submission Window Opens||May 8th, 2018|
|Last day to verify all other data for Final Letter Grades||
July 13th, 2018
|Last day to Submit CCRI Self-Report for Final Letter Grade||
July 13th, 2018
|*all information is due by end of day or 5:00pm|
The CCRI Self-Report Spreadsheet should be filled out and the total points earned submitted no later than end of day, JULY 13th. The spreadsheet will include clickable arrows (numbered 1-17) to jump directly to the item in the instructions. Cells that should be filled with data are colored light green. If an unacceptable response is entered, an error message will appear with the acceptable responses. Points are calculated automatically after each entry. RETAIN FINAL SPREADSHEET AND SUPPORTING DOCUMENTATION AND ALL OTHER RECORDS RELATED TO CALCULATIONS OF THE COLLEGE AND CAREER READINESS POINTS FOR INSPECTION AND AUDIT BY THE STATE, CONSISTENT WITH RECORD RETENTION POLICIES.
1 District – Enter your district or charter holder name. 2 School – Enter school name. Note: one school per spreadsheet. 3 Entered By – Enter your name. THE AUTHORIZED REPRESENTATIVE HEREBY ATTESTS TO THE ACCURACY AND COMPLETENESS OF THE DATA PROVIDED. ANY PERSON WHO KNOWINGLY MAKES, USES, OR CAUSES TO BE MADE OR USED, A FALSE RECORD IS SUBJECT TO CRIMINAL AND CIVIL PENALTIES. 4 Approved By – Enter the name of the person that has approved the document. The “Approved By” name listed here should match the name of the person that will enter the “Points Earned” on the ADEConnect website. THE AUTHORIZED REPRESENTATIVE HEREBY ATTESTS TO THE ACCURACY AND COMPLETENESS OF THE DATA PROVIDED. ANY PERSON WHO KNOWINGLY MAKES, USES, OR CAUSES TO BE MADE OR USED, A FALSE RECORD IS SUBJECT TO CRIMINAL AND CIVIL PENALTIES. 5 Number of cohort 2018 students – Enter the total number of cohort 2018 students for the 2017-2018 school year. If this box is left empty or does not match the number of student records you enter in the spreadsheet, it will turn red and have the following error message to the left: “Total students must be equal to the count of SSIDs.” The total points earned (#9) will not be calculated until this error is corrected. If the count of SSIDs entered is less than the number of cohort 2018 students you have filled out, you will receive a yellow error message in cell E9 that says “SSID Count < # of cohort 2018 students.” Make sure you are entering the SSID of each student that is in cohort 2018 and was enrolled from October 1st, 2017 to May 1st, 2018 (or graduated early) – regardless of whether they meet any of the indicators – to insure this number matches with the number of SSIDs. 6 a) SSID – Enter the SSID of each cohort 2018 student. After you click “Enter” the rest of the row will populate so you can mark the appropriate indicators. If the student does not meet any of the indicators, simply leave the row blank and click on the next cell under “SSID” to enter the next student. To correct a SSID, highlight the cell by clicking on it, enter the correct ID, and hit “Enter”. If a student’s SSID is deleted, the entered indicator amounts will remain. Manually delete your indicator responses for the deleted SSID. If you accidently delete a SSID, the indicator responses will still remain populated. Re-enter the SSID in that column. b) If a SSID cell is red, there is a duplicate SSID already entered in the spreadsheet. Cell E6 shows how many duplicate SSIDs you currently have. Check to make sure you haven’t already entered the SSID erroneously in the spreadsheet and correct the ID or delete the duplicate submission. We recommend entering each student’s CCRI information before entering the next SSID so you don’t lose track of the row for which you are entering data. 7 Enter a response for each indicator that the student meets. There are three different types of responses for the indicators. Each type is detailed below in the “Notes” section. 8 If your school meets this bonus, you will receive 1 bonus point in the “Points Earned” cell. Note: This calculation will not be done for you. You will need to calculate whether there has been an increase in the percent of students from the prior fiscal year to the current fiscal year or a total of 85% of students in post-secondary enrollment and/or military service. 9 a) This is the total number of CCRI points your school has earned. Ensure that no cells are highlighted, the total number of cohort 2018 students matches the number of SSIDs entered, and no error messages are showing up. This is the number that should be reported to ADE through ADEConnect before end of day JULY 13, 2017. RETAIN THE FINAL SPREADSHEET, SUPPORTING DOCUMENTATION, AND ALL OTHER RECORDS RELATED TO CALCULATIONS OF THE COLLEGE AND CAREER READINESS POINTS FOR INSPECTION AND AUDIT BY THE STATE, CONSISTENT WITH RECORD RETENTION POLICIES.
b) These are the bonus points earned in H5. A school can earn either 1 or 0 points.
10 Enter Type – This indicates the type of response needed. Each indicator can be marked “yes” in three different ways: all-or-nothing = x, a number (i.e. number of AP courses) = Total # courses, or undetermined color = “r” or “b.” 11 Red or Blue Indicator – Enter “r” or “b” to indicate whether you want the student’s points to count towards either the red or blue indicator. NOTE: To receive the maximum number of points for each student, the red/blue split indicator should be utilized to give the student 1 total points of each indicator type. For example, if the student already has 1.5 points for the blue indicator but only .75 points for red, you will want to mark it with an “r” so the student can earn you 22 points as opposed to 20. We recommend you fill out this one last so you know what option will have the most impact. If you need to change the indicator type, click on the box and enter what type you would like to switch it to (“r”or “b”) and hit “Enter.” The box will highlight the color of the new indicator type. If you need to delete your entry entirely, highlight the box and delete the letter. Trying to enter 0 or any other answer will show an error. 12 Check Box – Enter an “x” if the student satisfies this type of indicator. If the student does not, simply leave it blank. If you try to enter a “0” or anything other than an “x” in this field, an error message will pop up. If you need to get rid of your entry, just delete the “x” and hit “Enter.” 13 Quantity Indicator- Enter the number of courses, tests, or benchmarks the student has passed/achieved for the description above. If you try to enter a number greater than the accepted amount or less than 1 in this field, an error message will pop up. The maximum number you can enter is capped based on the maximum number of points you can earn for each indicator color. It is possible that a student has achieved more than the maximum number allowed for an indicator. I.e. The most points a student can earn toward the blue or red indicator is 2 points, so the maximum number entered for meeting the cut score on the AP exam is 4. If you need to get rid of your entry, just delete the number and hit “Enter.” 14 Indicator Name – This cell has the name, description of the indicator, and the cut scores of each indicator (where applicable). This indicator has different cut scores depending on when the student took the test. Make sure the student meets the cut score for the date tested. 15 Blue Indicator Points Total – This is the total for all blue-indicator points for each student. NOTE: Use these two boxes as a quick guide to determine whether to mark an item as “r” or “b” for a student. 16 Red Indicator Points Total – This is the total for all red-indicator points for each student. NOTE: Use these two boxes as a quick guide to determine whether to mark an item as “r” or “b” for a student. 17 Total of Blue and Red Indicator Points – This is the total of all the indicator points. 18 Total Score Per Student – Identifies how many points that student has earned towards your total CCRI points. The number of students that have earned points (>0) toward the CCRI is viewable in cell D6.
Please email [email protected] with any questions.