Describe and explain how information systems provide business value and assess the ethical, privacy, and security issues involved in the use of information systems.
2. Integrate the theory and practice of information technology with fundamental business enterprise concepts and principles of management, finance, operations, strategic planning, and marketing.
3. Implement the different types of systems that are used to support business processes.
4. Develop business process innovation and analyze the importance of these efforts for contemporary business.

Student Name & ID:

The Makeup2015.xlsx file (available for download University Portal) gives sales data for a small makeup company.
Each row lists the salesperson, product sold, location of the sale, units sold, and revenue generated.
Use this fi le to perform the following exercises:
a. Summarize the total revenue and units sold by each person of each product.
b. Summarize the percentage of each person’s sales that came from each location. Create a PivotChart to summarize this information.
c. Summarize each girl’s sales by location and use the Report Filter to change the calculations to include any subset of products.
College of Business AdministrationPage | 1