Spreadsheet: 00609f58-3ae6-47db-b262-e9b24c73d5e5
Sheet: Sheet1

INSTRUCTIONS FOR COMPLETING THE CONTINUING EDUCATION MAPS REPORT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | 1 |  |  |  | Non-Credit Data Collection Memos
 |  | A |  |  | The files for the data collection memos are under a folder called "CE Survey"
 |  |  | 1 |  | Memo form letters - one per semester
 |  |  | 2 |  | List of names of the official letter recipients
 |  |  | 3 |  | List of the contacts at the campuses (different from the official recipients)
 |  |  | 4 |  | Merge files for letters
 |  | B |  |  | Process the memos
 |  |  | 1 |  | Update the list of recipients (secretary will check them for accuracy)
 |  |  | 2 |  | Update the form letter with new dates and other revisions as needed
 |  |  | 3 |  | Perform mail merge and check results for accuracy and completeness
 |  |  | 4 |  | Sign memos and give to secretary for posting
 |  | C |  |  | Set up new data folder
 |  |  | 1 |  | Update the contact list as needed
 |  |  | 2 |  | Print the list and set up the folder for the new semester
 | 2 |  |  |  | MAPS Report Workbook Preparation
 |  | A |  |  | Copy workbook file and rename to new semester
 |  | B |  |  | Preserve historical data
 |  | C |  |  | Zero out the tables for data input (this step will help to prevent errors and is highly recommended)
 |  | D |  |  | Update titles and dates
 | 3 |  |  |  | Non-Credit Data Collection
 |  | A |  |  | Follow up with reporting units with e-mails and phone calls to collect data
 |  | B |  |  | Rename spreadsheets that come from the reporting units with naming convention:  CCNCSDD.xls, where CC = campus abbreviation,  S = semester, DD = year (note NC is a constant that means Non-Credit)
 |  | C |  |  | Put spreadsheets into a new folder for the given semester
 |  | D |  |  | File any hardcopies that are submitted by the reporting units into the project folder
 | 4 |  |  |  | Non-Credit Data File Preparation
 |  | A |  |  | Open the data file workbooks and clean them up as needed - add rows, columns, organize, etc.
 |  | B |  |  | Ideally, campuses should provide course name, start and end dates, enrollment counts, and course type
 |  | C |  |  | Verify start and end dates to ensure that the courses fall into the correct reporting period.  Sometimes there will be some overlap with courses reported the previous semester.  Review the data from the previous semester to eliminate any overlap.  If overlap is found, mark the courses and exclude them from the tally.
 |  | D |  |  | Review course type provided by campus for accuracy/appropriateness.  Change course type if needed.  For courses that do not have type, assign course type manually.  Review types as assigned in data sets for previous semesters for clues on types.  For those that can't be defined, contact campus for explication.
 |  | E |  |  | Create a summary sheet for each campus workbook.  Summary sheet can be copied from workbook for previous semester.  Pull numbers from data listing into summary sheet.  Print both the data listing and the summary sheet and file in the project folder (this will make a permanent hardcopy file record).
 | 5 |  |  |  | Credit Data Processing
 |  | A
 | 6 |  |  |  | [NAME]
 |  | A |  |  | Input data from Summary sheets into MAPS report workbook tables
 |  | B |  |  | Input data from credit data files into MAPS report workbook tables
 |  | C |  |  | Print draft tables
 |  | D |  |  | Check draft tables for accuracy and completeness and make corrections as needed
 |  | E |  |  | Print final tables
 | 7 |  |  |  | Charts
 |  | A |  |  | Copy chart file and rename to new semester
 |  | B |  |  | Update charts with data from the Graphics worksheet in the MAPS report workbook;  add new charts / replace charts as needed / desired
 |  | C |  |  | Print draft charts
 |  | D |  |  | Review charts for accuracy and make corrections as needed
 |  | E |  |  | Print final charts
 | 8 |  |  |  | Narrative
 |  | A |  |  | Copy narative file and rename to new semester
 |  | B |  |  | Edit Methodology section for changes and dates as needed
 |  | C |  |  | Revise the Summary and Highlights section with new information and analysis
 |  | D |  |  | Print draft and review
 |  | E |  |  | Make corrections and print final narrative
 | 9 |  |  |  | Cover Sheet
 |  | A |  |  | Cover sheets are in a folder named "Cover Sheets" (there is one sheet per MAPS report)
 |  | B |  |  | Revise cover sheet with new dates and print
 | 10 |  |  |  | [NAME]
 |  | A |  |  | [NAME] are in a folder called "Cover Memos" (there is one cover memo per MAPS report)
 |  | B |  |  | Revise memo as needed and print
 |  | C |  |  | Inital memo and attach to front of report
 | 11 | A |  |  | Give completed report top supervisor for review
 |  | B |  |  | After review, make changes to report as indicated
 |  | C |  |  | Give finalized report to secretary for pagination, duplication and distribution