Hands of Hope Worksheet – Project Scenario: Your class is volunteering to complete Community Service by helping at the Hands of Hope Food Pantry. You are in charge of keeping track of the hours each class member accumulated for the month of December. You will need to determine the total hours for each member as well as the average for the class. You will also need to use sort/filer database options to help problem solve.
PART I Step 1: Create the worksheet below. Use Data Fill option to enter Members. Step 2: Solve for the Total hours for each member. (AutoSum). Use copy method to copy function to other rows. Step 3: Solve for the Average hours for the entire class by week and for the month. (Average Function) Use copy method to copy function to other columns. Step 4: Center the Title Across Columns of your worksheet Step 5: Save in your folder as your initials period day hope Step 6: Hand in.
PART II Step 7: Sort your worksheet in Descending order by Total (column F)
Step 8: Filter those members who have less than 7 hours of community service completed. Step 9 : Save in your folder as your initials period day newhope Step 10: Hand in.