Microsoft Office 2007
Texts: Learning Microsoft Office 2007, Weixel, Fulton, Wempen, Skintik, Pearson Prentice Hall DDC Publishing - Includes Word, Excel, Access, PowerPoint, and Outlook
Cost: $43.00 - Search to see if you can find this book used at Amazon.com
Estimated hours: 50 to 200 hours depending your prior computer experience, knowledge of Windows, and data entry speed.
Additional Resources: You may want to purchase a reference manual for Microsoft Office in addition to your regular text book.
General Directions
- Your instructor will copy the student practice files that go with your book in a folder called DDC 2007 Lessons to your network folder. Be certain you are using the appropriate NETWORK DRIVE and FOLDER to store and retrieve your files (typically drive O:\). Ask if you are unsure.
- Complete all work in text with the exception of the On Your Own exercises. Print and hand in only the Critical Thinking exercises. Be sure to include the Exercise Number on your cover sheet. View all work in “print preview” before printing.
- Before submitting any work, check it thoroughly for quality. All work should be legible, spell checked AND proofread for accuracy, formatted correctly for data type, and it should make sense. Create a cover sheet (Ask instructor for Assignment Submission Procedures handout) for each exercise and attach lessons; submit for instructor review.
- Clearly identify each "Critical Thinking" exercise you are submitting. Be sure to include the Exercise Number on your cover sheet.
- If you customize the computer in any way (Quick Access toolbar, resolution, etc.), please return it to its original state.
- If you already know Office 2003 you should check out the Interactive Guides for all of the Office 2007 programs. They are very helpful for learning the new Office 2007 interface.
Working at Home
If you would like to work at home there is a CD in the back of your book that contains all of the necessary files. You can copy the data files folder to the hard drive of your computer and complete the lessons.
The CD that is included with the book includes a lot of great resources including Computer and Windows literacy lessons, keyboarding courses, and business glossaries. Be sure to explore the contents of the CD as you progress through the book.
What to Submit
Submit the Critical Thinking assignments for each lesson. Skip all On Your Own exercises.
Lesson 1: Getting Started with Microsoft Office
Nothing to submit for this lesson.
Lesson 1: Getting Started with Word 2007
Word Lesson Notes
Ask your instructor to review the Word 2007 tutorial before you begin the lessons.
If you are an experienced Word 2003 user, you may find the Interactive: Word 2003 to Word 2007 command reference guide helpful. There is an interactive guide for each of the applications. You can access the guides by press F1 in the application to open Help and typing 2003 in the search box.
Page 39 #16 - Save a New Document - Click the Save in drop-down arrow and locate drive O:\ - Select drive O:\. Double click the DDC 2007 Lessons folder to open it. Double click the Datafiles folder to open it. Finally, double click the Word folder to open the folder. Type the desired file name and click Save.
The On Your Own exercises focus on writing academic letters. I would recommend that you practice writing cover letters and other job related documents for the On Your Own exercises. Again, On Your Own exercises are optional.
Pages 81-83 - Submit Exercise 8 Critical Thinking
Page 84 - Skip Exercise 9 Curriculum Integration
Lesson 2: Basic Editing Skills
Page 91 #2 - Open an Existing Document - Click the Look in drop-down arrow and locate drive O:\ - Select drive O:\. Double click the DDC 2007 Lessons folder to open it. Double click the Datafiles folder to open it. Finally, double click the Word folder to open the folder. Select the file from the list and click Open.
Page 95 - Open Multiple Documents - You can select multiple documents in the Open Dialog box by clicking once on the first document that you want to open and then holding down the CTRL key and then clicking on the 2nd and subsequent documents. Once all of the documents are selected, click Open.
Lesson 3: Formatting Basics
Pg. 187 - Before you begin working with themes click the Home tab and click
the Change Styles button. Click Select Style > Word 2007. If you don't do this
your text will not change colors when you apply styles because the default style
is set to black and white.
Submit the Critical Thinking exercise at the end of the chapter.
Lesson 4: Word and the World Wide Web
Submit the Critical Thinking exercise at the end of the chapter.
Bonus Lessons
There are four additional lessons in the DDC 2007 Lessons folder (also on the CD) that you can complete. Using My Computer, navigate to DDC 2007 Lessons/Bonus Lessons. There are four PDF files (01_Word_05.pdf, 01_Word_06.pdf, 01_Word_07.pdf, & 01_Word_08.pdf that you can double click to open and print. Complete and Submit the Critical Thinking assignments for each lesson.
Lesson 5: Working with Tables
Submit the Critical Thinking exercise at the end of the chapter.
Lesson 6: Creating Documents with Merge
Critical Thinking exercie: Print and submit the Alaska Tour Participant list (43Alaska) and the Tours Mail Merge (43Confirm).
Lesson 7: Creating and Editing Long Documents
Submit the Critical Thinking exercise at the end of the chapter.
Lesson 8: Enhancing Documents and Automating Tasks
Submit the Critical Thinking exercise at the end of the chapter.
Excel Lesson Notes
Ask your instructor to review the Excel 2007 tutorial before you begin the lessons.
If you are an experienced Excel 2003 user, you may find the Interactive: Excel 2003 to Excel 2007 command reference guide helpful. There is an interactive guide for each of the applications. You can access the guides by press F1 in the application to open Help and typing 2003 in the search box.
Lesson 1: Getting Started with Excel
Save a New Document - Click the Save in drop-down arrow and locate drive O:\ - Select drive O:\. Double click the DDC 2007 Lessons folder to open it. Double click the Datafiles folder to open it. Finally, double click the Excel folder to open the folder. Type the desired file name and click Save.
Lesson 2: Working with Formulas and Formatting
Submit the Critical Thinking exercise at the end of the chapter.
Lesson 3: Working with Functions, Formulas, and Charts
Submit the Critical Thinking exercise at the end of the chapter.
Lesson 4: Advanced Printing, Formatting, and Editing
Critical Thinking Lesson: Print and submit the 30Inventory workbook only.
Bonus Lessons
There are three additional lessons in the DDC 2007 Lessons folder (also on the CD) that you can complete. Using My Computer, navigate to DDC 2007 Lessons/Bonus Lessons. There are three PDF files (02_Excel_05.pdf, 02_Excel_06.pdf & 02_Excel_07.pdf that you can double click to open and print. Complete and Submit the Critical Thinking assignments for each lesson.
Lesson 5: Advanced Chart Techniques
Critical Thinking Lesson: Print and submit the 35BreadSales workbook only.
Lesson 6: Advanced Functions, PivotCharts, and PivotTables
Submit the Critical Thinking exercise at the end of the chapter.
Lesson 7: Internet and Integration with Excel
Submit the Critical Thinking exercise at the end of the chapter.
Access Lesson Notes
Ask your instructor to review the Access 2007 tutorial before you begin the lessons.
If you are an experienced Excel 2003 user, you may find the Interactive: Access 2003 to Access 2007 command reference guide helpful. There is an interactive guide for each of the applications. You can access the guides by press F1 in the application to open Help and typing 2003 in the search box.
Lesson 1: Getting Started with Access 2007
Creating a New Blank Database - When you create a new database you will need to immediately save it.
Type the File Name and click the Browse button. Click the Save in drop-down arrow and locate drive O:\ - Select drive O:\. Double click the DDC 2007 Lessons folder to open it. Double click the Datafiles folder to open it. Finally, double click the Access folder to open the folder. Type the desired file name and click OK. Click the create button after typing the file name and selecting the location.
Notes on printing Tables and other Access Objects: Click the Office button and click Print. Select the HP LaserJet 2420 PCL6 from the Name drop down list and click the Properties button. Click the Finishing tab. Select Print on both sides and Landscape Orientation. Click OK twice. Use these steps for all Access lessons.
Page 380 - Print the tblMembers and tblWASurvey tables and submit.
Lesson 2: Working with Tables and Datasheets
Page 410 - Print the tblEmployees and tblTimecards tables and submit.
Lesson 3: Simplifying Data Entry with Lookups and Forms
Page 438 - Print frmTimeCards, form frmEmployees, and table tblPositions.
Bonus Lessons
There are two additional lessons in the DDC 2007 Lessons folder (also on the CD) that you can complete. Using My Computer, navigate to DDC 2007 Lessons/Bonus Lessons. There are two PDF files (03_Access_04.pdf & 03_Access_05.pdf that you can double click to open and print. Complete and Submit the Critical Thinking assignments for each lesson.
Lesson 4: Find Information in a Database
This is a Bonus lesson that can be found on the CD in the back of your book.
Critical Thinking Lesson: Print and submit all queries.
Lesson 5: Display Information with Reports
Critical Thinking Lesson: Print and submit all reports.
PowerPoint Lesson Notes
Ask your instructor to review the PowerPoint 2007 tutorial before you begin the lessons.
If you are an experienced PowerPoint 2003 user, you may find the Interactive: PowerPoint 2003 to PowerPoint 2007 command reference guide helpful. There is an interactive guide for each of the applications. You can access the guides by press F1 in the application to open Help and typing 2003 in the search box.
Notes on printing PowerPoint Presentations: Click the Office button and click Print. Select the HP LaserJet 2420 PCL6 from the Name drop down list and click the Properties button. Click the Finishing tab. Select Print on both sides and click OK. Under Print What, select Handouts and make sure that the Slides per page option is set to 6. Click OK. Use these steps for all PowerPoint lessons.
Save all files in O:\DDC 2007 Lessons\Datafiles\PowerPoint
Lesson 1: PowerPoint Basics
No notes at this time
Lesson 2: Work with Text and Graphic Elements
No notes at this time
Lesson 3: Prepare and Present a Slide Show
No notes at this time
Outlook Lesson Notes
Outlook 2007 is not running in the classroom. If you would like to learn about Outlook 2007 ask your instructor for the Outlook 2007 tutorial. You can complete the 04_Outlook.pdf file located in the DDC 2007 Lessons\Bonus Lessons folder at home if you have Outlook installed.
Challenge Lesson
Complete the 05_Challenge.pdf located in the DDC 2007 Lessons\Bonus Lessons folder.
Certificates are awarded to students who:
- Demonstrate an effort to learn and problem solve.
- Accurately complete all Critical Thinking Assignments (one retry is permitted per project; if errors are included in a second submission, you will receive a “no credit” for that project. Three or more “no credits” on any application study prevents receipt of a certificate for that application.
- Complete successfully a Project test which simulates work you would be asked to do in an office. Ask an instructor for these tests after completing the test.