As a working technology teacher, I get hundreds of questions from parents about their home computers, how to do stuff, how to solve problems. Each week, I’ll share one of those with you. They’re always brief and always focused. Enjoy!
Q: When tech gets difficult, my students stop trying. Class goes fine when the skills are similar to those used in their online games, but if it gets challenging, like remembering all the steps required to add a border to an Excel cell (or you fill in the blank with that show-stopping skill that everyone turns off to), they aren’t interested. What do I do?
A: After twelve years of teaching K-5, I know as sure as I know who our president is that kids will try harder if its fun. The challenge for us teachers: How do we make a multi-step skill that they may rarely use ‘fun’?
The answer is keyboard shortcuts–aka shortkeys. My students love them. I start in kindergarten with the easy ones–like Alt+F4 to exit a program–and build each year until they’re finding them themselves. Throw in a few that are quirky–that motivate students to find a place to use them, and you’ve one their hearts and minds. My two favorites are –> and :). OK–yeah, in WordPress it isn’t cool, but how about in Word:
- To create the first one: Type –> and Word automatically switches it to an arrow
- To create the second one: Type 🙂 and Word automatically switches it to a smiley face
Adjust the font sizes, placement of the parts to get different arrows and faces. Soon, students are proud to show off their shortkeys, their techi-ness, and borders in Excel become a point of pride.
BTW, here are the shortkeys for Excel borders:
- ALT+T top border
- ALT+B bottom border
- ALT+L left border
- ALT+R right border
- ALT+D diagonal and down
- ALT+U diagonal and up
- ALT+H horizontal
- ALT+V vertical
If you’re looking for Mac shortkeys, try Dan Rodney’s great list here.
Jacqui Murray has been teaching K-18 technology for 30 years. She is the editor/author of over a hundred tech ed resources including a K-12 technology curriculum, K-8 keyboard curriculum, K-8 Digital Citizenship curriculum. She is an adjunct professor in tech ed, Master Teacher, webmaster for four blogs, an Amazon Vine Voice, CSTA presentation reviewer, freelance journalist on tech ed topics, contributor to NEA Today, and author of the tech thrillers, To Hunt a Sub and Twenty-four Days. You can find her resources at Structured Learning.