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
Do Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions Unit PlanDo Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions Unit Plan
Publisher
Department of Defense
Resource Details
Curator Rating
Educator Rating
Not yet Rated
Grade
9th - 10th
Subjects
21 Century Skills
1 more...
Resource Type
Unit Plans
Audiences
For Administrator Use
2 more...
Lexile Measures
1190L
Unit Plan

Do Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions

Curated by ACT

In Module 2 Lesson 3 of this course on spreadsheets, students learn how to save time when setting up a spreadsheet by copying functions and formulas. Includes slideshow tutorials.

3 Views 0 Downloads
CCSS: Designed

Concepts

microsoft excel

Additional Tags

absolute cell formula, cell references, relative cell reference, using formulas, department of defense education activity, dodea: spreadsheet software: m2: l3: working smarter: copy formulas and functions, excel functions, spreadsheet software applications, formulas in excel, spreadsheets / databases in the classroom

Classroom Considerations

  • Knovation Readability Score: 4 (1 low difficulty, 5 high difficulty)
  • The intended use for this resource is Instructional

See similar resources:

Unit Plan

Do Dea: Spreadsheet Software: M5: L3: Customization: Modifying a Worksheet

Department of Defense
In Module 5 Lesson 3 of this course on spreadsheets, students learn how to work with two or more spreadsheet workbooks at the same time where they have related data and how to create different customized views. Includes slideshow tutorials.
9th - 10th 21 Century Skills
Unit Plan

Do Dea: Spreadsheet Software: M6: L3: Outside the Box: Get External Data

Department of Defense
In Module 6 Lesson 3 of this course on spreadsheets, students will learn how to import data that is in different formats and from a variety of sources, and transpose and format it. Includes slideshow tutorials.
9th - 10th 21 Century Skills
Unit Plan

Do Dea: Spreadsheet Software: M2: L5: Show Me Your Skills: Practice Skills

Department of Defense
In Module 2 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about formulas, functions, and manipulating a spreadsheet. Content is stored in the Resources section. Practice...
9th - 10th 21 Century Skills
CCSS: Designed
Unit Plan

Do Dea: Spreadsheet Software: M2: L2: Shortcuts Anyone? Calculate With Functions

Department of Defense
In Module 2 Lesson 2 of this course on spreadsheets, students learn how to use the built-in functions in Excel so that they don't have to retype a formula each time they use it. Includes slideshow tutorials.
9th - 10th 21 Century Skills
CCSS: Designed
Unit Plan

Do Dea: Spreadsheet Software: M2: L1: From the Ground Up: Create Basic Formulas

Department of Defense
In Module 2 Lesson 1 of this course on spreadsheets, students begin learning how to create formulas in a spreadsheet. They learn also about the importance of remembering the correct order of operations. Includes slideshow tutorials.
9th - 10th 21 Century Skills
Unit Plan

Do Dea: Spreadsheet Software: M3: L2: In the Library: Calculate With Functions

Department of Defense
In Module 3 Lesson 2 of this course on spreadsheets, students learn about naming cells and cell ranges and how a name moves with the range it is attached to. Names can also be used in constructing absolute cell reference formulas....
9th - 10th 21 Century Skills
Unit Plan

Do Dea: Spreadsheet Software: M5: L4: Work With Me! Collaboration Options

Department of Defense
In Module 5 Lesson 4 of this course on spreadsheets, students will learn how to collaborate on a spreadsheet document while working from different locations. Includes slideshow tutorials.
9th - 10th 21 Century Skills
Unit Plan

Do Dea: Spreadsheet Software: M3: L3: Can You Draw It? Working With Shapes

Department of Defense
In Module 3 Lesson 3 of this course on spreadsheets, students learn how to insert shapes into a spreadsheet and enhance them by resizing, rotating, changing line width, adding color and text, etc. Includes slideshow tutorials.
9th - 10th 21 Century Skills
Unit Plan

Do Dea: Spreadsheet Software: M4: L3: What's That Layout? Enhancing Charts

Department of Defense
In Module 4 Lesson 3 of this course on spreadsheets, students learn how to use advanced features of Excel to simplify analysis of their data, for example, to make predictions about future trends or to take mini-snapshots of data trends...
9th - 10th 21 Century Skills
CCSS: Designed
Unit Plan

Do Dea: Spreadsheet Software Applications: M2: L4: Manipulate Data

Department of Defense
In Module 2 Lesson 4 of this course on spreadsheets, students learn how to alter the information in a spreadsheet by manipulating it and formatting. Includes slideshow tutorials.
9th - 10th 21 Century Skills
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