Assignment 6.7 - Marking Guide Element Mark Result Main board Company logo 1.0 List box - month 1.0 List box - division 1.0 Requirement 1: Division statistics Profit identification 1.0 Correct profit figure 1.0 Correct variance 1.0 Correct over / under 1.0 Number format correct 1.0 Use company colors 1.0 Revenue identification 1.0 Correct revenue figure 1.0 Correct variance 1.0 Correct over / under 1.0 Number format correct 1.0 Use company colors 1.0 Net profit % identification 1.0 Correct net profit % figure 1.0 Correct variance 1.0 Correct over / under 1.0 Number format correct 1.0 Use company colors 1.0 Requirement 2: Product table Adhere to CEO format given 1.0 Display Cake division products 1.0 No gridlines 1.0 Sorted - high np% to low np% 1.0 Use colour to distinguish between sections 1.0 Table not cramped in 1.0 Net profit % Formatting is %, no decimals 1.0 Figures are correct 1.0 Colour as per CEO request 1.0 Robot indicator inserted 1.0 Robot indicator working as required 3.0

Profit Formatting is numbers with only thousands indicator 1.0 Figures are correct 1.0 Smiley indicator inserted 1.0 Smiley indicator working as required 2.0 Use appropriate colours (preferably company) 1.0 Revenue Formatting is numbers with only thousands indicator 1.0 Figures are correct 1.0 Bar conditional formatting inserted 1.0 Bar conditional formatting working as required 2.0 Use appropriate colours (preferably company) 1.0 Requirement 2: Top / Bottom 5 chart per revenue / profit Selection control for Profit / Revenue 1.0 Selection control for Top 5 / Bottom 5 1.0 Company colours used 1.0 Appropriate graph chosen 1.0 No gridlines 1.0 No y-axis 1.0 X-axis displaying products 1.0 Output of graph is correct - top 5 displayed 1.0 Legend indicating actual & budget 1.0 Labeling of values 1.0 Formatting in labeling is correct (thousands indicator / %) 1.0 Requirement 3: Net profit percentage tracker chart Selection control for products 1.0 Products for the Cake division in control 1.0 Company colours used 1.0 Appropriate graph chosen 1.0 No gridlines 1.0 Appropriate y-axis or labelling indicating percentages 1.0 X-axis displaying 12 months 1.0 Output of graph is correct for actual 1.0 Output of graph is correct for budget 1.0 Legend indicating actual & budget 1.0 Other best practices Dashboard on one page 1.0 Time stamp on dashboard 1.0 Extraction date on dashboard 1.0 70.0