Web-based Career & Technical Education

ITEM #: TB-BIM-iA

Business Information Management

A web-based textbook where students use their personal and computer applications skills to prepare for the workplace

View Table of Contents

In this new textbook, students will use their personal and computer applications skills as they produce professional documents. With a strong focus on workplace readiness and communication and writing skills, students will reinforce their touch typing skills, create word processing documents, develop spreadsheets, build databases, design digital publishing documents, and make digital presentations using the appropriate software for the task at hand.

Students will also explore the vital role technology has in the workplace, as well as learn the various hardware and software tools that are available today. This textbook culminates with students working in teams while collaborating on a final project.

Benefits & Features

Use with Microsoft Office, Google Docs, or equivalent applications
Hands-on school and workplace-themed projects using touch typing, word processing, databases, spreadsheets, presentations, digital publishing, and software integration
Concludes with a final project where students collaborate as they work in teams
All Assignments Submitted Online (from Student Portal to Instructor Portal)
No textbooks or paper required

Sample Lessons

View Table of Contents

Part 1

The Importance of Professionalism

Part 2

Soft Skills in the Workplace

Part 1

Technology in the Workplace

Part 2

Information Systems & Communication Technology

Part 1

Information Technology Requirements

Part 2

Planning and Setting Up Information Systems

Lesson 4.1

Unit Directories

Lesson 5.1

My Favorite Things

Lesson 5.2

Super Cuts

Lesson 5.3

State Symbols

Lesson 5.4

How to Build a Website

Lesson 5.5

Fortune 500 Top 10 Companies

Lesson 5.6

The Hunger Games

Lesson 5.7

The Voice

Lesson 5.8

Movie Summary

Lesson 5.9

Taking a Vacation

Learning About Databases

Lesson 6.1

Address Book

Lesson 6.2

Address Book 2

Lesson 6.3

Colleges

Lesson 6.4

Favorite U.S. Roller Coasters

Lesson 6.5

Address Book 3

Lesson 6.6

Sales at the School Store

Lesson 6.7

Income

Lesson 6.8

Concerts

Lesson 6.9

Multiple Oscar Winners

Lesson 7.1

Generation What?

Lesson 7.2

NBA Hall of Fame

Lesson 7.3

So You Think You Can Dance Season Winners

Lesson 7.4

Best-Selling Books

Lesson 7.5

Best-Selling Books 2

Lesson 7.6

Amazon

Lesson 7.7

Market Analysis

Lesson 7.8

AT40

Lesson 7.9

TV Legend Interviews

Lesson 7.10

Excel Art

Lesson 8.1

Employee Welcome

Lesson 8.2

Employee Welcome 2

Lesson 8.3

Choosing a College Major

Lesson 8.4

Geometric Shapes

Lesson 8.5

Geometric Shapes 2

Lesson 8.6

Building a House

Lesson 9.1

Toy Drive

Lesson 9.2

Toy Drive 2

Lesson 9.3

Science Fair Tips

Lesson 9.4

Coffee Mug Design

Lesson 9.5

Coffee Mug Design 2

Lesson 9.6

Lunch Menu

Lesson 9.7

Note Card

Lesson 9.8

Beginners Design Tips

Lesson 9.9

Doorknob Hanger

Lesson 9.10

Join the Club!

Lesson 9.11

Fall Festival Flyer

Part 1

What is the Pitch It! Project?

Part 2

Working in Teams

Part 3

Required Setup Instructions

Project 10.2

What's the Big Idea?

View Print/eBook Version »

Included with Your Purchase

24/7 access from anywhere, any device
Student Project Solutions

Specifications

Grade: 6-8, 9-12

Item #: TB-BIM-iA

ISBN: 978-1-626891-28-9

Author: The Development Team at B.E. Publishing

Introduction

Welcome to Business Information Management

Unit 1: Professionalism in the Workplace

Part 1 The Importance of Professionalism View Skills

Skills

TEKS: 1.A.i, 1.A.ii, 1.B.i, 1.C.i, 1.C.ii, 1.D.i, 1.E.i, 1.E.ii, 1.E.iii, 1.F.i, 1.F.ii, 1.F.iii, 1.F.iv, 1.F.v

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Part 2 Soft Skills in the Workplace View Skills

Skills

TEKS: 1.A.i, 1.A.ii, 1.B.i, 1.C.i, 1.C.ii, 1.D.i, 1.E.i, 1.E.ii, 1.E.iii, 1.F.i, 1.F.ii, 1.F.iii, 1.F.iv, 1.F.v

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Part 3 Rules and Regulations in the Workplace View Skills

Skills

TEKS: 1.A.i, 1.A.ii, 1.B.i, 1.C.i, 1.C.ii, 1.D.i, 1.E.i, 1.E.ii, 1.E.iii, 1.F.i, 1.F.ii, 1.F.iii, 1.F.iv, 1.F.v

Unit 1 Review

Unit 1 Assessment

Unit 2: Information Systems

Part 1 Technology in the Workplace View Skills

Skills

TEKS: 2.A.i, 2.A.ii, 2.B.i, 2.B.ii, 2.B.iii, 2.B.iv, 2.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Part 2 Information Systems & Communication Technology View Skills

Skills

TEKS: 2.A.i, 2.A.ii, 2.B.i, 2.B.ii, 2.B.iii, 2.B.iv, 2.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Part 3 Technology Benefits and Drawbacks View Skills

Skills

TEKS: 2.A.i, 2.A.ii, 2.B.i, 2.B.ii, 2.B.iii, 2.B.iv, 2.C.i

Part 4 Integrating Information Systems into Business View Skills

Skills

TEKS: 2.A.i, 2.A.ii, 2.B.i, 2.B.ii, 2.B.iii, 2.B.iv, 2.C.i

Unit 2 Review

Unit 2 Assessment

Unit 3: Managing Information Systems

Part 1 Information Technology Requirements View Skills

Skills

TEKS: 3.A.i, 3.A.ii, 3.B.i, 3.B.ii, 4.A.i, 4.A.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Part 2 Planning and Setting Up Information Systems View Skills

Skills

TEKS: 3.A.i, 3.A.ii, 3.B.i, 3.B.ii, 4.A.i, 4.A.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Part 3 Managing Information Systems View Skills

Skills

TEKS: 3.A.i, 3.A.ii, 3.B.i, 3.B.ii, 4.A.i, 4.A.ii

Unit 3 Review

Unit 3 Assessment

Unit 4: File Management

Part 1: The Computer File System

File System Basics View Skills

Skills

TEKS: 5.A.i, 5.B.i, 5.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Part 2: The Importance of an Organized File System

The Basics of File Management View Skills

Skills

TEKS: 5.A.i, 5.B.i, 5.C.i

Part 3: File Management Lessons

Lesson 4.1 Unit Directories View Skills

Skills

Creating a File Directory
Capturing a Screenshot
TEKS: 5.B.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 4.2 File Formats View Skills

Skills

Saving Files in Different Formats
TEKS: 5.B.i, 5.C.i

Lesson 4.3 Organizing Files View Skills

Skills

Copying and Moving Files
TEKS: 5.A.i, 5.B.i

Assessment

Unit 4 Assessment

Unit 5: Word Processing

Part 1: Introduction to Word Processing

Learning About Word Processing View Skills

Skills

TEKS: 6.A.i, 6.B.i, 6.B.ii, 6.C.i, 6.C.ii, 6.E.i, 6.E.ii, 6.E.iii, 6.E.iv, 6.F.i, 6.G.i, 6.G.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 5 Part 1 Assessment

Part 2: Document Basics & Formatting

Lesson 5.1 My Favorite Things View Skills

Skills

Creating, Naming, and Saving a Document
Revising, Renaming, and Saving an Existing Document
Changing Font and Font Size
Printing a Document
Closing a Document
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.D.i, 6.F.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 5.2 Super Cuts View Skills

Skills

Applying Bold, Italics, and Underline
Increasing and Decreasing Font Size
Aligning Text
Using Cut, Copy, and Paste
Creating a Numbered List
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.D.i, 6.F.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 5.3 State Symbols View Skills

Skills

Changing Font Color
Changing Text Case
Inserting a Symbol
Applying Strikethrough
Inserting a Standard and Customized Bullet
Applying a Border
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 5.4 How to Build a Website View Skills

Skills

Inserting a Page Break
Inserting a Bookmark
Hyperlinking Text to a Bookmark
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i, 6.G.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 5.5 Fortune 500 Top 10 Companies View Skills

Skills

Hyperlinking Text to a Website Address
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i, 6.G.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 5 Part 2 Assessment

Part 3: Formatting Paragraphs & Editing Text

Lesson 5.6 The Hunger Games View Skills

Skills

Using Find and Replace
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 5.7 The Voice View Skills

Skills

Using Spelling and Grammar Check
Using the Thesaurus Tool
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 5.8 Movie Summary View Skills

Skills

Changing Paragraph Line Spacing
Writing a Summary
Using Word Count
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.D.i, 6.D.ii, 6.F.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 5.9 Taking a Vacation View Skills

Skills

Formatting Numbered Lists
Using Bullets
Formatting Customized Bullets
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 5 Part 3 Assessment

Part 4: Working with Tables and Columns

Lesson 5.10 Celebrities and Their Pets View Skills

Skills

Inserting Tables
Shading Cells, Rows, and Columns
Inserting Rows
Merging Cells
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i, 6.G.i, 6.G.ii

Lesson 5.11 Homework Planner View Skills

Skills

Changing Column Width
Changing Cell Alignment
Changing Row Height
Changing Text Direction
Inserting an Image in a Table
Centering a Table Horizontally
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i, 6.G.i, 6.G.ii

Lesson 5.12 So You Think You Can Dance View Skills

Skills

Creating Two Columns
Justifying Text
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Unit 5 Part 4 Assessment

Part 5: Working with Tabs

Lesson 5.13 Video Game Ratings View Skills

Skills

Setting Left, Right, and Center Tabs
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Lesson 5.14 Social Media for Teens View Skills

Skills

Using Dot Leaders
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Unit 5 Part 5 Assessment

Part 6: Using Headers, Footers, & Page Setup

Lesson 5.15 From the Top to the Bottom View Skills

Skills

Inserting a Header
Inserting a Footer
Inserting Page Numbers
Inserting the Date
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.G.i

Lesson 5.16 School Lunch Menu View Skills

Skills

Formatting Page Orientation
Setting Custom Margins
Adding a Page Border
Centering Text Vertically
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Unit 5 Part 6 Assessment

Part 7: Working with Graphics and Visual Elements

Lesson 5.17 Spring Scene View Skills

Skills

Using Shapes
Using Shape Effects
Changing Shape Fill
Changing Shape Outline
Resizing Shapes
Grouping Shapes
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.G.i, 6.G.ii

Lesson 5.18 Dynamic Desktop View Skills

Skills

Inserting a Picture
Resizing a Picture
Rotating a Picture
Using Layout Options
Applying a Border to a Picture
TEKS: 6.C.i, 6.C.ii, 6.G.i, 6.G.ii

Lesson 5.19 Right Here, Right Now View Skills

Skills

Inserting a Text Box
Resizing Text Boxes
Wrapping Text Within a Text Box
Grouping a Text Box with Other Objects
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.D.i, 6.D.iii, 6.F.i, 6.G.i, 6.G.ii

Lesson 5.20 Days of the Week View Skills

Skills

Using WordArt
Formatting a Drop Cap
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Lesson 5.21 Logo Links View Skills

Skills

Hyperlinking Images to Websites
TEKS: 6.C.i, 6.C.ii, 6.G.i

Lesson 5.22 SWOT Analysis Diagram View Skills

Skills

Creating and Saving a Template
Aligning Objects
TEKS: 6.C.i, 6.C.ii, 6.F.i

Unit 5 Part 7 Assessment

Part 8: Creating Professional Documents

Lesson 5.23 Professional Business Documents View Skills

Skills

Identifying Business Documents
TEKS: 6.A.i, 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Lesson 5.24 Recommendation Letter View Skills

Skills

Writing an Effective Letter of Request
Formatting a Block Style Letter
Creating a Mail Merge for Letters
TEKS: 6.A.i, 6.B.i, 6.C.i, 6.C.ii, 6.D.iii, 6.E.i, 6.F.i, 6.H.i, 6.H.ii

Lesson 5.25 New Menu Announcement View Skills

Skills

Formatting a Press Release
TEKS: 6.A.i, 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Lesson 5.26 Spirit Week Memo View Skills

Skills

Formatting a Memo
TEKS: 6.A.i, 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Lesson 5.27 School Newsletter View Skills

Skills

Formatting a Newsletter
TEKS: 6.A.i, 6.B.i, 6.C.i, 6.C.ii, 6.E.iv, 6.F.i

Lesson 5.28 Knowledge College Letterhead View Skills

Skills

Creating Business Letterhead
TEKS: 6.C.i, 6.C.ii, 6.G.i, 6.G.ii

Lesson 5.29 Business Card View Skills

Skills

Creating a Business Card
TEKS: 6.A.i, 6.C.i, 6.C.ii, 6.F.i

Lesson 5.30 Promotional Flyer View Skills

Skills

Creating and Designing a Flyer
Selecting a Shadow and Dash Style
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i

Lesson 5.31 Resume View Skills

Skills

Creating and Formatting a Resume
TEKS: 6.A.i, 6.B.i, 6.C.i, 6.C.ii, 6.E.ii, 6.F.i

Lesson 5.32 Social Media Today View Skills

Skills

Formatting a Report in MLA Style
TEKS: 6.A.i, 6.B.i, 6.C.i, 6.C.ii, 6.E.iii, 16.F.i

Lesson 5.33 Knowledge College Majors View Skills

Skills

Creating, Editing, and Sharing an Online Word Processing Document
Collaborating Using Online Word Processing Software
TEKS: 6.B.i, 6.C.i, 6.C.ii, 6.F.i, 6.I.i, 6.I.ii, 6.I.iii

Unit 5 Part 8 Assessment

Unit 6: Databases

Part 1: Introduction to Databases

Learning About Databases View Skills

Skills

TEKS: 7.A.i, 7.B.i, 7.C.i, 7.D.i, 7.D.ii, 7.E.i, 7.F.i, 7.G.i, 8.A.i, 8.B.i, 9.A.i, 10.A.i, 10.B.i, 10.C.i, 10.D.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 6 Part 1 Assessment

Part 2: Creating Tables Using Datasheet View

Lesson 6.1 Address Book View Skills

Skills

Creating a Blank Database
Naming and Saving a Database
Defining the Structure of a Database
Selecting Data Types
Naming and Creating Fields
Naming and Saving a Table
Adjusting Column Widths
Printing a Table
Closing a Database
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 6.2 Address Book 2 View Skills

Skills

Opening an Existing Database
Adding New Fields
Using New Data Types
Formatting a Date/Time Field
Formatting a Yes/No Field
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 6.3 Colleges View Skills

Skills

Formatting Currency Fields
Using Hyperlinks
Formatting Number Fields
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 6.4 Favorite U.S. Roller Coasters View Skills

Skills

Deleting Fields
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 6.5 Address Book 3 View Skills

Skills

Applying Bold and Italics
Changing Font and Font Size
Changing Alignment
Changing Font Color
Using Find and Replace
Sorting Ascending and Descending
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i, 8.C.iii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 6 Part 2 Assessment

Part 3: Creating Tables Using Design View

Lesson 6.6 Sales at the School Store View Skills

Skills

Creating Tables Using Design View
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 6.7 Income View Skills

Skills

Adding a Field Description
Setting a Field Size
Inserting/Deleting Fields
Moving Fields
Naming and Creating Fields in Design View
Exporting a Table from a Database
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 6.8 Concerts View Skills

Skills

Changing Data Types
Applying a Selection Filter
Using Toggle Filter
Formatting Number View
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i, 8.D.ii, 9.A.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 6.9 Multiple Oscar Winners View Skills

Skills

Using Cut, Copy, and Paste
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 6 Part 3 Assessment

Part 4: Working with Queries

Lesson 6.10 Winter Olympics and Paralympics View Skills

Skills

Using Multiple Tables
Using the Query Wizard
Running a Query
Sorting Query Results
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i, 9.A.ii, 9.B.i

Lesson 6.11 James Bond Movies View Skills

Skills

Using Query Design View
Viewing Queries
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i, 9.B.i

Unit 6 Part 4 Assessment

Part 5: Creating Forms & Reports

Lesson 6.12 Cars View Skills

Skills

Using Criteria to Filter Records
Using the Form Wizard
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i, 8.C.ii, 9.B.i

Lesson 6.13 Entertainment Data Warehouse View Skills

Skills

Using Find Duplicates Query
Using the Report Wizard
Using the External Data Wizard
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.B.i, 8.D.i, 8.D.ii, 9.B.i, 9.C.i, 9.C.ii

Lesson 6.14 Graduation Announcements View Skills

Skills

Using the Label Wizard
TEKS: 7.D.i, 7.D.ii, 7.E.i, 8.A.i, 8.C.i, 9.B.i

Lesson 6.15 TechieTs.com View Skills

Skills

Designing and Creating a Database Based on a Business’s Requirements
TEKS: 7.D.i, 7.D.ii, 7.E.i, 7.G.i, 7.H.i, 8.A.i, 8.C.i

Unit 6 Part 5 Assessment

Review

Unit 6 Review

Unit 7: Spreadsheets

Part 1: Introduction to Spreadsheets

Learning About Spreadsheets View Skills

Skills

TEKS: 6.B.ii, 11.C.i, 11.C.ii, 11.C.iii, 11.D.i, 11.D.ii, 11.D.iii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 7 Part 1 Assessment

Part 2: Worksheet Basics and Page Layout

Lesson 7.1 Generation What? View Skills

Skills

Creating, Naming, and Saving a Workbook
Identifying Rows, Columns, and Cell Addresses
Previewing and Printing a Worksheet
Closing a Worksheet
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 7.2 NBA Hall of Fame View Skills

Skills

Resizing Rows and Columns
Centering Text Vertically in a Cell
Wrapping Text in a Cell
Setting the Print Area
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 7.3 So You Think You Can Dance Season Winners View Skills

Skills

Inserting and Deleting Rows
Selecting Cells
Using Cut
Using Copy
Using Paste
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 7.4 Best-Selling Books View Skills

Skills

Inserting and Deleting Columns
Freezing Panes
Adding Worksheets
Renaming a Worksheet
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 7.5 Best-Selling Books 2 View Skills

Skills

Revising, Renaming, and Saving an Existing Workbook
Using Spell Check and Thesaurus
Changing Page Orientation
Adjusting Page Scaling
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 7.6 Amazon View Skills

Skills

Inserting a Header
Inserting a Footer
Changing Page Margins
Printing Gridlines
Printing Row and Column Headings
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 7 Part 2 Assessment

Part 3: Formatting Data

Lesson 7.7 Market Analysis View Skills

Skills

Changing Font
Changing Font Size
Applying Bold, Italics, and Underline
Aligning Text in Columns Horizontally
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 7.8 AT40 View Skills

Skills

Formatting Cells as Text
Centering on a Page Horizontally and Vertically
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 7.9 TV Legend Interviews View Skills

Skills

Formatting Cells as Duration
Using Merge and Center
Adding Borders
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 7.10 Excel Art View Skills

Skills

Applying Fill Color
Applying Font Color
TEKS: 6.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 7 Part 3 Assessment

Part 4: Working with Numbers and Formulas

Lesson 7.11 Forever 21 View Skills

Skills

Formatting Cells as Numbers with Zero Decimals
Increasing/Decreasing Decimal Places
TEKS: 6.B.ii

Lesson 7.12 Accounts Payable—Nike Store View Skills

Skills

Formatting Cells as Currency
Formatting Cells as Percentages
TEKS: 6.B.ii

Lesson 7.13 Top 10 Most Expensive Flights View Skills

Skills

Formatting Cells as Accounting
TEKS: 6.B.ii

Lesson 7.14 Party Invitation List View Skills

Skills

Sorting Data in Ascending Order
Sorting Data in Descending Order
Selecting Non-Adjacent Cells
TEKS: 6.B.ii

Lesson 7.15 You Say It’s Your Birthday View Skills

Skills

Formatting Cells as Dates
TEKS: 6.B.ii

Lesson 7.16 Major Holidays View Skills

Skills

Using AutoFill to Complete a Sequence
TEKS: 6.B.ii

Lesson 7.17 Presentation Rubric View Skills

Skills

Using Basic Formulas: Addition
Copying and Pasting Formulas
Displaying Formulas
Using Cell References
TEKS: 6.B.ii

Lesson 7.18 My Check Register View Skills

Skills

Using AutoSum
Using SUM
Using Basic Formulas: Subtraction
TEKS: 6.B.ii

Lesson 7.19 Town Camp Summer Payroll View Skills

Skills

Using Basic Formulas: Multiplication
Using Parentheses for Multi-Math Formulas
TEKS: 6.B.ii

Lesson 7.20 Event Budget View Skills

Skills

There are no new skills being introduced in this reinforcement lesson.
TEKS: 6.B.ii

Lesson 7.21 Basic Baseball Stats View Skills

Skills

Using Basic Formulas: Division
TEKS: 6.B.ii

Lesson 7.22 Accounts Payable View Skills

Skills

Using Average, Maximum, and Minimum
TEKS: 6.B.ii

Lesson 7.23 Skittles View Skills

Skills

Formatting Cells as Fractions
TEKS: 6.B.ii

Lesson 7.24 Sales Projection View Skills

Skills

Using Absolute Cell References
TEKS: 6.B.ii

Lesson 7.25 Forever 21 Part 2 View Skills

Skills

Using the COUNTIF Function
TEKS: 6.B.ii

Lesson 7.26 The Ultimate Pay Raise View Skills

Skills

Using Conditions in Formulas
TEKS: 6.B.ii

Lesson 7.27 Dream House Mortgage View Skills

Skills

Using the Payment (PMT) Function
TEKS: 6.B.ii

Lesson 7.28 College Savings View Skills

Skills

Using the Future Value (FV) Function
TEKS: 6.B.ii

Lesson 7.29 Town Camp Summer Payroll Part 2 View Skills

Skills

Using the ROUND Function
Rotating Cell Orientation
TEKS: 6.B.ii

Lesson 7.43 Student Enrollment View Skills

Skills

Creating a Forecast Worksheet
TEKS: 11.A.v

Lesson 7.44 2016 World Series Champions View Skills

Skills

Creating Complex Formulas
TEKS: 11.A.iii

Lesson 7.45 Ice Cream Shop Inventory View Skills

Skills

Using the Forecast Function
TEKS: 11.A.iv

Lesson 7.46 Teen World Payroll Register View Skills

Skills

Identifying and Using Appropriate Formulas
TEKS: 11.B.i, 11.B.ii

Unit 7 Part 4 Assessment

Part 5: Working with Shapes and Elements

Lesson 7.30 Dinner Menu View Skills

Skills

Inserting a Clip Art Image
TEKS: 6.B.ii

Lesson 7.31 Paying the Bills View Skills

Skills

Inserting and Removing Comments or Notes for Cells
TEKS: 6.B.ii

Lesson 7.32 Take a Ride View Skills

Skills

Inserting WordArt
TEKS: 6.B.ii

Lesson 7.33 Binge Watch List View Skills

Skills

Inserting Shapes
TEKS: 6.B.ii

Lesson 7.34 Shoes, Shoes, Shoes! View Skills

Skills

Referencing Cells from Other Worksheets
Printing Multiple Worksheets
TEKS: 6.B.ii

Unit 7 Part 5 Assessment

Part 6: Working with Charts and Graphs

Lesson 7.35 Most Popular Features View Skills

Skills

Inserting a Pie Chart
Formatting a Pie Chart
TEKS: 6.B.ii, 11.C.i

Lesson 7.36 Sales History View Skills

Skills

Creating a Line Graph
Formatting a Line Graph
Using the Fill Effects Feature in a Graph
TEKS: 6.B.ii, 11.C.ii

Lesson 7.37 Sales Forecast View Skills

Skills

Creating a Column Chart
Formatting a Column Chart
Aligning Text in a Chart
TEKS: 6.B.ii, 11.C.i

Lesson 7.38 Fast-Food Nutrition View Skills

Skills

Inserting a Bar Chart
Formatting a Bar Chart
TEKS: 6.B.ii, 11.C.i

Lesson 7.39 Exercise Habits View Skills

Skills

Inserting an Exploded Pie Chart
Formatting an Exploded Pie Chart
TEKS: 6.B.ii, 11.C.i

Lesson 7.40 Customer Traffic Pattern Analysis View Skills

Skills

Creating, Editing, and Sharing an Online Spreadsheet
Collaborating Using Online Spreadsheet Software
TEKS: 6.B.ii, 11.D.i, 11.D.ii, 11.D.iii

Lesson 7.41 Competitive Pricing Comparisons View Skills

Skills

Creating a Bar Chart in an Online Spreadsheet
TEKS: 6.B.ii, 11.D.i, 11.D.ii, 11.D.iii

Lesson 7.42 Comparing Enrollment View Skills

Skills

Creating an Infographic
Formatting an Infographic
TEKS: 6.B.ii, 11.C.iii

Unit 7 Part 6 Assessment

Unit 8: Presentations

Part 1: Introduction to Presentations

Learning About Presentations View Skills

Skills

TEKS: 12.A.i, 12.A.ii, 12.A.iii, 12.B.i, 12.C.i, 12.C.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 8 Part 1 Assessment

Part 2: Presentation Basics

Lesson 8.1 Employee Welcome View Skills

Skills

Creating a Blank Presentation
Saving a Presentation
Changing Font and Font Size
Inserting New Slides
Viewing a Slide Show
Closing a Presentation
Printing a Presentation
Using Bulleted Lists
Removing Bullets

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 8.2 Employee Welcome 2 View Skills

Skills

Opening an Existing Presentation
Revising an Existing Presentation
Using Save As
Changing Font Color
Applying Bold, Italic, Underline, and Text Shadow

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 8.3 Choosing a College Major View Skills

Skills

Using Numbered Lists
Increasing List Levels
Changing Line Spacing
Aligning Text

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 8 Part 2 Assessment

Part 3: Customizing Presentations

Lesson 8.4 Geometric Shapes View Skills

Skills

Inserting Basic Shapes
Resizing Shapes
Inserting a Text Box
Deleting a Slide
Aligning Text within a Text Box

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 8.5 Geometric Shapes 2 View Skills

Skills

Changing Shape Fill
Changing Shape Outline
Adding Text to a Shape
Using Shape Effects
Using Quick Styles

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 8.6 Building a House View Skills

Skills

Changing Shape Height
Changing Shape Width
Aligning Objects
Arranging Objects
Grouping Objects
Rotating Objects
Using Copy and Paste

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 8 Part 3 Assessment

Part 4: Enhancing Slide Elements

Lesson 8.7 Touring Washington, D.C. View Skills

Skills

Inserting Pictures
Cropping a Picture
Aligning Pictures
Using Picture Styles
Applying Picture Borders
Applying Picture Effects
Applying an Image as a Background

Lesson 8.8 The Impact of Scents View Skills

Skills

Using Footers
Changing Slide Layout
Using WordArt
Inserting and Formatting a Table
Inserting a Hyperlink
Changing Background Color

Unit 8 Part 4 Assessment

Part 5: Using Design Themes & Templates

Lesson 8.9 Individual Sports View Skills

Skills

Using Templates
Using Video in a Slide
Reordering Slides

Lesson 8.10 Team Sports View Skills

Skills

Applying a Slide Theme
Changing a Slide Theme

Unit 8 Part 5 Assessment

Part 6: Applying Transitions & Animations

Lesson 8.11 Individual Sports 2 View Skills

Skills

Applying Slide Transitions
Applying Effect Options to Transitions

Lesson 8.12 Team Sports 2 View Skills

Skills

Using Sound
Timing Transitions
Previewing Transitions

Lesson 8.13 Business Meeting Agenda View Skills

Skills

Applying Animation
Applying Effect Options to Animations
Previewing Animations
Reordering Animation

Unit 8 Part 6 Assessment

Part 7: Delivering Effective Presentations

Lesson 8.14 Presentation Tips View Skills

Skills

Working with Presentation Views
Using Slide Sorter View
Adding Notes to Slides
Using Notes Page View
Printing Slides with Notes
TEKS: 12.A.i, 12.A.ii, 12.A.iii, 12.E.i

Lesson 8.15 Kiosk Presentation View Skills

Skills

Setting Up a Slide Show
Rehearsing Timings for a Slide Show
Making Your Own Design Decisions

Lesson 8.16 My Kind of Town! View Skills

Skills

Creating, Editing, and Sharing an Online Presentation
Collaborating Using Online Presentation Software
TEKS: 12.F.i, 12.F.ii, 12.F.iv

Unit 8 Part 7 Assessment

Review

Unit 8 Review

Unit 9: Desktop Publishing

Part 1: Introduction to Desktop Publishing

Learning About Desktop Publishing View Skills

Skills

TEKS: 13.A.i, 13.B.i, 13.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 9 Part 1 Assessment

Part 2: Publication Basics

Lesson 9.1 Toy Drive View Skills

Skills

Creating a Blank Publication
Saving a Publication
Inserting and Moving Text Boxes

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 9.2 Toy Drive 2 View Skills

Skills

Opening an Existing Publication
Using Save As
Changing Font
Changing Font Size
Changing Font Color
Applying Bold, Italic, and Underline
Changing Alignment
Changing Case and Character Spacing
Resizing Text Boxes
Printing a Publication

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 9.3 Science Fair Tips View Skills

Skills

Creating Numbered and Bulleted Lists
Changing Line Spacing
Using Find and Replace
Using Print Preview

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 9.4 Coffee Mug Design View Skills

Skills

Changing Page Orientation
Inserting Shapes
Inserting, Resizing, and Cropping Pictures
Using Copy and Paste
Horizontally Flipping a Picture
TEKS: 13.C.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 9.5 Coffee Mug Design 2 View Skills

Skills

Changing Shape Fill and Outline
Changing Shape Size
Rotating a Shape
Using Horizontal Guides
Grouping Objects

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 9 Part 2 Assessment

Part 3: Designing Professional Documents

Lesson 9.6 Lunch Menu View Skills

Skills

Importing Text
TEKS: 13.C.i, 13.C.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 9.7 Note Card View Skills

Skills

Changing Text Direction
Inserting and Formatting a Picture Border
Setting Margins

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 9.8 Beginners Design Tips View Skills

Skills

There are no new skills being introduced in this reinforcement lesson.
TEKS: 13.B.i, 13.B.ii, 13.C.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 9.9 Doorknob Hanger View Skills

Skills

There are no new skills being introduced in this reinforcement lesson.

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 9.10 Join the Club! View Skills

Skills

There are no new skills being introduced in this reinforcement lesson.
TEKS: 13.C.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Lesson 9.11 Fall Festival Flyer View Skills

Skills

There are no new skills being introduced in this reinforcement lesson.
TEKS: 13.B.i, 13.B.ii

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Unit 9 Part 3 Assessment

Review

Unit 9 Review

Unit 10: Pitch It! Final Assessment

Project 10.1: Introduction to Pitch It!

Part 1 What is the Pitch It! Project? View Skills

Skills

TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 14.A.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Part 2 Working in Teams View Skills

Skills

1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 14.A.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Part 3 Required Setup Instructions View Skills

Skills

1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 14.A.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Pitch It! Projects

Project 10.2 What's the Big Idea? View Skills

Skills

There are no new skills being introduced in this final assessment.
TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 6.D.iii, 14.A.i

Free Lesson

This lesson is available for a free preview. We'd love to know what you think!

Project 10.3 Creating Your Product’s Identity View Skills

Skills

There are no new skills being introduced in this final assessment.
TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 12.D.i, 13.A.i, 14.A.i

Project 10.4 Bringing Your Product to Life View Skills

Skills

There are no new skills being introduced in this final assessment.
TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 14.A.i

Project 10.5 Estimating Annual Gross Sales View Skills

Skills

There are no new skills being introduced in this final assessment.
TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 12.D.i, 14.A.i

Project 10.6 Marketing Your Product View Skills

Skills

There are no new skills being introduced in this final assessment.
TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 12.D.i, 13.C.ii, 14.A.i

Project 10.7 Advertising Vendor Database View Skills

Skills

There are no new skills being introduced in this final assessment.
TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 14.A.i

Project 10.8 Putting It All Together View Skills

Skills

There are no new skills being introduced in this final assessment.
TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 12.F.i, 12.F.ii, 12.F.iii, 12.F.iv, 14.A.i

Project 10.9 The Big Pitch! View Skills

Skills

There are no new skills being introduced in this final assessment.
TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 12.D.i, 12.E.i, 12.F.iii, 14.A.i

Project 10.10 Project Summary Report View Skills

Skills

There are no new skills being introduced in this final assessment.
TEKS: 1.A.i, 1.Di, 1.Fi, 1.F.iii, 1.F.iv, 1.F.v, 6.D.iii, 6.D.iv, 6.E.iii, 14.A.i

© 2017 iAcademy
|
Terms and Policies

Sold & Distibuted by B.E. Publishing

Powered By: