Requesting Info On Student Plans

Template For Requesting Info On Students Within A Particular Major Or Minor (Or, In CUNYfirst Parlance, “Plan”)
The template below can be modified to suit your purposes and then sent to subcc@ccny.cuny.edu to request information on students who have a particular academic plan. Information will be provided as an Excel file. In the example below, the Biology Dept. is requesting a listing of all students who are either “regular” Biology Majors (CUNYfirst code: BIOL-BS) or Macaulay Honors College Biology Majors (MHCBIO-BS) and who were registered for courses in one or more of Spring 2015, Fall 2014, or Spring 2014.


————–Start of template here———————

Dear Subcc,

For all students who:

A. …are registered in SP15 OR F14 OR SP14

B. …have one of the following academic plan(s)/major(s): BIOL-BS, MHCBIO-BS

…please provide the following information….

1. EMPLID
2. last name, first name, middle initial
3. Email address
4. Advisor #1
5. Advisor #1 — EMPLID
6. Advisor #2 (if they exist)
7. Advisor #2 — EMPLID
8. Academic Level (e.g. “Lower Junior”)
9. Date of Plan declaration.
10. Plan Req Term (plan requirement term)
11. Total Units
12. Transfer Units
13. Units in Spring 2015
14. Units in Fall 2014
15. Units in Spring 2014
16. GPA
17. Exp Grad (expected graduation term)
18. Chkout Stat (e.g. “Applied for Graduation,” “Eligible to Apply”)
19. Biology Plan (i.e. BIOL-BS or MCHBIO-BS?)
20-?. Additional Plans (Majors or Minors) the students might have.


Download Word .docx Template