|
Chapter One - The History of Computers |
|
|
|
|
1-1 | (1) |
|
1.2 Ancient Counting Machines |
|
|
1-2 | (1) |
|
|
1-2 | (1) |
|
|
1-3 | (1) |
|
|
1-3 | (1) |
|
|
1-4 | (1) |
|
1.7 Babbage's Difference and Analytical Engines |
|
|
1-4 | (1) |
|
1.8 The Electronic Tabulating Machine |
|
|
1-5 | (1) |
|
|
1-6 | (1) |
|
1.10 ENIAC: The First Electronic Computer |
|
|
1-7 | (1) |
|
1.11 The Stored Program Computer |
|
|
1-8 | (1) |
|
|
1-8 | (1) |
|
1.13 Programming Languages |
|
|
1-9 | (1) |
|
|
1-10 | (1) |
|
|
1-10 | (1) |
|
1.16 The Microprocessor and the Microcomputer |
|
|
1-11 | (1) |
|
1.17 The Personal Computer |
|
|
1-11 | (1) |
|
1.18 The Components of a Microcomputer |
|
|
1-12 | (1) |
|
|
1-12 | (1) |
|
1.20 The Central Processing Unit |
|
|
1-13 | (1) |
|
|
1-13 | (1) |
|
|
1-14 | (1) |
|
1.23 Applications Software |
|
|
1-15 | (1) |
|
1.24 Advantages of a Computer |
|
|
1-16 | (1) |
|
|
1-16 | (1) |
|
|
1-17 | (2) |
|
|
1-19 | |
|
Chapter Two - Introducing Windows 95 |
|
|
|
|
2-1 | (1) |
|
|
2-2 | (1) |
|
2.3 The Windows 95 Desktop |
|
|
2-3 | (2) |
|
|
2-5 | (1) |
|
|
2-6 | (1) |
|
|
2-7 | (1) |
|
|
2-7 | (4) |
|
2.8 Using Windows Explorer |
|
|
2-11 | (1) |
|
2.9 File and Folder Management |
|
|
2-12 | (2) |
|
2.10 Recovering Deleted Files |
|
|
2-14 | (1) |
|
2.11 Using Windows 95 Tools |
|
|
2-15 | (2) |
|
|
2-17 | (1) |
|
|
2-18 | (3) |
|
|
2-21 | |
|
Chapter Three - Introducing the Word Processor |
|
|
|
3.1 What is a Word Processor? |
|
|
3-1 | (1) |
|
|
3-1 | (1) |
|
3.3 Creating a New Word Document |
|
|
3-2 | (1) |
|
|
3-3 | (1) |
|
3.5 Using the Keyboard with Word |
|
|
3-4 | (1) |
|
|
3-4 | (1) |
|
|
3-5 | (2) |
|
|
3-7 | (1) |
|
|
3-8 | (2) |
|
3.10 Automatic Spell Checking and Grammer Checking |
|
|
3-10 | (1) |
|
|
3-11 | (1) |
|
|
3-12 | (1) |
|
|
3-13 | (1) |
|
|
3-13 | (1) |
|
|
3-14 | (1) |
|
3.16 Showing Nonprinting Characters |
|
|
3-15 | (1) |
|
|
3-15 | (2) |
|
|
3-17 | (1) |
|
|
3-18 | (2) |
|
|
3-20 | (2) |
|
|
3-22 | (3) |
|
|
3-25 | (2) |
|
|
3-27 | |
|
Chapter Four - Formatting Documents |
|
|
|
|
4-1 | (1) |
|
4.2 Previewing a Document |
|
|
4-2 | (2) |
|
4.3 The Undo Command and the Repeat Command |
|
|
4-4 | (1) |
|
4.4 Selecting and Deleting Blocks of Text |
|
|
4-4 | (2) |
|
|
4-6 | (1) |
|
4.6 Character Formats - Style |
|
|
4-6 | (3) |
|
4.7 When to Apply Formats |
|
|
4-9 | (1) |
|
4.8 Character Formats - Fonts |
|
|
4-9 | (2) |
|
4.9 Character Formats - Size |
|
|
4-11 | (1) |
|
4.10 Character Formats - Superscripts and Subscripts |
|
|
4-12 | (2) |
|
4.11 Paragraph Formats - Alignment |
|
|
4-14 | (2) |
|
4.12 Paragraph Formats - Line Spacing |
|
|
4-16 | (2) |
|
4.13 Page Formats - Margins |
|
|
4-18 | (2) |
|
4.14 Page Formats - Headers and Footers |
|
|
4-20 | (2) |
|
|
4-22 | (1) |
|
4.16 Page Formats - Pagination |
|
|
4-23 | (2) |
|
|
4-25 | (1) |
|
4.18 Setting Individual Tab Stops |
|
|
4-26 | (3) |
|
|
4-29 | (1) |
|
|
4-30 | (3) |
|
|
4-33 | (2) |
|
|
4-35 | |
|
Chapter Five - Word Processor Features |
|
|
|
5.1 Copying and Pasting Text |
|
|
5-1 | (1) |
|
|
5-1 | (1) |
|
5.3 Using the Control Key |
|
|
5-2 | (2) |
|
5.4 Finding Text in a Document |
|
|
5-4 | (1) |
|
5.5 Going to a Specific Page |
|
|
5-5 | (1) |
|
5.6 Finding Special Characters |
|
|
5-6 | (1) |
|
|
5-7 | (2) |
|
|
5-9 | (2) |
|
5.9 Paragraph Formats - Indents |
|
|
5-11 | (2) |
|
5.10 Paragraph Formats - Special Indents |
|
|
5-13 | (1) |
|
|
5-14 | (2) |
|
5.12 Creating Footnotes and Endnotes |
|
|
5-16 | (2) |
|
5.13 Inserting Time Stamps |
|
|
5-18 | (1) |
|
5.14 Displaying Document Information |
|
|
5-19 | (1) |
|
5.15 Adding Graphics to a Document |
|
|
5-20 | (1) |
|
|
5-21 | (2) |
|
|
5-23 | (1) |
|
|
5-24 | (2) |
|
|
5-26 | (1) |
|
|
5-27 | |
|
Chapter Six - Advanced Word Processor Features |
|
|
|
|
6-1 | (1) |
|
|
6-2 | (3) |
|
6.3 Inserting Special Characters |
|
|
6-5 | (1) |
|
6.4 Hyphenating Documents |
|
|
6-5 | (1) |
|
6.5 Applying Built-In Styles |
|
|
6-6 | (2) |
|
|
6-8 | (3) |
|
6.7 Creating a Table of Contents |
|
|
6-11 | (1) |
|
6.8 Creating Sections in a Document |
|
|
6-12 | (1) |
|
6.9 Using Section Headers and Footers |
|
|
6-13 | (1) |
|
6.10 Using Section Page Numbers |
|
|
6-14 | (2) |
|
6.11 Creating Hyperlinks to the Internet |
|
|
6-16 | (1) |
|
|
6-17 | (2) |
|
|
6-19 | (2) |
|
|
6-21 | (2) |
|
6.15 Where can you go from here? |
|
|
6-23 | (1) |
|
|
6-23 | (1) |
|
|
6-24 | (3) |
|
|
6-27 | (2) |
|
|
6-29 | |
|
Chapter Seven - Introducing the Spreadsheet |
|
|
|
7.1 What is a Spreadsheet? |
|
|
7-1 | (1) |
|
|
7-2 | (1) |
|
|
7-3 | (1) |
|
7.4 Moving Through the Spreadsheet |
|
|
7-3 | (1) |
|
7.5 Entering Data into the Spreadsheet |
|
|
7-4 | (1) |
|
7.6 Saving, Viewing, and Printing a Spreadsheet |
|
|
7-5 | (1) |
|
7.7 Creating Headers and Footers |
|
|
7-5 | (3) |
|
7.8 Using Formulas to Perform Calculations |
|
|
7-8 | (2) |
|
7.9 Using Cell Names in Formulas |
|
|
7-10 | (1) |
|
|
7-11 | (2) |
|
7.11 Using Functions to Perform Calculations |
|
|
7-13 | (2) |
|
|
7-15 | (1) |
|
7.13 Filling Adjacent Cells |
|
|
7-15 | (1) |
|
|
7-16 | (1) |
|
|
7-17 | (1) |
|
7.16 Changing a Column's Width |
|
|
7-18 | (1) |
|
7.17 Formatting a Spreadsheet |
|
|
7-19 | (3) |
|
|
7-22 | (2) |
|
|
7-24 | (3) |
|
|
7-27 | (2) |
|
|
7-29 | |
|
Chapter Eight - Spreadsheet Techniques |
|
|
|
8.1 Planning a Spreadsheet |
|
|
8-1 | (1) |
|
8.2 Entering Formulas - Pointing |
|
|
8-2 | (1) |
|
|
8-2 | (2) |
|
|
8-4 | (2) |
|
|
8-6 | (1) |
|
8.6 The MAX and MIN Functions |
|
|
8-7 | (1) |
|
8.7 Expanding a Spreadsheet |
|
|
8-8 | (1) |
|
|
8-9 | (1) |
|
|
8-10 | (2) |
|
8.10 Inserting and Deleting Rows and Columns |
|
|
8-12 | (1) |
|
8.11 Using the IF Function |
|
|
8-13 | (1) |
|
8.12 Printing a Large Spreadsheet |
|
|
8-14 | (2) |
|
|
8-16 | (1) |
|
|
8-17 | (3) |
|
8.15 Selecting, Moving, Sizing, and Deleting Charts |
|
|
8-20 | (2) |
|
|
8-22 | (2) |
|
|
8-24 | (1) |
|
8.18 Modifying Chart Titles |
|
|
8-25 | (1) |
|
8.19 Adding Series and Labels |
|
|
8-25 | (3) |
|
|
8-28 | (2) |
|
|
8-30 | (2) |
|
|
8-32 | (2) |
|
|
8-34 | |
|
Chapter Nine - Advanced Spreadsheet Techniques |
|
|
|
|
9-1 | (2) |
|
9.2 Using Sort to Organize a Spreadsheet |
|
|
9-3 | (2) |
|
9.3 Using Text in Functions |
|
|
9-5 | (1) |
|
|
9-6 | (2) |
|
|
9-8 | (2) |
|
|
9-10 | (2) |
|
9.7 Using Text in CHOOSE and VLOOKUP |
|
|
9-12 | (2) |
|
|
9-14 | (1) |
|
9.9 Printing a Selected Spreadsheet Area |
|
|
9-15 | (2) |
|
9.10 Where can you go from here? |
|
|
9-17 | (1) |
|
|
9-18 | (1) |
|
|
9-18 | (2) |
|
|
9-20 | (1) |
|
|
9-21 | |
|
Chapter Ten - Integrating the Word Processor and Spreadsheet |
|
|
|
10.1 Working with Multiple Files |
|
|
10-1 | (1) |
|
10.2 Removing Files from Memory - Close |
|
|
10-2 | (1) |
|
10.3 Copying Data Between Files |
|
|
10-3 | (1) |
|
10.4 Copying Text Between Word Documents |
|
|
10-3 | (2) |
|
10.5 Copying Data Between Excel Spreadsheets |
|
|
10-5 | (1) |
|
10.6 Copying Data Between Excel Spreadsheets and Word Documents |
|
|
10-6 | (2) |
|
10.7 Copying Data into a New File |
|
|
10-8 | (1) |
|
10.8 Copying a Chart into a Word Document |
|
|
10-9 | (1) |
|
10.9 Creating Hyperlinks to Files |
|
|
10-9 | (2) |
|
|
10-11 | (1) |
|
|
10-11 | (1) |
|
|
10-12 | (1) |
|
|
10-13 | |
|
Chapter Eleven - Introducing the Relational Database |
|
|
|
11.1 What is a Relational Database? |
|
|
11-1 | (1) |
|
11.2 The Relational Database Table |
|
|
11-1 | (1) |
|
|
11-2 | (1) |
|
11.4 Designing a Relational Database |
|
|
11-3 | (2) |
|
11.5 Creating a New Relational Database |
|
|
11-5 | (1) |
|
|
11-6 | (2) |
|
|
11-8 | (2) |
|
11.8 The Relational Database Management System |
|
|
11-10 | (1) |
|
|
11-11 | (1) |
|
|
11-12 | (2) |
|
11.11 Formatting Datasheet View |
|
|
11-14 | (1) |
|
|
11-15 | (1) |
|
|
11-16 | (1) |
|
|
11-17 | (2) |
|
|
11-19 | (1) |
|
|
11-20 | (2) |
|
|
11-22 | (2) |
|
|
11-24 | |
|
Chapter Twelve - Relational Database Techniques |
|
|
|
|
12-1 | (1) |
|
|
12-2 | (1) |
|
|
12-3 | (1) |
|
12.4 Using Select Queries |
|
|
12-4 | (4) |
|
12.5 Defining Relationships |
|
|
12-8 | (4) |
|
12.6 Modifying and Deleting a Select Query |
|
|
12-12 | (1) |
|
12.7 Sorting Select Query Results |
|
|
12-13 | (2) |
|
12.8 Using Ranges in Criteria |
|
|
12-15 | (2) |
|
12.9 Select Queries Using Or |
|
|
12-17 | (3) |
|
12.10 Select Queries using And |
|
|
12-20 | (2) |
|
|
12-22 | (1) |
|
|
12-22 | (1) |
|
|
12-23 | (2) |
|
|
12-25 | (1) |
|
|
12-26 | |
|
Chapter Thirteen - Relational Database Reports and Advanced Techniques |
|
|
|
|
13-1 | (1) |
|
|
13-2 | (6) |
|
|
13-8 | (3) |
|
13.4 Using Fields in Query Criteria |
|
|
13-11 | (1) |
|
|
13-12 | (3) |
|
13.6 Where Can you go from here? |
|
|
13-15 | (1) |
|
|
13-15 | (1) |
|
|
13-16 | (1) |
|
|
13-17 | (1) |
|
|
13-18 | |
|
Chapter Fourteen - Integrating the Database with the Word Processor and Spreadsheet |
|
|
|
14.1 Copying Database Entries into a Word Document |
|
|
14-1 | (1) |
|
14.2 Techniques for Copying Database Entries |
|
|
14-1 | (2) |
|
14.3 Copying Database Entries into an Excel Spreadsheet |
|
|
14-3 | (2) |
|
14.4 Creating an Access Table from Excel Spreadsheet Data |
|
|
14-5 | (2) |
|
14.5 Mail Merge - Form Letters |
|
|
14-7 | (4) |
|
14.6 Mail Merge - Mailing Labels |
|
|
14-11 | (5) |
|
|
14-16 | (1) |
|
|
14-16 | (2) |
|
|
14-18 | (1) |
|
|
14-19 | |
|
Chapter Fifteen - Making Presentations |
|
|
|
15.1 What is a Presentation? |
|
|
15-1 | (1) |
|
15.2 Creating a PowerPoint Presentation |
|
|
15-1 | (1) |
|
15.3 Viewing Powerpoint Presentations |
|
|
15-2 | (1) |
|
15.4 Displaying Individual Slides - Slides View |
|
|
15-3 | (1) |
|
15.5 Viewing the Slide Show |
|
|
15-3 | (2) |
|
15.6 Editing Text - Outline View |
|
|
15-5 | (1) |
|
|
15-5 | (2) |
|
15.8 Adding Clip Art Images to a Slide |
|
|
15-7 | (1) |
|
15.9 Displaying All Slides - Slide Sorter View |
|
|
15-8 | (1) |
|
15.10 Printing a Presentation |
|
|
15-8 | (1) |
|
15.11 Adding Footers on Slides |
|
|
15-9 | (1) |
|
|
15-10 | (1) |
|
|
15-10 | (2) |
|
|
15-12 | (1) |
|
15.15 Adding Charts from Spreadsheets |
|
|
15-12 | (2) |
|
15.16 Planning a Presentation |
|
|
15-14 | (1) |
|
15.17 Presentation Design |
|
|
15-14 | (3) |
|
15.18 Displaying Speaker Notes - Notes Pages View |
|
|
15-17 | (1) |
|
15.19 Where can you go from here? |
|
|
15-18 | (1) |
|
|
15-19 | (1) |
|
|
15-20 | (2) |
|
|
15-22 | (1) |
|
|
15-23 | |
|
Chapter Sixteen - Telecommunications and the Social and Ethical Implications of Computing |
|
|
|
|
16-1 | (1) |
|
16.2 Bulletin Board Systems and E-Mail |
|
|
16-2 | (1) |
|
|
16-3 | (1) |
|
|
16-4 | (1) |
|
|
16-5 | (1) |
|
16.6 Surfing the Internet |
|
|
16-5 | (1) |
|
|
16-6 | (2) |
|
16.8 Improved Microprocessors and Software |
|
|
16-8 | (1) |
|
16.9 Super Computers and Neural Networks |
|
|
16-9 | (1) |
|
|
16-9 | (1) |
|
16.11 Computer Generated Motion Picture Effects |
|
|
16-10 | (1) |
|
16.12 Artificial Intelligence |
|
|
16-10 | (1) |
|
|
16-11 | (1) |
|
16.14 Speech Recognition Software |
|
|
16-12 | (1) |
|
|
16-12 | (1) |
|
|
16-13 | (1) |
|
16.17 Multimedia/Hypermedia |
|
|
16-14 | (1) |
|
16.18 Advanced Storage Devices |
|
|
16-14 | (1) |
|
|
16-15 | (1) |
|
|
16-16 | (1) |
|
16.21 Careers in Computing |
|
|
16-17 | (2) |
|
16.22 The Social and Ethical Consequences of Computers |
|
|
16-19 | (1) |
|
16.23 The Right to Privacy |
|
|
16-20 | (1) |
|
16.24 Protecting Computer Software and Data |
|
|
16-21 | (1) |
|
16.25 The Ethical Responsibilities of the Programmer |
|
|
16-22 | (1) |
|
|
16-23 | (1) |
|
|
16-23 | (1) |
|
16.28 Graphics and Illustration Software |
|
|
16-24 | (1) |
|
16.29 Graphics and Illustration Equipment |
|
|
16-25 | (1) |
|
16.30 Where can you go from here? |
|
|
16-25 | (1) |
|
|
16-25 | (2) |
|
|
16-27 | (4) |
|
|
16-31 | |
Appendix A - Microsoft Office Keyboard Shortcuts and Functions |
|
Word Processor Keyboard Shortcuts |
|
A-1 | (2) |
Spreadsheet Keyboard Shortcuts |
|
A-3 | (1) |
Database Keyboard Shortcuts |
|
A-4 | (2) |
Functions |
|
A-6 | |
Appendix B - Creating Customized Forms and Reports |
|
Form Layout |
|
B-1 | (1) |
Creating Forms in Design View |
|
B-2 | (1) |
Customizing Forms in Design View |
|
B-3 | (1) |
Creating Reports in Design View |
|
B-4 | (1) |
Customizing Reports in Design View |
|
B-5 | (2) |
Adding Summaries and Subsummaries to a Report |
|
B-7 | |
Appendix C - Keyboarding Skills |
|
Learning to Touch Type |
|
C-1 | (1) |
Lesson 1 - The Home Row: ASDF JKL; |
|
C-1 | (2) |
Lesson 2 - RTYU |
|
C-3 | (2) |
Lesson 3 - EGHI |
|
C-5 | (2) |
Lesson 4 - CVB MNO |
|
C-7 | (2) |
Lesson 5 - WQZX P,? |
|
C-9 | (2) |
Lesson 6 - :"/ |
|
C-11 | (1) |
Lesson 7 |
|
C-11 | (2) |
Lesson 8 |
|
C-13 | (2) |
Lesson 9 |
|
C-15 | |