GS104aW4.html   (Edit 1/19/07 3:30pm)                      --Best Viewed in Netscape, Mosaic, Foxfire --
Topic: Spreadsheet Basics
 --Print This Page--
An instructor will be available in the computer lab, lower level of library, to help if needed. Check instructors' schedules on their web page for times.
Note: These terms pretty much follow the text. You can also check this Glossary for help with definition.  You will be expected to be able to define the terms with an asterisk in your own words in a quiz at the next class.

From Text
*Spreadsheet
   *Columns
   *Rows
   *Cells
     Numbers
     Text
     Formulas
     Functions
     *Recalculate
     Active cell
     Cell address
     Cell pointer
*Cell navigation
     Arrow keys
        Down
        Right
        Left
        Up
    Mouse click
    Scroll bar
    <Ctrl><Home>
*Entering information
    Text
    Formula bar
    Numbers
    Editing Cells
   <Home>
   <End>
   <Right>
   <Left>
   <Backspace>
*Formulas
Math 
Functions
     SUM (AutoSum Button)
     AVERAGE (Class discussion)
*Formatting/Format toolbar (just like Word)
    Numbers
    Style
        Currency
        Percent
        Comma style
        Decimal
        Font style (I, B, U)
        #
    Text
        Font
        style (I, B, U)
        Size
Print Preview
From Spreadsheet Basics
*Matrix
Columns
Rows
*Range
Text/Labels
*Math operations (must know GEMS/PEMDAS)
     +
     -
     *
     /
     ( )
     %
     ^
     =
Formulas
Functions
     SUM
    AVERAGE
     STDEV
1. (Class demo) Learn the basics of spreadsheets from the following:    
2.  Create a 6 month budget for your household, be sure and include totals for each month and category (Visa, Rent, Auto payment, School Fees, books...) and an average for all 6 months.  Save your budget with the name 6monthbudget.exe in your portfolio:
My Documents/SSTP_Documentation/9 Spreadsheets/6monthbudget.exe.
Hint:Try to create your budget spreadsheet   When you finish your spreadsheet or if you get stuck  then look at this working example, budgetExe.xls.

3.  Define the T
erms with an "*" and improve on definitions of terms you have in your dictionarySave your definitions in  your portfolio and place a copy in your homework folder. Wording should be yours  (not just copy and pasted from another source) clear, complete and understandable to someone like your self but not in this class. 


Erase all files in your homework folder.  Place a copy of all homework, in red above,  in your homework folder and bring to next class to place in class homework folder on the transfer drive