Career Cruising CAMS

1. Career CruisingCAMS EDP Completion Report Training January 18, 2008 Presented by: Cynthia Scherphorn Oakland Schools CODC/Career Cruising and EDP Reports

2. CAMS Login Login to your building database for collecting EDP report information. Oakland Schools CODC/Career Cruising and EDP Reports

3. CAMS Login Select EDP Completion Reports from the blue links on the left-hand side. Oakland Schools CODC/Career Cruising and EDP Reports

4. EDP Completion Reports Select EDP Completion Status by Student from the menu of reports available. Oakland Schools CODC/Career Cruising and EDP Reports

5. EDP Completion Status by Student Select desired grade level. You will need to repeat this step for every required grade level report. Oakland Schools CODC/Career Cruising and EDP Reports

6. EDP Grade Level Standards Check the grade level standards; confirm necessary minimum standards are represented. Oakland Schools CODC/Career Cruising and EDP Reports

7. Exporting Student Data Select Excel Spreadsheet and click the gray “Export” button. Click “Open” Oakland Schools CODC/Career Cruising and EDP Reports

8. Formatting Student Data The export will automatically open a new Excel workbook. Oakland Schools CODC/Career Cruising and EDP Reports

9. “Save As” - Type Select Microsoft Excel as the “Save as type”. Oakland Schools CODC/Career Cruising and EDP Reports

10. “Save As” - Place Select your preferred destination for saving the Excel file. Oakland Schools CODC/Career Cruising and EDP Reports

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. Oakland Schools CODC/Career Cruising and EDP Reports

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. Oakland Schools CODC/Career Cruising and EDP Reports

13. Setup (Step 2) When you release the mouse the action will automatically generate a number 1 in each cell. Oakland Schools CODC/Career Cruising and EDP Reports

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. Oakland Schools CODC/Career Cruising and EDP Reports

15. Pivot Table (Step 2) Click on the “Next” button. Oakland Schools CODC/Career Cruising and EDP Reports

16. Pivot Table (Step 3) Click on the “Next” button. Oakland Schools CODC/Career Cruising and EDP Reports

17. Pivot Table (Step 4) Click on the “Layout” button. Oakland Schools CODC/Career Cruising and EDP Reports

18. Selecting Pivot Table Data (Step 1) To select data you will click and drag the items needed. Oakland Schools CODC/Career Cruising and EDP Reports

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. Oakland Schools CODC/Career Cruising and EDP Reports

20. Pivot Table Data (Step 3) Click on the “Finish” button. Oakland Schools CODC/Career Cruising and EDP Reports

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. Oakland Schools CODC/Career Cruising and EDP Reports

22. Locate Duplicate Student Info Locate the duplicated student information. Oakland Schools CODC/Career Cruising and EDP Reports

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. Oakland Schools CODC/Career Cruising and EDP Reports

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. Oakland Schools CODC/Career Cruising and EDP Reports

25. Resource: Career Cruising EDP Completion Standards Oakland Schools CODC/Career Cruising and EDP Reports

26. Resource: Oakland Schools EDP Evidence Standards Oakland Schools CODC/Career Cruising and EDP Reports

27. Resource: CAMS Guide Oakland Schools CODC/Career Cruising and EDP Reports

28. Resource: CODC Contacts Oakland Schools CODC/Career Cruising and EDP Reports

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. Oakland Schools CODC/Career Cruising and EDP Reports

30. Thank You… • Questions ??? • Evaluation • Training Contact Information Cynthia Scherphorn cynthia.scherphorn@oakland.k12.mi.us 248.209.2271 Oakland Schools CODC/Career Cruising and EDP Reports