2023-2024 Course Standards
Legend
BM20 Microsoft Excel
Course Type: Adopted
Standard/Obj # | Standard/Objective | Course Weight | RBT Designation | Essential Employability Skills |
---|---|---|---|---|
1.00 | Understand basic and intermediate spreadsheet software skills. | 30% | B2 Conceptual Knowledge - Understand | Communication Ethics Problem Solving Professionalism Resource Management Teamwork |
1.01 | Introduction to Excel fundamentals. | - | B2 Conceptual Knowledge - Understand | - |
1.02 | Managing worksheets and workbooks. | - | B2 Conceptual Knowledge - Understand | - |
1.03 | Formatting cells. | - | B2 Conceptual Knowledge - Understand | - |
1.04 | Managing tables and range data. | - | B2 Conceptual Knowledge - Understand | - |
1.05 | Using formulas and functions. | - | B2 Conceptual Knowledge - Understand | - |
1.06 | Getting and transforming data. | - | B2 Conceptual Knowledge - Understand | - |
1.07 | Visualizing data. | - | B2 Conceptual Knowledge - Understand | - |
1.08 | Preparing to print and checking for issues. | - | B2 Conceptual Knowledge - Understand | - |
2.00 | Understand the advanced spreadsheet software skills. | 70% | B2 Conceptual Knowledge - Understand | Communication Ethics Problem Solving Professionalism Resource Management Teamwork |
2.01 | Managing and formatting data. | - | B2 Conceptual Knowledge - Understand | - |
2.02 | Using advanced formulas. | - | B2 Conceptual Knowledge - Understand | - |
2.03 | Validating and auditing data. | - | B2 Conceptual Knowledge - Understand | - |
2.04 | Analyzing data. | - | B2 Conceptual Knowledge - Understand | - |
2.05 | Using simple macros. | - | B2 Conceptual Knowledge - Understand | - |
2.06 | Using Microsoft PivotTables and Microsoft PivotCharts. | - | B2 Conceptual Knowledge - Understand | - |
2.07 | Collaborating with other people. | - | B2 Conceptual Knowledge - Understand | - |