Skip Navigation

Comp Tech - Spreadsheet Operators and Formulas

Main Core Tie

Computer Technology I
Strand 4

Time Frame

1 class periods of 60 minutes each

Authors

Business Ed Lesson Plan Team

Summary

A spreadsheet is a tool that can help solve the numeric "story problems" of your life. This assignment introduces how to set up Excel formulas based on fifteen simple scenarios (with five additional difficult scenarios for extra credit).


Materials


Instructional Procedures

Teach formula symbols including = to begin a formula, and operators for add, subtract, multiply, and divide. Teach the order of operations (Multiply and Divide, then Add and Subtract) and using Parentheses to interrupt the order.


Created: 01/17/2011
Updated: 02/04/2018