Table of Contents

1. INTRODUCTION
   1.1 Switching on the Computer
2. BASIC SKILLS - OPENING THE PROGRAM AND USING THE KEYS
   2.1 Introduction to Word Processing
   2.2 Starting the Word Processing Program
   2.3 The Enter Key and Arrow Keys
   2.4 The Backspace Key and the Delete Key
   2.5 The Caps Lock Key and the Shift Key
   2.6 Highlighting Text
   2.7 Overwriting Text
   2.8 Undoing
   2.9 Experiment
   2.10 Closing down the Program
   2.11 Summary
   2.12 Questions
3. SAVING AND MODIFYING FILES
   3.1 Toolbars
   3.2 Typing into a Document
   3.3 Saving to the Floppy Disk
   3.4 Closing down the Program
   3.5 Typing the Upper Characters on a Key
   3.6 The Show/Hide Button
   3.7 Creating a New Paragraph
   3.8 Save Instead of Save As
   3.9 Closing a File
   3.10 Re-opening a File
   3.11 Using the Undo facility
   3.12 Using the Delete Key
   3.13 Using the Backspace Key to Delete
   3.14 Highlighting and Formatting Text
   3.15 Cutting, Copying and Pasting Text
   3.16 Zoom
   3.17 Shutting Down the Computer
   3.18 Re-opening a File and Aligning Paragraphs
   3.19 Tabs
   3.20 Practice Exercises
   3.21 Summary
   3.22 Question
4. SPREADSHEETS
   4.1 Introduction
   4.2 Opening Microsoft Excel
   4.3 Using Formulae
   4.4 Cell References
   4.5 Highlighting and Clearing cells
   4.6 Subtracting, Multiplying and Dividing
   4.7 Recalculating
   4.8 Filling Figures into other Cells
   4.9 Filling Formulas into other Cells
   4.10 Formatting Cells
   4.11 Percentages
   4.12 The Formula Bar
   4.13 Saving
   4.14 Recalculating
   4.15 Absolute References
   4.16 Modifying a Formula
   4.17 Inserting a Column
   4.18 Using the Format Menu
   4.19 Printing
   4.20 Exercises (SUM Function, Formatting, Brackets First)
   4.21 Summary
   4.22 Questions
5. WINDOWS, FILE CHANGES AND HELP FILES
   5.1 Introduction
   5.2 Viewing Files already Created
   5.3 Minimizing and Maximizing the Window
   5.4 Resizing the Window
   5.5 Moving the Window
   5.6 Pasting between Windows
   5.7 Inserting one File into another File
   5.8 Bullets and Numbering
   5.9 Heading Styles and Paragraph Numbering
   5.10 Indenting
   5.11 Naming Heading Styles
   5.12 Applying the New Style to other Headings
   5.13 Indenting Paragraphs
   5.14 Creating a New Folder during the Save Process
   5.15 Customizing Tabs
   5.16 Aligning Tabs
   5.17 Converting to Table Format
   5.18 Using the Help Files
   5.19 Exercises
   5.20 Summary
   5.21 Questions
6. CHARTING
   6.1 Introduction
   6.2 Creating a Chart or Graph
   6.3 X and Y Axes
   6.4 Print Preview
   6.5 Formatting the Title
   6.6 Changing a Chart by altering the Worksheet
   6.7 Copying a Series of Months
   6.8 Changing Font Size
   6.9 Altering a Chart after it is Saved
   6.10 Line Graphs
   6.11 Removing a Series
   6.12 Altering the X-Axis Labels
   6.13 Changes to the Rainfall Chart
   6.14 Summary
   6.15 Questions
7. ORGANISING FILES
   7.1 Introduction
   7.2 The My Computer Icon
   7.3 Looking at what is on the Floppy Disk
   7.4 Viewing File Details
   7.5 Creating a New Folder
   7.6 Moving Files into a Folder
   7.7 Moving more than one File at a Time
   7.8 Searching for Files
   7.9 Saving to the Hard Drive
   7.10 Summary
   7.11 Questions
   7.12 Help Files Practice
8. DATABASES
   8.1 Introduction to Databases
   8.2 Opening a Database
   8.3 Database Tables
   8.4 Creating a Database Query
   8.5 Running a Database Query
   8.6 The AND Query
   8.7 More Queries
   8.8 Naming a Query
   8.9 The OR Query
   8.10 Sorting Alphabetically
   8.11 Using the Wild Card
   8.12 More Queries
   8.13 Summary
   8.14 Questions
   8.15 Extra Questions
9. GRAPHICS
   9.1 Introduction
   9.2 Inserting WordArt
   9.3 The Word Art Toolbar
   9.4 The Text Wrapping Icon
   9.5 Altering the Shape
   9.6 Rotating and Resizing a WordArt Graphic
   9.7 Altering the Colour
   9.8 Changing the Shape
   9.9 WordArt Character Spacing
   9.10 WordArt Vertical Text
   9.11 Exercise
10. INTEGRATING PACKAGES
    10.1 Introduction to Book Two
    10.2 Task A - Creating a Word Table
    10.3 Task B - Creating a Spreadsheet
    10.4 Task C - Copying data from a Word Table into a Spreadsheet
    10.5 Task D - Altering formulae in a Spreadsheet
    10.6 Task E - Using one Spreadsheet as a Template for Another
    10.7 Task F - Using Class 7 spreadsheet as a Template for Class 6
    10.8 Creating Databases
    10.8a Introduction to Creating Databases
    10.8b Creating a New Blank Database
    10.8c Naming the Database and saving to the Floppy
    10.8d Creating a Table inside the Finances Databases
    10.8e Column Headings and Data Types
    10.8f Changing from Design View and Saving the Table
    10.8g Modifying a Database
    10.8h Copying and Pasting in a Database
    10.8j Moving the Cursor
    10.8k Deleting Database Records
    10.8l Changing to Design View
    10.8m Changing the Data Type
    10.8n Summary
    10.9 TASK G Create another Table
    10.10 TASK H Create Database and Import Data
    10.11 TASK J Add more data and Run a Query
    10.12 TASK K Create Class 5 Test Sheet from a Template
    10.13 TASK L Create Class 4 Test Sheet
    10.14 TASK M Chart the Maths Results for Class 7 Pupils.
    10.15 TASK N Chart the Music Results
    10.16 Mailmerging
    10.16a Introduction to Mailmerging
    10.16b Linking a Prepared Letter to a Datasource
    10.16c Modifying the Data Source
    10.16d Creating both the Letter and the Datasource List
    10.16e Using a Query in a Mailmerge
    10.16f Using a Database as the Data Source
    10.16g Summary
11. MORE DIFFICULT EXAMPLES
    11.1 Introduction
    11.2 Capitalise Text
    11.3 Word Processing - Recipe
    11.4 Spreadsheet - Football League Scores
    11.5 Spreadsheets - Watts
    11.6 Spreadsheets - Petrol Consumption
    11.8 Parameter Queries
    11.7 Mailmerging a Letter using a Query
    11.9 Using Worksheets
    11.10 The OR and IF Functions
    11.11 The Lookup Function
    11.12 Calculations in Word Table
    11.13 Envelopes
    11.14 Table of Contents and Index
12. APPENDICES
    A Word Table of Class 7 Test Results
    B Sales Commission Spreadsheet
    C Test Results spreadsheet for Class 7
    D Holie Wellie Co Spreadsheet
    E Rootin Tootin Repairs Spreadsheet
    F Test Results Spreadsheet for Class 6
    G Class 5, 6 and 7 Pupils’ Details
    H Haggis Preservation Society
    J Answers to Section Two Questions
    K Answers to Section Three Questions
    L Answers to Section Four Questions
    M Answers to Section Five Questions
    N Answers to Section Six Questions
    O Answers to Section Seven Questions
    P Answers to Section Eight Questions
    Q Formatting Spreadsheet Cells
    R The Haggis
    S Using Help Files
    T The Haggis
13. QUERIES AND FORMULAS
14. GLOSSARY

Learn Computing with Microsoft Office Version 2000
©Beltie Productions