GS104aW4.html   (Edit 1/19/07 3:30pm)                      --Best Viewed in Netscape, Mosaic, Foxfire --
 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     *Entering information     Text     Formula bar     Numbers     Editing Cells                *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:
• Overview of Spreadsheets at Spreadsheet Basics (be sure and check out the sample budget spreadsheet at the end of this documentation) and  Excel Basics .
• Look over the following so that you know where you can find specific steps in creating a spreadsheet if needed: Text: Lesson 10-USING MICROSOFT EXCEL  Page 179-203.  This can be found at:
My Documents/SSTP_Documentation/IntroPC/INTROPC.doc   <------ then scan page 179-203
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: