So once you've wrapped up this course and feel ready for the AC exam, well, you'll need to schedule it. Now, once the exam is finished and submitted, you'll have the opportunity to leave feedback about specific exam items that you've marked. So from here, you can revisit any task by clicking on it and making any necessary changes until you finish the exam. Now, as you can see, it contains the tasks for all the projects and indicates whether they've been marked as complete for review or for feedback. Now, for example, summarise The Exam Summary view will appear once you've submitted all of your projects, but it can also be accessed with the Go to Summary button in the Exam Panel. Now, what you see marked as number two here in the picture is simply the divider line between the project file and the exam panel, which you can move up and down to resize them. Now just note that restarting a project won't restart the time it's just going to clear the tasks so you can get a fresh start. Now the Exam Panel is where you can view the project tasks, check the time remaining, restart or submit projects, and mark tasks as complete for review or for feedback. These are going to be opened automatically within Compass when you start a new project and will be saved once you submit it. Just note that you won't actually need to open or save any Excel files yourself. In other words, this is Excel as you know it. Now, the project file is the Excel interface, where you're going to be performing the tasks listed in the Exam Panel below. So once you're encompassed in the exam and it's started, your screen will look like this: As you can see, the Compass interface is divided into two main sections, the Project File and the Exam Panel. So I hope you're ready.Īlright, the exam interface is what you'll be interacting with while taking the exam. But other than that, these are all the topics covered in the exam and in the course. And this was done with the purpose of having a natural flow between the objective domains, the skills measured, and the course project. And then we broke some of these skills down to illustrate the topics more clearly. So, before we continue, if you download the official skillsmeasured PDF from the MO 201 website, you'll notice that the order is a bit different in the course. And finally, for workbook options and settings, you'll need to be able to manage workbooks, prepare workbooks for collaboration, and use and configure language options. For advanced charts and tables, you'll need to be able to create and modify advanced charts, create and modify Pivot tables, and create and modify Pivot charts. For managing and formatting data, you need to be able to fill cells based on existing data, format and validate data, and apply advanced conditional formatting and filtering. So for advanced formulas and macros, you'll need to be able to perform logical operations and formulas, use advanced date and time functions, create and modify simple macros, look up data using functions, perform data analysis, and troubleshoot formulas. Now, each of these objective domains contains a set of skills that can be measured and demonstrate competence in that area. So what will Microsoft be evaluating to certify me as an Excel expert? Well, the skills measured in the Mo 201Excel Expert Exam are broken up into four objective domains: creating advanced formulas and macros, managing and formatting data, creating advanced charts and tables, and managing workbook options and settings. Okay, time to talk about the actual content of the exam. Now, Microsoft doesn't provide task-level feedback, but they do give you score bars for each of the exam subjective domains, which we're going to review in the next lecture. Your exam score report is going to be available immediately after submitting the exam. And finally, the exam is scored from zero to 10, and a grade of 700 or more is required to become an official Microsoft certified expert. If you're having trouble with a specific task, you can mark it for review and revisit it as many times as you'd like within this time limit. number three, you'll have 15 minutes to complete the exam. It's made up of around six projects, each of which is a real-world business case, and has a total of around 25 tasks between those projects that revolve around those business scenarios. Number two, this is a project-based exam, so there's going to be no multiple-choice questions. Now, there's no need to worry about this right now, as we're going to talk about the interface in depth in another lecture. When you show up to take the test, your proctor will open up Compass on the computer and launch the exam, and you won't be able to leave Compass until you've completed it. Number one, the exam is presented using Compass, which is a web-based interface from a sort of port. All right, time to start talking about the exam itself, beginning with its structure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |