Organized collection of ramblings about Teen Bible Quizzing
Teen Bible Quiz
  • Study
  • Equip
  • Videos
  • Podcast

There's A Stat For That

10/3/2017

5 Comments

 
Picture
For my day job, my responsibilities are to inspire performance, innovate products, improve the environment, invest in people, and ultimately to make a profit for my business unit. To do many of these things, I rely heavily on making data-based decisions.

As a Quiz Coach, I try to do the same when it is applicable. While I do rely on the Holy Spirit’s leading of my heart when it comes to interacting and mentoring the teens, I do use statistics at times to refine individual study and game-situation strategies. For example:
  • Jaqueline is getting more than her share of According To questions during competition. Perhaps I should encourage her and provide resources to make those her specialty in the future.
  • Blake and Aaron answer a lot of Context questions. I should put them on different teams so they don’t compete against each other for that question every game.
  • It’s Question 16. What’s the probability that the last Memory Verse question will be asked next? Should I substitute my bench player now or wait?
  • What are my quizzers’ current averages for this tournament? Who should I start the next game?
In a previous post, I shared how to download and use ​Nazarene TBQ score sheets for iOS Numbers. Out of my own desire for more real-time analytical data and an improved question type prediction algorithm, I’ve made significant enhancements to that spreadsheet. Here’s what’s new:

1. Tracks Your Quizzer's Averages for the Tournament

PictureClick image to enlarge view
​Of course, it only tracks the averages for the games captured in the file. But as a coach, you will most likely be capturing every game for your team at the tournament (or practice). By putting your quizzers’ names on the Averages tab, it will automatically update as the games are completed.

If you update the names of the Teams on each score sheet, it will also track Total Points and Points Per Game (PPG) for those teams represented in the file.

2. Percent Correct for each Question Type for the Tournament

PictureClick image to enlarge view
​What types of questions are missed or not attempted most often? Strategically, I use the information on this Summary tab to guide the study for certain quizzers. If Context questions are a low statistic, for example, then that could be an opportunity for Denise or Timothy to capture.

3. Percent Correct for each Question Type by Quizzer

PictureClick image to enlarge view
​Use the Details tab to very quickly see which types of questions are answered by your quizzers. If using the Scoresheets in a practice, use this tab to determine how to create balanced teams. 

Checking the boxes next to several names updates that grouping's total at the bottom of the table. 

4 Improved Probability Algorithm for Question Types

PictureClick image to enlarge view
​During competition, track the types of questions being asked by tapping the question number and selecting the proper code for that question. The algorithm knows which questions have already been asked and takes into account that it is highly improbable for Memory Verses to be asked back-to-back when calculating the probability of the next question’s type.


​Since making these improvements, I’ve only used it once for a real tournament. If you have iOS Numbers, check that out here. (Once the page loads, tap the screen and choose Open in "Numbers")

If you decide to give it a try, let me know how it goes! And if you can think of any other useful way to parse the data, send me a note or comment below. I’m kind of a geek when it comes to that sort of stuff!

Download ready-to-use files:

For iOS Numbers on iPad: Nazarene TBQ Score Sheet. Once the file loads, either tap the screen and choose Open in "Numbers" or tap the "send" icon next to the address bar and choose Copy to Numbers.
​
For MS Excel on PC/Surface: Nazarene TBQ Score Sheet 

5 Comments
dairl
11/7/2017 08:08:37 pm

Would like to use you spreadsheet to track our quizzer teams. Really like it.
Only having trouble with columns cells 1 to 15 registering -10 for an x selection.
Also would like quiz out be set at 5 correct questions. Can you tell me how to fix these issues?

Thank you!!!
Dairl

Reply
David
11/7/2017 10:08:38 pm

Thanks for you comments! The spreadsheet is designed to follow the scoring rules for Nazarene Youth Bible Quizzing, so errors (the “X” selection) aren’t supposed to deduct 10 points unless it is after question 15, the quizzer’s 3rd error or the combined team’s 5th (or more) error.
The spreadsheet isn’t protected, so if you know a bit about Excel formulas, feel free to adjust it to suit your needs!

Reply
Debby
10/3/2018 06:39:08 pm

Oh my! I've been wanting a tablet for score keeping and this came up in my Facebook memories today. Is the link for the MS Excel on PC/Surface still current and up to date? Are people using this? I don't have a tablet yet!

Reply
David
10/3/2018 07:08:26 pm

Yes! The links work! And I use the iOS version at every quiz meet.

Reply
Debby Freeland
10/12/2018 11:30:04 am

On the MS Excel is there a way to log challenges and appeals? I've played with it a little but haven't noticed that function.

Reply



Leave a Reply.

    The TBQ Podcast

    Picture
    Check out the Podcast tab to listen to the archived episodes!

      STAY UPDATED

      Enter your first name.
      Enter your email address.
    Get Updates
    Privacy Guarantee: I will never share your e-mail address with anyone else.

    What Is Teen Bible Quizzing?

    Teen Bible Quizzing is a dynamic, enriching ministry with a mission to invite youth into a deeper relationship with Jesus! Endorsed by Nazarene Youth International (NYI), Teen Bible Quizzing uniquely combines study of the Bible, competition, fellowship and disciple-making in a program attractive to youth.
    Read More

    Bible Quiz Board Game

    Picture
    A board game to play using your Bible Quiz questions! Play at home to review or during a team practice. See this article to learn how to play. Purchase the physical board game or download and print your own.

    Bible Quiz Challenge Cards

    Picture
    Playing cards for quiz practice or at a quiz meet to add another dimension of excitement to Teen Bible Quizzing. See this article to learn how to play.

    Get The NPH Bible Quiz App

    Web app works on iOS and Android devices

    About Me

    I am the Louisiana Nazarene Teen Bible Quiz Director, the author of several Teen Bible Quiz apps and study guides, and regular host of The TeenBibleQuiz Podcast.

    I have been involved in Teen Bible Quizzing as either a coach or District Director since 1995.

    I am married to a wonderful wife and have a son and daughter who love the Lord and have recently retired from Teen Bible Quizzing.


    Archives

    June 2022
    August 2021
    September 2020
    August 2020
    July 2020
    February 2020
    January 2020
    July 2019
    April 2019
    March 2019
    December 2018
    September 2018
    July 2018
    May 2018
    November 2017
    October 2017
    September 2017
    July 2017
    May 2017
    April 2017
    December 2016
    July 2016
    June 2016
    April 2016
    March 2016
    November 2015
    August 2015
    July 2015
    May 2015
    October 2014
    September 2014
    August 2014

    Categories

    All
    According To
    Burnout
    Card Game
    Challenging
    Christian Competition
    Coaching
    Context Question
    Culture Change
    Danae Phillips
    Focus
    Good Sportsmanship
    How To Study
    Karl Tabor
    Keeping Score
    Memory Verses
    Mindset
    Motivating
    New Quizzers
    Passion
    Pitfalls
    Practice Questions
    Quiz Practice
    Quizzing App
    Rules
    Ryan Holman
    Score Sheet
    Situation Question
    Study Resources
    Time Management
    Top 10
    Uninvolved Parents
    Videos
    Volunteers
    What Is TBQ?

    RSS Feed