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

af Afrikaans
ak Akan
sq Albanian
am Amharic
ar Arabic
hy Armenian
az Azerbaijani
eu Basque
be Belarusian
bem Bemba
bn Bengali
bh Bihari
bs Bosnian
br Breton
bg Bulgarian
km Cambodian
ca Catalan
ceb Cebuano
chr Cherokee
ny Chichewa
zh-CN Chinese (Simplified)
zh-TW Chinese (Traditional)
co Corsican
hr Croatian
cs Czech
da Danish
nl Dutch
en English
eo Esperanto
et Estonian
ee Ewe
fo Faroese
tl Filipino
fi Finnish
fy Frisian
gaa Ga
gl Galician
ka Georgian
de German
el Greek
gn Guarani
gu Gujarati
ht Haitian Creole
ha Hausa
haw Hawaiian
iw Hebrew
hi Hindi
hmn Hmong
hu Hungarian
is Icelandic
ig Igbo
id Indonesian
ia Interlingua
ga Irish
it Italian
ja Japanese
jw Javanese
kn Kannada
kk Kazakh
rw Kinyarwanda
rn Kirundi
kg Kongo
ko Korean
kri Krio (Sierra Leone)
ku Kurdish
ckb Kurdish (Soranรฎ)
ky Kyrgyz
lo Laothian
la Latin
lv Latvian
ln Lingala
lt Lithuanian
loz Lozi
lg Luganda
ach Luo
lb Luxembourgish
mk Macedonian
mg Malagasy
ms Malay
ml Malayalam
mt Maltese
mi Maori
mr Marathi
mfe Mauritian Creole
mo Moldavian
mn Mongolian
my Myanmar (Burmese)
sr-ME Montenegrin
ne Nepali
pcm Nigerian Pidgin
nso Northern Sotho
no Norwegian
nn Norwegian (Nynorsk)
oc Occitan
or Oriya
om Oromo
ps Pashto
fa Persian
pl Polish
pt-BR Portuguese (Brazil)
pt Portuguese (Portugal)
pa Punjabi
qu Quechua
ro Romanian
rm Romansh
nyn Runyakitara
ru Russian
sm Samoan
gd Scots Gaelic
sr Serbian
sh Serbo-Croatian
st Sesotho
tn Setswana
crs Seychellois Creole
sn Shona
sd Sindhi
si Sinhalese
sk Slovak
sl Slovenian
so Somali
es Spanish
es-419 Spanish (Latin American)
su Sundanese
sw Swahili
sv Swedish
tg Tajik
ta Tamil
tt Tatar
te Telugu
th Thai
ti Tigrinya
to Tonga
lua Tshiluba
tum Tumbuka
tr Turkish
tk Turkmen
tw Twi
ug Uighur
uk Ukrainian
ur Urdu
uz Uzbek
vi Vietnamese
cy Welsh
wo Wolof
xh Xhosa
yi Yiddish
yo Yoruba
zu Zulu

Original subtitles

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

Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.