Information Flyer Template Free 11701 | Ba Cbap Application Worksheet V3

Partial file snippet.

Sheet 1: Instructions

CBAP/CCBA Application Worksheet

INSTRUCTIONS
ver. 3.0
Developed by Watermark Learning
www.WatermarkLearning.com
800-646-9362 n +1-952-921-0900

Overview:
This spreadsheet helps you organize your BA experience and education hours to help you complete the online CBAP or CCBA application. Most columns have comments to help you understand the needed information. When you are done, you can easily copy the formation from this spreadsheet into the IIBA application. Feel free to share this file with your colleagues and friends.

NOTE: This Excel spreadsheet assumes an average level of Excel expertise to use.

WORKBOOK:
How to use this spreadsheet:

Project Hours
The main worksheet you need to organize all your projects. If you run out of rows, simply copy/paste

more for each project you worked on.

Work History Section

Enter information for the organization whose projects you worked on as well as applicable contact information.

Work Experience Section

List project details including name. description, and start/end dates.

Knowledge Area Hours Section

Enter the percentage of total BA project time spent on each Knowledge Area. Check the comments for each

KA for short descriptions to help you know where your experience best fits.

Hours by Knowledge Area Section

The worksheet will calculate the hours for each KA by multiplying the BA project hours by the percentages you list for each KA. You can then copy the calculated hours into the "Total Hours Worked" section of the IIBA application. Makes sure you have the required minimums before you submit your application:

CBAP
· You can look back over 10 years, and need 7500 hours of BA work on those projects.

· You need 900+ hours in four or more Knowledge Areas.

CCBA
· You can look back over 7 years, and need 3750 hours of BA work on those projects.

· You need 900+ hours in two or more Knowledge Areas -OR-

500 hours in four or more KAs.

NOTE: the shaded columns such as "Calculated Duration in Months" will be calculated for you. If you enter anything into any of their cells the calculations will stop working.

Education

Complete the course information and hours for your BA training and makes sure you have the requirements

met before you submit your application:

CBAP
· You need 35 Hours of BA training in the past 4 Years

CCBA
· You need 21 Hours of BA training in the past 4 Years

NOTE
Pass this template on to friends and colleagues who want to apply for the CBAP or CCBA credentials.

As a courtesy, please leave our name and contact information on this worksheet.

Or, visit www.WatermarkLearning.com/CBAP for more information, including tips to help you

prepare for the CBAP exam.

Sheet 2: Project Hours

Work History

Work Experience Information

Enter the percentage along with or without the percent sign, such as 10 or 10%.
Knowledge Area Hours: Enter as a % of BA project time to equal 100%

Transfer these hours to the online application for each project's applicable KA. Hours must be in quarter-hour increments.
Hours by Knowledge Area

Enter the name of the organization whose project you worked on. If the organization no longer exists, state that.
Organization Name
Industry
Website
Country

List the name of a project contact that IIBA can use to verify you worked on the project. It should preferably be someone still at the organization. If there is no one, explain why.
Contact Name
Contact Email
Contact Phone

List your relationship to the contact (e.g., sponsor, customer, project manager, etc.)
Contact Relationship

List the project or initiative name. If there was no formal name, enter a brief version of the description.
Project or Initiative Name

List your role on the project, such as BA, BA-PM, etc.
Your Role

Enter the number of people reporting to you on the project. If none, enter 0.
Number Reporting to you, if any

List the project's description or its objectives.
Project Description/
Objectives

Enter the month, day, and year for the start date, as close as you can recall.
Start Date

Enter the month, day, and year for the end date, as close as you can recall.
End Date

Calculated number of months - no need to enter anything. Used to calculate the hours on the project.
Calculated Duration
in Months

Enter the percentage with or without the percent sign, such as 10 or 10%.
% of total BA time spent on project
(recommend not to exceed 80%*)

Calculated hours on the project - no need to enter anything. Used to calculate the hours by KA. Should be the same as "Total Hours All KAs" column when done.
Calculated Hours
on Project

BAPM is concerned with organizing and coordinating the business analysis work, including the efforts of the business analyst and stakeholders, throughout the initiative. It outlines the tasks that produce planning outputs, called approaches. That are used as inputs to tasks in all the other knowledge areas. It also includes tasks for assessing the business analysis work and recommending performance improvements. There are fifteen techniques associated with this KA, many of which we would expect here, such as Estimation, Functional Decomposition, and Lessons Learned. Some modeling techniques that we would expect in Elicitation and Collaboration are listed in this KA, but not in EC, such as Process Modeling, Survey or Questionnaire, and Workshops.

BA Planning and Monitoring

Requirements must be elicited from stakeholders in order to be analyzed and documented, and stakeholders need to be on board in order to effectively elicit requirements. This KA covers the process, tasks, and techniques for not only eliciting the requirements, but also collaborating with stakeholders. There are eight techniques in this KA. Some are expected for this KA, such as brainstorming and interviews. Some we might not associate with elicitation, such as estimation and data mining.
Elicitation and Collaboration

Requirements and designs are created and eventually retired, and this KA describes the tasks that are done to manage and maintain them from inception until they are no longer used. It includes ensuring that requirements relationships are aligned and maintained (a fancy way for saying ensuring that requirements are traced), assessing changes that are requested, and getting consensus on how to handle changes. There are twenty-four techniques mentioned in this KA.
Requirements Life Cycle Management

This KA describes what BAs need to do to identify strategic and tactical needs and then help the organization address those needs. In other words, it describes the current and future states, identifies gaps between the two, and suggests how to transition from the current to the future state. This transition plan is called a Change Strategy. Strategy analysis doesn’t happen just once. It recurs as changes are requested. There are twenty-six techniques mentioned in this KA.
Strategy Analysis

Considered by many to be the “core” of what a BA does, Requirements Analysis and Design Definition deals with how stakeholder requirements, identified during elicitation, are structured and organized. This KA is where business analysts specify and model both requirements and designs, validate and verify the information, identify options for the solution (for example build vs. buy), and estimate the value that each option brings to the organization.

To represent commonly accepted practices, this BABOK KA covers 10 techniques that are used not only in Requirements Analysis and Design Definition, but also in other KAs, such as the techniques used in Elicitation and Collaboration and Strategy Analysis.
Requirements Analysis & Design Definition

Once requirements have been approved, they need to be implemented to be of value. This KA is about the work needed to assess the solution’s performance (during development and after implementation) and to recommend actions required to remove barriers in the way of a solution reaching its potential value.

In other words, at any point during development or after the solution is in production, the business analyst may analyze the value of the solution, limitations to its ability to achieve value, and recommend ways to increase its value. There are fourteen techniques used in this KA, many of which are used in other KAs as well.

Solution Evaluation
Check
KA1: BA Planning and Monitoring
KA2:
Elicitation and Collaboration
KA3: Req Life Cycle Mgmt
KA4: Strategy
Analysis
KA5: Requirements Analysis
KA6: Solution Evaluation

Use as a cross-check to "Calculated Hours
on Project" column to ensure accuracy.

Total Hours
All KAs

0%
0
0
0
0
0
0

Use as a cross-check to column x to ensure accuracy.
0

0%
0
0
0
0
0
0
0

Total in Column "Calculated Hours on Project" should be the same total as in column "Total Hours All KAs"

0%
0
0
0
0
0
0
0

* 80% allows for the consideration of administrative overhead.

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions cbapccba application worksheetinstructions ver developed by watermark learningwwwwatermarklearningcom n overviewthis spreadsheet helps you organize your ba experience and education hours to help complete the online cbap or ccba most columns have comments understand needed information when are done can easily copy formation from this into iiba feel free share file with colleagues friends note excel assumes an average level of expertise use workbook how project main worksheet need all projects if run out rows simply copypaste more for each worked on work history section enter organization whose as well applicable contact list details including name description startend dates knowledge area percentage total time spent check ka short descriptions know where best fits will calculate multiplying percentages then calculated quot makes sure required minimums before submit middot look back over years those in four areas two kas shaded such duration months be anything any thei...

Related files

Share

Help

CBAP/CCBA Application Worksheet INSTRUCTIONS		ver. 3.0 Developed by Watermark Learning www.WatermarkLearning.com 800-646-9362 n +1-952-921-0900
CBAP/CCBA Application Worksheet INSTRUCTIONS

	Overview: This spreadsheet helps you organize your BA experience and education hours to help you complete the online CBAP or CCBA application. Most columns have comments to help you understand the needed information. When you are done, you can easily copy the formation from this spreadsheet into the IIBA application. Feel free to share this file with your colleagues and friends. NOTE: This Excel spreadsheet assumes an average level of Excel expertise to use.
WORKBOOK:	How to use this spreadsheet:
Project Hours	The main worksheet you need to organize all your projects. If you run out of rows, simply copy/paste
	more for each project you worked on.

	Work History Section
	Enter information for the organization whose projects you worked on as well as applicable contact information.
	Work Experience Section
	List project details including name. description, and start/end dates.
	Knowledge Area Hours Section
	Enter the percentage of total BA project time spent on each Knowledge Area. Check the comments for each
	KA for short descriptions to help you know where your experience best fits.

	Hours by Knowledge Area Section
	The worksheet will calculate the hours for each KA by multiplying the BA project hours by the percentages you list for each KA. You can then copy the calculated hours into the "Total Hours Worked" section of the IIBA application. Makes sure you have the required minimums before you submit your application:
CBAP	· You can look back over 10 years, and need 7500 hours of BA work on those projects.
	· You need 900+ hours in four or more Knowledge Areas.

CCBA	· You can look back over 7 years, and need 3750 hours of BA work on those projects.
	· You need 900+ hours in two or more Knowledge Areas -OR-
	500 hours in four or more KAs.

	NOTE: the shaded columns such as "Calculated Duration in Months" will be calculated for you. If you enter anything into any of their cells the calculations will stop working.

Education

	Complete the course information and hours for your BA training and makes sure you have the requirements
	met before you submit your application:
CBAP	· You need 35 Hours of BA training in the past 4 Years

CCBA	· You need 21 Hours of BA training in the past 4 Years



NOTE	Pass this template on to friends and colleagues who want to apply for the CBAP or CCBA credentials.
	As a courtesy, please leave our name and contact information on this worksheet.
	Contact us at +1-952-921-0900 for additional copies or more information on any IIBA Certification Preparation.
	Or, visit www.WatermarkLearning.com/CBAP for more information, including tips to help you
	prepare for the CBAP exam.

Work History								Work Experience Information									Enter the percentage along with or without the percent sign, such as 10 or 10%. Knowledge Area Hours: Enter as a % of BA project time to equal 100%							Transfer these hours to the online application for each project's applicable KA. Hours must be in quarter-hour increments. Hours by Knowledge Area
Enter the name of the organization whose project you worked on. If the organization no longer exists, state that. Organization Name	Industry	Website	Country	List the name of a project contact that IIBA can use to verify you worked on the project. It should preferably be someone still at the organization. If there is no one, explain why. Contact Name	Contact Email	Contact Phone	List your relationship to the contact (e.g., sponsor, customer, project manager, etc.) Contact Relationship	List the project or initiative name. If there was no formal name, enter a brief version of the description. Project or Initiative Name	List your role on the project, such as BA, BA-PM, etc. Your Role	Enter the number of people reporting to you on the project. If none, enter 0. Number Reporting to you, if any	List the project's description or its objectives. Project Description/ Objectives	Enter the month, day, and year for the start date, as close as you can recall. Start Date	Enter the month, day, and year for the end date, as close as you can recall. End Date	Calculated number of months - no need to enter anything. Used to calculate the hours on the project. Calculated Duration in Months	Enter the percentage with or without the percent sign, such as 10 or 10%. % of total BA time spent on project (recommend not to exceed 80%*)	Calculated hours on the project - no need to enter anything. Used to calculate the hours by KA. Should be the same as "Total Hours All KAs" column when done. Calculated Hours on Project	BAPM is concerned with organizing and coordinating the business analysis work, including the efforts of the business analyst and stakeholders, throughout the initiative. It outlines the tasks that produce planning outputs, called approaches. That are used as inputs to tasks in all the other knowledge areas. It also includes tasks for assessing the business analysis work and recommending performance improvements. There are fifteen techniques associated with this KA, many of which we would expect here, such as Estimation, Functional Decomposition, and Lessons Learned. Some modeling techniques that we would expect in Elicitation and Collaboration are listed in this KA, but not in EC, such as Process Modeling, Survey or Questionnaire, and Workshops. BA Planning and Monitoring	Requirements must be elicited from stakeholders in order to be analyzed and documented, and stakeholders need to be on board in order to effectively elicit requirements. This KA covers the process, tasks, and techniques for not only eliciting the requirements, but also collaborating with stakeholders. There are eight techniques in this KA. Some are expected for this KA, such as brainstorming and interviews. Some we might not associate with elicitation, such as estimation and data mining. Elicitation and Collaboration	Requirements and designs are created and eventually retired, and this KA describes the tasks that are done to manage and maintain them from inception until they are no longer used. It includes ensuring that requirements relationships are aligned and maintained (a fancy way for saying ensuring that requirements are traced), assessing changes that are requested, and getting consensus on how to handle changes. There are twenty-four techniques mentioned in this KA. Requirements Life Cycle Management	This KA describes what BAs need to do to identify strategic and tactical needs and then help the organization address those needs. In other words, it describes the current and future states, identifies gaps between the two, and suggests how to transition from the current to the future state. This transition plan is called a Change Strategy. Strategy analysis doesn’t happen just once. It recurs as changes are requested. There are twenty-six techniques mentioned in this KA. Strategy Analysis	Considered by many to be the “core” of what a BA does, Requirements Analysis and Design Definition deals with how stakeholder requirements, identified during elicitation, are structured and organized. This KA is where business analysts specify and model both requirements and designs, validate and verify the information, identify options for the solution (for example build vs. buy), and estimate the value that each option brings to the organization. To represent commonly accepted practices, this BABOK KA covers 10 techniques that are used not only in Requirements Analysis and Design Definition, but also in other KAs, such as the techniques used in Elicitation and Collaboration and Strategy Analysis. Requirements Analysis & Design Definition	Once requirements have been approved, they need to be implemented to be of value. This KA is about the work needed to assess the solution’s performance (during development and after implementation) and to recommend actions required to remove barriers in the way of a solution reaching its potential value. In other words, at any point during development or after the solution is in production, the business analyst may analyze the value of the solution, limitations to its ability to achieve value, and recommend ways to increase its value. There are fourteen techniques used in this KA, many of which are used in other KAs as well. Solution Evaluation	Check	KA1: BA Planning and Monitoring	KA2: Elicitation and Collaboration	KA3: Req Life Cycle Mgmt	KA4: Strategy Analysis	KA5: Requirements Analysis	KA6: Solution Evaluation	Use as a cross-check to "Calculated Hours on Project" column to ensure accuracy. Total Hours All KAs
														0		0							0%	0	0	0	0	0	0	Use as a cross-check to column x to ensure accuracy. 0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
														0		0							0%	0	0	0	0	0	0	0
										Total in Column "Calculated Hours on Project" should be the same total as in column "Total Hours All KAs"						0							0%	0	0	0	0	0	0	0

								* 80% allows for the consideration of administrative overhead.

Related files

Share

Share to social media

Help

Login Area