Monday, December 13, 2010

Meeting Minutes December 9, 2010

Fall Updates

  • Student Record Clean-up


    • Purged ~3,000 student records who never attended

    • Adjusted ~250 individual record errors (emails sent to wrong student file, etc

    • Created pop out view for emails in advising history (suggested by committee to add CLOSE button to top of email pop out)


  • Misc tweaks and fixes – still in progress



Topics of discussion:

  • Results of Priority Ranking for new development areas


    1. Student Profile Adjust

    2. More Search Filters

    3. Department Settings and Templates

    4. Reports

    5. Emails

    6. Forms

    7. Calendar

    8. Advisement Sheet

    9. Virtual Server


  • Student Profile Adjustments


    • Update navigation (multiple tabs) one screen viewing (reduce scrolling, reduce time to load profile load)

    • One tab would be open for all advisors/departments to see, discussed the following:


      • Preferred names, assigned advisors

      • Status (i.e. Disqualified, Transferred out, Departed, Study Abroad Sem/Location, Verbal graduation date)

      • Follow-up notes (i.e. referred student to…, or please contact advisor if you see this student…, remind student to…)


        • Lead to discussion about database being capable of sending reminder emails to advisor and/or student for follow-up

        • Heather will look into this possibility


      • NREG Statistics


    • Authorizations Tab for FERPA


  • More Search Filters (Placement results, Enrollment term, #Enrolled units) – discussion:


    • Some options covered by Custom reports

    • Search Enrolled # of units: full-time, part-time

    • Cumulative GPA by term – showing progression each semester



Next Meeting:

  • Last week of January or first week of February – meeting request to follow

  • Plan to continue discussion on Profile change and possibly finalize

  • Discuss sending out survey

Thursday, September 30, 2010

USC Undergraduate Advisement Database Committee Minutes

Summer Updates

Custom Report Rebuild

  • In July, 27.5 hours
  • More than double what was estimated!

    Holds
  • Table can be updated
  • Academic Status - will request that order is modified (more recent at top)

    Program owner
  • Search all LAS students

    Reviewed other search examples based on discussion
  • Referred or manually added majors - Search students who are not officially in major but added major/program tab (UNDL)
  • Comments - Filter comments from all program tabs

    To Do
  • Record Fixes and Corrections
  • Post code clean up and inactive posts (students who were admitted and never enrolled)
  • Line breaks to be added to comments and emails
  • Multi column sort of student list
  • Announcement emails - remove from advising history and add to separate tab
  • General areas to focus on in Fall 2010 - Priority ranking (1-9) distributed at today’s meeting

Advisement database survey will be distributed to advisors after CAA Survey ends.

Perhaps at next CAA meeting, we can discuss how to better handle student crises.

Monday, September 13, 2010

Filter by Program Owner

Finding it tricky to keep your program filters up-to-date with new posts? The majors, minors, post code and program search fields require that you enter each program individually.

A new filter has been added for you to search for student programs based on the owning school instead of inputting each program separately. The new field is call Program Owner and is located under the ACADEMIC FIELDS section of the search field list.

Here's how it works: just enter the type of programs you are looking for (major, minor, etc.) and the SIS code for your school (LAS, ENGR, BUAD, etc.). For example:

major-LAS
major-LASN
major-BUAD, minor-BUAD

The first example will return all students with at least one major in the College. The second example will return all students with a major in any of the Natural Sciences within the College. And, the third example will return all students with a major or minor in Marshall.

A list of the SIS program owner codes for each school is provided below for your reference:
ACCT - Leventhal School of Accounting
ANSC - Annenberg School for Communication & Journalism
ARCH - School of Architecture
BUAD - Marshall School of Business
CNTV - School of Cinematic Arts
DENT - Ostrow School of Dentistry
EDUC - Rossier School of Education
ENGR - Viterbi School of Engineering
FA - Roski School of Fine Arts
GERO - Davis School of Gerontology
GRAD - The Graduate School
LAS - College of Letters, Arts & Sciences (all programs)
LASH - College of Letters, Arts & Sciences - Humanities
LASN - College of Letters, Arts & Sciences - Natural Sciences & Mathematics
LASO - College of Letters, Arts & Sciences - Other Programs (Undecided, Undeclared)
LASS - College of Letters, Arts & Sciences - Social Sciences
LAW - Gould School of Law
MED - Keck School of Medicine
MUS - Thornton School of Music
PHAR - School of Pharmacy
PPD - School of Policy, Planning, and Development
SOWK - School of Social Work
THTR - School of Theatre

Wednesday, July 28, 2010

VPN now online

It is now possible to VPN without downloading any software by using:
sslvpn.usc.edu

This should be able to allow you to use the advisement database, my.usc.edu and other USC websites from home.

USC Advisement Database Meeting Minutes July 27, 2010

Attendants: Christina Aumann, Chris Noll, Elizabeth Erickson, Jeanne Herman, Russ Sommer (Note Taker), Nashira Thomas, Heather Cartagena (Ex- officio), Michael Kurland (Chair).

1. Recently Completed Updates
a. Custom Report Extension – went 8 hours over estimate due to adding photos to system.
i. Contains Department tab information
ii. Photos not available in EXCEL export, but are available in Word/PDF
b. SIS Display Updates – Including:
i. Academic Status & SAP
1. Currently lists are formatted from entering semester to current will plan to reverse order so current is first seen
2. Descriptions are displayed on Student Profile page and are static based on department/SIS descriptions
ii. Other HOLDS on Profile page are hyper-linked to an external table which further defines hold (descriptions pulled from SIS, but can be updated by Heather)
iii. HOLDS which restrict registration appear with a RED Exclamation Point !
2. Budget Status
a. 12 hours remain for July
b. Contract for 20 hours of service each month will continue
3. Next Items (Estimates pending – Programmer out of town at present)
a. Student List Multi-Column Sort - ability to sort a list by Holds and alphabetically for example
b. Filter by specific program in reports
c. Modify and add display of Student profile – to view all material on one screen with tabs to reduce scrolling
d. Search for Placement Results
e. Lock Advising History to not show announcement emails as default – brief discussion about locking personal preferences in filter
f. Add Email signature templates
g. Trouble shoot MAC issues
4. General areas to focus on for Fall 2010 discussion
a. Virtual Server for student access – ITS has made an update for web access.
i. Worked for Heather to sign in from home please visit: sslvpn.usc.edu
ii. Virtual Server may not be necessary if students can access this site
b. Number of items Advising sheets, Calendar function, Emails, Templates, Forms, Reports, Search Filters
c. Discussion tabled to receive feedback from Advisors
i. Will develop a primer survey to measure Database usage and concerns that will be sent to community for feedback – to be sent mid/late August
ii. Using survey results plan to have an open forum with advisors to demonstrate Database functions, best practices, and receive further feedback on concerns once a semester.
5. General Announcements/Discussion
a. Michael will be stepping down as Co-Chair of the committee upon completing his CAA Steering term
b. Next meeting will be seat by new Co-chair to be determined after new Steering team announced
c. Survey to advisors regarding caseloads and responsibilities still in the works
d. Discussed SC retention rate – 6 yr window for completion and with Provost efforts percentage increase to at least 89%
e. Possible to get tuition grant for students needing only 4-8 units to graduate.
f. Michael and Ian are still seeking Advising Narratives – Please contact if you’d like to assist them – mkurland@usc.edu
g. Removing data categories from Department custom tabs (i.e. items that are no longer relevant or have been
i. Difficult and not possible unless every field/value is blank for the item to be deleted
ii. NOT Possible for check box items – unchecked boxes still considered data

Thursday, July 15, 2010

Translation of SIS Codes for Academic Status, SAP Status and Activity Restrictions

A variety of updates have been made to the display of certain SIS information within the Advisement Database to help you better understand the meaning of different codes for Academic Status, SAP Status, and Activity Restrictions.

Academic Status indicates the students academic standing for a given term, such as academic probation or disqualification. For students whose academic standing has always been good, this information will display as a single "OK". But, for students who have been or currently are on academic probation, you will be able to see the history of the probation and/or disqualification status. The information is listed on the Student Profile page below the Advisement History box.

SAP Status indicates the students status relative to Financial Aid eligibility for a given year. For students whose SAP eligibility has never been reviewed, this information will display as a single "N/A". But, for students who have been reviewed for SAP, a status will appear for each year. A short description of each status is also included. The information is also listed on the Student Profile page below the Advisement History box.

Activity Restrictions have always been included in the Advisement Database. These include a variety of information from SCP or Athletics holds to Collections, and Library holds to Student Conduct. However, did you know that not all holds (activity restricts) actually stop a student from registering? There are several other "information only" holds. The new updates to the display of this information includes a small icon of a red exclamation point next to holds that actually restrict registration. Also, you can click on any hold to get additional information about the activity restrictions description and the contact information of the office or department who can remove the hold. The information is also listed on the Student Profile page above the Advisement History box.

Expanded Field Options for Custom Reports

The Custom Report option has been greatly expanded to allow you to export just about any of the fields available in the Advisement Database for your students. Previously, the custom report fields were limited to student name, USC ID, majors, minors, addresses, and USC email. Now you are able to create a filter on the Student List based on any criteria and then export a variety of information for the students on the filtered list.

The custom report fields include just about anything that is viewable within the Advisement Database including GPA, expected graduation, all requirements satisfied, degree date, mandatory advisement, and even USCard photo. You can also export information that you have been entering into your department's custom fields!

The report can then be sorted and grouped with output as a Word document (RTF), PDF, or Excel. Please note that USCard photos are *not* available in the Excel format, only RTF and PDF.

To access the custom report, just click on the Reports link in the navigation bar and select Custom Reports in the top center of the page under the "New Reports" heading.