Lesson Planet
Search educational resources
  • Sign In Try It Free
  • AI Teacher Tools
    • Discover Resources Search reviewed educational resources by keyword, subject, grade, type, and more
    • Curriculum Manager (My Content) Manage saved and uploaded resources and folders To Access the Curriculum Manager Sign In or Join Now
    • Browse Resource Directory Browse educational resources by subject and topic
    • Curriculum Calendar Explore curriculum resources by date
    • Lesson Planning Articles Timely and inspiring teaching ideas that you can apply in your classroom
    • Our Story
    • Frequently Asked Questions
    • Testimonials
    • Contact Us
  • Pricing
  • School Access
    • Your school or district can sign up for Lesson Planet — with no cost to teachers
      Learn More
  • Sign In
  • Try It Free

Hi, what do you want to do?

Create a lesson plan
Create a lesson plan
Generate resources with 80+ AI teacher tools
Generate resources with 80+ AI teacher tools
Search 200,000 instructional videos
Search 200,000 instructional videos
Find a teaching resource
Find a teaching resource
Solving Real-Life Problems in Excel Instructional VideoSolving Real-Life Problems in Excel Instructional Video
Publisher
GCFGlobal.org
Resource Details
Curator Rating
Educator Rating
Not yet Rated
Grade
9th - Higher Ed
Subjects
21 Century Skills
1 more...
Resource Type
Instructional Videos
Media Length
4:19
Audiences
For Teacher Use
1 more...
Duration
10 mins
Instructional Strategy
Direct Instruction
Technology
Video
Internet Access
Year
2014
Usage Permissions
Fine Print
Instructional Video

Solving Real-Life Problems in Excel

Curated and Reviewed by Lesson Planet

Jane has 20 bananas and gives 16 away; how many are left? Microsoft Excel can help with that! A video provides a brief overview of the software program. Viewers learn how to use planning, basic math, and knowledge to solve real-life problems using Excel software.

16 Views 10 Downloads
CCSS: Adaptable

Concepts

microsoft excel, formulas, spreadsheet skills, basic computer skills, computer software, technology resources

Instructional Ideas

  • Challenge students to write original word problems and use Excel to solve them 
  • Provide graphic organizers for note taking

Classroom Considerations

  • Requires speakers and projection if playing for the class, or a computer and headphones for each learner
  • This video is hosted on YouTube

Pros

  • Text and graphics help explain complex information 
  • Narration is slow-paced, clear, and easy to follow 

Cons

  • None

Common Core

SL.9-10.3 SL.11-12.3

See similar resources:

Instructional Video

Excel 2016: Creating More Complex Formulas

GCFGlobal.org
Please Excuse My Dear Aunt Sally! The 13th of 27 instructional videos from the Microsoft Excel 2016 set covers the order of operations. First, scholars review how to use the order of operations to solve math equations. Next, they see how...
5 mins 9th - Higher Ed 21 Century Skills
CCSS: Adaptable
eBook

Beginning Excel

Open Oregon Educational Resources
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
9th - Higher Ed 21 Century Skills
CCSS: Adaptable
Instructional Video

Episode 1.2: The Problem

Cisco
Where have all the schoolgirls in Malawi gone? Teen leaders solve a mystery and investigate a problem in episode two in the seven-part first series of Global Problem Solvers. After finding the missing girls at a far-away well, the group...
4 mins 6th - 12th Career & Technical Education
CCSS: Adaptable
Lesson Plan

Using an Excel Checkbook

Council for Economic Education
High school is the time that many scholars get their first jobs. Help young entrepreneurs apply economic principles to crucial skills for their new jobs and for functioning in society in general. They use Excel to balance a checkbook by...
9th - 12th Math
CCSS: Adaptable
Instructional Video

Episode 2.2: The Problem

Cisco
School's out ... forever? Episode two in a seven-part Global Problem Solvers series follows the team as they touch down in hurricane-ravaged Tampa. After meeting with a local principal and teacher, the group begins to formulate a plan to...
4 mins 6th - 12th Career & Technical Education
CCSS: Adaptable
Lesson Plan

Inserting Formulas in a Worksheet in Excel

Curated OER
Ninth graders study the vocabulary necessary to create formulas in Microsoft Excel. They complete assigned problems from the textbook for each type of function demonstrated by the teacher until they have developed competency with each...
9th 21 Century Skills
Unit Plan

Ted: Ted Ed: Can You Solve the Stolen Rubies Riddle?

TED Talks
Townspeople are demanding that a corrupt merchant's collection of 30 rubies be confiscated to reimburse the victims of his schemes. The king announces that the fine will be determined through a game of wits between the merchant and the...
9th - 10th 21 Century Skills
Unit Plan

Ted: Ted Ed: Can You Solve the Egg Drop Riddle?

TED Talks
The city has just opened its one-of-a-kind Faberge Egg Museum, with a single egg displayed on each floor of a 100-story building- and the world's most notorious jewel thief already has her eyes on the prize. Can you help the thief...
9th - 10th 21 Century Skills
Article

Interaction Design Foundation: What Is a Wicked Problem and How Can You Solve It?

Other
Have you ever come across a problem so complex that you struggled to know where to start? Then you have stumbled upon a wicked problem. While these problems may not have a definite solution, there are certainly things you can do to...
9th - 10th 21 Century Skills
Instructional Video

Episode 2.3: The Solution

Cisco
When times get tough, divide and conquer! The third of seven episodes in Global Problem Solver's second season shows the team working toward a solution for displaced pupils and teachers. After dividing into two teams, the Problem Solvers...
4 mins 6th - 12th Career & Technical Education
CCSS: Adaptable
Try It Free
© 1999-2026 Learning Explorer, Inc.
Teacher Lesson Plans, Worksheets and Resources

Sign up for the Lesson Planet Monthly Newsletter

Open Educational Resources (OER)

  • Health
  • Language Arts
  • Languages
  • Math
  • Physical Education
  • Science
  • Social Studies
  • Special Education
  • Visual and Performing Arts
View All Lesson Plans

Discover Resources

  • Our Review Process
  • How it Works
  • How to Search
  • Create a Collection

Manage Curriculum

  • Edit a Collection
  • Assign to Students
  • Manage My Content
Contact Us Site Map Privacy Policy Terms of Use