college and career readiness dashboard (ccr) - … and development/cc… · · 2017-05-03how do i...
TRANSCRIPT
DEPARTMENT OF
EDUCATION
RESEARCH AND DEVELOPMENT
College and Career Readiness Dashboard
(CCR) ____________________________________________
User Guide
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
2
Contents
Revision History .............................................................................................................. 3
Revision History Chart ..................................................................................................... 3
1. How do I get started? ................................................................................................. 4
2. How do I use the CCR Dashboard? ............................................................................ 5
3. How do I use the main data grid? ............................................................................... 9
4. How do I download data to local files? ...................................................................... 11
5. What are the Column Names and Description? ........................................................ 12
6. Data Availability ........................................................................................................ 17
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
3
Revision History
Every change to this document, subsequent to initial sign-off, must be recorded in the Revision History Chart below. There are no exceptions. Note that the Project Manager must sign off on any changes to this document.
Revision History Chart
Date Version Description Owner
7/17/2015 1.0 College and Career Readiness Dashboard(CCR)
Dr. Tony Thacker
11/13/2015 2.0 Added a section on Data Availability Dr. Tony Thacker
08/02/2016 3.0 Updated screenshots for Phase II changes Dr. Tony Thacker
05/02/2017 4.0 Updated screenshots in section 1, added data grid info in section 2 and updated field names in section 5.
Dr. Tony Thacker
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
4
1. How do I get started? Logging into the AIM: ALSE Identity Management Portal: Enter https://aim.alsde.edu into the
address line of your browser. You will be presented with a screen similar to the following. Click
the College and Career Readiness tile:
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
5
2. How do I use the CCR Dashboard? If you have the proper credentials, you should see a tile labeled “CCR College and
Career Readiness”. Click the tile. You will be presented a screen similar to this:
Select the desired Base Year, System, School & Sub Population from the drop down lists and click ‘Submit’. Note: Depending on your access level, the drop down lists may be limited to certain schools and systems. Drop down list descriptions:
The School Year – Contains three columns: o Cohort Year – This is the year that the student entered the 9th grade for
the first time (Base Cohort) o Grad Year – The graduating year of the Base Cohort (4 years) o Official Cohort – Identifies whether updates are still taking place for that
year. False means data for that cohort is being updated daily via Accumulator processing. True means that processing has ended for that cohort.
School System o LEA users will see the school system(s) to which they are assigned in the
Education Directory (Ed Dir) o ALSDE users will see all school districts and will have a statewide option
School o Will be filtered to the schools present in the School System selected in the
step above
The sub population consists of the following: o All Students o American Indian or Alaskan Native o Asian o Black of African American o Female
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
6
o Hispanic/Latino o Homeless o LEP o Male o Migrant o Native Hawaiian or Other Pacific Islander o Not Homeless o Not LEP o Not Migrant o Not Poverty o Not Special Ed o Not Specified (race) o Poverty o Special Ed o Two or More Races o White
You will then be presented a screen similar to this:
Each of the gauges represent the following according to the items selected in the drop down lists: Enrollment:
Overall – The percentage of all students meeting any Assessment benchmark of those with a matching test score.
ACT – The percentage of all students meeting any ACT benchmark of those students taking ACT test.
IB – The percentage of all students meeting any International Baccalaureate benchmark of those students taking IB courses.
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
7
AP – The percentage of all students meeting any Advanced Placement benchmark of those taking AP courses.
ACT Work Keys – not available yet
College Credit – The percentage of all students designated as meeting college credit CCR benchmark.
Career Tech Credential – The percentage of all students designated as meeting Career Tech CCR benchmark.
Military - The percentage of all students designated as meeting military CCR benchmark.
Graduates:
Overall – The percentage of graduate students meeting any Assessment benchmark of those with a matching test score.
ACT – The percentage of graduate students meeting any ACT benchmark of those students taking ACT test.
IB – The percentage of graduate students meeting any International Baccalaureate benchmark of those students taking IB courses.
AP – The percentage of graduate students meeting any Advanced Placement benchmark of those taking AP courses.
ACT Work Keys – not available yet
College Credit – The percentage of graduate students designated as meeting college credit CCR benchmark.
Career Tech Credential – The percentage of graduate students designated as meeting Career Tech CCR benchmark.
Military - The percentage of graduate students designated as meeting military CCR benchmark.
To see the numeric value of each of the gauges, hover the cursor over the desired gauge for several seconds. The numeric percentage will be displayed. The numeric indicators beneath the gauges indicate the number of students that are in the population (the denominator) and the number of students meeting the CCR benchmark (in the case of the Assessment data). The INow ‘In Population’ count is the student population selected by the drop down lists. This count is displayed at the bottom of the main grid. *Note: School year 2013-2014 is the first year the ACT was administered to all 11th grade students in the State of Alabama.
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
8
Immediately under the gauges you will find a data grid containing the student level data that makes up the totals reported in the gauges. The base view of the data grid contains the following columns:
System Code
School Code
SSID
First Name
Last Name
ALSDE Exit Type
Federal Exit Type
Is Poverty
Race
Sex
ACTa
IBa
APa
ACT Work Keysa
College Creditb
Career Techb
Militaryb
Grade aACT, IB, AP and ACT Work Key data comes from testing information provided by the testing agencies. bCollege Credit, Career Tech and Military information comes from the INOW application and is based on user input at the local level. These fields will contain “Yes/No/blank” which will correspond to checked/unchecked/null values in the INOW checkbox fields.
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
9
3. How do I use the main data grid? If desired, the grid can be customized by choosing which columns are displayed using the ‘Field Chooser’. Use the ‘Select Fields’ button to open the field chooser. The customization window displays headers of hidden columns. To hide a column, end-users should drag its header to the customization window. ● To hide a grid column, drag its header to the customization window. ● To make a column visible, drag its header from the customization window back to the Grid's header panel. The Grid allows you to sort data displayed within an unlimited number of columns. The column's current sort order is indicated by a sort glyph (▼) displayed at the column header's right edge. If the column isn't sorted, the sort glyph is hidden. Click the column's header to sort data against a data column or change the column's sort order. To sort data against multiple columns, click column headers with the SHIFT key pressed down. The Filter Row allows an end-user to filter data by typing text directly into the row. A filter condition can be applied automatically based on the value entered. The filter condition can be selected from the context menu, which is invoked by clicking a filter row button.
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
10
A Group panel displays headers of data columns involved in data grouping. End-users can group data by dragging column headers onto it.
Group rows are used to organize data rows into a tree when data grouping is applied. A group row contains a group expand button that enables end-users to expand and collapse the group row, as well as show or hide its child rows. Group rows can also display group summary values.
The Pager enables end-users to navigate through Grid data. It consists of navigation buttons: "next", "last", "previous", "first", an indicator that displays the current page number, the total number of pages, and page size item allowing end-users to specify the number of items displayed on a page.
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
11
4. How do I download data to local files? To download the grid’s data to a file on your local machine, first select the columns and data desired then position the cursor over the “Export to XLS” button just above the data grid. A dialog box will appear asking if you would like to Save or Open the file
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
12
5. What are the Column Names and Description? The following table lists the columns available to be selected via the ‘field chooser’ (described above):
Column Name Description
CCR Create Date Date that CCR student summary record was last processed
System Code Numeric system code that school is in
School Code Numeric school
SSID Student’s ID Number
First Name Student’s first name
Last Name Student’s last name
Race Student’s race
Sex Student’s sex
Grade Student’s grade
Date Of Birth Student’s date of birth
Is Hispanic Student’s Hispanic indicator
Is Homeless Student’s homeless indicator
Is Immigrant Student’s immigrant indicator
Is LEP Student’s Limited English Proficiency indicator
Is Migrant Student’s migrant indicator
Is Single Parent Student’s single parent indicator
Is Special Ed Student’s special ed indicator
Primary Exceptionality Student’s primary exceptionality (Spec Ed)
Is Poverty Student’s poverty indicator
Lunch Code Student’s lunch code
ALSDE Exit Type Student’s exit type based on the ALSDE graduate calculation. Applies to academic year 2016 graduates and prior.
Federal Exit Type Student’s exit type based on the Federal graduate calculation. Applies to academic year 2016 graduates forward.
Exit Type Cat Student’s exit type category (graduate, completer, etc.)
Current Status Student’s current status (Withdrawn, Dropout, Enrolled, etc.)
Base Cohort Year Student entered 9th grade
Official Cohort True once cohort year is closed for updates
has CCRS AP Attainment True if INow CCRS Advanced Placement Attainment indicator is checked
has CCRS IB Attainment True if INow CCRS International Baccalaureate Attainment indicator is checked
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
13
has CCRS ACT Attainment True if INow CCRS ACT Attainment indicator is checked
has CCRS College Credit Attainment True if INow CCRS College Credit Attainment indicator is checked
has CCRS Career Tech Credential Attainment
True if INow CCRS Career Tech Credential Attainment indicator is checked
has CCRS Military Attainment True if INow CCRS Military Attainment indicator is checked
ACT Scale Scores Comp Student's ACT Composite Score
ACT Scale Scores English Student's ACT English Score
ACT Scale Scores Reading Student's ACT Reading Score
ACT Scale Scores Math Student's ACT Math Score
ACT Scale Scores Science Student's ACT Science Score
ACT CCR True if student met any ACT benchmark
ACT In Population True if a matching ACT record is found for student (matching SSID)
ACT Test Date ACT testing date
IB Biology Student's International Baccalaureate Biology score
IB Chemistry Student's International Baccalaureate Chemistry score
IB Computer Sc Student's International Baccalaureate ComputerSc score
IB Dance Student's International Baccalaureate Dance score
IB Design Tech Student's International Baccalaureate DesignTech score
IB Economics Student's International Baccalaureate Economics score
IB Engilish A Student's International Baccalaureate EngilishA score
IB English A Lal Student's International Baccalaureate EnglishALal score
IB English A Lit Student's International Baccalaureate EnglishALit score
IB Env And Soc Student's International Baccalaureate EnvAndSoc score
IB Film Student's International Baccalaureate Film score
IB French AB Student's International Baccalaureate FrenchAB score
IB French B Student's International Baccalaureate FrenchB score
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
14
IB Geography Student's International Baccalaureate Geography score
IB German AB Student's International Baccalaureate GermanAB score
IB German B Student's International Baccalaureate GermanB score
IB History Student's International Baccalaureate History score
IB Latin Student's International Baccalaureate Latin score
IB Math Studies Student's International Baccalaureate Studies score
IB Mathematics Student's International Baccalaureate Mathematics score
IB Music Student's International Baccalaureate Music score
IB Peace Con St Student's International Baccalaureate PeaceConSt score
IB Philosophy Student's International Baccalaureate Philosophy score
IB Physics Student's International Baccalaureate Physics score
IB Politics Student's International Baccalaureate Politics score
IB Psychology Student's International Baccalaureate Psychology score
IB Soc Cul Anth Student's International Baccalaureate SocCulAnth score
IB Spanish AB Student's International Baccalaureate SpanishAB score
IB Spanish B Student's International Baccalaureate SpanishB score
IB Sports Ex Sci Student's International Baccalaureate SportsExSci score
IB Theatre Student's International Baccalaureate Theatre score
IB Theory Knowl Student's International Baccalaureate TheoryKnowl score
IB Visual Arts Student's International Baccalaureate VisualArts score
IB Wld Studies Student's International Baccalaureate WldStudies score
IB World Relig Student's International Baccalaureate WorldRelig score
IB CCR True if student met any International Baccalaureate benchmark
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
15
IB In Population True if a matching IB records are found for student (matching SSID)
IB Report Date International Baccalaureate scores reporting date
AP Arthisgr Student's Advanced Placement Arthisgr score
AP Artstdgr Student's Advanced Placement Artstdgr score
AP Artst2gr Student's Advanced Placement Artst2gr score
AP Art3dgr Student's Advanced Placement Art3dgr score
AP Biolgr Student's Advanced Placement Biolgr score
AP Calcabgr Student's Advanced Placement Calcabgr score
AP Calcbcgr Student's Advanced Placement Calcbcgr score
AP Chemgr Student's Advanced Placement Chemgr score
AP Chinesgr Student's Advanced Placement Chinesgr score
AP Comscagr Student's Advanced Placement Comscagr score
AP Comscbgr Student's Advanced Placement Comscbgr score
AP Econmagr Student's Advanced Placement Econmagr score
AP Econmigr Student's Advanced Placement Econmigr score
AP Englangr Student's Advanced Placement Englangr score
AP Englitgr Student's Advanced Placement Englitgr score
AP Envscigr Student's Advanced Placement Envscigr score
AP Eurhisgr Student's Advanced Placement Eurhisgr score
AP Frnlangr Student's Advanced Placement Frnlangr score
AP Frenltgr Student's Advanced Placement Frenltgr score
AP Gerlagr Student's Advanced Placement Gerlagr score
AP Govcomgr Student's Advanced Placement Govcomgr score
AP Govusgr Student's Advanced Placement Govusgr score
AP Humgeogr Student's Advanced Placement Humgeogr score
AP Italgr Student's Advanced Placement Italgr score
AP Japangr Student's Advanced Placement Japangr score
AP Latinvgr Student's Advanced Placement Latinvgr score
AP Latincgr Student's Advanced Placement Latincgr score
AP Musictgr Student's Advanced Placement Musictgr score
AP Physbgr Student's Advanced Placement Physbgr score
AP Physmgr Student's Advanced Placement Physmgr score
AP Physemgr Student's Advanced Placement Physemgr score
AP Psychgr Student's Advanced Placement Psychgr score
AP Spanlagr Student's Advanced Placement Spanlagr score
AP Spanltgr Student's Advanced Placement Spanltgr score
AP Statgr Student's Advanced Placement Statgr score
AP Ushistgr Student's Advanced Placement Ushistgr score
AP Wdhistgr Student's Advanced Placement Wdhistgr score
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
16
AP CCR True if student met any Advanced Placement benchmark
AP In Population True if a matching AP records are found for student (matching SSID)
AP Report Date Advanced Placement scores reporting date
ACTWk Applied Math Score Student's ACT Work Keys Applied Math Score
ACTWk Applied Math Ex Score Student's ACT Work Keys Math Ex Score
ACTWk Applied Tech Score Student's ACT Work Keys Applied Tech Score
ACTWk Bus Writing Score Student's ACT Work Keys Bus Writing Score
ACTWk Listening Score Student's ACT Work Keys Listening Score
ACTWk Locat Info Score Student's ACT Work Keys Locating Information Score
ACTWk Listen Under Score Student's ACT Work Keys Listen Under Score
ACTWk Observation Score Student's ACT Work Keys Observation Score
ACTWk Read For Info Score Student's ACT Work Keys Reading For Information Score
ACTWk Read For Info Ext Score Student's ACT Work Keys Info Ext Score
ACTWk Teamwork Score Student's ACT Work Keys Teamwork Score
ACTWk Writing Score Student's ACT Work Keys Writing Score
ACTWk Work Place Obs Score Student's ACT Work Keys Place Obs Score
ACTWk Performance Score Student's ACT Work Keys Performance Score
ACTWk Talent Score Student's ACT Work Keys Talent Score
ACTWk Fit Score Student's ACT Work Keys Fit Score
ACTWk In Population True if a matching ACT Work keys record is found for student (matching SSID)
ACTWk CCR True if student met any ACT Work Keys benchmark
ACTWk Certificate Level Certificate earned by the student based scores in the three core tests: Applied Mathematics, Locating Information and Reading for Information
ACTWk Test Date ACT Work Keys testing date
Note: Several fields will have a corresponding “display” field as well. These fields will contain “Yes/No/blank” which will correspond to checked/unchecked/null values that the checkbox fields contain.
College and Career Readiness Dashboard (CCR) Last Modified: 5/3/2017 9:51 AM
User Guide
17
6. Data Availability The data used in the CCR application is supplied by various entities including testing
organizations and LEAs through the Accumulator process. The following chart provides
information on the time of the year that each data element is loaded.
Data Type Time Period Available
ACT August
ACT WorkKeys August
Advanced Placement (AP) August
International Baccalaureate (IB) November
College Credit Continuous. Entered by the LEAs and updated during the nightly replication process.
Career Tech Credential Continuous. Entered by the LEAs and updated during the nightly replication process.
Military Continuous. Entered by the LEAs and updated during the nightly replication process.