Guided Computer Tutorials Software Training

Microsoft Tutorials
	Access 2010
	Access 2007
	Access 2003
	Excel 2010
	Excel 2011
	Excel 2007
	Excel 2008
	Excel 2003/2004
	PowerPoint 2010
	PowerPoint 2011
	PowerPoint 2007
	PowerPoint 2008
	PowerPoint 2003
	PowerPoint 2004
	Word 2010
	Word 2011
	Word 2007
	Word 2003
	Word 2004
Adobe Tutorials
	Photoshop CS5
	Photoshop CS4
	Photoshop CS3
	Photoshop CS3 Applications
	Photoshop Elements 8
	Photoshop Elements 7
	Photoshop Elements 6
	Photoshop Elements 3
	Flash CS5 & CS5.5
	Flash CS4
	Flash CS3
	DreamWeaver CS5 & CS5.5
	DreamWeaver CS4
	DreamWeaver CS3
	Illustrator CS5
	Illustrator CS4
	InDesign CS5 & CS5.5
	InDesign CS4
	InDesign CS3
	InDesign CS
	FireWorks CS5
	FireWorks CS4
Junior IT Courses
	PIT1 Support Files
	PIT2 Support Files
	PIT1 Office 2010 Files
	PIT2 Office 2010 Files
	PIT1&2 Adobe CS5 Files
	Sample IT Projects
Other Tutorials
	Kahootz 3
	Kahootz 2
	FileMaker Pro 10
	FileMaker Pro 8
	FileMaker Pro 7
	FileMaker Pro 6
	iMovie HD 5.0
	iPhoto 5.0
	Flash 8
	Flash MX 2004
	Flash MX
	DreamWeaver 8
	DreamWeaver MX 2004
	DreamWeaver MX
	DreamWeaver 4.0
	Access 97
	VectorWorks 9.0
	PageMaker 7.0

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

by Greg Bowden & 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

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 price of the CD is $99 (inc GST) which 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. Use the ORDERING section if you wish to purchase the CD.

Software Exercises and Sample Pages

The following table shows the list of exercises in each module. Sample pages from selected exercises can be downloaded.

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

Top