Career Coach EZ lift is the process created and administered by Enabling Services.
...
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:#1.
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
...
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.
...
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
...
Freeze the top row (View tab, Freeze Panes, Freeze top row).
| Anchor | ||||
|---|---|---|---|---|
|
Sometimes you have to ‘think outside the box’. What’s a similar name for a program?
...
A two-year degree could be an AS (Associate Science), AA (Associate Arts) AST (Associate Science-Transfer), AAT (Associate Arts Transfer). Usually around 60 units; of those 60 units-some are Gen Ed General Education requirements.
Gen Ed requirements help round out a student’s education. Most schools require at least one course in Math, English composition (reading/writing), Social Sciences, Natural/Physical/Biological Sciences, Arts & Humanities.
...
Because there is a vast difference in an Associate degree versus a Certificate, use your judgement in identifying possible occupations to be associated with the academic program.
Further, just because a student chooses a particular academic program doesn’t mean that when the student graduates from that program, they’re ready to start their chosen career. Their career choice might require additional academic studies (bachelor’s, master’s, doctorate).
| Anchor | ||||
|---|---|---|---|---|
|
We created an extensive workbook located here. We search for an academic program, and identify all the occupation codes/titles associated with that program, leveraging the work already accomplished in other endeavors.
...
Once this exercise has been completed for each Academic Program, worksheet by worksheet, we’ll be ready to send it to the school for review.
| Anchor | ||||
|---|---|---|---|---|
|
Academic Deans are responsible for all the academic programs in their discipline. A discipline is a broad academic ‘school of thought’.
...
The workbook has received from school; now we need to add occupation codes/titles to the Lightcast occupation mappings page.
| Anchor | ||||
|---|---|---|---|---|
|
Once the workbook has been received from the school, the next step is to add all the academic programs with their (approved) paired occupation codes/titles to the Lightcast workbook.
...