The last topic in our Excel unit is Pivot Tables.
Answers for the Wildcat Bluff small mammal dataset are
2.a.
Ch 84
NA 737
OI 647
PI 8530
Pm 546
R. mon 780
Sh 257.
2. b.
B01 12535, 184
B02 12380
G01 441
G02 952
M01 5637
M02 4714
M03 1792
PD02 4300
R01 8746.
2.c.
Na 9
Pl 31
Pm 2
X 7
2.d.
12583
2. e.
6442
At the start of next week (Feb. 1 to 5) we begin a unit on the Internet by reviewing the basics of wepage creation with HTML.
During the second class of the week there will be an Excel test covering the following:
- VLookup (only 4 marks out of 20)
- data validation
- goal seek
- scenarios
- pivot tables
The last class of the week will return to HTML.
After HTML, we learn webpage creation with Dreamweaver.
