Using Excel to Track Self-learning
I made a commitment going into my sophomore year of college at the University of St. Thomas that I was going to apply myself to learn more than what I was being taught in the classroom. Since that commitment, I have used a number of different methods and techniques to keep track of my productivity. For the past year, I have been keeping track of the amount of time I have read, done flashcards, completed online, courses, etc. I will go through a more detailed analysis of my progress in a later blog but wanted to share a general template of the Excel spreadsheet I used for those interested in doing their own tracking. Here is what the final product looks like.
It provides descriptive statistics for time spent self-studying in addition to a graph showing a cumulative sum of time self-studying and time spent per week. A link to a downloadable Google / Excel spreadsheet can be found below.
I tried to make the sheet as intuitive as possible. Under the tab “Blank Sheet”, you need to fill in the start date in cell A2. The rest of the dates will auto-populate down columns A and B. Each week fill in the total amount of time in minutes you spent self-studying. The rest of the values in columns D-M (sans H) along with the graph will auto-populate. Be sure to fill in the start and end date in cell H2 and you are good to go. See the below image for reference.