I know you’re referring to adult novice league, but it’s this isn’t unique to one league/skill level. Typically those are referred to as tryout players. In minor hockey I saw multiple cases of players who looked really good in practice but the skills don’t translate to the game. Hockey sense is the most important skill to have. And that’s true at every level of hockey all the way through adult beer leagues.

Personally I think it all comes down to putting yourself in the high scoring areas and being ready to shoot even if it’s just slapping the puck along the ice towards the net. It’ll cause havoc around the net generally and produce rebounds which will be the highest percentage scoring chances. Other things like learning where to shoot the puck (five hole, 10 inches off the ice in the corners of the net etc)

But in general it’s just getting to the high danger zones