Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 
SQL Server Transparent Data Encryption Alternative - Free Webinar
 

SQL Server Jeopardy for User Group Meetings


By:   |   Last Updated: 2013-08-09   |   Comments (6)   |   Related Tips: More > Professional Development Community

Problem

As a SQL Server User Group Leader with Ray Barley, we are always looking for new ideas for our monthly meetings.  We have tried polls on LinkedIN and Meetup.  We have had some good feedback on formats, but we really want to have some fun as a group, give members more opportunities to connect and "pack the house".  Do you have any suggestions?  Check out this tip to learn about SQL Server Jeopardy.

Solution

At our recent Baltimore SQL Server Users Group meeting, we tried something a little bit different and our community seemed to enjoy the change of pace.  We had our first session of SQL Server Jeopardy.  SQL Server Jeopardy helped us achieve a few goals:

  • Change our consistent meeting formats
  • Give community members more time to chat and get to know one another
  • Freed up having to find a main speaker for the meeting
  • Share knowledge in an entertaining and new way
  • Build some teams within the group
  • Collaboration among team members to solve a problem
  • A few laughs here and there
  • ...and a $50 gift card to the winning team

So how did we do it?

  • We prepared a game board via PowerPoint with 4 different categories
    • Database Administration
    • Database Development
    • Business Intelligence
    • Potpourri
  • We prepared multiple questions from levels 100 to 500
  • We split the group into 3 teams
  • Each of the groups had to come up with a team name
    • ...and they were are pretty creative
  • Each team had a single point of contact to respond to the questions
  • I asked the questions and Ray selected which team raised their hand first in order to answer the question
    • We had some pandemonium with asking and answering questions, so our lessons learned is to just follow a round robin format rather than trying to judge who raised their hand first or forgot about the rules (because they were super excited) and yelled out the answer.
    • So here is how we plan on handling this the next time:
      • First team has control of the board
      • Ask the question
      • Give the first team a finite amount of time to answer
        • If they answer incorrectly award zero points then give the second team a finite amount to answer.
          • Repeat for each team until the question is answered correctly or all teams do not field a correct answer.
        • If a team answers correctly, then they get the points and the next team gets control of the board.
    • With each question we shared the correct answer and asked for community members to provide a brief explanation of the answer to share knowledge among the group
    • Once the question was answered, we deleted the number from "the board" in PowerPoint
  • In terms of recording scores, we added points for correct answers and subtracted points for incorrect answers.
    • This lead to some pandemonium as well.  I think our lesson learned for our next session of SQL Server Jeopardy is to just add points for correct answers and zero points for incorrect answers.
  • With about 5 minutes remaining in our meeting we moved to the "Final Round" of SQL Server Jeopardy
    • Here is what we did:
      • We provided a general topic for the "Final Round" question
      • Each team chose how many points they wanted to bet then notified the remainder of the teams
      • We asked the final question
      • Gave all the teams about 1 minute to formulate an answer
      • Had each team present their answer
      • Crowned the first SQL Server Jeopardy Champions

SQL Server Jeopardy Board

Here is a screen shot of the starting board we had in PowerPoint:

SQL Server Jeopardy Board

Click here to download the sample SQL Server Jeopardy board.

SQL Server Jeopardy Questions

Our questions were all over the map in terms of the topic and the number of responses.  When we started off, we were not sure what sort of responses we would get, so we wanted to be open minded.  One of our lessons learned was to potentially select narrower topics to help determine the interest level.  We are thinking about throwing out some topics in a previous meeting to help find out the interest level and narrow down ideas before we hold our next SQL Server Jeopardy event.

Click here to download the sample SQL Server Jeopardy questions.

Next Steps


Last Updated: 2013-08-09


next webcast button


next tip button



About the author
MSSQLTips author Jeremy Kadlec Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an MSSQLTips.com co-founder and Edgewood Solutions SQL Server Consultant.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Thursday, January 15, 2015 - 10:32:17 AM - Bob Franzese Back To Top

Love the idea, Jeremy, sorry I missed this one. Years ago, I got a buzzer system that came with a cheap board game I picked up and I kept the buzzer years after I threw away the game. If you're going to do this again, perhaps a trip to Target or Walmart is in order?

 

Or just order this: http://www.amazon.com/Learning-Resources-LER3774-Answer-Buzzers/dp/B004DJ51HQ/ref=sr_1_1/175-1713352-9531605?ie=UTF8&qid=1421335819&sr=8-1&keywords=buzzers+for+games


Monday, September 16, 2013 - 2:12:05 PM - Jeremy Kadlec Back To Top

Chad,

Thanks so much for the updates.

Thank you,
Jeremy Kadlec
MSSQLTips.com Community Co-Leader


Monday, September 16, 2013 - 12:15:59 PM - Chad Crawford Back To Top

Check out http://jeopardylabs.com.  They have a system that works pretty well and I've used it for class reviews (I'm teaching a few DB classes internally).  It's a pretty good interface and keeps track of the score for you.  I also picked up a buzzer set, if you're willing to shell out a little ($35), it's a nice additon:  Educational Insights Eggspert http://www.amazon.com/gp/product/B001SN8DE8/ref=oh_details_o02_s00_i00?ie=UTF8&psc=1.  

 

I was thinking of doing something for our users group or a SQL Saturday, Your post gave me the motivation to put it together.

Thanks,

Chad


Wednesday, September 04, 2013 - 12:50:02 PM - Richard Fohrenbach Back To Top

Cute idea. We had a ACE (Achieving Competitive Excellence) Jeopardy game at Sikorsly Aircraft back in 2004. (ACE is the "lean" Six Sigma-like program used by UTC (United Technologies Corp, the parent of Sikorsky, Otis, Pratt and Whitney etc)


Friday, August 09, 2013 - 12:09:19 PM - Jeremy Kadlec Back To Top

Dustin,

Great to hear it!

Thank you,
Jeremy Kadlec
Community Co-Leader


Friday, August 09, 2013 - 11:03:55 AM - Dustin Jones Back To Top

Great idea! I plan to do this in an upcoming meeting!

 

http://centralpa.sqlpass.org


Learn more about SQL Server tools