CONSOLIDATED ANNUAL REPORT (CAR) TRAINING

1
CONSOLIDATED ANNUAL REPORT (CAR) TRAINING

• Presented By
• John Haigh
• Office of Vocational and Adult Education
• And
• Heather Fleck
• DTI Associates, Inc.

2
Through This Training You Will

• Receive important information regarding Perkins
  III Performance Reporting
• Learn how to prepare all CAR related documents
  through both
• Web-based Forms
• Excel-based Forms
• Learn how to approve and submit your CAR through
  the website

3
What You Should Know About Perkins III

• Updates on OVAE Activities
• Timeline for Submission
• Extensions
• Online Attestation
• Incentives and Sanctions
• Future Reporting

4
What You Should Know About Perkins III (cont.)

• The Major Components of CAR
• Financial Status Report
• Enrollment
• Performance Accountability Indicators
• Narrative

5
Preparing Your Report

• Access the homepage
• Type or Paste www.PerkinsCAR.com in your browser
• Select your state from the box marked Login
• Enter your assigned Password
• Click on the box marked SIGN IN!

6
Preparing Your Report (cont.)

• Choose your submission method
• In filling out the components of the CAR you are
  given the option of either using a Web-based or
  Excel-based approach.
• Once you have selected your method preference,
  the system will automatically load this methods
  page upon login. You can always switch methods.
• For the purposes of the training, please select
  Web-based first.

7
Web-Based Approach

• Completing CAR Components
• Upon accessing the page you will see a Table of
  Contents listing each separate component of the
  CAR
• Each component can be accessed and saved
  individually
• The components can be completed in any order

8
Web-Based Approach (cont.)

• Completing CAR Components (cont.)
• On the left hand side of the screen you are given
  links allowing you to
• Obtain Instructions
• Obtain a Submission Process Flowchart
• Print an Excel workbook of all forms with data
  entered on web forms
• Switch Submission Method
• Access the Director Approval Option
• Contact the DTI Help Desk
• Log Out

9
Web-Based Approach (cont.)

• Completing CAR Components (cont.)
• On the right hand side of the screen is a key
  explaining the icons located to the left of each
  component name on the Table of Contents
• The system will automatically change the icons to
  reflect the status of each component

10
Web-Based Approach (cont.)

• Completing CAR Components (cont.)
• To input data into the different documents,
  simply select the form from the Table of Contents
  and fill out each according to the Instructions

11
Web-Based Approach (cont.)

• Completing CAR Components (cont.)
• At the bottom of each form you will find the
  following options Reset, Save (Draft), Save
  (Final)
• To remove all data added to the form during a
  particular session, click on
• To save all data on the form while remaining
  allowed to add and/or change data, click on
• To save a completed form so that it can approved
  by the Director, click on
• Once the Director has approved the form the
  document becomes Read Only and these options
  will be replaced with

12
Web-Based Approach (cont.)

• Completing CAR Components (cont.)
• In completing the data worksheets, all
  calculations will be done automatically and all
  targets are pre-populated

The system knows these s
You enter these s
The system calculates these s
13
Web-Based Approach (cont.)

• Completing CAR Components (cont.)
• You will not be allowed to save the worksheet if
  any of the following errors exist in the data
• A Numerator entered is greater than its
  corresponding Denominator
• A cell contains an entry that is neither a number
  nor N/P
• A number is entered for any racial/ethnic
  category or special population group that is
  greater than the total number of students
  reported
• A cell is left blank (FINAL SAVES ONLY)

14
Web-Based Approach (cont.)

• Completing CAR Components (cont.)
• If errors are made on the form, you will alerted
  by the system

15

• Now well explore the
• Excel-based approach

16
Excel-Based Approach

• Completing CAR Components
• Upon accessing the page you will see a Table of
  Contents listing links to download and upload the
  CAR components

17
Excel-Based Approach (cont.)

• Completing CAR Components (cont.)
• On the left hand side of the screen you are given
  links allowing you to
• Download Instructions
• Download a Submission Process Flowchart
• View Tips for Excel Users
• Switch Submission Method
• Access the Director Approval Option
• Contact the DTI Help Desk
• Log Out

18
Excel-Based Approach (cont.)

• Completing CAR Components (cont.)
• On the right hand side of the screen is a key
  explaining the icons located to the left of each
  component name on the Table of Contents
• The system will automatically change the icons to
  reflect the status of each component

19
Excel-Based Approach (cont.)

• Completing CAR Components (cont.)
• To input data into the different documents, first
  select the link from the Table of Contents and
  follow the directions to save the document to
  your personal computer
• The Blank Accountability Workbook contains
  individual worksheets for each of the sub
  indicators

20
Excel-Based Approach (cont.)

• Completing CAR Components (cont.)
• In completing the data worksheets, all
  calculations will be done automatically and all
  targets are pre-populated

The system knows these s
You enter these s
The system calculates these s
21
Excel-Based Approach (cont.)

• Completing CAR Components (cont.)
• An error message will be activated if any of the
  following data is entered into a worksheet cell
• Data other than a number or N/P
• A numerator greater than its corresponding
  denominator
• A demographic population that is larger than the
  total number of students recorded

22
Excel-Based Approach (cont.)

• Once you have completed the Excel forms, you need
  to submit the workbooks through the website

23
Excel-Based Approach (cont.)

• Completing CAR Components (cont.)
• To upload data into the system, first select the
  link for the appropriate document
• Select Browse
• Select the appropriate form from where you have
  saved it on your personal computer
• Select Upload

24
Excel-Based Approach (cont.)

• Completing CAR Components (cont.)
• Once Excel workbooks are submitted to the
  website, data is integrated into the Web-based
  data and can be viewed through that portion of
  the website
• Be aware that uploading a workbook will overwrite
  all data either previously uploaded or entered
  via the Web-based approach. You can, however,
  upload data using the Excel-based approach and
  then modify it using the Web-based approach.

25

• Now well explore the
• Director Approval Option

This is the same whether you used the Web-based
or Excel-based approach
26
Approving Your Report

• Only the Director may approve the report
  components
• The components can be approved at any time
• While only completed components can be approved,
  the whole report need not be complete before the
  approval process begins
• The components can be approved in any order

27
Approving Your Report (cont.)

• To approve a component the Director must enter
  his/her PIN and press Approve at the bottom of
  the page

28
Approving Your Report (cont.)

• After approval the page is locked and available
  only as a Read-Only document
• Once the Director has approved the form, OVAE
  will consider it the official data for the state

29
Thank You For Participating!