ACCOUNTING INFORMATION SYSTEM Homework
TOTAL MARKS: 50 Marks
Machine Problem.
Direction: Read, analyze the narrative, and answer what are required.
Read the “superstore.xlsx” data into Power BI and find answers of the following:
Upload the data, “manager” and “order” in MS Access.
Create QUERIES for each segment
A. Consumer
2. Corporate
3. Home Office
Each query has the following information:
Segment. Use criteria
Order ID
Order Date
Customer ID
Region
Category
Sub-category
Quantity
Unit Price
Profit
Make a query to determine the Total Sales for each category. Name it as follows:
A. Consumer: Consumer Sales
2. Corporate: Corporate Sales
3. Home Office: Home Sales
The query should contain the following data:
Order ID
Order Date
Region
Category
Sub-category
Quantity
Unit Price
Sales Amount
Profit
Answer the following:
What is the total sale, profit for each segment?
| Sales | Profit | |
| A. Consumer | ||
| 2. Corporate | ||
| 3. Home Office |
Using the segment (Corporate, Consumer & Home Office), determine how much profit per category.
| Furniture | Office Supplies | Technology | |
| A. Consumer | |||
| 2. Corporate | |||
| 3. Home Office |
Rubric:
| 10-8 | 7-5 | 4- 0 | ||
| Has in-depth clear understanding on how use MS Access to create database | Clear understanding On how to use MS Access | Barely understood how to use MS Access or none at all. | |
| | 20-12 | 11-6 | 5-0 | |
| B. Ability to employ model-building techniques | All tables were created with 80-100% attributes are correct | All tables were created with 40-79% attributes are correct | Not all tables were created and/or less 40% attributes are correct | |
| | 20-12 | 11-6 | 5-0 | |
| C. Ability to develop Query to support business decisions making | All queries were created with 80-100% attributes are correct | All queries were created with 40-79% attributes are correct | Not all queries were created and/or less 40% attributes are correct |
| Prepared by : | Reviewed / Checked: | Recommending Approval: | Approved by: |
| DR. CECILIA LAGARAS Course Coordinator | DR. VISHWAS CHAKRANARAJAN Programme Head, BSBI | DR. VINODH NATARAJAN Associate Dean | MARLUNA L. URUBIO, Ph.D. Dean, CAFS |
| Date: : | Date: | Date: : | Date: : |
