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 highlights 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

The Rusty Lock and Key

I'm in a room. There's a door in front of me. On the other side of that door is a whole world of adventure and imagination and joy and delight, but for the moment, I'm locked in this gray little room. The door itself has a lock that is all rusted. I've tried to open it in the past, but I've never gotten very far. Sometimes I try to scrape the rust off the lock. I also have a rusty old key that I occasionally try to polish. Each time, after I've made a little progress, I'll put it into the keyhole in hopes of opening the door. It turns a half a millimeter or so, but the brief excitement at my progress dies quickly when I realize, once again, the lock isn't opening. I set the old key aside, and from there I can forget about the door, the lock, and the world outside, for months—years, even. But then something happens—I hear birdsong, or I catch a glimpse of color—and I pick up the key and start picking away at the stubborn rust. That dark little room is my ...
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

The Amazing Practice Tracker 2.0: Leveling Up My Piano Game

(Apologies for the cheesy clip art. I needed to come up with something, or the Blogger template would show a fuzzy, overly-enlarged snippet of the first chart below.) When I showed my husband my piano practice tracker, he said I should market and sell it. Ha. It’s not for sale, but I’m excited to share how this tool has transformed my practice—and why it might inspire all three of my readers. Since my last post about the Amazing Practice Tracker, I’ve made it even better. Here’s a peek at how it works, using my June data. All The Pretty Colors, All the Pretty Winners My tracker now sparkles with color: darker shades for active pieces, lighter ones for maintenance, technique, and sight-reading. Each day, the piece I practice most gets a bright yellow highlight—a little “gold medal,” if you will. (Click image for a slightly larger view.) A leaderboard automatically shows the day’s top piece and time. And if that isn't enough, I keep track of the month's leaders--specifically, ho...
Post a Comment
Read more