Premium

Creating and explaining spreadsheets

This B1 business English lesson helps students confidently discuss data, charts, and calculations using spreadsheets. Activities include vocabulary, listening, reading, grammar on giving instructions, and presenting a budget. Master essential spreadsheet terms and presentation ph

B1 Business Work Technology Audio
Creating and explaining spreadsheets

Summary

This downloadable PDF lesson for B1 ESL students helps them master the language of spreadsheets. A practical ESL resource for any business English class material that focuses on explaining data, charts, and calculations in a professional setting.

This B1 business English lesson helps students confidently discuss data. Activities include a vocabulary matching game, a listening exercise with a data expert, a grammar section on giving instructions, a reading comprehension task about a small business, and a final speaking practice where students present a budget. This class material provides a comprehensive introduction to using English for spreadsheet-related tasks in the workplace, making it a valuable resource for any professional English class.

Activities

  • A matching exercise where students define key spreadsheet terms like "cell," "formula," and "sort," building foundational vocabulary for discussing data and understanding spreadsheet functions.
  • A listening comprehension gap-fill exercise featuring a data expert, designed to improve listening for specific details and introduce relevant professional vocabulary in context.
  • A reading comprehension task where students analyze a short case study about a small business using spreadsheets to improve efficiency, followed by a true/false check.
  • A final speaking activity where students, in pairs, use a sample budget and useful phrases to prepare and deliver a short presentation, explaining data to their peers.
audio-thumbnail
Creating and explaining spreadsheets B1
0:00
/0

Transcript

0:00 Spreadsheets are incredibly powerful tools.0:02 They help organize vast amounts of data efficiently.0:05 Learning to create formulas is essential for data analysis.0:09 Visualizing trends with charts makes presentations much clearer.0:12 I always double-check my data for accuracy before sharing.0:16 It's crucial to explain the methodology behind your calculations.0:20 Understanding pivot tables really streamlines reporting processes mastering spreadsheets can truly boost your productivity.

Vocabulary focus

This lesson focuses on essential terminology for working with spreadsheets. Students will learn and practice key nouns such as "cell," "row," "column," "formula," and "data set." They'll also work with verbs like "sort" and "filter." In addition, the material introduces useful phrases for presenting data, such as "This sheet shows..." and "As you can see from the line graph..."

Grammar focus

The grammar section concentrates on giving clear and direct instructions, a crucial skill for explaining processes. Students will learn to use the imperative mood (e.g., "Enter the data," "Select the cells") for commands. They will also practice using the present simple tense to describe what a function or formula does (e.g., "This formula calculates the total"). A rewriting exercise helps solidify this practical grammar point.


Related

Sustainability: The high cost of fast fashion
B2 Practical English Business Lifestyle General Work Grammar Video

Sustainability: The high cost of fast fashion

This lesson explores the environmental and social impact of fast fashion. It delves into the concept of sustainability within the fashion industry and encourages discussion on consumer choices and corporate responsibilities.

Premium
History: the Cuban Missile Crisis
C1 Practical English General Grammar Business Video

History: the Cuban Missile Crisis

This lesson explores the Cuban Missile Crisis, a pivotal moment in the Cold War, through listening comprehension and vocabulary exercises. It also focuses on using the Third Conditional to discuss hypothetical historical outcomes.

Premium
Math in real life: How math guides our ships at sea
B2 Practical English Technology Grammar Travel Video

Math in real life: How math guides our ships at sea

This lesson explores the historical use of mathematics in navigation, particularly focusing on how early sailors found their way at sea. It covers key inventions like sextants and accurate timepieces, and the mathematical concepts like logarithms that made modern navigation possi

Premium