Category: Tools (Page 1 of 3)

Time Management Tips

Kate Sheppard is my idol for all things related to time management as an academic. Kate is still the model that we hold up in the History of Science department at OU for finishing on time as a grad student, and she’s even more impressive as a faculty member. She’s already published a monograph and a volume of edited correspondence along with numerous articles and was fast-tracked at Missouri S&T for tenure. She edits & contributes to LadyScience.com, and she’s on several committees for national organizations. She runs marathons. She has an adorable kid and husband. She’s just an all around bad-ass.

Here’s her advice for carving up time. I’m mostly writing this so I can have it as a note to remind myself how to be productive:

I’ve always like the Pomodoro technique, but I’m pretty bad at actually implementing it. The key, I think, is to plan out your day ahead of time and use the timer as a limit to how much time you have for each task. If you don’t get all of a task done in 30 minutes, that’s too bad, you need to move on to the next thing. This shifts the focus from, “I’ll work on this thing for a couple of hours,” to “I’ve got 30 minutes to add a couple of paragraphs to this document.” Brevity is the key to wit and production apparently.

After I read Kate’s tweets, I went ahead and mapped out my days for the rest of the week. I’m still using AirTables to keep track of my To-Do list and projects, but then I map those to-do items to 30 or 60 minute windows in my day. We’ll see how well this works over the relatively unstructured and chaotic summer. Hopefully, I’ll build a good enough routine that it’ll carry into the fall, and I can test it out within the chaos of faculty and student support.

AirTable Review

I have been trying out different project management tools over the last few weeks. So far, I’ve used Notion, Trello, and AirTable and also looked at half a dozen others. I also tried a notebook and paper, but I definitely prefer the digital.

via GIPHY

My first goal is to try to find something that can help me keep track of the various projects that I’m working on. I have a habit of saying yes to literally everything anyone proposes, and then losing track of my commitments. So I need something that will tell me what projects I’m already working on, when they’re due, and some sense of how much bandwidth I have to spare.

The second goal is seeing if any of these tools also make sense for adoption by the Office of Digital Learning. We are in the process of hiring new IDs, a new instructional technologist, and a new video person. We’ve been using a combination of Trello and excel to track things for a while, but in an OLC Live conversation with Clark Shah-Nelson, I realized that we could probably do better.

AirTable

This week I’ve been trying out AirTable at the recommendation of Angela Gunder. As the name suggests, AirTable is a lightweight tool for building tables. My guess is that many people are put off by tables due to repressed memories of having to look at MS Access in a poorly thought out computer class as a kid. I, however, love tables. Working with websites as much as I do, everything now looks like a table. Each webpage is a table. A website is just a table of webpages. And I manage big tables of all the OU Create websites. I’ve organized my research notes into online tables and I’ve built tables for history undergrads to do the same.

For a couple of weeks, I was using Notion.so, and I like how it lays everything out in linked webpages with embedded spreadsheets. Any record that you put into the system can become it’s own little wiki page with embeddable images, spreadsheets, and links to other pages.

However, I eventually decided to abandon Notion, because it was not enough like a table. It was difficult to create two-way links between records for quick movement around the note system. Updates on one page rarely carried over to related pages, so you had to enter the same information on every relevant spreadsheet, rather than just updating a single table.

I spent about two days back in Trello, before remembering that Trello doesn’t do anything other than Kanban charts. There’s no interrelation of information across different charts, and once you’ve completed an item, you just archive or delete it or live it sitting taking up space.

So what I wanted, was something that combined Trello’s Kanban to-do charts with a broader table layout with multiple ways to drill down into the data. AirTable has Kanban charts taking care of my need for visual to-do lists:A screen shot AirTable's Kanban chart viewWhen you update the status (or any other information) of a card in the chart, that update carries throughout the rest of the system. You can view all of your items in a set of spreadsheets that can be tied together with relational tables:

Screenshot of AirTable's table view

In my “To-Do List” database, I have created a table of tasks. Each task can be tied to a broader project, and I can see information about those projects in their own spreadsheet. I also made a spreadsheet for ‘Ongoing’ tasks that I do daily or weekly or monthly, the types of things that can’t just be checked off and removed.

My table also includes a spreadsheet for readings, and these can in-turn be linked back to tasks or projects.

Conclusions

For my own usage, AirTable is brilliant. I’m happy to put in the time and energy to build a table to keep track of all of my stuff. The sheets are interrelated, so my updates propagate through all of the various views and sheets easily. I can sort by deadline to see what’s urgent or by impact to see what the big, important projects are. When a task is done, I can change it’s setting and then hide completed tasks. This is similar to the archival feature in Trello, but it’s much easier to unhide all of my completed AirTable tasks and analyze the amount of work I did in a given week or on a given project.

For my group’s usage, I think AirTable has a lot of power but also several drawbacks. We could easily set up a spreadsheet of all of the programs around campus that we are working with and list out points of contact and notes. We could then create a related spreadsheet of the courses we are developing and have developed. A task list might then list out all of the pieces of content and meetings and design work we are doing for the various courses. We could even set up a separate media table of all of the video and image assets we have acquired and created for the courses. I think in terms of keeping track of all of the stuff that the Office of Digital Learning is working on, this would be a really great tool.

However, my usage so far has been free, but I think we would need to pay about $5 per user (about 15 of us) per month. That’s not a ton of money, but it’s a new cost as compared to our current free usage of Trello or Basecamp which we already have access to.

Also, I felt very comfortable playing with tables, but I anticipate most people will want to stay on their views of the main tables, especially as the database gets much bigger and less comprehensible. It’s easy for me to modify my tables to my exact needs, but it will necessarily be harder to design a set of tables that fit everyone’s needs. My guess is that we will end up with a few tables that are only used by one person, so that they can organize their information as they want. As long as those tables are related back to the main tables, that’s not too big of a problem, but the system will grow ever larger and more complicated.

But, those are all tasks to worry about next week. For now, I will change the status of “Write-up on AirTable” to done, and call it a day.

My Tables are Awesome

This past spring, I was having a conversation with Mia ZamoraAlan Levine, and Keegan Long Wheeler about the NetNarr course. Alan was putting together a table for a website that looked really slick, and when I asked what tool he was using, he said Awesome Tables. Four months later, I’m obsessed.

I am particularly susceptible to the charm of Awesome Tables, because I subscribe to the Tom Woodward school of using Google Sheets for everything. Awesome Tables adds a second sheet to a google spreadsheet. This second sheet has cells containing html, css, and js code, all of which format your data into an interactive table. Here’s the table that my Projects page is running:


Here’s the Google spreadsheet driving it. You can see the data on the first sheet and the code on the second.

I’m excited about this stuff for a couple of reasons:

  1. You can use the second sheet to work through basic website programming with real data and see the results by refreshing the table. I could see using this in a class to teach some basic web coding.
  2. There are about a dozen pretty nice templates built so it’s easy to quickly turn a spreadsheet into a decent looking database.
  3. Google Sheets is powerful because of the ability to use google scripts to collect data. You can use HTTP GET calls to mine data and standard javascript to parse the xml or json files into the rows of the table. You can also POST to google sheets from other web apps or use 3rd party services like Zapier or IFTTT to link it with other web apps with APIs.

There are other ways to build similar tables with bootstrap or even raw html and css, but Awesome Tables is fairly easy to use and embed. The connection between the data and the output is fairly intuitive and easy to manipulate.

By way of example of what you can do quickly and easily, here are a couple of Awesome Tables that I’ve been working on in the last couple of weeks:

Page 1 of 3

Powered by WordPress & Theme by Anders Norén

css.php