The short answer is that there is no assigned seating. The longer answer is that typically when everyone breaks for the stands they run by squadron to the same general area. However, after that the cadets (including C4Cs) are free to stand wherever they wish in the cadet seating (or for that matter hide in the bathroom if they so desire).
The football game is a good time. If you are taking your cadet to the game have them drive into the lot. Parking was free last year if the cadet was driving.
Also, check out pregame over at the tunnel when people are dropping dollar bills down on the band. It's a good time. My son said last year it was nuts and that there were cadets crowd surfing down there that were losing boots, socks, etc.
As far as seating, he was a C4C last year and sat down low. He volunteered to be on the push up detail after AF Scoring drives. I saw him on ESPN one night at a game when they were zooming in on a few of them after a commercial break for several seconds.