B1

Spreadsheets: explaining data and giving instructions

Spreadsheets — a B1 English lesson. Practise giving instructions and expand vocabulary for explaining data and charts in a professional setting.

LessonpillsLessonpills 3 min read
Contents

Summary

This 90-minute ESL lesson for B1 learners explores Spreadsheets: explaining data and giving instructions through a real article. Across 11 interactive exercises, you'll develop reading comprehension, vocabulary, grammar, practical communication, speaking skills — all built around authentic English content.

What you'll practise:

  • 5 key vocabulary items with definitions and usage notes
  • Grammar focus: using the imperative mood with examples and practice
  • Real-world phrases for explaining a chart or graph in a meeting
  • Gap-fill and cloze exercises to test vocabulary in context
  • Matching exercise to connect terms with their meanings
  • Error correction to sharpen grammar awareness
  • A reading passage to practise newly learned language

Lesson activities (11 exercises)

Each exercise builds on the previous one. Work through them in order for the best learning experience.

  1. Warm-up — Discussion questions to activate what you already know about the topic.
  2. Comprehension — Answer questions to check your understanding of the main ideas and supporting details.
  3. Vocabulary — Learn key words and expressions from the article, with definitions and usage notes.
  4. Matching — Connect words, phrases, or concepts to their correct counterparts.
  5. Grammar — Study using the imperative mood — explanation, examples, and key rules.
  6. Error correction — Find and fix the mistake in each sentence — a great grammar workout.
  7. Practical English — Learn phrases for explaining a chart or graph in a meeting — ready to use in real conversations.
  8. Fill the gaps — Complete sentences with the correct vocabulary. Drag and drop or type your answers.
  9. Reading — Read a short passage on the topic and answer comprehension questions.
  10. Discussion — Reflect on the topic and share your opinions using the language you've learned.

Vocabulary

This lesson introduces 5 key terms drawn directly from the article:

  • To walk someone through something — to explain a process or set of instructions to someone in a slow, detailed way.
  • A ballpark figure — an approximate number or a rough estimate.
  • To spot a trend — to notice a general pattern of change or development in data over time.
  • To double-check something — to check something for a second time to make sure it is correct and has no mistakes.
  • At a glance — immediately, after a quick look.

Grammar

This lesson focuses on using the imperative mood.

We use the imperative mood to give direct instructions, commands, or advice. In a business context, like explaining how to use a spreadsheet, it's a clear and efficient way to tell someone what to do. To make instructions more polite, we often add words like 'please' or use a softer tone.

Examples from the lesson:

  • Enter the sales figures for Q4 into column B. — Use the base form of the verb (e.g., enter, click, select) to give a clear instruction.
  • Don't delete the formula in the 'Total' cell. — To make a negative instruction, use 'Don't' before the base form of the verb.
  • First, highlight the data, then click on the 'Insert Chart' button. — You can connect multiple instructions with words like 'first', 'then', and 'next' to show the order of steps.

Key rules:

  • Use the base form of the verb without a subject (e.g., 'Copy the cells', not 'You copy the cells').
  • For negative commands, always use 'Don't' + the base verb.
  • To be more polite, you can add 'please' at the beginning or end of the sentence.

Practical English

explaining a chart or graph in a meeting

In business meetings, you often need to present data using charts or graphs. These phrases will help you guide your colleagues' attention, explain what the data means, and check their understanding clearly and professionally.

Phrases you'll learn:

  • "If you look at this chart, you'll see that..." — used to introduce a chart and direct everyone's attention to it.
  • "The most important thing to notice is..." — used to highlight the main point or the most significant piece of data.
  • "This section here represents..." — used to explain a specific part of the chart or graph.
  • "So, what this tells us is that..." — used to state the conclusion or implication of the data.
  • "As you can see, there was a sharp increase/decrease in..." — used to describe a significant change shown in the data.