Career Coach EZ Lift Procedural Documentation
Career Coach EZ lift is the process created and administered by Enabling Services.
Its purpose: Take the burden off schools in identifying Occupation Codes/Titles to associate with the school’s Academic Programs and Certificates-program by program.
Background: Career Coach is the search tool used in many California Community Colleges. It enables students to search for their desired occupation, and identify academic programs (and the schools offering them) that align with their career aspirations.
Career Coach can also be used to search academic programs, or search for military occupations/associated careers.
We came up with ‘EZ lift’ because schools were intimidated at the daunting task of reviewing all academic programs, and trying to identify the Occupation Codes/Titles that might align with a particular academic pursuit.
The steps:
Enabling Services obtains Career Coach workbook from Lightcast
Enabling Services delivers workbook to school
School reviews their academic programs, making additions, deletions, changes. Jump to the topic
School delivers updated workbook to Enabling Services (keep a copy; it will be used later in the EZ Lift process, noted in step 12)
Enabling Services creates EZ Lift workbook – one worksheet for each academic program. Jump to the topic
Details on creating worksheet tabs are here. Jump to the topic
Academic Programs and occupations associated with them. Jump to the topic
Enabling Services finds Occupation Codes/Occupation Titles aligning with academic programs, adding them to each program worksheet. Jump to the topic
Enabling Services sends EZ Lift workbook to school for review. Jump to the topic
School disseminates worksheets (one for each academic program) to Deans/Department Chairs responsible for assigned disciplines and their associated academic programs.
Deans/Department Chairs review worksheets for their discipline, reviewing Occupation Codes/Titles Enabling Services assigned to each program; they may choose to ‘strike’ some of the Occupation Codes/Titles assigned.
School returns updated EZ Lift workbook to Enabling Services
Enabling Services adds approved Occupation Codes/Occupation Titles to Occupation Mappings worksheet, program by program - within Career Coach workbook (as updated/received by school in item 4) Jump to the topic
Enabling Services sends updated Career Coach workbook to Lightcast
Lightcast makes updates in Career Coach, and sends updated workbook to Enabling Services
Enabling Services delivers updated workbook to school
Once a college is interested in pursuing the benefits of Career Coach, Enabling Services contacts Lightcast (formerly known as EMSI) to obtain the most recent Career Coach workbook for the school; we’ll be sending this workbook to the school for action.
The workbook has a worksheet listing academic programs/certificates-the ‘Programs’ tab. This list must be reviewed by the school for accuracy. They make any additions, deletions, and modifications to the program list.
School reviews their academic programs, making additions, deletions, changes
Once done, they return the updated workbook to Enabling Services.
Enabling Services creates EZ Lift workbook
Enabling Services then creates a new ‘EZ Lift’ workbook, with a worksheet for each academic program/certificate (screenshot below).
Since Excel tab names are limited to 31 characters, it might be helpful to determine how you’re going to name the tab first, then create the worksheets using a tool.
How to name worksheet tabs:
First, determine your abbreviated program names for each worksheet. Here is an example:
Next, create new worksheets programmatically based on values in a cell range-specifically, the range of Abbreviated Program names (as shown above).
Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
Click Insert > Module, and paste the following code in the Module Window.
Paste this code in the module window **Note** I changed my cell range to C2:C26 – (evidenced in ‘Screenshot of VB’ code next page), then I clicked on ‘Run’.
Here’s the code to copy:
Sub AddSheets()
'Updateby Extendoffice
Dim xRg As Excel.Range
Dim wSh As Excel.Worksheet
Dim wBk As Excel.Workbook
Set wSh = ActiveSheet
Set wBk = ActiveWorkbook
Application.ScreenUpdating = False
For Each xRg In wSh.Range("A1:A7")
With wBk
.Sheets.Add after:=.Sheets(.Sheets.Count)
On Error Resume Next
ActiveSheet.Name = xRg.Value
If Err.Number = 1004 Then
Debug.Print xRg.Value & " already used as a sheet name"
End If
On Error GoTo 0
End With
Next xRg
Application.ScreenUpdating = True
End Sub
========================================================
Screenshot of VB code:
Now you see the worksheets created-just as you named them:
For each worksheet, format as indicated below.
In the top line of the worksheet add the name of the school’s program, and school’s credential in columns A, B. In columns C, D, E, F – add Program Name, Credential, Occupation Code, Title; this follows the formatting in the Lightcast/EMSI workbook:
Now you have your foundation set up.
Freeze the top row (View tab, Freeze Panes, Freeze top row).