What I would do to figure this out, is first look at what’s difficult in your chosen piece. Are you struggling to read the sheet music fast enough? Could you be having trouble placing your fingers in advance (I talk about finger placement in another video), or are your fingers not feeling strong enough for a specific part in the music?
If there are one or two of these things in your piece, usually that’s considered normal, but if there are too many difficult things in the music to accomplish, that’s a sign the piece is beyond your ability. If that’s the case, go back to something a bit simpler – something that’s mostly easy for you to play, but helps you to isolate a specific skill that needs improvement (I recommend focusing on one skill at a time).
You can find pieces for different skills, and go over them again and again until you feel prepared and more capable to attempt that dream-piece you were trying to do in the first place! And this time hopefully it won’t feel so frustrating or take you too long.
Responses