Docstoc

CSCP Certification Maintenance Journal

Document Sample
CSCP Certification Maintenance Journal Powered By Docstoc
					This Excel workbook created by Jack A. Wetzel MBA, CPIM, CSCP
jwetzel@opsmath.com

OPS-MATH Spreadsheets
"Modern Teaching, Faster Learning"
http://www.opsmath.com



             Click here to go to the Instructions worksheet
                        Instructions on How to Use the Certification Maintenance Journal Spreadsheet

Line Item Instruction

           Use this workbook for your CSCP certification maintenance. There is a separate Excel workbook for the CPIM/CFPIM certification. Points earned
           for the CSCP certification may also be applied to the CPIM/CFPIM certification provided they meet the requirements stated in the CPIM/CFPIM
     1
           Certification Maintenance Bulletin. You should print this worksheet by clicking the print button on the Excel tool bar. You must complete instructions #2
           and #3 for this workbook to operate properly.
           This workbook uses a worksheet function that Excel does not normally install automatically. You will know if it is not installed if you get "#NAME?" in fields
           where you are expecting the certification due dates on the "Name & Dates" worksheet after you type in your information. If you need to install this function,
     2
           click "Tools - Add-Ins" on the Excel menu. Then check the box "Analysis TookPak" and click "OK." You may be asked for your original Excel installation
           CD. Then close Excel and re-open it. Then re-open this workbook.
           This workbook contains one simple macro on the "Point Summary" worksheet that must be used to trigger an update of the table on that worksheet.
           Therefore, you must enable macros in your Excel security settings to make it work. To change your macro security settings type "macro security" into Excel
     3
           Help and follow the instructions. Since macros could be written to contain viruses and other malicious software, you should always protect yourself by using
           the most current anti-virus software.
           The yellow tabs on the sheets of this workbook indicate user input is required on that sheet. Go to the "Name & Dates" worksheet and input the data into
     4
           the yellow shaded fields. Once completed, you will only need to update the "Name & Dates" worksheet each time you maintain your certification.
           Go to the "Journal" worksheet and input the data in the yellow shaded fields. You must input data into the "Year", Specific Activity", and "Points
     5
           Claimed" columns for the "Point Summary" worksheet to calculate properly.
           You may sort your entries on the "Journal" worksheet but the automatic sort buttons on the Excel tool bar won't work because the worksheet is protected
           with a password. To sort your data on the "Journal" worksheet, click on cell A8 and drag your mouse to cell D8. Continue dragging downward until you
     6
           reach the end of your data. Release the mouse button and select "Data - Sort" from the Excel menu. Then click the "No header row" radio button and select
           your sort options before clicking "OK".
           To print the "Journal" worksheet you will have to adjust the print range to include all of your data. Place your cursor on cell A8 and drag to cell D8. Continue
     7     dragging downward to include all of your data and then release your mouse button. Then click "File - Print Area - Set Print Area" from the Excel menu. Then
           click then print button in the Excel tool bar. The print headers and footers are already setup for you.
           Each time you enter data on the "Journal" worksheet, it will be out of sync with the "Point Summary" worksheet because the update must be triggered
           manually. You will see a prominent error message at the top of "Point Summary" worksheet whenever the point totals from these two worksheets are out of
           sync. You must click the "Click to Update Totals from Journal worksheet" macro button anytime you change the data on the "Journal" worksheet in order for
     8
           them to be in sync. This error message only works on point totals, so if you change a Year or Specific Activity, the error message will not be triggered.
           Clicking the macro button needs to be done after any update. As noted in Line Item 5 above, if you have not entered data into all three columns, the table
           on the "Point Summary" worksheet will not be what you expect.
           The best way to use this log is to record each individual activity and a detailed remark soon after you complete a certification maintenance activity. This is
           because these things are easy to forget. For example, if you go to 6 PDM's during a year, you should have 6 entries. The detailed remark could include the
     9
           date, name of the speaker, and the title of the presentation or program. As a minimum, you should update this workbook every three months to insure you
           don't forget to capture all of your points.




This workbook created without data by Jack Wetzel (president@topviewconsulting.com). The user input the data.                                                  Page 2 of 26
                         Instructions on How to Use the Certification Maintenance Journal Spreadsheet

           If you have any questions regarding what you can claim as points, please refer to the latest revision of the Certification Maintenance Bulletin and the APICS
    10
           website at http://www.apics.org. For questions in this area, please contact APICS at 800-444-2742 or certmain@apicshq.org or service@apicshq.org.

    11     A printout of the "Point Summary" and "Journal" worksheets can be attached to your Certification Maintenance Application.

           Once you have turned in your points for maintenance, save the file with a different file name to retain your history. Start a new file for the new certification
    12
           maintenance period.

           Certification maintenance points may change over time and this workbook may not be up to date. The most current Certification Maintenance Bulletin
    13
           (CMB) is the definitive source for determining points. The user is responsible to make sure this workbook accurately represents the most current CMB.

    14     This workbook is up-to-date to the CSCP Certification Maintenance Bulletin (CMB) version 8/09, which can be found on the back page of the CMB.

           Although great care has been taken to accurately calculate and categorized your points according to the CMB, errors are always a possibility. The creator
    15     of this workbook assumes no responsibility for errors of any kind. The user assumes all risk. It is the users responsibility to make sure the points on the
           "Point Summary" worksheet accurately reflect the points on the "Journal" worksheet and that it accurately reflects the current CMB.

           It is highly recommended that you check the revision date of this workbook to the file you are using. You may download the latest version from
    16
           http://www.opsmath.com. The latest revision date of this workbook is indicated in line item 18 below.

           If a newer version of this workbook is available and you want to use it (highly recommended) simply copy/paste your detailed data from your old workbook
    17     to the new one. However, to take advantage of any new formatting done on the new version, you should use the "paste-special" option and activate the
           "Values" radio button and then click "OK." This copies only the values to the new workbook and not the formatting.
    18     The revision date of this workbook is December 28, 2009.




This workbook created without data by Jack Wetzel (president@topviewconsulting.com). The user input the data.                                                     Page 3 of 26
                    Name:
                                                               There is a separate Excel workbook for the
           Certification(s): CSCP
                                                               maintenance of the CPIM/CFPIM certification
Original Certification Date:

    APICS Customer ID #:
The dates below never change even if you maintain late. For example if you maintain 1 year late you
will have to maintain again in 4 years.
Maintenance Due Date cycles for the next 7 cycles (35 years). You can apply for lifetime certification
at 62 years of age.
                            Maintained (Yes or No pull-down
        Due Dates                        menu)                 Next Cert Date
        1/31/2003                         No
        1/31/2008                         No
        1/31/2013                         No
        1/31/2018                         No
        1/31/2023                         No
        1/31/2028                         No
        1/31/2033                         No




             Do these columns show "#NAME?" If so, go to the
             "Instructions" worksheet and follow #2.
workbook for the
CFPIM certification
   Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                          Page 6 of 26

Note: the Year, Specific Activity, and Points Claimed columns are mandatory. Refer to Instruction #5. Print and submit this journal wi
certification maintenance application.

                                                      Name & ID #:
                                                      Certification:   CSCP
                                        Original Certification Date:
                               Next Certification Maintenance Date:

                                                                                                 Points
      Year         Specific Activity                                   Detailed Remarks         Claimed   X Activity Code
Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                     Page 7 of 26



                                                   Name & ID #:
                                                   Certification:   CSCP
                                     Original Certification Date:
                            Next Certification Maintenance Date:

                                                                                         Points
   Year         Specific Activity                                   Detailed Remarks    Claimed   X Activity Code
Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                     Page 8 of 26



                                                   Name & ID #:
                                                   Certification:   CSCP
                                     Original Certification Date:
                            Next Certification Maintenance Date:

                                                                                         Points
   Year         Specific Activity                                   Detailed Remarks    Claimed   X Activity Code
Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                     Page 9 of 26



                                                   Name & ID #:
                                                   Certification:   CSCP
                                     Original Certification Date:
                            Next Certification Maintenance Date:

                                                                                         Points
   Year         Specific Activity                                   Detailed Remarks    Claimed   X Activity Code
Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                    Page 10 of 26



                                                   Name & ID #:
                                                   Certification:   CSCP
                                     Original Certification Date:
                            Next Certification Maintenance Date:

                                                                                         Points
   Year         Specific Activity                                   Detailed Remarks    Claimed   X Activity Code
Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                    Page 11 of 26



                                                   Name & ID #:
                                                   Certification:   CSCP
                                     Original Certification Date:
                            Next Certification Maintenance Date:

                                                                                         Points
   Year         Specific Activity                                   Detailed Remarks    Claimed   X Activity Code
Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                    Page 12 of 26



                                                   Name & ID #:
                                                   Certification:   CSCP
                                     Original Certification Date:
                            Next Certification Maintenance Date:

                                                                                         Points
   Year         Specific Activity                                   Detailed Remarks    Claimed   X Activity Code
Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                    Page 13 of 26



                                                   Name & ID #:
                                                   Certification:   CSCP
                                     Original Certification Date:
                            Next Certification Maintenance Date:

                                                                                         Points
   Year         Specific Activity                                   Detailed Remarks    Claimed   X Activity Code
Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                    Page 14 of 26



                                                   Name & ID #:
                                                   Certification:   CSCP
                                     Original Certification Date:
                            Next Certification Maintenance Date:

                                                                                         Points
   Year         Specific Activity                                   Detailed Remarks    Claimed   X Activity Code
   Date Printed: 2/26/2012              APICS Certification Maintenance Journal - Detail                    Page 15 of 26



                                                      Name & ID #:
                                                      Certification:   CSCP
                                        Original Certification Date:
                               Next Certification Maintenance Date:

                                                                                            Points
      Year         Specific Activity                                   Detailed Remarks    Claimed   X Activity Code




THE DATA INPUT AREA ENDS HERE. START A NEW FILE
          Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail                                                    Page 16 of 26

ubmit this journal with your




                                                                         Complete List of Activities

                                                                                            Activity
      Point value for this activity   Specific Activity                                      Code      Point Value
                                                                                                       1 point per hour. 24 points for full
                                      APICS International Conference and Exposition           CE       registration and attendance

                                      APICS Membership                                        PM       6 points per year (.5 per month)

                                      Certification item-writing workshop                     CE       1 point for full hour of instruction*
                                                                                                       3 points per authorized CEU
                                      CEU (continuing education unit) course                  CE       point

                                      Chapter/District -- Chair of a standing committee      SSCP      2 points per year of service

                                      Chapter/District -- Member of a governing board        SSCP      2 points per year of service

                                      Chapter/District -- Member of a standing committee     SSCP      1 point per year of service

                                      Chapter/District -- Officer of a governing board       SSCP      3 points per year of service

                                      Conference, seminar, workshop, or APICS Webinar         CE       1 point for full hour of instruction*

                                      Course offered by degree granting institution           CE       1 point for full hour of instruction*

                                      CPIM or CIRM certification exam                         CE       10 points per exam passed

                                      CPIM or CIRM certification review course                CE       1 point for full hour of instruction*
                                                                                                       30 points for earning a certificate
                                      CSCP Learning System                                    CE       of completion

                                      District meeting with an educational component          CE       1 point for full hour of instruction*

                                      Educational plant tour                                  CE       1 point for full hour of instruction*
    Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail                                                        Page 17 of 26




                                                                    Complete List of Activities

                                                                                          Activity
Point value for this activity   Specific Activity                                          Code      Point Value

                                Independent-study program (college course)                  CE       3 credits = 48 points

                                Independent-study program (home study)                      CE       3 points per course completed
                                                                                                     2 points per full hour of
                                Instruction                                               PPED       instruction**
                                Membership in other professional organization related
                                directly to operations management                           PM       1 point per year

                                National/International -- Chair of a standing committee   SSCP       4 points per year of service

                                National/International -- Member of a governing board     SSCP       4 points per year of service
                                National/International -- Member of a standing
                                committee                                                 SSCP       2 points per year of service

                                National/International -- Officer of a governing board    SSCP       5 points per year of service
                                                                                                     2 points per full hour of
                                Presentation                                              PPED       presentation**

                                Professional development program                            CE       1 point for full hour of instruction*
                                                                                                     2 points per article or
                                Published article or contribution                         PPED       contribution***

                                Published book                                            PPED       30 points per book***

                                Published original research                               PPED       5 points per publication***

                                Training program                                            CE       1 point for full hour of instruction*
    Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail                             Page 18 of 26




                                                                   Complete List of Activities

                                                                                         Activity
Point value for this activity   Specific Activity                                         Code      Point Value

                                * Half-hour increments are accepted for .5 point.

                                ** Half-hour increments are accepted for 1 point.
                                *** An additional 10 points are awarded if published
                                material is cited as an APICS certification reference.
    Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail              Page 19 of 26




                                                       Complete List of Activities

                                                                          Activity
Point value for this activity   Specific Activity                          Code      Point Value
    Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail              Page 20 of 26




                                                       Complete List of Activities

                                                                          Activity
Point value for this activity   Specific Activity                          Code      Point Value
    Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail              Page 21 of 26




                                                       Complete List of Activities

                                                                          Activity
Point value for this activity   Specific Activity                          Code      Point Value
    Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail              Page 22 of 26




                                                       Complete List of Activities

                                                                          Activity
Point value for this activity   Specific Activity                          Code      Point Value
    Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail              Page 23 of 26




                                                       Complete List of Activities

                                                                          Activity
Point value for this activity   Specific Activity                          Code      Point Value
    Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail              Page 24 of 26




                                                       Complete List of Activities

                                                                          Activity
Point value for this activity   Specific Activity                          Code      Point Value
    Date Printed: 2/26/2012          APICS Certification Maintenance Journal - Detail              Page 25 of 26




                                                       Complete List of Activities

                                                                          Activity
Point value for this activity   Specific Activity                          Code      Point Value
       Date Printed: 2/26/2012                                                      APICS Certification Maintenance Journal - Summary   Page 26 of 26




                              This macro button will only work if you have enabled macros in
                              your Excel security settings. Go to the "Instructions" worksheet
                              and follow #3.




   Name & ID #:                                                     Original Certification Date:
    Certification: CSCP                                   Next Certification Maintenance Date:

                  Sum of Points Claimed      Year
                                              Grand
Activity Code     Specific Activity           Total
                               Grand Total




The maximum points allowed for PPED is 60 for CPIM and 80 for CFPIM. Also, PPED can be a maximum of 80% of the total
points claimed. The total PPED points shown inside the box below are capped at these levels so it may not agree with the
summary above. A warning message will appear in the box below if the 80% maximum is exceeded.



                                                          Total Points Claimed for Certification Maintenance
                                      CE          0.0
                                    PPED          0.0
                                    SSCP          0.0
                                      PM          0.0
                                    Total:        0.0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:2/26/2012
language:
pages:26