Excel Explorers: Get to Know Spreadsheets!

Excel Explorers: Get to Know Spreadsheets!

Learning Objective

At the end of the lesson you will understand the basic functions of Excel and be able to create a simple spreadsheet.

What do you already know about Excel?

Introduction to Excel

Excel is a software program used to create electronic spreadsheets. It's commonly used in schools, businesses, and at home for organizing and analyzing data.

Parts of Excel

Excel consists of cells, columns, and rows. Cells are the individual blocks where data can be entered, while columns and rows organize the cells into a grid-like structure.

Data Entry in Excel

Students can enter various types of data into Excel, such as numbers, text, and formulas. Data can be formatted and manipulated to perform calculations and create charts.

Formatting in Excel

Excel allows for formatting options including changing font styles, colors, and adding borders to cells and text. Formatting can make data more visually appealing and easier to read.

Basic Functions in Excel

Excel has basic functions like sum, average, and count that can be used to perform calculations on data. Formulas are used to execute these functions within the cells.

Multiple Choice Question

What is a cell in Excel? A) A type of graph, B) The individual blocks where data can be entered, C) A color used for formatting.

Practice Time

Students will now have the opportunity to create a simple spreadsheet in Excel by entering data, formatting cells, and using basic functions.

Write down 3 things you learned in this lesson.

Have students enter three things they learned in this lesson. With this they can indicate their own learning efficiency of this lesson.

Ask 1 question about something you haven't quite understood yet.

The students indicate here (in question form) with which part of the material they still have difficulty. For the teacher, this not only provides insight into the extent to which the students understand/master the material, but also a good starting point for the next lesson.