Getting to Know Microsoft Office Versions |
|
1 | (1) |
Using SAM Projects and Textbook Projects |
|
1 | (1) |
Introduction to Technology for Success: Computer Concepts |
|
1 | (1) |
|
Technology for Success: computer Concepts |
|
|
|
Module 1 Impact of Digital Technology |
|
|
1 | (1) |
|
Explain Society's Reliance on Technology |
|
|
2 | (5) |
|
Develop Personal Uses for Technology |
|
|
7 | (6) |
|
Explain the Role of Technology in the Professional World |
|
|
13 | (5) |
|
|
18 | (1) |
|
|
18 | (1) |
|
|
19 | (1) |
|
Critical Thinking Activities |
|
|
19 | (1) |
|
|
19 | |
|
|
1 | (1) |
|
Explain the Role of the Web in Daily Life |
|
|
2 | (3) |
|
Describe Websites and Webpages |
|
|
5 | (5) |
|
|
10 | (3) |
|
Apply Information Literacy Skills to Web Searches |
|
|
13 | (4) |
|
|
17 | (5) |
|
|
22 | (1) |
|
|
23 | (1) |
|
|
24 | (1) |
|
Critical Thinking Activities |
|
|
24 | (1) |
|
|
25 | |
|
Module 3 Computer Hardware |
|
|
1 | (1) |
|
Categorize the Various Types of Computer Hardware |
|
|
2 | (12) |
|
Demonstrate Familiarity with Input and Output Devices |
|
|
14 | (4) |
|
Maintain Hardware Components |
|
|
18 | (9) |
|
|
27 | (1) |
|
|
27 | (1) |
|
|
28 | (1) |
|
Critical Thinking Activities |
|
|
28 | (1) |
|
|
28 | |
|
Module 4 Operating Systems and File Management |
|
|
1 | (1) |
|
Compare Operating Systems |
|
|
2 | (5) |
|
Explain How an Operating System Works |
|
|
7 | (3) |
|
Personalize an Operating System to Increase Productivity |
|
|
10 | (6) |
|
|
16 | (4) |
|
|
20 | (1) |
|
|
20 | (1) |
|
|
21 | (1) |
|
Critical Thinking Activities |
|
|
21 | (1) |
|
|
21 | |
|
Module 5 Software and Apps |
|
|
1 | (1) |
|
Explain How to Use Apps as Part of Your Daily Life |
|
|
2 | (7) |
|
Use Common Features of Productivity and Graphics Apps |
|
|
9 | (23) |
|
|
32 | (1) |
|
|
33 | (1) |
|
|
33 | (1) |
|
Critical Thinking Activities |
|
|
34 | (1) |
|
|
34 | |
|
Module 6 Security and Safety |
|
|
1 | (1) |
|
Discuss Computer Safety and Health Risks |
|
|
2 | (10) |
|
Use Protective Measures to Safeguard Computers and Data |
|
|
12 | (12) |
|
|
24 | (1) |
|
|
25 | (1) |
|
|
26 | (1) |
|
Critical Thinking Activities |
|
|
26 | (1) |
|
|
26 | (1) |
|
|
27 | |
|
|
|
Module 1 Creating Documents with Word |
|
|
1 | (1) |
|
Understand Word Processing Software |
|
|
2 | (2) |
|
Planning a document Explore the Word Window |
|
|
4 | (2) |
|
|
6 | (2) |
|
|
8 | (2) |
|
Using keyboard shortcuts Select Text |
|
|
10 | (2) |
|
Format Text Using the Mini Toolbar and the Ribbon |
|
|
12 | (2) |
|
View and Navigate a Document |
|
|
14 | (2) |
|
Using Word document views Cut and Paste Text |
|
|
16 | (2) |
|
Highlighting text in a document Using the Undo, Redo, and Repeat commands Copy and Paste Text Splitting the document window to copy and move items in a long document |
|
|
18 | (2) |
|
Copying and moving items between documents Format with Fonts |
|
|
20 | (2) |
|
Applying shadows and other text effects to text Set Document Margins |
|
|
22 | (2) |
|
Changing orientation, margin settings, and paper size Add Bullets and Numbering |
|
|
24 | (2) |
|
|
26 | (2) |
|
Enhancing pictures with styles and effects Apply a Theme |
|
|
28 | (2) |
|
|
30 | |
|
Module 2 Editing and Formatting Documents |
|
|
1 | (1) |
|
|
2 | (2) |
|
Inking comments in Word Find and Replace Text |
|
|
4 | (2) |
|
Navigating a document using the Navigation pane and the Go to command Check Spelling and Grammar |
|
|
6 | (2) |
|
Using Smart Lookup Inserting text with AutoCorrect Research Informatioa |
|
|
8 | (2) |
|
Reading a document aloud using Word Using a add-ins for Word Change Line Spacing and Indents |
|
|
10 | (2) |
|
|
12 | (2) |
|
Changing the style set Insert Page Numbers and Page Breaks |
|
|
14 | (2) |
|
|
16 | (2) |
|
Add Footnotes and Endnotes |
|
|
18 | (2) |
|
|
20 | (2) |
|
|
22 | (2) |
|
Finding and citing sources with the Word Researcher Inspect a Document |
|
|
24 | (2) |
|
|
26 | |
|
Module 3 Formatting Text and Graphics |
|
|
1 | (1) |
|
|
2 | (2) |
|
Clearing formatting from text Work with Tabs |
|
|
4 | (2) |
|
|
6 | (2) |
|
Underlining text Insert a Table |
|
|
8 | (2) |
|
Insert and Delete Rows and Columns |
|
|
10 | (2) |
|
|
12 | (2) |
|
|
14 | (2) |
|
|
16 | (2) |
|
Draw and Format Shapes Correcting pictures, changing colors, and applying artistic effects |
|
|
18 | (4) |
|
Adding alt text and checking documents for accessibility issues Enhancing graphic objects with styles and effects Arrange Graphic Objects |
|
|
22 | (2) |
|
Creating an illustration in a drawing canvas Create SmartArt Graphics |
|
|
24 | (2) |
|
|
26 | |
|
|
|
Module 1 Getting Started with Excel |
|
|
1 | (1) |
|
|
2 | (2) |
|
Navigating a worksheet Enter Data |
|
|
4 | (2) |
|
Inserting and deleting selected cells Using Auto Fill and Flash Fill Edit Data |
|
|
6 | (2) |
|
Recovering unsaved changes to a workbook file Copy and Move Cell Data |
|
|
8 | (2) |
|
Using Paste Options and Paste Preview Enter Formulas and Use AutoSum |
|
|
10 | (2) |
|
Copy Formulas with Relative Cell References |
|
|
12 | (2) |
|
Inserting functions into formulas Copy Formulas with Absolute Cell References |
|
|
14 | (2) |
|
Using a mixed reference Enter a Formula with Multiple Operators |
|
|
16 | (2) |
|
|
18 | (2) |
|
|
20 | (2) |
|
|
22 | (2) |
|
Setting a print area Scaling to fit Practice |
|
|
24 | |
|
Module 2 Formatting a Worksheet |
|
|
1 | (1) |
|
|
2 | (2) |
|
Working with online pictures, other images, and symbols Change Font and Font Size |
|
|
4 | (2) |
|
Working with cell styles Change Font Styles and Alignment |
|
|
6 | (2) |
|
Rotating and indenting cell entries Adjust Column Width |
|
|
8 | (2) |
|
Changing row height Insert and Delete Rows and Columns |
|
|
10 | (2) |
|
Hiding and unhiding columns and rows Create and apply a template Apply Colors, Borders, and Documentation |
|
|
12 | (2) |
|
Checking worksheet accessibility Apply Conditional Formatting |
|
|
14 | (2) |
|
Formatting data with icon sets Managing conditional formatting rules Rename and Move a Worksheet |
|
|
16 | (2) |
|
Copying, adding, and deleting worksheets Check Spelling |
|
|
18 | (2) |
|
Translating text Using Find & Select features Practice |
|
|
20 | |
|
Module 3 Analyzing Data Using Formulas |
|
|
1 | (1) |
|
Enter a Formula Using the Quick Analysis Tool |
|
|
2 | (2) |
|
Build a Logical Formula with the IF Functioa |
|
|
4 | (2) |
|
Nesting IF functions Build a Logical Formula with the AND Functioa |
|
|
6 | (2) |
|
Using the OR and NOT logical functions Round a Value with a Function |
|
|
8 | (2) |
|
Using Excel rounding functions Build a Statistical Formula with the COUNTA function |
|
|
10 | (2) |
|
|
12 | (2) |
|
|
14 | (2) |
|
Using Draw tools Control Worksheet Calculations |
|
|
16 | (2) |
|
Showing and printing worksheet formulas Practice |
|
|
18 | |
|
Module 4 Working with Charts |
|
|
1 | (1) |
|
|
2 | (2) |
|
|
4 | (2) |
|
|
6 | (2) |
|
|
8 | (2) |
|
Creating a combo chart Change the Chart Layout |
|
|
10 | (2) |
|
Working with chart axes Format a Chart |
|
|
12 | (2) |
|
Working with WordArt Aligning charts Create a Pie Chart |
|
|
14 | (2) |
|
Working with other chart types Summarize Data with Sparklines |
|
|
16 | (2) |
|
|
18 | (2) |
|
Choosing the right trendline options for your chart Practice |
|
|
20 | |
|
|
|
Module 1 Integrating Word and Excel |
|
|
1 | (1) |
|
Integrate Data between Word and Excel |
|
|
2 | (2) |
|
Understanding object linking and embedding (OLE) Copy Data from Excel to Word |
|
|
4 | (2) |
|
Copy a Chart from Excel to Word |
|
|
6 | (2) |
|
|
8 | (2) |
|
Opening linked files and reestablishing links to charts Embed a Word File in Excel V |
|
|
10 | (2) |
|
|
12 | |
|
|
|
Module 1 Getting Started with Access |
|
|
1 | (1) |
|
Understand Relational Databases |
|
|
2 | (2) |
|
Open and Explore a Database |
|
|
4 | (2) |
|
|
6 | (2) |
|
Changing from Navigation mode to Edit mode Resizing and moving datasheet columns Edit Existing Data |
|
|
8 | (2) |
|
|
10 | (2) |
|
Creating a table in Datasheet View Object views Modify Fields |
|
|
12 | (2) |
|
Field properties Create a Query |
|
|
14 | (2) |
|
Simple Query Wizard Create a Form |
|
|
16 | (2) |
|
|
18 | (2) |
|
Changing page orientation Save and Share a Database with OneDrive |
|
|
20 | (2) |
|
Cloud computing Access is a local application Create a Database |
|
|
22 | (2) |
|
Compact and Back Up a Database |
|
|
24 | (1) |
|
|
25 | |
|
Module 2 Building Tables and Relationships |
|
|
1 | (1) |
|
|
2 | (2) |
|
Modify Fields in Datasheet View |
|
|
4 | (2) |
|
Currency versus Number data type Modify Number and Currency Fields |
|
|
6 | (2) |
|
|
8 | (2) |
|
Working with the Input Mask property Modify Date/Time Fields |
|
|
10 | (2) |
|
Entering dates Using Smart Tags Create Primary Keys |
|
|
12 | (2) |
|
|
14 | (2) |
|
Create One-to-Many Relationships |
|
|
16 | (2) |
|
Specifying the data type of the foreign key field Cascade options Work with Subdatasheets |
|
|
18 | (2) |
|
|
20 | |
|
Module 3 Creating Queries |
|
|
1 | (1) |
|
Work in Query Datasheet View |
|
|
2 | (2) |
|
Work in Query Design View |
|
|
4 | (2) |
|
Adding or deleting a table in Query Design View Linking tables in Query Design View Work in SQL View |
|
|
6 | (2) |
|
|
8 | (2) |
|
|
10 | (2) |
|
|
12 | (2) |
|
|
14 | (2) |
|
|
16 | (2) |
|
Searching for blank fields Apply OR Criteria |
|
|
18 | (2) |
|
Using wildcard characters Create a Calculated Field |
|
|
20 | (2) |
|
|
22 | (2) |
|
|
24 | |
|
Module 4 Working with Forms and Reports |
|
|
1 | (1) |
|
|
2 | (2) |
|
|
4 | (2) |
|
|
6 | (2) |
|
Bound versus unbound controls Work in Report Layout View |
|
|
8 | (2) |
|
Work in Report Design View |
|
|
10 | (2) |
|
Apply Conditional Formatting |
|
|
12 | (2) |
|
Use the Format Painter and Themes |
|
|
14 | (2) |
|
|
16 | |
|
Module 2 Integrating Word, Excel, and Access |
|
|
1 | (1) |
|
Integrate Data Among Word, Excel, and Access |
|
|
2 | (2) |
|
Import an Excel Worksheet into Access |
|
|
4 | (2) |
|
Copy a Word Table to Access |
|
|
6 | (2) |
|
Link an Access Table to Excel and Word |
|
|
8 | (2) |
|
Copy an Access Table to Word |
|
|
10 | (2) |
|
Opening linked files and enabling content Practice |
|
|
12 | |
|
|
|
Module 1 Creating a Presentation in PowerPoint |
|
|
1 | (1) |
|
Define Presentation Software |
|
|
2 | (2) |
|
Using PowerPoint on a touch screen Plan an Effective Presentation |
|
|
4 | (2) |
|
Understanding copyright Examine the PowerPoint Window |
|
|
6 | (2) |
|
Creating a presentation using a template Enter Slide Text |
|
|
8 | (2) |
|
Inking a slide Add a New Slide |
|
|
10 | (2) |
|
Viewing your presentation in grayscale or black and white Format Text |
|
|
12 | (2) |
|
Adding bullets to paragraphs Apply a Design Theme |
|
|
14 | (2) |
|
Changing theme colors Compare Presentation Views |
|
|
16 | (2) |
|
Insert and Resize a Picture |
|
|
18 | (2) |
|
|
20 | (2) |
|
Checking spelling as you type Print a PowerPoint Presentation |
|
|
22 | (2) |
|
Microsoft Office Online Apps Practice |
|
|
24 | |
|
Module 2 Modifying a Presentation |
|
|
1 | (1) |
|
|
2 | (2) |
|
Entering and printing notes Insert and Style Shapes |
|
|
4 | (2) |
|
Using the Eyedropper to match colors Rotate and Modify Shapes |
|
|
6 | (2) |
|
Aligning paragraph text Rearrange and Merge Shapes |
|
|
8 | (2) |
|
Changing the size and position of shapes Edit and Duplicate Shapes |
|
|
10 | (2) |
|
Editing points of a shape Align and Group Objects |
|
|
12 | (2) |
|
Distributing objects Add Slide Footers |
|
|
14 | (2) |
|
Creating superscript and subscript text Set Slide Transitions and Timings |
|
|
16 | (2) |
|
Inserting hyperlinks in a webpage Practice |
|
|
18 | |
|
Module 3 Inserting Objects into a Presentation |
|
|
1 | (1) |
|
|
2 | (2) |
|
Changing text box defaults Crop and Style a Picture |
|
|
4 | (2) |
|
Inserting a screen recording Insert a Chart |
|
|
6 | (2) |
|
Enter and Edit Chart Data |
|
|
8 | (2) |
|
Adding a hyperlink to a chart Insert Slides from Other Presentations |
|
|
10 | (2) |
|
Working with multiple windows Insert a Table |
|
|
12 | (2) |
|
Setting permissions Insert and Format WordArt |
|
|
14 | (2) |
|
|
16 | (2) |
|
Attaching a sound to an animation Insert and Edit Digital Video |
|
|
18 | (2) |
|
Saving a presentation as a video Practice |
|
|
20 | |
|
|
|
Module 3 Integrating Word, Excel, Access, and PowerPoint |
|
|
1 | (1) |
|
Integrate Data among Word, Excel, Access, and PowerPoint |
|
|
2 | (2) |
|
Import a Word Outline into PowerPoint |
|
|
4 | (2) |
|
Embed an Excel Worksheet in PowerPoint |
|
|
6 | (2) |
|
Link Access and Excel Objects to PowerPoint |
|
|
8 | (2) |
|
|
10 | (2) |
|
|
12 | |
Index |
|
1 | |