In 2372, the program was a relatively new idea. A group of Red Squad cadets, including Riley Shepard, disabled the global power distribution center in Lisbon, allowing Admiral Leyton to launch his coup attempt. (DS9: "Homefront", "Paradise Lost")
Shortly before the outbreak of the Dominion War, Red Squad was assigned to crew the USS Valiant, on a training mission to circumnavigate the Federation. Following the outbreak of war, the Valiant found itself trapped behind enemy lines. When the ranking officers were killed, Cadet Tim Watters assumed command, and kept the ship behind enemy lines. For eight months, Red Squad carried out the missions assigned to the Valiant, until, on stardate 51825, the Valiant engaged a Dominion battleship prototype. The ship was lost, with only three survivors – one Red Squad cadet among them, Dorian Collins. (DS9: "Valiant")
Red Squad members
The Red Squad insignia was an altered version of the USS Enterprise TOS command division assignment patch, the arrowhead changed from gold to red, the "star" division logo made gold and extended outside the arrowhead, and the bordering of the arrowhead also changed from black to gold.
The Activision video game Star Trek: Invasion was originally developed with the working title Star Trek: Red Squad. In the final game, the Valkyrie pilots of the USS Typhon, including the main character Ryan Cooper, were Red Squad members. (Star Trek: The Magazine Volume 1, Issue 10, p. 97)
The short story "Dorian's Diary" in Strange New Worlds III establishes that in 2374, sole Red Squad surivior Dorian Collins was awarded the Drakon Cluster of Courage, and the rest of the deceased Red Squad members were also awarded posthumously. Internal Affairs also launched an investigation into the actions of the cadets and criticized the decisions they made, but the public perception of them as heroes of the Dominion War made them overlook the actions of Red Squad.