Google Sheets SQL Showdown: Team Quiz

Welcome, spreadsheet warriors! Today, we’ll be putting your Google Sheets SQL knowledge to the test in a team quiz.

• Work on Google Sheets queries, test your knowledge on selecting and filtering data.

• Collaborate with your teammates, discussing approaches and problem-solving together.

• Apply your SQL knowledge under a time limit, simulating real-world scenarios.

Requirements

• Quiz Leader:: The quizmaster needs to prepare the questions, guide the quiz, and keep the energy high. Sample questions are provided below, but you should set your own. Anyone: trainee or volunteer can take this role. Prepare your quiz questions and answers in advance.

• Timekeeper: Keep track of time for each round to ensure the quiz runs smoothly.

• Assemble Your Team: Get into groups of 3-4. Teamwork makes the dream work!

• Paper & Pen: Prepare to write queries and discuss strategies WITHOUT using a computer.

• Friendly Competition: Complete the challenge with a positive and collaborative spirit!

The Challenge

This workshop will be divided into rounds, each presenting a Google Sheets SQL query. The scenarios will target various SQL functionalities available in Google Sheets.

You will write your answers on paper, not on a computer. Close your laptops. You may use this printed Google Sheets SQL CheatSheet to help you.

• Round 1: Getting Data: Practice using SELECT statements to find and get information from a sheet.

• Round 2: Conditional Queries: Let’s try something harder! Use WHERE clauses and conditional statements to filter data.

• Round 3: Advanced Arena: Challenge yourselves. Try using multiple conditions or advanced ways to filter data.

Bonus Round (Optional): Feeling confident? The quiz leader may do an extra round with an example spreadsheet. Really pushing your problem-solving abilities.

Acceptance Criteria

• Participation is Key: Be active with your team! Discussing questions and contributing ideas throughout the quiz.

• Show SQL Skills: Work together to plan correct Google Sheets SQL queries to solve the problems!

• Teamwork: Collaborate effectively and communicate your solutions clearly within your team.

Let the Games Begin!

Remember, effective communication, teamwork, and friendly competition are the keys to success!

SQL Showdown: Team Quiz Extravaganza - Example Questions

Round 1: Data Retrieval (10 minutes)

Scenario: You’re working with a Google Sheet containing product information.

Question 1: Say what you see

Write a query to select all product names and prices from the ‘Products’ sheet.

Question 2: WHERE are we going with this

How can you change the query to only show products with a price greater than $50?

Round 2: Conditional Queries (10 minutes)

Scenario: The Google Sheet also has a ‘Sales’ sheet that stores information about sales.

Question 1: AND the plot thickens

Write a query to get the product name and sales amount. Filter out sales where the quantity sold is greater than 10 AND the price is less than $100.

Question 2: OR is it?

Update the query to show sales where the product category is ‘Electronics’ OR the cost is over than $500.

Round 3: Advanced Arena (10 minutes)

Scenario: We have a ‘Customers’ sheet, containing customer names and their sale history.

Question 1: LIKE a pro

Write a query to find all customers whose names start with ‘A’ and have made a sale in the last 30 days.

Question 2: ORDER in the court

How can you change the query to show the top 5 customers by total sale amount, in descending order?

Bonus Round: Real-World Scenario

Scenario: The marketing team wants to identify top customers for a targeted campaign.

Challenge:

Write a query to find customers who have:

• Made over 3 purchases
• Have a total spend of over $1000
• Whose last buy was within the last 60 days.

Remember: These are just examples. You can change the difficulty and questions based on the group’s experience.

The winning team 🏆

Take a victory lap and eternal glory in the CodeYourFuture Hall of Fame. May the best Google Sheets SQL warriors be victorious! 🏆🔥

Know Your Computer

“Know Your Computer” focuses on how to perform regular tasks on your computer. In this workshop you will use basic Linux commands in the terminal. The goal is to reduce your fear of using the terminal.

Pre-requisite

To be able to do this workshop you will need a computer with a Linux shell running on it. If you already have a Mac or an Ubuntu operating system or any other Linux distribution running on your laptop, then you are fine. If your laptop is running on Windows operating system, download and install Git Bash for Windows. Code Your Future does not support Windows, so you must install or dual boot Linux to take our course. But to do this workshop, you can just use Git Bash. Once installed, open git bash and you should be able to perform the tasks below.

Tasks

You must use the terminal and Linux commands to complete each challenge. You must not use your GUI! Hands off the mouse! 🖱️

• Create a folder called my-shopping inside your Documents folder.
• Then create a file called my-list.txt inside my-shopping folder.
• Write the following items to my-list.txt file:

  1. Tea
  2. Pasta
  3. Coffee
  4. Milk

• Create a new folder called my-new-shopping inside your Documents folder.
• Now move my-list.txt from your my-shopping folder to your my-new-shopping folder. Your my-shopping folder should be empty after this step.
• Copy my-list.txt from your my-new-shopping folder back to your my-shopping folder. After this step, both folders should contain a file called my-list.txt.
• Now add the following line to my-list.txt file that is inside my-new-shopping folder:

   5. Sugar 

• Display the content of my-list.txt file inside my-shopping and the one inside my-new-shopping. my-list.txt file in my-shopping folder must have 4 items while the one inside my-new-shopping folder must have 5 items.

Resources

To help with this here are resources you can refer to: freecodecamp.com, Guru99, CLI-Treasure-Hunt.