ILCTE Lesson Spreadsheets

N-Q 3. Choose a level of accuracy appropriate to limitations on measurement when reporting quantities.

ENGAGE:

Show students some houses on Zillow or another real estate website. Ask them to write two to three sentences on what

their dream home would look like. You could use menti.com to do this introductory bell ringer activity.

EXPLORE:

The students will be given some handouts on Microsoft Excel or Google Sheets and the basics of formatting a

cell or group of cells, creating functions, and utilizing built-in functions.

Students will be introduced to concepts and definitions related to spreadsheets to utilize Microsoft Excel or Google

Sheets. Students will be introduced to the relationship between a row and a column and the concept of a cell. The

headings of a spreadsheet will be introduced columns from A to ZZ and rows from 1 to infinity so that students will see

the intersection of a row and column which constitutes a cell.

Then, students will be introduced to cell formatting. A cell can be formatted as text, number, decimal,

percentage, date/time, online link, and a function. [See handouts and Screencastify demonstration.]

The students will also be given the Coaches’ Realty example. Students wil l enter the fictitious data into Microsoft Excel

or Google Sheets. Students will then be introduced to formatting a cell with the data. Then, students will begin creating

small functions. Then, students will create a function using an absolute cell. Then, students will use the built-in

functions of Microsoft Excel to total the property sales for each realtor. [A Screencastify MP4 video has been created to

accompany this lesson with Microsoft Excel and Google Sheets versions.]

EXPLAIN:

• How do you format a cell or group of cells?

• What do all functions need to work properly?

• How do you perform a size to fit for a column or row?

• What built-in function will total a column or row for you?

• What spreadsheet operator allows you to multiply two cells in a spreadsheet?