Girl Scout Attendance Sheet

  • Version
  • 380 Downloads
  • 16 KB File Size
  • May 17, 2019 Updated
  • 0 Number of comments
  • Yes Free
  • 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.

Girl Scout Attendance Sheet Personalize

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.

Girl Scout Attendance Sheet Colors Date Formula

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).

Girl Scout Attendance Sheet Check Mark Wingdings

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).

Girl Scout Attendance Sheet Check Mark

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

Girl Scout Attendance Sheet Colors

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

Girl Scout Attendance Sheet Numbers

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).

=COUNTIF(C7:N7,"X")

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.

Girl Scout Attendance Sheet Countif Formula

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.

Girl Scout Attendance Sheet Additional Fields

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.

How useful was this template?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry 🙁

Help us improve!

Holiday and Observance Calendar

37 KB / 104 downloads
Calendar Chart

61 KB / 92 downloads
Weekly Attendance Sheet

14 KB / 350 downloads
Training Attendance Sheet

13 KB / 392 downloads
Sunday School Attendance Sheet

27 KB / 322 downloads
Monthly Attendance Sheet

18 KB / 455 downloads
Meeting Attendance Sheet

13 KB / 442 downloads
Homeschool Attendance Sheet

16 KB / 367 downloads
View Comments
There are currently no comments.