Forums

Discuss all things Remember The Milk.

Tracking my class assignments and projects

dtjohnso says:
My professors at my college use a standardized Word template for creating their course assignment schedules. I used to track my assignments exporting that table to Google Calendar via a complex route that involved a ton of data massaging in Excel and then a tricky CSV export/import process. Half the time I didn't format the date right or something and would have to do the process over again.

Now with RTM, I just dump the table from the Word doc into Excel and manipulate it a little bit to get it into RTM's format. Usually I have to do a little bit of date formatting, a Find/Replace or two to remove symbols like # and ^ from the assignment descriptions, and a column to the right of everything that uses Excel's CONCATENATE() function to produce strings that look like this which I email to my RTM import email address:

Supplemental Reading 1 ^1/24/2011 #OTT #Study
Supplemental Reading 2 ^1/31/2011 #OTT #Study
Supplemental Reading 3 ^2/7/2011 #OTT #Study
Word Study 1: Sheol ^2/14/2011 #OTT #Study #project
Word Study 2: Nephesh ^2/21/2011 #OTT #Study #project
Supplemental Reading 4 ^2/28/2011 #OTT #Study
Test: Supplemental Readings ^3/4/2011 #OTT #Study

The #Study tag refers to a list where I store all my assignments. The #OTT tag refers to my class, in this case Old Testament Theology. I use the #project tag for major writing/research projects that take more work than daily assignments.

I keep a few saved searches that really make these tags productive:
tag:project [shows all my writing projects for the semester]
list:Study and dueWithin:"14 days of today" [printable list of my next 2 weeks assignments]

Of course, I can also always quickly filter to a particular class by clicking on the class's tag in my tag cloud.
Posted at 2:39pm on January 26, 2011
raymond.bergmark Power Poster says:
In order to speed things up you could use the SUBSTITUTE function, removing unwanted characters.
Posted 14 years ago
Log in to post a reply.