Category: 5th 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.

Before teaching Lesson Plans using Photoshop, be sure to cover the basics with students:

Open Photoshop. Notice the tool bars at the top. These will change depending upon the tool you choose from the left side. These are the crux of Photoshop. We’ll cover about ten of them in fifth grade. The rest will have to wait. The right-hand tools are used independent of the left-hand tools. They are more project oriented.

• Click the File Browser tool (top right-ish). It shows you the folders on your computer. From here, you can select the picture you’d like to edit (or use File-open) (more…)

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

Background: None. This is an intro to MS Excel or spreadsheets

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

Time: About 30 minutes

Steps:

(more…)

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

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

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

1. Animals
2. Wolfquest—simulation–DL
3. Civics games
4. FBI Games
5. Looking Glass—animated story
6. Snap!—runs in your browser
7. Tynker
8. Wolfram Alpha widgets
9. Dig hole through the earth with Google Earth
10. Whyville–Social Media Sim
11. Spent
12. Earth science animations
13. Geography for Kids
14. Geography Games
15. Geography Games II
16. Geography—geonet game
17. Geography quiz—Seterra
18. Maps—Make them
19. States games

(more…)