Beginner

20 mins

Teacher/Student led

+10 XP

What you need:
Chromebook/Laptop/PC

Introduction to Data Queries

Learning Goals Learning Outcomes Teacher Notes

Warning: Your screen size is quite small for viewing this. Rotate your device into landscape mode if you can.

1 Warm Welcomes!
2 What You Already Know
3 The Magic Behind the Scenes
4 Types of Data Spells (Queries)
5 Why Use Data Queries?
6 Types of Data Sources
7 Crafting Your First Query
8 Practice Session
9 Next Up
Quiz

1 - Warm Welcomes!

Greetings, adept data magician! As we ascend to higher realms of Excel mastery, we encounter the mystical world of "Data Queries." Just as a magician seeks knowledge from ancient tomes, in Excel, we use data queries to seek and retrieve information from vast data landscapes.

Today, we'll unveil the secrets of initiating these queries and harnessing the power they bring. Ready to summon data at your command? Let's begin!

2 - What You Already Know

In the magical world of Excel, data queries are like summoning spells. They allow us to reach out and pull information from different sources, be it another Excel workbook, a database, or even a website. With a correctly cast query, vast amounts of data can be brought into your Excel sheet, ready for analysis.

The Essence of Data Queries:

Imagine standing at the edge of a vast library, filled with countless books, scrolls, and tomes. Each piece of literature holds unique knowledge, but it would take ages to manually gather all the information you need. Data queries are like a magical assistant that can instantly fetch the exact book or scroll you're looking for, bringing it right to your fingertips.

3 - The Magic Behind the Scenes

Summoning Data: At its core, a data query is a request. You're asking Excel to reach out to a specific source and bring back certain information.

Transcending Boundaries: With data queries, geographical or format boundaries don't limit you. Whether the data resides in a cloud in the digital sky, a server halfway across the world, or another file on your computer, a data query can fetch it.

Dynamic Refresh: One of the most magical traits of data queries is their ability to refresh. If the original data source updates, you can simply refresh your query, and your Excel sheet will update with the latest information. It's like having a scroll that automatically updates its content!

4 - Types of Data Spells (Queries)

Data queries aren't just about fetching data; they're about fetching the right data. With the correct instructions, your query can filter out unnecessary information, ensuring that only relevant and desired data makes its way to your workbook.

Types of Data Spells (Queries):

Import Queries: These bring data into Excel from an external source, transforming your workbook into a dynamic data repository.

Append Queries: If you have data spread across different tables or sheets and you want to bring them together in one grand table, append queries are your go-to spell.

Merge Queries: When you want to combine data based on common columns (like merging a list of potions with their effects based on potion names), merge queries come to the rescue.

Data queries in Excel are a testament to the software's profound capabilities. They embody the essence of efficient data management, allowing magicians like you to focus on analyzing and interpreting data rather than spending countless hours gathering it. With data queries in your magical arsenal, you're well-equipped to face any data challenge that comes your way.

5 - Why Use Data Queries?

Volume: Summon large amounts of data without manual entry.

Accuracy: Reduce the risk of human error. Let the query fetch the exact data you need.

Efficiency: Update your data with a single refresh, ensuring you always have the latest information.

Unlock the Full Learning Experience

Get ready to embark on an incredible learning journey! Get access to this lesson and hundreds more in our Digital Skills Curriculum.

Get started

Copyright Notice
This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.

Your Answer or Description of Your Work

Project URL This can be a link to your project (e.g. a Scratch, Microbit, Arcade or CodePen URL link).

Upload File

You must be logged into Scratch to share your project, otherwise the link will not work.

To get the URL link of your Scratch project:

Make sure you're logged into Scratch.
Click on the Share button in the project editor.
Click on the Copy Link button.
Click on the Copy Link link. This will save the URL of your project page into your clipboard.

To get the URL link of your Microbit project:

Click on the button in the project editor.
Click on the Publish Project button.
Click on the Copy button. This will save the URL of your project page into your clipboard.

To get the URL link of your Arcade project:

Click on the button in the project editor.
Click on the Publish Project button.
Click on the Copy button. This will save the URL of your project page into your clipboard.

To get the URL link of your CodePen project:

Make sure you're logged into CodePen.
Open your project in the editor.
Click on the Save button at the top of the editor.
Copy the link from the address bar in your web browser (e.g. https://codepen.io/Jane-Smith/pen/gOVXxBQ)

Introduction to Data Queries

Teacher Class Feed

1 - Warm Welcomes!

Send your work to your teacher

2 - What You Already Know

Send your work to your teacher

3 - The Magic Behind the Scenes

Send your work to your teacher

4 - Types of Data Spells (Queries)

Send your work to your teacher

5 - Why Use Data Queries?

Send your work to your teacher

Unlock the Full Learning Experience