GS104a Fourth Wednesday Assignment

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:

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:

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 Terms with an "*" and improve on definitions of terms you have in your dictionary. Save 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