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!

 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

(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.
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.