Learn-by-Doing: Microsoft Excel 2013 is one of the five titles in the Learn-by-Doing: Microsoft Office 2013 Series, where students are introduced to Microsoft Excel 2013 using a hands-on, learn-by-doing approach.
This web-based title uses school and workplace themed lessons to introduce students to the powerful tools and features of Microsoft Excel 2013. Each new set of Excel 2013 skills are clearly explained using a step-by-step, illustrated format that makes learning come to life for the student.
Learn-by-Doing: Microsoft Excel 2013 (Level 1) is designed to be used by students enrolled in a computer applications course that includes spreadsheets in its curriculum. The lessons in this web-based content build upon one another. Skills and features are presented in an order ranging from basic to intermediate.
Benefits & Features
- Aligned to Common Core Standards
- Designed and formatted for today’s interactive, visual learner
- Teaches students basic to intermediate Microsoft Excel 2013 skills
- Lesson content is customized with school and workplace themes
- Includes 30 easy-to-follow lessons
- Includes a comprehensive Curriculum Guide for mapping skills
- All Assignments Submitted Online (from Student Portal to Instructor Portal)
- No textbooks or paper required
Lesson 2
American Top 40 Music
Lesson 3
American Top 40 Music 2
Included with Your Purchase
- 24/7 access from anywhere, any device
- Written and Performance Unit Assessments
- Student Project Solutions
- Unit Written Assessments and Solutions
Specifications
Grade: 6-8, 9-12
Item #: TB-EXL2013-iA
ISBN: 978-1-626890-89-3
Author: Martha McGuinness and the Development Team at B.E. Publishing
Introduction
The Learn-by-Doing Series
Unit 1: Worksheet Basics
Lesson 1
Navigating Excel
View Skills
Skills
-
Opening a Blank Workbook
-
Identifying Ribbons, Tabs, & Groups
-
Identifying the Name Box
-
Understanding Backstage View
-
Identifying Rows, Columns, & Cell Addresses
-
Using the Zoom Adjustment Tool
-
Closing Excel
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Lesson 2
American Top 40 Music
View Skills
Skills
-
Creating a Blank Workbook
-
Saving a Worksheet
-
Closing a Worksheet
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Lesson 3
American Top 40 Music 2
View Skills
Skills
-
Opening an Existing Workbook
-
Revising an Existing Worksheet
-
Using Save As
-
Previewing and Printing a Worksheet
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Lesson 4
Boston Bruins Roster
View Skills
Skills
-
Resizing Rows and Columns Manually
-
Inserting Rows and Columns
-
Deleting Rows and Columns
Lesson 5
Boston Bruins Roster 2
View Skills
Skills
-
Using Cut
-
Using Copy
-
Using Paste
-
Using Undo & Redo
-
Selecting Text
Lesson 6
Top Twitter Accounts
View Skills
Skills
-
Using Spellcheck
-
Using the Thesaurus
Unit 1
Written Assessment
Unit 1
Performance Assessment
Unit 2: Formatting Data
Lesson 7
Multiplication Tables
View Skills
Skills
-
Changing Font
-
Changing Font Size
-
Changing Font Color
-
Applying Bold, Italic, and Underline
-
Formatting Row Height and Column Width
Lesson 8
Calendar
View Skills
Skills
-
Adding Borders
-
Applying Fill Color
-
Increasing Font Size
-
Decreasing Font Size
Lesson 9
Address Book
View Skills
Skills
-
Applying Horizontal Cell Alignment
-
Applying Vertical Cell Alignment
Lesson 10
Pizza Recipe
View Skills
Skills
-
Using the Orientation Alignment Tool
-
Increasing Indent
-
Decreasing Indent
-
Using Wrap Text
-
Using Merge and Center
Lesson 11
Best Netflix TV Series
View Skills
Skills
-
Using the Format Cells Dialog Box
Unit 2
Written Assessment
Unit 2
Performance Assessment
Unit 3: Page Layout Options
Lesson 12
Pizza Recipe 2
View Skills
Skills
-
Changing Margins
-
Changing Page Orientation
-
Setting Print Area
Lesson 13
Roller Coasters
View Skills
Skills
-
There are no new skills being introduced in this lesson.
Lesson 14
The 50 States
View Skills
Skills
-
Changing Page Width
-
Changing Page Height
-
Changing Page Scale
Lesson 15
Top Online Shopping Sites
View Skills
Skills
-
Printing Gridlines
-
Printing Row & Column Headings
Unit 3
Written Assessment
Unit 3
Performance Assessment
Unit 4: Working with Numbers & Formulas
Lesson 16
Top Grossing Movies
View Skills
Skills
-
Applying Accounting Number Format
-
Applying Percent Style
-
Applying Comma Style
-
Applying Increase/Decrease Decimal
-
Clearing All Formatting
Lesson 17
Top Grossing Movies 2
View Skills
Lesson 18
Best-Selling PlayStation 4 Games
View Skills
Lesson 19
Budget
View Skills
Skills
-
Using Basic Formulas: Addition, Subtraction, Multiplication, and Division
Lesson 20
Math Quiz Grades
View Skills
Skills
-
Using Auto Fill
-
Using Copy Formulas
-
Using Paste Formulas
Lesson 21
SAT Scores
View Skills
Skills
-
Using AutoSum
-
Using Sum
-
Using Average
-
Using Minimum
-
Using Maximum
Lesson 22
Gradebook
View Skills
Lesson 23
Final Exam Schedule
View Skills
Skills
-
Formatting Date
-
Formatting Time
Unit 4
Written Assessment
Unit 4
Performance Assessment
Unit 5: Working with Shapes & Elements
Lesson 24
Buying a Car
View Skills
Lesson 25
Buying a Car 2
View Skills
Skills
-
Inserting Online Pictures
-
Inserting Shapes
-
Inserting SmartArt
Lesson 26
Top Liberal Arts Colleges
View Skills
Lesson 27
Gradebook 2
View Skills
Skills
-
Renaming Worksheets
-
Adding Worksheets
-
Printing Multiple Worksheets
Lesson 28
Purchase Order
View Skills
Skills
-
Inserting a Text Box
-
Inserting a Header & Footer
-
Using WordArt
-
Inserting a Signature Line
Lesson 29
Flash Cards
View Skills
Skills
-
Inserting Symbols
-
Using Paste Options
Unit 5
Written Assessment
Unit 5
Performance Assessment
Unit 6: Working with Charts & Graphs
Lesson 30
Skittles
View Skills
Skills
-
Inserting a Pie Chart
-
Formatting a Pie Chart
Lesson 31
Best-Selling Albums
View Skills
Skills
-
Inserting a Column Chart
-
Formatting a Column Chart
Lesson 32
Winter Olympic Games
View Skills
Skills
-
Inserting a Line Chart
-
Formatting a Line Chart
Lesson 33
Snowiest Cities
View Skills
Skills
-
Inserting a Bar Chart
-
Formatting a Bar Chart
Lesson 34
NBA Results
View Skills
Skills
-
Inserting a Win/Loss Sparkline
Unit 6
Written Assessment
Unit 6
Performance Assessment