Category: Spreadsheets

Tech Tip #58: Show all Your Tools on Toolbars

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: I work with younger students (first grade, second grade, even third grade). We’re using Office 2003. When I direct them to the menu bar and one of the dropdown menu choices, sometimes it isn’t there. Instead, there’s a chevron–double arrow–that they have to click to expand the menu. This is confusing for youngers. Is there any way to have the entire menu drop down rather than the truncated version?

A: Absolutely. Go to Tools, Customise. Select the Options tab and select the ‘Always show full menus’ checkbox. (more…)

Tech Tip #57: How to Create a Chart Really Fast

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: What’s the easiest way to introduce 3rd graders to Excel charts?

A: When students have gone through the basics and feel like that scary interface (with the blank boxes and letters and numbers) isn’t so scary, you’re ready to create a chart. Collect class data. Highlight the labels and data and push F11.

(more…)

#12: Create Simple Shapes in Excel

What’s the first thing you think of when I say, Excel. Numbers, right–turning data into information. That is Excel’s ‘killer app’, but the ingenious human brain has come up with another striking use for Excel: Drawing. I spent a long time trying to find a lesson that taught drawing in Excel and/or offered example. I finally gave up and created my own. (more…)

#12: Create Simple Shapes in Excel

What’s the first thing you think of when I say, Excel. Numbers, right–turning data into information. That is Excel’s ‘killer app’, but the ingenious human brain has come up with another striking use for Excel: Drawing. I spent a long time trying to find a lesson that taught drawing in Excel and/or offered example. I finally gave up and created my own. (more…)

Where Would You Like to Go Today?

Are you here for a lesson plan… Tech tips… Humor? Click the category below and you’re there.

[caption id="attachment_1055" align="aligncenter" width="154"]tech tips 52 weeks of tech tips[/caption] [caption id="attachment_1057" align="aligncenter" width="150"]kid pix KidPix lessons for K-2[/caption] [caption id="attachment_1058" align="aligncenter" width="150"]google Earth Google Earth lesson plans[/caption] [caption id="attachment_1059" align="aligncenter" width="150"]Photoshop Photoshop lesson plans[/caption] [caption id="attachment_1063" align="aligncenter" width="150"]web 2.0 Web 2.0 lesson plans[/caption] [caption id="attachment_1064" align="aligncenter" width="150"]ms word MS Word lesson plans[/caption]

excelpowerpointpublisherkeyboarding

[caption id="attachment_1075" align="aligncenter" width="176"]mouse Mouse lesson plans[/caption] [caption id="attachment_1072" align="aligncenter" width="150"]Computer humor Take a break[/caption]

math

#72: How to Check Your Math in Excel

This is one of the most popular lessons I teach to Excel beginners. It is relevant, instantly usable and makes sense from the beginning. Before you start this one, be sure to complete Project 70 and 71.

[gallery columns="2" ids="45219,45218"]

–from 55 Technology Projects for the Digital Classroom

–5 lesson plans for spreadsheets


Jacqui Murray has been teaching K-8 technology for 15 years. She is the editor/author of over a hundred tech ed resources including a K-8 technology curriculum, K-8 keyboard curriculum, K-8 Digital Citizenship curriculum. She is an adjunct professor in tech ed, CSG Master Teacher, webmaster for four blogs, anAmazon Vine Voice book reviewer, Editorial Review Board member for Journal for Computing Teachers, CAEP reviewer, CSTA presentation reviewer, freelance journalist on tech ed topics, and a weekly contributor to TeachHUB. You can find her resources at Structured Learning.

updated 5-18-16