lesson plan

NTeQ Lesson Plan

Lesson Title: Microsoft Excel

Subject Area(s): Technology Grade Level: Elementary school

Lesson Summary

Briefly describe the purpose of the lesson and the student activities.

Learning Objectives

By the end of this lesson, the students will:

(1) Learners will be able to create an Excel spreadsheet, focusing on ‘auto-sum’ tool.

(2) Learners will be able to use Excel ‘auto-sum’ feature to total columns that contain constants.

(3) Learners will be able to learn about the many functions of Microsoft Excel

(4) Learners will be able to efficiently input information in MS Excel.

(5) Learners will understand the importance of creating and maintaining a spreadsheet to manage numbers-related tasks and present the information in ways that can be easily read and understood.

(6) Learners will know the data input in Excel (columns, rows, and cells), types of data (labels, constants, and formulas).

(7) Learners will be able to create different types of charts and diagrams.

(8) Learners will learn how to import documents from other files and incorporate them in Microsoft Excel.

(9) Larners will be able to appreciate Microsoft Excel in data presentation.

Standards

National:

· Candidates contribute to the development, communication, and implementation of a shared vision for the comprehensive use of technology to support a digital-age education for all students.

· Candidates design, develop, and implement technology-rich professional learning programs that model principles of adult learning and promote digital-age best practices in teaching, learning, and assessment.

Materials

Computers with Microsoft Excel. Handouts.

Computer Functions and Data Manipulation

Computer Function	Computer Application	Data Manipulation
·	·	·
·	·	·
·	·	·

Specify Problem

Write in language you will use with students. For example, Today, we are going to investigate…… What would you do if …..

Results Presentation

Multidimensional Activities

Briefly describe the lesson activities. Begin with the Lesson Introduction or how you will introduce the problem and how you will address prerequisite skills, share learning objectives, and provide needed information. As you describe the computer activities, please include what students need to do before they go the computers, while they are at the computers, and what they do after they finish computer work. Descriptions of the supporting activities follow the computer activities. This form has space for three computer and three supporting activities. When you design your lesson, include the appropriate number of each for your particular lesson. After these activities are planned, describe the Culminating Activity, or how main ideas will be reviewed and/or final presentations given. When these components are planned describe the rotation plan – how will students rotate between the activities.

Lesson Introduction – Briefly describe how you will introduce the problem and how you will address any prerequisite skills, share learning objectives, and provide needed information.

Computer Activities

Activity 1 Activities to be completed: Prior to going to computer At the computer After going to computer

Activity 2 Activities to be completed: Prior to going to computer At the computer After going to computer

Activity 3 Activities to be completed: Prior to going to computer At the computer After going to computer

Supporting Activities

Activity 1 Activities to be completed:

Activity 2 Activities to be completed:

Activity 3 Activities to be completed:

Culminating Activity – Briefly describe how main ideas will be reviewed and/or final presentations given.

Rotation Plan Briefly describe how students will rotate through the computer and supporting activities

Assessment Use a template similar to the one below to develop your rubric(s). A sample is provided to guide your writing.

Rubric Template. Place performance objectives in the first column, then create descriptions of each level of performance.

Objective or Performance	Beginning 1	Developing 2	Accomplished 3	Exemplary 4	Score
1.	Description of identifiable criteria that reflect a beginning level of performance.	Description of identifiable criteria that reflect progress toward mastery of performance	Description of identifiable criteria that reflect mastery of performance	Description of identifiable criteria that reflect exceptional performance.
2	Repeat with next item	“	“	“

Sample: Newspaper Article on Seatbelt Safety

Objective or Performance	Beginning 1	Developing 2	Accomplished 3	Exemplary 4	Score
1.Students will write a persuasive article on why drivers should wear seatbelts	Persuasive arguments are not clear or concise and had very poor references made to supporting graphics.	Persuasive arguments are fairly clear and concise. References made to graphics provide limited support.	Persuasive arguments are clear, concise, and articulate. References made to supporting graphics are useful.	Persuasive arguments are very clear, concise, and articulate. Excellent references made to supporting graphics.
2. Students will generate spreadsheet charts that demonstrate a trend.	The charts show very little about seatbelt use. The title, labels, legend, are missing or incomplete.	The charts show limited aspects of seatbelt use. The title, labels, legend, and type of chart provide incomplete support.	The charts demonstrate trends in seatbelt use. The title, labels, legend, and type of chart support understanding.	The charts clearly demonstrate trends in seatbelt use. Excellent choice of title, labels, legend, and type of chart.

Objective or Performance	Beginning 1	Developing 2	Accomplished 3	Exemplary 4	Score