@RichardBecker5 - without functional patrols there is no troop. You may want to look up the scouting program as outlined by Baden-powell. As i noted before the BSA is not exactly following the scouting program.
The patrol system is not one method in which Scouting can be carried on. It is the only method.”
—Lord Baden-Powell, Scouting’s founder
Scouting Ideals.
Patrols.
Outdoors.
Advancement.
Personal Growth.
Adult Association.
Leadership Development.
Uniform.
@JohnGunyon - if your organization is not to be questioned or criticized then it is a cult.
FYI @jwstl
2022-12-05-A
Advancement Chair for our Troop
I run a report every 4 months, which lists all the Scouts, their rank, their last rank date, their Eagle MBs.
I import this into a spreadsheet
It has logic to do some counts and dates
I flag the Scouts that have not advanced recently
I flag the older scouts who have a lot of Eagle MBs to complete prior to age 18.
I distribute a PDF to ScoutMaster, and the Committee
The SM and ASM can give extra attention to slow moving scouts, or those approaching Eagle with much to do
Attached is
1 a picture of Report Builder Query
2 a copy of the report, after importing csv data into my template
Love to hear any suggestions
Nice! That’s the same approach I was thinking of.
I’m pretty good at Excel - but would save a LOT of time if you feel like sharing your (sanitized) workbook?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
A few months back @Jwstl asked “Is there any way to track when a scout last advanced? For the purposes of making sure we are helping them make progress?”
I failed to post the actual spreadsheet, which is added here. I’m Advancement Chair
Our ~Quarterly Process
Run a report every 2-4 months, which lists all the Scouts, their rank, their last rank date, their Eagle MBs.
Import into a spreadsheet
Spreadsheet has logic to do some counts and dates
I manually flag Scouts who have not advanced recently (some discretion)
I manually flag older scouts who have many Eagle MBs to complete prior to age 18 (some discretion)
I add notes suggesting which scouts need extra attention.
I distribute a PDF to ScoutMaster, and cc the Committee
The SM and ASMs then give extra attention to slow moving scouts, or those approaching Eagle with much to do
Attached is
1 a picture of Report Builder Query
2 a copy of the report, after importing csv data into my template
3 a copy of the xls
Ranks_and_Eagle_MB_by_DOB_Tracker2023 - sanitized.xlsx (37.8 KB)
© 2019 Boy Scouts of America - All Rights Reserved
