Page of 3 ZOOM + Apply Your Knowledge Project 4 - Tracking Donations Input boxes In tan Output boxes in yellow Given data in blue Answers in red 234 Daniels Submitted Employee ID Last Name 12/6/2011 211 Smith 12/16/2011 12/5/2011 243 Bagley 12/10/2011 334 Kellee 12/6/2011 345 Cross 12/27/2011 365 Lee 12/13/2011 366 Smith 12/27/2011 370 Wills 12/4/2011 389|Fisher 11/29/2011 432 Ash 12/2/2011 454 Cross 12/3/2011 456|Butler 12/3/2011 499 Cross 12/2/2011 543 Fisher 12/12/2011 546 Daniels 12/20/2011 558 LOS 12/5/2011 654 Ash 2/12/2011 657 Rogers 12/9/2011 675 Ash 12/6/2011 832 Haitz 12/16/2011 867 Daniels 12/3/2011 945 Williams 12/14/2011 977 Rogers 12/17/2011 987 Haim 2/6/2011 21 Smith 2/16/2011 234 Daniels 2/5/2011 243 Bagley 2/10/2011 334 Kellee 2/6/2011 345 Cross 2/27/2011 365 Lee 2/13/2011 366 Smith 2/27/2011 370 Wills 2/4/2011 389 Fisher 1/29/2011 432 Ash 2/2/2011 454 Cross 2/3/2011 456 Butler 2/3/2011 499 Cross 212/2011 543 Fisher First Name Organization James Diabetic Association Julie Make a Wish Foundation Bob Cancer Society Pete Police Federation Roberta Leukemia Society Sufeing Homeless Shelters James Habitat for Humanity Mary Habitat for Humanity Scott Cancer Society Jamie Habitat for Humanity Roberta Make a Wish Foundation Amy Cancer Society Roberta Animal Shelter Scott Meals on Wheels Julie Amnesty International Jim Meals on Wheels Carlin Diabetic Association Scott Animal Shelter Scott Diabetic Association Todd Cancer Society Julie Make a Wish Foundation James Vietnam Veterans Scott Homeless Shelters Gary Diabetic Association James Diabetic Association Julie Make a Wish Foundation Bob Cancer Society Pete Police Federation Roberta Leukemia Society Sufeing Homeless Shelters James Habitat for Humanity Mary Habitat for Humanity Scott Cancer Society Jamie Habitat for Humanity Roberta Make a Wish Foundation Amy Cancer Society Roberta Animal Shelter Scott Meals on Wheps Amount Donation Sent $50 12/19/2011 $2251 12/29/2011 $25 12/6/2011 $180 12/14/2011 $60 12/19/2011 $25 12/30/2011 $ $150 12/23/2011 $100 12/29/2011 $125 12/10/2011 $50 12/1/2011 $75 12/4/2011 $250 12/10/2011 $20 12/5/2011 $125 12/26/2011 $200 12/21/2011 $115 12/22/2011 $100 12/6/2011 $35 12/15/2011 $100 12/18/2011 $50 12/14/2011 $130 12/21/2011 $60 12/13/2011 $ $80 12/19/2011 $50 12/22/2011 $50 2/19/2011 $225 2/29/2011 $25 2/6/2011 $180 2/14/2011 $60 2/19/2011 $251 2/30/2011 $150 2/23/2011 $100 2/29/2011 $25 2/10/2011 $50 2/1/2011 $75 2/4/2011 $250 2/10/2011 $20 2/5/2011 $25 2/26/2011 Page of 3 ZOOM + Submitted Employee ID Last Name 12/6/2011 211 Smith 12/16/2011 234|Daniels 12/5/2011 243 Bagley 12/10/2011 334 Keller 12/6/2011 345 Cross 12/27/2011 365 Lee 12/13/2011 366 Smith 12/27/2011 370 Wills 12/4/2011 389 Fisher 11/29/2011 432 Ash 12/2/2011 454 Cross 12/3/2011 456 Butler 12/3/2011 499 Cross 12/2/2011 543 Fisher 12/12/2011 546 Daniels 12/20/2011 558 |Los 12/5/2011 654 Ash 12/12/2011 657 Rogers 12/9/2011 675 Ash 12/6/2011 832 Haitz 12/16/2011 867 Daniels 12/3/2011 945 Williams 12/14/2011 977 Rogers 12/17/2011 987|Haim 2/6/2011 21 Smith 2/16/2011 234 Daniels 2/5/2011 243 Bagley 2/10/2011 334 Kellee 2/6/2011 345 Cross 2/27/2011 365 Lee 2/13/2011 366 Smith 2/27/2011 370 Wills 2/4/2011 389 Fisher 1/29/2011 432 Ash 2/2/2011 454 Cross 2/3/2011 456 Butler 2/3/2011 499 Cross 2/2/2011 543 Fisher 2/2/2011 546 Daniels 2/20/2011 558 Los 2/5/2011 654 Ash 2/2/2011 657 Rogers 2/9/2011 675 Ash | 2/6/2011 832 Haitz 2/16/2011 867 Daniels 2/3/2011 945 Williams 2/14/2011 977 Rogers 2/17/2011 987 Haim 6/6/2011 25 Smith 6/16/2011 234 Daniels 6/5/2011 243 Bagley 6/10/2011 334 Kellee 6/6/2011 345 Cross 6/27/2011 365 Lee 6/13/2011 366 Smith 6/27/2011 370 Wills 6/4/2011 389 Fisher 5/29/2011 432 Ash 6/2/2011 454 Cross 6/3/2011 456 Butler 6/3/2011 6/2/2011 543 Fisher 6/6/2011 546 Daniels 6/20/2011 558 Los 6/5/2011 654|Ash 6/6/2011 657 Rogers 6/9/2011 675|Ash 6/6/2011 832 Haitz 6/16/2011 867 Daniels First Name Organization James Diabetic Association Julie Make a Wish Foundation Bob Cancer Society Pete Police Federation Roberta Leukemia Society Sufeing Homeless Shelters James Habitat for Humanity Mary Habitat for Humanity Scott Cancer Society Jamie Habitat for Humanity Roberta Make a Wish Foundation Amy Cancer Society Roberta Animal Shelter Scott Meals on Wheels Julie Amnesty International Jim Meals on Wheels Carlin Diabetic Association Scott Animal Shelter Scott Diabetic Association Todd Cancer Society Julie Make a Wish Foundation James Vietnam Veterans Scott Homeless Shelters Gary Diabetic Association James Diabetic Association Julie Make a Wish Foundation Bob Cancer Society Pete Police Federation Roberta Leukemia Society Sufeing Homeless Shelters James Habitat for Humanity Mary Habitat for Humanity Scott Cancer Society Jamie Habitat for Humanity Roberta Make a Wish Foundation Amy Cancer Society Roberta Animal Shelter Scott Meals on Wheels Julie Amnesty International Jim Meals on Wheels Carlin Diabetic Association Scott Animal Shelter Scott Diabetic Association Todd Cancer Society Julie Make a Wish Foundation James Vietnam Veterans Scott Homeless Shelters Gary Diabetic Association James Diabetic Association Julie Make a Wish Foundation Bob Cancer Society Police Federation Roberta Leukemia Society Sufeing Homeless Shelters James Habitat for Humanity Mary Habitat for Humanity Scott Cancer Society Jamie Habitat for Humanity Roberta Make a Wish Foundation Amy Cancer Society Roberta Animal Shelter Scott Meals on Wheels Julie Amnesty International Jim Meals on Wheels Carlin Diabetic Association Scott Animal Shelter Scott Diabetic Association Todd Cancer Society Julie Make a Wish Foundation Amount Donation Sent $50 12/19/2011 $225 12/29/2011 $25 12/6/2011 $180 12/14/2011 $60 12/19/2011 $25 12/30/2011 $1501 12/23/2011 $100 12/29/2011 $125 12/10/2011 $50 12/1/2011 $75 12/4/2011 $250 12/10/2011 $20 12/5/2011 $125 12/26/2011 $200 12/21/2011 $115 12/22/2011 $1001 12/6/2011 $35 12/15/2011 $100 12/18/2011 $50 12/14/2011 $130 12/21/2011 $60 12/13/2011 $80 12/19/2011 $50 12/22/2011 $50 2/19/2011 $225 2/29/2011 $25 2/6/2011 $180 $ 2/14/2011 $60 2/19/2011 $25 2/30/2011 $150 2/23/2011 $100 2/29/2011 $25 2/10/2011 $50 2/1/2011 $75 2/4/2011 $250 2/10/2011 $20 2/5/2011 $25 2/26/2011 $200 2/21/2011 $ $15 2/22/2011 $100 2/6/2011 $35 2/15/2011 $100 2/18/2011 $50 2/14/2011 $130 2/21/2011 $60 2/13/2011 SBO 2/19/2011 $50 2/22/2011 $50 6/19/2011 $225 6/29/2011 $25 6/6/2011 $180 6/14/2011 $60 6/19/2011 $25 6/30/2011 $150 6/23/2011 $100 6/29/2011 $65 6/10/2011 $50 6/1/2011 $75) 6/4/2011 $250 6/10/2011 $20 6/5/2011 $65 6/26/2011 $200 6/21/2011 $55 6/22/2011 $100 6/6/2011 $35 6/15/2011 $100 6/18/2011 $50 6/14/2011 $130 6/21/2011 Pele 499 Cross Page of 3 0 ZOOM + 6/16/2011 6/3/2011 6/14/2011 6/17/2011 9/9/2011 9/19/2011 9/8/2011 9/10/2011 9/9/2011 9/27/2011 9/13/2011 9/27/2011 9/4/2011 8/29/2011 9/2/2011 9/3/2011 9/3/2011 9/2/201 9/9/2011 9/20/2011 9/8/2011 9/9/2011 9/9/2011 9/9/2011 9/19/2011 9/3/2011 9/14/2011 9/17/2011 867 Daniels 945 Williams 977 Rogers 9871 Haim 28 Smith 234 Daniels 243 Bagley 334 Kellee 348 Cross 398|Loo 399 Smith 370 Wills 389 Fisher 432 Ash 484 Cross 489 Butler Julie James Scott Gary James Julie Bob Pete Roberta Sufeing James Mary Scott Jamie Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association Diabetic Association Make a Wish Foundation Cancer Society Police Federation Leukemia Society Homeless Shelters Habitat for Humanity Habitat for Humanity Cancer Society Habitat for Humanity Make a Wish Foundation Cancer Society $130 $60 $80 $50 SBO $228 $28 $180 $90 $28 $180 $100 $98 $80 $78 $280 $20 $98 $200 $BB $100 $38 $1001 $BO $130 $90 $80 $80 6/21/2011 6/13/2011 6/19/2011 6/22/2011 9/19/2011 9/29/2011 9/9/2011 9/14/2011 9/19/2011 9/30/2011 9/23/2011 9/29/2011 9/10/2011 9/1/2011 9/4/2011 9/10/2011 9/8/2011 9/29/2011 9/21/2011 9/22/2011 9/9/2011 9/18/2011 9/18/2011 9/14/2011 9/21/2011 9/13/2011 9/19/2011 9/22/2011 499 Cross Animal Shelter 843 Fisher 849 Daniels 888 Los 984 Ash 987 Rogers 978. Ash 832 Haitz 897 Daniels 948 Williams 977 Rogers 987 Haim Meals on Wheels Amnesty International Meals on Wheels Diabetic Association Animal Shelter Diabetic Association Cancer Society Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association Amount TOTAL DONATIONS PER ORGANIZATION Organization Amnesty International Total Animal Shelter Total Cancer Society Total Diabetic Association Total Habitat for Humanity Total Homeless Shelters Total Leukemia Society Total Make a Wish Foundation Total Meals on Wheels Total Police Federation Total Vietnam Veterans Total Grand Total AVERAGE DONATION PER ORGANIZATION Amount Organization Amnesty International Total Animal Shelter Total Cancer Society Total Diabetic Association Total Habitat for Humanity Total Homeless Shelters Total Leukemia Society Total Make a Wish Foundation Total Meals on Wheels Total Police Federation Total Vietnam Veterans Total Grand Average