06-GS104bM3.html    (Edited 3/22/07  2:30pm)
Lab Assignment  Due next class
Topic:
Spreadsheets/Excel (1) Review: basics, formatting ,Lab Assignment  Due next class

Review : The goal this quarter is to make you a "hacker" (problem solver) capable of figuring out how to ask and answer questions about computers and solve your computer problems.  Knowing exactly how to perform every function in programs is not the goal but vocabulary is important!   Without the appropriate term you cannot search for an answer!

 A GS104a Instructor will be available in the computer lab, lower level of library, to help if needed every Friday and often Saturday or Sunday.   The class assisstant is available at the OASIS center during his office hours.
Vocabulary
Review of terms from GS104a assignments and the text.  Most you probably know and have in your dictionary.  The terms with an "*" you will be expected to be able to define and give examples without accessing other sources.  Check with a GS104 instructor or the class assiastant if you need help with these terms.  In addition to the class and text documentation you can also check this Glossary or Google for help with definitions you may not find

 *Matrix *Columns *Rows *Cells *Range *Text/Labels *Cell navigation *Entering  Information *Math operations  *GEMS/PEMDAS *recalculate *formulas *Functions *Formatting/Format toolbar Formatting     *Numbers    *Text     *Style   *Print Preview

Make sure you understand and can find the instructions on how to perform the following functions in  Excel03. These were mostly covered last quarter. Check out those functions you are not clear about. You may be asked questions about some of these functions on the next quiz so be prepared to know where to find the information, it is not necessary to remember exactly how to perform a task but you definitely need to know where to find instructions and be able to perform the task from the instructions on the next quiz.

(a) Review  Excel Functions
Browse the following quickly.  Check out those functions listed in bold that you do not recognize. These were mostly covered last quarter. Make sure you understand the function and can find the instructions on how to perform them if needed. You may be asked questions about some of these functions and expected to perform them on the next quiz so be prepared.

(b) New Excel Functions
Examine
the lessons with an * below a little more closely since we did not cover these in GS104a.  Make sure you understand the boldfaced tems.
You may be asked questions about some of these functions and expected to perform them on the next quiz so be prepared.

Text: Introduction to PC's using Windows XP
Find in: My Documents/SSTP_Documentation/IntroPC/INTROPC.doc
Lesson 10 - USING MICROSOFT EXCEL 2002------------------------165-185
TEXT:  Microsoft Excel Level I (functions we have mostly covered in GS104a the most important materials have an *)
Find in: My Documents/SSTP_Documentation/Excel03/EXCL03L1.doc
Lesson 1 -  EXPLORING EXCEL----------------------------------------------------------1-20 exercise page 20
Lesson 2 -  USING BASIC WORKBOOK SKILLS----------------------------------20-29 exercise page 29
Lesson 3 -  WORKING WITH RANGES-----------------------------------------------57-66 exercises page 66
Lesson 4 -  CREATING SIMPLE FORMULAS --------------------------------------69-89 exercise page 89
Lesson 5 -  COPYING AND MOVING DATA ---------------------------------------65-87 exercise page 87
Lesson 6 -  PRINTING--------------------------------------------------------------------113-122 exercise page 122
Lesson 7 -  USING PAGE SETUP  ----------------------------------------------------123-141 exercise page 141
Lesson 8 -  FORMATTING NUMBERS---------------------------------------------143-151 exercise page 151
Lesson 9 -  FORMATTING TEXT----------------------------------------------------153-169  exercise page 169
Lesson 10 -  WORKING WITH COLUMNS AND ROWS----------------------171-186 exercise page 186
Lesson 11 -  FORMATTING CELLS----------  --------------------------------------189-212 exercise page 212
Lesson 12 -  USING AUTOMATIC FORMATTING AND STYLES  --------215-231 exercise page 231
*Lesson 13 -  GETTING HELP  -------------------------------------------------------233-247 exercise page 247

WebSpreadsheet Basics from web documentation. For a quick overview Spreadsheet Basics and Excel Basics
Especially review excel formatting:
FORMULAS AND FUNCTIONS

FORMATTING TEXT
CHANGING COLUMN WIDTH
INSERTING NEW COLUMNS OR ROWS

(2)  Assignment: Review your spreadsheet work from GS104a and complete the following [Note: all the material for GS104a is still on the web so you can review material from there if needed]:
(a) Update and enhance your budget spreadsheet, add some new items now part of your expenses, delete any items you no longer have, make it cover at least a 6 month period, make sure the last column is an estimate of what you will spend for the whole year. Format your spreadsheet so that the columns are an appropriate width, the numbers are shown as currency, major totals are clearly labeled and highlighted. [Understanding this spreadsheet is important for the quiz next class.]
My Documents/_GST104 Portfolio/4 Windows XP/budget2.xls

• Your Major GPA (if you have a major and took classes in your major during the Winter)
To see how a spreadsheet like this might look check this (it is an example and dosen't work, you have to figure out how to do that)
gpa.xls  (labels and data no formulas)

My Documents/_GST104 Portfolio/4 Windows XP/GPA2.xls

(c) Review your checkbook balancing spreadsheet and make sure it works correctly and format it so that it looks good--check  how this example looks--it dosen't work so you can't simply copy
chkBkExe.xls  (labels and data no formulas)

My Documents/_GST104 Portfolio/4 Windows XP/
checkbook2.xls

(d) NEW: Make a 3 year car loan for \$5000 at 9% from Kern Schools Credit Union and your payment is \$113 per month.  How much in interest do you pay? Check how this example for a computer loan at 7.9% looks.  It is a sample and formulas do not work.  [Use the spreadsheet you made last quarter for a computer loan as a starting point]

ComputerLoan.xls  (labels and data no formulas)
Name your 3 year car loan spreadsheet Carloan.xls and save it in:
My Documents/_GST104 Portfolio/4 Windows XP/Carloan.xls
 In your work above (a)  appropriately format data with, 2 decimals and \$ format where relevant, (b) text size 10, (c) Column width appropriate for width of widest data, (d) highlight the most important cells with a light green box and (e) create a yellow box at the top right with your name, class and instructors name typed in the box.

(3) Dictionary: Make sure you have the terms with an "*" defined and a good example where relevant.  You have defined most of  these terms previously in your dictionary.    Improve on previously defined terms if possible and define new terms in your own words (not just copy and pasted from another source).  Your definitions should be clear, complete and understandable to someone like your self who is not in this class. Your understanding the concept is the goal for creating definitions.  If you do not understand a concept ask fellow class members then your instructor if needed.