Your grandmother has given you $150.00
and tells you to go out and buy at least one of each item from the spreadsheet
below. You must also pay the 6% sales tax.
Your task is to create a spreadsheet that will help you get as close to the $150.00 without going over (not even by a penny!)
|
|
| A few hints: |
| Subtotal: multiply the quantity by the price. |
| Tax: 6% = .06 Multiply this by the subtotal |
| Total: add the subtotal to the tax |
Use the S
button (Auto Sum) in the diagram below to get the grand total.
Spreadsheet Activity #2 - Division of Living Cells
Using a
microscope, a particular cell is observed over a twenty-two hour period. It is
observed that a new cell spends
| 11.0 hours in rapid growth |  |
| 7.0 hours making new DNA | |
| 3.0 hours preparing to divide | |
| .20 hours in Prophase | |
| .40 hours in Metaphase | |
| .15 hours in Anaphase | |
| .25 hours in Telophase |
Prepare a
Doughnut graph of this data to illustrate the life cycle of the cell
Spreadsheet Activity #3 - Melting Ice
| Prepare a line graph to show the relationship between time and temperature for some melting ice. Use the following experimental results. |
|
|
Time (mins) |
0 |
5 |
10 |
15 |
20 |
25 |
30 |
35 |
40 |
45 |
50 |
55 |
60 |
65 |
70 |
|
Temperature
(Celsius) |
-25 |
-20 |
-10 |
-5 |
0 |
0 |
0 |
0 |
0 |
2 |
4 |
6 |
8 |
10 |
12 |
Spreadsheet
Activity #4: Graph of Average
Temperatures
 |
 |
 |
 |
For a
science project last year, you took the outdoor temperature at 4:00 in the
afternoon on the 5th, 15th and 25th day of each month. Prepare a column graph of
the average monthly temperature.
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
5th |
22 |
23 |
23 |
48 |
52 |
79 |
84 |
93 |
81 |
64 |
43 |
36 |
|
15th |
12 |
24 |
27 |
44 |
62 |
80 |
90 |
93 |
86 |
61 |
40 |
38 |
|
25th |
18 |
12 |
36 |
51 |
59 |
75 |
96 |
98 |
78 |
54 |
35 |
22 |
 |
 |
Use the data below to prepare a spreadsheet that will show
each student’s current average score, and the mean, median and mode for each
test. Create one graph that contains a line graph for each
of the students showing their test scores.
|
|
Test –
1 |
Test –
2 |
Test –
3 |
Test - 4 |
John |
90 |
84 |
82 |
86 |
Jane
|
98 |
90 |
88 |
92 |
Demetrius
|
84 |
80 |
88 |
88 |
Kayla
|
98 |
90 |
84 |
92 |
Shanique
|
100 |
92 |
90 |
92 |
The homework points in the following chart need to be computed into each student’s grade with information above, but tests count 80% of the grade and homework counts 20%. Prepare a spreadsheet that shows each student’s test average, homework average and overall average.
|
|
Homework
- 1
|
Homework – 2 |
Homework
– 3
|
Homework
- 4
|
John |
100 |
85 |
90 |
90 |
Jane
|
85 |
80 |
95 |
95 |
Demetrius
|
90 |
90 |
90 |
85 |
Kayla
|
100 |
100 |
90 |
95 |
Shanique
|
95 |
90 |
95 |
95 |
Your
task is to buy carpet to cover the four floors listed in the bottom chart.
Prepare a spreadsheet to show how much it will cost to cover each of the rooms
with the following carpets (have the spreadsheet do all your calculations and
include the 6% sales tax) along with the total cost:
| Super Dooper Deluxe Stain-Preventer | $12.99/sq. ft. |
| The Best-You-Can-Get | $ 9.99 sq. ft |
| Easy on your Feet - Easy on your Budget | $ 6.98/sq. ft. |
|
|
Length
(ft.) |
Width
(ft.) |
|
Living Room |
18 |
30 |
|
Bedroom #1 |
10 |
12 |
|
Bedroom #2 |
8 |
8 |
|
Hallway |
10 |
5 |
