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
#2. Enabling Services delivers workbook to school
#3. School reviews their academic programs, making additions, deletions, changes
#4. School delivers updated workbook to Enabling Services (keep a copy; it will be used later in the EZ Lift process, noted in step 12)
#5. Enabling Services creates EZ Lift workbook – one worksheet for each academic program
#6. Details on creating worksheet tabs are here
...
(click on the hyperlink-#6)
7Enabling Services finds Occupation Codes/Occupation Titles aligning with academic programs, adding them to each program worksheet
...
8Enabling Services sends EZ Lift workbook to school for review
...
9School disseminates worksheets (one for each academic program) to Deans/Department Chairs responsible for assigned disciplines and their associated academic programs.
...
10Deans/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.
...
11School returns updated EZ Lift workbook to Enabling Services
...
12Enabling 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)
...
13Enabling Services sends updated Career Coach workbook to Lightcast
...
14Lightcast makes updates in Career Coach, and sends updated workbook to Enabling Services
...
15Enabling 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.
...
Once done, they return the updated workbook to Enabling Services.
| Anchor | ||||
|---|---|---|---|---|
|
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.
...
| Anchor | ||||
|---|---|---|---|---|
|
...
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
...