ILCTE Lesson Spreadsheets

5 E Lesson Plan

Teacher: Ryan O’Shea

School: Cairo High School (Cairo, Illinois)

Objectives:

Students will be able to define a cell given a data range and set of values.

Students will be able to format a cell given a data range and set of values.

Students will be able to reference an absolute cell given a data range and set of values.

Students will be able to fill a group of cells given a data range and set of values.

Students will be able to use the built-in functions (AVERAGE, MIN, MAX, SUM) in Microsoft Excel or Google Sheets.

Students will be able to define a function given a data range, set of values and defined problem.

Students will be able to describe the important element for every function.

NBEA Standards:

Accounting V: Accounting Process

Achievement Standard: Complete the steps in the accounting cycle in order to prepare the financial statements.

Performance Expectations:

• Describe the impact of technology on the accounting process

Accounting VI: Interpretation and Use of Data

Achievement Standard: Use planning and control principles to evaluate the performance of an organization and apply differential analysis and present value concepts to make informed business decisions.

• Explain how to apply appropriate information technology to the accounting system.

Information Technology I: Impact on Society