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 Tuesday, 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
Jacqui Murray is the editor of a technology curriculum for K-fifth grade and creator of two technology training books for middle school. She is the author of Building a Midshipman, the story of her daughter’s journey from high school to United States Naval Academy midshipman. She is webmaster for five blogs, an Amazon Vine Voice book reviewer, a columnist for Examiner.com, Editorial Review Board member for Journal for Computing Teachers, IMS tech expert, and a weekly contributor to Write Anything and Technology in Education. Currently, she’s working on a techno-thriller that should be ready this summer. Contact Jacqui at her writing office or her tech lab, Ask a Tech Teacher.