This set of Centennial Quality Unit Award worksheets by Richard Diesslin is located on the NetCommish web site at http://usscouts.org/commish/resources.asp

 

Click HERE to get a blank copy you can use for your unit. It will help you plug in your data on each of the

Begin by entering your unit's goals  on the Training, Membership, Support, and Program "detail" worksheets.  The summary pages for each year will automatically display data you enter on the "detail" worksheets.

 

Disclaimer: Use this spreadsheet at your own risk. Every attempt has been made to ensure the proper tracking using this spreadsheet, but the developer is not liable for any results in any way.

Adult Training Goals and Actuals
           
  Total # Adult Goal Actual Goal
Year Leaders* Training % # Trained % Met
2005          
2006          
2007          
2008          
2009          
2010          
 

* = this includes any adult assisting as direct contact leaders (a.k.a. working with the scouts)

The goals set should be realistic based on the number of adults that will need training for new positions, youth protection, fast start, basic, Baloo and etc.

 Note: count each person trained during the year as "1" (even if they went to more than one training event) 

 

Unit Youth Retention and Recruitment Goals and Rates
                     
  Goal

                  Actual

Goal Attainment
Year # New Scouts % Retained Jan. 1st # Dec. 1st # # New Scouts % Retained New Retained On Time Qualify
2006                    
2007                    
2008                    
2009                    
2010                    

Note: 

Actual Jan.1st # is the total number of scouts on record at the end of the year (e.g., Jan. 1, 2007 for 2007 tracking year.)
Actual Dec. 1 # is the total number of scouts on roster (e.g., Dec. 1, 2007 roster count for 2007 tracking year.)
Actual # New Scouts is the total that joined your unit in the past year (e.g., new recruits, transfers, cross-overs)
% Retained is Jan 1st # / Dec. 1st # (can be more than 100%)
Recommendation: it is okay to be mildly ambitious, but goals should be reasonably achievable.The idea is to assist with planning, not    punish a unit for failing to meet overly aggressive goals.

 

 Must Meet all goals for this requirement

To meet the retained scout goal, the actual % retained should equal or exceed the goal.

To meet the new scout goal, the actual number of new scouts should equal or exceed the goal

Also, the re-charter must be turned in on time to get credit for this requirement (hence the "On Time" check box).

 

Example:                  
  Goal Actual Goal Attainment
Year # New Scouts % Retained Jan. 1st  # Dec.1st  # # New Scouts % Retained New Retained On Time Qualify
2006     40 30 10 75.0%        
2007 5 70.0% 50 40 8 80.0% Yes Yes x Yes
2008 5 75.0% 43 40 3 93.0% No Yes x No
2009 5 80.0% 45 35 15 77.8% Yes No x No
2010 5 80.0% 55 60 8 109.1% Yes Yes x Yes
                     

 

Adult Recruitment Goals  
         
  Goal Actual Goal  
Year # New Adults # New Adults* Met  
2005        
2006        
2007        
2008        
2009        
2010        
    *=This includes transfers and multiples

 

Rank Advancement Goals and Rates  
                 
  Goal* Actual Goal Attainment*
Year % Advanced # of Scouts # Advancements % Advanced Advancement or 10% Improvement Qualify
2005                
2006                
2007 60%         or    
2008 60%         or    
2009 60%         or    
2010 60%         or    
  * This goal is set by national. 
   Note: A scout advancing 2 ranks in one year counts as 2, etc. 
                 Note: An Eagle palm counts as a rank advancement

 

Example:              
  Goal* Actual Goal Attainment*
Year % Advanced # of Scouts # Advancements % Advanced Advancement or 10% Improvement Qualify
2005                
2006   40 30 75.0%        
2007 60% 50 35 70.0% Yes or No Yes
2008 60% 43 40 93.0% Yes or Yes Yes
2009 60% 45 20 44.4% No or No No
2010 60% 55 30 54.5% No or Yes Yes

 

 

Participation 
                 
  # of Outdoor Event or Monthly Activity   Goal Attainment
Year Scouts # Participating Annual % Goal* 70% P or 10% I Qualify
2006                
2007       70%   or    
2008       70%   or    
2009       70%   or    
2010       70%   or    
 

# of scouts =  the number of scouts at the end of the year (from membership worksheet)

# Participating = count "1" for each scout that has had an outdoor experience or participated in a monthly activity (no repeats)

        These goals are set by National

                 
Further explanation:

At least 70 percent of the youth members had at least one "outdoor experience" (during the calendar year) or one "activity" per month, or the unit improves participation by 10% or more over the previous year.

 

Each unit establishes a goal at the beginning of the year on the number of outdoor events or other activities planned. (Pack meetings can count as one activity per month. Packs are also encouraged to conduct or attend outdoor camping events periodically during the year.) Crews/Ships/Troops/Teams do not count their regular meetings and patrol meetings as outdoor events or activities.

 

Example                
  # of Outdoor Event or Monthly Activity   Goal Attainment
Year Scouts # Participating Annual % Goal* 70% P or 10% I Qualify
2006 40 30 75.0%          
2007 50 35 70.0% 70% Yes or No Yes
2008 43 25 58.1% 70% No or No No
2009 45 30 66.7% 70% No or Yes Yes
2010 55 50 90.9% 70% Yes or Yes Yes