Teachers.Net
JoinLog in
Teachers.Net

Internet Lesson Plan

By Jeff Fruster

  • Computer
  • Senior
Activity Time
1hr 30 min
Materials
computer, book,
Concepts / Topics
filtering, hiding, using the drawing tool, adding/editing pictures, hyperlinks
Resource Type
Lesson Plan

The teacher demonstrates spreadsheet tasks as students read and take notes, then students complete the steps on their own computers and save their work.

Standards

Business Computer Applications 1 and 2

Activity/Course Codes: 5008 and 5009

D.5, D.6

Objectives

Students will be able to sort data in a worksheet, use AutoFilter to extract specified data from the worksheet, hide worksheet columns or rows, and use the drawing toolbar. In addition to these tasks, students will be able to insert a picture in a worksheet, use Excel templates to format a worksheet, insert a hyperlink in a worksheet, save a workbook in a different format, and add/edit comments. How to create and respond to discussion comments will also be covered, along with how to use the research tool.

Instructional Design

Presentation/Demonstration

I will open class by having students log on to their computers and turn to the “Making the Worksheet Useful” section in their books. Students will be instructed to take notes during the reading portion of the chapter, covering vocabulary and the various processes. I will then walk them through steps 6.1–6.12:

  • 6.1 and 6.2: Filtering.
  • 6.3: Hiding columns and rows.
  • 6.4 and 6.5: Using the drawing tool.
  • 6.6 and 6.7: Adding/editing pictures.
  • 6.8: Using templates.
  • 6.9: Working with hyperlinks.
  • 6.10: Saving spreadsheets on the internet.
  • 6.11: Editing/viewing comments.
  • 6.12: Using the research tool to gather information from the internet.

Guided Practice

Every action or process contained in steps 6.1 through 6.12 will be demonstrated from my computer onto a projection screen so students may view all the steps before completing them.

Independent Practice

Students will complete their own notes while reading between completing the steps in the lesson. They will also complete all the secondary processes within each step after watching them demonstrated.

As students read the material, I will walk around and be available for questions. I will also view students’ screens to informally check for accuracy. After completion, students will save their work to their personal school computer files, where I can check and informally assess their work. Any common mistakes will be addressed the following class period, followed by time for questions.

Instructional design time: 1 hour, 20 minutes.

Closing

The lesson will end with the printing of all material covered in the day’s lesson. I will also hand out a half-sheet test syllabus covering the testing material. Students will have the last five minutes to save and close any programs we are working on. They will then log off. (5 minutes)

Materials

  • Computers
  • Office 2003 textbooks
  • Note-taking material

Evaluation

Evaluation will be informal. During class, I will observe students during reading time. After school, I will check their work on the school hard drive.

Adjustments

Visually impaired students will be seated at the front of class, joined by lower-level students. Higher-level students will be seated beside lower-level students for informal peer assistance.

Teachers.Net · https://teachers.net/lessons/3922.html