Foundations of Business and Technologies

Unit(s): Introduction to Technology & Operating Systems

Presentation Management

Unit(s): Business Documents & Word Processing

Desktop Publishing

Each Week:

Continue Alphanumeric Typing Skills.  Students should work to improve their speed and accuracy each grading period.  

Weeks 1-9

Week 1:  Digital Citizenship

Create a teacher account at EverFi.net and create a course for EverFi Ignition.  See the EverFi Ignition curriculum guide on the EverFi.net website.

Week 2:  Intro to Keyboarding

Teacher can setup a free account on Typing.com to monitor student progress through keyboarding lessons.  Make sure to teach proper keyboarding technique, finger placement, and ergonomics.  Teacher can use keyboarding practice as a warmup if they choose, but typing lessons should continue throughout the course.

SUGGESTION:  Track student progress in typing lessons and setup a class period competition to motivate students.

Week 3-4:  Intro to Operating Systems

Students will learn basic system skills that will be used throughout the year.  These skills should include, but are not limited to:

• File Management

• Keyboard Shortcuts

• Managing Windows

• Data Storage

iCEV Lessons:  Workplace Technology, Introduction to Computers, Operating Systems & Networking, Windows 10 Operating Systems Basics (2016) – Units 1-5

Week 5:  Intro to Microsoft Office

Students will learn about the workspace and user interface that is used throughout the Office suite (all applications).  The pieces that students should know include, but are not limited to:

• Ribbon

• Tabs

• Groups

• Commands

• Managing Windows

• Keyboard Shortcuts

Learning the basics in this first 5-week period will help students be more comfortable and efficient when working through the Microsoft Office suite this year.

Weeks 6-9

Microsoft PowerPoint

This unit will focus on Microsoft PowerPoint.  Teacher should review the Workspace and User Interface in PowerPoint.  Students will learn how to create, edit, and format business presentations.

• Planning a presentation 

• Themes

• Inserting Slides

• Slide Layouts

• Reusing slides

• Importing slides from outline

• Headers & Footers

• Edit Master slides

• SmartArt & Graphics

• Formatting & Aligning Text

• Arranging Slides

• Transitions

• Animations

• Lists

• Drawing & Formatting Shapes

• Modify Themes and Backgrounds

• Creating custom shows

• Setting timings

• Sharing Presentation

• Insert links

• Insert images & video

At the end of the unit, students will prepare for MOS PowerPoint certification exam through certification prep software and practice tests.

Each Week:

Continue Alphanumeric Typing Skills.  Students should work to improve their speed and accuracy each grading period.  

Weeks 9-13

Microsoft Word

This unit will focus on Microsoft Word.  Teacher should review the Workspace and User Interface in Word.  Students will learn how to create, edit, and format professional text documents such as letters, memos, newsletters, cover letters, reports, etc. 

• Headers & Footers

• Themes & Styles

• Alignment & Spacing

• Watermarks

• Font Styles & Text Effects

• Lists

• SmartArt & Graphics

• Page Borders

• Working with Tables

• Breaks

• Columns

At the end of the unit, students will prepare for MOS Word certification exam through certification prep software and practice tests.

Weeks 14-18

Microsoft Publisher

This unit will focus on Microsoft Publisher.  Teacher should review the Workspace and User Interface in Publisher.  Students will learn how to create, edit, and format professional publications, such as newsletters, business cards, brochures, menus, etc.

• Creating and saving new publications

• Inserting pages

• Working with text

• Creating lists

• Inserting and deleting objects, pictures, and tables

• Creating master pages

• Using building blocks

• Performing a mail merge

• Printing a publication

Each Week:

Continue Alphanumeric Typing Skills.  Students should work to improve their speed and accuracy each grading period.  

Weeks 19-26

Each Week:

This unit students will begin numeric typing lessons with a focus on 10-keying and the numeric keypad.  Students should work to improve their speed and accuracy each grading period. 

Week 20-27:  Microsoft Excel

This unit will focus on Microsoft Excel.  Teacher should review the Workspace and User Interface in Excel.  Students will learn how to create, edit, and format professional spreadsheets.

• Creating and saving spreadsheets

• Adding, Moving & Deleting Worksheets

• Themes and cell styles

• Adjust viewing window (cascade, tile, etc.)

• Understand cells and cell references

• Understand columns and rows

• Simple formulas including:

• AutoSum & SUM

• MIN

• MAX

• AVERAGE

• IF

• More complex formulas including:

◦ SUMIF & SUMIFS

◦ COUNTIF & COUNTIFS

◦ NOW

◦ Concatenate

◦ Text Functions – UPPER, LOWER, LEFT, RIGHT, MID

◦ TRIM

• Using math operations and order of operations

• Create formulas using problem-solving and logic

• Formatting a worksheet

• Find and Replace

• Using Excel Tables

• Create and modify charts

• Conditional formatting

• Using Sparklines, Goal Seek, and What-If 

• Data analysis

• Printing a worksheet and workbook

Each Week:

Continue Alphanumeric Typing Skills.  Students should work to improve their speed and accuracy each grading period.  

Weeks 28-36

Week 37:  Final Exams

Each Week:

This unit students will begin numeric typing lessons with a focus on 10-keying and the numeric keypad.  Students should work to improve their speed and accuracy each grading period. 

Week 28-36:  Microsoft Access

This unit will focus on Microsoft Access.  Teacher should review the Workspace and User Interface in Access.  Students will learn how to plan, create and manage professional databases.

• Database concepts

• Records

• Fields

• Types of Data

• Queries

• Criteria

• Planning tables and relationships

• Creating tables in Datasheet View & Design View

• Adding Records

• Editing Records

• Adding & Modifying Fields

• Importing & Protecting Data

• Primary Keys

• Importing & Protecting Data

• Managing relationships between tables

• Filtering data

• Understanding Data Analysis

• Creating Queries

• Select Query

• Multi-Table Query

• Make Table Query

• Append Query 

• Using Comparison Operators in Queries

• Using Calculated Fields

• Summarizing Data in Queries

• Creating & Using Forms

• Creating Reports

• Input Masks

• Lookup Lists

Required Project:

My Favorite… Presentation

Required Project:

Letterhead & Business Letter

Required Project:

Taste the Rainbow:  A Skittles Project

Required Project: Create a Database

(Student Choice)

Additional Activities:

Employability Skills Presentation

MOS PowerPoint Certification Exam

Additional Activities: 

MOS Word Certification Exam

Additional Activities:

MOS Excel Certification Exam

Cycle 1: 

-Professionalism

-Ethics

127.15(1)(A)

127.15(1)(E)

127.15(1)(F)

127.15(1)(G)

127.15(1)(H)

127.15(1)(I)

127.15(1)(K)

127.15(1)(L)

127.15(1)(M)

Cycle 2: 

-Teamwork

-Problem Solving

127.15(1)(B)

127.15(1)(I)

Cycle 3:

-Self Management Skill

-Conflict Resolution

-Leadership

127.15(1)(B)

127.15(1)(D)

127.15(1)(E)

127.15(1)(F)

127.15(1)(G)

127.15(1)(H)

127.15(1)(I)

127.15(1)(J)

127.15(1)(M)

Cycle 4:

Communication Skills

127.15(1)(C)