Video Gallery

Using Google Drive to Make Scatterplot Graph

Go to Video Gallery Added Aug 27, 2015 •

Copy this URL:
Embed code:	<iframe class="edlio-embed-player" type="text/html" width="640" height="360" src="//whs-hs.weatherfordisd.com/apps/embed/?v=86254" frameborder="0" allowfullscreen></iframe> Change dimensions

Go HD

Show Transcript

hello AP Physics this is mrs. Comstock and I'm going to give you a quick tutorial on how you can use your Google drive to create a scatter plot for your laps make sure that you are signed in under your Google account and then the easiest way is to go to your drive select new  and then go down and hit a Google sheet  comes up and it looks like a Excel spreadsheet so we're going to kind of do the thing that we did in class put in your data on the left-hand column you put your independent variable  with its units next to that you put your dependent variable and then put your data in you can clean it up by putting board turn around it and you can even Center the data in your data table look a little bit nicer now you're going to highlight the cells that you should include in your graph go up and select insert and go down and pick chart when you do that it'll come up and you'll see the scatter plot probably already made you can then customize your scatterplot first thing you want to do is correct the title you want to make what is dependent variable vs. independent variable so V distance versus time  we don't want to Legend on our graphs go to the legend tool select none in our Legend will go away scroll down a little bit farther and notice water access the horizontal is identified and since you highlighted this in your table your independent access or your x-axis is relabel scroll down a little bit farther in this will allow you to put major in minor gridlines for our purposes you'll want scroll down a little bit further so that you can see better you'll want 10 for your major and 5 for your minor you go up select vertical  access scroll down and again put 10 for your major and 5 for your minor gridlines finally if you go down a little bit farther this will allow you inner a trend line if it looks like it's a straight or linear select linear if it's curved you may want to try calling them it's see if that works this finishes your scatter plot and you can in select insert and it'll insert into your sheets document now if you want to go ahead and print it you can go to the print screen and print both your data table and your graph or if you want to download it so that you can put into a Word document simply hit download into Mac soft Excel it'll download to the bottom of your sheet select download up in an Excel you can save it and then copy and paste it into a Word document hope this is helped have a great day

Uploaded by Nicole Comstock.

Video Gallery

Using Google Drive to Make Scatterplot Graph

Popular Videos