Skip to main content

My Amazing Practice Tracker

Y'all, I love my piano-practice tracker. I enter my time every day, and I could seriously look at all of my stats for hours. Because I have no piano videos to share with you today and I've already discussed my December goals, I will now share my practice tracker with you, using my November stats. Click on images to make them larger.

Part I: Data Entry and Daily Leaderboard

When I'm practicing, I enter all of my information into the PWJ Practice Log. Then, when I'm at my laptop, I enter it into the practice tracker. Not only does it show the total minutes and hours spent practicing each day, but it automatically highlight the piece/project with the most time entered.


This then feeds into my daily leaderboard. The greater the number of "wins," the darker the cell with the number.

Part II: Totals and Averages

This section shows the total minutes/hours for each piece for the month. It also shows how much time I'm spending, on average, on each piece. To do that, it counts the number of times I practice in a month and then divides by the total amount of time. On the right, you can see how much time I'm averaging per day for the whole month.


The colorful section at the bottom shows first, second, third, fourth, fifth, and sixth places. This is a kind of gamification that I do, even though it's predetermined who should win (Liszt, since it has my highest percentage goal for this month). Still, it's fun to see who's in which place each day.

Part III: Weekly Tally

In keeping with the gamification, I keep a tally of which pieces are "winning" for each week. Whoever is ahead gets a blue cell.

Part IV: Pretty Pie Charts

This section is just a couple of pie charts showing the percentages. They aren't super-helpful (since I also have a section showing the actual percentages). But they're pretty to look at.

Part V: Goals vs Actual

I've shared this one here before. It shows my percentage goal vs actual time spent practicing. If I go over the goal range, the cell turns yellow, and if I'm under, it turns light red. Within goal range is green. Yay for me! My only "over-practice" has been in technique! Jingle Bells Rag is below goal because it was originally a 15% goal, but I upped it to 20% about a week ago. It's been fun catching up!


This chart also shows which of my pieces are the furthest below the goal. This is probably the most helpful part of the spreadsheet for me because it tells me what I should practice next.

Part VI: Rates and Predictions

This is the newest section of my spreadsheet, and it's related to the percentage goals. Basically, it tells me how many hours I should expect to put into each piece/skill, depending on how many hours I will practice in a month. I typically practice between 50 and 60 hours a month (though the last few months have been lower thanks to travel and the hurricane).


This part is helpful in setting my percentage goals because I can say, "wait, I want to put more than X hours into Liszt." And so I can increase the goal.

This one also shows how many hours I will have practiced by the end of the month if I remain at my current rate, along with how many more hours per day I need to practice to get to 60, 70, 75, or 80 hours. (Not that I will ever get to 75 or 80!)

BTW, here is another part of the Excel file: a graphic showing total hours practiced per month.

Part VII: Weekly and Weekend Stats

These are just some general weekly stats--who wins the weekly leaderboard, how many hours per week I practice, how many hours per weekend I practice, and what percentage of my week's practice occurred on the weekend.

Part VIII: Graphic Representation of Total Hours Practiced

This is a different worksheet. Yellow indicates maintenance pieces, purple indicates active pieces, and gray indicates inactive pieces.


This one is a little messed up because a lot of my "Amazing Grace" work was counted under "Lagniappe" before I created its own category. (It's always a challenge if I start something new in the middle of the month, since I don't have a column for it!)

Part IX: Comparisons

These are just a couple of line charts comparing the current month (dark blue) to all the others (lighter colors). One is for day of month, and the other is for day of week.


Part X: Recommended Minutes Per Day

NEW FOR DECEMBER: This chart tells me how much time I would need to spend on each area in order to meet my percentage goals for the day. The numbers are for how much I expect to be able to practice in a day, between 1 hour and 3 hours.


This is just a guide, as I don't practice every single thing every single day. But I think it's going to be helpful.

And that's it! I have more stuff, but it's boring (unlike all of the above, ha ha). 

By the way, I didn't create this all at once. I started it in February and have refined it more and more each month.
Labels:

Comments

Post a Comment

Popular posts from this blog

Rethinking Bare Necessities

Today's breakthrough moment (there are actually two of them) focuses on "Bare Necessities." As you'll remember, I discovered Jonny May's arrangement back in early March and immediately decided to learn it. I printed out the music, started the course, and proceeded to learn the stride section, posting a few videos of my progress. Ha. I bet those videos make it look like I was making progress. I guess I was ... but not really. And I realized something this weekend that I hadn't before: Because I was thinking of "Bare Necessities" as a "fun" piece, I wasn't practicing it seriously or diligently. I wasn't treating it as something I wanted to master. This mindset might work with an easier piece, but this arrangement isn't easy. The result: despite a little progress at the outset, I wasn't moving forward. I was stalled. Breakthrough #1 The first breakthrough was realizing that if I truly want to learn this piece and play it well,...
Post a Comment
Read more

March Goals Recap/Looking Ahead to April

It's April 1, and time to revisit the goals I set for last month. I practiced a total of 50.45 hours in March, averaging 1.62 hours (or just over an hour and a half) per day. Realistically, I practice about 45 minutes to an hour a day on weekdays, and I usually get at least one longer practice (or multiple shorter practices) in on one or both days of the weekend to bring the average up. CLASSICAL GOALS Chopin, F Minor Nocturne March Goal: Have entire piece by memory and performance-ready. I have about 90% of the piece by memory, but I still have some work to do before it's performance-ready. The only two sections that I don't quite have are "The Agitation" and the "stretto" section with the seventh chords. I'll work on both this week and will have them both memorized before the weekend. April Goal: Finish memorizing, and polish, polish, polish! My focus now is really on phrasing and dynamics. I have the notes down, even in the difficult passages. Fro...
Post a Comment
Read more

Maple Leaf Rag Breakthrough

Oh, Maple Leaf. Where to begin? At the Beginning I think I’ve mentioned this before, but I learned the A and B sections of Maple Leaf Rag back in the 1990s. I can’t tell you if it was early, mid- or late 90s, but it was during those 10 years after I’d graduated college, when I was playing a good bit of piano but not taking regular lessons from anyone. I don’t remember teaching it to myself at all. I just know that, at some point, the first half of Maple Leaf Rag was part of my two- or three-song repertoire of pieces I’d be able to play by memory over the next 25 years. It was always sloppy and I knew it, but people loved it, and so I played it if there was ever a piano around. Back in January, I decided to properly re-learn those two sections, and to finally learn the C and D sections of this wonderful piece. I worked on these over the next month or two, learning (and-relearning) the notes pretty quickly ... but it took time to memorize, and also to get everything to tempo surpassing a...
Post a Comment
Read more