Emc computer technology catalog 2013 by EMC Publishing

2013 FALL

Learning Solutions for Computer Technology

800-328-1452 | www.emcschool.com

800-328-1452 | 800-328-4564 Fax

emcschool.com | email: educate@emcp.com

Computer Applications

A Guide to Microsoft Office 2013 ®

A Guide to Microsoft Office 2013

Teach your students the fundamentals of Microsoft Office 2013 with hands-on practice and cross-curricular projects. Challenge your students with progressive levels of instruction. A Guide to Microsoft Office 2013 includes:

600 pages

New!

• Real business documentation projects—preparing business letters, brochures, newsletters, blogs, PDF documents, invoices, pivot tables, inventory databases, and business presentations. • Critical-thinking practice and opportunities to conduct integrated and collaborative research with review questions and exercises. • Opportunities for students to develop skills in conducting web research, emailing, creating multimedia presentations, preparing marketing documents, and using a digital notebook with bonus coverage of Internet Explorer, SkyDrive, Outlook, PowerPoint, Publisher, and OneNote. Tips, topic sidebars, and alternative methods provide helpful information throughout the chapter.

CONTENTS 1. Microsoft Office Basics. 2. Using a Word Processor. 3. Formatting Documents. 4. Advanced Formatting Features. 5. Using a Spreadsheet. 6. Functions and Data Organization. 7. Creating Charts. 8. Advanced Spreadsheet Techniques. 9.Working with a Database. 10. Relational Database Techniques. 11. Analyzing Data in a Database. 12. Creating Presentations. 13. Advanced PowerPoint Features. 14. Desktop Publishing. 15. Using OneNote. Glossary. Index.

Computer Applications

Projects-Based Approach

Challenge students with varied levels of instruction and provide them hands-on practice with cross-curricular exercises that focus on creating business documents. Student Courseware Text (hardcover) eBook 6 year license eBook 1 year license

Price $71.95 $61.95 $19.95

ISBN 978-0-82196-559-7 978-0-82196-734-8 978-0-82196-735-5

Instructor Resources *Instructor Resources and EXAMVIEW® Assessment Suite (CD only)

Price

$135.95

ISBN

978-0-82196-566-5

*Internet Resource Center: www.emcp.net/lvpoffice2013

eBooks available—works on all devices!

A Guide to Microsoft Office 2010 ®

TIP Right-click the status bar and select Track Changes to add a track changes indicator to the status bar.

Exercises allow for practice in real-world, business-related activities.

Once a document has been reviewed, the author can click REVIEW j Accept or REVIEW j Reject in the Changes group to keep or remove the changes. Comments are removed by clicking REVIEW j Delete in the j Info j Check for Issues j Comments group. As a final check, click Inspect Document. This will run the Document Inspector tool which checks for tracked changes and comments that may have been missed.

The types of changes a reviewer can make can be restricted before emailing the document. Click REVIEW j Restrict Editing to display the task pane of options for restricting changes.

Exercise 4

Reading a Document on Screen

Print Layout Print Layout

———————————————— Computer Maintenance

A regular maintenance routine will help keep your computer in good condition. A maintenance routine should include cleaning the computer, maintaining the hard disk, and regularly updating virus protection and operating system software. COMPUTER MAINTENANCE contains some tips about keeping a computer in good condition. Open COMPUTER MAINTENANCE, which is a Word data file for this text, and complete the following steps:

Zoom

a) Format the title “Computer Maintenance” as Candara 14 point, bold, and centered. “Cleaning” “Disk Maintenance” “Updating Software” c) Input devices are devices from which the computer can accept data. Two input devices are discussed in the “Cleaning” section. Format the first occurrence of each input device name as italic.

Student Courseware Text (hardcover) eBook 6 year license

d) Output devices are devices that display or store processed data. One output device is discussed in the “Cleaning” section. Bold the full name of the output device. changed on the status bar: .

e) In the “Disk Maintenance” section, format the text “built-in” as bold and italic. Documents can also be viewed in Web Layout and Read Mode. Web Layout displays a document as it would look as a web page. Read Mode displays the document in easy-to-read columns:

f) The “Updating Software” section explains what must be downloaded regularly to protect against new viruses. Format the name of the download as bold and italic.

Price $71.95 $61.95

ISBN 978-0-82195-833-9 978-0-82196-022-6

g) Save the modified COMPUTER MAINTENANCE and print a copy.

Exercise 5

————————————————————— Cover Letter

Package your text with SNAP Classroom Online Training and Assessment Program.

a) Given the following job advertisement from the Sun News on August 24, 2014, create a cover letter in a new document: Part-Time Sales Position Great opportunity for a student. Part-time position in busy retail clothing store. Hours are 5–9 p.m. three days a week and 9–5 p.m. on Saturdays. Need to be motivated and a self-starter. Salary includes wage plus commission. Send or email cover letter and résumé to: Ms. Jessica Wilson, Manager Clothes and More 678 Palm Blvd. Boca Raton, FL 33427-5314 clothesandmore@emcp.com

• The TOOLS tab contains options, such as Find and Search with Bing, that are useful when reading a document. • Zoom in on images, charts and tables by double-clicking the mouse or if you have a touch screen, double-tapping the object.

Chapter 2 Using a Word Processor

Instructor Resources *Instructor Resources and EXAMVIEW® Assessment Suite (CD only)

Price

$135.95

ISBN

978-0-82196-023-3

*Internet Resource Center: www.emcp.net/lvpoffice2010

It is common practice to include a cover letter with a résumé or portfolio when applying for a job. A cover letter should be in the block style and addressed to a specific individual and company. The first paragraph should indicate the position being applied for and give the location and date of the advertisement. The second and possibly third paragraph should expand in detail upon qualifications pertinent to the job. The concluding paragraph should request an interview, state contact information, and thank the reader for his or her time and consideration.

b) Format the following headings as Candara 12 point, bold, and left aligned:

Print Layout view is the default view in Word 2013. To better read a document in Print Layout view, the document can be magnified or reduced by clicking VIEW j Zoom and selecting an option in the Zoom dialog box. Alternatively, drag the Zoom slider or click or in the bottom-right corner of the window:

TIP Page views can also be

672 pages

Student Courseware SNAP Classroom 2010 Training and Assessment Site License (one seat)

Price

$7.95

ISBN

978-0-76384-754-8

b) Check the document on screen and correct any errors and misspellings. O2013H.indb 58

2/7/2013 5:03:17 PM

c) Save the document naming it Cover Letter Name replacing Name with your name.

O2013H.indb 68

800-328-1452 | 800-328-4564 Fax

Chapter 2 Using a Word Processor

2/7/2013 5:03:19 PM

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Computer Applications

Guidelines for Microsoft Office 2013 ®

Guidelines for Microsoft® Office 2013 teaches the essentials of Office 2013 for personal, academic, and business use. Its clear, easy-to-follow instruction offers quick tips for potential trouble spots with minimal reading and maximum visuals.

720 pages

New!

• Two- and four-page skill activities list the steps on one page and display large illustrations of the steps on the other—reading is minimal. • A visual introduction to each module highlights best uses of the software. • Guided, end-of-chapter exercises measure students’ achievement of learning outcomes, and creative end-of-module projects evaluate students’ problemsolving in new situations. • A Student Resources disc, packaged with the textbook, contains skills videos demonstrating every skill plus data files and a glossary. eBooks available—works on all devices! Skills videos demonstrate the steps in every skill.

Large visuals include callouts that show where to click and are numbered to match the steps.

Chapter 1 When you open PowerPoint, you can create a blank presentation or select a presentation template. A blank presentation contains a single title slide and is displayed in Normal view. Most slides contain placeholders into which you can enter text. A title slide contains a title placeholder, with the text Click to add title, and a subtitle placeholder, with

M8_C1_S01

the text Click to add subtitle. When you insert a new slide, by default it has a Title and Content layout, which includes a title placeholder and a content placeholder. The content placeholder contains a bullet symbol and the words Click to add text, as well as buttons that can be clicked to add other objects, such as charts or videos, to the slide.

Steps ➧Tip You can access the Charms bar from any screen by moving your mouse pointer to the upper right corner of the screen. 1-4

Another Way

You may have a PowerPoint 2013 tile on the Start screen. If you do, you can click this tile to start PowerPoint.

Shortcut

Insert New Slide Ctrl + M 6

Press Win + C to display the Charms bar.

Click the Search charm.

Type PowerPoint.

Click PowerPoint 2013 in the Apps results list to display the PowerPoint landing page.

Click Blank Presentation. A blank presentation opens in Normal view with the HOME tab displayed.

Click the New Slide button in the Slides group on the HOME tab. The new slide appears with a title placeholder on top and a content placeholder below.

Click the FILE tab.

Click the Save As option to display the Save As backstage area.

Browse to your Module 8 working folder on your storage medium, type M8-C1-S1-FairTrade in the File name text box, and then click Save.

Another Way

Right-click a thumbnail on the left side of the Normal view and choose New Slide from the menu that appears.

➧Tip To apply a different layout, click the New Slide button arrow and then click the desired option from the drop-down menu.

588

Module 8 PowerPoint

Instructor Resources *Instructor Resources DVD with EXAMVIEW® *Instructor’s Guide (print) and Instructor Resources DVD with EXAMVIEW® Assessment Suite

Price $69.95 $59.95 $19.95

ISBN 978-0-76385-258-0 978-0-76385-916-9 978-0-76385-917-6

Price

ISBN

$135.95

978-0-76385-261-0

$135.95

978-0-76385-511-6

*Internet Resource Center: www.emcp.net/guidelines2013

Guidelines for Microsoft Office 2010 ®

640 pages

PowerPoint

Video

Open PowerPoint and Insert a Slide

Skill 1

Student Courseware Text with Student Resources disc eBook 6 year license eBook 1 year license

CONTENTS Introduction. Your Digital Toolkit. 1. Managing Your Time with Microsoft Outlook 2013. 2. Using SkyDrive. 3. Using Microsoft OneNote 2013. 4. Taking Screenshots. Module 1. Computing Essentials. What Is a Computer System and How Does It Work? How Do Operating Systems Software and Applications Software Differ? Module 2. Microsoft Windows 8. 1. Navigating around Windows. 2. Managing Files and Folders. 3. Working with Windows Settings, Accessories, Security, and Help. Module 3. Internet Basics. Module 4. Microsoft Office 2013 Suite Overview. Module 5. Microsoft Word 2013. 1. Creating Documents. 2. Formatting Documents. 3. Working with Tables and Objects. 4. Finalizing and Sharing Documents. Module 6. Microsoft Excel 2013. 1. Creating an Excel Workbook 2. Working with Formulas and Functions. 3. Formatting Cells. 4. Working with Charts. Module 7. Microsoft Access 2013. 1. Working with Databases. 2. Creating Forms and Tables. 3. Working with Queries and Reports. Module 8. Microsoft PowerPoint 2013. 1. Creating a Presentation. 2. Working with Slide Masters and Handouts. 3. Adding Visual Elements and Sound. 4. Completing, Running, and Sharing Your Show. Module 9. Integrating Word, Excel, Access, and PowerPoint. Glossary. Index.

Computer Applications

Guided, Step-By-Step Approach

Student Courseware Text (hardcover) with Student Resources and Skills Videos CD eBook 6 year license with Skills Videos Instructor Resources *Instructor’s Guide with EXAMVIEW® (Print and DVD)

Price

ISBN

$74.95

978-0-76384-440-0

$64.95

978-0-76384-376-2

Price

$135.95

ISBN

978-0-76384-492-9

*Internet Resource Center: www.emcp.net/guidelines2010 Taking It Further Using a Template When you open PowerPoint, the page you see is sometimes referred to as a landing page. On this page, you can select from a variety of templates that are preformatted, allowing you to quickly create a professional looking presentation. If you do not see a template

you want to use, you can type search criteria in the Search online templates and themes text box. Suggested search criteria, such as Business and Photo Albums, is listed under the search text box to help you find what you are looking for.

Chapter 1 Creating a Presentation

589

Package your text with SNAP Classroom Online Training and Assessment Program.

Student Courseware SNAP Classroom 2010 Training and Assessment Site License

Price

$7.95

ISBN

978-0-76384-754-8

Clear, easy-to-follow instructions teach the essentials of the Office suite. 6

800-328-1452 | 800-328-4564 Fax

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Computer Applications

Marquee Series Marquee Series: Microsoft Office 2013

The Marquee Series teaches the essential skills in Word, Excel, Access, and PowerPoint. The highly effective, point-and-click approach facilitates self-paced, accelerated, and traditional learning. Bonus material on Windows 8, Internet Explorer 10, and Computer Concepts makes the Marquee Series well-suited for Introduction to Computers courses.

• Model answers of in-section projects are shown at the beginning of each section ensuring students complete their projects accurately.

792 pages

New!

• Additional activities include preparing MLA research papers. • Four progressive levels of case-based assessment, including the popular Marquee Challenge, ensure software mastery at the introductory level. eBooks available—works on all devices!

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD

Price $91.95 $81.95 $19.95 $24.95

ISBN 978-0-76385-265-8 978-0-76385-918-3 978-0-76385-919-0 978-0-76385-291-7

CONTENTS Information Technology Essentials. Windows 8. 1. Exploring Windows 8. 2. Maintaining Files and Customizing Windows. Internet Explorer 10. 1. Browsing the Internet Using Internet Explorer 10. Word 2013. 1. Creating and Editing a Document. 2. Formatting Characters and Paragraphs. 3. Formatting and Enhancing a Document. 4. Formatting with Special Features. Index. Excel 2013. 1. Analyzing Data Using Excel. 2. Editing and Formatting Worksheets. 3. Using Functions, Setting Print Options, and Adding Visual Elements. 4. Working with Multiple Worksheets, Tables, and Other File Formats. Integrating Programs: Word and Excel. Index. Access 2013. 1. Maintaining Data in Access Tables. 2. Creating Tables and Relationships. 3. Creating Queries, Forms, and Reports. 4. Summarizing Data and Calculating in Forms and Reports. Integrating Programs: Word, Excel, and Access. Index. PowerPoint 2013. 1. Preparing a Presentation. 2. Editing and Enhancing Slides. 3. Customizing a Presentation. Integrating Programs: Word, Excel, and PowerPoint. Index. Instructor Resources *Instructor’s Guide (print and CD) with EXAMVIEW® *Instructor’s Guide with EXAMVIEW® (CD only)

Price

ISBN

$135.95

978-0-76385-290-0

$135.95

978-0-76385-292-4

Computer Applications

Visual Approach

*Internet Resource Center: www.emcp.net/Marquee13

Step-by-step, project-based instruction with corresponding screen visuals help students meet learning objectives quickly.

Activity 3.1

Cutting, Copying, and Pasting Text; Using Paste Special

With the Cut, Copy, and Paste buttons in the Clipboard group on the HOME tab, you can move and/or copy words, sentences, or entire sections of text to other locations in a

Project

You are working on a First Choice Travel document containing information on Thailand. You decide that some of the text in the document should be reorganized, and you also decide to add additional information to the document. 1 2

Tutorial 3.1 Cutting, Copying, and Pasting Text

document. You can cut and paste text or copy and paste text within the same document or between documents. Specify the formatting of pasted text with options at the Paste Special dialog box.

Open FCTThailand.docx and then save the document and name it WS3-FCTThailand. Move the Attractions section below the Traveling in Thailand section. Begin by selecting the Attractions heading and the paragraph of text that follows the heading. Click the Cut button in the Clipboard group on the HOME tab. Clicking the Cut button places the text in a special location within Word called the clipboard.

Two-page activities showcase stream-lined, point-and-click instruction that pares reading to a minimum.

7 8

Position the insertion point at the beginning of the heading Passports/ Visas and then click the Paste button in the Clipboard group.

Click the Paste Options button and then click the Merge Formatting button (middle button) at the Paste Options button drop-down list.

Click the Word button on the Taskbar and then click the FCTThaiStats.docx thumbnail.

Select the text Resources: and the three lines below it and then click the Copy button.

Click the Word button on the Taskbar and then click the WS3-FCTThailand.docx thumbnail.

Move the insertion point to the end of the document and then press the Enter key once. Paste the copied text into the document Step without the formatting by clicking the Paste button arrow 13 and then clicking Paste Special at the drop-down list.

At the Paste Special dialog box, click Unformatted Text in the As list box and then click OK.

Select the four lines of text you just pasted in the document and then remove the spacing after the paragraphs by clicking the PAGE LAYOUT tab and then clicking twice on the down-pointing arrow at the right side of the After measurement box in the Paragraph group.

Step 3

Step 2

Need Help? If you click the wrong button, immediately click the Undo button.

Move the insertion point to the beginning of the Accommodations heading and then in the Clipboard group on the HOME tab. click the Paste button A Paste Options button displays below the pasted text. Click this button and a drop-down list of buttons displays. Use these buttons to specify the formatting of the pasted text. By default, the Keep Source Formatting button (first button from the left) is selected. With this button selected, text is pasted with the formatting from the source document. You can also click the Merge Formatting button (middle button) to merge formatting with the destination formatting or click the Keep Text Only button (third button) to keep only the text and not the formatting.

Open FCTThaiStats.docx. You will copy text from this document and paste it in the Thailand information document.

Select the Points of Interest heading and the four lines of text below the heading in the and then click the Copy button Clipboard group.

Click the Word button on the Taskbar and then click the WS3-FCTThailand.docx thumbnail.

Save WS3-FCTThailand.docx.

Click the Word button on the Taskbar, click the FCTThaiStats.docx thumbnail, and then close the document.

Step 9

Step 15

Price $66.95 $56.95 $19.95 $24.95

selected text by following similar steps. The difference is that you need to hold down the Ctrl key while dragging with the mouse. With the Ctrl key down, a box containing a plus symbol displays near the gray box by the arrow pointer.

WORD Section 3

608 pages

New!

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD

Moving and Copying Text with the Mouse

Step 6

Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; Audrey Roggenkamp, Pierce College at Puyallup; and Ian Rutkosky, Pierce College at Puyallup

Learn just the basics of Office 2013 in this brief version of the textbook!

In Addition You can move selected text using the mouse. To do this, select the text with the mouse and then move the I-beam pointer inside the selected text until the I-beam pointer turns into an arrow pointer. Hold down the left mouse button, drag the arrow pointer (displays with a gray box attached) to the location where you want the selected text inserted, and then release the button. Copy and move

Cut and Paste Text 1. Select text. 2. Click Cut button in Clipboard group. 3. Move insertion point to desired position. 4. Click Paste button in Clipboard group. Copy and Paste Text 1. Select text. 2. Click Copy button in Clipboard group. 3. Move insertion point to desired position. 4. Click Paste button in Clipboard group. Display Paste Special Dialog Box 1. Cut or copy text. 2. Click Paste button arrow. 3. Click Paste Special. 4. Click desired format in As list box. 5. Click OK.

Step 14

Closing the FCTThaiStats.docx document displays the WS3-FCTThailand.docx document.

Marquee Series: Microsoft Office 2013—Brief Edition

Activity 3.1

ISBN 978-0-76385-266-5 978-0-76385-920-6 978-0-76385-921-3 978-0-76385-291-7

Instructor Resources *Instructor’s Guide (print and CD) with EXAMVIEW® *Instructor’s Guide with EXAMVIEW® (CD only)

Price

ISBN

$135.95

978-0-76385-290-0

$135.95

978-0-76385-292-4

*Internet Resource Center: www.emcp.net/Marquee13

In Addition sidebars offer extra information on key features. 8

800-328-1452 | 800-328-4564 Fax

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Computer Applications

232 pages

New!

Facilitates self-paced, accelerated, and traditional learning formats for learning Microsoft Word 2013 and includes activities on preparing MLA research papers.

CONTENTS Windows 8. 1. Exploring Windows 8. 2. Maintaining Files and Customizing Windows. Internet Explorer 10. 1. Browsing the Internet Using Internet Explorer 10. Word 2013. 1. Creating and Editing a Document. 2. Formatting Characters and Paragraphs. 3. Formatting and Enhancing a Document. 4. Formatting with Special Features. Index.

Student Courseware Text with data files CD

Price $35.95

Instructor Resources *Instructor’s Guide (print and CD) with EXAMVIEW® *Instructor’s Guide with EXAMVIEW® (CD only)

Price

248 pages

New!

Provides a hands-on approach to learning Microsoft Excel 2013 and teaches key forumlas and functions for preparing budgets and presenting and analyzing data.

Provide students with additional tutorials!

800-328-1452 | 800-328-4564 Fax

256 pages

New!

ISBN

$135.95

978-0-76385-290-0

$135.95

978-0-76385-292-4

Emphasizes the development of database analysis and management techniques.

*Internet Resource Center: www.emcp.net/Marquee13

Price $35.95

Instructor Resources *Instructor’s Guide (print and CD) with EXAMVIEW® *Instructor’s Guide with EXAMVIEW® (CD only)

Price

Student Courseware Text with data files CD

Price $35.95

Instructor Resources *Instructor’s Guide (print and CD) with EXAMVIEW® *Instructor’s Guide with EXAMVIEW® (CD only)

Price

ISBN 978-0-76385-269-6 ISBN

$135.95

978-0-76385-290-0

$135.95

978-0-76385-292-4

Marquee Series: Microsoft PowerPoint 2013 ®

CONTENTS Windows 8. 1. Exploring Windows 8. 2. Maintaining Files and Customizing Windows. Internet Explorer 10. 1. Browsing the Internet Using Internet Explorer 10. Excel 2013. 1. Analyzing Data Using Excel. 2. Editing and Formatting Worksheets. 3. Using Functions, Setting Print Options, and Adding Visual Elements. 4. Working with Multiple Worksheets, Tables, and Other File Formats. Integrating Programs: Word and Excel. Index.

Student Courseware Text with data files CD

CONTENTS Windows 8. 1. Exploring Windows 8. 2. Maintaining Files and Customizing Windows. Internet Explorer 10. 1. Browsing the Internet Using Internet Explorer 10. Access 2013. Maintaining Data in Access Tables. 2. Creating Tables and Relationships. 3. Creating Queries, Forms, and Reports. 4. Summarizing Data and Calculating in Forms and Reports. Integrating Programs: Word, Excel, and Access. Index.

*Internet Resource Center: www.emcp.net/Marquee13

ISBN 978-0-76385-267-2

Marquee Series: Microsoft Excel 2013 Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; Audrey Roggenkamp, Pierce College at Puyallup; and Ian Rutkosky, Pierce College at Puyallup

Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; Audrey Roggenkamp, Pierce College at Puyallup; and Ian Rutkosky, Pierce College at Puyallup

Computer Applications

Marquee Series: Microsoft Access 2013

Marquee Series: Microsoft Word 2013

New!

ISBN 978-0-76385-268-9 ISBN

$135.95

978-0-76385-290-0

$135.95

978-0-76385-292-4

208 pages

Teaches the basics of effective slideshow design and creation.

CONTENTS Windows 8. 1. Exploring Windows 8. 2. Maintaining Files and Customizing Windows. Internet Explorer 10. 1. Browsing the Internet Using Internet Explorer 10. PowerPoint 2013. 1. Preparing a Presentation. 2. Editing and Enhancing Slides. 3. Customizing a Presentation. Integrating Programs: Word, Excel, and PowerPoint. Index. Student Courseware Text with data files CD

Price $35.95

Instructor Resources *Instructor’s Guide (print and CD) with EXAMVIEW® *Instructor’s Guide with EXAMVIEW® (CD only)

Price

ISBN 978-0-76385-270-2 ISBN

$135.95

978-0-76385-290-0

$135.95

978-0-76385-292-4

*Internet Resource Center: www.emcp.net/Marquee13

Student Courseware SNAP 2013 Tutorials CD

Price $24.95

ISBN 978-0-76385-291-7

Provide students with additional tutorials!

*Free to adopters of 20 or more texts

Student Courseware SNAP 2013 Tutorials CD

Price $24.95

ISBN 978-0-76385-291-7

emcschool.com | email: educate@emcp.com

Computer Applications

Marquee Series: Microsoft Excel 2010

Student Courseware Text (softcover) with data files CD eBook 6 year license Text with data files CD and SNAP 2010 Tutorials CD

720 pages

Price

ISBN

$100.95 $81.95

978-0-76383-771-6 978-0-76384-344-1

$115.95

978-0-76383-912-3

CONTENTS: Information Technology Essentials. Windows 7. 1. Exploring Windows 7.0. 2. Maintaining Files and Customizing Windows. Internet Explorer 8.0. 1. Browsing the Internet Using Internet Explorer 8.0. Word 2010. 1. Creating and Editing a Document. 2. Formatting Characters and Paragraphs. 3. Formatting and Enhancing a Document. 4. Formatting with Special Features. Index. Excel 2010. 1. Analyzing Data Using Excel. 2. Editing and Formatting Worksheets. 3. Using Functions, Setting Print Options, and Adding Visual Elements. 4. Working with Multiple Worksheets, Tables, and Other File Formats. Integrating Programs: Word and Excel. Index. Access 2010. 1. Maintaining Data in Access Tables. 2. Creating Tables and Relationships. 3. Creating Queries, Forms, and Reports. 4. Summarizing Data and Calculating in Forms and Reports. Integrating Programs: Word, Excel, and Access. Index. PowerPoint 2010. 1. Preparing a Presentation. 2. Editing and Enhancing Slides. 3. Customizing a Presentation. Integrating Programs: Word, Excel, and PowerPoint. Index. Instructor Resources *Instructor’s Guide with EXAMVIEW® (Print and DVD) *Instructor’s Guide with EXAMVIEW® (DVD only)

Price

ISBN

$135.95

978-0-76383-773-0

$135.95

978-0-76383-789-1

Student Courseware Text (hardcover) with data files CD eBook 6 year license Text with data files CD and SNAP 2010 Tutorials CD

560 pages

Price

ISBN

$71.95 $61.95

978-0-76384-445-5 978-0-76384-365-6

$86.95

978-0-76384-446-2

Instructor Resources *Instructor’s Guide with EXAMVIEW® (Print and DVD) *Instructor’s Guide with EXAMVIEW® (DVD only)

Price

Student Courseware Text (softcover) with data files CD Text with data files CD and SNAP 2010 Tutorials CD

Price

ISBN

$34.95

978-0-76383-778-5

$49.95

978-0-76383-914-7

800-328-1452 | 800-328-4564 Fax

Instructor Resources *Instructor’s Guide with EXAMVIEW® (Print and DVD) *Instructor’s Guide with EXAMVIEW® (DVD only)

$135.95

978-0-76384-494-3

$135.95

978-0-76384-495-0

Price

$49.95

978-0-76383-915-4

Price

ISBN

$135.95

978-0-76383-773-0

$135.95

978-0-76383-789-1

CONTENTS Windows 7.0. 1. Exploring Windows 7. 2. Maintaining Files and Customizing Windows. Internet Explorer 8.0. 1. Browsing the Internet Using Internet Explorer 8.0. Access 2010. Maintaining Data in Access Tables. 2. Creating Tables and Relationships. 3. Creating Queries, Forms, and Reports. 4. Summarizing Data and Calculating in Forms and Reports. Integrating Programs: Word, Excel, and Access. Index.

Student Courseware Text (softcover) with data files CD Text with data files CD and SNAP 2010 Tutorials CD

232 pages

Price

ISBN

$34.95

978-0-76383-784-6

$49.95

978-0-76383-916-1

Instructor Resources *Instructor’s Guide with EXAMVIEW® (Print and DVD) *Instructor’s Guide with EXAMVIEW® (DVD only)

Price

ISBN

$135.95

978-0-76383-773-0

$135.95

978-0-76383-789-1

ISBN

CONTENTS: Windows 7.0. 1. Exploring Windows 7. 2. Maintaining Files and Customizing Windows. Internet Explorer 8.0. 1. Browsing the Internet Using Internet Explorer 8.0. Word 2010. 1. Creating and Editing a Document. 2. Formatting Characters and Paragraphs. 3. Formatting and Enhancing a Document. 4. Formatting with Special Features. Index.

216 pages

978-0-76383-781-5

Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

Marquee Series: Microsoft PowerPoint 2010 ®

CONTENTS Windows 7.0. 1. Exploring Windows 7. 2. Maintaining Files and Customizing Windows. Internet Explorer 8.0. 1. Browsing the Internet Using Internet Explorer 8.0. PowerPoint 2010. 1. Preparing a Presentation. 2. Editing and Enhancing Slides. 3. Customizing a Presentation. Integrating Programs: Word, Excel, and PowerPoint. Index.

Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

$34.95

Instructor Resources *Instructor’s Guide with EXAMVIEW® (Print and DVD) *Instructor’s Guide with EXAMVIEW® (DVD only)

Marquee Series: Microsoft Word 2010 Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

ISBN

Marquee Series: Microsoft Access 2010

Marquee Series: Microsoft Office 2010—Basic CONTENTS: Information Technology Essentials. Windows 7. 1. Exploring Windows 7.0. 2. Maintaining Files and Customizing Windows. Internet Explorer 8.0. 1. Browsing the Internet Using Internet Explorer 8.0. Word 2010. 1. Creating and Editing a Document. 2. Formatting Characters and Paragraphs. 3. Formatting and Enhancing a Document. Excel 2010. 1. Analyzing Data Using Excel. 2. Editing and Formatting Worksheets. 3. Using Functions, Setting Print Options, and Adding Visual Elements. Access 2010. 1. Maintaining Data in Access Tables. 2. Creating Tables and Relationships. 3. Creating Queries, Forms, and Reports. PowerPoint 2010. 1. Preparing a Presentation. 2. Editing Slides and Slide Elements. Integrating Programs: Word, Excel, and PowerPoint. Index.

232 pages

Price

Student Courseware Text (softcover) with data files CD Text with data files CD and SNAP 2010 Tutorials CD

Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

CONTENTS Windows 7.0. 1. Exploring Windows 7. 2. Maintaining Files and Customizing Windows. Internet Explorer 8.0. 1. Browsing the Internet Using Internet Explorer 8.0. Excel 2010. 1. Analyzing Data Using Excel. 2. Editing and Formatting Worksheets. 3. Using Functions, Setting Print Options, and Adding Visual Elements. 4. Working with Multiple Worksheets, Tables, and Other File Formats. Integrating Programs: Word and Excel. Index.

Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

Computer Applications

Marquee Series: Microsoft Office 2010

Student Courseware Text (softcover) with data files CD Text with data files CD and SNAP 2010 Tutorials CD

192 pages

Price

ISBN

$34.95

978-0-76383-787-7

$49.95

978-0-76383-917-8

Instructor Resources *Instructor’s Guide with EXAMVIEW® (Print and DVD) *Instructor’s Guide with EXAMVIEW® (DVD only)

Price

ISBN

$135.95

978-0-76383-773-0

$135.95

978-0-76383-789-1

Student Courseware SNAP 2010 Tutorials CD

Price $24.95

ISBN 978-0-76383-911-6

$7.95

978-0-76384-754-8

ISBN

$135.95

978-0-76383-773-0

$135.95

978-0-76383-789-1

Visit emcschool.com for information and packaging options for our Marquee Series: Microsoft Office 2007 titles.

Package your text with SNAP Online Training and Assessment Program.

SNAP Classroom 2010 Training and Assessment Site License

*Internet Resource center: www.emcp.net/Marquee10

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Computer Applications

Case-Based, Certification Approach

Benchmark Series Students learn the essential features of Windows 8 and Internet Explorer 10 and develop a mastery skill level in Microsoft® Word, Excel, Access, and PowerPoint through the case-based, certification approach in the Benchmark Series. To enrich student skills in all applications, this graduated, three-level instructional approach moves from an initial modeling of skills to guided application in project based exercises to independent problem-solving in realistic workplace scenarios. The Benchmark Series provides students:

1,464 pages

New!

• Ability to solve problems independently through case study assessments at chapter and unit levels. • Confirmation and confidence that they are on the right track with the guidance of clearly written steps, screen captures, and model answers. • Mastery skill levels to meet the Microsoft Office Specialist certification objectives. • Project approach creates realistic context for learning software skills. eBooks available—works on all devices!

Multi-part projects provide a framework for instruction and practice on software features.

Hints offer useful tips on how to use features efficiently and effectively. Project 1 Format a Product Pricing Worksheet

7 Parts

You will open a workbook containing a worksheet with product pricing data and then format the worksheet by changing column widths and row heights, inserting and deleting rows and columns, and clearing data in cells. You will also apply font and alignment formatting to data in cells.

b. Position the cell pointer on the column boundary between columns A and B until it turns into a double-headed arrow pointing left and right. c. Hold down the left mouse button, drag the column boundary to the right until Width: 10.33 (100 pixels) displays in the box, and then release the mouse button. 7. Adjust the width of column C to accommodate the longest entry by double-clicking on the column boundary between columns C and D. Step 8. Save EL1-C3-P1-CMProducts.xlsx. 6c

Changing Column Width ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ Columns in a worksheet are the same width by default. In some worksheets, you may want to change column widths to accommodate more or less data. Change column width using the mouse on column boundaries or at a dialog box.

Changing Column Width Using Column Boundaries As you learned in Chapter 1, you can adjust the width of a column by dragging the column boundary line or adjust a column width to the longest entry by doubleclicking the boundary line. When you drag a column boundary, the column width displays in a box above the mouse pointer. The column width number that displays represents the average number of characters in the standard font that can fit in a cell. You can change the width of selected adjacent columns at the same time. To do this, select the columns and then drag one of the column boundaries within the selected columns. As you drag the boundary, the column width changes for all selected columns. To select adjacent columns, position the cell pointer on the first desired column header (the mouse pointer turns into a black, down-pointing arrow), hold down the left mouse button, drag the cell pointer to the last desired column header, and then release the mouse button.

Project 1a

Changing Column Width Using a Column Boundary

To change the width of all columns in a worksheet, click the Select All button and then drag a column boundary to the desired position.

Changing Column Width at the Column Width Dialog Box Quick Steps

Format

Part 1 of 7

1. Open CMProducts.xlsx. 2. Save the workbook with Save As and name it EL1-C3-P1-CMProducts. 3. Insert a formula in cell D2 that multiplies the price in cell B2 with the number in cell C2. Copy the formula in cell D2 down to cells D3 through D14. 4. Change the width of column D by completing the following steps: a. Position the mouse pointer on the column boundary in the column header between columns D and E until it turns into a double-headed arrow pointing left and right. b. Hold down the left mouse button, drag the column boundary to the right until Width: 11.00 Step (106 pixels) displays in the box, and then release the mouse button. 4b 5. Make cell D15 active and then insert the sum of cells D2 through D14. 6. Change the width of columns A and B by completing the following steps: a. Select columns A and B. To do this, position the cell pointer on the column A header, hold down the left mouse button, drag the cell pointer to the column B header, and then release the mouse button.

Chapter 3

■

Formatting an Excel Worksheet

Project 1b

800-328-1452 | 800-328-4564 Fax

At the Column Width dialog box, shown in Figure 3.1, you can specify a column width number. Increase the column width number to make the column wider or decrease the column width number to make the column narrower. To display the Column Width dialog box, click the Format button in the Cells group on the HOME tab and then click Column Width at the drop-down list. At the Column Width dialog box, type the number representing the average number of characters in the standard font that you want to fit in the column and then press Enter or click OK.

CONTENTS Preface. Getting Started. Using Windows 8. Browsing the Internet Using Internet Explorer 10. Word 2013 Unit 1. Editing and Formatting Documents. 1. Preparing Documents. 2. Formatting Characters and Paragraphs. 3. Customizing Paragraphs. 4. Formatting Pages. Unit 1 Performance Assessment. Word 2013 Unit 2. Enhancing and Customizing Documents. 5. Applying, Formatting and Inserting Objectives. 6. Maintaining Documents. 7. Creating Tables and SmartArt Graphics. 8. Merging Documents. Unit 2 Performance Assessment. Word Index. Excel 2013 Unit 1. Preparing and Formatting a Worksheet. 1. Preparing an Excel Workbook. 2. Inserting Formulas in a Worksheet. 3. Formatting an Excel Worksheet. 4. Enhancing a Worksheet. Unit 1 Performance Assessment. Excel 2013 Unit 2. Enhancing the Display of Workbooks. 5. Moving Data within and between Workbooks. 6. Maintaining Workbooks. 7. Creating Charts and Inserting Formulas. 8. Adding Visual Interest to Workbook. Unit 2 Performance Assessment. Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD

Price $101.95 $91.95 $19.95 $24.95

Figure 3.1 Column Width Dialog Box

ISBN 978-0-76385-385-3 978-0-76385-922-0 978-0-76385-923-7 978-0-76385-440-9

Excel Index. Access 2013 Unit 1. Creating Tables and Queries. 1. Managing and Creating Tables. 2. Creating Relationships between Tables. 3. Performing Queries. 4. Creating and Modifying Tables in Design View. Unit 1 Performance Assessment. Access 2013 Unit 2. Creating Forms and Reports. 5. Creating Forms. 6. Creating Reports and Mailing Labels. 7. Modifying, Filtering, and Viewing Data. 8. Importing and Exporting Data. Unit 2 Performance Assessment. Access Index. PowerPoint 2013 Unit 1. Creating and Formatting PowerPoint Presentations. 1. Preparing a PowerPoint Presentation. 2. Modifying a Presentation and Using Help. 3. Formatting Slides. 4. Inserting Elements in Slides. Unit 1 Performance Assessment. PowerPoint 2013 Unit 2. Customizing and Enhancing PowerPoint Presentations. 5. Creating Tables, Charts, and SmartArt Graphics. 6. Using Slide Masters and Action Buttons. 7. Applying Custom Animation and Setting Up Shows. 8. Integrating, Sharing, and Protecting Presentations. Unit 2 Performance Assessment. PowerPoint Index. Office 2013 Integrated Project. Instructor Resources *Instructor’s Guide (print and CD) *Instructor’s Guide CD only *EXAMVIEW® Assessment Suite CD only

Price

ISBN

$135.95 $72.95

978-0-76385-451-5 978-0-76385-445-4

$135.95

978-0-76385-450-8

*Internet Resource Center: www.emcp.net/BenchmarkOffice13 Type the column width in this text box.

Changing Column Width at the Column Width Dialog Box

Part 2 of 7

1. With EL1-C3-P1-CMProducts.xlsx open, change the width of column A by completing the following steps: a. Make any cell in column A active. b. Click the Format button in the Cells group on the HOME tab and then click Column Width at the drop-down list. c. At the Column Width dialog box, type 12.7 in the Column width text box. d. Click OK to close the dialog box. Step 2. Make any cell in column B active and then change the 1c width of column B to 12.5 by completing steps similar to those in Step 1. Step 3. Make any cell in column C active and then change the 1d width of column C to 8 by completing steps similar to those in Step 1. 4. Save EL1-C3-P1-CMProducts.xlsx.

Step-by-step instructions clearly guide students to the skills’ desired outcomes.

Change Column Width Drag column boundary line. OR Double-click column boundary. OR 1. Click Format button. 2. Click Column Width at drop-down list. 3. Type desired width. 4. Click OK.

Paradigm’s new Benchmark Series: Microsoft® Office 2013 offers a case-based, certification approach to learning Word, Excel, Access, and PowerPoint. Students build a working knowledge and introductory skill level in each application.

Excel Level 1

■

Unit 1

Quick Steps sidebars feature brief step-by-step summaries for reference and review. *Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Computer Applications

752 pages

New! Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD

Price $86.95 $76.95 $19.95 $24.95

Instructor Resources *Instructor’s Guide (print and CD) *Instructor’s Guide CD only *EXAMVIEW® Assessment Suite CD only

Price

Instructor Resources *Instructor’s Guide (print and CD) *Instructor’s Guide CD only *EXAMVIEW® Assessment Suite CD only

ISBN 978-0-76385-386-0 978-0-76385-924-4 978-0-76385-925-1 978-0-76385-441-6 ISBN

$135.95 $72.95

978-0-76385-452-2 978-0-76385-446-1

$135.95

978-0-76385-450-8

Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; Jan Davidson, Lambton College; Audrey Roggenkamp, Pierce College at Puyallup; and Ian Rutkosky, Pierce College at Puyallup © 2014

CONTENTS Getting Started in Office 2013. Using Windows 8. Browsing the Internet Using Internet Explorer 10. Word 2013 Level 1 Unit 1. Editing and Formatting Documents. 1. Preparing Documents. 2. Formatting Characters and Paragraphs. 3. Customizing Paragraphs. 4. Formatting Pages. Unit 1 Performance Assessment. Level 1 Unit 2. Enhancing and Customizing Documents. 5. Applying, Formatting, and Inserting Objects. 6. Maintaining Documents. 7. Creating Tables and SmartArt. 8. Merging Documents. Level 1 Unit 2 Performance Assessment. Word Level 1 Index. Word 2013 Level 2 Unit 1. Formatting and Customizing Documents. 1. Customizing Paragraphs and Pages. 2. Proofing Documents. 3. Automating and Customizing Formatting. 4. Customizing Themes, Creating Macros, and Navigating in a Document. Unit 1 Performance Assessment. Level 2 Unit 2. Editing and Formatting Documents. 5. Inserting Special Features and References. 6. Creating Specialized Tables and Indexes. 7. Working with Shared Documents. 8. Protecting and Preparing Documents. Unit 2 Performance Assessment. Word Level 2 Index.

712 pages

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD

Price $86.95 $76.95 $19.95 $24.95

Instructor Resources *Instructor’s Guide (print and CD)® *Instructor’s Guide CD only *EXAMVIEW® Assessment Suite CD only

Price

ISBN 978-0-76385-389-1 978-0-76385-930-5 978-0-76385-931-2 978-0-76385-442-3 ISBN

$135.95 $72.95

978-0-76385-453-9 978-0-76385-447-8

$135.95

978-0-76385-450-8

*Internet Resource Center: www.emcp.net/BenchmarkExcel13

Benchmark Series: Microsoft® Word 2013 Level 2

Benchmark Series: Microsoft® Excel 2013 Level 1

Nita Rutkosky, Pierce College at Puyallup; Audrey Roggenkamp, Pierce College at Puyallup; and Ian Rutkosky, Pierce College at Puyallup

408 pages

Price $43.95 $33.95 $19.95 $24.95

ISBN 978-0-76385-387-7 978-0-76385-926-8 978-0-76385-927-5 978-0-76385-441-6

Price

ISBN

$135.95 $72.95

978-0-76385-452-2 978-0-76385-445-4

$135.95

978-0-76385-450-8

800-328-1452 | 800-328-4564 Fax

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD Instructor Resources *Instructor’s Guide (print and CD) *Instructor’s Guide CD only *EXAMVIEW® Assessment Suite CD only

368 pages

Price $43.95 $33.95 $19.95 $24.95

ISBN 978-0-76385-388-4 978-0-76385-928-2 978-0-76385-929-9 978-0-76385-441-6

Price

ISBN

$135.95 $72.95

978-0-76385-452-2 978-0-76385-445-4

$135.95

978-0-76385-450-8

*Internet Resource Center: www.emcp.net/BenchmarkWord13

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD Instructor Resources *Instructor’s Guide (print and CD)® *Instructor’s Guide CD only *EXAMVIEW® Assessment Suite CD only

With Benchmark Series: Microsoft Excel 2013 Levels 1 and 2, students build mastery skills in Excel 2013. Students receive step-bystep instructions in creating, formatting, and maintaining Excel workbooks for numbersbased data analysis. Meets Microsoft Office Specialist Certification Exam Objectives

New!

Benchmark Series: Microsoft® Word 2013 Level 1

*Internet Resource Center: www.emcp.net/BenchmarkWord13

With Benchmark Series: Microsoft® Word 2013 Levels 1 and 2, students build mastery skill level in Word 2013. Students receive step-bystep instruction in creating letters, reports, research papers, brochures, newsletters, and other documents. Meets Microsoft Office Specialist Certification Exam Objectives

*Internet Resource Center: www.emcp.net/BenchmarkWord13

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD

Benchmark Series: Microsoft® Excel 2013 Levels 1 and 2

CONTENTS Preface. Getting Started in Office 2013. Using Windows 8. Browsing the Internet Using Internet Explorer 10. Excel 2013 Level 1 Unit 1. Preparing and Formatting a Worksheet. 1. Preparing an Excel Workbook. 2. Inserting Formulas in a Worksheet. 3. Formatting an Excel Worksheet. 4. Enhancing a Worksheet. Unit 1 Performance Assessment. Level 1 Unit 2. Enhancing the Display of Workbooks. 5. Moving Data within and between Workbooks. 6. Maintaining Workbooks. 7. Creating Charts and Inserting Formulas. 8. Adding Visual Interest to Workbooks. Unit 2 Performance Assessment. Excel Level 1 Index. Excel 2013 Level 2 Unit 1. Advanced Formatting, Formulas, and Data Management. 1. Advanced Formatting Techniques. 2. Advanced Functions and Formulas. 3. Working with Tables and Data Features. 4. Summarizing and Consolidating Data. Unit 1 Performance Assessment. Level 2 Unit 2. Managing and Integrating Data and he Excel Environment. 5. Using Data Analysis Features. 6. Protecting and Sharing Workbooks. 7. Automating Repetitive Tasks and Customizing Excel. 8. Importing, Exporting, and Distributing Data. Unit 2 Performance Assessment. Excel Level 2 Index.

384 pages

Price $43.95 $33.95 $19.95 $24.95

ISBN 978-0-76385-390-7 978-0-76385-932-9 978-0-76385-934-3 978-0-76385-442-3

Price

ISBN

$135.95 $72.95

978-0-76385-453-9 978-0-76385-445-4

$135.95

978-0-76385-450-8

*Internet Resource Center: www.emcp.net/BenchmarkExcel13

*Free to adopters of 20 or more texts

Computer Applications

Benchmark Series: Microsoft® Word 2013 Levels 1 and 2

Price $43.95 $33.95 $19.95 $24.95

344 pages ISBN 978-0-76385-391-4 978-0-76385-935-0 978-0-76385-936-7 978-0-76385-442-3

Price

ISBN

$135.95 $72.95

978-0-76385-453-9 978-0-76385-445-4

$135.95

978-0-76385-450-8

*Internet Resource Center: www.emcp.net/BenchmarkExcel13

emcschool.com | email: educate@emcp.com

Computer Applications

Nita Rutkosky, Pierce College at Puyallup; Denise Seguin, Fanshawe College; Jan Davidson, Lambton College; Audrey Roggenkamp, Pierce College at Puyallup; and Ian Rutkosky, Pierce College at Puyallup

With Benchmark Series: Microsoft Access 2013 Levels 1 and 2, students build mastery skills in Access 2013. Students receive step-bystep instructions in creating, formatting and maintaining databases to report and analyze information.

Meets Microsoft Office Specialist Certification Exam Objectives

760 pages

Price $86.95 $76.95 $19.95 $24.95

ISBN 978-0-76385-392-1 978-0-76385-899-5 978-0-76385-900-8 978-0-76385-443-0

Title Price ISBN *Instructor’s Guide (print and CD) $135.95 978-0-76385-454-6 *Instructor’s Guide CD only $72.95 978-0-76385-448-5 *EXAMVIEW® Assessment Suite CD only $135.95 978-0-76385-450-8 *Internet Resource Center: www.emcp.net/BenchmarkAccess13

Benchmark Series: Microsoft Access 2013 Level 1

Benchmark Series: Microsoft Access 2013 Level 2

Nita Rutkosky, Pierce College at Puyallup; Audrey Roggenkamp, Pierce College at Puyallup; and Ian Rutkosky, Pierce College at Puyallup

Denise Seguin, Fanshawe College; and Jan Davidson, Lambton College

© 2014 Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD Instructor Resources *Instructor’s Guide (print and CD) *Instructor’s Guide CD only *EXAMVIEW® Assessment Suite CD only

CONTENTS Preface. Getting Started in Office 2013. Using Windows 8. Browsing the Internet Using Internet Explorer 10. Access 2013 Level 1 Unit 1. Creating Tables and Queries.1. Managing and Creating Tables. 2. Creating Relationships between Tables. 3. Performing Queries. 4. Creating and Modifying Tables in Design View. Unit 1 Performance Assessment. Level 1 Unit 2. Creating Forms and Reports. 5. Creating Forms. 6. Creating Reports and Mailing Labels. 7. Modifying, Filtering, and Viewing Data. 8. Importing and Exporting Data. Unit 2 Performance Assessment. Access Level 1 Index. Access 2013 Level 2 Unit 1. Advanced Tables, Relationships, Queries, and Forms. 1. Designing the Structure of Tables. 2. Designing and Building Relationships and Lookup Fields. 3. Advanced Query Techniques. 4. Creating and Using Custom Forms. Unit 1 Performance Assessment. Level 2 Unit 2. Advanced Reports, Access Tools, and Customizing Access. 5. Creating and Using Custom Reports. 6. Using Access Tools and Managing Objects. 7. Automating, Customizing, and Securing Access. 8. Integrating Access Data. Unit 2 Performance Assessment. Access Level 2 Index.

456 pages

With Benchmark Series: Microsoft® PowerPoint 2013, students build mastery skills in PowerPoint 2013. Students receive step-by-step instructions in designing and creating effective slide shows that inform and motivate audiences. Meets Microsoft Office Specialist Certification Exam Objectives

New!

New! Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD

Price $61.95 $51.95 $19.95 $24.95

Instructor Resources *Instructor’s Guide (print and CD)® *Instructor’s Guide CD only *EXAMVIEW® Assessment Suite CD only

Price

ISBN 978-0-76385-395-2 978-0-76385-905-3 978-0-76385-906-0 978-0-76385-444-7 ISBN

$135.95 $72.95

978-0-76385-455-3 978-0-76385-445-4

$135.95

978-0-76385-450-8

CONTENTS Preface. Getting Started in Office 2013. Using Windows 8. Browsing the Internet Using Internet Explorer 10. PowerPoint 2013 Unit 1. Creating and Formatting PowerPoint Presentations. 1. Preparing a PowerPoint Presentation. 2. Modifying a Presentation and Using Help. 3. Formatting Slides. 4. Inserting Elements in Slides. Unit 1 Performance Assessment. Unit 2. Customizing and Enhancing PowerPoint Presentations. 5. Creating Tables, Charts, and SmartArt Graphics. 6. Using Slide Masters and Action Buttons. 7. Applying Custom Animation and Setting Up Shows. 8. Integrating, Sharing and Protecting Presentations. Unit 2 Performance Assessment. PowerPoint Index.

*Internet Resource Center: www.emcp.net/BenchmarkPowerPoint13

376 pages

408 pages

Price $43.95 $33.95 $19.95 $24.95 Price

ISBN 978-0-76385-393-8 978-0-76385-901-5 978-0-76385-902-2 978-0-76385-443-0 ISBN

$135.95 $72.95

978-0-76385-454-6 978-0-76385-445-4

$135.95

978-0-76385-450-8

*Internet Resource Center: www.emcp.net/BenchmarkAccess13

Benchmark Series: Microsoft® PowerPoint 2013

Computer Applications

Benchmark Series: Microsoft® Access 2013 Levels 1 and 2

800-328-1452 | 800-328-4564 Fax

Price $43.95 $33.95 $19.95 $24.95 Price

ISBN 978-0-76385-394-5 978-0-76385-903-9 978-0-76385-904-6 978-0-76385-443-0 ISBN

$135.95 $72.95

978-0-76385-454-6 978-0-76385-445-4

$135.95

978-0-76385-450-8

*Internet Resource Center: www.emcp.net/BenchmarkAccess13

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Computer Applications

Benchmark Series: Microsoft Word 2010 Levels 1 and 2

Nita Rutkosky, Pierce College at Puyallup and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

Nita Rutkosky, Pierce College at Puyallup; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

1,448 pages

Student Courseware Text (softcover) with data files CD eBook 6 year license Text with data files CD and SNAP 2010 Tutorials CD

• Case-based approach creates a realistic context for learning practical skills. • Case study assessments at chapter and unit levels test students’ abilities to solve problems independently.

Instructor Resources *Print Instructor’s Guide with DVD *Instructor’s Guide DVD *EXAMVIEW® Assessment Suite

• Capstone integrated project capitalizes on the power of the Office suite. • Includes model answer images for in-chapter projects.

Student Courseware Text (softcover) with data files CD eBook 6 year license Text with data files CD and SNAP 2010 Tutorials CD

Price

ISBN

$105.95 $91.95

978-0-76383-811-9 978-0-76384-349-6

$120.95

978-0-76383-815-7

Access 2010 Unit 1. Creating Tables and Queries. 1. Managing and Creating Tables. 2. Creating Relationships between Tables. 3. Performing Queries. 4. Creating and Modifying Tables in Design View. Unit 1 Performance Assessment. Access 2010 Unit 2. Creating Forms and Reports. 5. Creating Forms. 6. Creating Reports and Mailing Labels. 7. Modifying, Filtering, and Viewing Data. 8. Importing and Exporting Data. Unit 2 Performance Assessment. Access Index. PowerPoint 2010 Unit 1. Creating and Formatting PowerPoint Presentations. 1. Preparing a PowerPoint Presentation. 2. Modifying a Presentation and Using Help. 3. Formatting Slides. 4. Inserting Elements in Slides. Unit 1 Performance Assessment. PowerPoint 2010 Unit 2. Customizing and Enhancing PowerPoint Presentations. 5. Creating Tables, Charts, and SmartArt Graphics. 6. Using Slide Masters and Action Buttons. 7. Applying Custom Animation and Setting Up Shows. 8. Integrating, Sharing, and Protecting Presentations. Unit 2 Performance Assessment. PowerPoint Index. Office 2010 Integrated Project. Instructor Resources *Print Instructor’s Guide with DVD *Instructor’s Guide DVD *EXAMVIEW® Assessment Suite

Price

ISBN

$135.95 $72.95

978-0-76383-895-9 978-0-76383-812-6

$135.95

978-0-76383-813-3

*Internet Resource Center: www.emcp.net/benchmarkoffice10

Package your text with SNAP Classroom Online Training and Assessment Program.

800-328-1452 | 800-328-4564 Fax

Student Courseware SNAP 2010 Tutorials CD SNAP Classroom 2010 Training and Assessment Site License

752 pages

Meets Microsoft Office Specialist Certification Exam Objectives

Students build a working knowledge and introductory skill level in Word, Excel, Access, and PowerPoint with the case-based, certification approach to learning.

CONTENTS Preface. Getting Started in Office 2010. Using Windows 7. Browsing the Internet Using Internet Explorer 8.0. Word 2010 Unit 1. Editing and Formatting Documents. 1. Preparing Documents. 2. Formatting Characters and Paragraphs. 3. Customizing Paragraphs. 4. Formatting Pages. Unit 1 Performance Assessment. Word 2010 Unit 2. Enhancing and Customizing Documents. 5. Applying Formatting and Inserting Objects. 6. Maintaining Documents. 7. Creating Tables and SmartArt. 8. Merging Documents. Unit 2 Performance Assessment. Word Index. Excel 2010 Unit 1. Preparing and Formatting a Worksheet. 1. Preparing an Excel Workbook. 2. Inserting Formulas in a Worksheet. 3. Formatting an Excel Worksheet. 4. Enhancing a Worksheet. Unit 1 Performance Assessment. Excel 2010 Unit 2. Enhancing the Display of Workbooks. 5. Moving Data within and between Workbooks. 6. Maintaining Workbooks. 7. Creating a Chart in Excel. 8. Adding Visual Interest to Workbooks. Unit 2 Performance Assessment. Excel Index.

With Benchmark Series: Microsoft® Word 2010 Levels 1 and 2, students build mastery skill level in Word 2010. Students receive step-by-step instructions in creating letters, reports, research papers, brochures, newsletters, and other documents.

Price $24.95

ISBN 978-0-76383-894-2

$7.95

978-0-76384-754-8

Price

ISBN

$88.95 $76.95

978-0-76384-299-4 978-0-76384-351-9

$103.95

978-0-76383-826-3

Price

ISBN

$135.95 $72.95

978-0-76383-897-3 978-0-76383-880-5

$135.95

978-0-76384-342-7

*Internet Resource Center: www.emcp.net/benchmarkword10

Benchmark Series: Microsoft® Word 2010 Level 1

Benchmark Series: Microsoft® Word 2010 Level 2

Nita Rutkosky, Pierce College at Puyallup and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

Nita Rutkosky, Pierce College at Puyallup; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

408 pages

Student Courseware Text (softcover) with data files CD eBook 6 year license Text with data files CD and SNAP 2010 Tutorials CD

$48.95 $33.95

978-0-76384-300-7 978-0-76384-352-6

$63.95

978-0-76383-827-0

Instructor Resources

Price

*Print Instructor’s Guide with DVD *Instructor’s Guide DVD *EXAMVIEW® Assessment Suite

CONTENTS Preface. Getting Started in Office 2010. Using Windows 7. Browsing the Internet Using Internet Explorer 8.0. Word 2010 Level 1 Unit 1. Editing and Formatting Documents. 1. Preparing Documents. 2. Formatting Characters and Paragraphs. 3. Customizing Paragraphs. 4. Formatting Pages. Level 1 Unit 1 Performance Assessment. Level 1 Unit 2. Enhancing and Customizing Documents. 5. Applying Formatting and Inserting Objects. 6. Maintaining Documents. 7. Creating Tables and SmartArt. 8. Merging Documents. Level 1 Unit 2 Performance Assessment. Level 1 Index. Word 2010 Level 2 Unit 1. Formatting and Customizing Documents. 1. Customizing Paragraphs and Pages. 2. Proofing Documents. 3. Automating and Customizing Formatting. 4. Customizing and Navigating in a Document. Level 2 Unit 1 Performance Assessment. Level 2 Unit 2. Referencing and Sharing Information. 5. Inserting Special Features and References. 6. Creating Specialized Tables and Indexes. 7. Working with Shared Documents. 8. Protecting and Preparing Documents. Level 2 Unit 2 Performance Assessment. Level 2 Index.

Price

ISBN

$135.95 $72.95

978-0-76383-897-3 978-0-76383-880-5

$135.95

978-0-76384-342-7

Package your text with SNAP Classroom Online Training and Assessment Program.

*Free to adopters of 20 or more texts

Student Courseware Text (softcover) with data files CD eBook 6 year license Text with data files CD and SNAP 2010 Tutorials CD Instructor Resources *Print Instructor’s Guide with DVD *Instructor’s Guide DVD *EXAMVIEW® Assessment Suite

Student Courseware SNAP 2010 Tutorials CD SNAP Classroom 2010 Training and Assessment Site License

Computer Applications

Benchmark Series: Microsoft Office 2010

360 pages

Price

ISBN

$48.95 $33.95

978-0-76384-301-4 978-0-76384-353-3

$63.95

978-0-76383-828-7

Price

ISBN

$135.95 $72.95

978-0-76383-897-3 978-0-76383-880-5

$135.95

978-0-76384-342-7

Price $24.95

ISBN 978-0-76383-898-0

$7.95

978-0-76384-754-8

emcschool.com | email: educate@emcp.com

Computer Applications

704 pages

Meets Microsoft Office Specialist Certification Exam Objectives

Instructor Resources *Print Instructor’s Guide with DVD *Instructor’s Guide DVD *EXAMVIEW® Assessment Suite

Price

ISBN

$88.95 $76.95

978-0-76384-313-7 978-0-76384-355-7

$103.95

978-0-76383-839-3

Price

ISBN

$135.95 $72.95

978-0-76383-900-0 978-0-76383-881-2

$135.95

978-0-76384-342-7

*Internet Resource Center: www.emcp.net/benchmarkexcel10

Instructor Resources *Print Instructor’s Guide with DVD *Instructor’s Guide DVD *EXAMVIEW® Assessment Suite

CONTENTS Preface. Getting Started in Office 2010. Using Windows 7. Browsing the Internet Using Internet Explorer 8.0. Excel 2010 Level 1 Unit 1. Preparing and Formatting a Worksheet. 1. Preparing an Excel Workbook. 2. Inserting Formulas in a Worksheet. 3. Formatting an Excel Worksheet. 4. Enhancing a Worksheet. Level 1 Unit 1 Performance Assessment. Level 1 Unit 2. Enhancing the Display of Workbooks. 5. Moving Data within and between Workbooks. 6. Maintaining Workbooks. 7. Creating a Chart in Excel. 8. Adding Visual Interest to Workbooks. Level 1 Unit 2 Performance Assessment. Level 1 Index. Excel 2010 Level 2 Unit 1. Advanced Formatting, Formulas, and Data Management. 1. Advanced Formatting Techniques. 2. Advanced Functions and Formulas. 3. Working with Tables and Data Features. 4. Summarizing and Consolidating Data. Level 2 Unit 1 Performance Assessment. Level 2 Unit 2. Managing and Integrating Data and the Excel Environment. 5. Using Data Analysis Features. 6. Protecting and Sharing Workbooks. 7. Automating Repetitive Tasks and Customizing Excel. 8. Importing, Exporting, and Distributing Data. Unit 2 Performance Assessment. Level 2 Index.

768 pages

Price

ISBN

$88.95 $76.95

978-0-76384-305-2 978-0-76384-358-8

$103.95

978-0-76383-852-2

Price

ISBN

$135.95 $72.95

978-0-76383-903-1 978-0-76383-882-9

$135.95

978-0-76384-342-7

*Internet Resource Center: www.emcp.net/benchmarkaccess10

Benchmark Series: Microsoft® Excel 2010 Level 2

Benchmark Series: Microsoft® Access 2010 Level 1

Nita Rutkosky, Pierce College at Puyallup; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

Denise Seguin, Fanshawe College

Nita Rutkosky, Pierce College at Puyallup; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

336 pages

384 pages

Price

$48.95 $33.95

978-0-76384-314-4 978-0-76384-356-4

$63.95

978-0-76383-840-9

Price

ISBN

$135.95 $72.95

978-0-76383-900-0 978-0-76383-881-2

$135.95

978-0-76384-342-7

Package your text with SNAP Classroom Online Training and Assessment Program.

800-328-1452 | 800-328-4564 Fax

Student Courseware SNAP 2010 Tutorials CD SNAP Classroom 2010 Training and Assessment Site License

Price

ISBN

$48.95 $33.95

978-0-76384-315-1 978-0-76384-357-1

$63.95

978-0-76383-841-6

Price

ISBN

$135.95 $72.95

978-0-76383-900-0 978-0-76383-881-2

$135.95

978-0-76384-342-7

Price $24.95

$7.95

ISBN 978-0-76383-901-7

978-0-76384-754-8

With Benchmark Series: Microsoft® Access 2010 Levels 1 and 2, students build mastery skills in Access 2010. Students receive step-by-step instructions in planning, creating, and managing databases to report and analyze information.

Meets Microsoft Office Specialist Certification Exam Objectives

Benchmark Series: Microsoft® Excel 2010 Level 1

With Benchmark Series: Microsoft® Excel 2010 Levels 1 and 2, students build mastery skills in the Excel 2010 application. Students receive stepby-step instructions in creating, formatting, and maintaining Excel workbooks for numbers-based data analysis.

CONTENTS Preface. Getting Started in Office 2010. Using Windows 7. Browsing the Internet Using Internet Explorer 8.0. Access 2010 Level 1 Unit 1. Creating Tables and Queries. 1. Managing and Creating Tables. 2. Creating Relationships between Tables. 3. Performing Queries. 4. Creating and Modifying Tables in Design View. Level 1 Unit 1 Performance Assessment. Level 1 Unit 2. Creating Forms and Reports. 5. Creating Forms. 6. Creating Reports and Mailing Labels. 7. Modifying, Filtering, and Viewing Data. 8. Importing and Exporting Data. Level 1 Unit 2 Performance Assessment. Level 1 Index. Access 2010 Level 2 Unit 1. Advanced Tables, Relationships, Queries, and Forms. 1. Designing the Structure of Tables. 2. Building Relationships and Lookup Fields. 3. Advanced Query Techniques. 4. Creating and Using Custom Forms. Level 2 Unit 1 Performance Assessment. Level 2 Unit 2. Advanced Reports, Access Tools, and Customizing Access. 5. Creating and Using Custom Reports. 6. Using Access Tools and Managing Objects. 7. Automating, Customizing, and Securing Access. 8. Integrating Access Data. Level 2 Unit 2 Performance Assessment. Level 2 Index.

Computer Applications

Student Courseware Text (softcover) with data files CD eBook 6 year license Text with data files CD and SNAP 2010 Tutorials CD

Benchmark Series: Microsoft Access Levels 1 and 2

Benchmark Series: Microsoft Excel 2010 Levels 1 and 2

376 pages

408 pages

Price

ISBN

$48.95 $33.95

978-0-76384-306-9 978-0-76384-359-5

$63.95

978-0-76383-853-9

Price

ISBN

$135.95 $72.95

978-0-76383-903-1 978-0-76383-882-9

$135.95

978-0-76384-342-7

Package your text with SNAP Classroom Online Training and Assessment Program.

*Free to adopters of 20 or more texts

Student Courseware SNAP 2010 Tutorials CD SNAP Classroom 2010 Training and Assessment Site License

Price

ISBN

$48.95 $33.95

978-0-76384-307-6 978-0-76384-360-1

$63.95

978-0-76383-854-6

Price

ISBN

$135.95 $72.95

978-0-76383-903-1 978-0-76383-882-9

$135.95

978-0-76384-342-7

Price $24.95

ISBN 978-0-76383-904-8

$7.95

978-0-76384-754-8

emcschool.com | email: educate@emcp.com

Computer Applications

456 pages

With Benchmark Series: Microsoft® PowerPoint 2010, students build mastery skills in PowerPoint. Students receive step-by-step instructions in designing and creating effective slide shows that inform and motivate audiences.

Signature Series: Microsoft Word 2013 ®

Prepare your students for the Word 2013 skills required in college and the job market with Signature Series: Microsoft® Word 2013. Students build their technical knowledge and reinforce their problem-solving abilities using a graduated progression of learning solutions, from guided tutorials to independent challenges. • Interdisciplinary unit assessment activities reinforce writing and problem-solving skills within the context of creating Word documents. • Expanded sets of chapter exercises offers instructors greater choice in selecting assignments. • Meets Microsoft Certification Exam Objectives.

Meets Microsoft Office Specialist Certification Exam Objectives Student Courseware Text (softcover) with data files CD eBook 6 year license Text with data files CD and SNAP 2010 Tutorials CD Instructor Resources *Print Instructor’s Guide with DVD *Instructor’s Guide DVD *EXAMVIEW® Assessment Suite

Price

ISBN

$68.95 $51.95

978-0-76384-309-0 978-0-76384-361-8

$83.95

978-0-76383-859-1

Price

ISBN

$135.95 $72.95

978-0-76383-906-2 978-0-76383-908-6

$135.95

978-0-76384-342-7

CONTENTS Preface. Getting Started in Office 2010. Using Windows 7. Browsing the Internet Using Internet Explorer 8.0. Unit 1. Creating and Formatting PowerPoint Presentations. 1. Preparing a PowerPoint Presentation. 2. Modifying a Presentation and Using Help. 3. Formatting Slides. 4. Inserting Elements in Slides. Unit 1 Performance Assessment. Unit 2. Customizing and Enhancing PowerPoint Presentations. 5. Creating Tables, Charts, and SmartArt Graphics. 6. Using Slide Masters and Action Buttons. 7. Applying Custom Animation and Setting Up Shows. 8. Integrating, Sharing, and Protecting Presentations. Unit 2 Performance Assessment. Index.

Computer Applications

Comprehensive Approach

Benchmark Series: Microsoft PowerPoint 2010

*Internet Resource Center: www.emcp.net/benchmarkpowerpoint10

eBooks available—works on all devices!

Package your text with SNAP Classroom Online Training and Assessment Program.

Student Courseware SNAP 2010 Tutorials CD SNAP Classroom 2010 Training and Assessment Site License

Price $24.95

ISBN 978-0-76383-907-9

Using the Undo and Redo Buttons $7.95

978-0-76384-754-8

Undo

Visit emcschool.com for additional information and packaging options for our Benchmark Series: Microsoft Office 2007 titles.

Redo

If you make a mistake and delete text that you did not intend to delete or if you change your mind after deleting text and want to retrieve it, you can use the Undo or Redo button on the Quick Access toolbar. For example, if you type text and then click the Undo button, the text will be removed. You can undo text or commands. For example, if you add formatting such as bolding to text and then click the Undo button, the bolding is removed. If you use the Undo button and then decide you do not want to reverse the original action, click the Redo button. For example, if you select and underline text and then decide to remove the underlining, click the Undo button. If you then decide you want the underlining back on, click the Redo button. Many Word actions can be undone or redone. Some actions, however, such as printing and saving, cannot be undone or redone. Word maintains actions in temporary memory. If you want to undo an action that you performed earlier, click the Undo button arrow. This causes a drop-down list to display. To make a selection from this drop-down list, click the desired action and the action, along with any actions listed above it in the drop-down list, is undone.

Students compare their work to model answers to ensure accuracy.

November 4, 2015

Exercise 1.4

Exercise 1.5

Deleting and Restoring Text with the Undo and Redo Buttons

Part 1 of 1

1. Open SoftwareSuites.docx. (This document is located in the Chapter01 folder you copied to your storage medium.) 2. Save the document with Save As and name it C01-E05-SoftwareSuites. 3. Make the changes indicated by the proofreaders’ marks in Figure 1.9 on the next page. (Proofreaders’ marks are listed and described in Appendix A at the end of this textbook.) 4. Move the insertion point to the end of the document. Press the Backspace key until the last four words of the document (or into a spreadsheet.) are deleted. Be sure to delete the space before or. 5. Undo the deletion by clicking the Undo button on the Quick Access toolbar. 6. Redo the deletion by clicking the Redo button on the Quick Access toolbar. 7. Type a period after the word presentation to end the sentence. 8. Select the first sentence in the first paragraph and then delete it. 9. Select the second paragraph in the document and then delete it. Step Step 10a 10b 10. Undo the two deletions by completing the following steps: a. Click the down-pointing arrow to the right of the Undo button. b. Click the second Clear listed in the drop-down list. (This will redisplay the first sentence in the first paragraph and the second paragraph. The first sentence will be selected.) 11. With the first sentence of the paragraph selected, press the Delete key. 12. Save, print, and then close C01-E05-SoftwareSuites.docx.

C01-E04-LtrKCC.docx

Dr. Avery Reynolds Kodiak Community College 310 Northern Lights Boulevard Anchorage, AK 99033 Dear Dr. Reynolds: I enjoyed meeting you and discussing the implementation of a Pharmacy Tech program into the Business Information Technology curriculum. As I mentioned, we added a pharmacy tech program to our department at Cascade Community College last year. We advertised it in our college schedule and sent brochures to all high school seniors in our district. Thirty people registered for the program, and student evaluations, which were completed last semester, were very favorable. If you would like more information about the program, please call me at (712) 555-3400. I will be attending the National Computer Technology conference. I hope to see you there. Sincerely,

Kerry Brown XX LtrKCC.docx

Software suites typically include the four most widely used applications: word processing, database management, spreadsheet, and presentation applications. Some, such as Microsoft Office, also include web page authoring programs because the development of personal websites is becoming increasingly important to consumers. Suites are popular because buying a package is less expensive than purchasing each component program separately. Software suites offer advantages other than price. Because the programs were developed using the same user interface, all programs in the suite function in a similar manner. A user who becomes familiar with one program can easily learn to use the others because the screen layouts, tabs, menus, buttons, icons, and toolbars are similar. Another strong feature of suites is that they allow users to seamlessly integrate files from component programs. For example, information produced using a spreadsheet can be placed into a word processing document, or a database table can be imported into a slide show presentation.

Exercise 1.5 C01-E05-SoftwareSuites.docx

Chapter One

Step-by-step exercises provide students with the opportunity to practice Word skills using features immediately after they read about them.

800-328-1452 | 800-328-4564 Fax

Creating, Printing, and Editing Documents

emcschool.com | email: educate@emcp.com

Computer Applications

Signature Series: Microsoft Word 2010

Nita Rutkosky, Pierce College at Puyallup; and Audrey Rutkosky Roggenkamp, Pierce College at Puyallup

Nita Rutkosky, Pierce College at Puyallup; and Audrey Roggenkamp, Pierce College at Puyallup

1,152 pages

New!

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license SNAP 2013 Tutorials CD

Price $96.95 $86.95 $19.95 $24.95

Instructor Resources *Instructor’s Guide (print and CD) with EXAMVIEW® *Instructor’s Guide with EXAMVIEW® (CD only)

Price

ISBN 978-0-76385-199-6 978-0-76385-933-6 978-0-76385-907-7 978-0-76385-205-4 ISBN

$135.95

978-0-76385-204-7

$135.95

978-0-76385-206-1

*Internet Resource Center: www.emcp.net/SignatureWord13

CONTENTS Unit 1. Preparing Documents. 1. Creating, Printing, and Editing Documents. 2. Formatting Characters. 3. Aligning and Indenting Paragraphs. 4. Customizing Paragraphs. 5. Proofing Documents. Unit 2. Formatting and Managing Documents. 6. Formatting Pages. 7. Customizing Page Formatting. 8. Inserting Elements and Navigating in a Document. 9. Maintaining Documents. 10. Managing and Printing Documents. Unit 3. Enhancing Documents. 11. Inserting Images. 12. Inserting Shapes, WordArt and Advanced Character Formatting. 13. Creating Tables. 14. Enhancing Tables. 15. Creating Charts. Unit 4. Managing Data. 16. Merging Documents. 17. Managing Lists. 18. Sorting and Selecting; Finding and Replacing Data. 19. Managing Page Numbers, Headers, and Footers. 20. Managing Shared Documents. Unit 5. Customizing Documents and Features. 21. Inserting and Customizing Quick Parts. 22. Customizing AutoCorrect and Word Options. 23. Customizing Themes. 24. Creating and Managing Styles. 25. Protecting, Preparing, and Sharing Documents. Unit 6. Referencing Data. 26. Inserting Endnotes, Footnotes, and References. 27. Creating Indexes. 28. Creating Specialized Tables. 29. Creating Forms. 30. Using Outline View and Formatting with Macros. Appendices. Index.

Signature Series: Microsoft® Word 2010 offers students clear and comprehensive instruction to develop a mastery skill level in Word. Realistic projects and critical-thinking assignments give them the practice they need to excel in college and the job market.

1,152 pages

Aligns with Microsoft Office Specialist Objectives Student Courseware Text (softcover) with data files CD eBook 6 year license Text with SNAP 2010 Tutorials CD Instructor Resources *Instructor’s Guide with EXAMVIEW® (Print and DVD) *Instructor’s Guide with EXAMVIEW® (DVD only)

Price

ISBN

$87.95 $77.95

978-0-76384-295-6 978-0-76384-362-5

$102.95

978-0-76384-015-0

Price

ISBN

$135.95

978-0-76383-759-4

$135.95

978-0-76383-760-0

*Internet Resource Center: www.emcp.net/signatureword2010

Package your text with SNAP Classroom Online Training and Assessment Program.

Coming Soon! Signature Series: Advanced Microsoft Word 2013: Desktop Publishing

CONTENTS Unit 1. Preparing Documents. 1. Creating, Printing, and Editing Documents. 2. Formatting Characters. 3. Aligning and Indenting Paragraphs. 4. Customizing Paragraphs. 5. Proofing Documents. Unit 2. Formatting and Managing Documents. 6. Formatting Pages. 7. Customizing Page Formatting. 8. Inserting Elements and Navigating in a Document. 9. Maintaining Documents. 10. Managing and Printing Documents. Unit 3. Enhancing Documents. 11. Inserting Images. 12. Inserting Shapes and WordArt. 13. Creating Tables. 14. Enhancing Tables. 15. Creating Charts. Unit 4. Managing Data. 16. Merging Documents. 17. Sorting and Selecting. 18. Managing Lists. 19. Managing Page Numbers, Headers, and Footers. 20. Managing Shared Documents. Unit 5. Customizing Documents and Features. 21. Inserting and Customizing QuickParts. 22. Customizing AutoCorrect and Word Options. 23. Customizing Themes. 24. Creating and Managing Styles. 25. Protecting and Preparing Documents. Unit 6. Referencing Data. 26. Inserting Endnotes, Footnotes, and References. 27. Creating Indexes. 28. Creating Specialized Tables. 29. Creating Forms. 30. Using Outline View and Formatting with Macros. Appendices. Index.

Student Courseware SNAP 2010 Tutorials CD SNAP Classroom 2010 Training and Assessment Site License

Price $24.95

ISBN 978-0-76384-014-3

$7.95

978-0-76384-754-8

Computer Applications

Signature Series: Microsoft Word 2013

Signature Series: Advanced Microsoft Word 2010: Desktop Publishing ®

Student Courseware Text (softcover) with data files CD eBook 6 year license Instructor Resources *Instructor’s Guide with EXAMVIEW® (Print and DVD)

734 pages

Price $97.95 $82.95

ISBN 978-0-76383-890-4 978-0-76384-363-2

Price

$135.95

ISBN

978-0-76383-891-1

*Internet Resource Center: www.emcp.net/advancedword2010

Signature Series: Advanced Microsoft® Word 2010: Desktop Publishing text offers comprehensive instruction and practice with illustrated, step-by-step instructions in advanced Word 2010 techniques.

CONTENTS Unit 1. Creating Business and Personal Documents. 1. Understanding the Desktop Publishing Process. 2. Preparing Internal Workplace Documents. 3. Creating Letterheads, Envelopes, and Business Cards. 4. Creating Personal Documents. Unit 2. Preparing Promotional Documents and Newsletters. 5. Creating Promotional Documents— Flyers and Announcements. 6. Creating Brochures and Booklets. 7. Creating Specialty Promotional Documents. 8. Creating Basic Elements of a Newsletter. 9. Using Design Elements to Enhance Newsletters. Unit 3. Producing Web Pages, Microsoft Publisher Documents, and PowerPoint Presentations. 10. Creating Web Pages and Forms. 11. Introducing Microsoft Publisher 2010. 12. Creating Presentations Using PowerPoint. Index.

Visit emcschool.com for information and packaging options for our Signature Series: Microsoft Word 2007 titles.

800-328-1452 | 800-328-4564 Fax

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Computer Literacy

With this one-textbook solution, educators and students will experience a seamless transition from concepts to applications coverage—both written in the same style and presented in the same way. Using a projects-based approach, students will:

Computer Applications with Microsoft Office 2013 ®

512 pages

New!

• L earn computer skills they need to know to be successful in today’s digital world. • I mmediately “do” activities—topics are chunked and concept coverage is organized in brief twoor four-page spreads, appealing to a variety of learning styles. • R eference visual aids throughout the text, including: pictures, diagrams, charts, graphs, etc. • R eview and reinforce learning through end-ofchapter projects. • B e exposed to the latest concepts and software— including green computing, ethics, Windows 8 and Microsoft® Office 2013.

768 pages

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license Instructor Resources *Instructor’s Guide (print) with EXAMVIEW® CD

New! Price $105.95 $95.95 $19.95

ISBN 978-0-76385-187-3 978-0-76385-908-4 978-0-76385-910-7

Price

ISBN

$135.95

978-0-76385-188-0

Using Windows 8 and Managing Files

By default, the Messaging, Mail, and Calendar apps provide quick status and notifications on the Lock screen. 4 Tap or click the first button Step with a plus symbol in the Lock 4 screen apps section and tap or click Weather at the pop-up Choose an app list. The Weather app will now provide notifications when the screen is locked. 5 Tap or click Start screen at the top of the PC settings window. Step 5 6 Tap or click one of the 20 designs below the image of the current Start screen background. You determine the design you want to view. 7 Slide or drag the color slider to Your screen change the color of the Start may vary. screen background and designs. You determine the color you want to view. 8 Display the Start screen to view the new design and color scheme. 9 Tap or click your account name at the top right of the Start screen and tap or click Lock to view the new background. Step Step 7 6 10 Sign back in with your password to unlock the system. Note: Check with your instructor if you are completing this topic in a school computer lab to see if he or she wants you to restore the Lock and Start screen to the original settings by redoing Steps 1 through 8 and choosing the default Lock screen and Start screen options. Remove the Weather app from the Lock screen notifications by tapping or clicking the Weather button and tapping or clicking Don’t show quick status here at the top of the Choose an app list.

Change Lock Screen Background 1. Reveal Charms bar. 2. Tap or click Settings. 3. Tap or click Change PC settings. 4. Tap or click desired background picture. 5. Display Start screen. Add an App to the Lock Screen 1. Reveal Charms bar. 2. Tap or click Settings. 3. Tap or click Change PC settings. 4. Tap or click first plus symbol button in Lock screen apps section. 5. Tap or click desired app. 6. Display Start screen. Change Start Screen Design or Color Scheme 1. Reveal Charms bar. 2. Tap or click Settings. 3. Tap or click Change PC settings. 4. Tap or click Start screen. 5. Tap or click desired design. 6. Slide or drag color scheme slider to desired color. 7. Display Start screen.

When you are signed in with a Microsoft account, your Lock and Start screen settings are saved online. Sign in from another PC or mobile device and your new background, design, and color scheme will appear on the other device.

CONTENTS Part I: Computer Concepts. 1. Living in a Digital World. 2. Exploring the World Using the Internet. 3. Computer Hardware. 4. The Operating System and Utility Programs. 5. Application Software. 6. Using Social Media to Connect and Communicate. 7. Computer Security and Privacy. Appendix A. Buying a New Computing Device. Appendix B. Wireless Networking. Part II: Computer Applications with Microsoft Office 2013. 1. Using Windows 8 and Managing Files. 2. Navigating and Searching the Web. 3. Exploring Microsoft Office 2013 Essentials. 4. Organizing and Managing Class Notes Using OneNote. 5. Communicating and Scheduling Using Outlook. 6. Creating, Editing, and Formatting Documents using Word. 7. Enhancing a Document with Special Features. 8. Creating, Editing, and Formatting Worksheets Using Excel. 9. Working with Functions, Charts, and Page Layout Options in Excel. 10. Creating, Editing, and Formatting a Presentation using PowerPoint. 11. Enhancing a Presentation with Pictures, Sound, Video, and Animation Effects. 12. Using and Querying an Access Database. 13. Creating a Table, Form, and Report in Access. 14. Integrating Word, Excel, PowerPoint, and Access Components. 15. Using Windows Live SkyDrive and Other Cloud Computing Technologies.

Student Courseware Text with data files CD eBook 6 year license eBook 1 year license

Price $79.95 $69.95 $19.95

Instructor Resources *Instructor’s Guide (print) with EXAMVIEW® CD

Price

ISBN 978-0-76385-186-6 978-0-76385-912-1 978-0-76385-913-8 ISBN

$135.95

978-0-76385-188-0

*Internet Resource Center: www.emcp.net/SeguinCOMPUTER2013

COMPUTER Applications with Microsoft Office 2013 gives your students the practice they need to be successful in their academic and professional lives. End-of-chapter projects and exercises throughout that increase in levels of difficulty reinforce learning.

Computer Literacy

COMPUTER Concepts & Microsoft Office 2013

CONTENTS 1. Using Windows 8 and Managing Files. 2. Navigating and Searching the Web. 3. Exploring Microsoft Office 2013 Essentials. 4. Organizing and Managing Class Notes Using OneNote. 5. Communicating and Scheduling Using Outlook. 6. Creating, Editing, and Formatting Documents using Word. 7. Enhancing a Document with Special Features. 8. Creating, Editing, and Formatting Worksheets Using Excel. 9. Working with Functions, Charts, and Page Layout Options in Excel. 10. Creating, Editing, and Formatting a Presentation using PowerPoint. 11. Enhancing a Presentation with Pictures, Sound, Video, and Animation Effects. 12. Using and Querying an Access Database. 13. Creating a Table, Form, and Report in Access. 14. Integrating Word, Excel, PowerPoint, and Access Components. 15. Using Windows Live SkyDrive and Other Cloud Computing Technologies.

256 pages

New!

Student Courseware Text eBook 6 year license eBook 1 year license)

Price $69.95 $59.95 $19.95

Quick Steps summarize task instructions and help students quickly review chapter topics.

Instructor Resources *Instructor’s Guide (print) with EXAMVIEW® CD

Price

App Tips offer brief tidbits of information that help students maximize their use of applications.

*Internet Resource Center: www.emcp.net/SeguinCOMPUTER2013

$135.95

ISBN 978-0-76385-181-1 978-0-76385-775-2 978-0-76385-911-4 ISBN

COMPUTER Concepts provides comprehensive coverage of hardware, software, Internet, social media, security, and ethics. Its challenging end-of-chapter exercises move students from simple recall to advanced thinking and analysis of IT issues.

CONTENTS 1. Living in a Digital World. 2. Exploring the World Using the Internet. 3. Computer Hardware. 4. The Operating System and Utility Programs. 5. Application Software. 6. Using Social Media to Connect and Communicate. 7. Computer Security and Privacy. Appendix A. Buying a New Computing Device. Appendix B. Wireless Networking.

978-0-76385-188-0

Beyond Basics boxes expand the discussion of computer features and explain how to use them effectively.

Tap or click Account picture at the top of the PC settings window to add a picture to your account name on the Start screen. Tap or click the Browse button and navigate to the image file you want to use at the Files window. You can also use the Camera button to take a new picture of yourself using your PC or mobile device webcam.

*Internet Resource Center: www.emcp.net/SeguinCOMPUTER2013

800-328-1452 | 800-328-4564 Fax

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Computer Literacy

Our Digital World: Introduction to Computing, Second Edition

Computer and Internet Essentials: Preparing for IC3 teaches the skills and concepts required to successfully prepare for IC3 Global Standard 3 Certification, and includes information needed to learn essential computer skills that will help students succeed in future technology careers.

Appeal to today’s students with Our Digital World: Introduction to Computing, an innovative hybrid learning product that combines online activities and textbook resources. Today’s students are highly connected and they engage with a variety of technologies in a typical day, including text messaging, email, and social networking. Our Digital World: Introduction to Computing, Second Edition combines online activities and textbook resources to create an innovative hybrid learning product that appeals to contemporary students who want to do rather than only read. Its engaging writing style captures the excitement of cuttingedge technology developments and inspires students to explore topics and related ethical and security issues through videos, online research, and hands-on activities. For teachers, this approach offers flexibility in adapting course material to student needs and to course venues, from traditional lecture to online instruction, or a combination.

• Students learn information for today’s Internet users including email etiquette, online hazards, and privacy protection. • Identifies IC3 objectives correlated to the lessons allowing students to quickly identify lessons that will help them complete an objective. • Requires students to apply their critical thinking skills in order to work through a problem or scenario.

Nita Rutkosky, Pierce College at Puyallup; Audrey Roggenkamp, Pierce College at Puyallup; Ian Rutkosky, Pierce College at Puyallup; and Faithe Wempen, Indiana University/Purdue University at Indianapolis © 2013

816 pages

Student Courseware Text (hardcover) eBook 6 year license

Price $69.95 $59.95

Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price

ISBN 978-0-82196-317-3 978-0-82196-703-4 ISBN

$135.95

978-0-82196-322-7

*Internet Resource Center: www.emcp.net/IC3

Contents Unit 1: Computing Fundamentals. Topic 1: Understanding and Selecting a Computer. Topic 2: Using an Operating System. Topic 3: Choosing and Using Application Software. Unit 2: Key Applications. Topic 4: Working with Microsoft Office 2010 Applications. Topic 5: Editing a Document in Word. Topic 6: Formatting Characters and Paragraphs in Word. Topic 7: Creating and Enhancing Tables in Word. Topic 8: Formatting a Document in Word with Special Features. Topic 9: Analyzing Data Using Excel. Topic 10: Formatting an Excel Workbook. Topic 11: Preparing a Presentation. Topic 12: Inserting Graphic Elements in a Presentation and Integrating Word, Excel, and PowerPoint. Unit 3: Living Online. Topic 13: Understanding Networks and the Internet. Topic 14: Using a Web Browser. Topic 15: Using Email. Topic 16: Using PCs and the Internet Safely and Responsibly. Glossary. Index.

Accessing Items in the Control Panel

Drilling Down and Delving Deeper features additional information on key features within a lesson. IC correlations identify when a lesson or feature aligns with the IC3 exam objectives. 3

Items in the Control Panel with a multi-colored shield next to them can be changed only by a user whose account includes administrative privileges. When you attempt to open one of those items, a User Access Control dialog box appears to verify that the logged-in account has the appropriate privileges. If you are logged in as an administrator, you can click Yes or OK to move past this warning. If you are logged in as a standard user, you will not be allowed to make the change. Log out and then log in as a user with administrator privileges. You can change the level of a user account in the User Accounts and Family Safety (or User Accounts) section of the Control Panel.

Right-click printer to display shortcut menu

1-1.1.5, 1-3.3.4 default printer The printer that is set to be used automatically if another printer is not specified

Q uick S teps View the Installed Printers 1. Click Start. 2. Click Devices and Printers. View a Printer’s Queue from the Devices and Printers Window 1. Double-click printer. 2. If queue does not appear, double-click See what’s printing. Pause/Resume a Printer from the Print Queue Window 1. Click Printer on menu bar. 2. Click Pause Printing or Resume Printing. Pause/Resume/Cancel an Individual Print Job from the Print Queue Window

Print in an Application

A printer is one of the most common types of devices you can attach to a computer. They come in many varieties, including laser and inkjet. Some printers are multifunctional devices, combining the capabilities of a printer with those of a scanner, copier, and/or fax machine. When you print your work in an application, you can choose to which of the installed printers the work should be sent. If you do not specify which printer to use, the print job is sent to the printer designated as the default printer. The default printer is the printer that is used automatically if a particular printer is not specified by an application or print job. You can view the list of installed printers in Windows, choose which one will be the default, and even add a new printer to the list. You can also look at the properties for each printer, and make changes to them. To view the installed printers, click Start and then click Devices and Printers. At the Devices and Printers window (see Figure 2.22), you can double-click a printer and then click See what’s printing to view its queue (that is, the list of files in line to be printed), or right-click the printer’s icon and then select from its shortcut menu to view its properties, make it the default printer, and so on. (Two separate commands are available: Properties and Printer properties; each of these displays separate options.) Manage print jobs using the printer’s queue. Options include pausing or resuming the print job. For example, if you have an urgent file at the end of a printer queue, you can pause the jobs that precede it and then resume those files when the urgent file has been printed. To use a printer, open the application from which you want to print and then issue the Print command. The exact location of the command varies, but the most common place for it is on the File menu or File tab. Clicking File and then clicking Print typically opens a Print dialog box (or the Print tab Backstage view in Office applications), from which you can change any printer settings as needed before clicking the Print button to print the file.

1. Click File and then click Print. 2. Set print options as needed. 3. Click Print (or OK).

UNIT 1 Topic 2

800-328-1452 | 800-328-4564 Fax

Exercise 2.9 Working with Printers 1. Click Start and then click Devices and Printers. This is the default printer. 3. If more than one printer icon displays, right-click one of the others and then click Set as Default Printer. Repeat the steps to reset the original printer as the default. 4. Right-click the default printer and then click Printer properties.

Step 5

6. Examine the properties on several of the tabs in the properties dialog box and then click Cancel.

• Integrates collaborative activities, blogging, wikis, and podcasts throughout the chapters.

304 pages

CONTENTS 1. Digital Technologies: Exploring a Wealth of Possibilities. 2. The Internet: Gateway to a World of Resources. 3. Computer Hardware and Peripherals: Your Digital Toolbox. 4. System Software: The Control Center of Your Computer. 5. Applications Software: The Key to Digital Productivity. 6. Communication and Network Technologies: Connecting Through Computers. 7. The Social Web: Opportunities for Learning, Working, and Communicating. 8. Digital Defense: Securing Your Data and Privacy. Glossary. Index.

Instructor Resources *Instructor’s Guide with CD *Instructor Resources and EXAMVIEW® CD

2. Locate the printer icon that has the green circle with a check mark on it.

5. At the properties dialog box with the General tab selected, click the Print Test Page button.

Student Courseware Text and Online Companion Website Text and Core Content DVD eBook 6 year license and Online Companion Website SNAP Classroom 2010 Training and Assessment Site License Online Companion Website Core Content DVD

Lesson 2.9 Working with Printers

1. Click Document on menu bar. 2. Click Pause, Resume, or Cancel.

Figure 2.21 Devices and Printers Window

Jon Gordon; Karen Lankisch; Nancy Muir; Denise Seguin; and Anita Verno

Price

Computer Literacy

Computer and Internet Essentials: Preparing for IC3

ISBN

$87.95 $82.95

978-0-76384-765-4 978-0-76384-764-7

$77.95

978-0-76385-777-6

$7.95 $36.95 $26.95

978-0-76384-754-8 978-0-76384-761-6 978-0-76384-758-6

Price $135.95

ISBN 978-0-76384-769-2

$135.95

978-0-76384-763-0

• Provides extensive teacher support, including PowerPoint presentations with audio and a robust learning management system for scheduling assignments and tracking student participation in online course structures. • Core content activities, including videos and Flash movies, are available on DVD for students with limited Internet access. • Updated information on new technologies such as cloud storage and mobile apps. • All new Spotlight on the Future Podcasts with online multiple-choice quizzes. • Includes coverage on the Windows 8 Operating System.

*Internet Resource Center: www.emcp.net/digitalworld2e

7. Double-click the icon for the default printer to open its queue. If the print queue does not open, doubleclick the See what’s printing option.

Using an Operating System

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Computer Literacy

560 pages

CONTENTS Part 1. Learning Windows 8 Basics. 1. Working with the Windows 8 Desktop. 2. Working with Disks and Other Removable Media. 3. Learning about Files, Folders, and Libraries. 4. Organizing and Protecting Information. 5. Using Windows 8 Programs. 6. Customizing the Desktop and Start Screen. Part 2. Using the Internet and Multimedia with Windows 8. 7. Browsing with Internet Explorer. 8. Ensuring Your Safety and Privacy on the Internet. 9. Using Mail and Social Features. 10. Working with Digital Photographs and Music. Part 3. Basic Networking and System Maintenance. 11. Using Your System on a Network. 12. Maintaining Your System. 13. Adding Software and Hardware. Part 4. Power Computing Topics. 14. Troubleshooting and Repairing Your System. 15. Securing and Monitoring Your System. 16. Sharing Information On and Off the Road.

• Within- and end-of-chapter exercises reinforce steps, help students apply knowledge, and test problem-solving skills. Student Courseware Text eBook 6 year license eBook 1 year license

Price $73.95 $63.95 $19.95

Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price $135.95

ISBN 978-0-76384-797-5 978-0-76385-778-3 978-0-76385-915-2 ISBN

Faithe Wempen and Lisa Bucki 384 pages

New!

*Internet Resource Center: www.emcp.net/windows8

Price $73.95 $63.95

Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price

Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price $135.95

800-328-1452 | 800-328-4564 Fax

Faithe Wempen and Lisa Bucki

ISBN 978-0-76383-732-7 978-0-76384-379-3 ISBN 978-0-76383-808-9

Student Courseware Text

Price $56.95

ISBN 978-0-76384-019-8

$135.95

Student Courseware Text eBook 6 year license

Price $59.95 $49.95

Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price $135.95

224 pages

Instruction works for both Windows XP and Vista platforms.

ISBN 978-0-76384-798-2 978-0-76385-780-6 978-0-76385-914-5

Windows 7 – Brief Edition

*Internet Resource Center: www.emcp.net/windows7

Price $57.95 $47.95 $19.95

Windows 7 560 pages

CONTENTS 1. Communicating with Email. 2. Managing and Archiving Email Messages. 3. Using Calendar for Scheduling. 4. Managing Contacts 5. Creating Tasks and Notes. 6. Customizing and Integrating Outlook Components. Index.

• Quick Steps feature summaries in page margins provide handy references. • Comprehensive chapter assessments that challenges students to recall concepts and apply skills.

Instructor Resources *Instructor’s Guide at the Internet Resource Center

$72.95

www.emcp.net/ Outlook2010

Microsoft® Outlook 2007

Windows 8 – Brief Edition covers new and enhanced features of the new operating system, and reinforces the development of necessary skills.

Student Courseware Text eBook 6 year license eBook 1 year license

Microsoft® Outlook 2010 teaches students the functionality and features of the Outlook application. It has an emphasis on researching, sharing, and transferring information to succeed in a knowledge-based economy. • Clear instruction and step-by-step exercises correlated with screen visuals guide student learning.

*Internet Resource Center: www.emcp.net/windows8

Student Courseware Text eBook 6 year license

224 pages

Denise Seguin, Fanshawe College

978-0-76384-801-9

Windows 8 – Brief Edition

Faithe Wempen and Lisa Bucki

Denise Seguin, Fanshawe College

• Step-by-step instructions in Here’s How boxes present clear training and serve as a handy reference.

New!

Microsoft Outlook 2010

Systematic descriptions and illustrations of basic and intermediate Windows 8 features provide students with a sound command of the new operating system.

Computer Literacy

Windows 8

ISBN

CONTENTS 1. Using Outlook for Email. 2. Using Calendar for Scheduling. 3. Managing Contacts. 4. Creating Tasks and Notes. 5. Customizing, Integrating, and Archiving Outlook Components. Index. Student Courseware Text

Price $56.95

ISBN 978-0-76383-016-8

Instructor Resources *Instructor’s Guide at the Internet Resource Center

$72.95

www.emcp.net/ Outlook2007

384 pages

978-0-76384-801-9

Internet: Systems and Applications, Second Edition, covers cutting-edge information technology and trends including IM, wireless networks, security, and e-commerce. • Key principles about Internet access, security, browsing, and Email.

384 pages ISBN 978-0-76383-806-5 978-0-76384-381-6 ISBN

CONTENTS Preface. Unit 1. Using the Internet. 1. Understanding the Internet. 2. Accessing the Internet. 3. Ensuring Internet Security. Unit 2. Accessing Information on the Web. 4. Using a Web Browser. 5. Accessing Information Resources. 6. Downloading and Storing Information. Unit 3. Communications Technology. 7. Experiencing Multimedia. 8. Using Email. 9. Asynchronous Communications. 10. Synchronous Communications. Appendix A. Mozilla, Firefox. Glossary. Index

978-0-76383-808-9

Student Courseware Text with Encore CD

Price $51.95

ISBN 978-0-76383-193-6

Instructor Resources *Instructor Resources CD *EXAMVIEW® Assessment Suite CD

Price $72.95

ISBN 978-0-76383-194-3

$135.95

978-0-76383-195-0

*Internet Resource Center: www.emcp.net/InternetSystems2e

*Internet Resource Center: www.emcp.net/windows7

*Free to adopters of 20 or more texts

• Companion Encore CD includes Flash tutorials, reportable quizzes, glossary, and image bank.

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Programming

An Introduction to Programming Using Microsoft® Visual Basic 2010 emphasizes good problem-solving skills in a clear and easy-to-understand format.

A Guide to Web Development Using Adobe Dreamweaver CS5

480 pages

380 pages

Object-oriented programming concepts are integrated throughout the text and each chapter explains the use of Visual Basic controls. CONTENTS 1. Computer Technology. 2. Introducing Visual Basic. 3. Variables and Constants. 4. Controlling Program Flow with Decision Structures. 5. Controlling Program Flow with Looping Structures. 6. Procedures. 7. Mathematical and Business Functions. 8. Arrays and Structures. 9. Color, Sound, and Graphics. 10. Creating Classes. 11. Using Files. 12. Sorting and Searching. 13. MDI Applications. 14. Databases and Web Programming. Appendix A-Visual Basic for Applications (VBA). Index.

Student Courseware Text (hardcover) eBook 6 year license eBook 1 year license

Price $79.95 $69.95 $19.95

Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price $135.95

ISBN 978-0-82196-202-2 978-0-82196-702-7 978-0-82196-733-1 ISBN 978-0-82196-203-9

*Internet Resource Center: www.emcschool.net/VisualBasic2010

CONTENTS 1. Networks and the Internet. 2. HTML. 3. Introducing Dreamweaver. 4. Website Development. 5. Images in Dreamweaver and Fireworks. 6. Typography, Style Sheets, and Color 7. Introducing Flash. 8. Website Content, Forms, and Dynamic Web Pages. 9. Publishing and Promoting a Website. Appendix A-Banner Ads and ActionScript. Appendix B-Digital Camera Files. Appendix C-Templates. Appendix D-HTML Tags and Attributes. Appendix E-Final Projects. Index. Student Courseware Text (hardcover) eBook 6 year license eBook 1 year license

Price $69.95 $59.95 $19.95

ISBN 978-0-82196-208-4 978-0-82196-736-2 978-0-82196-737-9

A Guide to Programming in Java, Third Edition, emphasizes the development of good problemsolving and programming skills in a clear, easyto-understand format. It is written for different student learning styles and effectively uses screen shots of source code, generated output, and finished projects to strengthen understanding.

372 pages

CONTENTS 1. Computer Technology. 2. Introducing Java. 3. Variables and Constants. 4. Conditional Control Structures. 5. Loop Structures and Strings. 6. Methods. 7. Classes and Object-Oriented Development. 8. Inheritance and Polymorphism. 9. Arrays. 10. GUIs and Event-Driven Programming. 11. File and Exception Handling. 12. Recursion and Advanced Algorithms. 13. Data Structures. Appendix A-Unicode. Appendix B-Using JCreator. Appendix C-Applets and Web Programming. Index.

Student Courseware Text (hardcover) eBook 6 year license eBook 1 year license

Price $75.95 $65.95 $19.95

Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price $135.95

ISBN 978-0-82196-213-8 978-0-82196-704-1 978-0-82196-730-0 ISBN 978-0-82196-217-6

*Internet Resource Center: www.emcschool.net/Java3e

An Introduction to Programming Using Microsoft Visual Basic 2008

A Guide to Programming in Java, Second Edition for Java SE 5 and Java SE 6

Jan Marrelli

Beth Brown

480 pages

Student Courseware Text (hardcover)

Price $79.95

Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price $135.95

800-328-1452 | 800-328-4564 Fax

ISBN 978-0-82195-068-5 ISBN 978-0-82195-072-2

400 pages

Student Courseware Text (hardcover) with CD

Price $75.95

Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price $135.95

ISBN 978-0-82196-357-9

A Guide to Web Development Using Adobe Dreamweaver CS5 teaches Flash, Fireworks, and Dreamweaver in a full-color format. Students learn about Web development, HTML, CSS, and how to use Dreamweaver to create websites.

Web Development

An Introduction to Programming Using Microsoft Visual Basic 2010

• Each chapter discusses concepts which are then reinforced within hands-on activities. • All explanations, problems, and answers have been produced using Dreamweaver CS5, Fireworks CS5, and Flash CS5. • Students are introduced to the history, terminology, and concepts of networks and the Internet. Email protocol and careers associated with web development are also discussed. Instructor Resources *Instructor Resources and EXAMVIEW® CD

Price $135.95

ISBN 978-0-82196-210-7

*Internet Resource Center: www.emcp.net/DreamweaverCS5

480 pages

HTML Essentials, Second Edition, teaches the essential features and capabilities of HTML, including hypertext links, inline images, lists, fonts and colors, multimedia, tables, forms, page designs, and much more. • HTML 4.01, plus HTML 5 and Cascading Style Sheets (CSS), stressing backward, forward, and cross-browser compatibility, usability, and accessibility.

CONTENTS Introduction. 1. Creating a Basic Web Page. 2. Working with Online Documents. 3. Working with Fonts, Colors, and Backgrounds. 4. Working with Images and Other Media. 5. Working with Tables. 6. Working with Forms. 7. Designing Multi-Column Web Sites. Appendix A-HTML Quick Reference. Appendix B-HTML to XHTML Conversion Chart. Appendix C. Cascading Style Sheets Sampler. Appendix D-Special Characters Chart. Appendix E-Web-Safe Colors. Appendix F.-Working with JavaScript. Appendix G-Miscellaneous Technologies and Features. Glossary. Index.

• Students can work on many platforms; example files available for download in Windows, Macintosh, and Linux/Unix formats.

Student Courseware Text (softcover)

Instructor Resources *Instructor’s Guide at the Internet Resource Center *EXAMVIEW® Assessment Suite

Price $48.95

ISBN 978-0-76383-642-9

• Real-world case examples and hands-on tutorials and quizzes promote rapid learning and skill development.

Price

ISBN www.emcp.com/irc

$135.95

978-0-76383-707-5

*Internet Resource Center: www.emcp.net/html

ISBN 978-1-58003-123-3

*Free to adopters of 20 or more texts

emcschool.com | email: educate@emcp.com

Keyboarding

Paradigm Keyboarding and Applications I: Sessions 1-60 Using Microsoft® Word 2010, Sixth Edition

Paradigm’s all-new Keyboarding, Sixth Edition and SNAP Online Lab offer your students a streamlined and current approach to mastering life-long keyboarding skills. This easy-to-navigate program provides them with the tools they need through extensive drills, activities, and varied practice with contemporary documents. • In the Sessions 1-30 text, students are drilled on new keys and move from keying letters to words to sentences. • Keyboarding skills and techniques are introduced, developed, and continually reinforced. • Correct finger positioning, speed, and accuracy are emphasized with key drills, speed drills, and positional reinforcement drills. • 1-minute and 3-minute timings build speed and assess student progress.

176 pages

• Expository drills and writing assignments develop critical thinking and keyboard composition skills.

CONTENTS Introduction. Unit 1. Alphabetic Keys. Unit 2. Number Row Keys. Unit 3. Punctuation and Symbol Keys. Unit 4. Numeric Keypad. Unit 5. Thinking and Composing at the Keyboard. Unit 6. Alphabet Reinforcement. Unit 7. Email and Memos. Part I. Unit 8. Business Correspondence. Part I. Unit 9. Tables. Part I. Unit 10. Business Reports. Part I. Unit 11. Manuscripts and Research Papers. Part I. Unit 12. Productivity Measurement. Part I. Index. Appendix A. Appendix B. Student Courseware Text and SNAP Online Lab SNAP Online Lab

Price $95.95 $48.95

ISBN 978-0-76384-788-3 978-0-76384-785-2

Instructor Resources *Instructor’s Guide on CD

Price $72.95

ISBN 978-0-76384-786-9

*Internet Resource Center: www.emcp.net/keyboarding6e

• Included with the text, SNAP Online Lab allows teachers to deliver keyboarding courses, track performance, and communicate with students.

Student Courseware Text and SNAP Online Lab SNAP Online Lab

Price $62.95 $48.95

ISBN 978-0-76384-787-6 978-0-76384-785-2

Instructor Resources *Instructor’s Guide on CD

Price $72.95

ISBN 978-0-76384-786-9

*Internet Resource Center: www.emcp.net/keyboarding6e

The SNAP Online Lab is a totally web-based learning management system that lets you easily deliver keyboarding courses, track student performance, and communicate with your students. • Provides immediate feedback on speed and accuracy for all timings and production documents. • Includes videos that demonstrate proper finger positioning. • Incorporates diagnostic software that identifies keys that students struggle with and provides additional practice. • Includes a new gradebook for assigning, grading, tracking student progress, and downloading results.

800-328-1452 | 800-328-4564 Fax

*Free to adopters of 20 or more texts

480 pages

New!

In Sessions 1-33, students are drilled on new keys and move from keying letters to words to sentences. Sessions 34-60 teach students how to create memos, emails, letters, reports, manuscripts, and tables. • Correct finger positioning, speed, and accuracy are emphasized with key drills, speed drills, and positional reinforcement drills. • 1-minute, 3-minute, and 5-minute timings are used to build speed and assess student progress. • Expository drills and writing assignments develop critical thinking and keyboard composition skills. • Microsoft Word 2010 features are introduced and skills are developed and continually reinforced. • Correct formatting of business letters, memos, and emails is emphasized and practiced. • Students produce documents that combine keyboarding proficiency, use of Microsoft Word 2010 features, and critical thinking skills.

Paradigm Keyboarding and Applications II: Sessions 61-120 Using Microsoft® Word 2010, Sixth Edition

New!

CONTENTS Introduction. Unit 1. Alphabetic Keys. Unit 2. Number Row Keys. Unit 3. Punctuation and Symbol Keys. Unit 4. Numeric Keypad Keys. Unit 5. Thinking and Composing at the Keyboard.

William Mitchell, Consultant; Patricia King, Blackhowk Technical College; and Ronald Kapper, College of DuPage

Keyboarding

Paradigm Keyboarding, Sixth Edition

552 pages

New! CONTENTS Introduction. Unit 13. Email and Memos Part II. Unit 14. Business Correspondence Part II. Unit 15. Tables Part II. Unit 16. Business Reports Part II. Unit 17. Manuscripts and Research Papers. Part II. Unit 18. Graphics and Imagery. Unit 19. Publications. Unit 20. Family Law In-Basket Project. Unit 21. Medical Documents InBasket Project. Unit 22. Productivity Measurement Part II. Index. Appendix A. Appendix B. Student Courseware Text and SNAP Online Lab SNAP Online Lab

Price $99.95 $48.95

ISBN 978-0-76384-789-0 978-0-76384-785-2

Instructor Resources *Instructor’s Guide on CD

Price $72.95

ISBN 978-0-76384-786-9

*Internet Resource Center: www.emcp.net/keyboarding6e

In Sessions 61-120, students develop skills in creating memos, emails, letters, tables, business reports, manuscripts, and business publications. Also provided are simulated workplace exercises for additional practice.

• 1-minute, 3-minute, and 5-minute timings are used to build speed and assess student progress. • Writing assignments are used to enhance keyboard composition skills and develop critical thinking. • Microsoft Word 2010 skills are developed and continually reinforced. • Students produce documents in all sessions that reinforce formatting and Word skills. • Legal and Medical In-basket projects allow students to apply their keyboarding skills and knowledge of Word features to real-world document production and require them to make decisions, prioritize activities, and gather information.

emcschool.com | email: educate@emcp.com

Accounting

Computerized Accounting with QuickBooks® 2013

Robert L. Dansby; Burton S. Kaliski and Michael D. Lawrence

Kathleen Villani and James B. Rosa

1,296 pages

Teach the why and the how of accounting procedures through real-world scenarios and transactions. Learning-objective based instruction, clear examples, and up-to-date content make this program perfect for your students. • Key term lists plus terms defined in page margins teach the language of accounting. • Engaging illustrations, T accounts, and color-coded accounting documents clarify difficult procedures. • In the Real World part openers featuring well-known companies bring accounting concepts to life. Teacher Support CONTENTS: Introduction. Part I. Accounting for the Service Business. 1. The Nature of Accounting. 2. Recording Business Transactions. 3. Starting the Accounting Cycle for a Service Business. 4. The Accounting Cycle Continued: Work Sheet, Financial Statements, and Adjusting Entries. 5. Completing the Accounting Cycle for a Service Business: Closing Entries and the Post-Closing Trial Balance. Comprehensive Review Problem I. Part II. Accounting for Cash and the Merchandising Business. 6. Internal Control and Accounting for Cash. Appendix A. Appendix B. 7. Accounting for Merchandising Business: Purchases and Cash Payments. 8. Accounting for Merchandising Business: Sales and Cash Receipts. Appendix C. 9. Work Sheet and Adjustments for a Merchandising Business. Appendix D. 10. Financial Statements and Closing Entries for a Merchandising Business. Comprehensive Review Problem II. Part III. Accounting for Payroll. 11. Accounting for Payroll: Employee Earnings and Deductions. 12. Accounting for Payroll: Employer Taxes and Reports. Comprehensive Review Problem III. Part IV. Accounting for Notes and Interest, Bad Debts, Inventory, and Plant Assets and Depreciation. 13. Accounting for Notes and Interest. 14. Accounting for Bad Debts. 15. Accounting for Merchandise Inventory. 16. Accounting for Plant Assets and Depreciation. Appendix E. 17. Accounting for Accruals and Deferrals. Comprehensive Review Problem IV. Part V. Accounting for Partnerships and Corporations. 18. Accounting for Partnerships. 19. Corporate Accounting—Formation and Paid-In Capital. 20. Corporate Accounting: Earnings and Distribution. 21. Long-Term Liabilities and Investments. Comprehensive Review Problem V. Part VI. Accounting for Decision Making and Manufacturing Operations. 22. Statement of Cash Flows. 23. Analysis and Interpretation of Financial Statements. 24. Accounting for Departments and Branches. 25. Introduction to Manufacturing Accounting. 26. Job Order and Process Cost Accounting. Appendix F. Comprehensive Review Problem VI. Part VII. Budgeting Standard Costs and Cost Analysis. 27. Budgeting and Standard Cost Accounting. 28. Cost Behavior and Cost-Volume-Profit Analysis.

Instructor Resources *Teacher Resource Package (includes Annotated Instructor’s Edition, Instructor Resources DVD, Solutions Manual) *EXAMVIEW® Test Banks Print Solutions for Practice Sets 1, 2 & 3

Price

ISBN

$89.95 $59.95

978-0-82195-509-3 978-0-82195-194-1

$89.95

978-0-76383-494-4

*Internet Resource Center: www.emcp.net/CompAcctg

800-328-1452 | 800-328-4564 Fax

• Annotated Instructor’s Edition’s unique wrap-around design provides teacher material alongside student content—includes notes, hints, and classroom questions.

608 pages

New!

CONTENTS: 1. QuickBooks 2013. 2. Vendors. 3. Customers. 4. PeriodEnd Procedures. 5. Inventory. 6. New Company Setup —Detailed Start. 7. New Company Setup —Express Start. 8. Payroll Setup. 9. Payroll Processing. 10. Banking. 11. Jobs and Time Tracking. 12. Customizing Your Company File. Student Courseware Text with student disc and 140-day Trial CD Instructor Resources *Instructor’s Guide CD

Price

ISBN

$105.95

978-0-76385-314-3

Price $72.95

ISBN 978-0-76385-315-0

600 pages

New!

Internet Resource Center – includes Student Study Partner Content. • Animated tutorials, quizzing features, matching activities

ISBN 978-0-82195-203-0

$59.95

978-0-82195-719-6

$24.95 $19.95

978-0-82195-178-1 978-0-82195-208-5

$47.95

978-0-76383-500-2

$47.95

978-0-76383-499-9

$47 .95 $99.95

978-0-76383-586-6 978-0-82195-717-2

$16.95

978-0-82195-187-3

$19.95

978-0-82195-191-0

$19.95

978-0-82195-201-6

*Free to adopters of 20 or more texts

• Students create a company file, run accounts receivable and accounts payable, manage timetracking and payroll, track inventory and fixed assets, manage budgets, maintain ledgers and journals, and create reports.

Computerized Accounting with Sage 50 2013 offers your students reinforcement of accounting concepts, plus step-by-step Sage 50 software instruction. Hands-on practice with simulation exercises require students to create a company and apply the accounting skills they learn to all aspects of running their business.

Jim Mazza and Gary Chavez

• Excel, Peachtree, and QuickBooks templates

Price $69.95

• Case problems, a comprehensive problem, procedure reviews, and quizzes ensure software mastery.

Computerized Accounting with Sage 50® 2013

• Print-based solutions and test banks

Student Courseware Comprehensive Text (hardcover) Comprehensive eBook 6 year license Comprehensive Study Guide and Working Papers Study Partner CD Don Robertson Consulting Practice Set 1 Columbia River Computers Practice Set 2 Business Bookkeeping Solutions Practice Set 3 Practice Sets 1, 2 & 3 Working Papers in Excel 2007 on CD Peachtree 2008 Starter Files CD and Education Version Software CD QuickBooks 2008 Starter Files and Education Version Software CD

• Includes 140-day trial CD of QuickBooks Pro and Accountant 2013 Student Trial Edition Software.

*Internet Resource Center: www.emcp.net/quickbooks2013

• Instructor’s Resources DVD has the most valuable resources gathered for easy access.

• Interactive chapter summaries available in English and Spanish

Computerized Accounting with QuickBooks® 2013 offers your students clear, concise instruction that reinforces accounting concepts while teaching them how to execute key financial transactions.

Accounting

Comprehensive Accounting

CONTENTS: Preface. 1. Getting Started. 2. Setting Up a Company 3. Entering Transactions for a Cash Business. 4. Accounts Receivable and Sales for a Business. 5. Accounts Payable and Purchases for a Service Business. 6. Cash Payments and Cash Receipts. 7. Preparing the Financial Statement. 8. Purchasing of Inventory in a Merchandise Business. 9. Sales of Inventory in a Merchandise Business. 10. Payroll. 11. Job Costing. 12. Partnerships and Corporations. Appendix - Fixed Assets. Index. Student Courseware Text with student disc

Price $93.95

ISBN 978-0-76385-309-9

• CD with data files and a fully functioning copy of Sage 50 Complete 2013, Education Version. • Straightforward explanations for using the software to create a company file, run accounts payable, manage inventory and payroll, track inventory and fixed assets, maintain ledgers and journals, and create reports. Instructor Resources *Instructor’s Guide CD

Price $72.95

ISBN 978-0-76385-310-5

*Internet Resource Center: www.emcp.net/Sage2013

Computerized Accounting with Peachtree 2012

Computerized Accounting with QuickBooks 2012 Kathleen Villani and James B. Rosa Student Courseware Text with student disc and 140-day Trial CD eBook with 140-day Trial CD Instructor Resources *Instructor’s Guide CD

Price

600 pages

Jim Mazza and Gary Chavez ISBN

$105.95 $95.95

978-0-76384-773-9 978-0-76385-086-9

Price $72.95

ISBN 978-0-76384-774-6

592 pages

Student Courseware Text with student disc eBook with student disc

Price $93.95 $83.95

ISBN 978-0-76384-794-4 978-0-76385-087-6

Instructor Resources *Instructor’s Guide CD

Price $72.95

ISBN 978-0-76384-795-1

emcschool.com | email: educate@emcp.com

New Office 2013 textbooks address the unique needs and learning styles of your students.

How to Order By Phone 800-328-1452 Phone lines are open Monday through Friday from 8:00 a.m. to 5:00 p.m. (Central Time).

By Email pg. 4

pg. 6

Scan your purchase order and email it to educate@emcp.com. You will receive a confirmation email.

pg. 8

By Fax 800-328-4564 By Mail EMC Publishing Attention: Customer Service 875 Montreal Way St. Paul, MN 55102-4245

pg. 14

pg. 25

Online Visit emcschool.com Call 800-328-1452 or complete the online registration form.

New Computer Concepts & Applications Series— the one-textbook solution!

For Each Order

Please prepare a list of the items you wish to order, with the prices and ISBNs. Each order must include: 1. Purchase order number, payment, or VISA, MasterCard, or American Express number, cardholder address, security code, and expiration date. 2. School or library billing and shipping addresses. We cannot ship to a residence unless order is prepaid or charged to VISA, MasterCard, or American Express. If charged to a VISA, MasterCard, or American Express account, please list the billing address of your charge account in the “bill to” space on the order form.

pg. 28

Paradigm’s all-new Keyboarding, Sixth Edition offers your students a streamlined and current approach to master keyboarding skills.

800-328-1452 | 800-328-4564 Fax

3. Name and position of person ordering.

Terms are net 30 days from invoice date. Prices in this catalog reflect all discounts. Prices do not include taxes where applicable. A shipping and handling charge will be applied to all invoices within the continental United States. Minimum shipping and handling charge is $10.00. Method of shipment is at our discretion. If you wish to specify particular directions, an additional charge may be required. (An additional charge will be required for shipments outside of the continental United States.) The shipping and handling charge is billed as a separate item on the invoice.

Returns

Returns for materials purchased from EMC cannot be accepted unless written approval has been secured. Open software cannot be returned. Call 800-328-1452.

Prices

Prices stated in this catalog are in effect at the time of publication and are shown at school price (list price less educational discount). Prices are subject to change without notice. EMC will provide quotations and/or bids as may be required by your school or state.

Examination Copies for Listing and Adoptions

Where a listing or adoption is required prior to purchase, examination textbooks and selected materials may be sent for review by qualified committees or individuals. If your decision does not include EMC, please help us recycle our textbooks and join our conservation effort. Simply call our Customer Service Department at 800-328-1452 and ask for a call tag to be issued and we’ll arrange to pick up the materials. This is a complimentary service.

No part of any EMC textbook or multimedia component may be adapted, reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the permission of the publisher. The works may not be transmitted by television or other devices or processes or copied, recast, transformed, or adapted in any matter, in whole or in part, except where permission is granted. Product names included in this catalog have been used for identification purposes only and may be trademarks or registered trademarks of their respective owners.

Technical Support Service

Technical Support is available to our customers to answer questions pertaining to our software. Phone and email support is available Monday through Sunday from 8am-10pm (CST). Visit support.emcp.com to use our 24/7 Chat Service or to view FAQs, User Guides, Training Videos and more.

4. Address and telephone number.

EMC Publishing Technical Support

5. Quantity.

875 Montreal Way St. Paul, MN 55102 Phone: 800-328-1452 Email: support@emcp.com Web: support.emcp.com

6. Product title and ISBN. 7. Prices and totals (include sales tax where applicable).

pg. 36

Terms

875 Montreal Way St. Paul, MN 55102

Please share this catalog with your entire department!

All New Learning Solutions from EMC! Computer Applications • Computer Literacy • Programming Web Development • Keyboarding • Accounting

Go to www.emcschool.com or call 800-328-1452 to request your FREE review materials today!

Engage • Motivate • Challenge

ALCATF13