Practice IT Book 1 (3rd Edition)
Microsoft Office 2010 Support Files

by Greg Bowden and Kerryn Maguire

The Microsoft Office 2010 Support Files provide more detailed tutorials and worksheets in PDF format using Microsoft Office 2010 (Access, Excel, PowerPoint and Word) for the software activities in the Practice IT Book 1 (third edition) text book published by Cambridge University Press.

http://www.cambridge.edu.au/education/pit

Practice IT Book 1 Microsoft Office 2010 Support Files

The Microsoft Office 2010 Support Files are aimed at students in years 7 and 8 and can be used separately from the Practice IT Book 1 text book, but the book does provide projects at the end of each software module and a theory module on computer awareness and the social impacts of computer use.

The Support Files provide teachers with the choice of teaching from the book or giving the more detailed tutorials to students to work through at their own rate, or use a combination of the two approaches.

The CD provides schools with a licence to print as many copies of the tutorials as they want for use within the school, to place the files on their school's network or content management systems and to place the files on staff laptops.

Prices (Including GST)

Products can be purchased using a School Purchase Order Number, Credit Card or PayPal.

PIT Book 1 Microsoft Office 2010 Support Files, $A33

The following table shows the list of exercises in each module. Sample pages from selected exercises can be downloaded. If you are using Firefox and the sample pages don't display correctly, use the OPEN WITH DIFFERENT VIEWER button.

Module 2: Word Processing
1	Entering a Document
2	Formatting Text
3	Copying and Pasting Text
4	Inserting Page Breaks and Moving Text	Microsoft Word 2010 pages (305k)
5	Tab Stops
6	Setting page Margins
7	Combining Tabs and Indents
8	Further Tabs and Indents
9	Bulleted and Numbered Lists
10	Leader Characters
11	Further Tabs and Indents	Microsoft Word 2010 pages (375k)
12	Page Formats
13	Inserting Graphics
14	Multiple Page Documents
15	Using Sections
16	Detailed Newsletters
Module 3: Microsoft Drawing Tools
1	Drawing Shapes
2	Editing Objects
3	Shape Fills
4	Shape Outlines
5	Shape Effects
6	3-D Effects
7	The Text Box Tool	Microsoft Word 2010 pages (303k)
8	Using Clip Art
9	Using WordArt
10	WordArt Enhancements
11	SmartArt Graphics
12	Aligning Objects
Module 5: Multimedia
1	Creating a New Presentation	Microsoft PowerPoint 2010 pages (477k)
2	Entering Text
3	Formatting Text
4	Inserting Graphics
5	Starting from Scratch
6	More Graphics
7	Slide Transitions
8	Animating Slides for a Slide Show
9	Building Bullets
10	Using Masters
11	Formatting Master Bullets
12	Adding Background Items
13	Adding a Picture to a Master
14	Following the Master
15	Applying and Modifying a Theme Design
16	Using the Master
17	Movie Promo Master
18	Creating a Master for a Zoo
19	Movie Clips
20	Action Buttons
21	Creating a Custom Action Button
22	Adding More Hyperlinks
23	Using Action Objects to Navigate	Microsoft PowerPoint 2010 pages (336k)
24	Proceeding With Action Buttons
Module 7: Spreadsheets
1	Spreadsheet Structure	Microsoft Excel 2010 pages (330k)
2	Data Entry
3	Formulas and Calculations
4	Addition
5	Division and Subtraction
6	Multiplication, Addition & Subtraction
7	The Sum Formula
8	Formatting the Spreadsheet
9	More Formatting
10	Creating a Column Chart
11	Creating a Pie Chart
12	Charting Only Part of the Data	Microsoft Excel 2010 pages (153k)
13	Using Goal Seek
14	Goal Seek to Calculate Sales and Profit
15	Goal Seek to Find Number of Guests
Module 8: Databases
1	Creating a Database	Microsoft Access 2010 pages (495k)
2	Editing a Database
3	Creating Reports
4	Calculation Fields
5	Creating Different Reports
6	Sorting Data
7	Finding Data	Microsoft Access 2010 pages (495k)
8	Creating Another Table

Practice IT Book 1 (3rd Edition) Microsoft Office 2010 Support Files

Module 2: Word Processing

Entering a Document

Formatting Text

Copying and Pasting Text

Inserting Page Breaks and Moving Text

Tab Stops

Setting page Margins

Combining Tabs and Indents

Further Tabs and Indents

Bulleted and Numbered Lists

Leader Characters

Further Tabs and Indents

Page Formats

Inserting Graphics

Multiple Page Documents

Using Sections

Detailed Newsletters

Module 3: Microsoft Drawing Tools

Drawing Shapes

Editing Objects

Shape Fills

Shape Outlines

Shape Effects

3-D Effects

The Text Box Tool

Using Clip Art

Using WordArt

WordArt Enhancements

SmartArt Graphics

Aligning Objects

Module 5: Multimedia

Creating a New Presentation

Entering Text

Formatting Text

Inserting Graphics

Starting from Scratch

More Graphics

Slide Transitions

Animating Slides for a Slide Show

Building Bullets

Using Masters

Formatting Master Bullets

Adding Background Items

Adding a Picture to a Master

Following the Master

Applying and Modifying a Theme Design

Using the Master

Movie Promo Master

Creating a Master for a Zoo

Movie Clips

Action Buttons

Creating a Custom Action Button

Adding More Hyperlinks

Using Action Objects to Navigate

Proceeding With Action Buttons

Module 7: Spreadsheets

Spreadsheet Structure

Data Entry

Formulas and Calculations

Addition

Division and Subtraction

Multiplication, Addition & Subtraction

The Sum Formula

Formatting the Spreadsheet

More Formatting

Creating a Column Chart

Creating a Pie Chart

Charting Only Part of the Data

Using Goal Seek

Goal Seek to Calculate Sales and Profit

Goal Seek to Find Number of Guests

Module 8: Databases

Creating a Database

Editing a Database

Creating Reports

Calculation Fields

Creating Different Reports

Sorting Data

Finding Data

Practice IT Book 1 (3rd Edition)
Microsoft Office 2010 Support Files