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.