In my last post, in which I talked about the different methods I am using to keep myself accountable in my dissertation writing, I briefly touched on the progress tracking spreadsheet that Ashley and I are collectively using.
What it is
Our tracking spreadsheet is a Google Docs spreadsheet that we created to share our progress and to help keep each other on track. Each of us has our own sheet to keep track of our individual efforts toward our dissertations. My spreadsheet is divided up into weeks and days. The rows represent all of the weeks between January 1 and August 31, and the first seven columns are one for each day of the week (Sunday, Monday, Tuesday, etc.). At the end of each day, in the cell that corresponds with that day, I input the number of words I wrote toward my dissertation. I count only words that make it into the dissertation document and no brainstorming, outlining, or references. While these items all count toward dissertation progress — and indeed are important steps toward completing! — I want to keep honest track of much writing toward the final product I am doing. I can read, browse, and crunch data all week, but when it comes down to it, I also need to be putting words on paper (well, on the screen) if I am going to finish in a year. In the columns after the days of the week, I total the number of words I have written for that week in one column and have another that has the total number of words I set for my goal to write that week.
Thoughts so far
Overall: I love the spreadsheet. People who know me know that I am by nature highly-organized and goal-oriented. This spreadsheet allows me to be both in dissertation writing: it forces a daily attention to the spreadsheet, constant tracking of my progress, and allows me to celebrate little victories when I meet the weekly goal that I set. I am eternally grateful to my colleague Ashley for introducing this to me and for coming up with the idea for us to use this to track our progress and keep each other motivated.
I realize this might not be a good idea for everyone. This spreadsheet works particularly well for me and my working personality: I look forward to the end of the day (or my writing session) when I can eagerly input my total word count for the day and watch the numbers add up for the week. It’s like a little shot of confidence that I can do this big, HUGE project because I’m doing so one small chunk at a time.
Trouble spots: The spreadsheet has highlighted for me the days and/or times that I struggle to write. You’ll notice that I have a big fat “0” for three of the four Thursdays in January. Well, that’s because those days I teach and have meetings about the conference that are hosting this spring. These two things end up taking up most of my day, and by the end, I don’t have the brain energy to tackle my dissertation in any meaningful way. I’ve identified that. But I have an entire semester’s worth of Thursdays, and I can’t afford to not write at all on those days if I’m going to finish this year. So I have decided now to make Thursday my “clean up” days: Any new references that I need to put into my bibliography, I note them all week, and on Thursdays, I format them properly into that document. Bam – I can APA format articles in my sleep, so that’s perfect for Thursday. Most importantly, I’m not losing an entire day: I’m making it work for my schedule.
I also made an effort to insert comments into the spreadsheet when I had particular thoughts about the day that I wanted to remember, such as a day with a low total word count in my document but during which I had completed the entire IRB application for my dissertation — a big, important step. Perhaps by the end of the diss I’ll have enough data to write an article on dissertation writing, or to give a workshop to other grad students at this stage of their degree … who knows!
Timeline: After using this spreadsheet for the first month of the year, I have done a little thinking about the timeline that I am on for writing and how well I’ve been able to meet my daily and weekly writing goals. It has even given me the confidence to up my daily writing goal by 82 words, taking my weekly word count goal from 1946 to 2450. This will result in an entirely complete first draft of my dissertation by August and will give me the entire fall semester for revisions, which I think is a reasonable and achievable goal. I’ll write another update post (maybe end of next month?) to report back on how my new elevated word count goal is going.
Do other folks use a system for keeping track of progress on big projects, like a dissertation? If so, what do you use? How does that work for you?