Category: Lesson plans

Here are the top ten spreadsheet tips according to Ask a Tech Teacher readers. Many are for Excel–just adapt them to Google Sheets if that’s your school program. Most are free lesson plans:

• #79: Excel Turns Data Into Information
• #74: Mastering Excel (for Beginners)
• #73: How to Graph in Excel
• 71: Beginning Graphs in MS Excel
• Tech Tip #62: Email from Word (Or PowerPoint or Excel)
• How to Use Excel to Teach Math Arrays
• #12: Create Simple Shapes in Excel
• #75: Tessellations in Excel
• #72: How to Check Your Math in Excel
• #70: Create a Timecard in Excel for Grade Two and Up

(more…)

Whiteboards have long been a de rigeur staple in classrooms, occupying pride-of-place at the front of the room. Despite the popularity of hi-tech Smartscreens, the simple whiteboard remains the favored method of sharing information during class time.

But one change has revolutionized their use: They can now be projected from your iPad. Before introducing three amazing must-have whiteboard apps, let me note that there are dozens of options, all with varied traits and prices. I selected these three because they are intuitive, multi-functional, and work as a classroom tool rather than just another new widget teachers must learn.

AirSketch

Free to try

AirSketch is a basic, uncomplicated whiteboard that lets you do anything you’d normally do on a whiteboard. It’s similar to web-based options like AWW or Scriblink with two dramatic differences: It works through a iPad and can be mirrored to a computer (and from there, the class screen). This untethers teachers from their desk.  All that’s needed is an iPad, AirSketch, a class computer, and a class screen.

Here’s how to do it:

• Open AirSketch on an iPad. In the lower right corner, it provides the page’s IP address.
• Type that IP address into the computer browser and the iPad screen appears.
• Project this to the class screen while using the iPad as a whiteboard

Pros

AirSketch is simple to set up and intuitive to use. It’s exactly like using the whiteboard–though instead of markers, you use a finger. Students no longer have to traipse up to the (intimidating) front of the room to answer questions. Instead, they borrow your iPad and draw their response.

(more…)

Greeting cards are easy enough for second graders–even early readers. Using MS Publisher, pick a template, add a picture to personalize, add their name–and they’re done. It takes about 15 minutes. Kids always feel great about creating these greeting cards: (more…)

This is the only project that’s easier than the holiday card in Publisher. There’s no folding and the templates are bright, colorful and exciting for kids as young as second grade: (more…)

Here’s a great lesson plan with three activities well-suited to the discussion of architecture and design in 1st grade:

Review

Students complete three projects in two weeks to aid understanding of architecture, design, and three-dimensional thinking. They’ll experiment with spatially laying out a three-dimensional structure on a two-dimensional paper. When completed, they’ll discuss with neighbors while practicing good listening skills learned in class.

Start with a discussion of design. This includes size, shape, texture, proportion, scale, mass and color. We will apply these to rooms, buildings, and neighborhoods. Encourage students to think and analyze critically as they engage in learning.

In figures below, ask students which are two- or three-dimensions? How do they know?

Design the Classroom

Visit Classroom Architect and demo how to design the classroom with drag-and-drop pieces (see figures below). Take suggestions from class on layout. Students must think about where tables and storage are relative to other items. This is an active learning lesson that encourages visual thinking. Develop a sample based on class input and show how to make corrections if necessary.

(more…)

Lesson planning used to mean filling in boxes on a standard form with materials, goals, expectations, assessments–details like that. Certainly this is valuable information, but today’s lesson plans–like today’s lessons–demand less rote fill-in-the-blanks and more conceptualization, critical thinking, and collaboration. With the increased reliance on online resources, Skype interviews with professionals, and hands-on learning activities, lessons are no longer taught within four walls so they shouldn’t be planned that way. They need collaboration with all stakeholders from initial planning stage to revision and rewrite.

And that paper form that was copied in triplicate–now it’s an online tool that can be accessed, edited, appended, and viewed by everyone involved. In fact, it can be one of three tools, depending upon how your brain organizes ideas:

• mindmap–for those who love to throw everything out there on a canvas and arrange
• online planner–for those who fill in boxes with required information and want the lesson plan to appear fully formed from these ideas
• spreadsheet–for those who like to build from the ground up and have the lesson plan detailed and scalable–in a structured way

I’ve tried all of these and have found three favorite tools, one from each category, that work for me. Read through these, try them out, and then add a comment with what you think:

(more…)

Web 2.0 is the most exciting thing to happen to education since the schoolhouse. It is a limitless classroom, allowing students access to anything they can define. Includes what’s a digital citizen, how to create a blog, a classroom internet start page, a classroom wiki, how to join social networks and post pictures on Flikr, where to go for podcasting and online docs, and more.

Here’s where you start:

(more…)

This assessment is comprehensive, designed not to test students. but assess their knowledge as an aid to you in determining where to begin. Use it when you start a new class or to determine where are the holes in their learning.

All of these skills are covered in a multi-year once-a-week project-based program, such as described in other parts of this blog. If your classes don’t cover all of these skills, adapt the assessment to your needs. If you use Google Docs, adapt it to that program.

Click on each page of lesson plan.

(more…)

Have students teach each other the 25 most common techie problems. They learn how to solve the problem and teach the class as a presentation, then answer questions. They will feel accomplished and tech savvy.

If the lesson plans are blurry, click on them for a full size alternative.

(more…)

By third grade, students can email their homework to you rather than turn in all those pesky hard copies. No more lost work, no more dog-ate-their-homework, no more blaming their mom. They can use their own account or a parents. Once they learn how, it is automatic–and they love doing it this way.Here’s the lesson:

If the lesson plan is blurry, click for a full size alternative.

(more…)