Teachers.Net
JoinLog in
Teachers.Net

Introduction the MS Excel

By Jimmy Yu

  • Computer
  • Middle
Activity Time
2-3 hours
Materials
computer, MS Excel
Concepts / Topics
excel, autosum, formulas
Resource Type
Lesson Plan

Students set up an Excel spreadsheet, enter grocery items and prices, use AutoSum to total prices, and submit a printed spreadsheet for assessment.

Introduction to Microsoft Excel

Computer Applications Jimmy Yu Oak Avenue Intermediate

Subjects: Computer Applications and Math

Time: 2 class periods (2–3 hours)

Student Technology Standard Addressed

1(e): Sort, organize, interpret, and display information using spreadsheets, databases, and graphs.

Learning Objectives

  • Open MS Excel and set up a spreadsheet.
  • Use the MS Excel AutoSum feature to total columns that contain constants—in this case, prices.
  • Identify the parts of an MS Excel spreadsheet: cells, rows, and columns.
  • Efficiently input information in MS Excel.
  • Understand the importance of AutoSum and how formulas are created in MS Excel.
  • Understand the importance of creating and maintaining a spreadsheet to manage numbers-related tasks.

Resources Needed

Teacher-created class handouts and a computer for each student with MS Office software, including MS Excel.

Hook and Prior Knowledge

  • Have you ever shopped in a supermarket?
  • Do you or your parents use a grocery checklist?
  • Do you or your parents ever compare prices?

Review basic MS Office tools: bold, font changes, font size, highlighting, and text alignment.

Review data input in MS Excel, including columns, rows, and cells, and types of data: labels, constants, and formulas.

Check for Understanding

What are we going to do today?

  • Create a spreadsheet.
  • Input data in MS Excel.

What are we going to use the AutoSum tool for?

  • To efficiently create a formula to total prices.

Concept and Skill Development: Guided Practice

Model making a short grocery checklist with prices.

ITEMAMOUNTQTY/LBSTOTAL
Apples$1.392
Orange juice$2.781
New York steak$7.992
Plastic cups$3.591
GRAND TOTAL

Show how to properly set up a spreadsheet in MS Excel. Use the AutoSum feature to total the prices.

Essential Questions

  • What did I do?
  • Why did I do this?
  • How can this help me?
  • Why is the AutoSum feature necessary?

Why Is This Important?

  1. Learning technology.
  2. Making life easier.
  3. Helping with organization.

Independent Practice

Students will create an MS Excel spreadsheet, focusing on the AutoSum tool.

Student Assessment

  • Visually check students’ work at their computers to see whether they are using the AutoSum function correctly.
  • Students will print and turn in a spreadsheet for assessment.

Differentiation of Instruction

GATE / High-Level Achievers

Students will analyze and compare the use of formulas with the more traditional method of simple calculations. They will produce a brief summary of their analysis. Additionally, they will model and explain the steps to others in the class to demonstrate their understanding of the subject.

Below Grade Level

Students will work in groups and discuss what a spreadsheet is and the function of a formula. They will insert data into MS Excel, identify a formula, and recall the AutoSum feature.

English Language Learners (ELL)

ELL students will be paired with a helpful, high-achieving student to reinforce the strategies given by the teacher. They will be encouraged to use the electronic dictionary to aid comprehension. Additionally, they will receive teacher-typed notes that summarize or outline the oral instructions given in class. They will identify a formula and a spreadsheet, and recall the AutoSum feature.

Closure

The closure activity will be the independent activity and the printed assignment turned in for assessment. Afterward, I will use the LCD projector and ask individual students to identify parts of an MS Excel spreadsheet.

Post-Lesson Reflection / Assessment

Oral instruction will be provided along with a teacher-created handout. I will go over the handout with the students to ensure understanding. I will activate prior knowledge by discussing grocery checklists, balance sheets, calculations, and basic math terms. Students will be encouraged to work cooperatively to share knowledge and information during guided practice and independent practice.

Next Steps

Next logical steps include reteaching the lesson in another format. For example, I will add a lesson that calculates an account balance (credits, debits, and subtotals), as well as one that calculates percentages (basketball shooting percentages). Follow-up activities will involve the entire class to reinforce the importance of spreadsheets and formulas.

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