Showing posts with label Meeting Minutes. Show all posts
Showing posts with label Meeting Minutes. Show all posts

Monday, June 6, 2011

Meeting Minutes June 2, 2011


  1. PENDING PROJECTS – all have been approved based on remaining funds for Fiscal Year


    • Student Profile Updates


      • User-defined block placement on two pages:


        • Must use all 12 information blocks

        • No repeated blocks in the page placement

        • Plan to add a “Return to Default” Option


      • New Enrollment Status Block


        • Will note: Full-time and Part-time Status

        • Other statuses:


          • Overseas Studies

          • Transferred-out

          • Deceased

          • Other, see notes


        • Will have the ability to search for status

        • Training options discussion:


          • In-person Training Session, or

          • Green Question Mark – with hover over instructions


        • New Preferred Name field


          • One time import of existing info from Department Tabs

          • Will be editable on the Profile page, below SIS Name

          • Heather will check to see if this will merge with emails and searches


        • New Assigned Advisor field


          • One time import of existing info from Department, import will include:


            • Specific Advisor Assignments: Marshall, Annenberg, Psychology, Architecture, Leventhal

            • Alpha-splits

            • Program-splits

            • WILL NOT include assignment by class standing


          • Will be editable and also on Profile page




    • Follow-up feature added to Comments


      • User will be allowed to tag advising comments with a calendar date

      • System will send user an email based on date selected as a reminder


    • Announcement emails moved to separate tab


      • System will sort out all announcement emails to separate tab

      • Allows for faster loading and less clutter in Advising Tab

      • Mass emails sent pre-2009 will also be filtered to new Announcement Tab

      • Emails forwarded to the Database from outside system (i.e. Outlook) will still be labeled as Advising


    • User-defined email signature line


      • Will be added to emails sent out through the system – no more copy paste and misspellings



  2. SURVEY


    • Wait to release, until we add most recent system updates


      • Will allow for some time for users to learn and possibly give early feedback

      • Also can be used as an educational tool to inform/instruct new users


    • Distribute in early July


  3. BUDGET


    • ~ 33 hours remaining for June


      • Estimate 22 hours for items b-d above

      • Estimate 2-3 hours for system maintenance

      • Approx. 8-9 hours to fill


        • programmer will be leaving for vacation June 17, but will still count for previous fiscal year if we get requests in now


      • New six-month contract begins in July.



  4. NEXT ITEMS:


    • More Search Filters (i.e. Placement results, enrollment term, #enrolled units) – will have programmer work on these with remaining June budget


      • Ability to check based on Grad Date (5/2011) would be the format used

      • Will inquire into how a ‘W’ will be noted in Enrollment units search


    • Department Settings and Templates (more options)

    • Reports ( i.e., filter by specific program in reports)

    • New Poll of priorities – tbd after we receive survey results


  5. NEXT MEETING:


    • Will be early July, request to be sent later this week.


Thursday, March 10, 2011

Advising Database Meeting Notes – March 10, 2011

  1. User Defined Preference for information blocks are possible


    • Customizing the default screen to have the information you use the most, appear on the first screen

    • Information would be in blocks on two pages (Left, Right, Top, Middle, and Bottom)


  2. Estimates from Urban Insight (15-17hrs) --- RE: Shared information screen for all departments


    • Preferred Name – 3hrs

    • Assigned Advisor/Department Contact – 4 hrs

    • Enrollment Status – 6.5 hrs (+2 for admin input list)


      • Would display drop down menu selection with pre-approved notation and semester applicable for all to see

      • Example: 20093: Study Abroad, 20101: LOA


    • Proposed Follow-up tag – 1.5 hrs


      • A tag that each user could place on students for follow-up

      • Discussion resulted with the idea of marking comments under Advising tab, for the system to email user on calendar selected date for follow-up.

      • Unsure whether the notification could be for individual user, or would be seen system-wide

      • HMJ will connect with programmer for estimate and possibilities


    • Made decisions to also request additional quotes for long-discussed features

      • Separating all 'Announcement' emails to another tab

      • Adding email signature to user settings



  3. Budget


    • January = 19.75

    • February = 3.25

    • 57 hours available for March/April


  4. Survey – designed to collect information on usage and user knowledge to help define next updates and also to collect feedback on recent updates as well as need for additional user training.


    • Chris Noll made rough draft and we discussed format

    • Agreed to make edits and distribute survey before next meeting

    • Combine items in How often do you use this function? with How familiar are you with each function (radial button scale)

    • Does this function need updates? (check box)

    • Will you attend a training session on a specific function? (check box)

    • Discussed the idea of creating training videos for tips or having live sessions.


  5. Next Meeting – TBD


    • Topics


      • Continued Discussion on Survey

      • Programming Estimates

      • Results on splitting Student Profile into two pages



Thursday, January 27, 2011

Meeting Minutes - January 27, 2011

Updates:

  • Comments now have line breaks. These were retroactively added to previous comments, if line breaks were used.

  • Entry Terms – Can now be searched using <, >, = qualifiers

  • Can now find students who have graduated from a special program, such as SCP

  • SAP/AcRev status are now in reverse chronological order (most recent status up top)

  • Custom Reports – Programmer has worked on removing duplicate records


Next Items

  • Multiple Tabs – to reduce database load time and scrolling. Primarily Student Profile Changes (i.e. Demographics, Scholarships, and Contacts on different tabs)


    • Brief discussion on having customizable Profiles similar to default List View (may be complicated by mix of STATIC information from SIS and Dynamic info added by us)


  • Student Profile Changes - Discussion


    • Heather composed most common Custom/Department Fields utilized, which included: Advisor, Graduation Date, LOA, Preferred Name, Office of Overseas Studies. Noted that 450 items created, were unused.

    • We discussed which items make the most sense to be included in a common tab that all departments can view, and which also may be useful for NREG tracking.

    • We’ve agreed upon the following, with logistics pending:


      1. Preferred Name

      2. Department Contact (Academic Advisor – or other contact for more complicated advising arrangements. This item can also be left blank)

      3. Enrollment Status with semester noted (LOA, Abroad (w/location), Transferred Out, etc.). I envision this similar to AcRev or FinAid status.



  • Survey for future action


    • We will plan to continue with our survey to advisors regarding Database changes, updates, training preferences.

    • Chris Noll has started process, and we will continue to work


  • Next meeting likely early March, pre-Spring Break --- Meeting Request to follow

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.

Wednesday, July 28, 2010

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

Friday, July 9, 2010

Meeting Minutes 6/28/10

USC Advisement Database Meeting Minutes
June 28, 2010

Agenda:
1. 2009-2010 Review
2. Budget Status
3. List of new items

Our committee has been in existence for one year.
Many changes that we requested have been made.
Need to use remaining FY2010 hrs.
-600,000 individual items/ day
-Log of system 300 million items
Logged information will be deleted after 30 days
-Perhaps this will help speed up the system? Maybe…
-Urban Insight will continue updates (custom report rebuild, SIS data displays) – will bill under FY2010
Budget refreshes for July = 20 hrs/month
Filter advisement sheet, all programs
*If we want to test advisement database, we can request access to the record of “Thomas Trojan” thru Heather

What is the purpose of our committee?
Survey – Find out who is using the system. What do they want to know?
Let’s have working meetings in computer labs (advance training for advisors across campus).
-Perhaps in our meetings, we can put together training workshops?
-Survey – how familiar are you with certain processes? (Scale 1-10)
-If you scored 8, 9, or 10, would you be able to train other advisors?
-Template – supposed to have pop-up box
-click “Save” and then click back or close browser
-Heather will fix – it is a bug!
Expired Posts still show up as “active” in database
KUALI will eventually replace SIS

USC Advisement System
– designed to promote retention and help advisors communicate between double majors/ minors.
Graduate Advisement System
– not likely in the near future.
Wish list for July
1. Multi-level sort
2. LOA- wait for Heather! No action now
3. Filter by program in reports (Similar to at-risk reports)
4. Update profile screen with fields that can be edited by all users (major and minor advisors)
5. Placement test results
6. Mac trouble shooting
7. Email signature included in template
8. Filter locked (default) - lock filter so announcements are not seen.

Wednesday, June 9, 2010

Meeting Minutes 6/7/10

Database Committee notes for 6/7/10 Meeting Minutes

Attendants: Christina Chris Noll, Ian B. Keil, Elizabeth Erickson, Jeanne Herman, Jennifer Gerson, Michael Kurland (Chair).
1. Spoke about updates, email lockups, cleaning up logs and custom reports will use up the time remaining for June.
2. Emailing system has been locking up since April/May, what Is causing this and why should we pay for it? Is it ITS fault? If so then can we bill them?
3. Re-evaluation of what the committee should be about was discussed.
a. Want to create a panel (us) of Liaisons or advisers to advisers about the advisement database (ADB) so that we can go back to our schools/departments and be an additional resource.
b. Thus, we will need to understand the parts better and use part of each meeting going through a section of ADB.
c. We will also continue to rank the importance of updates and new changes to be done to the ADB both through focusing on the specific parts (such as Advisement Sheet or Search) as well as comparing all parts and ranking.
d. We will also like to create in conjunction with Heather helpful hints, cheat sheets, and other helpful things for us and other users.
4. It was thought that templates could not be updated, but tested that they could be. Although, the advisement sheets template would save and not close, it was found to press the save button and then hit back twice in order to get out. (Instead of loading the page over again).
5. Question: Does custom report cover LOAs?
6. Contact ITS to see if they can have a representative at our meetings
7. Some wants:
a. Would be good if the lock on the filter would stay until taken off (for all tabs)
b. Search function for audits (but low priority as there is a work around)
c. Separate announcement tab for emails – will it only filter new announcements or all? Is not as needed if the filter would stay locked.
d. Email subject lines – does it give a subject line if we email the ADB?
e. Email breaks for the emails to ADB would make those emails useful and not unreadable.
f. More discussion is needed on the next steps to take
8. Next meeting will be in 2-4 weeks, a meeting wizard will be sent out.

Tuesday, May 4, 2010

Database Committee notes for 4/29 Meeting Minutes

Attendants: Christina Aumann, Diana Jaramillo, Deri Leong-Miller, Chris Mattson, Russ Sommer (Note taker), Ian B. Keil, Elizabeth Erickson, Enrica Hodder, Michael Kurland (Chair), Heather Cartagena (Ex-officio).
1. Discussed recently completed updates
a. Multiple Email Attachments –
i. Ian noticed a little glitch and will continue to test.
ii. The estimated 6 hrs for this update, actually took 11 hours
b. Custom Report Rebuild –
i. in-process
ii. Original 24-26 hours expected, but may take longer
iii. Possibly completed before grades are posted
2. Discussed budget invoice
a. March Invoice = 21.75 hours
b. Still have 10.75 hours banked from previous months
c. Unexpected April hours
i. Shibboleth system failure issues resulted in downed system –may require newer version of Shibboleth (unsure if we will pursue at this time)
ii. 2-3 hours to trouble shoot the above and locked email issues
iii. ITS – changed email ports which resulted in some email confirmation issues
3. Next Database updates
a. Displaying SIS Data – 15 hrs
i. Academic Status – 4hrs
ii. Holds/Activity Restrictions – 7hrs
iii. SAP Status – 2 hrs
iv. Testing – 2 hrs
4. Summer Items and Beyond – Discussion - After Custom Reports and SIS Data updates
a. Remove USC Intranet/VPN – 32 hours
i. Would involve virtual student server
ii. Some departments find it easier for students to connect than others
iii. Having recent Course Plan available has helped
iv. Continue to remind students to sign in on campus computers
b. Separate Announcement Emails from Advising History View – Estimate Pending
i. Brief discussion on this being an extra tab or other format
5. Other points of discussion –
a. Possibility of adding Academic Support tab automatically when an Academic Probation/Review tab is added
b. Discussed the Database Email Void that Heather manages
i. Incorrect ID format on email tag lines
ii. Sending emails to system prior student data being added – returning students
iii. Heather will continue to manage for various reasons
c. KWALI (sp?) – Consortium to replace SIS system
i. Currently working on financial piece
ii. Still in development state
iii. Will likely still need DARS/STARS system with KWALI – mainly a registration/information conduit
iv. Should not affect Database itself
v. Will be open sourced so multiple schools could use
vi. Still several years before implementation
d. NREG list is active
e. Revisited Database APPT Calendar
i. Many departments are not using, so has dropped in priority
ii. Still an important tool for some
iii. Discussed different strategies and uses between departments
6. Next meeting likely first few weeks of June before weekly orientations.

Tuesday, March 9, 2010

Meeting Minutes 3-8-2010

Present: (no particular order) Diana Jaramillo, Russ Sommer (Note taker), Christina Aumann, Christopher Noll, Jeanne Herman, Enrica Holder, Deri Leong-Miller, Elizabeth Erickson, Michael Kurland (Chair), Heather Cartagena(Ex-officio).



  1. Discussed Recently Completed Updates

    1. Progress Audit Icons – took a total of 8 hours (2 over estimate)

      1. Resulted in a bit of confusion but overall no major complaints or concerns

      2. May decide to hide these buttons in preferences and view during Audits

    2. Mid-term Alert Emails

      1. Received well by all departments

      2. Plans to add line breaks to emails in the future

    3. Multiple Email Attachments – this item is in-progress

  2. Budget Status

    1. February – 14.25 hours used total

    2. With Jan/Feb excess – leaves 32.50 hours for March

  3. Latest Quotes

    1. Custom Report Fields (24-26 hours)

      1. The entire Report system will be rebuilt with this time

      2. Which includes all items presented including Department Fields and Pictures

    2. SIS Data Displays

      1. Academic Status – 4 hrs

      2. 1. Semester by semester status updates instead of just ‘N’
        2. Allowing Advisors to better track students on probation

      3. Holds/Activity Descriptions – 7 hours

      4. 1. Holds will result in hyperlink to descriptions
        2. Too much data to include in Student Profile

      5. SAP Status – 2 hrs

      6. 1. Translated labels in profile

      7. Testing / Debugging – 2 hrs

      8. Total Estimate – 15 hrs

    3. USC Intranet/VPN Requirement Issues with Student Access – 2 approaches (currently students need to download VPN and subsequent programs to make appointments and via Course Plans on OASIS -> this is a confusing and difficult process for many).

      1. Provided detailed packet of information in response to options

      2. Create a new student portal server – 32 hours

      3. 1. Cheaper than purchasing a new server
        2. Would partition one of the two current servers and allow students to access off-campus

      4. Create a separate website for student access – 8 hours

      5. 1. Less secure – NOT RECOMMENDED

      6. DISCUSSION – Likely to proceed with creating portal server perhaps in summer. Though few departments use appointment scheduling (partially due to this difficulty) in the future more items may be placed in MyUSC for students – so the need will likely grow

  4. No longer seeking new ITP position despite interviews

    1. Appears to be more cost effective to continue working with vendor

  5. Future Plans

    1. Move forward with Custom Reports updates (March)

    2. Move forward with all SIS Data Displays (borrowing time from April if needed)

  6. Future Meeting

    1. Expected Late – April. Michael will send invites soon.

    2. Discussion topics:

      1. VPN Virtual Server

      2. Revisit original list and reprioritize future plans

Wednesday, October 21, 2009

Meeting Minutes 10/20/09

Database Committee notes for 10/20/09:

Present: (no particular order) Diana Jaramillo (Note taker), Christina Aumann, Christopher Mattson, Jenn Brown, Jennifer Gerson, Elizabeth Erickson, Michael Kurland (Chair), Heather Cartagena (Ex-officio).

1. Review and Discussion of Quotes

· Increased Edit Time and Save as Draft

i. We want to explore extending “Increase Edit Time” to a significant period (72 hours to one week). If this can be done for a low number of Urban Insight hours, this may present significant cost savings over implementing the drafts.

ii. We may determine that we are willing to invest in the drafts in the future if the longer edit time does not meet our needs.

· Course Plan Updates

i. We agreed that all items on this list were important to implement sooner rather than later except for “Insert years between existing years.”

ii. “Insert years between existing years” will likely be put back in the queue at a later point.

· Various Requests

i. Of this list, we felt that all items could wait.

ii. “Modify low midterm grade notification emails” was determined to be highest priority, but given the timing of when this will be needed, January seemed reasonable to schedule this.

iii. We asked Heather to check with the programmer to see whether specifying the number of attachments to three would reduce the time needed to implement “Multiple email attachments.”

iv. We revisited the idea of having a report in the database that would match with what is requested for the audits. Heather said that she would need to think through the logic needed to develop such a report before a quote could be requested.

2. Next Meeting

· We can reduce meeting time to one hour.

· The online calendar is a fruitful topic for discussion and will be the focus of the next meeting.

· Heather read through the existing requests related to the calendar feature.

· Christina Aumann volunteered to get the discussion started via e-mail to include the committee members who were not in attendance today.

Friday, September 25, 2009

Meeting Minutes 9-24-09

Database Committee notes for 9/24/09:

Present: (no particular order) Ian Keil, Diana Jaramillo, Jason Pappas, Christina Aumann, Jeanne Herman, Christopher Mattson, Deri Leong-Miller, Jenn Brown, Jennifer Geison, Elizabeth Erickson, Russell Sommer (Note taker), Michael Kurland (Chair), Heather Cartagena (Ex-officio).

1) Discussed Newsletter edits

a. Mid-semester alerts –

i. Grades will be entered week 6-10

ii. Current messages only sent for first low grade for students (students labeled with BLACK <= icon)

1. Suggested alerts for each poor grade w/greater detail on emails (course title in subject line)

2. Students ID number

b. CAA meeting

i. Plug filter training

ii. Mention highlights from Database bulletin

iii. Heather plans to draft Database “Cheat Sheet” w/our additions/edits later

2) Recent and upcoming updates

a. Scholarship names have been added to student profile

b. Self-reported Graduation Date will be removed

c. FUNDING will be back to 20 hours in October – awaiting estimates on:

i. Save as Draft option – with reminder emails 2 days before expiration

ii. Course Plan bundle

3) AUDITS

a. Reviewed aspects of scoring Rubric with more detail to follow (dean’s currently have rubric)

b. New suggestions

i. Automatic subject line – Not necessary/varies by department

ii. Current semester load – will look into for new course plans, not current

iii. Populate Overall units vs. USC units

4) NO hiring updates, 5 recommended for second interviews

5) Next meeting – TBD

a. Plans to discuss new estimates

b. Reprioritize improvements list