Kibale Chimpanzee Project - Chimpanzee Diet Composition.xlsx

	A	B	C	D	E	F	H	I
1	Calculating Chimpanzee Diet Composition
2
3	GOALS
4	To use real data on chimpanzees from the Kanyawara community to calculate diet composition
5	To practice using spreadsheets
6
7	DATASHEETS
8	This workbook contains 1 worksheet with raw data called 'Chimpanzee Feeding Bouts' and one table called 'Diet Composition' where the data will be summarized (see instructions below).
9
10	Chimpanzee Feeding Bouts
11	In the Chimpanzee Feeding Bouts worksheet, you will find 60,793 feeding scans from 2009 to 2013.
12	This data comes from 15 minute scan data from group follows. If the chimpanzee party that is being followed is observed feeding on the 15 minute scan, then species and part of the food eaten are recorded.
13	Every food species that the chimpanzees eat are given a 3 letter code (you don't need to worry about the species codes!) and also food part.
14	From this sheet you will calculate the diet composition for the Kanyawara chimps.
15
16	Calculating Dietary Composition
17	Here you are going to count the number of 15 minutes that chimps were feeding on particular food items and then divide this number by the total number of scans that the chimps are feeding. This will give you the proportion of the diet for each food part.
18	For this calculation, you can use the countif function.
19
20	1. You need to count the number of times each new food part shows up in your table. You can use a count if function on worksheet called 'Diet Composition'
21
22	Countif function
23	Countif functions take the form: =countif(range, criterion)
24	Here the range will be the column with your new food parts and the criterion will be the food part you are counting.
25
26		Example of Countif
27		Date	Observer ID	Scan Time	Food ID	New Food Part	Count of fruit	Count of leaf
28		01-Jan-09	FM	7:45	FCP	fruit	5	4
29		01-Jan-09	FM	8:00	FCP	fruit
30		01-Jan-09	FM	8:15	FCP	fruit
31		01-Jan-09	FM	8:30	FCP	fruit
32		01-Jan-09	FM	9:15	AFR	pith
33		01-Jan-09	FM	9:30	AFR	pith
34		01-Jan-09	FM	10:15	THV	leaf
35		01-Jan-09	FM	10:30	RBA	fruit
36		01-Jan-09	FM	10:45	CAF	leaf
37		01-Jan-09	FM	11:00	THV	leaf
38		01-Jan-09	FM	11:15	THV	leaf
39
40	2. The total feeding count is equal to the number of 15 minutes feeding scans where the food part is known and recorded.
41	3. You can now calculate the proportion of the diet by new food part by dividing the number of 15 min scans of each part by the total number feeding scans
42	4. You will now make a pie chart of the diet composition of chimpanzee diets. Select the appropriate data, go to the insert tab and choose chart and pick a pie chart. Here you should add data labels so that the proportions (numbers) appear on the chart itself. Format your chart to give it a title.
43
44	Ways of making this assignment easier
45	Give the students the count data already calculated and have them calculate the proportions and make the pie graph.
46	Another option would be to give the students only one year or one month of data to make the spreadsheet more manageable.
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100