Posted on Leave a comment

Too Much of a Good Thing

By Ann Murray, Director of Institutional Research, Laramie County Community College

As I was pondering what to write about, many thoughts kept bouncing around in my mind. This is probably a sign of the ever-increasing demand on rarely-increasing resources that many in IR are struggling with. The things that have been occupying my thoughts at the end of this academic year can be boiled down to “too much of a good thing.”

At Laramie County Community College (LCCC), we seemed to have turned an important corner. Including data and information to develop improvement strategies and for evaluating operational effectiveness is the accepted practice across the college. Areas making decisions based on anecdote rather than statistically reliable evidence now seem to be in the minority. More people are requesting more new recurring reports to incorporate into ongoing processes, which has raised the profile and the value of our IR functions. It has also increased people’s expectations. This is all good and something that we have been working toward for many years.

What’s not so good is that our resources haven’t increased and, with the budget constraints that Wyoming is facing for the next several years, that won’t change any time soon. So we need to find ways to streamline our reporting processes and be more efficient. Some things we’re trying include:

  • Using existing reports as much as possible to answer ad hoc questions,
  • Developing a two-three year research agenda,
  • Increasing the visibility and use of our online resources, and
  • Distributing our annual reporting calendar more widely so that people will know when to expect what data.

That brings me to my big question for you: what are you doing to better manage your workload and balance the demands on staff time?

Posted on Leave a comment

(Dis)Order From Chaos

By Ann Murray, Director of Institutional Research, Laramie County Community College

The IR Office at Laramie County Community College needed a better way to receive and track ad hoc project requests and document how much staff time these project consume. (We had been using an Excel file that was usually out-of-date and a PDF project request form, entering the information from the request manually.) After looking at several software packages, we have adopted Smartsheet. It seemed to best fit our needs for several reasons.

  • It looks a lot like Excel, so it has been easy to learn. You can create different sheets for different kinds of information; we have one for ad hoc project requests and one for tracking staff time.
  • We were able to create an online project request form and have the information go directly into the ad hoc project request sheet, which means we will be saving some data-entry time.
  • We can attach documents to the sheets.
  • We can share sheets among staff members across the college.
  • We can create reports to show what staff members are spending their time on and how much time we spend on ad hoc or regular reporting, training, etc.
  • It’s relatively inexpensive (there are several pricing options).

We haven’t got it perfectly setup yet, but we’re making progress and it will help us streamline some things. If you need software to do formal Project Management, Smartsheet might not be for you. But if you’re trying to get a handle on all the things you do, check it out at smartsheet.com.

How do you organize your office work?