One of the most popular applications of math is through spreadsheets (like Excel) that make numbers relevant to everyday life. Many think this is too complicated, too cerebral, someone can do it but not them–they’d be wrong. I start my students in 1st grade with spreadsheets (though they don’t call it that) like this art exercise:

and build on their skills until they have the basics by fifth grade.

Then, we spend middle school applying those skills to lessons.

Over the next few months, we’ll 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

–from 55 Technology Projects for the Digital Classroom.  (more…)

Adobe Photoshop is kind of KidPix for grown-ups, as well as the default photo-editing program for anyone serious about graphics. This series of projects (available in the first volume of the book, 55 Technology Projects for the Digital Classroom) introduces students to a traditionally-challenging program in an easy to understand way, each project scaffolding to the next, thus avoiding the frustration and confusion inherent in most Photoshop training.

Here are the skills fifth graders can learn in Photoshop if you’ve prepared them with basic computer skills. I’ve provided links. The bolded ones are published, unbolded coming soon:

• Photoshop artwork–live
• Photoshop actions–live
• Photoshop basics #5 live
• Photoshop filter and rendering tools
• Photoshop starters–auto-correct with the auto-correction — live quick fixes that make a photo look cleaner #6
• Photoshop crop tool–Live
• Photoshop clone tool– live
• Photoshop–change the background–live
• Photoshop tools–add custom shapes–live
• Photoshop–start with Word –live (a little dated but still useful)

Today: Cloning

The clone tool duplicates a hard to crop-and-copy image (like the flowers below) or deletes part of a background—a sign or a post in a nature scene—you don’t want there. You can clone within a picture (as with the flowers), (more…)

One of the best ways to get students interested in technology is allow them to personalize their work area. That starts with placing wallpaper of their choice on their desktop. (more…)

Here are the basic skills fifth graders can learn in Photoshop if you’ve prepared them with basic computer skills. I’ve provided links but they aren’t live until publication:

• Photoshop artwork–live
• Photoshop actions–live
• Photoshop basics #5 live
• Photoshop filter and rendering tools
• Photoshop starters–auto-correct with the auto-correction — live quick fixes that make a photo look cleaner #6
• Photoshop crop tool–Live
• Photoshop clone tool– within a picture and to another picture #8
• Photoshop–change the background–live
• Photoshop tools–add custom shapes–live
• Photoshop–start with Word –live (a little dated but still useful)

Before trying this lesson, start here. Don’t worry. It’s not hard–just the basics.

Getting Started

Ready? Let’s start with what Adobe Photoshop is–a grown-up KidPix, and the default photo-editing program for anyone serious about graphics. This series of projects (available in 55 Technology Projects for the Digital Classroom Volume I) introduces students to a traditionally-challenging program in an easy to understand way, each scaffolding to the next, thus avoiding the frustration and confusion inherent in most Photoshop training.

There are three ways to crop in Photoshop:

(more…)

I get a lot of questions from readers about what tech ed resources I use in my classroom so I’m taking a few days this summer to review them with you. Some are from members of the Ask a Tech Teacher crew. Others, from 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: Lesson Plans

There are lots of bundles of lesson plans available–by theme, by software, by topic, by standard. Let me review a few:

• STEM Lesson Plans
• Coding Lesson Plans
• By Grade Level
• 30 K-5 Common Core-aligned lessons
• 110 lesson plans–integrate tech into different grades, subjects, by difficulty level, and call out higher-order thinking skills.
• singles–for as low as $.99 each. Genius Hour, Google Apps, Khan Academy, Robotics, STEM, Coding, and more.
• Holiday projects–16 lesson plans themed to holidays and keep students in the spirit while learning new tools.

Who needs this

These are for the teacher who knows what they want to teach, but need ideas on how to integrate tech. They are well-suited to classroom teachers as well as tech specialists.

(more…)

Here are the basic skills fifth graders can learn in Photoshop if you’ve prepared them with basic computer skills. I’ve provided links but they aren’t live until publication:

• Photoshop artwork–live
• Photoshop actions–live
• Photoshop basics #5 (this lesson)
• Photoshop filter and rendering tools
• Photoshop starters–auto-correct with the auto-correction — quick fixes that make a photo look cleaner #6
• Photoshop crop tool–with the lasso and the magic wand #7
• Photoshop clone tool– within a picture and to another picture #8
• Photoshop–change the background–live
• Photoshop tools–add custom shapes–live
• Photoshop–start with Word –live (a little dated but still useful)

Get started

Open Photoshop. What you see will vary depending upon your Photoshop version. Adapt the lesson to what your school offers.

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. Cover about ten 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. 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…)

Here are the basic skills fifth graders can learn in Photoshop if you’ve prepared them with basic computer skills. I’ve provided links but they aren’t live until publication:

• Photoshop artwork–already live
• Photoshop actions–already live
• Photoshop basics
• Photoshop filter and rendering tools
• Photoshop starters–auto-correct with the auto-correction tools–those quick fixes that make a photo look cleaner (coming up)
• Photoshop crop tool–with the lasso and the magic wand
• Photoshop clone tool– within a picture and to another picture
• Photoshop–change the background (put yourself in front of the Eiffel Tower or on top of Hoover Dam)
• Photoshop tools–add custom shapes

Getting Started

Before we get into Photoshop, we’ll start with a program your fifth grader is most likely comfortable with: MS Word. For basic image editing, Word does a pretty good job, so we’ll start with a project using Word’s tools. Each version of Word has slightly different tools so adapt your lesson to what is available in your school. Plus, if you’re using a different word processor (i.e., Google Docs), adapt this to its tools:

• Open a blank document. Insert a picture with multiple focal points (see samples).
• Duplicate the image once for each focal point.
• Click one image to activate toolbar.
• Crop each duplicate to show just one of the focal points available in the Picture toolbar
• Use other tools available on the toolbar. This will vary, but may include
  • add a border
  • wrap
  • change background
• Rotate picture creatively.
• Resize and move to fit on page
• Test picture effects available
• If you use pictures from the internet, be sure they’re royalty free.

(more…)

The program that says ‘pro’ more than any other is Adobe Photoshop. Believe it or not, there are a whole list of skills easy enough for a fifth grader (maybe even fourth, but I haven’t had time to test it yet).

Over the next months, in this series, I’ll show you how to teach Photoshop skills appropriate for fifth grade and up. The list includes:

• Photoshop artwork–already live
• Photoshop actions–already live
• Photoshop basics
• Photoshop filter and rendering tools
• Photoshop starters–auto-correct with the auto-correction tools–those quick fixes that make a photo look cleaner (coming up)
• Photoshop crop tool–with the lasso and the magic wand
• Photoshop clone tool– within a picture and to another picture
• Photoshop–change the background (put yourself in front of the Eiffel Tower or on top of Hoover Dam)
• Photoshop tools–add custom shapes
• Photoshop–start with Word (a little dated but still useful)

I’ve provided links, but they aren’t live until publication. These can be adapted to other art programs like Canva. Here are examples of the type of project students can create: (more…)

Photoshop reputation as a photo editor ignores its many other tools that enable you to draw like a pro with a wide variety of brushes, textures, and scintillating extras. This side of Photoshop is perfect for creative projects that tie in with many different classroom lesson plans.

Want more Photoshop projects available in this project book? Check these out, then click the link below:

(more…)

By fourth grade, my students are so good at PowerPoint, I don’t even teach it in fifth grade (I move on to Photoshop). They’ve learned enough to get them through school. Here’s how I do that: (more…)