Category: 3rd Grade

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.

Learning computers starts in kindergarten with understanding hardware. This lesson plan (#103 in the lesson plan book noted below) includes three pages. Introduce less with K, more each year until by sixth grade, students are good hardware problem solvers because they understand the basics.

Page 2 is an assessment you can either print out and have students fill in or push out to students to be completed online.

(more…)

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

Over the next week, I’ll share ideas that will get you ready for your Hour of Code. This includes (links won’t work until the articles are posted):

1. An Overview of This Week
2. Long list of websites by grade
3. 10 Unusual Projects
4. 6 Unplugged Hour of Code Activities (today)

***

These unplugged activities go back to the roots of coding. The idea started as a clever way to teach students to think critically and problem-solve. The easiest way was to gamify coding, put students on a digital device they loved, and set them free. One hour, according to Hour of Code, would show them that deep thinking was fun and problem-solving was exhilarating.

I happen to agree. Some of my most gratifying moments are when I accomplish the impossible, unravel a Mobius Strip-like problem, or force myself to do what I’ve never before done. Hour of Code does that every year for oh many students. But here’s my issue: Too often, kids forget that the goal is to practice critical thinking and problem solving, not pursue a career in programming.

Let’s reinforce that goal by stepping away from digital device, recognize that these skills — critical thinking and problem-solving — apply to any part of life, even without a computer, iPad, or smartphone in hand. All kids need is their brain which happily, every child carries with them.

Here are some of my favorite unplugged activities:

Crazy Circuits With Squishy Circuits

(more…)

Common Core tells us:

New technologies have broadened and expanded the role that speaking and listening play in acquiring and sharing knowledge and have tightened their link to other forms of communication. Digital texts confront students with the potential for continually updated content and dynamically changing combinations of words, graphics, images, hyperlinks, and embedded video and audio.

The underlying theme can’t be ignored by teachers any longer: A 21^st Century learner requires technologic proficiency. Proof enough is that Common Core summative assessments will be completed online—only possible if students use technology as comfortably as paper and pencil to demonstrate knowledge.

But how do you do that if you aren’t a ‘techie’ or a ‘geek’, if you barely use a Smartphone much less the myriad of online tools. I have ten strategies that will make your teaching life easier, bump up your effectiveness with students, and save time complying with Common Core standards. Try these ten tech uses. Watch what a difference they make:

(more…)

I get a lot of questions from readers about what tech ed resources I use in my classroom so I’m going to take a few days this summer to review them with you. Some are edited and/or written by members of the Ask a Tech Teacher crew. Others, by tech teachers who work with the same publisher I do. All of them, I’ve found well-suited to the task of scaling and differentiating tech skills for age groups, scaffolding learning year-to-year, taking into account the perspectives and norms of all stakeholders, with appropriate metrics to know learning is organic and granular.

Today: K-8 Keyboard Curriculum

Overview

K-8 Keyboard Curriculum (four options plus one)–teacher handbook, student workbooks, companion videos, and help for homeschoolers

2-Volume Ultimate Guide to Keyboarding

K-5 (237 pages) and Middle School (80 pages), 100 images, 7 assessments

K-5–print/digital; Middle School–digital delivery only

Aligned with Student workbooks and student videos (free with licensed set of student workbooks)

Student workbooks sold separately

__________________________________________________________________________

1-Volume Essential Guide to K-8 Keyboarding

120 pages, dozens of images, 6 assessments

Great value!

Delivered print or digital

Doesn’t include: Student workbooks

(more…)

Here’s a great list of age-appropriate, safe websites that will inspire third graders whether they’re in your classroom or at home (check here for updates):

1. Riding the Wind with Kalani
2. Weather Websites
3. Wild Weather Adventure
4. All About America
5. USA Puzzle
6. 360^o views from around the world
7. Computer lab favorites
8. How stuff works
9. Quick quizzes—how much do you know?
10. Thinking Skills–Riddles
11. USA Puzzle
12. Water Cycle–very visual; good tool for lower grades
13. Water cycle–interactive
14. Water cycle—label diagram

More resources for third graders

33 Resources for Read Across America Day

Hour of Code Lesson Plans by Grade

3rd Grade Resources

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.

Hour of Code–December 7th-12, 2020–is a time when teachers show students why they should love-not-fear coding and students find out that these activities — often seen as geeky or impossible — aren’t. They’re actually fun.

Over the next week, I’ll share ideas that will get you ready for your Hour of Code. This includes (links won’t work until the articles are posted):

• Hour of Code? Here’s why you should participate
• Long list of websites by grade
• 10 Unusual Projects
• 6 Unplugged Activities for Hour of Code

***

These suggestions go back to the roots of coding. The idea started as a clever way to teach students to think critically and problem-solve. The easiest way was to gamify coding, put students on a digital device they loved, and set them free. One hour, according to Hour of Code, would show them that deep thinking was fun and problem-solving was exhilarating.

I happen to agree. Some of my most gratifying moments are when I accomplish the impossible, unravel a Mobius Strip-like problem, or force myself to do what I’ve never before done. Hour of Code does that every year for oh many students. But here’s my issue: Too often, kids forget that the goal is to practice critical thinking and problem solving, not pursue a career in programming.

Let’s reinforce that goal by stepping away from digital device, recognize that these skills — critical thinking and problem-solving — apply to any part of life, even without a computer, iPad, or smartphone in hand. All kids need is their brain which happily, every child carries with them.

Here are some of my favorite unplugged activities:

Crazy Circuits With Squishy Circuits

If you’re wondering how squishy dough can conduct electricity, watch this 4-minute TED Talk. Though the video shows how to make the dough, you don’t have to do that. Ward’s Science sends it as part of the kit. You just attach the circuits, motors, and conductors, and let your creativity flow:

(more…)

I get a lot of questions from readers about what tech ed resources I use in my classroom so I’m going to take a few days this summer to review them with you. Some are edited and/or written by members of the Ask a Tech Teacher crew. Others, by tech teachers who work with the same publisher I do. All of them, I’ve found, are well-suited to the task of scaling and differentiating tech skills for age groups, scaffolding learning year-to-year, taking into account the perspectives and norms of all stakeholders, with appropriate metrics to know learning is organic and granular.

Today: K-12 Technology Curriculum

Overview

The K-12 Technology Curriculum is Common Core and ISTE aligned, and outlines what should be taught when so students have the necessary scaffolding to use tech in the pursuit of grade level state standards and school curriculum.

Each book is between 212 and 252 pages and includes lesson plans, assessments, domain-specific vocabulary, problem-solving tips, Big Idea, Essential Question,  options if primary tech tools not available, posters, reproducibles, samples, tips, enrichments, entry and exit tickets, and teacher preparation. Lessons build on each other kindergarten through 5th grade. Middle School and High School are designed for the grading period time frame typical of those grade levels with topics like programming, robotics, writing an ebook, and community service with tech.

Most (all?) grade levels include base topics of keyboarding, digital citizenship, problem solving, digital tools for the classroom, and coding.

Included are optional student workbooks (sold separately) that allow students to be self-paced, responsible for their own learning. They include required rubrics, exemplars, weekly lessons, full-color images, and more.

The curriculum is used worldwide by public and private schools and homeschoolers.

Who needs this

Tech teachers, tech coordinators, library media specialists, curriculum specialists

Classroom grade level teachers if your tech teacher doesn’t cover basic tech skills.

(more…)

I get a lot of questions from readers about what tech ed resources I use in my classroom so I’m going to take a few days this summer to review them with you. Some are edited and/or written by members of the Ask a Tech Teacher crew. Others, by tech teachers who work with the same publisher I do. All of them, I’ve found well-suited to the task of scaling and differentiating tech skills for age groups, scaffolding learning year-to-year, taking into account the perspectives and norms of all stakeholders, with appropriate metrics to know learning is organic and granular.

Today: K-8 Keyboard Curriculum

Overview

K-8 Keyboard Curriculum (four options plus one)–teacher handbook, student workbooks, companion videos, and help for homeschoolers

2-Volume Ultimate Guide to Keyboarding

K-5 (237 pages) and Middle School (80 pages), 100 images, 7 assessments

K-5–print/digital; Middle School–digital delivery only

Aligned with Student workbooks and student videos (free with licensed set of student workbooks)

Student workbooks and videos sold separately

__________________________________________________________________________

1-Volume Essential Guide to K-8 Keyboarding

120 pages, dozens of images, 6 assessments

Great value!

Delivered print or digital

Doesn’t include: Student workbooks or videos

(more…)