Cool Roster Spreadsheet System

Coach Roster Management

While looking around web to see what tools are out there with regards to "positive charting", I found this page by accident. I checked out the "lineup" tab where this particular spreadsheet has some automation. All you need to do is to initial list the names of players in the "Master List". The next step is for you to choose the positions. The spreadsheet will then auto list the positions in a 4-4-2 formation by AYSO quarter breaks.

Here is the link:
http://www.vertex42.com/ExcelTemplates/soccer-roster-template.html

Game Card Management

Game Card Management
All coaches are required to complete game cards for each game.

Game Card in Coach Packet
When you opened your coach packet from the Uniform Distribution, you will notice game cards in the envelope. Game cards are used to help track your players on and off the field during the game.

If you need more game cards, please stop by the AYSO Staff Picnic Table at the Peterson Park South Fields (near the field house) on Saturdays from 9am-1pm.

Pre-Fill Game Cards
My recommendation is to pre-fill 2 game cards before Saturday (Game Day). The card should list all players on your entire team roster. You should fill out a few cards at a time.

I would also keep a second roster cards during the game and here is why:

• The referee will ask for a card at the start of the game.
• Keeping an extra copy of the game card will help you remember who played in and out for this week based on rotation for the next week. This will help you work the rotation of players between different positions.
• We have some AYSO coaches that have great player rotation systems that they have used on their own. I welcome any coach to offer their system of rotation to new coaches! Please email me. We can use you as a great example ;-)
• Your second copy will be used to guide you keeping track of players play from week to week.
• During the game, ask your Assistant Coach or Team Parent to help keep track of players on the secondary sheet.
• If a referee did not take your game card, please bring the game card to the AYSO Picnic Table at the Peterson Park South Fields (next to the field house) anytime on Saturday Game Day. (or) bring these to the Coach Admin Meetings.

Game Card Sheet Online
Here is a good tool on the Internet. AYSO has provided the Game Cards in print out format. I’ve used this format at my second roster card during the game to help me keep track of players.

You can use the following link to create your game card online:

link here: http://www.ayso.org/Libraries/Resources/ayso_lineup_card.pdf

By filling the game card thru your web/browser, you are then able to print out 1 sheet with 4 game cards. You should print out multiple copies.

Marking the Game Card
As instructed on the game card, the card states that for each quarter, you mark down who has not played. Therefore you’ll just need to mark down who is not on the field.

Rotation Method: Some coaches use a pre-planned rotation per quarter to help them manage and ensuring players play most of the game. In addition, the rotation concept gives the players freedom to try different positions on the field.

Coaches can ask parents regarding availability from week to week so that the lineup card and roster rotations are planned and/or kept in mind for you.

For example, one player might have been sick the week before or another did not get to play 3/4 of game. You would like to be sure that everyone has a chance to play. You should be sure that those players who played less then previous week, get more playing time the next time.
Also players who don't show to practice does not have a direct effect to playing on Saturday. For example, a player may not be able to a practice with your team due to family event, but does show on Saturday.

Coaches should consider rotating the goalie by quarter and ensure that everyone on the team plays goalie at least few times a season. In higher age-divisions, you may get some players who wish to specialize in goalie. In that case as always encourage teammates to help by being a goalie as well so that everyone has time on the field.

Here we have demonstrated the AYSO philosophies of "Everyone Plays" and "Balanced Teams".


Coach Feedback
Coach #1
I prepare a lineup, by quarter, on a sheet of paper on Thursday or Friday. I usually decide who my keepers are going to be by Tuesday, so we can work with them at practice.

I give a copy to my assistant coach, who sets up the defense while I set up the mids and forwards.

This does two things -- it reduces the delay between quarters, and keeps the coach from being besieged by people yelling "I wanna play this!" or "I don't wanna play that!"

The coach needs good attendance info from his/her players' parents, of course, in order to make this work well.

11 v 11 Player Rotation for U14, U16 and U19

11 v 11 Player Rotation for U14, U16 and U19

9 v 9 for U12 Player Rotation

9 v 9 for U12 Player Rotation

7v7 Player Rotation for U10

7 v 7 Player Rotation for U10

5 v 5 Player Rotation

U08 Division
The following is the player rotation for a 5 v 5 game in the U08 Division.

3 v 3 Lineup Player Rotation

U05 and U06 Division Player Rotation

The following is a chart of the number of quarters a player plays thru rotation at the quarter breaks.  

AYSO 183 - 2011 Spring Season

AYSO 183 - Spring Season

Schedule
We are looking to start April 16th. This park district management will make the decision based on field conditions.

The schedule is posted online at http://www.ayso183.org

Spring 2011 Game Day/Practice Reminders:

1. Goal Setup: 45 minutes before game time (9 :00 AM)
   
   All teams that have 9:00 AM starts, should arrive 45 minutes before game time. Coaches and Parents should be prepared to carry goal equipment from the field lockers to the field locations. We are also expected to setup the goals 10-15 minutes before game time. We want to be sure that the games start on time. Anytime that is lost as part of setup is lost for that one hour only. The next game starts at 10:00am.
   
   Please be sure that upon setup of the goal, that all stakes are properly placed to hold the goal firmly down on the ground. The goal must be secure to the ground.
   
   
   
   
2. Player Forms: All coaches present must have player forms with them. Advice keep all player forms in a folder and in your own soccer coaches bag. Warning: AYSO Staff have been instructed to ask coaches if player forms are present. If not, we risk the chance of that game not being played. Seriously. Why? AYSO requires that these forms are present from a safety perspective such that if a player gets hurt, coaches and team parents have emergency contact and waiver information readily available. Important: I am really stressing this point and I take the displeasure with regards to micro-managing this reminder.
   
   
3. Game Cards: All coaches must have the Game Card (lineup card) filled out at the start of each game. Please spend the time to fill out these game cards (or) print outs. If you don't have cards, please go online to print out these cards. The referee will request these cards at the start of each game. Therefore it is best to have a backup card / clipboard sheet to keep track of your player rotations.
   
   Why? These cards are used to help keep track of player rotations in our games. We'd like to be sure that players get to play at least 1/2 of the game and we recommend and try go get each player to play 3/4 of a game. It is important that all players in AYSO play as much as possible through the entire season.
   
   Game Card Turn In: Typically a referee will ask for the game cards at the start of the game, at the end of game ~ or end of field duties, the referee will turn in the game cards to AYSO Staff.
   
   Game Lineup Sheet (Your copy): Its important that you keep your own copy (spreadsheet) of your lineup. This will help you keep track of players during the course of play. This will also give you a perspective as to how you can manage your teams lineup for the next game. Some players don't make it all games, so you want to be sure that returning players from absent games get to play in most of the next game. (Advice)
   
   
4. Goal Take Down:
   
   Teams that have the last game on the fields will have the responsibility to take down goals. The goals, nets, stakes, corner flags, and equipment are taken down and brought back to the field locker location. Some goals have goal bags associated, so please be sure that all equipment is placed in the bag.
   
   
5. Being Green
   
   We have a lot of people watching our soccer games. We do have a increased chance of leaving bottles, wrappers, food, paper, and clothing behind. Please give a heads up to families that we should leave the park as green as possible and that all trash should be properly disposed into the garbage cans in the park.
   
   
   

Area Fest - Sunday June 5th 2011
AYSO 183 Teams in the U10, U12, and U14 divisions can participate in the AYSO Area Fest. The Area Fest comprises of AYSO's in the north and northwestern suburbs close to Chicago such as Skokie, Highland Park, Glenview, Morton Grove, Evanston and Chicago.

The date for Area Fest is June 5th 2011.

Area Fest basically comprises of short-sided games on smaller fields. The number of players on the field is 5 v 5 (U10) and 7 v 7 (U12). The length of games are shorter than the regulation time in AYSO.

Please contact me if there is interest by your team to join the Area Fest.

AYSO Region 183 will need volunteers to help setup at the different locations at Area Fest. Typically all parents who partipate as coaches, assistant coaches and team parents help with Area Fest setup at their team locations.