9 results
Graphic arts lessons for Microsoft Excel
EXCEL 2016 - Franco's Car Wash - Using Formulas
The premise of this lesson is simple. Students create a spreadsheet to track weekly sales for a fictional company called “Franco’s Car Wash”. Along the way, students will create formulas to capture information such as units sold, subtotals, and grand total (money made) after tax. Importantly, students will realize the importance of creating formulas that reference cells.
Using cell addresses in formulas make them easy to update. Students will practice formatting skills, making their spreadshee
Grades:
6th - 12th
Types:
EXCEL 2016 - Intro to Formatting
In this introduction to using Excel, students pretend they are creating a customer contact list for a Lawncare business. They type in the data and get used to navigating the cells that make up Excel spreadsheets. Along the way, students add colors, borders, and complete other basic formatting tasks. This lesson is about learning the basics of formatting in Excel and saves the math functionality for another day.As Excel can initially feel foreign and not overly intuitive to new users when compar
Grades:
6th - 12th
Types:
EXCEL 2016 - Conditional Formatting
Students learn all about Conditional Formatting and the VLOOKUP function in this lesson. They construct a worksheet which summarizes the restaurant ratings of fictional critics. A splash of color helps to breathe life into the data and accentuate key pieces of information. This is where Conditional Formatting comes in.
The VLOOKUP function is used to facilitate an automatic recommendation system which is based on average restaurant ratings.
The lesson allows for differentiation. Instruction is
Grades:
6th - 12th
Types:
EXCEL 2016 - Family School year Budget
Students create a school year budget for a fictional family in this lesson. They use multiple sheets to track predicted costs as well as actual costs for the following categories; school supplies, electronics, clothing and lunchtime + accessories. Formulas will need to be constructed to make the math work, and students will practice referring to multiple worksheets as well as using absolute cell references. Students will use table styles as a way to quickly format the information.
The lesson a
Grades:
6th - 12th
Types:
EXCEL 2016 - Catering Invoice - More on Formulas
This beginner level Excel 2016 lesson takes a deeper look into using formulas. Students create an invoice for a fictional company called “Green Plate Caterers”. The invoice is for an office party at an insurance company. To complete the invoice successfully, students will create formulas which follow the order of operations.
Students will use styles and the Format Painter command to format the information.
The lesson allows for differentiation. Instruction is full of screenshots as well as
Grades:
6th - 12th
Types:
EXCEL 2016 - Simple Functions - NBA Salaries
In this activity, students learn all about using simple functions in Excel such as Sum and Average. NBA player salaries over five seasons are used as students employ the powerful mathematical capabilities of Excel to display the amount of money the players make on the three highest spending teams in the league. Students use color codes so that they can customize individual salary sheets for Golden State, Cleveland and Oklahoma City.
The lesson allows for differentiation. Instruction is full o
Grades:
6th - 12th
Types:
EXCEL 2016 - More Functions - WXFG Radio
This lesson is great for taking a deeper dive into using functions. The premise for the activity is students are pretending to be recently hired by a fictional radio station to clean up their archaic record-keeping practices. Students transform a disorganized, incomplete and mistake-ridden employee information spreadsheet using functions.
They use the power of some of Excel’s text manipulation and date calculation functions. It is a perfect follow up to Excel 2016 - Simple Functions - NBA Sa
Grades:
7th - 12th
Types:
EXCEL 2016 - Using Tables - Grocery List
In this activity, students create a sortable grocery list that calculates a running total. Tables are explored as a convenient means of organizing information and performing some math. Students experience first hand how practical Excel can be for an everyday task such as a grocery list.
In completing this lesson, students will explore using the PRODUCT and IF functions, and will see that these functions can be used in combination. They will learn to freeze rows in order to make the information
Grades:
6th - 12th
Types:
EXCEL 2016 - Using Charts - Student Grades
This lesson is an ideal starting point for teaching students how to use charts in Excel. Students play the role of teachers who are calculating class grades. They will create both a column chart (for Math grades) and a line chart (for History grades). Creating two charts gives students ample exposure to this important concept.
In completing this lesson, students will learn how to instruct Excel to pick the data they want to be displayed in their charts. They will learn data entry short-cu
Grades:
6th - 12th
Types:
Showing 1-9 of 9 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands