Introduction to spreadsheets.

GOALS and Outcome

- Identify advantages and uses of spreadsheet software and charts/graphs.

- Identify and explain spreadsheet terminology.

- Create and save basic spreadsheets and apply formulas.

- Retrieve, edit, manipulate, and print various spreadsheets. 

- Create various charts/graphs from spreadsheets. 

What are Uses of Spreadsheets?

- Prepare budgets
      What is a budget?
      Why is it beneficial to have a budget?
- Maintain student grades
- Prepare financial statements
- Analyze numbers
      What is the definition of analyze? 
- Manage inventory
      What is inventory? 

- Make forecasts

Advantages of Spreadsheets

- Forecasting and making decisions
        Car Payment-Yes
        Rent-Yes
        House Payment-Yes
        Movies and eating out-NO

- Fast and efficient
- Spreadsheets Automatically recalculate with formula’s


Identify and explain spreadsheet terminology
 A spreadsheet tool used to play out different situations to determine the outcome
Student Discussion/Examples
What If……..Planning a Party
What If…….Shopping


Attributes of the Parts of the SS Window 
Active Cell
Cell is outlined in bold
Cell Address is in the upper left hand corner
 

Columns
Vertical portion of the spreadsheet
Identified by letters
 

Rows
Horizontal portion of the spreadsheet
Identified by numbers
 

Cell
Created by the intersection of a row and column


Entering Data into a Spreadsheet
 Labels
Alphabetical text

Values
A number

Formulas
Statement that performs a calculation

Functions
Built-in formula that is a shortcut for common calculations


Mathematical Operators
    +    addition
    -    subtraction
    *    multiplication    (asterisk)
    /    division    (slash or diagonal)    


Spreadsheet Functions 
Function Name             Description  
AVERAGE                     Average of arguments.
COUNT                          Counts the number of cells in a range.
IF                                    Specifies a logical test to perform; then                 

                                        performs one action if test result in true                

                                        and another if it is not true.
MAX                               Maximum value of range of cells.
MIN                                Minimum value of range of cells.
ROUND                          Rounds a number to a specified number of digits.
SUM                               Totals a range of cells.


Relative and Absolute Referencing 
Relative
cells that change when they are copied into other cells
 

Absolute
cells that do not change regardless of where it is copied
 
Graphing 
Bar graph
used to compare the values of various items

Line graph
useful for plotting trends

Area graph
like a “filled in” line graph.  Used to track changes over time

Pie graph
used to represent the percentage each item contributes to the total