Category: Teacher resources

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

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

digital whiteboard

#25: Intro to PowerPoint–with KidPix Pictures

Drawings are done in KidPix. Assign topics (me, my family, etc) for grades K-1 to reinforce the concept of following directions. With 2nd grade, use one picture for each of the parts of a story—characters, plot, setting, climax/resolution.  Mix pictures and text.  Younger students can show these to parents at Open House or a parent night using Windows slideshow function (something they can do without assistance after a bit of practice). Second graders can create a PowerPoint slideshow that will knock the socks off of their parents.

This is the first of about six projects in PowerPoint (see sidebar for more). Start with this one and build up to the last. (more…)