Using this data, company executives would like to see a set of Key Performance Indicators (KPIs) displayed as a Dashboard which they can use to quickly evaluate how well the organization is doing in achieving its overall strategic goals. The executives would like an interactive tool that will provide them with a quick overview of the sales of the organization. The report should be in chart or graphic form and must be condensed to a single worksheet. The report should be interactive such that users would be able to change variables directly on the face of the chart (e.g. change variables so that they see the trend for only the last 6 months as opposed to the entire year).
APPENDIX A- POSSIBLE STUDENT PROJECT HANDOUT ASSIGNMENT Assignment a s me you have been h as an instructor's aid and luve been pan the seadents' grade infoemation abeve that has Ibeen impo r Cvas You are to design a grade book using ExcelC that will provide the following infomation l) The ltal points possible for each assignment are as ellows a. Quizzes-5 points possible for each qui b. Projects 25 points possiNe for each peeject Exams-100 poins possible for each exam 2) Minimum Maximum and Average scorcs for each assignentquir projoct and am Also find Maximum % and Average % for each ampincm Total cach student's points and the total points possble Alow the grade book to drop the lowest quir score 5) The overall average quiz, project, esam atd lotal scones befre and aftfuppig a s lowest quiz scorefs) 6)Calculaie cach shadent's scote as a percentage of the total adjusted possiile 7) Have the Pde book automatically assign a student gade hacd os of RON, 70% 60% and below with the opion of bazg flexble in the event the 8) Determine the individual shademt's grade point valac basod on ther letier gradk Alo ) Provide a grade distribution by having the specadshont astomatically calcu he 10Alow the mstructor to analyze the data by putting .t inonder hemthe highest.. I1) Make rocommendations to the instructor about whetho or not yo thirk the gd nstructor dsires to curve the grad make this Bexible in the event the istructor desires to curve the grades number ofand % ofeach Fade awarded("A",-s", ct.). otal score to the lowest adjustod total score be curvod, and whether or not you think cheating has occurred anywhore. Jusify your AJS Edveator Jornal Falue , Na. 2088-3 APPENDIX A- POSSIBLE STUDENT PROJECT HANDOUT ASSIGNMENT Assignment a s me you have been h as an instructor's aid and luve been pan the seadents' grade infoemation abeve that has Ibeen impo r Cvas You are to design a grade book using ExcelC that will provide the following infomation l) The ltal points possible for each assignment are as ellows a. Quizzes-5 points possible for each qui b. Projects 25 points possiNe for each peeject Exams-100 poins possible for each exam 2) Minimum Maximum and Average scorcs for each assignentquir projoct and am Also find Maximum % and Average % for each ampincm Total cach student's points and the total points possble Alow the grade book to drop the lowest quir score 5) The overall average quiz, project, esam atd lotal scones befre and aftfuppig a s lowest quiz scorefs) 6)Calculaie cach shadent's scote as a percentage of the total adjusted possiile 7) Have the Pde book automatically assign a student gade hacd os of RON, 70% 60% and below with the opion of bazg flexble in the event the 8) Determine the individual shademt's grade point valac basod on ther letier gradk Alo ) Provide a grade distribution by having the specadshont astomatically calcu he 10Alow the mstructor to analyze the data by putting .t inonder hemthe highest.. I1) Make rocommendations to the instructor about whetho or not yo thirk the gd nstructor dsires to curve the grad make this Bexible in the event the istructor desires to curve the grades number ofand % ofeach Fade awarded("A",-s", ct.). otal score to the lowest adjustod total score be curvod, and whether or not you think cheating has occurred anywhore. Jusify your AJS Edveator Jornal Falue , Na. 2088-3
