GO!
with Microsoft ®
Office 2016
Discipline Specific
Projects
Shelley Gaskin and Alan Shapiro
330 Hudson Street, NY, NY 10013
Vice President, Career Skills: Andrew Gilfillan
Executive Editor: Jenifer Niles
Team Lead, Project Management: Laura Burgess
Development Editor: Nancy Lamm
Editorial Assistant: Michael Campbell
Director of Product Marketing: Maggie Waples
Director of Field Marketing: Leigh Ann Sims
Field Marketing Managers: Molly Schmidt and Joanna Conley
Marketing Coordinator: Susan Osterlitz
Operations Specialist: Diane Peirano
Senior Art Director: Diane Ernsberger
Cover Photos: GaudiLab, Rawpixel.com, Pressmaster, Eugenio
Marongiu, Boggy, Gajus, Rocketclips, Inc.
Associate Director of Design: Blair Brown
Director of Media Development: Blaine Christine
Media Project Manager, Production: John Cassar
Full-Service Project Management: Amy Kopperude
Composition: iEnergizer Aptara®, Ltd.
Printer/Binder: RR Donnelley Menasha
Cover Printer: Phoenix Color
Text Font: Times LT Pro
Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on the appropriate page within
text. Microsoft and/or its respective suppliers make no representations about the suitability of the information contained in the documents and related
graphics published as part of the services for any purpose. All such documents and related graphics are provided “as is” without warranty of any kind.
Microsoft and/or its respective suppliers make no representations about the suitability of the information contained in the documents and related
graphics published as part of the services for any purpose. All such documents and related graphics are provided “as is” without warranty of any kind.
Microsoft and/or its respective suppliers hereby disclaim all warranties and conditions with regard to this information, including all warranties and
conditions of merchantability, whether express, implied or statutory, fitness for a particular purpose, title and non-infringement. In no event shall
Microsoft and/or its respective suppliers be liable for any special, indirect or consequential damages or any damages whatsoever resulting from loss
of use, data or profits, whether in an action of contract, negligence or other tortious action, arising out of or in connection with the use or performance
of information available from the services. The documents and related graphics contained herein could include technical inaccuracies or typographical
errors. Changes are periodically added to the information herein. Microsoft and/or its respective suppliers may make improvements and/or changes in
the product(s) and/or the program(s) described herein at any time. Partial screen shots may be viewed in full within the software version specified.
The documents and related graphics contained herein could include technical inaccuracies or typographical errors. Changes are periodically added
to the information herein. Microsoft and/or its respective suppliers may make improvements and/or changes in the product(s) and/or the program(s)
described herein at any time. Partial screen shots may be viewed in full within the software version specified.
Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. This book is not sponsored or
endorsed by or affiliated with the Microsoft Corporation.
Copyright © 2017 by Pearson Education, Inc. as Prentice Hall. All rights reserved. Manufactured in the United States of America. This publication
is protected by Copyright, and permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or
transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, request
forms and the appropriate contacts within the Pearson Education Global Rights & Permissions department, please visit www.pearsoned.com/permissions/.
Many of the designations by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this
book, and the publisher was aware of a trademark claim, the designations have been printed in initial caps or all caps.
Cataloging-in-Publication Data is on file with the Library of Congress.
10 9 8 7 6 5 4 3 2 1
ISBN 10:
0-13-444491-4
ISBN 13: 978-0-13-444491-8
Brief Contents
Chapter 1
Culinary Arts.......................................................... 1
Chapter 2
Healthcare............................................................ 35
Chapter 3
Administration of Justice...................................... 71
Chapter 4
Legal...................................................................105
Appendix A
Proper Business Letter Format.........................A-1
Appendix B
Basic MLA Paper Formatting with
Microsoft Word 2016........................................ B-1
Appendix C
Tracking Changes in Word Documents.............. C-1
Index..................................................................................... I-1
Brief Contents
iii
This page intentionally left blank
Table of Contents
Chapter 1 Culinary Arts...............................................1
Word 2016
GO! Make It
PROJECT 1A
2
Culinary Bistro Mailing: Part 1 Culinary Bistro Letter............................................2
Part 2 Culinary Bistro Flyer.......................................................................................4
Part 3 Culinary Bistro Mailing Labels.......................................................................6
Part 4 Culinary Bistro Form Letters..........................................................................8
GO! Think
10
PROJECT 1B
Culinary Gala Mailing: Part 1 Culinary Gala Letter.............................................. 10
Part 2 Culinary Gala Flyer.......................................................................................11
Part 3 Culinary Gala Mailing Labels.......................................................................12
Part 4 Culinary Gala Form Letters..........................................................................13
Excel 2016
GO! Make It
PROJECT 1C
14
Food Costing............................................................................................................14
GO! Think
PROJECT 1D
18
Hudson Grill..............................................................................................................18
Access 2016
GO! Make It
PROJECT 1E
20
Recipe Database ��������������������������������������������������������������������������������������������������� 20
GO! Think
PROJECT 1F
28
Kitchen Inventory Database.................................................................................. 28
PowerPoint 2016
GO! Make It
PROJECT 1G
30
Community Garden Presentation.......................................................................... 30
GO! Think
PROJECT 1H
33
Healthy Recipe Presentation................................................................................. 33
Chapter 2 Healthcare................................................. 35
Word 2016
GO! Make It
PROJECT 2A
36
Healthcare Dental Mailing: Part 1 Healthcare Dental Letter.............................. 36
Table of Contents
v
Part 2 Healthcare Dental Newsletter.................................................................... 38
Part 3 Healthcare Dental Mailing Labels.............................................................. 40
Part 4 Healthcare Dental Form Letters................................................................. 42
GO! Think
PROJECT 2B
44
Healthcare Medical Mailing: Part 1 Healthcare Medical Letter ������������������������ 44
Part 2 Healthcare MLA Paper................................................................................. 45
Part 3 Healthcare Medical Mailing Labels............................................................ 47
Part 4 Healthcare Medical Form Letters............................................................... 48
Excel 2016
GO! Make It
PROJECT 2C
49
Medical Invoice....................................................................................................... 49
GO! Think
PROJECT 2D
53
Medical Supplies Order.......................................................................................... 53
Access 2016
GO! Make It
PROJECT 2E
55
Inventory Database................................................................................................ 55
GO! Think
PROJECT 2F
65
Billing Database...................................................................................................... 65
PowerPoint 2016
GO! Make It
PROJECT 2G
GO! Think
PROJECT 2H
67
Lowering Blood Pressure Presentation................................................................ 67
70
Patient Presentation............................................................................................... 70
Chapter 3 Administration of Justice........................... 71
Word 2016
GO! Make It
PROJECT 3A
72
Neighborhood Watch Mailing: Part 1 Neighborhood Watch Letter................... 72
Part 2 Neighborhood Watch Newsletter............................................................... 74
Part 3 Neighborhood Watch Mailing Labels......................................................... 76
Part 4 Neighborhood Watch Form Letters............................................................ 78
GO! Think
PROJECT 3B
80
Seniors Mailing: Part 1 Seniors Letter.................................................................. 80
Part 2 Seniors Newsletter...................................................................................... 81
Part 3 Seniors Mailing Labels................................................................................ 82
Part 4 Seniors Form Letters................................................................................... 83
vi
Table of Contents
Excel 2016
GO! Make It
PROJECT 3C
84
Police Calls............................................................................................................... 84
GO! Think
PROJECT 3D
88
Parking..................................................................................................................... 88
Access 2016
GO! Make It
PROJECT 3E
90
Training Database................................................................................................... 90
GO! Think
PROJECT 3F
99
Community Policing Database.............................................................................. 99
PowerPoint 2016
GO! Make It
100
PROJECT 3G
Syber Crime Presentation.................................................................................... 100
GO! Think
103
PROJECT 3H
Community Presentation..................................................................................... 103
Chapter 4 Legal........................................................105
Word 2016
GO! Make It
Project 4A
106
Client Mailing: Part 1 Client Letter..................................................................... 106
Part 2 Motion Testimony...................................................................................... 108
Part 3 Client Labels............................................................................................... 111
Part 4 Client Form Letters.................................................................................... 113
GO! Think
115
PROJECT 4B
Legal Stock Mailing: Part 1 Stock Letter............................................................ 115
Part 2 Copyright Law Paper................................................................................. 116
Part 3 Stock Labels............................................................................................... 118
Part 4 Stock Form Letters.................................................................................... 119
Excel 2016
GO! Make It
120
PROJECT 4C
Stockholder Ledger.............................................................................................. 120
GO! Think
125
PROJECT 4D
Billable Hours........................................................................................................ 125
Table of Contents
vii
Access 2016
GO! Make It
Project 4E
127
Caseload Database............................................................................................... 127
GO! Think
138
PROJECT 4F
Stockholders Database........................................................................................ 138
PowerPoint 2013
GO! Make It
140
PROJECT 4G
Jury Selection........................................................................................................ 140
GO! Think
144
PROJECT 4H
Community Presentation..................................................................................... 144
Appendix A Proper Business Letter Format.............. A-1
Appendix B Basic MLA Paper Formatting with
Microsoft Word 2016............................. B-1
Appendix C
Tracking Changes in Word Documents.... C-1
Index....................................................................... I-1
viii
Table of Contents
About the Authors
Shelley Gaskin, Series Editor, is a professor in the Business and Computer Technology Division
at Pasadena City College in Pasadena, California. She holds a bachelor’s degree in Business
Administration from Robert Morris College (Pennsylvania), a master’s degree in Business from
Northern Illinois University, and a doctorate in Adult and Community Education from Ball State
University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer
industry, where she was a systems analyst, sales representative, and director of Customer Education
with Unisys Corporation. She also worked for Ernst & Young on the development of large systems
applications for their clients. She has written and developed training materials for custom systems
applications in both the public and private sector, and has also written and edited numerous computer application textbooks.
This book is dedicated to my students, who inspire me every day.
Alan Shapiro worked as an Instructional Designer at St. Petersburg College for 18 years. In this role,
he worked with faculty on best practices for using technology in the classroom to increase student
success. He was also an Adjunct Instructor for Computer Applications courses. Alan currently works
as an IT Implementation Specialist.
This book is dedicated to the success of all students, both those in class with me
and those using this book!
About the Authors
ix
Instructor Materials
All
Instructor and
Student materials
available at
pearsonhighered
.com/go
Student Assignment Tracker (previously called Assignment Sheets) – Lists all the assignments
for the chapter. Just add the course information, due dates, and points. Providing these to students
ensures they will know what is due and when.
Scripted Lectures – A script to guide your classroom lecture of each instructional project.
PowerPoint Lectures – PowerPoint presentations for each chapter.
Prepared Exams – Exams for each chapter.
Test Bank – Includes a variety of test questions for each chapter.
Student Data Files – www.pearsonhighered.com/go.
Syllabus Template – Outlines various plans for covering the content in different length courses.
x
Instructor Materials
You will complete the following discipline specific projects:
Word
1
CULINARY
ARTS
Discipline Specific
Projects
GO! Make It | Project 1A Culinary Bistro Mailing (p. 2)
Part 1 Create a proper business letter to match visual summary. Use graphics, text box, no spacing
style, and character and paragraph formatting.
Part 2 Create a flyer to match visual summary.
Use graphics, SmartArt, lists, character and paragraph formatting, table, tab stops, footnotes,
and save as PDF.
Part 3 Create mailing labels to match visual summary.
Edit table. Use character and paragraph formatting and mail merge.
Part 4 Create form letters to match visual summary.
Edit table. Use mail merge.
GO! Think | Project 1B Culinary Gala Mailing (p. 10)
Part 1 Create a business letter to invite businesses to a fund-raising event.
Use graphics, text box, no spacing style, and character and paragraph formatting.
Part 2 Create a flyer.
Use graphics, SmartArt, lists, character and paragraph formatting, table, tab stops, footnotes,
and save as PDF.
Part 3 Create mailing labels.
Edit table. Use character and paragraph formatting and mail merge.
Part 4 Create form letters.
Use mail merge.
Excel
GO! Make It | Project 1C Food Costing (p. 14)
Create a workbook to match visual summary.
Enter data, formulas, and functions; chart data; group worksheets; format; and make summary sheet.
GO! Think | Project 1D Hudson Grill (p. 18)
Create a workbook to analyze monthly restaurant sales.
Enter data, formulas, and functions; chart data; group worksheets; format; and make summary sheet.
Access
GO! Make It | Project 1E Recipe Database (p. 20)
Work with a database to match visual summary. Add table, edit table structure, and join tables; create
forms and reports; and create queries with compound criteria, calculated fields, and grouping.
GO! Think | Project 1F Kitchen Inventory Database (p. 28)
Work with a database to track suppliers and inventory data. Add table, edit table structure, and join tables;
create forms and reports; and create queries with compound criteria, calculated fields, and grouping.
PowerPoint
GO! Make It | Project 1G Community Garden Presentation (p. 30)
Create a presentation to match visual summary. Format slides and work with pictures, tables, charts,
WordArt, SmartArt, animation, transitions, backgrounds, and themes.
GO! Think | Project 1H Healthy Recipe Presentation (p. 33)
Create a presentation about preparing a healthy recipe. Format slides and work with pictures, tables,
charts, WordArt, SmartArt, animation, transitions, backgrounds, and themes.
1
CONTENT-BASED ASSESSMENTS
GO! Make It
Apply skills from
these objectives:
1 Create a New
Document from an
Existing Document
roject 1A Culinary Bistro Mailing:
P
Part 1 Culinary Bistro Letter
PROJECT FILES
2 Change Document and
For Project 1A Culinary Bistro Mailing Part 1, you will need the following files:
3 Insert and Format
w1A_Bistro_Letter
w1A_Bistro_Logo
4 Use Special Character
You will save your document as:
Paragraph Layout
Graphics
and Paragraph
Formatting
Lastname_Firstname_1A_Bistro_Letter
5 Change and Reorganize
PROJECT RESULTS
Text
6 Use Proofing Options
7 Insert and Modify Text
Boxes and Shapes
8 Preview and Print a
Word 2016, Windows 10, Microsoft Corporation.
Document
FIGURE 1.1 Project 1A, Part 1 Bistro Letter
(Project 1A Part 1 Culinary Bistro Letter continues on the next page)
2
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1
Project 1A Part 1 Culinary Bistro Letter (continued)
1 Create a folder in which to save your files for this
project called Culinary Bistro Mailing. From the
student files that accompany this text, locate and copy
the file w1A_Bistro_Logo to this folder.
2 From the student files that accompany this text,
locate and open the file w1A_Bistro_Letter, and then
save the file in the Culinary Bistro Mailing folder as
Lastname_Firstname_1A_Bistro_Letter. You will
use this file to create a properly formatted business
letter to match the one shown in Figure 1.1.
3 Insert a footer with the file name as a Quick Parts
field in the footer.
4 Change the top margin to .5". Verify that the side
and bottom margins are set to 1".
5 For the entire document, change the line spacing
to single, and change the paragraph spacing after to
zero. Verify that all indents are set to zero.
6 In the letterhead, from your Bistro Mailing files,
insert the picture w1A_Bistro_Logo. Resize, wrap text
around the logo image, and position it in the letterhead.
7 At the top of the page, enter and align the Bistro in a
Box text, and format the font to match the letterhead shown
in Figure 1.1. Add space before the paragraph if needed.
8 Use a text box for the contact information. Add a
top border to the blank line below the letterhead, as
shown in Figure 1.1.
9 From the ribbon, insert the current date below the
letterhead and above the recipient’s address block and
choose a date format to match the one shown in Figure 1.1.
10 Make corrections to the text, including size,
capitalization, punctuation, and content to match the
proper business letter format shown in Figure 1.1.
11 Format the letter by adding and removing blank lines
to match the proper vertical spacing shown in Figure 1.1.
12 Correct any spelling and grammar errors. Preview
the document and compare it with Figure 1.1, making
adjustments as needed.
13 Save and close the document and submit it as
directed by your instructor.
Project 1A: Part 1 Culinary Bistro Letter
|
Culinary Arts
3
CULINARY ARTS
GO! Make It
CONTENT-BASED ASSESSMENTS
GO! Make It
Apply skills from
these objectives:
1 Create a New
Project 1A Part 2 Culinary Bistro Flyer
PROJECT FILES
Document from an
Existing Document
For Project 1A Culinary Bistro Mailing Part 2, you will need the following files:
2 Change Document and
w1A_Bistro_Flyer
w1A_Bistro_Logo
Paragraph Layout
3 Insert a SmartArt
You will save your documents as:
Graphic
4 Insert Footnote
5 Insert and Format
Lastname_Firstname_1A_Bistro_Flyer
Lastname_Firstname_1A_Bistro_Flyer_PDF
6 Use Special Character
PROJECT RESULTS
Graphics
and Paragraph
Formatting
7 Change and Reorganize
Text
8 Create and Format a
Table
9 Create and Modify Lists
10 Set and Modify Tab
Stops
11 Use Proofing Options
12 Preview and Print a
Document
13 Save a Document as a
Word 2016, Windows 10, Microsoft Corporation.
PDF
FIGURE 1.2 Project 1A, Part 2 Bistro Flyer
(Project 1A Part 2 Culinary Bistro Flyer continues on the next page)
4
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1 From the student files that accompany this text,
locate and open the file w1A_Bistro_Flyer, and then
save the file in the Culinary Bistro Mailing folder as
Lastname_Firstname_1A_Bistro_Flyer. You will use
this file to create a one-page flyer that looks like the
Bistro Flyer shown in Figure 1.2.
2 Insert a footer with the file name as a Quick Parts
field at the right of the footer.
3 Insert and format a table to match the table shown
in Figure 1.2.
4 Apply Webding 228 bullets.
5 Insert the w1A_Bistro_Logo picture file. Set text
wrapping, size, and position.
6 Insert a paragraph border to match Figure 1.2.
7 Insert a SmartArt graphic to match Figure 1.2.
1
(continued)
8 Set tab stops, and enter the phone, fax, and
website text.
9 At the end of the second paragraph, insert a footnote
asterisk. Enter the footnote text as shown in Figure 1.2.
10 Set line spacing, align text, and format fonts to
match Figure 1.2.
11 Check the flyer for spelling and grammar errors,
and correct any errors you find. Preview the document
and compare with Figure 1.2, making adjustments as
needed. Ensure the flyer fits on one page.
12 Save the document.
13 Save the document again as a PDF file with the
name Lastname_Firstname_1A_Bistro_Flyer_PDF
in your Culinary Bistro Mailing folder. Close the file.
14 Submit file(s) as directed by your instructor.
Project 1A: Part 2 Culinary Bistro Flyer
|
Culinary Arts
5
CULINARY ARTS
GO! Make It Project 1A Part 2 Culinary Bistro Flyer
CONTENT-BASED ASSESSMENTS
GO! Make It
Apply skills from
these objectives:
1 Create Mailing Labels
Project 1A Part 3 Culinary Bistro Mailing Labels
PROJECT FILES
Using Mail Merge
For Project 1A Culinary Bistro Mailing Part 3, you will need the following files:
2 Format a Table
3 Change Document and
New blank Word document
w1A_Bistro_Addresses
Paragraph Layout
4 Preview and Print a
You will save your document as:
Document
Lastname_Firstname_1A_Bistro_Labels
Word 2016, Windows 10, Microsoft Corporation.
PROJECT RESULTS
FIGURE 1.3 Project 1A, Part 3 Bistro Mailing Labels
(Project 1A Part 3 Culinary Bistro Mailing Labels continues on the next page)
6
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1
Project 1A Part 3 Culinary Bistro Mailing Labels (continued)
1 From the student files that accompany this
text, locate and open the file w1A_Bistro_Addresses,
and add yourself to the top of the mailing list. Save the
file in the Culinary Bistro Mailing folder as
Lastname_Firstname_1A_Bistro_Addresses, and
close the file.
2 Starting with a new blank Word document, use
mail merge to create a labels document that looks like
the Bistro mailing labels shown in Figure 1.3. Save this
file as Lastname_Firstname_1A_Bistro_Label_Main
in your Culinary Bistro Mailing folder so you do not
confuse it with your final results file.
3 Your labels are Avery US Letter, 5160 Easy Peel
Address labels, which are 1" tall by 2.63" wide.
4 Use Lastname_Firstname_1A_Bistro_Addresses
as the recipient data source.
5 Ensure that all lines fit in the label area. Preview
the document and compare with Figure 1.3, making
adjustments as needed. Save the main document.
6 At the end of the merge, Edit individual labels to
create a new file with only the label text. Save your new
address labels document in your Culinary Bistro Mailing
folder as Lastname_Firstname_1A_Bistro_Labels.
7 To the footer add the file name as a Quick Parts
field. Preview the document and if necessary, delete
blank lines or row(s) at the bottom of the table so that
the entire document fits on one page (even the blank
labels). Modify the bottom margin if necessary to
ensure the footer will display on the page if printed.
Save this as the end results file.
8 Submit file(s) as directed by your instructor.
Project 1A: Part 3 Culinary Bistro Mailing Labels
|
Culinary Arts
7
CULINARY ARTS
GO! Make It
CONTENT-BASED ASSESSMENTS
GO! Make It Project 1A Part 4 Culinary Bistro Form Letters
Apply skills from
these objectives:
1 Create a New
PROJECT FILES
Document from an
Existing Document
For Project 1A Culinary Bistro Mailing Part 4, you will need the following files:
2 Format a Table
3 Merge a Data Source
Lastname_Firstname_1A_Bistro_Addresses (from Part 3 of this project)
Lastname_Firstname_1A_Bistro_Letter (from Part 1 of this project)
and a Main Document
You will save your documents as:
4 Preview and Print a
Document
Lastname_Firstname_1A_Bistro_Form_Letters
Lastname_Firstname_1A_Bistro_Addresses
Word 2016, Windows 10, Microsoft Corporation.
PROJECT RESULTS
FIGURE 1.4 Project 1A, Part 4 Bistro Form Letters
(Project 1A Part 4 Culinary Bistro Form Letters continues on the next page)
8
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1 From your Culinary Bistro Mailing folder, locate
and open Lastname_Firstname_1A_Bistro_Addresses.
Add a column to the table for the recipients’ titles, such
as Mr. or Ms., and enter appropriate titles. Save and
close the file.
2 From your Culinary Bistro Mailing folder, locate and
open your file Lastname_Firstname_1A_Bistro_Letter.
Save the file as Lastname_Firstname_1A_Bistro_Main_
Letter so that you will not confuse it with your end results
file. Use mail merge to create a new document containing
11 form letters that look like the letter shown in Figure 1.4.
3 In the footer of the main letter file, delete the field
name code. In the footer, enter your last name and first
name and 1A Bistro Form Letters. This new footer
will show on each of the form letters. Save the file.
1
(continued)
4 The data source is Lastname_Firstname_1A_Bistro_
Addresses. Sort by zip code from low to high. Insert a
proper business letter address block and greeting line.
Preview the document and compare with Figure 1.4.
5 Verify that the letters are properly formatted in the
merge preview, and go back to fix as needed. Save
Lastname_Firstname_1A_Bistro_Main_Letter.
6 At the end of the merge, choose to Edit individual
letters to create a new file with the 11 letters, one on
each page.
7 Save the end results file with the 11 letters in your
Culinary Bistro Mailing folder as
Lastname_Firstname_1A_Bistro_Form_Letters.
8 Submit file(s) as directed by your instructor.
END | You have completed Project 1A
Project 1A: Part 4 Culinary Bistro Form Letters
|
Culinary Arts
9
CULINARY ARTS
GO! Make It Project 1A Part 4 Culinary Bistro Form Letters
OUTCOMES-BASED ASSESSMENTS
GO! Think Project 1B Culinary Gala Mailing:
Apply skills from
these objectives:
1 Create a New
Part 1 Culinary Gala Letter
Document from an
Existing Document
2 Change Document and
Paragraph Layout
3 Insert and Format
Graphics
4 Use Special Character
and Paragraph
Formatting
5 Change and Reorganize
Text
6 Use Proofing Options
7 Preview and Print a
Document
10
Culinary Arts
PROJECT FILES
For Project 1B Culinary Gala Mailing Part 1, you will need the following files:
w1B_PPCC_Logo
w1B_Gala_Letter
You will save your document as:
Lastname_Firstname_1B_Gala_Letter
You are the president of the local chapter of the American Culinary Federation.
You have been asked to send a letter to invite local businesses to attend a Chefs’ Gala
Celebration and fundraising event at a local hotel. The chefs participating are local chefs,
and they will cook their favorite menu items to raise money for local charities.
1 Create a folder in which to save your files for this project called
Culinary Gala Mailing.
2 From the student files that accompany this text, locate and open the file
w1B_Gala_Letter, and then save the file in your Culinary Gala Mailing folder as
Lastname_Firstname_1B_Gala_Letter.
3 Add the file name to the footer as a Quick Parts field.
4 Create a letterhead using the first three lines in the letter. Insert the
w1B_PPCC_Logo graphic. Insert a paragraph border to separate the letterhead from
the text in the letter.
5 Edit to compose a one-page proper business letter inviting local businesses to attend
the gala.
6 Insert your own local charities as a list. Add the names of community organizations
and charities in your area that the gala will support. These may include any nonprofit
organizations, including local food banks, rescue missions, and the American Culinary
Education Fund.
7 Change the line spacing, paragraph spacing, blank lines, and text in the letter as
appropriate for a properly formatted one-page business letter. Reference the example of a
properly formatted business letter in the previous project or see proper business letter
requirements in Appendix A.
8 Preview the document and go back to adjust as needed. Adjust margins and font size
appropriately to make the letter fit neatly on one page.
9 Check the letter for spelling and grammar errors, and correct any errors found.
10 Save the document, and submit the letter file as directed by your instructor.
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
OUTCOMES-BASED ASSESSMENTS
Document from an
Existing Document
2 Change Document and
Paragraph Layout
3 Insert a SmartArt
Graphic
GO! Think
1
Project 1B Part 2 Culinary Gala Flyer
CULINARY ARTS
Apply skills from
these objectives:
1 Create a New
PROJECT FILES
For Project 1B Culinary Gala Mailing Part 2, you will need the following files:
New blank Word document
w1B_PPCC_Logo
You will save your documents as:
4 Insert Footnote
5 Insert and Format
Lastname_Firstname_1B_Gala_Flyer
Lastname_Firstname_1B_Gala_Flyer_PDF
6 Use Special Character
You are the president of the local chapter of the American Culinary Federation.
You are planning a Chefs’ Gala celebration and fund-raising event at a local hotel. The
chefs participating are local chefs, and they will cook their favorite menu items to raise
money for local charities. In this project, you will create a one-page flyer that explains
details about the Chefs’ Gala and fund-raising event. The flyer will be used to encourage
businesses to attend your event.
1 Open a new blank Word document, and then save the file in your
Culinary Gala Mailing folder as Lastname_Firstname_1B_Gala_Flyer.
2 Add the file name to the footer as a Quick Parts field.
3 Add an appropriate title.
4 After the title, apply a two-column format, and use both columns to display the flyer
information.
5 Use small caps, various font sizes, and colors throughout the document.
6 Refer to the letter in Part 1 of this project for cost, date, time, and reservation
information as you compose the flyer.
7 Include the same local charities that will benefit from this event as were listed in the
letter in Part 1 of this project. Format the list of charities in a table, and format the table
using a design to match other parts of the flyer.
8 Do some research to come up with items for a tempting menu! Use real or made-up
restaurants.
9 Apply paragraph borders and paragraph shading.
10 Create a text box with the ticket information, and then change the border and
shading to match the other colors in the document.
11 Include a SmartArt Picture List to display chef photos and their restaurant names. Search
Microsoft Office Clip Art or Office.com to find chef photos to insert in your SmartArt.
12 Use additional Microsoft clip art or other graphics, including the logo file
w1B_PPCC_Logo.
13 Check for spelling and grammar errors, and correct any errors you find.
14 For best visual results, apply document design principles: Use formatting consistently
rather than randomly. Apply contrast by making titles large and bold compared to body text.
Apply design proximity by minimizing space after each title paragraph. Align all neatly.
15 Preview the document, and go back to adjust as needed. Save the document.
16 Save the document again as a PDF file with the name
Lastname_Firstname_1B_Gala_Flyer_PDF.
17 Submit file(s) as directed by your instructor.
Graphics
and Paragraph
Formatting
7 Change and Reorganize
Text
8 Create and Format a
Table
9 Create and Modify Lists
10 Set and Modify Tab
Stops
11 Use Proofing Options
12 Preview and Print a
Document
13 Save a Document as a
PDF
Project 1B: Part 2 Culinary Gala Flyer
|
Culinary Arts
11
OUTCOMES-BASED ASSESSMENTS
GO! Think
Apply skills from
these objectives:
1 Create Mailing Labels
PROJECT FILES
Using Mail Merge
2 Format a Table
3 Change Document and
Paragraph Layout
4 Preview and Print a
Document
Project 1B Part 3 Culinary Gala Mailing Labels
For Project 1B Culinary Gala Mailing Part 3, you will need the following files:
New blank Word document
w1B_Gala_Addresses
You will save your document as:
Lastname_Firstname_1B_Gala_Labels
1 From the student files that accompany this text, locate and copy the file
w1B_Gala_Addresses to your Culinary Gala Mailing folder.
2 Starting with a new blank Word document, you will use mail merge to create
mailing labels. So that you will not confuse it with your end results file, save the file as
Lastname_Firstname_1B_Gala_Labels_Main in your Culinary Gala Mailing folder.
3 Your labels are Avery US Letter, 5160 Easy Peel Address labels, which are 1" tall by
2.63" wide.
4 Your data source is your Culinary Gala Mailing file w1B_Gala_Addresses.
5 Arrange your labels and change spacing to ensure that all lines fit in the label area.
Save the main document file.
6 After the merge is completed, Edit individual labels to create a new file with all
11 labels. Save the file as Lastname_Firstname_1B_Gala_Labels.
7 To the footer add the file name as a Quick Parts field. If necessary, delete blank lines
or row(s) at the bottom of the table so that the entire document fits on one page (even the
blank labels). Modify the bottom margin, if necessary, to ensure the footer will display on
the page if printed. Save this end results file.
8 Submit file(s) as directed by your instructor.
12
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
OUTCOMES-BASED ASSESSMENTS
Document from an
Existing Document
2 Merge a Data Source
and a Main Document
3 Preview and Print a
Document
GO! Think
Project 1B Part 4 Culinary Gala Form Letters
PROJECT FILES
For Project 1B Culinary Gala Mailing Part 4, you will need the following files:
Lastname_Firstname_1B_Gala_Letter (from Part 1 of this project)
w1B_Gala_Addresses
You will save your document as:
Lastname_Firstname_1B_Gala_Form_Letters
1 From your Culinary Gala Mailing folder, locate and open your file
Lastname_Firstname_1B_Gala_Letter. Save the file as Lastname_Firstname_1B_
Gala_Main_Letter so that you will not confuse it with your end results file. Use mail
merge to create properly formatted business letters.
2 In the footer of the main letter file, replace the field name code, typing in your last
name and first name and 1B Gala Form Letters. This new footer will show on each of
the form letters.
3 The data source is your Culinary Gala Mailing file w1B_Gala_Addresses. Preview
the document, and go back to adjust as needed. Save the main document file.
4 After the merge is completed, Edit individual letters to create a new file with all 11
form letters with proper business letter format.
5 Save this end results file as Lastname_Firstname_1B_Gala_Form_Letters.
6 Submit file(s) as directed by your instructor.
END | You have completed Project 1B
Project 1B: Part 4 Culinary Gala Form Letters
|
Culinary Arts
13
1
CULINARY ARTS
Apply skills from
these objectives:
1 Create a New
CONTENT-BASED ASSESSMENTS
GO! Make It
Apply skills from
these objectives:
1 Enter Data in a
Project 1C Food Costing
PROJECT FILES
Worksheet
2 Format Cells with
For Project 1C, you will need the following files:
3 Chart Data to Create a
e1C_Food_Costing
e1C_Bistro_Logo
4 Check Spelling in a
You will save your workbook as:
Merge & Center
Column Chart
Worksheet
5 Construct Formulas
for Mathematical
Operations
Lastname_Firstname_1C_Food_Costing
PROJECT RESULTS
6 Edit Values in a
Worksheet
7 Format a Worksheet
8 Use the SUM,
AVERAGE, MIN, and
MAX Functions
9 Navigate a Workbook
and Rename
Worksheets
10 Edit and Format
Multiple Worksheets at
the Same Time
11 Create a Summary
Excel 2016, Windows 10, Microsoft Corporation.
Sheet
FIGURE 1.5 Project 1C Food Costing
(Project 1C Food Costing continues on the next page)
14
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1
Project 1C Food Costing (continued)
1 Create a folder in which to store your files for this project called Food Costing. From
the student files that accompany this text, copy the file, e1C_Bistro_Logo, to this folder.
2 From the student files that accompany this text, locate and open the file
e1C_Food_Costing, and then save the file in your Food Costing folder as
Lastname_Firstname_1C_Food_Costing. You will modify the workbook to match
the worksheets shown in Figures 1.5, 1.6, and 1.7.
3 Group Sheet1, Sheet2, and Sheet3, and modify the group of sheets as follows:
• Change the top margin to 2", and set the worksheet to center horizontally on the
printed page to match Figure 1.5.
• In the footer, insert the code for the file name.
• In the header, insert the file e1C_Bistro_Logo.
• For the column heading and other labels, enter text; adjust column widths and row
heights; and format the font, size, alignment, and wrapping to match the figure.
• Merge and center the Bistro in a Box title and Gourmet Sandwiches subtitle.
Format the font, size, and color to match Figure 1.5. Delete blank rows as needed.
• Enter a formula to calculate the cost of the first sandwich as a percentage of
selling price. Copy the formula to compute the same thing for all the sandwiches.
• Use the AVERAGE, MIN, and MAX functions to calculate to match Figure 1.5.
• Format the cells to match the figure.
• Apply borders to match the figure.
• Ungroup the worksheets when done.
4
5
Rename the worksheet tabs of the first four ungrouped sheets and apply tab colors.
Sheet1
Sheet2
Sheet3
Sheet4
New tab name
Sandwiches
Wraps
Salads
Summary
Tab color
Blue
Red
Green
Yellow
Modify and format the Summary worksheet as follows:
• Insert the codes for the file name and sheet name in the footer, and set the
worksheet to center horizontally on the printed page to match Figure 1.6.
• Copy the Bistro in a Box title from one of the previous worksheets, and add it to
the top of this worksheet. Merge and center the Menu Item Food Cost title, and
format to match Figure 1.6.
• In the row with the column heading labels, use the keyboard command
after the words Average, Minimum, and Maximum to insert a line break.
+
• Adjust text format, borders and shading, row heights, and column widths to match
the figure.
• Enter formulas using cell references from the Sandwiches, Wraps, and Salads
worksheets to display the average, minimum, and maximum food cost
percentages for the three categories, as shown in Figure 1.6.
• Format to match Figure 1.6.
• Insert a Clustered Column chart to visually display the data. Apply a Chart
Layout, change the titles, and size and position the chart as shown in Figure 1.6.
(Project 1C Food Costing continues on the next page)
Project 1C: Food Costing
|
Culinary Arts
15
CULINARY ARTS
GO! Make It
CONTENT-BASED ASSESSMENTS
Project 1C Food Costing (continued)
Excel 2016, Windows 10, Microsoft Corporation.
GO! Make It
FIGURE 1.6 Project 1C Food Costing
6 On the Sandwiches worksheet, change the selling price of the Rancher’s BBQ Beef
and Pork Tenderloin to $12.50 each. Note the changes to the figures on the Sandwiches
worksheet and also the Summary worksheet.
7 Modify and format the Possibilities worksheet as follows:
• Insert the codes for the file name and sheet name in the footer, change the
orientation to Landscape, and center horizontally on the page to match Figure 1.7.
• Merge and center the title and subtitle, and format to match Figure 1.7.
• Enter a formula to calculate a new selling price of the first sandwich based on the
percentage increase in cell E3, using absolute cell referencing. Fill the formula for
all the sandwiches. Also, calculate increased selling prices for each sandwich for
5% and 7% price increases.
• Calculate the new food cost percentages based on the current cost and the
increased selling prices. Hint: Use the current selling price as the base. Fill and
format as shown in Figure 1.7.
(Project 1C Food Costing continues on the next page)
16
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1
Project 1C Food Costing (continued)
Excel 2016, Windows 10, Microsoft Corporation.
CULINARY ARTS
GO! Make It
FIGURE 1.7 Project 1C Food Costing
• Use the AVERAGE function to display the average food cost percentage for each
price increase at the bottom of the worksheet.
• Format to match Figure 1.7. Adjust column widths and row heights if necessary
so that all data is visible.
8 Check the worksheets for spelling and grammar errors, and correct any errors you
find. Save the workbook and submit it as directed by your instructor.
END | You have completed Project 1C
Project 1C: Food Costing
|
Culinary Arts
17
OUTCOMES-BASED ASSESSMENTS
GO! Think
Apply skills from
these objectives:
1 Enter Data in a
PROJECT FILES
Worksheet
2 Construct and Copy
Formulas and Use the
SUM Function
3 Format Cells with
Merge & Center and
Cell Styles
4 Chart Data to Create a
Chart
5 Check Spelling in a
Worksheet
6 Construct Formulas
for Mathematical
Operations
7 Edit Values in a
Worksheet
8 Format a Worksheet
9 Use the SUM,
AVERAGE, MEDIAN,
MIN, and MAX
Functions
10 Navigate a Workbook
and Rename
Worksheets
11 Edit and Format
Multiple Worksheets at
the Same Time
12 Create a Summary
Sheet
Project 1D Hudson Grill
For Project 1D, you will need the following file:
e1D_Hudson_Grill
You will save your workbook as:
Lastname_Firstname_1D_Hudson_Grill
As manager of the Hudson Grill restaurant, you must analyze monthly sales data to
determine totals for sales, cost of goods sold, and profit for each month and construct a
summary for the quarter. It is also important to make a chart to depict this data.
1 Create a folder in which to store your files for this project called Hudson Grill.
2 Open the file e1D_Hudson_Grill, and then save it in your Hudson Grill folder as
Lastname_Firstname_1D_Hudson_Grill.
3 Group Sheet1, Sheet2, and Sheet3, and modify the grouped sheets as follows:
• Change the orientation to Landscape.
• Set the worksheet to center horizontally and vertically on the printed page. Set
gridlines to print.
• In the footer, insert the code for the file name.
• Set appropriate text wrapping, bold, column widths, row heights, and borders for
the column heading titles.
• Enter a formula for each menu item to calculate total food cost, referencing the
cells with the cost per item and plates purchased.
• Enter a formula to calculate total number of plates purchased.
• Enter a formula for each menu item to calculate percentage of total plates
purchased.
• Enter a formula to calculate total cost of goods sold (total of the food costs).
• Enter a formula for each menu item to calculate the total sales referencing the
cells with menu price and plates purchased.
• Enter a formula to calculate the total sales.
• Enter a formula to calculate the total profit on food by subtracting total cost of
goods sold from total sales.
• Arrange and format title across the columns used. Format The Hudson Grill as
the main title, and make the Monthly Sales row stand out.
• Format and align neatly. Apply appropriate cell styles, borders, and fill color.
• Make appropriate adjustments as needed so the grouped sheets clearly fit on one
page each. Ungroup the worksheets when done.
4 Rename the worksheet tabs of the ungrouped sheets according to the month and
year, and apply your choice of tab colors.
(Project 1D Hudson Grill continues on the next page)
18
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
OUTCOMES-BASED ASSESSMENTS
1
Project 1D Hudson Grill (continued)
5
Rename the fourth sheet 1st Qtr Summary.
• In the summary worksheet, use formulas to reference the cells from the monthly
sales worksheets.
• Set the worksheet to center horizontally on the printed page.
• In the footer, insert the codes for the sheet and file names.
• Arrange and format neatly and professionally. Use borders, fills, cell styles, font
sizes, and merge and center as appropriate.
• Insert a text box and arrow shape to point out that March had the highest profit.
• Create a chart that shows the first-quarter summary of sales and profit for
each month. Move the chart to a separate sheet, and then name the sheet
1st Qtr Chart. Apply appropriate style and layout. Add appropriate chart
elements. Adjust the fonts to ensure readability.
6 Check the worksheets for spelling and grammar errors, and correct any errors you
find. Save the workbook and submit it as directed by your instructor.
END | You have completed Project 1D
Project 1D: Hudson Grill
|
Culinary Arts
19
CULINARY ARTS
GO! Think
CONTENT-BASED ASSESSMENTS
GO! Make It
Apply skills from
these objectives:
1 Open and Save an
Project 1E Recipe Database
PROJECT FILES
Existing Database
2 Change the Structure
For Project 1E, you will need the following files:
3 Create Table
a1E_Recipe_Database.accdb (Access file)
a1E_Recipe_Ingredients.xlsx (Excel file)
of Tables and Add a
Second Table
Relationships
You will save your database as:
4 Create a Query in Query
Lastname_Firstname_1E_Recipe_Database.accdb
5 Sort Query Results
6 Specify Criteria in a
PROJECT RESULTS
Design
Query
7 Specify Numeric Criteria
in a Query
8 Use Compound Criteria
in a Query
9 Create a Query Based
on More Than One
Table
10 Create Calculated Fields
in a Query
11 Create a Form Using
the Form Wizard
12 Create Reports Using
the Report Wizard
13 Close a Database and
Access 2016, Windows 10, Microsoft Corporation.
Exit Access
FIGURE 1.8 Project 1E Recipe Database—Recipe Ingredients Table
(Project 1E Recipe Database continues on the next page)
20
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1
Project 1E Recipe Database (continued)
1 Create a folder in which to store your files for this project called Recipe Database.
2 From the student files that accompany this text, locate the a1E_Recipe_Ingredients
Excel workbook, and copy it into your Recipe Database folder.
3 From the student files that accompany this text, open a1E_Recipe_Database, and
then save it to your Recipe Database folder as Lastname_Firstname_1E_Recipe_Database.
Enable the content. Open the 1E Recipes table, and make yourself familiar with the data
in the table.
4 In the 1E Recipes table, rename the Minutes Prep Time field to Prep Time. Apply
Best Fit to all of the columns. Save and close the table.
5 Create a table as shown in Figure 1.8 by importing the a1E_Recipe_Ingredients
Excel workbook.
• Use the first row as the column headings.
• Use Ingredient ID as the primary key.
• Name the table Lastname_Firstname_1E_Recipe Ingredients.
• Open the table, and become familiar with the information in the table. Apply Best
Fit to all of the columns. Save and close the table.
6 Create a one-to-many relationship between the 1E Recipes table and the
Lastname_Firstname_1E_Recipe_Ingredients table using the Recipe ID field.
• Do not enforce referential integrity. Adjust the tables so that all fields are visible.
• Save and close the Relationships pane.
7 Open the 1E Recipes table. Because you have created the relationship, you will see
a plus sign or expand symbol to the left of each recipe name. Click the plus sign, and you
will see the ingredients listed for each recipe. Close the table.
8 Create a form based on the 1E Recipes table that can be used to enter more recipes.
Use the Form Wizard accepting the default settings. Save the form with the name
Lastname_Firstname_1E_Recipes, and then close the form.
9 Create a query using the 1E Recipes table that answers the following question:
Which recipes are low-fat recipes?
• Use the fields Recipe Name, Menu Item, Source, and Low Fat.
• Sort by Menu Item in ascending order in Design View.
• Run the query, and compare with Figure 1.9.
• Apply Best Fit to all of the columns. Save the query as
Lastname_Firstname_1E_Low_Fat, and then close the query.
10 Create a compound query using the 1E Recipes table that answers the following
question: Which individual appetizer or side dish menu items have less than 150 calories?
• Use the fields Recipe Name, Menu Item, and Calories.
• Sort by Menu Item in ascending order in Design View.
• Run the query and compare with Figure 1.10.
• Apply Best Fit to all of the columns. Save the query as
Lastname_Firstname_1E_Low_Cal_App_and_Side.
(Project 1E Recipe Database continues on the next page)
Project 1E: Recipe Database
|
Culinary Arts
21
CULINARY ARTS
GO! Make It
CONTENT-BASED ASSESSMENTS
Project 1E Recipe Database (continued)
Access 2016, Windows 10, Microsoft Corporation.
GO! Make It
FIGURE 1.9 Project 1E Recipe Database—Low-Fat Query
(Project 1E Recipe Database continues on the next page)
22
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1
Project 1E Recipe Database (continued)
Access 2016, Windows 10, Microsoft Corporation.
CULINARY ARTS
GO! Make It
FIGURE 1.10 Project 1E Recipe Database—Low-Cal App and Side Query
(Project 1E Recipe Database continues on the next page)
Project 1E: Recipe Database
|
Culinary Arts
23
CONTENT-BASED ASSESSMENTS
GO! Make It
Project 1E Recipe Database (continued)
Access 2016, Windows 10, Microsoft Corporation.
11 Create a calculated field query using the 1E Recipes table that answers the question:
What is the total time it takes to prepare a recipe including the prep time and cook or
chill minutes?
• Use the fields Recipe Name, Prep Time, and Cook or Chill Minutes.
• Create a calculated field Total Min that calculates the Prep Time plus the Cook
or Chill Minutes. Change the number format to Standard.
• Create another calculated field Total Hrs that divides the Total Min by 60.
Change the number format to Standard.
• Sort by Recipe Name in ascending order in Design View.
• Run the query, and compare with Figure 1.11.
• Apply Best Fit to all of the columns. Save the query as
Lastname_Firstname_1E_Total_Time, and then close the query.
FIGURE 1.11 Project 1E Recipe Database—Total Time Query
(Project 1E Recipe Database continues on the next page)
24
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1
Project 1E Recipe Database (continued)
Access 2016, Windows 10, Microsoft Corporation.
12 Create a query using the 1E Recipes table that answers the question: Which recipes
serve four or more?
• Use the Recipe Name, Source, Menu Item, and Servings.
• Sort by Menu item in ascending order in Design View.
• Run the query, and compare with Figure 1.12.
• Save the query as Lastname_Firstname_1E_Serves 4+, and then close the query.
FIGURE 1.12 Project 1E Recipe Database—Serves 4+ Query
(Project 1E Recipe Database continues on the next page)
Project 1E: Recipe Database
|
Culinary Arts
25
CULINARY ARTS
GO! Make It
CONTENT-BASED ASSESSMENTS
GO! Make It
Project 1E Recipe Database (continued)
Access 2016, Windows 10, Microsoft Corporation.
13 Create a query using both tables that answers the following question: What are the
ingredients in Recipe 2, and how much of each ingredient is needed?
• Use the Recipe ID, Recipe Name, Ingredient, and Quantity fields.
• Sort in ascending order by Ingredient in Design View.
• Run the query, and compare with Figure 1.13.
• Apply Best Fit to all of the columns. Save the query as
Lastname_Firstname_1E_Recipe_2_Ingred, and then close the query.
FIGURE 1.13 Project 1E Recipe Database—Recipe 2 Ingredients Query
(Project 1E Recipe Database continues on the next page)
26
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1
Project 1E Recipe Database (continued)
CULINARY ARTS
GO! Make It
Access 2016, Windows 10, Microsoft Corporation.
14 Use the Report Wizard to create a report matching Figure 1.14 using data from
1E Recipes and Lastname_Firstname_1E_Recipe_Ingredients.
• Use the Recipe Name, Ingredient, Quantity, and Comments fields.
• View data by Recipe Name.
• Do not group or sort the data.
• Accept the Stepped Layout and Portrait Orientation default settings.
• Save the report as Lastname_Firstname_1E_Recipe_Ingredients. Close the report.
FIGURE 1.14 Project 1E Recipe Database—Recipe Ingredients Report
15 Close the database, and submit it as directed by your instructor.
END | You have completed Project 1E
Project 1E: Recipe Database
|
Culinary Arts
27
OUTCOMES-BASED ASSESSMENTS
GO! Think
Apply skills from
these objectives:
1 Create a Table and
Project 1F Kitchen Inventory Database
PROJECT FILES
Define Fields in a Blank
Desktop Database
For Project 1F, you will need the following files:
2 Change the Structure
New blank Access database
a1F_Cooking_Equipment (Excel file)
of Tables and Add a
Second Table
3 Create and Use a Form
You will save your database as:
to Add and Delete
Records
Lastname_Firstname_1F_Kitchen_Inventory
4 Create Table
You are starting a catering business and have purchased some basic kitchen
cookware, utensils, and cutlery. A local chef has advised you to keep records of your
equipment and supplies. You will create a new database to store and track your inventory
of equipment. You intend to maintain a list of restaurant suppliers from whom you will
purchase your equipment and supplies.
1 Create a folder in which to store your files for this project called
Kitchen Inventory Database. From the student data files that accompany this text, copy
the Excel file, a1F_Cooking_Equipment, into this folder.
2 Create a new blank desktop database, and save it to your Kitchen Inventory
Database folder. Name the database Lastname_Firstname_1F_Kitchen_Inventory.
3 Create a new table to store data for three restaurant suppliers. Rename the ID
field Supplier ID, and then change the data type to Short Text. Create names and select
a data type for each field in your table based on the type of information listed below.
SUP101, SUP102, and SUP103 are Supplier IDs. Save the table, and name it
Lastname_Firstname_1F_Restaurant_Suppliers. Enter the following data in your
table:
Relationships
5 Create a Query in Query
Design
6 Sort Query Results
7 Specify Criteria in a
Query
8 Specify Numeric Criteria
in a Query
9 Use Compound Criteria
in a Query
10 Create Calculated Fields
in a Query
11 Create Reports Using
Report Wizard
12 Modify the Design of a
Report
13 Close a Database and
Exit Access
SUP101
SUP102
SUP103
King of Culinary Supplies
Baker’s Dream
Wholesale Kitchen Equipment
5432 North Nevada Avenue
90 Frontage Road
6789 Pinion Bluffs Parkway
Colorado Springs
Denver
Colorado Springs
CO
CO
CO
80903
80266
80920
719-555-3211
303-555-4567
719-555-4958
www.kingofculinary.com
www.bakersdream.com
www.kitchenequip.com
4 Create a form for your table, and save it with the default name.
5 Search the Internet to find at least one additional supplier that sells cooking supplies
or equipment. Using the form, enter the additional supplier information into your table.
6 Create a new table by importing the Excel workbook a1F_Cooking_Equipment
into your database. Allow Access to add the primary key field. Name the table
Lastname_Firstname_1F_Cooking_Equipment.
(Project 1F Kitchen Inventory Database continues on the next page)
28
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
OUTCOMES-BASED ASSESSMENTS
1
Project 1F Kitchen Inventory Database (continued)
7 Create a relationship between the two tables using a field that is common to both
tables. Enforce referential integrity.
8 Create queries to answer the following questions, and include fields of your choice.
Enter criteria and sort appropriately in Design View. Save and name each query using
words that are descriptive of the query results.
• Select a city, and then display only the suppliers that are in that city. What is the
street address for each supplier in that city?
• What baking pans are in your existing inventory, and what is the description of
each pan?
• For which items do you have more than eight in your inventory?
• Based on the quantity in stock and the unit price, what is the value of each item?
• What are the sizes and quantities on hand for the items in the cutlery and utensils
categories?
• Which items are missing a price? Hint: Use Is Null for the criteria.
9 Run the query that calculates item value. Add a Total Row to the bottom of the query
results to compute the total value of your equipment.
10 Search the Internet to find prices for the missing items, and then enter the prices in
the table.
11 Create a report that displays your cooking equipment inventory. Group and sort the
records as you desire. Modify the column widths and change the orientation, as needed so
that all data is visible. Name and save the report.
12 Close the database, and submit it as directed by your instructor.
END | You have completed Project 1F
Project 1F: Kitchen Inventory Database
|
Culinary Arts
29
CULINARY ARTS
GO! Think
CONTENT-BASED ASSESSMENTS
GO! Make It Project 1G Community Garden Presentation
Apply skills from
these objectives:
1 Edit a Presentation in
PROJECT FILES
Normal View
2 Add Pictures to a
Presentation
3 Print and View a
Presentation
4 Edit an Existing
Presentation
5 Format Slides
6 Apply Slide Transitions
7 Format Numbered and
Bulleted Lists
8 Insert Text Boxes and
Shapes
9 Format Objects
10 Remove Picture
Backgrounds and Insert
WordArt
11 Create and Format a
SmartArt Graphic
12 Create and Modify
For Project 1G, you will need the following files:
p1G_Community_Garden
p1G_Club_Logo
p1G_Garden
p1G_Hands
p1G_Garden_Photo
p1G_Grass
p1G_PPCC_Logo
p1G_Tomato
p1G_Vegetables
p1G_Vegetables_2
p1G_Veggie_Tree
You will save your presentation as:
Lastname_Firstname_1G_Community_Garden
PROJECT RESULTS
PowerPoint 2016, Windows 10, Microsoft Corporation.
Tables
FIGURE 1.15 Project 1G Community Garden Presentation
(Project 1G Community Garden Presentation continues on the next page)
30
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1
(continued)
1 Your culinary arts club has created a community garden. You have been asked to
create a presentation about your project for students at another college.
2 Create a new folder to store your files for this project, and name the folder
Community Garden.
3 From the student files that accompany this text, locate the Culinary, PowerPoint,
Community Garden project files, and copy all the p1G files for this project into your
Community Garden folder.
4 Open the file p1G_Community_Garden from your Community Garden folder,
and save it as Lastname_Firstname_1G_Community_Garden.
5 Insert a header and footer for the notes and handouts.
• Display a date that updates automatically.
• Add to the footer the page number and Presented by Firstname Lastname.
6 On Slide 1 as shown in Figure 1.15:
• Create a WordArt title with the text Community Garden.
• Change the background style graphics to picture, and insert the p1G_Grass
picture as the background.
• Insert the p1G_PPCC_Logo picture in the upper left corner.
• Insert the p1G_Club_Logo picture in the upper right corner.
7 Insert a new slide with the Title and Content layout, as shown in Figure 1.15.
• In the title placeholder, enter: Purpose.
• In the content placeholder, enter:
Provide an educational opportunity for PPCC Culinary Arts students to cultivate
green space and promote awareness of the environment, health, and nutrition
among students, faculty, and staff.
• Insert the p1G_Hands picture in the upper right corner.
• Grass will be added to the slides in step 15.
8 Insert a new slide with Title and Content layout, as shown in Figure 1.15.
• In the title placeholder, type Goals.
• Insert a SmartArt List Continuous Picture with the following information:
Picture file to Insert
p1G_Vegetables
p1G_Tomato
p1G_Vegetables_2
Text to Enter
Promote Healthy
Lifestyle
Promote
Awareness
Provide Help for
Students
• On the Notes pane, type the following note:
A community garden will promote awareness of the impact WE have on our
environment. It will also provide for the many needs of the students in the PPCC
community.
(Project 1G Community Garden Presentation continues on the next page)
Project 1G: Community Garden Presentation
|
Culinary Arts
31
CULINARY ARTS
GO! Make It Project 1G Community Garden Presentation
CONTENT-BASED ASSESSMENTS
GO! Make It Project 1G Community Garden Presentation
9
10
11
12
13
14
(continued)
Insert a new slide with the Title and Content layout.
• In the title placeholder, type Benefits and Rewards.
• Use a bulleted list, and type the following information:
Develop a program for storing, processing, and composting waste.
Use composted soil for on-site gardens and greenhouse.
Reduce food costs for the PPCC culinary program.
Promote public relations in the PPCC community.
Reuse all four slides from the p1G_Garden presentation.
On the first new slide, Slide 5, format the text Green to match Figure 1.15.
On the second new slide, Slide 6, edit the SmartArt to match Figure 1.15.
In Slide 8, insert the p1G_Veggie_Tree picture to match Figure 1.15.
Insert a new slide with Title and Content layout to match Figure 1.15.
• Title it Financial Contributors.
• Insert a table with the following information:
Organization
Amount
PPCC Foundation
$1,500
Student Government
3,000
Culinary Arts Club
500
Community Business Donations
1,000
Total
$6,000
15 Select Slides 2 through 9. You will place the grass at the bottom of each slide,
positioned a bit lower than on Slide 1, to match Figure 1.15.
• Change the background style for all of the selected slides to a picture by using the
p1G_Grass picture.
• In the Format Background pane, set Offset top to 0% and Offset bottom to –40%.
16 After Slide 9, insert a new slide with Picture with Caption layout to match Figure 1.15.
• Insert the p1G_Garden_Photo picture.
• Format the background style to Solid Fill Standard Green color.
• Insert the p1G_PPCC_Logo picture in the upper left corner.
• Enter the title text PPCC Community Garden Completed June 2016.
• Under the title caption, enter For further information, contact the Culinary
Arts Department at Pikes Peak Community College.
17 To all slides apply the Transition Cover.
18 Insert the slide number on each slide but do not include it on the title slide.
19 Run the slide show, and proofread.
20 Save the presentation, and submit it as directed by your instructor.
END | You have completed Project 1G
32
Culinary Arts
|
Chapter 1: DISCIPLINE SPECIFIC PROJECTS
OUTCOMES-BASED ASSESSMENTS
Presentation
2 Edit a Presentation in
Normal View
3 Add Pictures to a
Presentation
4 Print and View a
Presentation
5 Format Slides
6 Apply Slide Transitions
7 Format Numbered and
Bulleted Lists
8 Insert Online Pictures
9 Format Objects
10 Create and Format a
SmartArt Graphic
11 Customize Slide
Backgrounds and
Themes
12 Animate a Slide Show
13 Create and Modify
Tables
14 Create and Modify
Charts
GO! Think
1
Project 1H Healthy Recipe Presentation
CULINARY ARTS
Apply skills from
these objectives:
1 Create a New
PROJECT FILES
For Project 1H, you will need the following file:
New blank PowerPoint presentation
You will save your presentation as:
Lastname_Firstname_1H_Healthy_Recipe
1 Your culinary arts club is participating in a neighborhood health fair, and you have
been asked to create a presentation telling how to prepare a healthy recipe.
2 Select a published recipe, an old family recipe, or one of your own creations. Keep
in mind that you must cite your source(s) in your presentation.
3 Create a new folder for this project, and name it Healthy Recipe.
4 Create a new blank PowerPoint presentation file. Save the file in your
Healthy Recipe folder as Lastname_Firstname_1H_Healthy_Recipe.
5 Include a list of ingredients, preparation directions, a photo of the finished recipe,
and nutritional information such as calories, fat, fiber, and carbohydrates.
6 In the Notes and Handouts footer, enter your name and 1H_Healthy_Recipe.
7 Insert the following footer on the slides: Presented by Firstname Lastname.
8 Apply a design theme of your choice.
9 Use at least three different slide layouts. Follow the 6 × 6 rule. (No more than six
lines of text and no more than six words in a line.)
10 Use WordArt on at least one slide.
11 Insert online pictures or photos related to your topic.
12 Use SmartArt.
13 Create a table or chart to display information about your recipe.
14 Apply transitions to all slides, and if you like, add simple animation.
15 In the Notes pane, enter notes about the points you plan to make during the
presentation.
16 Run the slide show, and proofread.
17 Save the presentation, and submit it as directed by your instructor.
END | You have completed Project 1H
Project 1H: Healthy Recipe Presentation
|
Culinary Arts
33
This page intentionally left blank
You will complete the following discipline specific projects:
Word
2
H E A LT H C A R E
Discipline Specific
Projects
GO! Make It | Project 2A Healthcare Dental Mailing (p. 36)
Part 1 Create a proper business letter to match visual summary.
Use graphics, no spacing style, and character and paragraph formatting.
Part 2 Create a newsletter to match visual summary.
Use graphics, character and paragraph formatting, table, tab stops, footnotes, and save as PDF.
Part 3 Create mailing labels to match visual summary.
Edit table, use character and paragraph formatting, and mail merge.
Part 4 Create form letters to match visual summary.
Edit table and use mail merge.
GO! Think | Project 2B Healthcare Medical Mailing (p. 44)
Part 1 Create a business letter to inform staff about a new medical facility.
Use graphics, no spacing style, and character and paragraph formatting.
Part 2 Create an MLA paper about diet and exercise.
Use paragraph formatting, page numbering, footnotes, citations, Source Manager, and save as
PDF.
Part 3 Create mailing labels.
Edit table, use character and paragraph formatting, and mail merge.
Part 4 Create form letters.
Use mail merge.
Excel
GO! Make It | Project 2C Medical Invoice (p. 49)
Create a medical invoice workbook to match visual summary.
Enter data, formulas, and functions; chart data; group worksheets; format; and make summary sheet.
GO! Think | Project 2D Medical Supplies Order (p. 53)
Create a workbook to keep track of medical supplies and orders.
Enter data, formulas, and functions; chart data; group worksheets; format; and make summary sheet.
Access
GO! Make It | Project 2E Inventory Database (p. 55)
Work with an inventory database to match visual summary. Add tables, edit table structure, and join
tables; create forms and reports; and create queries with compound criteria, calculated fields, and
grouping.
GO! Think | Project 2F Billing Database (p. 65)
Work with a database to keep track of suppliers and inventory. Add a table, edit table structure, and
join tables; create forms and reports; and create queries with compound criteria, calculated fields, and
grouping.
PowerPoint
GO! Make It | Project 2G Lowering Blood Pressure Presentation (p. 67)
Create a blood pressure presentation to match visual summary. Format slides and work with pictures,
tables, charts, WordArt, SmartArt, animation, transitions, backgrounds, and themes.
GO! Think | Project 2H Patient Presentation (p. 70)
Create a presentation for patients living with a particular disease or condition. Format slides, and work
with pictures, tables, charts, WordArt, SmartArt, animation, transitions, backgrounds, and themes.
35
CONTENT-BASED ASSESSMENTS
GO! Make It
Apply skills from
these objectives:
1 Create a New
Document from an
Existing Document
roject 2A Healthcare Dental Mailing:
P
Part 1 Healthcare Dental Letter
PROJECT FILES
2 Change Document and
For Project 2A Healthcare Dental Mailing Part 1, you will need the following files:
Paragraph Layout
3 Insert and Format
w2A_Dental_Letter
w2A_Dental_Logo
4 Use Special Character
You will save your document as:
Graphics
and Paragraph
Formatting
Lastname_Firstname_2A_Dental_Letter
5 Change and Reorganize
PROJECT RESULTS
Text
6 Use Proofing Options
7 Preview and Print a
Word 2016, Windows 10, Microsoft Corporation.
Document
FIGURE 2.1 Project 2A, Part 1 Dental Letter
(Project 2A Part 1 Healthcare Dental Letter continues on the next page)
36
Healthcare
|
Chapter 2: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
2
Project 2A Part 1 Healthcare Dental Letter (continued)
1 Create a folder in which to save your files for this
project called Healthcare Dental Mailing.
2 From the student files that accompany this text,
locate and open the file w2A_Dental_Letter, and then
save the file in the Healthcare Dental Mailing folder
as Lastname_Firstname_2A_Dental_Letter. Use this
file to create a properly formatted business letter. Make
the following modifications so that the document looks
like the one shown in Figure 2.1.
3 Insert a footer with the file name as a Quick Parts
field in the footer.
4 Change the top margin to .5". Set the side and
bottom margins to 1".
5 For the entire document, change the line spacing
to single and change the paragraph spacing after to
zero, and set all indents to zero.
6 In the letterhead, from your student files, insert
the picture w2A_Dental_Logo. Size and position the
logo in the letterhead.
7 At the top of the page, edit and align the text and
format the fonts to match the letterhead at the top of the
letter shown in Figure 2.1.
8 Add a top border to the blank line below the
letterhead.
9 Make corrections and additions to the text,
including size, capitalization, punctuation, and content
to match the proper business letter format shown in
Figure 2.1. Use the current date.
10 Format the letter by adding and removing blank
lines to use proper vertical spacing, as shown in
Figure 2.1.
11 Correct any spelling and grammar errors. Preview
the document, and compare with Figure 2.1, making
adjustments as needed.
12 Save the document, and submit it as directed by
your instructor.
Project 2A: Part 1 Healthcare Dental Letter
|
Healthcare
37
HEALTHCARE
GO! Make It
CONTENT-BASED ASSESSMENTS
GO! Make It Project 2A Part 2 Healthcare Dental Newsletter
Apply skills from
these objectives:
1 Create a New
PROJECT FILES
Document from an
Existing Document
For Project 2A Healthcare Dental Mailing Part 2, you will need the following files:
2 Change Document and
w2A_Dental_Newsletter
w2A_Dental_Logo
w2A_Basketball
w2A_Dentist
Paragraph Layout
3 Insert a SmartArt
Graphic
4 Insert a Footnote
5 Insert and Format
You will save your documents as:
Graphics
6 Use Special Character
Lastname_Firstname_2A_Dental_Newsletter
Lastname_Firstname_2A_Dental_Newsletter_PDF
7 Change and Reorganize
PROJECT RESULTS
and Paragraph
Formatting
Text
8 Create and Format a
Table
9 Set and Modify Tab
Stops
10 Use Proofing Options
11 Preview and Print a
Document
12 Save a Document as a
Word 2016, Windows 10, Microsoft Corporation.
PDF
FIGURE 2.2 Project 2A, Part 2 Dental Newsletter
(Project 2A Part 2 Healthcare Dental Newsletter continues on the next page)
38
Healthcare
|
Chapter 2: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1 From the student files that accompany this
text, locate and copy the files w2A_Dental_Logo,
w2A_Basketball and w2A_Dentist into the
Healthcare Dental Mailing folder.
2 From the student files that accompany this text,
locate and open the file w2A_Dental_Newsletter, and
then save the file in the Healthcare Dental Mailing
folder as Lastname_Firstname_2A_Dental_Newsletter.
You will use this file to create a one-page newsletter.
Make the following modifications so that the document
looks like the one shown in Figure 2.2.
3 Edit the footer to match Figure 2.2. Add the text
Printed on Recycled Paper, and insert the file name as
a Quick Parts field.
4 Set margins and columns to match Figure 2.2.
5 Insert the w2A_Dental_Logo picture file. Set text
wrapping, and then size and position it.
6 Enter and edit text as needed, and set tabs to
match Figure 2.2.
7 Insert borders to match Figure 2.2.
8 Insert picture files, SmartArt, and a table. Position
and format them to match Figure 2.2.
9 At the end of the first paragraph about mouth
protectors, insert a footnote. Enter the footnote text:
ADA/National High School Athletics Partnership.
10 Set line and paragraph spacing, align text, and
format fonts to match Figure 2.2.
11 Check the newsletter for spelling and grammar
errors, and correct any errors you find. Ensure that the
newsletter fits on one page. Preview the document, and
compare with Figure 2.2, making adjustments as needed.
12 Save the document in your
Healthcare Dental Mailing folder.
13 Save the document again as a PDF file with the name
Lastname_Firstname_2A_Dental_Newsletter_PDF
in your Healthcare Dental Mailing folder.
14 Submit file(s) as directed by your instructor.
Project 2A: Part 2 Healthcare Dental Newsletter
|
Healthcare
39
HEALTHCARE
2
GO! Make It Project 2A Part 2 Healthcare Dental Newsletter(continued)
CONTENT-BASED ASSESSMENTS
GO! Make It Project 2A Part 3 Healthcare Dental
Apply skills from
these objectives:
1 Create Mailing Labels
Mailing Labels
Using Mail Merge
PROJECT FILES
2 Format a Table
3 Change Document and
For Project 2A Healthcare Dental Mailing Part 3, you will need the following files:
Paragraph Layout
New blank Word document
w2A_Dental_Addresses
4 Preview and Print a
Document
You will save your documents as:
Lastname_Firstname_2A_Dental_Addresses
Lastname_Firstname_2A_Dental_Labels
Word 2016, Windows 10, Microsoft Corporation.
PROJECT RESULTS
FIGURE 2.3 Project 2A, Part 3 Dental Mailing Labels
(Project 2A Part 3 Healthcare Dental Mailing Labels continues on the next page)
40
Healthcare
|
Chapter 2: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
1 From the student files that accompany this text,
locate and open the file w2A_Dental_Addresses, and
add yourself to the top of the mailing list. Save the file
as Lastname_Firstname_2A_Dental_Addresses in
the Healthcare Dental Mailing folder, and then close
the file.
2 Starting with a new blank Word document, use mail
merge to create a document that looks like the one shown
in Figure 2.3. Your labels are Avery US Letter, 5160 Easy
Peel Address labels, which are 1" tall by 2.63" wide.
3 The recipient data source is
Lastname_Firstname_2A_Dental_Addresses.
4 When inserting the address block, notice that in
this data source the first and last names are both in one
Name column. Use Match Fields to match the Name
column to First Name and do not match Last Name in
the address block.
5 Ensure that all lines fit in the label area. To avoid
confusing this file with the end results file, save this file
in your Healthcare Dental Mailing folder as
Lastname_Firstname_Dental_Labels_Main.
6 Preview the document, and compare with Figure 2.3,
making adjustments as needed. Save the main document.
7 At the end of the Merge, Edit individual
labels to create a new file with only the label
text. Save your new address labels document
in your Healthcare Dental Mailing folder as
Lastname_Firstname_2A_Dental_Labels.
8 To the footer, add the file name as a Quick Parts
field. Preview the document, and if necessary delete
blank lines or row(s) at the bottom of the table so that
the entire document fits on one page (even the blank
labels). Modify the bottom margin if necessary to
ensure the footer will display on the page if printed.
Save this as the end results file.
9 Submit file(s) as directed by your instructor.
Project 2A: Part 3 Healthcare Dental Mailing Labels
|
Healthcare
41
2
HEALTHCARE
GO! Make It Project 2A Part 3 Healthcare Dental Mailing Labels (continued)
CONTENT-BASED ASSESSMENTS
GO! Make It
Apply skills from
these objectives:
1 Create a New
Document from an
Existing Document
roject 2A Part 4 Healthcare Dental
P
Form Letters
PROJECT FILES
2 Format a Table
3 Merge a Data Source
For Project 2A Healthcare Dental Mailing Part 4, you will need the following files:
Lastname_Firstname_2A_Dental_Addresses (from Part 3 of this project)
Lastname_Firstname_2A_Dental_Letter (from Part 1 of this project)
and a Main Document
4 Preview and Print a
Document
You will save your documents as:
Lastname_Firstname_2A_Dental_Form_Letters
Lastname_Firstname_2A_Dental_Letter_Addresses
Word 2016, Windows 10, Microsoft Corporation.
PROJECT RESULTS
FIGURE 2.4 Project 2A, Part 4 Dental Form Letters
(Project 2A Part 4 Healthcare Dental Form Letters continues on the next page)
42
Healthcare
|
Chapter 2: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
2
Project 2A Part 4 Healthcare Dental Form Letters (continued)
1 From your Healthcare Dental Mailing folder, locate
and open your file Lastname_Firstname_2A_Dental_
Addresses. Add two columns to the table. Edit and
rearrange the content in the table to include separate first
and last name columns and a column for recipient titles
such as Mr. or Ms., and enter appropriate titles. Save and
close the file.
2 You will use mail merge to create a new document
containing 12 form letters that look like the one shown in
Figure 2.4. From your Healthcare Dental Mailing folder,
locate and open your file Lastname_Firstname_2A_
Dental_Letter. Save the file as Lastname_Firstname_2A_
Dental_Main_Letter to prevent confusion with your
end results file.
3 In the footer of the main letter file, replace the field
name code, typing in your last name and first name and
2A Dental Form Letters. This new footer will show on
each of the form letters. Save the main document file.
4 The data source is Lastname_Firstname_2A_
Dental_Letter_Addresses. Insert a proper business
letter address block and greeting line.
5 Preview the document, and compare with Figure 2.4.
Verify that the letters are properly formatted in the
merge preview, and go back to fix as needed. Save the
main document.
6 At the end of the merge, choose to Edit individual
letters to create a new file with the 12 letters, one on
each page. Save the file with the 12 letters as
Lastname_Firstname_2A_Dental_Form_Letters in
your Healthcare Dental Mailing folder. Save this end
results file.
7 Submit file(s) as directed by your instructor.
END | You have completed Project 2A
Project 2A: Part 4 Healthcare Dental Form Letters
|
Healthcare
43
HEALTHCARE
GO! Make It
OUTCOMES-BASED ASSESSMENTS
GO! Think Project 2B Healthcare Medical Mailing:
Apply skills from
these objectives:
1 Create a New
Part 1 Healthcare Medical Letter
Document from an
Existing Document
PROJECT FILES
2 Change Document and
For Project 2B Healthcare Medical Mailing Part 1, you will need the following files:
Paragraph Layout
3 Insert and Format
w2B_Global_Hospital_Logo
w2B_Medical_Letter
4 Use Special Character
You will save your document as:
Graphics
and Paragraph
Formatting
Lastname_Firstname_2B_Medical_Letter
5 Change and Reorganize
Text
You are the assistant to the vice president of facility development for a major hospital
system. You want to send a letter to a doctor telling about a new medical facility your
hospital system is planning to open.
1 Create a folder in which to save your files for this project called
Healthcare Medical Mailing.
2 From the student files that accompany this text, locate and open the file
w2B_Medical_Letter, and then save the file in your Healthcare Medical Mailing folder
as Lastname_Firstname_2B_Medical_Letter.
3 Add the file name to the footer as a Quick Parts field.
4 Edit and properly format a one-page letter informing doctors about the new medical
facility. Reference the example of a properly formatted business letter in the previous
project or see proper business letter requirements in Appendix A.
5 Create a letterhead using the first three lines in the letter. Insert the
w2B_Global_Hospital_Logo graphic. Insert a paragraph border to separate the
letterhead from the text in the letter.
6 Research special hospital services or new medical technologies. Insert three or four
special hospital services or new medical technologies as a list or table. Include one related
to wellness or preventive health because with this letter you will be enclosing a paper
about diet and exercise.
7 Set the line spacing, paragraph spacing, blank lines, and text as appropriate for a
properly formatted one-page business letter.
8 Add a small paragraph or sentence indicating that you are enclosing, for the doctor’s
review, a paper about the health effects of diet and exercise.
9 Preview the document, and go back to adjust as needed. Compare with the example
of a properly formatted business letter in the previous project or see proper business letter
requirements in Appendix A. Adjust margins and font size appropriately to make the letter
fit neatly on one page.
10 Check the letter for spelling and grammar errors, and correct any errors you find.
11 Save the document, and submit the letter file as directed by your instructor.
6 Use Proofing Options
7 Preview and Print a
Document
44
Healthcare
|
Chapter 2: DISCIPLINE SPECIFIC PROJECTS
OUTCOMES-BASED ASSESSMENTS
Document from an
Existing Document
2 Use Special Character
and Paragraph
Formatting
3 Change Document and
Paragraph Layout
4 Create Citations and
a Bibliography in a
Research Paper
5 Insert Footnotes in a
Research Paper
6 Change and Reorganize
Text
7 Use Proofing Options
8 Preview and Print a
Document
9 Save a Document as a
PDF
2
GO! Think Project 2B Part 2 Healthcare MLA Paper
HEALTHCARE
Apply skills from
these objectives:
1 Create a New
PROJECT FILES
For Project 2B Healthcare Medical Mailing Part 2, you will need the following file:
w2B_Diet_and_Exercise
You will save your documents as:
Lastname_Firstname_2B_Diet_and_Exercise
Lastname_Firstname_2B_ Diet_and_Exercise_PDF
You are a student in Dr. Hilary Kim’s Physiology course. You have been asked to
prepare a research paper about a topic related to wellness. You have researched the effects
of diet and exercise. Dr. Kim is working with Global Hospital Corp. to develop their new
Wellness Center in south Colorado Springs. She will be distributing the best wellness
paper from her class to doctors in the Global Hospital Corp. system in the south Colorado
Springs area.
1 From the student files that accompany this text, locate and open the file
w2B_Diet_and_Exercise, and then save the file in your Healthcare Medical Mailing
folder as Lastname_Firstname_2B_Diet_and_Exercise.
2 Add the file name to the footer as a Quick Parts field.
3 Using MLA Edition 8 research paper format, set line and paragraph spacing and
enter the first page information. See Appendix B.
4 Format the page numbering and paragraph indents using MLA Edition 8 research
paper format.
5 Insert two footnotes as follows:
• At the end of the second paragraph, enter a footnote: The objective of the study
was to examine the effects of exercise on total and intra-abdominal body fat
overall and by level of exercise.
• On the second page, enter a footnote at the end of the paragraph that begins
Exercise also has and ends with the quote “. . . intra-abdominal body fat,” says
Irwin. Enter the text of the note: Physical activity may provide a low-risk
method of preventing weight gain. Unlike diet-induced weight loss,
exercise-induced weight loss increases cardiorespiratory fitness levels.
6 Using the MLA Edition 8 research paper format, enter three sources using the
Source Manager as follows:
• The first source, NIH News, is a webpage with no named author, so use
U.S. Department of Health and Human Services as the corporate author. Enter
the title of the webpage: NIH News. Enter the date of publication, 2012 October
15. For the date accessed, use the current date. For medium, enter Web.
• The second source is a book titled Cardiovascular Physiology, Seventh Edition.
The authors are Mohrman, David and Lois Heller. It was published in 2010 in
New York by McGraw-Hill Professional. For medium, enter Print.
(Project 2B Part 2 Healthcare MLA Paper continues on the next page)
Project 2B: Part 2 Healthcare MLA Paper
|
Healthcare
45
OUTCOMES-BASED ASSESSMENTS
GO! Think Project 2B Part 2 Healthcare MLA Paper
(continued)
• The third source is a book titled Exercise for Mood and Anxiety: Proven
Strategies for Overcoming Depression and Enhancing Well-Being. The
authors are Otto, Michael and Jasper A. J. Smits. It was published in 2011 in
New York by Oxford University Press, USA. For medium, enter Print.
46
Healthcare
|
7
Using the MLA Edition 8 research paper format, insert three citations as follows:
• At the end of the first paragraph, enter a citation for Otto. Edit to include page 3
in the citation.
• On the second page, in the paragraph that begins Other positive effects, at the end
of the second sentence right after blood flow increases substantially, enter a
citation for Mohrman. Edit to include page 195 in the citation.
• At the bottom of the second page, at the end of the paragraph beginning
A recent study and ending with can sustain weight loss, enter a citation for
U.S. Department of Health and Human Services.
8
9
10
11
Create a reference page using the MLA Edition 8 research paper format.
Preview, proof, and correct as needed. Save the document.
Save the document again as a PDF.
Submit file(s) as directed by your instructor.
Chapter 2: DISCIPLINE SPECIFIC PROJECTS
OUTCOMES-BASED ASSESSMENTS
Using Mail Merge
2 Format a Table
3 Change Document and
Paragraph Layout
4 Preview and Print a
Document
2
GO! Think Project 2B Part 3 Healthcare Medical
HEALTHCARE
Apply skills from
these objectives:
1 Create Mailing Labels
Mailing Labels
PROJECT FILES
For Project 2B Healthcare Medical Mailing Part 3, you will need the following files:
New blank Word document
w2B_Medical_Addresses
You will save your document as:
Lastname_Firstname_2B_Medical_Labels
1 From the student files that accompany this text, locate and copy the file
w2B_Medical_Addresses to your Healthcare Medical Mailing folder.
2 Start with a new blank Word document. To prevent confusion with the end results
file, save the file as Lastname_Firstname_2B_Medical_Labels_Main in your
Healthcare Medical Mailing folder.
3 Use mail merge to create labels. Your labels are Avery US Letter, 5160 Easy Peel
Address labels, which are 1" tall by 2.63" wide.
4 Use w2B_Medical_Addresses as your data source. Use Match Fields to insert
proper and complete names and addresses.
5 Arrange your labels and change spacing to ensure that all lines fit in the label area.
Save the main document file.
6 After the merge is completed, Edit individual labels to create a new file with all the
labels. Save the document as Lastname_Firstname_2B_Medical_Labels.
7 To the footer, add the file name as a Quick Parts field. If necessary, delete blank
lines or row(s) at the bottom of the table so that the entire document fits on one page
(even the blank labels). Modify the bottom margin, if necessary, to ensure the footer will
display on the page if printed. Save this end results file.
8 Submit file(s) as directed by your instructor.
Project 2B: Part 3 Healthcare Medical Mailing Labels
|
Healthcare
47
OUTCOMES-BASED ASSESSMENTS
GO! Think
Apply skills from
these objectives:
1 Create a New
Document from an
Existing Document
roject 2B Part 4 Healthcare Medical Form
P
Letters
PROJECT FILES
2 Merge a Data Source
For Project 2B Healthcare Medical Mailing Part 4, you will need the following files:
and a Main Document
Lastname_FirstName_2B_Medical_Letter (from Part 1 of this project)
w2B_Medical_Addresses
3 Preview and Print a
Document
You will save your document as:
Lastname_Firstname_2B_Medical_Form_Letters
1 From your Healthcare Medical Mailing folder, locate and open your file
Lastname_Firstname_2B_Medical_Letter. Save the file as
Lastname_Firstname_2B_Medical_Main_Letter to prevent confusion with your end
results file. Use mail merge to create properly formatted business letters.
2 In the footer of the main letter file, replace the field name code, typing in your last
name and first name and 2B Medical Form Letters. This new footer will show on each
of the form letters.
3 Use mail merge and filter the data source, the student data file w2B_Medical_Addresses,
to create properly formatted business letters for only the doctors in Colorado Springs. Use
Match Fields to insert proper and complete names and addresses. Save the main
document file.
4 After the merge is completed, Edit individual letters to create a new file with all 18
form letters with proper business letter format.
5 Save this end results file as Lastname_Firstname_2B_Medical_Form_Letters.
6 Submit file(s) as directed by your instructor.
END | You have completed Project 2B
48
Healthcare
|
Chapter 2: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
Worksheet
GO! Make It
PROJECT FILES
2 Construct and Copy
For Project 2C, you will need the following file:
3 Format Cells with
e2C_Invoice
e2C_ALLMED_Logo
Formulas and Use the
SUM Function
Merge & Center and
Cell Styles
4 Chart Data to Create a
Column Chart
5 Check Spelling in a
2
Project 2C Medical Invoice
HEALTHCARE
Apply skills from
these objectives:
1 Enter Data in a
You will save your workbook as:
Lastname_Firstname_2C_Invoice
PROJECT RESULTS
Worksheet
6 Construct Formulas
for Mathematical
Operations
7 Edit Values in a
Worksheet
8 Format a Worksheet
9 Use the SUM,
AVERAGE, MEDIAN,
MIN, and MAX
Functions
Excel 2016, Windows 10, Microsoft Corporation.
10 Navigate a Workbook
and Rename
Worksheets
11 Edit and Format
Multiple Worksheets at
the Same Time
12 Create a Summary
Sheet
FIGURE 2.5 Project 2C Invoice
(Project 2C Medical Invoice continues on the next page)
Project 2C: Medical Invoice
|
Healthcare
49
CONTENT-BASED ASSESSMENTS
GO! Make It
Project 2C Medical Invoice (continued)
1 Create a folder in which to store your files for this project called
Healthcare Invoice.
2 From the student files that accompany this text, locate and open the file
e2C_Invoice, and save the file in your Healthcare Invoice folder as
Lastname_Firstname_2C_Invoice. You will modify the workbook to match the
worksheets shown in Figures 2.5, 2.6, and 2.7.
3 Group Sheet1, Sheet2, Sheet3, and Sheet4 to simultaneously edit the group of sheets
as follows:
• In the footer, insert the codes for the file name and the sheet name.
• Set the orientation to Landscape.
• Set the top margin to 1", the left and right margins to .45", the bottom margin
to .75", and the worksheet to center horizontally on the printed page to match
Figure 2.5.
• Enter a function to calculate the total number of items ordered.
• Enter a function to calculate the total number of items shipped.
• Enter a formula to calculate the total not shipped. (Subtract the amount ordered
from the amount shipped.)
• Enter and fill a formula to calculate the amount for each item. (Multiply the
number shipped by the unit price.)
• Enter a function to calculate the subtotal.
• Enter a formula to calculate the local tax, referencing the cell with the rate.
• Enter a formula to calculate the state tax, referencing the cell with the rate.
• Enter a formula to calculate the total.
• Enter text SOLD TO and SOLD BY and format text orientation and cell merging
to match Figure 2.5.
• Apply borders and shading to match Figure 2.5.
• Format the cell alignment and numbers to match Figure 2.5.
• Ungroup the worksheets when done.
• Insert e2C_ALLMED_Logo on each sheet to match Figure 2.5.
4 Rename the worksheet tabs for each sheet.
• Rename Sheet1 Jan.
• Rename Sheet2 Feb.
• Rename Sheet3 Mar.
• Rename Sheet4 Apr.
• Rename Sheet5 Summary.
(Project 2C Medical Invoice continues on the next page)
50
Healthcare
|
Chapter 2: DISCIPLINE SPECIFIC PROJECTS
CONTENT-BASED ASSESSMENTS
2
Project 2C Medical Invoice (continued)
Excel 2016, Windows 10, Microsoft Corporation.
HEALTHCARE
GO! Make It
FIGURE 2.6 Project 2C Invoice
5
Complete the Summary sheet to match Figure 2.6.
• In the footer, insert the code for the file name and the code for the sheet name.
• Set the worksheet to center horizontally on the printed page.
• Enter formulas, referencing the cells with the number of items shipped for each
month.
• Enter formulas, referencing the cells with the invoice total amounts for each
month.
• Apply borders and shading, merge and center, bold, size columns, and format the
cells to match Figure 2.6.
(Project 2C Medical Invoice continues on the next page)
Project 2C: Medical Invoice
|
Healthcare
51
CONTENT-BASED ASSESSMENTS
Project 2C Medical Invoice (continued)
Excel 2016, Windows 10, Microsoft Corporation.
GO! Make It
FIGURE 2.7 Project 2C Invoice
6
Create a chart.
• Create a clustered column chart showing the invoice amount for each month.
• Move the chart to a new chart sheet named Summary Chart.
• Format the chart to match Figure 2.7.
• In the footer, insert the codes for the file name and the sheet name.
• Move the Summary Chart worksheet so that it is after (to the right of) the
Summary worksheet.
7 Check the sheets for spelling and grammar errors, and correct any errors you find.
Save the workbook, and submit it as directed by your instructor.
END | You have completed Project 2C
52
Healthcare
|
Chapter 2: DISCIPLINE SPECIFIC PROJECTS
OUTCOMES-BASED ASSESSMENTS
Worksheet
2 Construct and Copy
Formulas and Use the
SUM Function
3 Format Cells with
Merge & Center and
Cell Styles
4 Check Spelling in a
Worksheet
5 Construct Formulas
for Mathematical
Operations
6 Format a Worksheet
7 Use IF Functions and
Apply Conditional
Formatting
8 Navigate a Workbook
and Rename
Worksheets
9 Edit and Format
Multiple Worksheets at
the Same Time
10 Create a Summary
Sheet
11 Chart Data with a Pie
Chart
12 Format a Pie Chart
GO! Think
2
Project 2D Medical Supplies Order
HEALTHCARE
Apply skills from
these objectives:
1 Enter Data in a
PROJECT FILES
For Project 2D, you will need the following file:
e2D_Medical_Supply_Orders
You will save your workbook as:
Lastname_Firstname_2D_Medical_Supply_Orders
One of your duties at Spring Pediatric Group is to keep track of medical supplies for
the entire office and order them on a regular basis. You have started to create a workbook
that contains a worksheet for each supplier and a summary worksheet to keep track of the
total inventory value on hand. You will calculate the value of current inventory and enter
an IF function to alert you when you need to reorder a particular item.
1 Create a folder in which to save your files for this project called Medical Supply
Orders.
2 Open the file e2D_Medical_Supply_Orders, and save it in your Medical Supply
Orders folder as Lastname_Firstname_2D_Medical_Supply_Orders.
3 Group Sheet1, Sheet2, Sheet3, and Sheet4, and then modify the grouped sheets
simultaneously as follows:
• In the header, enter the text Supply Ordering and Tracking. In the footer, insert
codes for the file name and sheet name.
• Change the orientation to Landscape.
• Format the column headings in row 8, setting fill color, bold, alignment,
wrapping, and row height.
• Format the title row using merge and center, fill color, increased font size, and
font color.
• In rows 3, 4, and 5, apply a fill color to the cells containing the supplier name,
address, supplier number, and purchasing department information. Apply bold to
the text in those three rows.
• Enter and fill a formula to calculate the inventory value for each item, referencing
the cells with unit cost and quantity in stock. Only fill for those rows with
supplies. If additional supplies are later added to a sheet, the formula may then be
filled down further.
• Enter a function to total the inventory value. Format and border cell appropriately.
• In the Order Alert column, enter and fill an IF function to display the text ORDER
when the Qty in Stock value is less than five. This will alert you to order more of
each item when your current inventory falls below five. Only fill for those rows
with supplies. If additional supplies are later added to a sheet, the formula may
then be filled down further.
• Format using appropriate number formats, alignments, and borders.
• If necessary, adjust column widths so that each worksheet fits on one page.
• Ungroup the sheets.
4 Rename the worksheet tabs with the names of the suppliers.
(Project 2D Medical Supplies Order continues on the next page)
Project 2D: Medical Supplies Order
|
Healthcare
53
OUTCOMES-BASED ASSESSMENTS
GO! Think
Project 2D Medical Supplies Orde...
Purchase answer to see full
attachment