Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:01,000 --> 00:00:03,333
so we've done some really great work so far
2
00:00:03,333 --> 00:00:05,299
we're comfortable with Excel now
3
00:00:05,300 --> 00:00:07,133
we understand how spreadsheets work
4
00:00:07,133 --> 00:00:09,099
we've worked with cell referencing
5
00:00:09,333 --> 00:00:13,033
we know kinds of data categories we put into Excel
6
00:00:13,066 --> 00:00:15,199
we know that for some of those data categories
7
00:00:15,200 --> 00:00:15,933
like numbers
8
00:00:15,933 --> 00:00:17,599
there are many different data types
9
00:00:17,600 --> 00:00:18,900
and we need to be very clear
10
00:00:18,900 --> 00:00:20,666
through self formatting
11
00:00:20,666 --> 00:00:22,566
which data types were using
12
00:00:22,666 --> 00:00:25,366
so we have a lot of our foundation built
13
00:00:25,366 --> 00:00:26,166
and now we're very
14
00:00:26,166 --> 00:00:29,233
very close to entering data and working on our project
15
00:00:29,266 --> 00:00:29,999
and as you know
16
00:00:30,000 --> 00:00:32,300
our first project that we're going to be working on
17
00:00:32,300 --> 00:00:36,266
is dealing with weather data for a location near us
18
00:00:36,333 --> 00:00:37,299
I'm near Charlotte
19
00:00:37,300 --> 00:00:38,000
North Carolina
20
00:00:38,000 --> 00:00:40,433
and so that's the data I'm going to be showing you
21
00:00:40,566 --> 00:00:41,999
and what I'm going to do here is
22
00:00:42,000 --> 00:00:43,600
I'm going to introduce you to the data
23
00:00:43,600 --> 00:00:44,900
that we're going to be using
24
00:00:44,900 --> 00:00:47,633
and then we can think about planning our spreadsheet
25
00:00:47,766 --> 00:00:49,566
and then we'll enter in our data
26
00:00:49,566 --> 00:00:50,333
after which
27
00:00:50,333 --> 00:00:53,466
we'll be ready to go with plotting and analysis
28
00:00:53,466 --> 00:00:54,766
and doing a lot of the things
29
00:00:54,766 --> 00:00:56,699
that you're here to learn about and excel
30
00:00:57,133 --> 00:00:58,133
now remember
31
00:00:58,133 --> 00:00:59,899
this is one of the first products
32
00:00:59,900 --> 00:01:00,900
we're going to be producing
33
00:01:00,900 --> 00:01:02,800
we're going to be producing a plot
34
00:01:02,866 --> 00:01:04,966
of high and low temperatures per month
35
00:01:04,966 --> 00:01:05,966
across a year
36
00:01:05,966 --> 00:01:07,533
for a location near us
37
00:01:07,533 --> 00:01:09,099
so let's keep this in mind
38
00:01:09,266 --> 00:01:10,399
the first thing we need to do is
39
00:01:10,400 --> 00:01:11,733
we need to find a good data set
40
00:01:11,733 --> 00:01:12,499
for this and so
41
00:01:12,500 --> 00:01:13,200
what I'm going to do is
42
00:01:13,200 --> 00:01:14,600
I'm going to introduce you to
43
00:01:14,600 --> 00:01:16,166
one of a few different web pages
44
00:01:16,166 --> 00:01:18,366
where you can go to look up climate data
45
00:01:18,366 --> 00:01:20,666
and weather data for a location near you
46
00:01:20,733 --> 00:01:22,466
and then that's what we're going to use
47
00:01:22,466 --> 00:01:23,366
to prepare ourselves
48
00:01:23,366 --> 00:01:25,899
to collect those data and put it into Excel
49
00:01:25,900 --> 00:01:28,300
or then we can manipulate and visualize it
50
00:01:28,933 --> 00:01:29,999
here I'm gonna share with you
51
00:01:30,000 --> 00:01:31,766
one potential source of weather
52
00:01:31,766 --> 00:01:32,733
climate information
53
00:01:32,733 --> 00:01:34,533
that I recommend for what we're doing
54
00:01:34,533 --> 00:01:36,299
for the next few steps in this class
55
00:01:36,533 --> 00:01:38,766
that's the World Weather Information Service
56
00:01:38,766 --> 00:01:41,199
you can see that I just used a search bar
57
00:01:41,200 --> 00:01:43,166
to look for that web page
58
00:01:43,166 --> 00:01:44,733
it pops up right here
59
00:01:44,733 --> 00:01:46,166
and here we have the URL
60
00:01:46,166 --> 00:01:46,866
if you'd like to
61
00:01:46,866 --> 00:01:49,066
just type that directly into your browser
62
00:01:49,066 --> 00:01:49,766
we're going for
63
00:01:49,766 --> 00:01:52,066
the World Weather Information Service
64
00:01:52,466 --> 00:01:53,966
this is a fantastic web page
65
00:01:53,966 --> 00:01:54,866
because what it does is
66
00:01:54,866 --> 00:01:57,599
it provides weather information and climate information
67
00:01:57,733 --> 00:01:59,399
for cities all around the world
68
00:01:59,400 --> 00:02:02,800
all we have to do is just enter in a location near us
69
00:02:02,800 --> 00:02:04,966
that we're particularly interested in
70
00:02:05,000 --> 00:02:05,533
and then we'll
71
00:02:05,533 --> 00:02:07,333
get some of the data that we're interested in
72
00:02:07,333 --> 00:02:08,433
so I'm going to
73
00:02:08,733 --> 00:02:11,266
type in a city near me Charlotte
74
00:02:11,266 --> 00:02:12,066
North Carolina
75
00:02:12,066 --> 00:02:13,266
in the United States
76
00:02:13,266 --> 00:02:15,166
and you can and should
77
00:02:15,166 --> 00:02:17,866
search for a location of interest to you
78
00:02:18,733 --> 00:02:19,599
the first thing we see
79
00:02:19,600 --> 00:02:21,666
is we see the current weather conditions
80
00:02:21,666 --> 00:02:23,933
and we see the forecast for the next few days
81
00:02:23,933 --> 00:02:25,399
but if we scroll down
82
00:02:25,400 --> 00:02:27,566
then here's the data we're really after
83
00:02:27,566 --> 00:02:28,733
in this table here
84
00:02:28,733 --> 00:02:30,633
you can see that we have the mean
85
00:02:30,666 --> 00:02:32,399
daily high temperatures
86
00:02:32,400 --> 00:02:33,900
and low temperatures
87
00:02:33,966 --> 00:02:35,966
for particular months of the year
88
00:02:35,966 --> 00:02:38,199
this is over a 30 year period
89
00:02:38,400 --> 00:02:39,500
and these are averages
90
00:02:39,500 --> 00:02:40,600
so on average
91
00:02:40,600 --> 00:02:42,266
the low temperature in January
92
00:02:42,266 --> 00:02:42,866
in Charlotte
93
00:02:42,866 --> 00:02:45,366
is going to be about 29.6
94
00:02:45,366 --> 00:02:47,399
or 30 degrees Fahrenheit
95
00:02:47,400 --> 00:02:49,666
and we have that for every month of the year
96
00:02:49,733 --> 00:02:52,166
you can see that we also have rainfall data
97
00:02:52,166 --> 00:02:54,366
and so maybe we can use this as well
98
00:02:54,366 --> 00:02:56,399
as we're moving forward in this class
99
00:02:57,766 --> 00:02:58,699
right up above
100
00:02:58,700 --> 00:03:00,066
you can see one kind of plot
101
00:03:00,066 --> 00:03:00,799
and you saw that
102
00:03:00,800 --> 00:03:03,200
we're going to be producing a plot very much like this
103
00:03:03,200 --> 00:03:04,500
using Excel
104
00:03:05,166 --> 00:03:08,033
so this is a fantastic source of information
105
00:03:08,466 --> 00:03:10,066
that hopefully will be of interest to you
106
00:03:10,066 --> 00:03:11,899
as we move forward in this class
107
00:03:11,900 --> 00:03:14,900
I'm also going to provide links to a few other sources
108
00:03:14,900 --> 00:03:17,466
of weather and climate data that you can use
109
00:03:17,466 --> 00:03:20,166
if this one doesn't quite do the trick for you
110
00:03:20,966 --> 00:03:22,533
now that we have our data source
111
00:03:22,533 --> 00:03:23,499
what we're going to do is
112
00:03:23,500 --> 00:03:25,100
we're going to look at what we need to do
113
00:03:25,100 --> 00:03:27,066
to enter those data into Excel
114
00:03:27,100 --> 00:03:29,100
that means setting up our spreadsheet
115
00:03:29,100 --> 00:03:30,333
so that's our next step
116
00:03:30,333 --> 00:03:31,999
will be setting up our spreadsheet
117
00:03:32,000 --> 00:03:33,400
and getting ready in advance
118
00:03:33,400 --> 00:03:35,366
so that we can then enter our data
119
00:03:35,366 --> 00:03:37,433
and start working with those data
120
00:03:37,500 --> 00:03:39,066
that's what's coming up next
8452
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.