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!
--Print This Page by choosing Print
from
File menu--
| 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
|
(1) Spreadsheet
Basics Review
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
(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.]
Name your budget spreadsheet budget2.xls
and save it in:
My
Documents/_GST104
Portfolio/4 Windows XP/budget2.xls
(b) Update your GPA spreadsheet you
created last quarter, add your spring grades for your classes at CSUB in a spreadsheet and
calculate:
- Your overall GPA
- 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)
Name your GPA spreadsheet
GPA2.xls
and save it in:
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)
Name
your checkbook
balancing
spreadsheet checkbook2.xls
and save it in:
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.
(4) Review
new additions to Computers
and Society Links.
Erase
the previous documents
from your
homework folder (mine would be named
rossjHW). Make a
copy of all homework, in
red above, and place in this
folder on
your computer-be sure and erase old homework from this folder.
You will copy this folder to the class folder on transfer at the
beginning of the next
class.