Category: 5th Grade

math

#72: How to Check Your Math in Excel

This is one of the most popular lessons I teach to Excel beginners. It is relevant, instantly usable and makes sense from the beginning. Before you start this one, be sure to complete Project 70 and 71.

[gallery columns="2" ids="45219,45218"]

–from 55 Technology Projects for the Digital Classroom

–5 lesson plans for spreadsheets


Jacqui Murray has been teaching K-8 technology for 15 years. She is the editor/author of over a hundred tech ed resources including a K-8 technology curriculum, K-8 keyboard curriculum, K-8 Digital Citizenship curriculum. She is an adjunct professor in tech ed, CSG Master Teacher, webmaster for four blogs, anAmazon Vine Voice book reviewer, Editorial Review Board member for Journal for Computing Teachers, CAEP reviewer, CSTA presentation reviewer, freelance journalist on tech ed topics, and a weekly contributor to TeachHUB. You can find her resources at Structured Learning.

updated 5-18-16

18 Online Keyboard Sites for Kids

You want to practice 10-15 minutes two to three times a week. Even for kindergartners. Choose a fun software program–whichever will keep their attention when they’re young. I use Type to Learn Jr. in my school until half-way through first grade, but there are other good ones. For the older children, I use Type to Learn. I have great results with it. Students are challenged, intrigued, motivated by the prizes and the levels.

Another option is online typing sites. Typingweb is good. It’s a graduated program that keeps track of your progress. If you’re picking an online program as an alternative to software, it’s important to log in so the software remembers what your child has accomplished. If you’re going to use online sites as part of an overall typing practice curriculum, here are some other good sites to try:

  1. Keyboard challenge—adapted to grade level http://www.abcya.com/keyboard.htm
  2. Keyboard practice—quick start http://www.keybr.com/
  3. Keyboarding Fingerjig—6 minute test of ability http://www.jonmiles.co.uk/fingerjig.php
  4. Keyboarding for Kids http://webinstituteforteachers.org/~gammakeys/Lesson/Lesson1.htm
  5. Keyboarding practice http://www.usspeller.com/keytutor.html
  6. Keyboarding—alphabet rain game http://www.powertyping.com/rain.shtml (more…)
digital whiteboard

*8: Fifth Grade Cloning in Photoshop

clone3Adobe Photoshop is kind of like 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.

We’ve already completed Word image editing basics here and Photoshop autofixes here. This one on cloning is going to be a favorite of your children.

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

#15: A Holiday Letter for Grades 2-6

 

This holiday letter can be as simple (for 2nd graders) or sophisticated (middle school) as your students can handle. There are a gamut of skills–

  • text
  • borders
  • pictures (from the internet, from clip art, from a separate file folder on your school server)
  • different fonts, font colors, font sizes

I’ve included a grading rubric to guide students in accomplishing as much as they can. Start with the basics (text, a border, some pictures) and add more skills as students get used to the early ones: (more…)