The Excel 2010 assessment is fully simulated and available at a variety of levels enabling you to assess at a level relevant to both the candidate and the role. A comprehensive report breaks down ability by level, percentile and correct answers.
Available levels are basic, intermediate and expert. You can choose the level at the point of assignment.
The levels were initially based on Microsoft Training and have been “levelled” in line with real world day to day activities. The levelling is based on a common consensus from Skillsarena’s view, customer feedback and the Skillsarena User Group. Levels assigned to candidates should be chosen as appropriate to the needs of the role. In the vast majority of cases Basic is appropriate and perhaps intermediate in some cases.
Consider that the levels are based on “typical use” of the application; for example basic would cover those tasks that are performed regularly and easily, the majority of times by most people using the application day in day out. More difficult tasks such as those in intermediate and certainly expert levels will only be performed by those that have more in-depth knowledge of the application and typically use far less basic functionality.
Consideration 1: MS Applications are vast in their capabilities and functionality. The majority of us only use around 20% or less of the applications full capability (and don’t need any more than this in the majority of cases).
Consideration 2: Everyone’s opinion of their own level is very different. Levels in the assessments here are based on functionality, complexity and how common a task would be performed in the normal workplace.
Persons who need to demonstrate understanding and capability in MS applications prior to employment or as part of training needs analysis.
Basic. Clear the data in cell B4.
Intermediate. Give the chart on the worksheet “Charts” the title “Staff”.
Expert. In the current worksheet use the filter list option so that only “Electronics” items are displayed.