Data Entry and Project Implentiation

PART 1.

Campus Travel has recently started selling products on the Internet; the managers are eager to know how the company's Web site is accepted by the customers. The file Week3_CampusTravel.csv contains transaction information for the past three days, generated from the company's Web server, including IP addresses of the visitors, whether a transaction was completed, and the transaction amount. You are asked to present the current status of the e-commerce initiative. Use your spreadsheet program to prepare the following graphs:

 

1.  A graph highlighting the total number of site visits and the total number of transactions per day.

 

      2.     A graph highlighting the total sales per day.

 

· Please make sure you document the two (2) graphs proficiently and professionally.  

 

Make sure to format the graphs in a professional manner, including headers, footers, and the appropriate labels, and print each graph on a separate page (Hint: To calculate the total number of site visits and the total number of transactions, use the "countif" function to count the number). 

PART 2.

Not all frequent fliers accumulate large amounts of miles.  There are many who never travel for years but have frequent-flier accounts.  As manager of sales and marketing, you want to find out how to target these individuals with promotions and special offers. To accomplish this task, you will need to create the following reports:

 

1.  A report displaying all frequent fliers, sorted by distance traveled

2.  A report displaying all frequent fliers, sorted by the total amount spent on air travel.  In the file Week3_InfrequentFliers.mdb, you find travel data of the members of a frequent-flier program for the year 2012.  Prepare professionally formatted printouts of all reports, including headers, footers, dates, and so on. (Hint: Use the report wizard to create the reports; use queries to sum up the fares and distances for each traveler before creating the respective reports.)

 

· Please name your assignment (Your_Lastname_Week3 Database-Assmt)