The other wonderful thing about visualization and stat tracking is the ability to make adjustments to the study routine. Making adjustments to the meta of the language learning process. Left to my own devices, it would be far easier psychologically to assume that whatever tactics I'm using are working without a hitch, than make any real changes. Numbers, however, don't lie. When weekly or monthly retention rates get too low, or I'm forgetting characters just as fast as I'm learning new ones I can address and fix those issues, but only because of the feedback provided by programs like Skritter.
Progress graphs and statistic tracking is a great, dare I say necessary?, tool provided by services online, but what I'm more interested in for today's post is setting up a system to make adjustments and tweaks to personal study habits that happen offline. More specifically, we'll be exploring the use of time tracking as a part of a healthy study routine.
As a language teacher it is my responsibility to focus on and develop the four areas, or skills, of language acquisition: listening, speaking, reading, and writing (mostly composition rather than actual character practice). Classroom activities and take home work is specifically designed to target and develop these different areas, either in isolation, or in combination. As a language learner, especially one who now operates outside the traditional classroom framework, the development process is more ambiguous; often ignoring some areas of acquisition due to interest... or more often sheer convenience. Mentally, I know this is unhealthy. To be truly proficient in Chinese I should have a command of all the areas of acquisition, even if some are slightly stronger than the others.
In order to overcome my own complacency, I decided to start tracking my daily study routine, knowing that unless I could physically visualize my study process I was very unlikely to make any changes. Starting in November, 2012 I created a simple Google Spreadsheet that I would use to track the time I spent studying/ using Chinese. More importantly, I used the spreadsheet to track what area of language I was using at any given time.
![]() |
| An example of a given week of language usage. |
- Date
- Start Time
- End Time
- Difference
- Description
- Week Total
- All Time
- Type
- Listening
- Reading
- Speaking
- Writing
- Characters
- Other
At first glance this might look like a lot of information, but apart from Date, Start Time, End Time, Description, and Type every other element is automated by using simple functions. With this simple spreadsheet I am able to quickly track when I'm studying, and more importantly what I'm studying. After a given week I'll run the total time spent on any give field, writing for example, and get a percentage based on the total time spent for the week. During a week in January for example, I spent 37:48:00 using Chinese over the course of the week, and with a few simple clicks I'm able to visualize how my time was spent, which can be seen in the chart below. Amazingly, I spent over 18 hours, or ~50% of my time, writing that week!
![]() |
| Exam Week. 18 hours spent writing in Chinese! |
Once again, stats and tracking information was able to save the day, and allow me to tweak how I was going about studying and using Chinese. Without this simple tool, I might very well be in the same place today that I was over six months ago. While this type of time tracking might not be for everyone, it has been crucial in helping me develop better and more focused study habits, and just too valuable to my own study routine not to share!
I hope you've all gained something from my experience, and I hope you'll be able to use this, or a similar method to track your own language studies and fill in the gaps and alter how you think about your own learning process! If you have a system that works for you, or have questions about my process, be sure to leave them in the comments below.
Have questions, comments, feedback, or a topic you want covered on the Skritter blog? Please send them to jake@skritter.com.


