You can download my CIA exam study planner, for Gleim and Hock review courses.
This study planner is an excel spreadsheet that helps you to:
- Calculate the number of studying hours per week
- Estimate the time required to prepare for the exam, based on the number of studying hours and any vacation days you may have identified
- Specify the start and end dates of each study unit. You can then monitor your progress in the calendar
This Video Shows How My CIA Exam Study Planner Works
The spreadsheet is pretty much self-explanatory, but just to make sure, I made this screen capture to walk you through. This video was originally made for the CMA exam planner but the format is exactly the same.
This file contains worksheets for Part 1, Part 2 and Part 3, and it could be automatically downloaded to your computer after clicking. Please check your desktop or download folder:
(Hock CIA study planner will be available shortly)
For those who have slower internet connection, you might want to refer to this instruction in text format.
The image below shows how the CIA exam study planner looks like once you open the excel sheet.
This is the master page where you can enter all the inputs:
1. Weekly Schedule
The area shaded in yellow is the weekly schedule area. You can mark off with an “x” for time allocated to your CIA exam study. The default spreadsheet starts the day from 5am and ends at mid-night, but you can always insert more rows for further customization.
2. Days off
Realistically you will have some days off. For the scheduled ones, such as wedding days and a long weekend off, you can mark them off in this column and the spreadsheet will excludes these dates from the calculation.
3. Basic Study Mode
You need to input a start date (please pick a Monday otherwise the spreadsheet won’t work). Other than that, it’s all auto-calculation. It shows you
I am showing you a screenshot of the first page of this CIA exam study planner. The area highlighted in yellow is the input area. In other words, don’t type outside the yellow boxes or you may alter the formulas and affect the calculations.
You will see, from the bold text, the number of studying hours for your chosen exam part (There are 3 tabs indicating each part of the exam). For example, the worksheet above shows that 61 hours are required, which translate to 38 days, 5 weeks, and 1.2 months.
4. Comprehensive Study Mode
What’s special about our CIA exam study planner is that we’ve got 2 scenarios. To me, to ensure passing the CIA exam on your first try, you need to use this comprehensive mode.
The basic mode (for Gleim , for example) assumes that you go through the entire Gleim CIA Review System. This requires students to go through 20 multiple choice questions in each study session.
For comprehensive mode, you’ve got to work on the above, plus ALL the practice questions on Gleim, together with time needed for thorough review. As you will see, it often doubles the prep time.
This study planner has been vetted by the Gleim Team. If you have questions on how it works, or how it doesn’t work (e.g. you find a bug), please let me know in the comment section below. Thanks a lot and hope this can help you in your CIA exam prep.