Criteria
| Credits | 10 credits |
| Mode of Training | Self-learning with doubt clearing sessions |
| Criteria to attain credits | Complete all the modules
Successfully complete the assessment |
| Final Assessment Format | Descriptive |
| Does the assessment require answer script submission | Yes |
| Mode of score collation | Offline |
| Assessment Duration | 2 hours (closed book) |
| Passing Percentage | 70% |
| No of question paper sets available | 5 |
| For enrollment to earn credits | Contact your BU PoC for enrollment, scheduling test, answer script submission and credit allocation |
| References useful for BU PoCs only | Link |
| People who have attained credits for this course | NA |
Test Information
The test consists of two parts.
Part 1 – Check the understanding of concepts of Excel covered in Excel Level: 01 course
Part 2 – Dashboarding
Evaluation Criteria for Dashboarding exercise
| Components | Criteria |
| Calculations and Functionality (25 Marks) |
Are all the NULLS in the data treated? |
| Data cleaning/column transformations/column creation done? | |
| Are the drop downs changing dynamically? | |
| Are the tables and graphs dynamically changing? | |
| Are the formulae taking care of edge cases? (iferrors and offsets applied properly) | |
| Pivot tables and pivot charts created correctly? | |
| Formatting (15 Marks) |
Are the formatting of fonts, text alignments, borders proper for all the visuals/cards? |
| Are the numbers formatted properly (decimal values, currency format, etc)? | |
| Mu Sigma colours used? | |
| Are all the headings and titles meaningful and intuitive? | |
| Sheets and data tables are named correctly? | |
| Problem Completion and StoryFlow (10 Marks) |
Are the different views in the dashboard in a flow ? |
| Are all the relevant views created? | |
| Does the dashboard display proper insights and recommendations ? | |
| Does the story conclude to a result ? |