Career Cruising CAMS

1
Career CruisingCAMS

• EDP Completion
• Report Training
• January 18, 2008
• Presented by Cynthia Scherphorn

2
CAMS Login
Login to your building database for collecting
EDP report information.
3
CAMS Login
Select EDP Completion Reports from the blue links
on the left-hand side.
4
EDP Completion Reports
Select EDP Completion Status by Student from the
menu of reports available.
5
EDP Completion Status by Student
Select desired grade level. You will need to
repeat this step for every required grade level
report.
6
EDP Grade Level Standards
Check the grade level standards confirm
necessary minimum standards are represented.
7
Exporting Student Data
Select Excel Spreadsheet and click the gray
Export button. Click Open
8
Formatting Student Data
The export will automatically open a new Excel
workbook.
9
Save As - Type
Select Microsoft Excel as the Save as type.
10
Save As - Place
Select your preferred destination for saving the
Excel file.
11
Save As File Name
Type in the file name. If you are working with
multiple data sources for your district I suggest
you Save As District/ Building and then create
multiple worksheets within the workbook.
12
Setup for Pivot Table (Step 1)
Create an additional column and title it Count.
Type a number 1 in the open cell and click on the
lower right-hand corner of the cell. Holding the
mouse down, drag the box to the bottom of the
numbered cells.
13
Setup (Step 2)
When you release the mouse the action will
automatically generate a number 1 in each cell.
14
Pivot Table Creation (Step 1)
To create the Pivot Table, first click on the
open cell between 1 and A. This will select the
entire set of data. Click on Data at the top
and select Pivot Table and Pivot Table Chart
from the drop-down menu.
15
Pivot Table (Step 2)
Click on the Next button.
16
Pivot Table (Step 3)
Click on the Next button.
17
Pivot Table (Step 4)
Click on the Layout button.
18
Selecting Pivot Table Data (Step 1)
To select data you will click and drag the items
needed.
19
Pivot Table Data (Step 2)

• Click on Count and drag to the center Data
  section.
• Click on Student Name and drag to the Row
  section.
• Click on the Ok button.

20
Pivot Table Data (Step 3)
Click on the Finish button.
21
Student Data Duplication Sort
The Pivot Table creates the new worksheet in the
existing workbook that you are working with. The
student data is now numbered with a count of
repetitions existing within the data.
22
Locate Duplicate Student Info
Locate the duplicated student information.
23
Clean Excel File Information
You will need to return to your original student
data exported from Career Cruising and remove one
of the student files. This does not remove it
from the Career Cruising online database. Once
the data is clean and complete with each grade
level, Save the file. Attach the Excel file to
an email and send the report to the designated
contact at Oakland Schools.
24
Submitting EDP Excel Information

• Attach the Excel file to an email.
• Provide the district name.
• Provide the name of the individual responsible
  for the collection and reporting of EDP
  information.

25
Resource Career Cruising EDP Completion Standards
26
Resource Oakland Schools EDP Evidence Standards
27
Resource CAMS Guide
28
Resource CODC Contacts
29
Timeline / Suggestions

• When working with a group of students capture the
  EDP evidence at the end of the update session.
  Students can change the information after you
  have seen them.
• Mid-year data submission is the end of February.
• April training for end-of-year data submission
  due the first week in June.

30
Thank You

• Questions ???
• Evaluation
• Training Contact Information
  Cynthia Scherphorn cynthia.scherphorn_at_oakland.k12.
  mi.us 248.209.2271