Excel dashboard project

DASHBOARD PROTOTYPE Dashboard Components Required Points 300 Analysis Tabs Organized and Accurate 5 Pivot Table Works Properly/ Appropriate use 5 Advanced Formula Works Properly/ Appropriate use Ex: Pivot Table Cal culation 5 Conditional Formatting Works Properly/ Appropriate use 5 IF Formula Works Properly/ Appropriate use 20 Advanced Function Works Properly/ Appropriate use Ex: VLookup, Index, Choose , etc. 20 Sparkline Works Properly/ Appropriate use 5 Annotation /Comments on Analysis tabs for questions Comment that summarizes the answer to your question 20 DASHBOARD Visually Appealing and Informs the User/Meets the Objective 20 Pivot Table Chart s Works Properly/ Appropriate use 10 Pivot Table Chart s Labels, Titles, Visual Effect, Filters 10 Pivot Table Combination Chart Interpretations – Answer the question on your mockup. 15 Slicer Works Properly/ Appropriate use 10 Advanced macro s on DB Works Properly/ Appropriate use 20 Trending Chart - (Smoothing or Linear Forecast) Works Properly/ Appropriate use/Interpretation/ Labels, Titles, Visual Effect 20 Challenging components (2) different ones for a grade of A Examples: Histogram and/or Pareto chart, Thermometer chart, Interactive controls (ex: check box). An approved example from Chapter 52 of your class book. 20 Mockup 5 or 6 questions that center around the objective 10 Map Hyperlinks from components to tab/ Appropriate purpose – See example for details 20 JU SYMPOSIUM PowerPoint & Presentation Visually Appealing and Informs 50 TOTAL LATE Pass the Due Date Minus 30 Comment: You must prese nt in the JU Symposium. Levels of Quality Points Awarded Excellent Works Properly AND Appropriate use ; Visually organized and appealing Full Number of Points as shown in the rubric Partial Works Properly OR Appropriate use ; Partially organized and/or appealing. ½ Points as shown in the rubric Poor Does not Work properly or is it used appropriat ely; unorganized; messy and unappealing; not done No P oints