My lovely university never ceases to amaze me. Every semester without fail, they do something so monumentally stupid that I can’t help but go:
This has been going on since my freshman year. So 4 years of college, 2.5 years of grad school, and it will now be close to 2 consecutive years of being an adjunct. And every semester they surprise me with a brand new level of organizational stupidity. It’s always a different branch, different school, or office that does this. But it’s always entertaining. This semester the WTF moment was delivered by the Office of Academic Advising. Before I show you their email, let me give you some background.
Academic Advising likes to track the progress of students on academic probation. In the past, half way through the semester they used to send all faculty little envelopes with paper forms to be filled out. You got a separate envelope for each course your were teaching, and inside you had a short questionnaire regarding the progress of the 2-3 students in that class who were on probation. Since I’m using a general requirement course that must be taken, I always had at least 3 of these forms to fill out for each class. They were really short, 1 page things that asked about student’s grades, whether or not they turn in their work on time, whether or not they attend the class regularly and etc… It usually took me few minutes to fill them out, put them in an inter-office envelope and drop them in the Computer Science Department’s outbox.
This semester the Office of Academic Advising decided to modernize the process and have instructors fill out the forms online. That’s a good thing, right? Wrong. Please read the email they sent me:
Each year, The Center for Academic Advising & Adult Learning administers the Student Academic Monitoring Program (STAMP). As part of the STAMP program, academically at-risk students are identified and faculty members are asked to assess the student’s performance in class. Comments submitted by faculty are then used by advisors to determine appropriate intervention strategies and support services for students. In an effort to increase the efficiency of the program, STAMP will be administered entirely online this semester. The list of students in your course(s) who are included in the Student Academic Monitoring Program this semester will be available on NetStorage, the University’s secure drive. To access your list, follow the instructions listed at the bottom of this email.
Once you’ve accessed the list, go to [URL redacted to prevent stupidity] and complete a form for each student on your list. Submission of the form by faculty will automatically generate an email to the student. This email will include ONLY the quantitative information supplied by the faculty (eg. number of absences, approximate grade in the course, assignments submitted on time, etc.). Qualitative information submitted in the Comments section will be viewed only by advisors.
Your honest evaluation of these students at mid-semester plays a key role in our efforts to assist them and to ensure their retention at the University. Please submit the online STAMP forms no later than Monday, November 3rd.
Thank you in advance for your cooperation.
Center for Academic Advising & Adult Learning
1. Go to NetStorage
2. In the username box, enter your NetId (eg. smithj)
3. In the password box, enter your password
4. Click OK
5. Click on DriveF@GROUPS
6. Open the CAAAL folder
7. Open the STAMP folder
8. Open the FACULTY folder
9. Open the spreadsheet that corresponds to the first letter of your last name
10. Sort the spreadsheet by faculty_name (column A) to find your name. Your students will be listed in column C.
TLDR: we are lazy, and you should do all the work from now on.
So the office of Academic Advising dumped their list of students on probation into bunch of excel worksheets, then put those worksheets on a network share.
Our mission, should we choose to accept it is to weed through these spreadsheets, locate the students who attend out classes, then go and fill out a generic blank online form for each of them:
Can you see the problems with this new scheme? Obviously it’s a pain in the ass to do. I’d much prefer to fill out my paper form and be done with it. But there are more jarring issues here.
For one, any faculty member, adjunct, graduate student teaching a class and God knows who else can go and download all these spreadsheet and get access to a list of students on academic probation and their student ID numbers. Upon merging and sorting all these files you can easily re-create class schedules for all these students. I don’t know about you but to me this is way to much personal information being accessible to way to many people. I’m pretty sure this is a privacy violation, and there is probably a rule against doing precisely this sort of thing somewhere on the books.
Second issue is that, as far as I can tell anyone can go and fill out that blank form. There doesn’t seem to be validation of any type so I could fill out forms for students that are not in my class. In fact, I could fill out this form for students who are not on probation, or who don’t even exist.
Not to mention the fact that different people will put different things into the free-form input boxes labeled “Course Name” and “Course Number”. Why? Well, let me give you an example. One of the courses I teach can be identified as follows:
- CMPT 109-36: Fluency in Technology
There is also a “call number” associated with this course which is a unique numeric identifier students use when registering and then promptly forget. The question is, which part of the above is the course name and which one is the course number? Does the course number only CMPT 109 or do I need to specify the section number CMPT 109-36. Also how do I input this information into the box. I can think of several ways to do it:
- CMPT 109-36
- CMPT-109 36
- CMPT 10936
- CMPT 109 sec. 36
And etc.. I think you can see the pattern here. All of the above are somewhat valid annotations and I have seen people use most of these variations at different occasions. This effectively means that sorting and aggregating on the Course Number column in the database will not produce any useful results. The data that they will get in this form will be absolute shit, and will require to be tabulated by hand just like the paper forms were. All they really doing is eliminating the printing, mailing, hand sorting and scanning/data entry part of the process by offloading all the work onto the instructors. Not cool.
I’m being told that this new method is a slight improvement though. Apparently, in the past these spreadsheets used to be emailed from one department to another without any encryption. So at least this time around they have them locked behind some sort of user authentication screen and you must access them via SSL. :P