Introduction

Over the last lessons in this unit you have learned how to create formulas in different types of formats. At the end of the lesson you will be able to create formulas by using the AutoSum button ∑ and copy those formulas to other cells by using the fill handle. You will also insert new columns and rows and see how the formulas will automatically adjust the cell reference name.

Lesson Objectives

Following successful completion of this lesson, students will be able to...

  • Utilize spreadsheet features, including formulas and functions, in creating, editing, and printing workbooks
  • Demonstrate programming logic used to create a product
    • Examples: products—digital game, interactive learning tool
  • Utilize interactive models and digital sources to address real-world problems.
    • Example: using graphic organizing tools

Enduring Understandings

  • Spreadsheets and their unique abilities can be very useful in organizing and calculating various types of data.

The above objectives correspond with the Alabama Course of Study: Business Technology Applications standards: 6, 19, and 21

This lesson incorporates the following Literacy Standards: R1, R2, R3, R4, R5, R6, R10, W1, W2, W3, W4, W5, and W6