WEBVTT
Kind: captions
Language: en
00:00:00.450 --> 00:00:05.279
There are many methods you can use to make
a decision about the future, such as making
00:00:05.279 --> 00:00:09.690
a pros and cons list or having a discussion
with a friend.
00:00:09.690 --> 00:00:14.290
You can also calculate the probability of
a certain outcome.
00:00:14.290 --> 00:00:17.860
Probability tells you the likelihood that
an event will happen.
00:00:17.860 --> 00:00:23.430
For example, you could use weather data that
forecasts a 65 percent chance of rain to decide
00:00:23.430 --> 00:00:25.500
whether to bring an umbrella to school.
00:00:25.500 --> 00:00:30.390
Or, you could calculate the probability that
your favorite band's new song will be a hit
00:00:30.390 --> 00:00:34.230
based on how their songs ranked in the past.
00:00:34.230 --> 00:00:38.660
Calculating the probability doesn't guarantee
a specific outcome, but it helps you determine
00:00:38.660 --> 00:00:41.440
if a particular outcome is likely.
00:00:41.440 --> 00:00:47.850
In this lesson, you will calculate the probability
of an event using formulas and a spreadsheet.
00:00:47.850 --> 00:00:51.960
You will imagine that you and your classmates
have the opportunity to earn an extra thirty
00:00:51.960 --> 00:00:53.880
minutes for your lunch period.
00:00:53.880 --> 00:00:59.880
Each student will choose a number, and then
your teacher will roll two, six-sided dice.
00:00:59.880 --> 00:01:03.220
Those who choose the sum that’s rolled will
get the privilege.
00:01:03.220 --> 00:01:08.079
You could choose a number at random, but some
numbers have a higher probability of being
00:01:08.079 --> 00:01:09.079
rolled.
00:01:09.079 --> 00:01:13.439
To give yourself a better chance of receiving
the longer lunch period, you can use probability
00:01:13.439 --> 00:01:16.770
to choose the most likely number.
00:01:16.770 --> 00:01:21.210
As you complete this project, you will:
Use spreadsheet formulas and functions,
00:01:21.210 --> 00:01:24.880
Change number formats,
Round large numbers,
00:01:24.880 --> 00:01:28.469
And copy formulas into multiple cells.
00:01:28.469 --> 00:01:34.110
This lesson uses Google Sheets, but you could
use these skills in any spreadsheet application.
00:01:34.110 --> 00:01:37.560
A spreadsheet is a useful way to organize
data.
00:01:37.560 --> 00:01:42.799
Plus, anything you create in Google Sheets
is automatically saved to your Google account,
00:01:42.799 --> 00:01:46.920
so you can access it anywhere from any device
connected to the internet.
00:01:46.920 --> 00:01:51.270
To complete this lesson, you must be signed
in to your Google account.
00:01:51.270 --> 00:01:54.770
Open a new tab in your browser, and sign in
now.
00:01:54.770 --> 00:02:13.390
If you don’t have a Google account, pause
the video and create one now.
00:02:13.390 --> 00:02:22.790
To begin, open the starter project linked
on this page.
00:02:22.790 --> 00:02:37.280
Make a copy, and give it a title.
00:02:37.280 --> 00:02:41.349
With this spreadsheet, you will:
Determine the possible combinations of dice
00:02:41.349 --> 00:02:44.689
rolls,
Calculate the probability that each combination
00:02:44.689 --> 00:02:48.459
is rolled,
Simulate rolling two dice,
00:02:48.459 --> 00:02:55.830
Calculate how often each number was rolled,
And compare the outcome to your prediction.
00:02:55.830 --> 00:03:02.780
Spreadsheets are made up of many rows and
columns.
00:03:02.780 --> 00:03:12.549
And each block in the spreadsheet is called
a cell.
00:03:12.549 --> 00:03:17.519
As you complete this project, you will select
various rows and columns, and you will type
00:03:17.519 --> 00:03:19.040
into the cells.
00:03:19.040 --> 00:03:24.540
Choose a number between 2 and 12, including
those numbers, to earn your chance at a longer
00:03:24.540 --> 00:03:25.620
lunch.
00:03:25.620 --> 00:03:28.500
Type it in the cell beside My Pick.
00:03:28.500 --> 00:03:32.439
You will use this number later in the lesson.
00:03:32.439 --> 00:03:37.810
Then, move on to the next video to start building
your project!
00:03:37.810 --> 00:03:43.200
Now, it’s your turn:
Open the starter project, and make a copy.
00:03:43.200 --> 00:03:44.340
Add a title.
00:03:44.340 --> 00:03:47.629
Choose a number between 2 and 12, and add
it to the sheet.
00:03:47.629 --> 00:03:51.669
Then, move on to the next video where you
will build your project spreadsheet.