Tip:
Highlight text to annotate it
X
Hi everybody, this is Kevin and here is a little of video tutorial
on how to do
the first of the graphing
labs in the vial thirty two the terminal at class
okay
so this first portion we're going to do is just like a really simple graph
this is kind of uh... an exercise for people to practice some skills if it's
been awhile since you've used
excel
but it's especially for people that are just not comfortable excel format having
used before we're confused last time they did or anybody who looks at this
levitt and seems like it'd looks really complicated that this is just written
just for you case or they can get some
practice on a few the fundamentals right
so uh... we're going to use open excel now if you're on a pc you're on a mac
there are a lot of different excel out there now and
and uh... he could look differently from one who
computer type to the next and even one person to the next
so though
just after you see in the lab and that is kinda written for a pc
and on doing this one right now today on a mac
and so between the
i don't the written instructions in the lab and this tutorial
hopefully ill have plain information a poll from to make your lab
go consuming okay
so so let's get into it here so
on page eleven of the of the assignment
it's is talking about making a scatter graph in excel okay
so the first thing it is putting your data now the data goes into the
worksheet now this one when you open up exo usually will just open up in june
a big blank worksheet he writes of this whole area here that i'm sort of moving
around
nothing in here so let's put some stuff that so in column a day
wrote one
let's just click in their highlight that sell and then will tighten hours
we'll go over to
column b
rowell type in dollars
now the state of the i'm just typing in these numbers
are just work what's right and you're and a someone through five
and for dollars wilders
christmas tree and i'll show you some
summer shortcuts on entering in repeated numbers and a lot but that's just
principal temperament
janelle ready to go to do is just graph out
how many dollars uh... you earn per hour or something like that
the easiest way to do this is to select information select the the data
and then tell excel that you want to make it sure content
and um... there are different ways to do this
one where you might want to try is just a highlight that and then
goto insert them appear at the top insert
and nazi go down a little bit and chart by chart is jst basically another name
for a graph castles click on char
users of different kinds of charts and again depending on what excel you're
using this might look a little bit differently okay
but we're going to see the simplest what what might be considered the simplest
kind of chart which is called a scatter plot insist dots on a graph okay no
lines nothing else
sos click on that and that's as old as all these different fancy types of
scatter plots
which is keep this trooper boring here okay
as you just used by just about stem cell souls click on that
up will pop
hopefully the graph under smoothing it by grabbing the edge
and i can even gravis edge when it goes from four aerostat uros at lets me know
it's expecting me to make it bigger
suddenly got bigger now has a look
so over here we have worked well
ten twenty thirty forty that must be our dollars over there
on our expects us the horrors on wednesday road one two three four five
six seven skid that must be our hours
arnelle's is pretty good except that we don't have any axes you do the read
labels on either the taxes so let's let's get in that
depending on the kind of excel you have your going to have a really different
deal this
order for a way in which you know that you're going to type in your axe you
can't just click on it
and go k
if we just click on that access
it's going to bring up allot of different things that we can do change
it uh... in terms of what numbers are being displayed
we can change that kind of numbers we can even change the text tick marks and
response of the numbers all sorts of stuff
but there's nothing is really easy and
least at the first glance for actually putting a label on the case let's get
out of this coke ansel
so you don't want to squeak out
so now in this type of excel this version of of a mac excell which is the
newest version
that something might have
switching to do is
go up here to the purple area chart layout
now this as a whole bunch of different things that you can do to this crap
that's actually pretty nice layout bunch get used to it
over here we need to have to tell excel what part of this craft wanna mollify
now pours on alexis that's the that's accessible one
through six
vertical axis
would be the zero
three sixty so schools for horizontal first all right
so click on oracle access and then we need we wanna modify
won a modified accessed titles right
so horizontal axis
let's put it i tl below the access list click and now i just pops in there and
now we can just click on it
and just type in
clever we want hours
work but that
now over here
we want to put in our access over here for our what are why call
so we go back up to access titles
but now we want to click on vertical axis title
and you can there's lots differ ways you can do that i would probably just say
rotated title erica
and now we can type in covert click on that
and so it was already there and you can put in
whatever you like such as sort of collapsed
every also
this looks pretty boring i met and there's a lot of fancy things you could
do it you can change
the background color all the tax code you can modify how big you need the
letters
or words are you can't put uh... all sorts of stuff and see pictures in the
background but at its core
a good graft usually is simple case o
just cuz it looks simple
doesn't mean it's not a good graphic a lot of people make mistakes
not just in
in uh... college campuses when they're doing presentations or or to things like
that but
even in scientific papers people sometimes get there had to be really
want to make the graph looks fancy that is not always a good option a kit
so keep it simple
so there we are we just finished the first one there and that
if you have been following along at my snail's pace we we did this pretty
quickly
but once you get the hang of this this is a graph you can make in probably
about thirty seconds right and that'll be a good twila out for some of our
other
labs down the road