06-GS104bW3.html (Edited
3/24/07 10:10am)
Lab Assignment Due next class
Topic: New
Spreadsheet Functions
(1) Statistics, (2) Charts
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. Check
instructors office hours. |
Vocabulary
Review of terms from
GS104a assignments and some new terms. Many you 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 assistant 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.
New/Review
From Text: Excel
XP Level 1
math
operators (GEMS or PEMDAS)
formulas [begin with an "="]
functions [common
formulas built in to Excel so you don't have to figure out how to get
Excel to perform the calculations]
Function categories from Insert/Function
All
Financial
Date & Time
Math & Trig
Statistical
Lookup & Reference
Tsxt
Logical
Information
Database
|
Commonly used Functions
TODAY (a date & Time function)
Sum
Autosum
Autosum list- Sum, Average, Count, Max, Min
*Statistical functions (just ones we will use)
*Average
*Count
*Max
*Median
*Min
*Mode
Chart
Basics
|
(1) Functions
are frequently used formulas
included in Excel. There are more then 150 in the current
version. They range from the simple and obvious SUM to the
relatively esoteric. We will focus on the most commonly used
functions and a brief look at statistical functions in Excel.
Examine the following Excel
formulas functions. 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.
Functions
TEXT:
Microsoft
Excel Level 1
Find in: My
Documents/SSTP_Documentation/Excel03/EXCL03L1.doc
Lesson 4 - CREATING SIMPLE FORMULAS --------------------------------------69-89
exercise page 89
TEXT:
Microsoft
Excel Level 2
Find in: My
Documents/SSTP_Documentation/Excel03/EXCL03L2.doc
Lesson
5 - USING OTHER FUNCTIONS----------------------------------------------65-81
exercise page 81
Lesson
6 - MANAGING
DATA-------------------------------------------------------- 83-96 exercise page
96 (sorting
lists)
(2) Making charts,
visual displays of data, is a fun part of
Excel, a picture is worth a thousand words. We will briefly explore this.
Examine the following Excel Chart
functions. You are
not
expected to become an expert in charting for this class. You may be asked to chart data 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.
Charts
TEXT:
Microsoft
Excel Level 3
Find in: My
Documents/SSTP_Documentation/Excel03/EXCL03L3.doc
Lesson 9 - CREATING
CHARTS------------------------------------------------------129-151, exercise page 151
Lesson 10-
FORMATTING
CHARTS-------------------------------------------------153-164
exercise page 164
Lesson
11 - DRAWING AN OBJECT--------------------------------------------------167-184
(3)
Sorting data to organize lists or find patterns in data is a
common
operation in Excel.
Examine the following so that you
understand
the
process.
Sorting
TEXT:
Microsoft
Excel Level 2--Thoroughly review the following
Find in: My
Documents/SSTP_Documentation/Excel03/EXCL03L2.doc
Lesson 6 - Managing
Data-----------------------------------------------------------------83-96 exercise page
96 (sorting
lists)
(4) Function Assignment: Open the following Statistics
Exercise [math and
statistical functions] and
perform the
stated
tasks on a spreadsheet.
Name your statistics spreadsheet
statistics.xls
and save it in:
My
Documents/_GST104
Portfolio/4 Windows XP/statistics.xls
(5)
Chart Assignment: For an overview of charts, check out Chart
Basics. Using the deviance
data analysis above create a chart comparing the
difference between male and female deviance.
Copy and paste your
chart into a Word document called "MyChart"
making sure that you have a few
sentences under each chart describing what the chart shows. Of
course your name and section should be at the top.
Name your chart spreadsheet chart.xls
and save it in:
My
Documents/_GST104
Portfolio/4 Windows XP/chart.xls
(6) 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.
(7)
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.