Data entry & Organization

This project simply requires simple data entry and organization for an education initiative project. The specific directions are listed below. Start with the first attachment- anything before April 2014 will not have a region listed (the highlighted “extension region” column). Fill in these regions by searching the zip code to find the county it was held in, using the “counties targeted” column (but only if one county is listed), or by searching the name of who delivered it (at [login to view URL]). If you have the county, you’ll know the region by consulting the second attachment- find the county and then fill in which region it is in the column. If you have the name of who delivered it, their region should be listed on the extension website. Sort the sheet by Extension region. Put in breaks so it’s clear that each region (i.e., urban west, urban east, NE, NW, WC, EC, SW, SE) has it’s own section. For each region, sum the following: Number of events Number of attendees Number of events that involved partners Start a new spreadsheet with the columns of: name, number of events, number reached, number of events with partners, salary offset, county support, mileage, other expenses. Use the 3rd and 4th attachments, which are team member lists by region. Use these to get the names and again break up (include a blank row to break up the regions- give each region own highlighted color) the sheet by region. There should be a lot of overlap between the two but check each one because some people may have only been on year 1 (3rd attachment) or year 2 (4th attachment). Go back to your first spreadsheet to fill in the total events, attendees, and partnership numbers for each person. We assume you’ll have a lot of zeroes for team members. The point of this is to show that we spent money to train people, but not everyone performed that well.