Sheet 1: Start

	
	
	

		


		
CBAP Application Template
	
	

		


		


	
	

		


		


	
	

		
Who
		
This template, in its original format can be used by BAs applying for CBAP certification. With a few modifications, CCBA applicants  can leverage this template as well.
	
	

		
What
		
This template will help you structure your work experience,  details associated with your past and current projects, list of questions that may occur during the application process and a live To Do list , that you can use while working on your CBAP application.
	
	

		
How
		
There are 5 main sheets in this template. 1) Projects - To list of all your relevant projects and the associated details required for the application. 2) Project Tasks - To record hours spent on each BA task/activity in the six knowledge areas of BABOK. 3) Org Info - To collect logistics related to the organization and the projects. 4) To do List - To keep the application process on track.
	
	

		


		


	
	

		


		


	
	

		


		
Suggested Steps
	
	

		


		
1. In the Projects worksheet, list down the names of all the organizations where you performed the role of a BA.
	
	

		


		
2. Enter the Start Date and End Date for your work at each of the organizations.
	
	

		


		
3. Enter the Project names.
	
	

		


		
4. Enter Project Start date and End date
	
	

		


		
5. In the '# of Weeks' field, calculate and enter the weeks worked for each organization and for each project. If you worked on mulitple projects at the same time, allocate hours accordingly.
	
	

		


		
6. In the '# of Total Hours' , enter total hours worked for each project. 
	
	

		


		
7. Enter approximate hours spent on BA tasks for those projects in the '#BA Hours' field
	
	

		


		
8. Enter the Project Contact names.
	
	

		


		
9. While doing steps 1 to 8, enter any project details, BA activities, questions, pending action items that come to your mind.
	
	

		


		
10. In the 'Project Tasks', start marking the BA activities performed in each knowledge area and allocate percentages.
	
	

		


		
11. In the ' Project Tasks', enter BA hours for each of the projects. Use the number you calculated in the Projects worksheet.
	
	

		


		
12. The template will calculate your Total BA hours and the total hours spent in each Knowledge Area.
	
	

		


		
13. In the 'Org Info' sheet enter the information related to the orgnization where you performed the projects and the details about the project.
	
	

		


		
14. Review all the information entered. Ensure there are no conflicting totals or dates.
	
	

		


		
15. Log on to IIBA website and start replicating this information in your CBAP application. Good luck!
	
	

		


		


	
	

		


		


	
	

		


		
Please Note: This template contains formula fields for a few projects only. If you are adding more projects, please ensure the calculations get applied to the new cells.
	



Sheet 2: Projects

	
	
	
	
	
	
	
	
	
	

		
How to use this: Start by entering Organization names and Project Names and then enter dates and hours.
		

		At the organization level, the start date and the end date will provide the length of your work period at the organization. This is not directly reported in the IIBA app, but gives you an idea of the time bucket from which you can further determine how many hours you spent on each project. 

		Start Date
		
End Date
		

		This is a manual calculation. It will be helpful in determing your total hours worked at the organization .

		# Weeks Worked
		

		The # of Total Hours are determined by the # Weeks worked * 40 hrs. However, if you have worked on multiple projects in the same time frame, this formula would be not be applicable.

		# of Total Hours
		

		Use this column to account for Business Analysis  related projects out of the # of Total Hours bucket. This field will be a summation of the # BA Hours you assign to each project. 
		# BA Hours
		

		Left empty on purpose
		

		

		Use this field to note down any details that come to your mind regarding the project and the BA activities that you performed.Later on, you can enter this information more systematically in the Project Tasks worksheet. This is just to capture your thoughts.
		Project details
		

		Use this field to note down which knowledge area you spent most of your time in for this particular project. Again, this is just an optional field to let you capture your chain of thoughts.
		BABOK
		

	Note down the name of the PM or the Project Contact associated with this project. This is the time to ask for their permission to use them as  references. 


IMPORTANT
 --If PM is one of your references, ensure that they note that in the reference form for IIBA---
	PM
	
	

		
Organization A
		
1-Sep-05
		
28-Feb-07
		
77
		
3080
		
3080
		


		


		


		


	
	

		

		5-Aug-11
		Project 1
		
1-Sep-05
		
30-Dec-05
		
17
		
680
		
680
		


		


		


		


	
	

		
Project 2
		
2-Jan-06
		
28-Feb-07
		
60
		
2400
		
2400
		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		
Organization B
		
2-May-07
		
1-Sep-09
		
121
		
4840
		
2000
		


		


		


		


	
	

		
Project 3
		
2-May-07
		
1-Sep-09
		
121
		
4840
		
2000
		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		
Organization C
		
29-Oct-10
		
18-Apr-11
		
24
		
960
		
900
		


		


		


		


	
	

		
Project 4
		
29-Oct-10
		
18-Apr-11
		
24
		
960
		
900
		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		
Organization D
		
19-Apr-11
		
1-Aug-11
		
15
		
600
		
600
		


		


		


		


	
	

		
Project 5
		
19-Apr-11
		
1-Aug-11
		
15
		
600
		
600
		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		
Organization E
		
5-Aug-11
		
Till Date
		
68
		
2720
		
2720
		


		


		


		


	
	

		
Project 6
		
5-Aug-11
		
10-Jan-12
		
22
		
880
		
880
		


		


		


		


	
	

		
Project 7
		
11-Jan-12
		
30-Nov-12
		
46
		
1840
		
1840
		


		


		


		


	



Sheet 3: Project Tasks

	
	
	
	
	
	
	
	
	
	
	

		
How to use this: Start putting '1'  in KA tasks, for each activity done for each of the projects. Enter the Total hours and the % time in each KA  to get the calculated BA hours per KA per project. Add columns as required.
		
While filling out this portion, please be aware that some of these tasks such as creating test cases, design documents, writing meeting minutes, which are the tasks performed by QA, PM or a Technical analyst,  will not be counted towards your BA hours. 
		
Project 1
		
Project 2
		
Project 3
		
Project 4
		
Project 5
		
Project 6
		
Project 7
		

		Important Requirement - IIBA requires the applicant to have 900 hours in 4 out 6 knowledge areas.
		Total KA Hours
		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		

		Copy these hours from the Projects worksheet.
		Total BA  Hours
		


		
680
		
2400
		
2000
		
900
		
600
		
880
		
1840
		


		
9300
		
Total BA Hours (should be at least 7500 hours)
	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Business Analysis Planning & Monitoring:
		
Enter the percentage of time spent in this KA
		
40
		
27
		
24
		
24
		
21
		
30
		
17
		


		


		


	
	

		


		
Calculated BA hours in this KA
		
272
		
648
		
480
		
216
		
126
		
264
		
313
		
2319
		
Total KA Hours (should be at least 900 hours for 4 out of 6)
		


	
	

		


		
Planned business analysis approach
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Conducted stakeholder analysis
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Planned business analysis activities
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Estimated requirements activities (e.g., milestones, work units, level of effort, duration,)
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Planned business analysis communication
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Planned requirements management process
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Determined what requirement attributes need to be captured
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Planned, monitored and reported on business analysis performance
		
1
		
1
		


		


		
1
		
1
		
1
		


		


		


	
	

		


		
 Measured and reported on requirements activity
		
1
		
1
		


		


		
1
		
1
		
1
		


		


		


	
	

		


		
 Identified and documented project team roles and responsibilities
		


		


		
1
		
1
		


		
1
		


		


		


		


	
	

		


		
 Identified project risks
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		
 
		
 Determined SDLC approach for project
		


		


		
1
		
1
		


		
1
		


		


		


		


	
	

		
 
		
 Created the project plan
		


		


		


		


		


		
1
		
1
		


		


		


	
	

		
 
		
 Conducted resource planning
		


		


		
1
		
1
		


		
1
		


		


		


		


	
	

		
 
		
 Conducted project team meetings
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		
 
		
 Conducted BA team performance reviews
		
1
		
1
		


		


		


		


		


		


		


		


	
	

		
 
		
 Managed team of BAs (i.e. accountable for conducting regular one on one meetings, assessing individual’s ongoing skills and performance, negotiating compensation increases, determining areas for improvement and professional development needs, approving vacation time, overtime, etc.)
		


		


		


		


		


		


		


		


		


		


	
	

		
 
		
 Planned operational support activities based on business analysis deliverables
		
1
		


		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		
 
		


		


		


		


		


		


		


		


		


		


		


	
	

		
 Elicitation:     
		
Enter the percentage of time spent in this KA
		
21
		
10
		
7
		
7
		
9
		
7
		
7
		


		


		


	
	

		


		
Calculated BA hours in this KA
		
143
		
240
		
140
		
63
		
54
		
62
		
129
		
830
		


		


	
	

		


		
 Prepared for requirements elicitation
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Conducted elicitation activities
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Facilitated requirements workshop
		


		
1
		


		


		
1
		


		
1
		


		


		


	
	

		


		
 Documented the results of elicitation activities
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Validated elicitation results
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Requirements Management & Communication:
		
Enter the percentage of time spent in this KA
		
18
		
20
		
18
		
18
		
21
		
25
		
17
		


		


		


	
	

		


		
Calculated BA hours in this KA
		
122
		
480
		
360
		
162
		
126
		
220
		
313
		
1783
		


		


	
	

		


		
Managed solution and requirements scope (e.g., baseline, structure, impacts, change management and approval process)
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Obtained sign-off
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Managed requirements change
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Managed and resolved requirements conflicts
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Established requirements baseline
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Structured requirements for traceability
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Determined appropriate format to present requirements
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Created a requirements package
		


		


		


		


		
1
		
1
		
1
		


		


		


	
	

		


		
 Conducted a presentation of the requirements to stakeholders
		


		


		


		


		
1
		
1
		
1
		


		


		


	
	

		


		
 Communicated requirements
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Adjusted project scope based on changes to requirements
		


		


		
1
		
1
		


		
1
		
1
		


		


		


	
	

		


		
 Conducted design walkthroughs
		


		


		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
Prepared and conducted project progress presentation for senior management
		
1
		
1
		


		


		
1
		
1
		
1
		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Ent Analysis
		
Enter the percentage of time spent in this KA
		
21
		
7
		
18
		
18
		
12
		
7
		
14
		


		


		


	
	

		


		
Calculated BA hours in this KA
		
143
		
168
		
360
		
162
		
72
		
62
		
258
		
1224
		


		


	
	

		


		
 Define the business needs
		
1
		


		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Identify business problem or opportunity
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Determined gap(s) in capabilities to meet the business needs
		
1
		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Determined solution approach
		


		


		
1
		
1
		
1
		


		
1
		


		


		


	
	

		


		
 Conducted feasibility studies for solution options
		


		


		
1
		
1
		
1
		


		
1
		


		


		


	
	

		


		
 Identified potential high level solutions
		


		


		
1
		
1
		
1
		


		
1
		


		


		


	
	

		


		
 Defined solution scope
		
1
		


		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Developed a business case
		
1
		


		
1
		
1
		


		


		
1
		


		


		


	
	

		


		
 Documented system/application architecture
		


		


		


		


		


		


		


		


		


		


	
	

		


		
 Determined project scope
		
1
		


		
1
		
1
		


		


		
1
		


		


		


	
	

		


		
 Selected and prioritized projects
		


		
1
		


		


		


		


		
1
		


		


		


	
	

		


		
 Launched a new project
		


		


		
1
		
1
		


		


		
1
		


		


		


	
	

		


		
 Created the project charter
		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Requirements Analysis:   
		
Enter the percentage of time spent in this KA
		


		
20
		
16
		
16
		
21
		
25
		
21
		


		


		


	
	

		


		
Calculated BA hours in this KA
		
0
		
480
		
320
		
144
		
126
		
220
		
386
		
1676
		


		


	
	

		


		
 Determined priority and relative importance of requirements
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Organized requirements so that they are understood by all stakeholders
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Documented dependencies and interrelationships between requirements
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Specified and modeled requirements
		


		


		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Created and documented as-is models
		


		


		


		


		
1
		
1
		
1
		


		


		


	
	

		


		
 Determined requirement assumptions and constraints
		


		
1
		


		


		
1
		
1
		
1
		


		


		


	
	

		


		
 Verified requirements
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Conducted structured walkthroughs
		


		


		


		


		
1
		
1
		
1
		


		


		


	
	

		


		
 Validated requirements
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Traced requirements back to the business case
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Delivered use cases
		


		


		


		


		


		
1
		
1
		


		


		


	
	

		


		
 Determined work that needs to be done in the project based on requirements
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Evaluated risk associated with implementing certain requirements
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Created training materials
		


		


		


		


		


		


		
1
		


		


		


	
	

		


		
 Created user guides/manuals
		


		


		


		


		


		


		
1
		


		


		


	
	

		


		
 Created and documented solution design
		


		


		


		


		


		


		
1
		


		


		


	
	

		


		
 Created service level agreements
		


		


		


		


		


		


		


		


		


		


	
	

		
 
		


		


		


		


		


		


		


		


		


		


		


	
	

		
 Solution Assesssment & Validation:    
		
Enter the percentage of time spent in this KA
		


		
16
		
17
		
17
		
16
		
6
		
24
		


		


		


	
	

		


		
Calculated BA hours in this KA
		
0
		
384
		
340
		
153
		
96
		
53
		
442
		
1467
		


		


	
	

		
 
		
 Assessed business value delivered by proposed solutions
		


		


		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		
 
		
 Allocated requirements among releases and/or solution components
		


		


		
1
		
1
		
1
		


		
1
		


		


		


	
	

		


		
 Determined organizational readiness to effectively operate the new solution
		


		
1
		


		


		
1
		
1
		
1
		


		


		


	
	

		


		
 Defined transition requirements to move to the new solution
		


		
1
		
1
		
1
		
1
		
1
		
1
		


		


		


	
	

		


		
 Validated a solution
		


		
1
		
1
		
1
		
1
		


		
1
		


		


		


	
	

		


		
 Defined acceptance criteria for the solution
		


		
1
		


		


		
1
		


		
1
		


		


		


	
	

		


		
 Assessed business impact of defects and issues
		


		
1
		
1
		
1
		


		


		
1
		


		


		


	
	

		


		
  Evaluated the quality of the solution
		


		
1
		
1
		
1
		
1
		


		
1
		


		


		


	
	

		
 
		
 Identified opportunities for improvement post-implementation
		


		


		
1
		
1
		
1
		


		
1
		


		


		


	
	

		
 
		
 Created the test strategy and test plan
		


		


		


		


		


		


		
1
		


		


		


	
	

		
 
		
 Created the test cases
		


		


		


		


		


		


		
1
		


		


		


	
	

		
 
		
 Executed test cases
		


		


		


		


		


		


		
1
		


		


		


	
	

		
 
		
 Tracked and managed the defects
		


		


		


		


		


		


		
1
		


		


		


	
	

		
 
		
 Managed the quality assurance/testing process and resources
		


		


		


		


		


		


		
1
		


		


		


	
	

		
 
		
 Obtained user acceptance testing signoff
		


		


		


		


		


		


		
1
		


		


		


	
	

		
 
		
 Created the implementation plan
		


		


		
1
		
1
		


		


		
1
		


		


		


	
	

		
 
		
 Managed the solution selection committee
		


		


		


		


		


		


		
1
		


		


		


	
	

		
 
		
 Delivered training
		


		


		


		


		


		


		
1
		


		


		


	
	

		
 
		
 Evaluated technology options
		


		
1
		
1
		
1
		
1
		


		
1