and a design workbook to calculate target capability levels based on enterprise-specific design factors. COBIT 2019 Governance System Design Workbook
Why use an Excel spreadsheet for such a complex assessment? The answer lies in accessibility and customizability. While enterprise software suites exist, Excel remains the most common tool for governance professionals because:
A verified Excel assessment model must automate complex data structures across multiple worksheets. It translates qualitative qualitative audit observations into quantifiable capability metrics. Module A: The Design Factors Calculator
in Excel format. This "verified" tool facilitates several key assessment functions: Building a Maturity Model for COBIT 2019 Based on CMMI 28 Dec 2021 — cobit 2019 maturity assessment tool xls verified
The spreadsheet automatically generates visual charts—typically radar graphs or bar charts. These dashboards provide an immediate look at the "Gap" between the current capability level and the target maturity level dictated by the design factors. Step-by-Step Guide to Conducting the Assessment
Separately, ISACA publishes a free — an Excel file that helps organizations design and implement a tailored governance system. While its primary purpose is design rather than maturity assessment, many practitioners adapt it for assessment purposes. It guides users through 11 design factors, assigning values and importance levels based on the organization’s context, then calculates the impact of each factor on the 40 governance and management objectives. Academic research has confirmed that the design toolkit is itself an Excel file published by ISACA, containing sheets such as the COBIT Performance Model (CPM).
The process is not implemented or fails to achieve its purpose. and a design workbook to calculate target capability
Work through the 40 objectives listed in the XLS tool. Interview process owners, review policy documentation, and inspect configuration settings. For example, under , verify how your enterprise monitors shadow IT—such as employees downloading unauthorized entertainment software onto corporate devices. Step 4: Record Findings and Calculate Scores
Enterprise Governance of Information and Technology (EGIT) requires structured evaluation to align IT operations with core business objectives. , the globally recognized framework created by ISACA , shifts enterprise governance from rigid capability frameworks to dynamic, tailored governance systems.
Instead of simple "Yes/No" options for maturity levels, this spreadsheet utilized the attributes. It asked specific questions for each level to ensure you couldn't "skip" steps. While enterprise software suites exist, Excel remains the
Are you aligning this with other frameworks like or NIST ?
A maps your organization’s 40 governance and management objectives (e.g., APO01 – IT Management Framework, DSS01 – Managed Operations) against these levels. The result is a heatmap or scorecard that highlights gaps and strengths.
The process is planned, monitored, and adjusted.