Excel makes graphs simple and easy for beginners. Even my parent helpers are amazed at how much students can do with a simple F11 shortkey and a right click. This lesson plan works just as well with Google Sheets though you may have to adapt a few of the instructions.

If the lesson plans are blurry, click on them for a full size alternative. (more…)

I have to reblog this wonderful post by my efriend, Lisa. How many of these fit you? Can you add to this list?

You Know You’re a Techy Teacher When…

1. You can’t remember the last time you printed a classroom document.
2. Plurking, tweeting, and playing with your wiki in public are acceptable behaviors.
3. Your Notebook isn’t spiral bound – it plugs into the wall.
4. Forget the garden…you spend more time on the weekend weeding out your Inbox.
5. You can recite your school’s Acceptable Use Policy by heart.
6. On parent/teacher night, instead of exchanging business cards, you Bump.
7. You express yourself with emoticons.
8. You no longer consider it graffiti to write on someone’s wall.
9. Your significant other gets jealous of your PLN.
10. It’s not creepy to have lots of followers.
11. Your students call you the “cool” teacher.
12. The other teachers are jealous of your Instagram.
13. YouTube is blocked in your school, and you know how to get around it.
14. The Tech Department is sick of your constant requests to unblock Twitter.
15. You’ve Googled your principal.
16. You know that TweetDeck is not a patio with a lot of birds.
17. You correct your friends’ grammar when they text you.
18. “Casual Fridays” means logging into the EdTech UNconference in your bunny slippers.
19. You wear your “I Heart EdTech” button everywhere you go.
20. You read this blog post then tweet it, like it, and pass it on to a friend (more…)

This is one of the most popular lessons I teach to Excel beginners. It is relevant, instantly usable and makes sense from the beginning. Click the images below to enlarge them for viewing.

–from 55 Technology Projects for the Digital Classroom

Copyright ©2023 usna.wordpress.com – All rights reserved.

This project (#70 in the collection of #110) hides a spreadsheet’s power behind a template you create and students fill out at home. If they’re older and more familiar with spreadsheets, involve them in creating the template. If the lesson plans are blurry, click on them for a full size alternative.

Note: The example uses Excel, but it works just as well with Google Spreadsheets.

–from 55 Technology Projects for the Digital Classroom

(more…)

Every month, we’ll share five themed posters that you can share on your website (with attribution), post on your walls, or simply be inspired.

This month: Security

–for the entire collection of 65 posters, click 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.

Subscriber Special

Until January 18th:

Free Martin Luther King Day Lesson Plans

 

(more…)

Here’s an update to my Favorite PC Shortkeys poster:

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.

Every month, subscribers to our newsletter get news to help their tech teaching.

August:

3 Ways to Learn Digital Citizenship

so you can teach your students

Building Digital Citizens: Online college-credit 5-week class

Building Digital Citizens: Online certificate class delivered via Google Classroom (also available through Teachers Pay Teachers)

K-8 Digital Citizenship Curriculum

Here’s a preview of my Digital Citizenship materials:

(more…)

April 24th-30th:

Coaching or Mentoring

BOGO — Buy one month; get the second free

Do any of these sound like you?

• Your kindergartners don’t know what ‘enter’, ‘spacebar’, ‘click’ or many other techie words mean but you need to teach them to keyboard, internet, and become digital citizens. How do you start?
• You have new students in your class who haven’t had technology training. The rest of the class has. How do you catch them up?
• Your principal wants you to teach the technology class but you’ve never done it before. What do you do on the first day?
• You’ve been teaching for twenty years but now your Principal wants technology integrated into your class. Where do you start?
• You have a wide mix of tech skills among students in your class. How do you differentiate between student geeks and students who wonder what the right mouse button is for?
• You’ve been tasked with organizing a Technology Use Plan for your school. Where do you start?
• You and colleagues are expected to create a Curriculum Map. How does technology fit into that?
• You love being an edtech professional but what’s your career path?

More and more teachers–both new and experienced–are looking for coaching or mentoring to fill gaps in their learning, keep up to date on the latest teaching strategies, and solve problems they didn’t expect. Many turn to the personalized approach we offer in a collaboration between Ask a Tech Teacher, Jacqui Murray, and Structured Learning. Coaching is completed via Google Hangout with email available for quick questions. After only a short time, teachers find they are better prepared with tech-infused lesson plans, able to teach to standards more fluently, can integrate tech into core classroom time, easily differentiate for student needs with tech, and more.

“Once a month, pick my brain. I’ll share what I’ve learned and what works from 25 years of teaching.” –Jacqui Murray

Normally, we charge a $150 per month with a two month minimum (for a total of $300). This month between the 24th and 30th, get both months of coaching or mentoring for only $150.

Click our PayPal Me here. Add $150.00 to the line.

Because it’s PayPal, you can enter as a guest with any credit card–no PayPal account required.

We wrote the books. We’ll help you deliver on keyboarding, integrating tech into your curriculum, digital citizenship, Common Core, and more. Questions? Ask Jacqui Murray at askatechteacher at gmail dot com.

(more…)

Through my Teachers Pay Teachers store, I have two lesson plans help you plan Martin Luther King Day on January 15, 2018.

4th grade

Students interpret the words of Dr. Martin Luther King in their own words in a visual organizer. Great project that gets students thinking about the impact of words on history. Common Core aligned. 7-page booklet includes a sample, step-by-step projects, a rubric for assessment, and additional resources to enrich teaching.

5th grade

Students research events leading up to Dr. Martin Luther King’s impact on American history and share them with an Event Chain organized visually, including pictures and thought bubbles. Aligned with Common Core. 7-page booklet includes a sample, step-by-step projects, a rubric for assessment, and additional resources to enrich teaching.

(more…)