Technical Details
Current Release Version: FY24.23.1
Release Date:
Security Roles: SPS Advising
...
Features
...
Current Cycle
Features to Complete
...
- Headshot
- Bio
- List of the program(s) they represent
- List of the types of meetings they conduct.
- Calendar to click to schedule a meeting.
...
- The purpose of their meeting (from a drop-down list of meeting types)
- Their career goals (i.e. preferred industry, location, etc.)
- Upload resume
...
to
...
- Move CDL's aliases from Front to Slate.
- Provide CDL advisors with Bcc email addresses to include in all of their messages with students.
- Create mass email template.
...
Consider
- Security & Access Management
- Define role-based security model and assign users to appropriate groups based on role
- CONSIDER: Create program-level realms for segmenting individuals by program
- Students should be allowed to view personal records and student-facing forms and events only
- Dependent on the Student Portal implementation
- Define role-based security model and assign users to appropriate groups based on role
- Unregistered Student List
- Advisors will have a list of eligible students who are not registered on their main portal screen.
- Advisors can click into a student’s record to find out why s/he might not be registered.
- Advisors will be able to send form emails to students (either sent automatically or triggered by the advisor after assessing the student’s status).
- See Icebox for additional considerations
Previous Releases
Release FY24.
...
3.
...
0 [
...
June 2024]
...
- Incomplete Grade Request Form
- If a student wants an extension in a course and therefore receive a temporary grade of "Incomplete," the following steps occur:
- The student logs into a portal at https://advising.sps.columbia.edu/portal/incomplete_grade_requests where they can see a list of Incomplete grades they have requested (if any) and the statuses of those requests.
- The student can click on a link to bring up the Incomplete Grade Request form. If the student has courses eligible for an incomplete grade, the form will pop up. If not, an error will appear stating that the student does not have available classes.
- When the student selects the appropriate course from a drop-down list of courses, a set of fields including the term, instructor name, and instructor email address will be populated.
- The student also uploads a document stating the reason for the request.
- Upon completing the form, a confirmation email goes to the student, the spsadvising alias, and the instructor.
- The instructor informs a representative of the SPS Advising team of the following information: what assignments the student needs to complete in the class, a date by which they need to be completed, and the grade that the student will receive if the work is not completed on time.
- The SPS Advising representative accesses the form on the back-end at https://advising.sps.columbia.edu/manage/form/form?id=c5e2d7aa-67d1-4453-a43d-2df63d598024. There they enter the information supplied by the professor along with the professor's name (as an electronic signature).
- A confirmation that this information has been entered is sent to the student and the spsadvising alias.
- The student logs back into the portal. All of the information about the request will now be displayed in the table at the top of the screen. The student clicks a link in the signature column. The form appears below, and the student can now provide an electronic signature showing that they understand the expectations.
- A confirmation email is sent to the student, their advisor, and the spsadvising alias.
- If a student wants an extension in a course and therefore receive a temporary grade of "Incomplete," the following steps occur:
- Change of Modality Request Form
- Students enrolled in a remote program who want to change to in-person (or vice versa) complete a Change of Modality form.
- The student receives a confirmation email upon completion. The email also goes to the student's advisor and spsadvising@columbia.edu
- The request must be approved by the program director and advisor.
- Once approved, it should get sent (manually) to Andy Hrycyk for processing.
- FERPA Release Form
- The FERPA Release form designates one or more people who can speak on behalf of the student. Students complete a form that grants permission to an individual who or an organization whose representatives can speak about their record on their behalf.
- Students receive an email confirming that their request was received. The confirmation e-mail also goes to spsadvising@columbia.edu.
- Information about the individual's designee(s) are displayed on a FERPA Release tab on their profile page in Slate.
- Students will have the ability to revoke a a FERPA release by emailing their advisor. In that case, the advisor can access a form to change the status from active to inactive.
- The FERPA Release tab has separate sections for FERPA releases that are active and inactive.
Release FY24.2.0 [March 2024]
...
- When the status of a student's Leave of Absence request becomes fully executed, if "Suppress Communications" is set to "no", and it has been approved by the program rep, the advisor, and, in the case of a medical LOA, the wellness representative, a confirmation email automatically goes to the student and a copy goes to:
- If the leave was for a medical reason: his/her advisor and the wellness alias.
- If the leave is voluntary or military: his/her advisor.
...
- Career Design Lab (CDL) Integration
- Coach Scheduling
- Created new fields for CDL coaches:
- Biography
- CDL Coach Start Date
- CDL Last Initials Covered
- CDL Programs Covered
- Created new materials types for CDL coaching:
- Resume
- Cover Letter
- Relevant Career Materials
- Created separate Scheduler Templates for virtual/in-person meetings
- For each template, created a form based on existing form in 12twenty.
- For each template, created the following communications:
- Career Coaching Appointment Scheduled
- Career Coaching Appointment Cancellation
- Career Coaching Appointment Reminder
- Career Coaching Appointment Follow-Up
- Career Coaching Appointment No-Show
- Career Coaching Appointment Updated
- Created User accounts for all CDL coaches.
- Added a managed Scheduler calendar for each coach.
- Created blank Active Scheduler calendars for each coach (virtual and, when appropriate, in-person)
- Built "CDL Scheduling" landing page
- Built "Book CDL Coach Meeting" portal
- Created a method for each coach
- Created a view page for each coach with widgets for the modes of appointments they conduct (virtual and/or in-person)
- Created new fields for CDL coaches:
- Communications
- Moved CDL's aliases from Front to Slate.
- Created a CDL inbox group.
- Had CDL forward CDL alias emails to the new inbox group.
- Created a CDL Inbox role
- Associated CDL Inbox role with CDL inbox group.
- Assigned CDL Inbox role to appropriate users.
- Provided CDL coaches with Bcc email addresses to include in all of their messages with students/alumni.
- Created mass email template.
- Moved CDL's aliases from Front to Slate.
- Coach Scheduling
- Leave of Absence Form
- Added an internal entry field for the date upon which a student submits a Return from Leave of Absence form.
- Added an internal entry field for the date upon which a student requests an extension for their leave of absence.