The final project is the last phase of the Dashboard project
Document Preview:
The final project is the last phase of the Dashboard project. It uses decision making skills, problem solving skills, and information technologies in order to apply the business and economic knowledge gained from the project experience. You will have 3 questions that you answer in Blackboard based on your excel skills and analysis of the data. You must show the work in the Excel spreadsheet that you will also submit. You MUST submit the Excel spreadsheet and answer the questions in Blackboard to receive credit. This project can only be taken once and will not be accepted after August 23rd. This project has a time limit of 2 hours. DO NOT OPEN IT UNTIL YOU ARE READY TO TAKE IT. You will be notified when time expires, and you may continue or submit. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain. Make sure to have a 2 hour window that you can work on this because you will not be allowed to take it twice. You will have points deducted if you do not submit the project by the end of the 2 hour window. It will be considered late. Exam Review .Content Previous item Page 3 of 4 Next item You will have two hours to complete your project. Your Exam will consist of: Essay Questions 1. You will answer the questions by using your Excel & Access Skills to query the answers. 2. You will analyze the data and draw conclusions. The project will include excel skills and analysis: Now Function IF Function Name Manager for Row Titles Conditional Formatting Average Function Sparkline Column Chart Pivot Tables Pivot Table Values (Sum, Count, Average, etc.) Pivot Charts Group dates to have months, years and quarters (One time,,,when you start the exam. Do not redo or undo). It will change your answers. Stacked Time Comparison Chart Charts with secondary axis Slicer Forecasting using Linear Trendlines in charts You will analyze the data
Document Preview:
The final project is the last phase of the Dashboard project. It uses decision making skills, problem solving skills, and information technologies in order to apply the business and economic knowledge gained from the project experience. You will have 3 questions that you answer in Blackboard based on your excel skills and analysis of the data. You must show the work in the Excel spreadsheet that you will also submit. You MUST submit the Excel spreadsheet and answer the questions in Blackboard to receive credit. This project can only be taken once and will not be accepted after August 23rd. This project has a time limit of 2 hours. DO NOT OPEN IT UNTIL YOU ARE READY TO TAKE IT. You will be notified when time expires, and you may continue or submit. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain. Make sure to have a 2 hour window that you can work on this because you will not be allowed to take it twice. You will have points deducted if you do not submit the project by the end of the 2 hour window. It will be considered late. Exam Review .Content Previous item Page 3 of 4 Next item You will have two hours to complete your project. Your Exam will consist of: Essay Questions 1. You will answer the questions by using your Excel & Access Skills to query the answers. 2. You will analyze the data and draw conclusions. The project will include excel skills and analysis: Now Function IF Function Name Manager for Row Titles Conditional Formatting Average Function Sparkline Column Chart Pivot Tables Pivot Table Values (Sum, Count, Average, etc.) Pivot Charts Group dates to have months, years and quarters (One time,,,when you start the exam. Do not redo or undo). It will change your answers. Stacked Time Comparison Chart Charts with secondary axis Slicer Forecasting using Linear Trendlines in charts You will analyze the data
0 comments:
Post a Comment