Internet Lesson Plan
- Computer
- Senior

- Activity Time
- Materials
- Concepts / Topics
- Resource Type
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