How would you make the reports in PE Figures 10-1 and 10-2 “look better”? After
ID: 3765406 • Letter: H
Question
How would you make the reports in PE Figures 10-1 and 10-2 “look better”? After you improve the design of the reports, explain why you make the changes you did
10-1 10-2 Petrie's Best Customers by Monthly Purchases March 20fd Petrie's Best Customers by Monthly Purchases March 2014 Grand 5 Customer 6 Customer Name Customer ID Home City State Total 7 Francesca Jones 43218765-991 New Orleans LA 8 Ahmad Walgreens 12345678-990 Yuba City CA 2134.35 9 Wilma Sanchez 10 Sylvia Pollock 11 William Peace 12 Jose Gonzalez 13 D'Andre Martinez 14 John Smith 5 Custonmer 6 Custonser Naame Customer ID Horne City State Quantity SKU Description 7 Franicesca Jones 43218765-991 New Orleans LA Grand Amount TotalTotal 2 67830 50r Panasonic 30 TV 4 98000 8 HDVI cables 1 44441 Flat scre-en TV stand 3327.65 249.95249.95 10 Ahmed Walgreens 12345078290 Yub City CA 34567 19"ggmputer monitor 93.99 99,99 2134, 35 45645699-990 Lamoni 2038.75 1988.94 1645.87 1543.34 1109.15 1065.34 147 Dell desktop 134889 HP laser printer P1102w 167890 50r Panasonie 30 TV 2 980&HDVi; cables 1 67890 501 Panasonic 30 TV 1 44441 Flat scre-en TV stand IA CA FL GA 45.56 45,56 14.5 149.95 1398.95 1198.95 69.9 139.90 12 13 Los Angeles Tampa Atlanta New York Las vegas 15 ilma Sanchez 45645699.990Lamon 1398.95 1398.95 2038.75 24995 249.95 1 67388 Petri's 7-1 suround sound set24.95 249.95 69.35 139.90 17 98008" HOVI cables NVExplanation / Answer
CHANGES :-
1). Title, TableName, ColumnName - Should be marked with different colors & style. So, that they are recognisable seperately on their own.
2). Color the columname `Total` with different colors.
lets say
(a). Green for the customers whose CustomerID is present; and red for the missing ones
(b). Green for those with total>3000, yellow for total>2000, etc.
3). `Grand Total` should be highlighted, so that it is clearly visible.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.