M3_Excel_lecture.pptx

M3_Excel_lecture.pptx - SPREADSHEETS...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SPREADSHEETS Using
Microsoft
Excel
 EXCEL         Create and format spreadsheets for export Create formulas and execute other advanced features Create charts and graphs for export into Word and PowerPoint Analyze data within spreadsheets and effectively select the proper graph type 2 THE PURPOSE OF EXCEL   Process
information

   Automatically
perform
calculations
   Update
calculations
   Track
data
   Create
graphs
and
charts
   Create
simulations
 3 1 EXCEL BASICS   Let ’s
open
the
Excel
in‐
class
activity
to
begin
             The
main
screen
 Rows
and
Columns

 Cells
and
Ranges

 Data
Types
and
Formulas
 Formatting
 Charts
and
Graphs
 Cell E2 Worksheet Tab Menu Bar Row 3 Workbook (file name) Tool Bar Column D 4 CREATING SPREADSHEETS   Planning
             Data
to
be
used
 Formulas
to
be
used
 Charts
and
graphs
to
be
created
 Column
and
row
labels
 Documentation
of
entries
 Legend
and
chart/graph
labels
   Format
 5 RAW DATA – CREATE A SPREADSHEET GIVEN: You have three types of candy: 1.  Jelly Beans, 2.  Gum Balls, 3.  M & M’s You have four different colors: 1.  Red 2.  Green 3.  Yellow 4.  Blue 6 2 RAW DATA – CREATE A SPREADSHEET GIVEN: You have three types of candy: 1.  Jelly Beans, 2.  Gum Balls, 3.  M & M’s You have four different colors: 1.  Red 2.  Green 3.  Yellow 4.  Blue 7 CELLS AND RANGES   Data
is
entered
in
cells
   Cells
have
reference
names
     UNIQUE
names
 RANGES
are
grouped
multiple
cells
 CELL REFERENCE PRACTICE Give
the
reference
names
 for
these
groups:
 1.  2.  3.  4.  1 2 
CELL,
A1
 
B3:C3
 
C5:C7
 
A8:B10
 4 3 3 LET’S OPEN THE IN-CLASS ACTIVITY FILE….   Entire
sheet
   Font
   Border
   Color
   Drawing
Tools
   Width
and
Height
   Columns
   Rows
   Cells
   Format
Painter
   Merge
cells
icon
 10 CELL AND WORKSHEET FORMAT OPTIONS   Columns
   Rows
   Cells
   Entire
sheet
   Font
   Border
   Color
   Width
and
Height
   Format
Painter
   Merge
cells
icon
 11 COLUMNS AND ROWS   Click
and
drag;
height,
width,
content
   Entire
column
or
row
   Format
from
Menu
Bar
 12 4 CELL FORMATTING  Numbers
  Alignment
  Font
  Border
  Pattern
  Protection
 FORMATTING NUMBERS
 NUMBERS
   General
   Currency
   Accounting
   Date
   Time
   Percentage
   Scientific
   Text
   Special
   Custom
 FORMATTING ALIGNMENT
   Horizontal
   Vertical
   Orientation
   Control

 FONT
   Font
   Font
Style
   Size
   Underline
   Color
   Effects
 5 FORMATTING Borders
 
 Border   Presets
   Line
   Border

   Color
 Patterns
   Shading
   Pattern
 INCLASS ACTIVITY: RAW DATA – CREATING A SPREADSHEET GIVEN: You have three types of candy: 1.  Jelly Beans, 2.  Gum Balls, 3.  M & M’s You have four different colors: 1.  Red 2.  Green 3.  Yellow 4.  Blue 17 SELECTING AND ORGANIZING DATA Build a spreadsheet Insert the following data into your worksheets horizontal and vertical axis. You have:         15 Red Jelly beans, 3 red gumballs and 9 red M&M’s 1 green gumball, 8 yellow gumballs, and 6 blue gumballs In addition to the 9 red M&M’s, you also have 3 green, 7 yellow, and 4 blue M&M’s. You have 12 green jelly beans, 9 yellow jelly beans and 2 blue jelly beans 6 DATA Once you have entered your data into Excel, you can import the spreadsheet to your Word or PowerPoint Documents. NOTE: This function is part of your final project integration. Red Green Yellow Blue Jelly Beans 15 12 9 2 Gum Balls 3 1 8 6 M&Ms 9 3 7 4 CHARTS AND GRAPHS   Charts
display
data
in
a
graphical
format,
which
can
help
you
 and
your
audience
visualize
relationships
between
series
of
 data.
   When
we
decide
on
a
chart
to
use,
we
need
to
determine
 which
cells
contain
the
data
to
create
the
chart.
 SELECTING DATA What percentage of jelly beans are red? Red Green Yellow Blue Jelly Beans 15 12 9 2 Gum Balls 3 1 8 6 M&Ms 9 3 7 4 21 7 CHART MY JELLY BEANS 24% 5% 39% 32% Red Green Yellow Blue CHART– FOR YOUR IN CLASS ACTIVITY Use
these
questions
below
to
create
three
more
charts
on
 the
in
class
chart
activity
sheet.
       What
percentage
of
all
candy
is;
 
red
/
green
/
blue
/
yellow
?
 What
is
the
ratio
of
each
of
the
three
candy
types;
jelly
 beans,
gum
balls,
M&Ms?
 What
percentage
of
all
candy
is
red?
 23 CHART EXAMPLE   What
is
the
percentage
of
each
jelly
bean
color?

   What
chart
should
be
used
to
show
this
relationship?
   
What
percentage
does
each
color
of

jelly
bean
 contribute
to
the
total?
 24 8 CHART–CREATE THESE OTHER CHARTS FOR YOUR IN CLASS ACTIVITY       What
percentage
of
all
candy
is;
red
/
green
/
blue
/
 yellow
?
 What
is
the
ratio
of
each
of
the
three
candy
types;
jelly
 beans,
gum
balls,
M&Ms?
 What
percentage
of

all
candy
is
red?
 25 CHARTS FOR ANALYSIS Pie Charts (%) for Annual Income and Expense Categories Column Chart showing Total Income, Expense, Difference for each month 26 HAVE YOU SEEN THIS? Here are some answers to common questions that come up in Excel. 1.  I see #### instead of content in some cells CAUSE: The cell contains a number, date, or time that is wider than the cell, or the cell contains a date or time formula that produces a negative result 2.  I see #REF! instead of content in some cells CAUSE: The formula contains one or more references to cells that have been moved, deleted, or overwritten. 3.  I see #VALUE! instead of content in some cells CAUSE: The formula is missing a required argument. 9 FUNDING PROJECT   Working
Excel
Assignment
Document
   Save
the
file
using
the
EDT
321
Convention
 FIRSTNAME_LASTNAME_EXCELASSIGNMENT
   Complete
the
assignment
and
submit
it
through
 the
Digital
Drop
Box
   Upload
it
your
www
folder
on
your
AFS
Space
 and
hyperlink
it
to
your
website
 WHAT-IF SCENARIOS “If I get a grant for $10,000 will I be able to make a trip to Alaska to help avoid Polar Bear extinction?” “If my funding is less, can I afford to go by myself or do I need to find another source of funds?” 29 10 ...
View Full Document

This note was uploaded on 03/06/2011 for the course EDT 321 taught by Professor Johnson during the Fall '08 term at ASU.

Ask a homework question - tutors are online