browser icon
You are using an insecure version of your web browser. Please update your browser!
Using an outdated browser makes your computer unsafe. For a safer, faster, more enjoyable user experience, please update your browser today or try a newer browser.

Spreadsheets

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

tech tipsAs 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: Before making charts, try this easy and fun intro to Excel columns, rows and tools.

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. Here’s a free lesson plan on that.

(more…)

Categories: 3rd Grade, 4th Grade, 5th Grade, Spreadsheets, Tech tips | Leave a comment

How to Use Excel to Teach Math Arrays

Grade Level: 5th (or whichever grade you are teaching arrays)

Background: None. This is an intro to MS Excel

Vocabulary: Excel, cell, rows, columns, paint bucket, borders, arrays, resize, formulas

Time: About 30 minutes

Steps:

(more…)

Categories: 5th Grade, Lesson plans, Math, Spreadsheets | Leave a comment

#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…)

Categories: 2nd, 3rd Grade, 4th Grade, 5th Grade, 8th grade, Art, Lesson plans, Spreadsheets | Leave a comment

#101: Don’t Print Homework–Email it!

By third grade, students can email their homework to you rather than turn in all those pesky hard copies. No more lost work, no more dog-ate-their-homework, no more blaming their mom. They can use their own account or a parents. Once they learn how, it is automatic–and they love doing it this way. (more…)

Categories: 3rd Grade, 4th Grade, 5th Grade, 8th grade, Freebies/Discounts, Lesson plans, Spreadsheets, Teacher resources, Web Tools, Word processing | Tags: , | Leave a comment

#75: Tessellations in Excel

Excel will clear up the confusion about tessellations. They are simple, quick and fun. Read on: (more…)

Categories: 5th Grade, 8th grade, Lesson plans, Spreadsheets, Teacher resources | Leave a comment

#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…)

Categories: 3rd Grade, 4th Grade, 5th Grade, 8th grade, Art, Freebies/Discounts, Lesson plans, Spreadsheets, Teacher resources | Leave a comment

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

excelpowerpointpublisherkeyboarding

[caption id="attachment_1075" align="aligncenter" width="176" caption="Mouse lesson plans"]mouse[/caption] [caption id="attachment_1072" align="aligncenter" width="150" caption="Take a break"]Computer humor[/caption]
Categories: 1st, 2nd, 3rd Grade, 4th Grade, 5th Grade, 8th grade, DTP, Google, Humor, Keyboarding, Kindergarten, Lesson plans, Photoshop, Slideshows, Spreadsheets, Teacher resources, Tech tips, Web Tools, Websites, Word processing | Tags: | Leave a comment

Tech Tip #16: Email That Document

tech tipsAs 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!

(more…)

Categories: DTP, Parents, Slideshows, Spreadsheets, Teacher resources, Tech tips, Word processing | Tags: | Leave a comment

#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

Categories: 3rd Grade, 4th Grade, 5th Grade, Freebies/Discounts, Lesson plans, Math, Spreadsheets, Teacher resources | 3 Comments

Tech Tip #16: Email That Document

tech tipsAs 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!

(more…)

Categories: 5th Grade, 8th grade, Classroom management, Computer skills, DTP, Slideshows, Spreadsheets, Teacher resources, Word processing | Tags: | Leave a comment