 So in this video, I'm going to talk a little bit about working with the spreadsheet program for lab 6 and again This is specific for my physical sciences students and the comparing the planets lab Now you'll have a view which is a student view which will look a little bit like this but also have some differences in it and In that view you want to find the assignment and you want to locate the additional resources and And for part two there is the planetary data spreadsheet When you click on that button, it should go ahead and download an excel spreadsheet file for you And then you're going to want to open that file up I'm assuming most of you are going to be using Microsoft excel If you don't you'll be using LibreOfficeCalc and things will work similarly When you first open this up, it's going to show you the data But it's going to have a warning up here that files from the internet can contain viruses And we do need to edit it, but this is a file that came from me. So you trust it We'll go ahead and click on enable editing Now when that happens, you'll notice it pops up an error I'm not sure why it does this, but in this case, I know that it's okay And we didn't actually lose our data If for some reason your program and your file opens up with that warning right away again Just click okay, and it should open up just fine Now we've got the data for the mass and radius for each one of the planets And we need to calculate the volume and density Now these are in earth units, not in normal kilograms or meters And we're going to use the formula as it's written out in your lab manual Now notice in the lab manual, it says to enter a formula in cell D Seven D refers to which column seven refers to which row And up here in Microsoft excel, the name D seven will show that you're actually in that box versus E seven or D eight So once you make sure you're in the right cell, then you can start to actually type in your formula And the equal sign is a very important part of this And for this equation, you're using C Seven And then this little symbol that's like a little upwards arrow That's the number or the symbol that's right above the number six And three and that actually means it's to the third power or the radius cubed When you hit enter, it should calculate the value that's in there And if everything preserved in the formatting, it should have it set so that it's took three decimal places If for some reason you've got a lot of numbers There's a Place up here on excel under the number Where you can either increase or decrease the decimal points And if you did have a bunch of numbers, we want to go ahead and decrease that down So that if you look at the decimal plate, there's one two three numbers after that decimal place Once you've got the number which should be zero point zero five six in this first box and you've confirmed that that's correct We want to go ahead and copy that down Now you don't want to use that same C seven equation in each box. You want it to adjust to the each row number as you go There's a few ways to do this One of the easiest ways that most students know is if you come over here to the corner of the box And you just drag it down It will go ahead and copy those formulas as far down as you drag But there's another way I want to show you real quick because it's going to be useful if you have a very long list Which we're going to have in some of our future labs If you place your cursor right over here like we did before but rather than Pushing the mouse button down and dragging just double click with that left mouse button And it will automatically take the entire column and fill that in You're going to want to do this and also then use the formula that's supposed to go in e seven and fill that down And then you're going to take these values and you're going to transfer them into your lab manual Now you can save the spreadsheet and submit it with your file But I want you to have these numbers in your lab manual Because that lab manual is your lasting resource that you're going to be able to use on your final exam So make sure that you record that information and then Use that data to answer the questions in your lab manual If you have any difficulties with it, please contact me If you're not using the microsoft excel, but you're using the free replacement software the libre office calc It should work very similarly, but if you have any questions, just let me know