SIMSOC Excel Spreadsheet

For my Introduction to Sociology classes I have been running SimSoc for a number of years. SimSoc was constructed in the late 1960s by William Gamson, and has been tweaked ever since by various authors. Designed to assist participants to create a simulated society, Gamson's manuals help facilitators to run such simulations.

When I first started running the simulations for my students, I found it incredibly difficult to know how to tabulate the values for each session. The Coordinator's Manual is frustratingly sparse on several details, and it leaves out all of the information contained in the Participant's Manual, so the facilitator must purchase both and be thoroughly familiar with both. In order to help me keep up with the session-by-session, I started this Excel spreadsheet that became a full-fledged management system for the sessions. It is the result of several years gradual work. I decided to put it online for others who feel it might be useful to them.

The first page is instructions for the coordinator. The second page is where you will enter in your participants' information (name, group head, room, etc). The third sheet is what calculates the values, and at the end of the sessions (or during) you can enter participant information. The fourth-sixth pages you can print for the participants: MasMed reports, attendance/subsistence sheet for the helper, and an instruction sheet for the helper. The final sheet is a "wish list," though the only thing is a way to calculate the minorities sessions. I have never incorporated this into my simulations, simply because of the 5-hour time-frame that limits what I can invest in the simulation. There are many other features I have not incorporated for that same reason.

Feel free to contribute to the project or ask any questions about running a session.

SimSoc Excel Spreadsheet (right-click to save and download)

Feel free to e-mail me at
"Open your eyes. Don't let your mind tell the story here." Tonic, 1996

"Our lies have made us angry with the truth." Five O'Clock People, 1997

Regarding an assessment of the modern application of the Ten Commandments:
"Science supplies the means of killing, finance the methods of stealing, the newspapers have learned how to bear false witness artistically to a globeful of people daily, and covetousness is the moral basis of our civilization.." Rauschenbusch, 1917