All language subtitles for 7Topic 3-2 Entering Data Week 1 Getting to Know Excel & Enterin-1

so here we are

we're at our source of data

that we're going to be using for this project

we're at the World Weather Information Service web page

I'm looking at Charlotte

North Carolina's data

you may be looking at data

for another city around the world

and what we're going to be doing

before we start entering data

is we're going to think about

how we want our spreadsheet set up

this will be the first time we're designing

our own spreadsheet

and we wanna make sure we do it right

part of the reason we're using this data set

is because it's a fantastic model

for a good way to set up data

what you'll notice here

is that every column in this table represents

in a variable of its own

we have the variable of month

we have the variable of low temperatures

mean daily minimum temperatures

we have the variable of high temperatures

mean daily high temperatures and so on

every column is its own variable

this is an excellent principle to follow

when setting up a spreadsheet

which is what we'll be doing in Excel in a moment

so every column is available

every row then

is an observation

we have an observation associated with January

we have another observation associated with February

and so on and so

keeping this idea in our head

columns are variables

rows are observations

can be very

very helpful

when we're setting up a spreadsheet of our own

so what we'll do now

is with this in mind

we're going to go over into an Excel

and set up our spreadsheet

so that we're going to be ready and organized

for our data entry

which will be our next step

before we start working with these data

so here we are

we're in Excel

we're ready to start entering our data

but first we need to set up our spreadsheet

one thing that you'll notice here

is that I've already

saved this file

I've given it a name

weather data

and I encourage you to do that as well

this is always a really good first step

to get in the habit of

is to give your file a name and save it

and that way

you're not going to lose anything

and you're going to keep very organized

with whatever you're doing in Excel

something else I'm going to do is

I'm gonna rename this sheet

I'm gonna rename it CLT

that's the abbreviation for Charlotte

and now if I

decide to put in weather data for other cities

I can have different sheets for those as well

so that's not really necessary

if I'm only working with one set of data

but now at least

I know that the data I'm working with

come from Charlotte and North Carolina

what's next

the final thing we need to do

in setting up our spreadsheet

before we can enter data

is just giving us our column headers

right and so

we're going to name each column

because each column represents a variable

you may recall that these were months

these were daily

low temperature

the average

and daily high temperature

the average

we also have a column for precipitation

which will enter in as well

as we've seen before

sometimes our labels are too long for the column width

and so we can just double click between those columns

to automatically space the column to the right size

and finally

as a reminder

one thing I like to do is

I like to bold that first row

those column headers

so that those stand out

and we know that that's information

separate from the rest of the data table

and now we're already

all set to start entering our data

which is what we're going to do right now