On Time and Under Budget
Jun. 2nd, 2018 08:57 pmAfter four years, the first college that asked me to help them move their programs to the new degree audit system asked me to work for them again. Last time, they kept extending my contract, over and over. Until a whole year had gone by. It was a big job.
Victory Is Mine
This time, they were just coding the new catalog, but they were down two advisors, so they asked me to help. They were hoping to be done by May 23, but they couldn't get me officially approved until May 11, so I was contracted for May 11 - 31 (20 hours per week). I finished everything available to me (none of the new programs had codes assigned yet) 2.5 hours before quitting time on the 31st. I was so, so glad to have actually finished in the time budgeted this time. Okay, not "glad," exactly, more like victorious!
Useful Drudgery
I didn't have to cut corners, either. I made things more efficient, especially by making one college-wide restriction against pass-fail courses so that I could delete the hundreds of requirement-level restrictions that got ported over from the old system.
Puzzles
And I solved some puzzles. In one case, they switched from asking for a certain number of hours from one big list to also asking for a minimum number of hours from a subset of that list. I got to figure out how to structure the course lists so I could use the same ones in both catalogs. (This way, any time a new course is approved, you just add it to one course list and it works for all the catalogs.)
In another case, there was a requirement that could be modified for students in another program, but there was no way for the degree audit system to know who is in that other program. I figured out how to make it so that the audit would not ever wrongly say that the requirement was filled and so that to override the rule for the students in the program, all you had to do was change one single-digit number. (And I explained it in the comments so non-experts could easily figure out what was needed.)
Teamwork
There was another requirement where some additional options are always approved but not publicized. But it was a puzzle: my first idea meant you would have to do a lot of overrides and my second meant that before people had completed the requirement, part of the pre-approved unpublicized option would appear on their audit, which would be confusing at best. So I talked to the person who knew the most about this other option and we figured out that I was confused about the other option, and so it was actually possible to just make it work perfectly for everyone. Woo! I almost never get to participate in real teamwork--neither one of use could have come up with this solution on our own.
New Things
While I was gone, the new certified minors and certificates have been added to the degree audit system (in addition to majors), so I got to see how those work.
Co-workers
All the people I worked with in the college were great. My supervisor at the college was there for me to ask questions of daily to make sure that I was coding thing the way they actually wanted. For example, when a course is mentioned in the new catalog that was not mentioned in the last catalog, is that because the requirement has changed to allow the new course or, more likely, is this a course that didn't exist before but is acceptable in all catalogs?
I also met the two people who have my old role in the Registrar's Office. One has only been there a couple of months, but shows promise. The other is also pretty new and still learning but asks lots of questions and mostly got back to me (with perfect answers), so I'm feeling really good about him. (The questions he didn't answer regarded minutia about which I could easily just assume the worst.)
There were some other people in the Registrar's Office who I contacted because I needed to see another part of the catalog that had some university-wide degree requirements. Radio silence. Until the last day when I said, "today is my last day" and when I gave them three possible options (send me the text, give me a link to the text and permission to access it, or let me come over and read it). They set up a keyboard and monitor in their office so that I could come over and read it online. They had been waiting for their supervisor to tell them how to help me because they couldn't imagine how until they got my e-mail. They also didn't realize it was urgent. They still don't realize that it would have been urgent even if it weren't my last day because we were trying to get the degree audit programs live in time for summer orientation.
The people in charge of assigning the degree codes, omg. Actually, it was the people assigning the institutional codes that backed up the process for four months, but those folks weren't even mentioned in the long list of steps required for new programs until I dug into it. Fun times. (Actually, it is fun. I don't like bugging people to do their jobs, or worse, telling them how, but it feels good doing so as a favor to the whole group of people who are in my same position. And if people get annoyed with me or think I'm a bad apple or whatever, I don't have to care, and I save full-timers from getting stuck with those labels while still sometimes getting them results.)
Salary
They asked what my salary requirement was. I am so terrible at salary negotiations. Last time they could only afford $17.50/hour. This happened to be almost at the very top of the "Assistant Advisor" range. Inflation calculations showed that this was equivalent to $19/hour in today's dollars. So I answered that I wanted $20/hour negotiable. And they agreed to $20/hour. It turns out that the top of the "Assistant Advisor" salary range is still within pennies of $17.50 so this time I was an "Administrative Associate." So, even though I am a terrible negotiator and salary ranges have not kept up with inflation, I still got a better salary than had I been maximally doormattish. Another victory!
Except for the part about how I never got properly authorized to use the time reporting system, ha ha. I'm not too worried. I know I'll get paid eventually.
Summary
I really enjoyed helping out my old coworkers, meeting the new versions of me, getting to see the new features of the degree audit system, and coding the new catalog (and fixing up parts of the previous catalog(s)) as well as I could, with lots of help from competent and conscientious people. Even working half time, though, was a bit much. (That's partly because I also worked a couple of weekend jobs that Robin was doing where they needed more help.)
Commitments
Even when you're retired, it's hard to juggle all your commitments. This summer I have basically 2 commitments: 1) a one-week trip to Cancun and 2) a friend and I are going to go to a water park for exercise in the early afternoon of some weekdays.
Easy, right?
Except the college that hired me heard that another college could really use me and gave them my e-mail address. That second college hasn't yet contacted me, but I've heard things are so dire that their advisors don't even trust their audits, so they don't use them. Their degree audit expert retired recently, and the new guy is having really tough time figuring things out. So I would love to help them (and would ask for $25/hour, negotiable), but yikes, they would probably want me to work on weekday afternoons!
Actually, the new bus system starts next week, which means there will be a bus to the university every 15 minutes instead of every 35 and the route will be much more direct, and therefore (surely) shorter. So in the past, I would do 20-hour work weeks by working three days a week, but maybe working 8 - 12 would be just fine now. That could totally work.
Victory Is Mine
This time, they were just coding the new catalog, but they were down two advisors, so they asked me to help. They were hoping to be done by May 23, but they couldn't get me officially approved until May 11, so I was contracted for May 11 - 31 (20 hours per week). I finished everything available to me (none of the new programs had codes assigned yet) 2.5 hours before quitting time on the 31st. I was so, so glad to have actually finished in the time budgeted this time. Okay, not "glad," exactly, more like victorious!
Useful Drudgery
I didn't have to cut corners, either. I made things more efficient, especially by making one college-wide restriction against pass-fail courses so that I could delete the hundreds of requirement-level restrictions that got ported over from the old system.
Puzzles
And I solved some puzzles. In one case, they switched from asking for a certain number of hours from one big list to also asking for a minimum number of hours from a subset of that list. I got to figure out how to structure the course lists so I could use the same ones in both catalogs. (This way, any time a new course is approved, you just add it to one course list and it works for all the catalogs.)
In another case, there was a requirement that could be modified for students in another program, but there was no way for the degree audit system to know who is in that other program. I figured out how to make it so that the audit would not ever wrongly say that the requirement was filled and so that to override the rule for the students in the program, all you had to do was change one single-digit number. (And I explained it in the comments so non-experts could easily figure out what was needed.)
Teamwork
There was another requirement where some additional options are always approved but not publicized. But it was a puzzle: my first idea meant you would have to do a lot of overrides and my second meant that before people had completed the requirement, part of the pre-approved unpublicized option would appear on their audit, which would be confusing at best. So I talked to the person who knew the most about this other option and we figured out that I was confused about the other option, and so it was actually possible to just make it work perfectly for everyone. Woo! I almost never get to participate in real teamwork--neither one of use could have come up with this solution on our own.
New Things
While I was gone, the new certified minors and certificates have been added to the degree audit system (in addition to majors), so I got to see how those work.
Co-workers
All the people I worked with in the college were great. My supervisor at the college was there for me to ask questions of daily to make sure that I was coding thing the way they actually wanted. For example, when a course is mentioned in the new catalog that was not mentioned in the last catalog, is that because the requirement has changed to allow the new course or, more likely, is this a course that didn't exist before but is acceptable in all catalogs?
I also met the two people who have my old role in the Registrar's Office. One has only been there a couple of months, but shows promise. The other is also pretty new and still learning but asks lots of questions and mostly got back to me (with perfect answers), so I'm feeling really good about him. (The questions he didn't answer regarded minutia about which I could easily just assume the worst.)
There were some other people in the Registrar's Office who I contacted because I needed to see another part of the catalog that had some university-wide degree requirements. Radio silence. Until the last day when I said, "today is my last day" and when I gave them three possible options (send me the text, give me a link to the text and permission to access it, or let me come over and read it). They set up a keyboard and monitor in their office so that I could come over and read it online. They had been waiting for their supervisor to tell them how to help me because they couldn't imagine how until they got my e-mail. They also didn't realize it was urgent. They still don't realize that it would have been urgent even if it weren't my last day because we were trying to get the degree audit programs live in time for summer orientation.
The people in charge of assigning the degree codes, omg. Actually, it was the people assigning the institutional codes that backed up the process for four months, but those folks weren't even mentioned in the long list of steps required for new programs until I dug into it. Fun times. (Actually, it is fun. I don't like bugging people to do their jobs, or worse, telling them how, but it feels good doing so as a favor to the whole group of people who are in my same position. And if people get annoyed with me or think I'm a bad apple or whatever, I don't have to care, and I save full-timers from getting stuck with those labels while still sometimes getting them results.)
Salary
They asked what my salary requirement was. I am so terrible at salary negotiations. Last time they could only afford $17.50/hour. This happened to be almost at the very top of the "Assistant Advisor" range. Inflation calculations showed that this was equivalent to $19/hour in today's dollars. So I answered that I wanted $20/hour negotiable. And they agreed to $20/hour. It turns out that the top of the "Assistant Advisor" salary range is still within pennies of $17.50 so this time I was an "Administrative Associate." So, even though I am a terrible negotiator and salary ranges have not kept up with inflation, I still got a better salary than had I been maximally doormattish. Another victory!
Except for the part about how I never got properly authorized to use the time reporting system, ha ha. I'm not too worried. I know I'll get paid eventually.
Summary
I really enjoyed helping out my old coworkers, meeting the new versions of me, getting to see the new features of the degree audit system, and coding the new catalog (and fixing up parts of the previous catalog(s)) as well as I could, with lots of help from competent and conscientious people. Even working half time, though, was a bit much. (That's partly because I also worked a couple of weekend jobs that Robin was doing where they needed more help.)
Commitments
Even when you're retired, it's hard to juggle all your commitments. This summer I have basically 2 commitments: 1) a one-week trip to Cancun and 2) a friend and I are going to go to a water park for exercise in the early afternoon of some weekdays.
Easy, right?
Except the college that hired me heard that another college could really use me and gave them my e-mail address. That second college hasn't yet contacted me, but I've heard things are so dire that their advisors don't even trust their audits, so they don't use them. Their degree audit expert retired recently, and the new guy is having really tough time figuring things out. So I would love to help them (and would ask for $25/hour, negotiable), but yikes, they would probably want me to work on weekday afternoons!
Actually, the new bus system starts next week, which means there will be a bus to the university every 15 minutes instead of every 35 and the route will be much more direct, and therefore (surely) shorter. So in the past, I would do 20-hour work weeks by working three days a week, but maybe working 8 - 12 would be just fine now. That could totally work.