Education Assignment for shy

Jordanjameire
AYK4_Data_Version_1.xlsx
Home>Education homework help>Education Assignment for shy

AYK 4

Apply Your Knowledge
Project 4 - Tracking Donations
Input boxes in tan
Output boxes in yellow
Given data in blue
Answers in red

Tracking Donations

Submitted Employee ID Last Name First Name Organization Amount Donation Sent
12/6/11 211 Smith James Diabetic Association $50 12/19/11
12/16/11 234 Daniels Julie Make a Wish Foundation $225 12/29/11
12/5/11 243 Bagley Bob Cancer Society $25 12/6/11
12/10/11 334 Kellee Pete Police Federation $180 12/14/11
12/6/11 345 Cross Roberta Leukemia Society $60 12/19/11
12/27/11 365 Lee Sufeing Homeless Shelters $25 12/30/11
12/13/11 366 Smith James Habitat for Humanity $150 12/23/11
12/27/11 370 Wills Mary Habitat for Humanity $100 12/29/11
12/4/11 389 Fisher Scott Cancer Society $125 12/10/11
11/29/11 432 Ash Jamie Habitat for Humanity $50 12/1/11
12/2/11 454 Cross Roberta Make a Wish Foundation $75 12/4/11
12/3/11 456 Butler Amy Cancer Society $250 12/10/11
12/3/11 499 Cross Roberta Animal Shelter $20 12/5/11
12/2/11 543 Fisher Scott Meals on Wheels $125 12/26/11
12/12/11 546 Daniels Julie Amnesty International $200 12/21/11
12/20/11 558 Los Jim Meals on Wheels $115 12/22/11
12/5/11 654 Ash Carlin Diabetic Association $100 12/6/11
12/12/11 657 Rogers Scott Animal Shelter $35 12/15/11
12/9/11 675 Ash Scott Diabetic Association $100 12/18/11
12/6/11 832 Haitz Todd Cancer Society $50 12/14/11
12/16/11 867 Daniels Julie Make a Wish Foundation $130 12/21/11
12/3/11 945 Williams James Vietnam Veterans $60 12/13/11
12/14/11 977 Rogers Scott Homeless Shelters $80 12/19/11
12/17/11 987 Haim Gary Diabetic Association $50 12/22/11
2/6/11 21 Smith James Diabetic Association $50 2/19/11
2/16/11 234 Daniels Julie Make a Wish Foundation $225 2/29/2011
2/5/11 243 Bagley Bob Cancer Society $25 2/6/11
2/10/11 334 Kellee Pete Police Federation $180 2/14/11
2/6/11 345 Cross Roberta Leukemia Society $60 2/19/11
2/27/11 365 Lee Sufeing Homeless Shelters $25 2/30/2011
2/13/11 366 Smith James Habitat for Humanity $150 2/23/11
2/27/11 370 Wills Mary Habitat for Humanity $100 2/29/2011
2/4/11 389 Fisher Scott Cancer Society $25 2/10/11
1/29/11 432 Ash Jamie Habitat for Humanity $50 2/1/11
2/2/11 454 Cross Roberta Make a Wish Foundation $75 2/4/11
2/3/11 456 Butler Amy Cancer Society $250 2/10/11
2/3/11 499 Cross Roberta Animal Shelter $20 2/5/11
2/2/11 543 Fisher Scott Meals on Wheels $25 2/26/11
2/2/11 546 Daniels Julie Amnesty International $200 2/21/11
2/20/11 558 Los Jim Meals on Wheels $15 2/22/11
2/5/11 654 Ash Carlin Diabetic Association $100 2/6/11
2/2/11 657 Rogers Scott Animal Shelter $35 2/15/11
2/9/11 675 Ash Scott Diabetic Association $100 2/18/11
2/6/11 832 Haitz Todd Cancer Society $50 2/14/11
2/16/11 867 Daniels Julie Make a Wish Foundation $130 2/21/11
2/3/11 945 Williams James Vietnam Veterans $60 2/13/11
2/14/11 977 Rogers Scott Homeless Shelters $80 2/19/11
2/17/11 987 Haim Gary Diabetic Association $50 2/22/11
6/6/11 25 Smith James Diabetic Association $50 6/19/11
6/16/11 234 Daniels Julie Make a Wish Foundation $225 6/29/11
6/5/11 243 Bagley Bob Cancer Society $25 6/6/11
6/10/11 334 Kellee Pete Police Federation $180 6/14/11
6/6/11 345 Cross Roberta Leukemia Society $60 6/19/11
6/27/11 365 Lee Sufeing Homeless Shelters $25 6/30/11
6/13/11 366 Smith James Habitat for Humanity $150 6/23/11
6/27/11 370 Wills Mary Habitat for Humanity $100 6/29/11
6/4/11 389 Fisher Scott Cancer Society $65 6/10/11
5/29/11 432 Ash Jamie Habitat for Humanity $50 6/1/11
6/2/11 454 Cross Roberta Make a Wish Foundation $75 6/4/11
6/3/11 456 Butler Amy Cancer Society $250 6/10/11
6/3/11 499 Cross Roberta Animal Shelter $20 6/5/11
6/2/11 543 Fisher Scott Meals on Wheels $65 6/26/11
6/6/11 546 Daniels Julie Amnesty International $200 6/21/11
6/20/11 558 Los Jim Meals on Wheels $55 6/22/11
6/5/11 654 Ash Carlin Diabetic Association $100 6/6/11
6/6/11 657 Rogers Scott Animal Shelter $35 6/15/11
6/9/11 675 Ash Scott Diabetic Association $100 6/18/11
6/6/11 832 Haitz Todd Cancer Society $50 6/14/11
6/16/11 867 Daniels Julie Make a Wish Foundation $130 6/21/11
6/3/11 945 Williams James Vietnam Veterans $60 6/13/11
6/14/11 977 Rogers Scott Homeless Shelters $80 6/19/11
6/17/11 987 Haim Gary Diabetic Association $50 6/22/11
9/9/11 28 Smith James Diabetic Association $80 9/19/11
9/19/11 234 Daniels Julie Make a Wish Foundation $228 9/29/11
9/8/11 243 Bagley Bob Cancer Society $28 9/9/11
9/10/11 334 Kellee Pete Police Federation $180 9/14/11
9/9/11 348 Cross Roberta Leukemia Society $90 9/19/11
9/27/11 398 Lee Sufeing Homeless Shelters $28 9/30/11
9/13/11 399 Smith James Habitat for Humanity $180 9/23/11
9/27/11 370 Wills Mary Habitat for Humanity $100 9/29/11
9/4/11 389 Fisher Scott Cancer Society $98 9/10/11
8/29/11 432 Ash Jamie Habitat for Humanity $80 9/1/11
9/2/11 484 Cross Roberta Make a Wish Foundation $78 9/4/11
9/3/11 489 Butler Amy Cancer Society $280 9/10/11
9/3/11 499 Cross Roberta Animal Shelter $20 9/8/11
9/2/11 843 Fisher Scott Meals on Wheels $98 9/29/11
9/9/11 849 Daniels Julie Amnesty International $200 9/21/11
9/20/11 888 Los Jim Meals on Wheels $88 9/22/11
9/8/11 984 Ash Carlin Diabetic Association $100 9/9/11
9/9/11 987 Rogers Scott Animal Shelter $38 9/18/11
9/9/11 978 Ash Scott Diabetic Association $100 9/18/11
9/9/11 832 Haitz Todd Cancer Society $80 9/14/11
9/19/11 897 Daniels Julie Make a Wish Foundation $130 9/21/11
9/3/11 948 Williams James Vietnam Veterans $90 9/13/11
9/14/11 977 Rogers Scott Homeless Shelters $80 9/19/11
9/17/11 987 Haim Gary Diabetic Association $80 9/22/11

Answers

TOTAL DONATIONS PER ORGANIZATION AVERAGE DONATION PER ORGANIZATION
Organization Amount Organization Amount
Amnesty International Total Amnesty International Total
Animal Shelter Total Animal Shelter Total
Cancer Society Total Cancer Society Total
Diabetic Association Total Diabetic Association Total
Habitat for Humanity Total Habitat for Humanity Total
Homeless Shelters Total Homeless Shelters Total
Leukemia Society Total Leukemia Society Total
Make a Wish Foundation Total Make a Wish Foundation Total
Meals on Wheels Total Meals on Wheels Total
Police Federation Total Police Federation Total
Vietnam Veterans Total Vietnam Veterans Total
Grand Total Grand Average