Help Manual


Sigma Magic Help Version 17

Change Audit


The Change Audit document can be used to audit any organizational change initiative to ensure that the change will be successful. According to John Kotter's model for change, any change can be characterized by eight steps:
1Establishing a sense of urgency
2Creating a guiding coalition
3Developing a vision and strategy
4Communicating the change vision
5Empowering employees for broad-based action
6Generating short-term wins
7Consolidating gains and producing more change
8Anchoring new approaches in the culture
The checklist documented in the Excel tool is based on John Kotter's model for successful change.


This tool can be added to your active workbook by clicking on Change and then selecting Change Audit. Click on Analysis Setup to open the menu options for this tool.


A sample screenshot of the setup menu is shown below.
menu 1
Analysis Type: Specify the template to use for Change Audit. This option is enabled if there are multiple templates installed on your system.
Rating Scale: Specify the scale used to evaluate each evaluation criterion. You can evaluate the checklist on one of the following scales:
None, Some DoneFor each checklist criterion, you can specify that that criterion is not complete (None), partially complete (Some), or fully complete (Done).
No, YesFor each checklist criteria, you can specify that the criteria are not done (No) or fully done (Yes).
View Example: Click on this button to add an example worksheet. You can use the example to understand how others have filled out the tool or use the example as a starting point and modify it to meet your needs better.
Help Button: Click on this button to open the help file for this topic.
Cancel Button: Click on this button to cancel all changes to the settings and exit this dialog box.
Create Button: Click on this button to save all changes and update the worksheet template.
OK Button: Click on this button to save all changes and compute the outputs for this analysis.
On the worksheet, rate each audit assessment criteria based on the selected scale. There are eight main criteria, and each criterion has a few sub-criteria.


You will see the following dialog box if you click the Checklist button. Data The checklist contains a few pointers on things you must pay particular attention to while performing this analysis. The checklist has been derived from experience working on past projects. Not all the checklist items need to apply to you. However, you should carefully review the checklist and apply any recommendations that make sense for your project. Make sure to read each checklist item and mark it as completed after you have read and taken actions as appropriate for your project.
Item: The items on the checklist are listed on the left
Status: The status of whether the checklist has been answered is listed on the right.
Ideally, all items on the checklist should be marked as reviewed/completed.


If you click the Verify button, the software will perform some checks on the data you entered. A sample screenshot of the dialog box is shown in the figure below. Pre-Process Inputs 4 The software checks if you have correctly specified the input options and entered the required data on the worksheet. The results of the analysis checks are listed on the right. If the checks are passed, they are shown as green-colored checkmarks. If the verification checks fail, they are shown as a red-colored cross. The verification checks are shown in the orange exclamation mark if the verification checks result in a warning. Finally, any checks required to be performed by the user are shown as blue info icons.
Item: The left-hand side shows the major tabs and the items checked within each section
Status: The right-hand side shows the status of the checks.
Overall Status: The overall status of all the checks for the given analysis is shown here. The overall status check shows a green thumps-up sign if everything is okay and a red thumps-down sign if any checks have not passed. Note that you cannot proceed with generating analysis results for some analyses if the overall status is not okay.


Click on Compute Outputs to update the computation results. The figure below shows a sample screenshot of the worksheet. Change Audit Example Depending on how you answered the checklist, the overall phase of your project is determined. The project phase is marked as done only if all its elements are complete. No specific graphs are generated for this tool. Change Audit Example


Here are a few pointers regarding this analysis:
  • If you want to advance the phase of the Change Audit since a particular element does not apply to your scenario, you can still mark the phase as completed. However, make sure that this does not apply.


For more information on this topic, please refer to the following articles. Do note that if any external links are mentioned below, they are for reference purposes only.