Girl Scout Attendance Sheet

• Version
• 6'385 Downloads
• 16 KB File Size
• January 3, 2022 Updated
• 0 Number of comments
• ★★★★★

  ★★★★★
  Rating

A young lady’s experience as a Girl Scout can create some wonderful memories. The Girl Scouts organization provides a way to become part of the community, develop new skills, have lots of fun, and of course - eat cookies! However, active participation is required to advance through the ranks and get the full experience. To help troop leaders track participation, we offer a Girl Scout Attendance Sheet template, which includes attendance sheets in portrait and landscape orientation.

Template Contents

Portrait

A girl scout attendance sheet form for up to 35 scouts in portrait orientation.

Landscape

A girl scout attendance sheet form for up to 25 scouts in landscape orientation.

Using the Template

General Use

First, include a new title and enter the troop # and year at the top of the attendance sheet, as shown below. Next, enter all scout names in the “Name” column.

Tip: You can change the gray and white attendance sheet color scheme to match your girl scout troop colors. A tutorial on modifying color schemes can be found here.

Next, determine how often your scout troop will meet, and then enter the meeting dates across the top row. The dates can be entered manually, which is useful if meeting dates are inconsistent. But if your troop meets once a week on the same day, you can automate the rest of the dates by referencing the previous cell and adding 7 days. For example, set the first date manually in cell C6. Then, enter “=C6+7” into the formula bar, and copy the formula across the top row to populate the rest of the cells.

To view a how-to example, see this screen recording.

Track Attendance

Get creative! Take attendance your way. See ideas listed below.

• Mark scouts who are present with a check mark (leave blank to show absence).

Tip: To enter a checkmark use the “Wingdings 2” font and enter “P” into the cells.

• Mark scouts who are present with an “X” (leave blank to show absence).

• Use color codes to display attendance type (e.g. blue = present, red = absent)

• Use numbers to mark scouts who are present (leave blank to show absence). This method will allow you to quickly count total attendance.

Calculate Attendance Totals

Attendance totals can be calculated manually, especially since there aren’t many instances to count in the sheets provided. But to save time, attendance can be calculated automatically using a simple formula. For example, if you are using an “X” to count attendance, enter the following formula into the “Total” column (portrait worksheet).

This formula will capture any attendance marked with an “X” (for row 7) with a range of C7 to N7. Drag this formula down to automatically calculate attendance for all scouts.

To view a how-to example, see this screen recording.

Include Additional Fields

Whether you are using this attendance sheet for Girl Scouts or Boy Scouts, additional fields - such as “rank” - can be created. To create additional fields, simply insert a new column, label it, and fill out new information. In the example below, a Girl Scout rank field has been added to the original spreadsheet.

New Sheets and Historical Records

Troop leaders may need to refer to attendance history when making decisions and communicating with parents or legal guardians. To retain a copy of previous attendance sheets, simply duplicate the attendance sheet once you reach the final date (or insert columns to include more dates). Delete any old attendance records from the previous sheet and start over.

Tip: Create copies of attendance sheets before using them to avoid deleting old information.

A tutorial on duplicating worksheets can be found here.

Expand Attendance Sheet

If your troop is larger than 35 scouts, you can expand the attendance sheet to include more. Copy (Ctrl + C) the last row and “Insert Copied Cells” at the bottom of the worksheet to create more records in the same sheet. A tutorial on inserting multiple rows can be found here.

Tip: Column headings will disappear as you scroll down toward additional records. Use the “Freeze Panes” option to retain column headings. A tutorial on how to freeze panes can be found here.