One of the most popular applications of math is through spreadsheets (like Excel) that make those numbers relevant to everyday life. We’re going to provide a series of lessons on spreadsheet basics you can use in your K-8 classroom. Here are some of the topics we’ll cover:

1. #74: Mastering Excel (for Beginners)
2. #71: Beginning Graphs in MS Excel
3. #70: Create a Timecard in Excel for Grade Two and Up
4. #73: How to Graph in Excel
5. #12: Create Simple Shapes in Excel
6. #75: Tessellations in Excel
7. #72: How to Check Your Math in Excel
8. How to Use Excel to Teach Math Arrays
9. #62: Email from Word (Or PowerPoint or Excel)
10. #79: Excel Turns Data Into Information

Today:

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

January 4th-9th

the 56-page PDF, “25 Digital Tools for the Classroom”

for free!

“25 Digital Tools for the Classroom” is a thorough discussion on which are the most useful tools in a K-8 classroom, organized by grade level. This includes popular digital tools such as blogs, backchannel devices, vocabulary decoding tools, avatars, digital portfolios, digital note-taking, as well as others you may not have thought of. Here’s what you do:

• Sign up for our newsletter, Weekly Websites, Tech Tips, and Tech Ed News. If you already subscribe, qualify by purchasing one of our resources on the Structured Learning website. Any product, any price qualifies.
• Email us the welcome message or receipt you receive (we’re at askatechteacher at gmail dot com). Make the subject line read, “Please send free ’25 Digital Tools for the Classroom'”.
• We’ll send you the collection.
• If the newsletter doesn’t work for you, there’s an ‘unsubscribe’ at the bottom of each email.

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

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

This month: Safety and Security

–for the entire collection of 65 posters, click here

(more…)

In these 169 tech-centric situations, you get an overview of pedagogy—the tech topics most important to your teaching—as well as practical strategies to address most classroom tech situations, how to scaffold these to learning, and where they provide the subtext to daily tech-infused education.

Today’s tip: Top Ten Internet Shortkeys

Category: Internet

Sub-category: Keyboarding

Here’s a poster with ten favorite shortkeys students will love when using the internet:

Sign up for a new tip each week or buy the entire 169 Real-world Ways to Put Tech into Your Classroom.

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