WEBVTT
Kind: captions
Language: en
00:00:00.199 --> 00:00:04.000
In this video, you will start to build your
project spreadsheet.
00:00:04.000 --> 00:00:07.230
You will:
Use the SUM function to determine the possible
00:00:07.230 --> 00:00:13.049
outcomes of rolling two dice,
And copy that formula to the entire data set
00:00:13.049 --> 00:00:15.700
to save time and be more accurate.
00:00:15.700 --> 00:00:20.050
To determine the possible combinations of
the two dice your teacher will roll, you will
00:00:20.050 --> 00:00:21.360
create a chart.
00:00:21.360 --> 00:00:26.750
Each possible side of the dice is represented
by the rows and columns in the spreadsheet.
00:00:26.750 --> 00:00:31.200
You will record all the possible sums and
write a formula to calculate them.
00:00:31.200 --> 00:00:34.190
To start, review your probability sheet.
00:00:34.190 --> 00:00:41.020
The outcomes chart shows each number on die one, the orange die, and on die two, the purple die.
00:00:42.020 --> 00:00:47.130
If the dice roll results in two ones, then
the sum of the two dice -- or the outcome -- is two.
00:00:48.690 --> 00:00:54.430
In your spreadsheet, type a two in the cell
where the number one on each die intersect.
00:00:54.430 --> 00:00:56.680
In this example, it’s C4.
00:00:56.680 --> 00:01:02.600
If the orange die shows a one and the purple die shows a two, the outcome is three.
00:01:02.600 --> 00:01:04.769
Add that sum to your spreadsheet.
00:01:04.769 --> 00:01:09.350
You can continue to do simple addition to
calculate the outcome of each combination
00:01:09.350 --> 00:01:14.869
of dice, but adding the numbers for each possibility takes a long time.
00:01:14.869 --> 00:01:20.810
Instead, use a SUM function in your spreadsheet to complete this task automatically.
00:01:20.810 --> 00:01:25.369
A SUM function is a formula that adds the
values in cells.
00:01:25.369 --> 00:01:30.920
In cells C4 and C5, delete the sums you just calculated.
00:01:30.920 --> 00:01:32.780
Then, type the formula.
00:01:32.780 --> 00:01:36.729
Formulas in Google Sheets always start with an equals sign.
00:01:36.729 --> 00:01:38.520
Next, type the word SUM.
00:01:38.520 --> 00:01:41.840
A menu provides formatting help.
00:01:41.840 --> 00:01:46.149
Select sum.
00:01:46.149 --> 00:01:51.180
In this case, you’re adding the numbers
in C3 and B4.
00:01:51.180 --> 00:01:56.899
Select cell C3, type a plus sign, then select cell B4.
00:01:56.899 --> 00:02:03.240
If you get an error message, make sure you’ve typed the formula exactly as you see here.
00:02:03.240 --> 00:02:04.329
Nice job!
00:02:04.329 --> 00:02:09.119
To copy that formula to the rest of the column, click the handle in the lower right-hand corner
00:02:09.119 --> 00:02:14.069
of the cell, hold it, and drag it down the
column until you reach the bottom of your list.
00:02:15.879 --> 00:02:19.530
The sum will be calculated for each combination of dice.
00:02:19.530 --> 00:02:21.480
Now, check your work.
00:02:21.480 --> 00:02:22.480
Oops!
00:02:22.480 --> 00:02:24.250
Those numbers don’t look right.
00:02:24.250 --> 00:02:30.930
Click into each cell to see the formulas.
00:02:30.930 --> 00:02:35.230
Dragging the formula updated the row and the column being added in each cell.
00:02:35.230 --> 00:02:38.230
Typical cell references are relative.
00:02:38.230 --> 00:02:42.079
That means they change when a formula is copied to another cell.
00:02:42.079 --> 00:02:50.239
The formula in C5 calculated C4 plus B5, rather than C3 plus B5.
00:02:50.239 --> 00:02:55.130
You want the value of the orange die to stay the same while the value of the purple die changes.
00:02:56.379 --> 00:03:00.590
To fix this, use an absolute cell reference.
00:03:00.590 --> 00:03:05.560
Absolute cell references remain constant,
even when you copy them to another cell or sheet.
00:03:06.720 --> 00:03:11.549
Absolute references are important when you want to reference the same cell or range in multiple formulas.
00:03:13.180 --> 00:03:23.310
To create an absolute cell reference, add
dollar signs to the letter and number.
00:03:23.310 --> 00:03:33.090
Then, copy the formula to the rest of the
column to update the outcomes.
00:03:33.090 --> 00:03:34.090
Great job!
00:03:34.090 --> 00:03:37.700
Now, copy the formula to each of the remaining columns.
00:03:37.700 --> 00:03:43.920
Double click in the cell to see the formula,
then select the formula, copy it, and paste it into the next column.
00:03:46.609 --> 00:03:53.209
Add absolute cell references to use the correct cells.
00:03:53.209 --> 00:04:00.599
And drag to populate the rest of the columns.
00:04:00.599 --> 00:04:06.340
Remember to check your work.
00:04:06.340 --> 00:04:07.379
Nice job!
00:04:07.379 --> 00:04:10.760
You could use a SUM function in other spreadsheets to add:
00:04:10.760 --> 00:04:15.969
How much money you spent on snacks last year, or whether you raised enough money for the school band competition.
00:04:17.360 --> 00:04:22.600
Now, it’s your turn:
Use the SUM function to calculate the possible combinations of rolling two dice,
00:04:22.600 --> 00:04:28.310
And copy the formula into each column to complete the table.