Cbap Application Worksheet - Excel

Document Sample
Cbap Application Worksheet - Excel Powered By Docstoc
					                                                             CBAP Application Worksheet
                                                                                                                 ver. 2.0
                                                                                         Developed by Watermark Learning
                INSTRUCTIONS                                                                www.WatermarkLearning.com
                                                                                                            800-646-9362
                                                                        Thanks to Linda Miller, CBAP, PMP for her help on this form
                NOTE: This Excel spreadsheet assumes an average level of Excel expertise to use.

WORKBOOK: How to use this spreadsheet:
Summary   Complete the Summary section and list and number each project you worked on.
          The number will help in cross-referencing to the other worksheet.
          Copy additional rows for each project you report on.
                Project Hours Section
                 · You can look back over 10 years, and need 7500 hours of BA work on those projects.
                 · For each project, list the total hours you spent on the project, and total non-BA hours you worked.
                 · For example, if you worked 1000 hours on a project, and did 50 hours of PM-related work, and
                   50 hours of QA work, you would list 1000 in the "Total Hours on Project" and 100 hours for
                   "Non-BA Hours on Project." The worksheet will calculate 900 hours for "BA Activity Hours."
                 · The worksheet will total the hours for you. Be sure to blank out the example hours.

                Activities by KA Section - Hours
                 · For each project, list the hours you spent on each Knowledge Area for the BA activities you performed.
                 · Check the total on the bottom to make sure you have 900+ hours in at least 4 of the 6 KAs.
                 · You do not need hours in 4 KAs for every project, but you will need the 900+ hours in at least 4 KAs
                   among all your projects. You need to have 900+ hours in at least 4 of the KAs to qualify.

                Activities by KA Section - Percentages
                 · For each project, the percentages spent on each Knowledge Area for the BA activities of a project
                   will be calculated. The percentages should total 100% for each project.
                 · The worksheet will total the KAs, so you will know when you have reached 100%.
                 · You do not need 4 KAs per project, but you will need experience in at least 4 KAs among all your projects.

Projects        For each project, list the information asked for. The online CBAP application requests all this information.
                 · If any data is optional, it is listed as "Opt." on the worksheet. If a contact has left the organization,
                   and you don’t have a replacement contact name, we recommend listing a generic phone number and
                   email address for the organization. IIBA will use this to reach your contacts if the audit your application.
                 · Expand the column widths as needed to add your data. Insert additional rows as needed.

NOTE            Pass this template on to friends and colleagues who want to apply for the CBAP credential.
                As a courtesy, please leave our name and contact information on this worksheet.
                Contact us at 800-646-9362 for additional copies or more information on CBAP Certification Preparation.
                Or, visit www.WatermarkLearning.com/CBAP for more information, including tips to help you
                prepare for the CBAP exam.

Developed by: Watermark Learning                                          800-646-9362                                                Page 1
                                                               CBAP Application Worksheet


    OVERVIEW                                                                                 (BA hours are
                                                                                             calculated- don't
                                                                                             enter any                            Activities by KA
                                                                                             values)                 (Total BA Hours. Need 900+ in 4 or more KAs)

                                                                Total Hours    Non-BA Hours BA Activity                                                              TOTAL
Nbr Project Name                                          Dates on Project     on Project   Hours         BAPM         RE       RC       EA       RA       SAV       (Calculated)
                                           Example:   2/1/2008-             20            2            18     5             2        4        4        3                      18
                                                       2/5/2008
   1 AAAAAA                                                                                             0
   2 BBBBB                                                                                                  0
   3 CCCCC                                                                                                  0
   4 DDDDD                                                                                                  0
    TOTAL                                              N/A               20              2                18     5          2        4        4        3         0            18
    (Recommend BA hours be 9000 or more)




  Developed by: Watermark Learning                                                                                                                                          Page 2
                                                              CBAP Application Worksheet



              Activities by KA
 (Percentage of Total BA Hours; will be calculated-
              don’t enter any values)



BAPM RE         RC     EA     RA SAV TOT              Notes
 28% 11% 22% 22% 17%                         100%

                                                 0%
                                                 0%
                                                 0%
                                                 0%
N/A     N/A    N/A     N/A    N/A    N/A      N/A




  Developed by: Watermark Learning                                                         Page 3
                                                                CBAP Application Worksheet


Project Listing - Note all fields required unless marked (Opt)

                      Project Information                                                       Nbr         Project Contact
                                                                                                Reporting
                                                                                                to You                                Relationship
Nbr Project Name      Start Date   End Date   Project Description/Objective   Project Role(s)   (Opt)       Name      Email   Phone   to Contact
   1 AAAAAA


   2 BBBBB


   3 CCCCC


   4 DDDDD




Developed by: Watermark Learning                                                                                                                     Page 4
                                                            CBAP Application Worksheet



                                                              Hours on        Description of
Organization Information                                      Project         BA Activities
                            Organization Address,
Organization                City State, Zip,      Organization (see Summary   (see Summary
Name             Industry   Country               Website (Opt) worksheet)    worksheet)
                                                                      xxx            xxx


                                                                     xxx            xxx


                                                                     xxx            xxx


                                                                     xxx            xxx




Developed by: Watermark Learning                                                               Page 5

				
DOCUMENT INFO
Description: Cbap Application Worksheet document sample