Homework Exercise - CIS 211 - Management Information Systems

Independent Work Policy

On this assignment, students must work independently. Actions such as directly collaborating with students currently enrolled in the class, referring to the work students formerly enrolled in the class, and using other people to complete the assignment are all examples of violations of this policy. Students should use the instructor for any questions about completing the assignment.

Academic Integrity

Students who choose to violate the independent work policy must cite the use of other people's work by including the names of those people in a conspicuous location. By providing citations, students avoid violating the Elon Honor Code. Students who both violate the independent work policy and fail to cite the names of contributors are subject to the Elon University Academic Integrity Policy.

Format

Students will modify a Microsoft Access database subject to the directions below.

Directions

Download cis-211-hw-5.accdb, a database of donations to a university. You will find that there are 10 blank queries (i.e., queries with no fields that produce no data in the datasheet view). Modify the queries according to the directions below. Each query is worth 6 points. Partial credit will be awarded.

Do not rename queries and ensure that you modify the correct query. Each misnamed query results in a 1-point deduction (10 total points if all are misnamed).

Sort each query by the first field listed unless otherwise directed. Queries that are not sorted in the expected way may result in a 1-point deduction (10 points total if all queries are not sorted).

  1. 01-505-Donors: Show the donor phone number, donor city, donor ID, and donor type name of all donors in the 505 area code.
  2. 02-Vacaville-NM: Show the donor phone number, donor ID, and donor type name of all donors in Vacaville, NM.
  3. 03-Received-Gifts: Show the gift ID, gift value, gift year, donor ID, and fund name of all received gifts.
  4. 04-Pledges: In this query you will determine which donors have promised gifts that have not been received and for each such donor, how many gifts have not been received. So for each donor, show the number of non-received gifts from that donor, donor ID, and donor phone number. Sort the query by the number of non-received gifts (descending) and then by donor ID (ascending).
  5. 05-Non-Alum-Big-Gifts: Show the gift ID, donor ID, fund name, fund type name, and gift value of all gifts of $1000 or more made by non-alumni to either General fund types or Athletic fund types.
  6. 06-Value-Summary: In this query you will determine the total value of received gifts and total value of non-received gifts. Show two fields: whether the gifts were received or not, and the total value of gifts in that category. Ensure to use appropriate field names (i.e., not the default names)
  7. 07-Gifts-by-Fund: Show the fund name and total value of gifts donated to each fund. In a third field named Interest, calculate 3% of the total gift value (Hint: in the Totals row in the query design view for the Interest field, change Group By to Expression). Format the Interest field as currency with no decimal places showing.
  8. 08-Gifts-by-Month-and-Year: Break down gifts by year then by month. For each unique combination of month and year, provide both the number of gifts made and total value of gifts made. The fields provided will thus be year, month, number of gifts, and total value of gifts. Sort by year then by month in descending order.
  9. 09-Dec-Gifts: In this query, look only at gift-giving in December months. Show the year and total value of gifts made in each December in 2005 or after.
  10. 10-Recontact-List: Show the donor ID and phone number of all donors who have made only one donation and who have not donated in 2007.

Delivery

Use the following steps to upload your two Access files to Blackboard no later than the date listed on the class schedule. We will discuss the solution to the assignment in class on the due date, so late work cannot be accepted.

  1. Ensure that you have not changed the file name
  2. Open the Blackboard page for the class
  3. Click Course Tools
  4. Click Digital Dropbox
  5. Click Send File (not Add File)
  6. In the Name field, type HW5 (do not type your name)
  7. Submit the file