Chapter 3: Simulation Training (Projects A and B)

User Generated

E017

Computer Science

Description

Chapter 3: Simulation Training (Projects A and B). I attached the book everything will be in chapter 3. Starting from Page 71 to 103.

Unformatted Attachment Preview

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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Surname 1
Student
Instructor
Course
Date
Project A

October 21, 2017
Mr. Anderson Cooper
3182 Landways Avenue, Suite 180
Atlanta, AT 15097.

Dear Mr. Cooper:
Recently, there has been a sharp increase in the crime rate in the neighborhood. Some of
these incidents include the High School shootings which left several tens of children dead and
dozens more injured. In response to this, some Landways citizens have proposed the
implementation of a Neighbourhood Watch Program.
The key benefit of the program is that it encourages Neighbours to be each one’s brother’s
keeper and to report any suspicious activity within the surrounding. If this program is
implemented alongside law enforcement authorities, the crime rate that has been way on the
ceiling will eventually come down. The purpose of the program is ensuring people are safe by
reducing the crime rate significantly.
Therefore, you are invited to a Neighbourhood Watch meeting this Sunday 22nd October at
5pm at the local golf club to deliberate on the issue. An officer from the law enforcement
authority shall provide meaningful insights and tips during the meeting. He will also be
taking questions and providing responses to these questions to ensure everyone gets the
concepts right. Make an effort of appearing at the Neighbourhood Watch and coordinate with
the other citizens to see how you can assist in making the neighborhood safe.

Sincerely,

Surname 2

Jacob Juma,
Community Police Director,


Surname 1
Student
Instructor
Course
Date
Project A

October 21, 2017
Mr. Anderson Cooper
3182 Landways Avenue, Suite 180
Atlanta, AT 15097.

Dear Mr. Cooper:
Recently, there has been a sharp increase in the crime rate in the neighbourhood. Some of
these incidents include the High School shootings which left several tens of children dead and
dozens more injured. In response to this, some Landways citizens have proposed
implementation of a Neighbourhood Watch Program.
The key benefit of the program is that it encourages Neighbours to be each one’s brother’s
keeper and reporting any suspicious activity within the surrounding. If this program is
implemented alongside law enforcement authorities, the crime rate that has been way on the
ceiling will eventually come down. The purpose of the program is ensuring people are safe by
reducing the crime rate significantly.
Therefore, you are invited to a Neighbourhood Watch meeting this Sunday 22nd October at
5pm at the local golf club to deliberate on the issue. An officer from the law enforcement
author...


Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags