CJA Enrollment¶

Steps¶

Save the Excel file from Teams as a CSV file. Clean it up and upload to the Online Report Repository (AR0160).
Naming Convention: Section Course Name and Number, Semester and Year.
- Example: 37362 CJA 034C 2023FA.csv

Copy and paste to a new sheet on the CSV and use the MATCH formula to find existing students:
```
=MATCH(C2,Sheet1!$B$1:$B$50,0)
```
- Insert a column → Enter =match( → Click first last name on Sheet 1 → comma → Click Sheet 2 and highlight all last names → F4, comma, zero, close parentheses → Enter → Pull down.
- Or just copy IDs to each student and fill in what's missing.
Check if students are able to register or if they need new applications.
- If they need a new app: find the application in the packet, load the new application, mark it, and Laserfiche it.

For students without a match, search Colleague in NAE to find their Student ID number and add to Sheet 1.

Once every student has an ID, create a list in SLED (list name: tp) with all Student ID numbers.
Save All.

Step 1 — Check for errors (no changes made):

Field	Value
Section Block	`CJER`
Reg User Group	`ARSTAFF`
Date	First day of class listed on the packet
Update	No
Saved list name	`ER`

Step 2 — Enroll the students:

Field	Value
Section Block	`CJER`
Reg User Group	`ARSTAFF`
Date	First day of class listed on the packet
Update	Yes
Saved list name	`ER`

Warning

SAVE THIS OUTPUT.

Warning

SAVE THIS OUTPUT.

Log completion date in the Excel file.
Delete the name search Excel file in Teams.
Scan and save the whole packet (Paper Packet, BRGN Output, SROS Output; combine through Adobe) to: M:\Instructor Grade Book\Term YYYY - Instructor Folders\00CJA
Email Martin or Lisa with a list of sections ready for grade (new process: complete the request on Dynamic Forms).

When completing a new application for a student, go to ASUM and click the paper icon next to an open application field. Input: