Data Collection

• Introduction to SQL

This site is a lesson on using SQL. It starts with a simple SELECT query. The user must type in the correct command to select certain columns from a database. Once the user has completed the first lesson, then he or she may continue to more complicated lessons.

• Clinical Trials Repository

This site is a government-run repository of information on current and completed clinical trials. Users can search for clinical trials by disease type and also by whether the trial is currently recruiting. Then a detailed description of the trial is given. This can be used in a classroom setting to discuss design issues and ethical issues with clinical trials.

• Body Worn Camera Experiment

This website is a summary of a randomized controlled trial of a metropolitan police department's body-worn camera program. It is useful in class to talk about the design of the experiment and also to talk about how they state their results. Their results are given as confidence intervals for differences.

• Song: Randomly Select

A song to be used in discussing the value of random selection in sampling and random assignment in experimentation. The lyrics were written by Mary McLellan from Aledo High School in Aledo, Texas as one of several dozen songs created for her AP statistics course. The song may be sung to the tune of the 2014 hit “All About that Bass,” by Meghan Trainor. Also, an accompanying video may be found at https://www.youtube.com/watch?v=br-5FtoYfkc

• Song: Lurking Variable

A song that can be used in discussing lurking variables - unobserved variables that may drive the relationships seen in the data. The lyrics were written by Mary McLellan from Aledo High School in Aledo, Texas as one of several dozen songs created for her AP statistics course. The song may be sung to the tune of the 2013 song “Happy,” written by Pharrell Williams for the animated movie Despicable Me 2. Also, an accompanying video may be found at

• Song: Confounding Variables

A song that may be used in discussing how confounding variables may provide alternate explanations for the data making causal interpretations difficult. The lyrics were written by Mary McLellan from Aledo High School in Aledo, Texas as one of several dozen songs created for her AP statistics course. The song may be sung to the tune of the mid-20th century folk song 99 Bottles of Beer. Also, an accompanying video may be found at

• Song: Cluster vs. Stratify

A song that may be used in discussing the difference between cluster sampling and stratified sampling  and the value of them when you have groups known to be homogeneous for the variable under study.  The lyrics were written by Mary McLellan from Aledo High School in Aledo, Texas as one of several dozen songs created for her AP statistics course. The song may be sung to the tune of Mike Chapman and Nicky Chin’s 1979 song "Kitty", popularized by Toni Basil in her 1981 recording of the song as "Mickey". Also, an accompanying video may be found at https://www.youtube.com/watch?v=rX9erSAH9WY

• Video: Randomize

A video to be used in discussions of the value of random assignment to avoid bias in the comparison of groups in an experiment. The video and lyrics were written by Mary McLellan from Aledo High School in Aledo, Texas and is sung to the tune of the Bee Gees 1977 disco hit "Stayin' Alive." The video won second place in the video category of the 2017 A-mu-sing contest.
• Song: Losing Cause

A song to be used in discussing the idea that correlation does not imply causation. The original music and lyrics were written in 2017 by Lawrence Mark Lesser from The University of Texas at El Paso and won first place in the song category of the 2017 A-mu-sing contest.
• Song: Question the Questions

A song to aid in discussing various common problems seen in the wording of questions in sample surveys. The original music and lyrics were written in 2017 by Lawrence Mark Lesser from The University of Texas at El Paso. The song won second place in the 2017 A-mu-sing contest.