Comp Tech - Spreadsheet Operators and Formulas

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.