Integrated Business Projects (Book with CD-ROM)

by Olinzock, Anthony A.

• ISBN13: 9780538727617
• ISBN10: 0538727616
• Edition: 2nd
• Format: Hardcover
• Copyright: 2004-03-26
• Publisher: Cengage Learning

Summary

Integrated Business Projects is a business simulation designed to help reinforce and build software skills, improve Internet skills, and develop teamwork and critical-thinking skills. Students will work as an administrative assistant at Star River Adventures, a company that provides whitewater rafting excursions and other outdoor adventures. Students will learn about the operation of a small business as he/she works in various departments and for the owner of the company. Integrated Business Projects is designed as a complete course, but may be used to complement and enhance technology courses.

Table of Contents

Preface	v
Directory of Applications	xxiii
Introduction	1	(8)
Part 1 Marketing and Sales	9	(104)
Preparing Marketing and Administrative Documents	10	(16)
Create Folders and Prepare Letters	11	(3)
Answer Donation Request Letter	11	(2)
Prepare Discount Request Letter	13	(1)
Challenge: Research Address Formats	13	(1)
Format Reading List	14	(2)
Challenge: Internet Research for Articles	14	(2)
Create Petty Cash Table	16	(2)
Thinking Critically	17	(1)
Use Desktop Publishing for Stickers and Thank-You Note	18	(2)
Format Labels for Stickers	18	(1)
Design Thank-You Note	19	(1)
Prepare Section of Policy Manual	20	(4)
Research River Classifications	24	(1)
Prepare Injury Follow-up Form	25	(1)
Creating Personnel Documents	26	(21)
Create Organization Chart	27	(1)
Prepare Job Descriptions	28	(4)
Bus Driver Job Description	28	(1)
Administrative Assistant Job Description	28	(3)
Reservationist Job Description	31	(1)
Create Name Cards	32	(1)
Prepare Information Sheet	33	(2)
Continue Work on Manual	35	(6)
Thinking Critically	35	(6)
Prepare Guide Information	41	(5)
Guide Application	41	(1)
Guide Regulations	41	(5)
Research Topics Related to Rafting	46	(1)
Preparing Administrative Documents	47	(21)
Create List of Food Service Options	48	(3)
Create Meal Packages Brochure	48	(1)
Thinking Critically	48	(2)
Create Meal Packages Form	50	(1)
Complete Meals Form	50	(1)
Prepare Agenda and Minutes	51	(4)
Key Agenda for Meeting	51	(1)
Create Agenda for Mr. Newland	51	(2)
Create Minutes	53	(1)
Challenge: Create WV Scouts Meeting Agendas	54	(1)
Produce Rafting Checklists	55	(4)
Prepare Trip Checklist	55	(1)
Create Sign-up Sheet	56	(1)
Job 3-4 Generate Employee List and Directory	57	(1)
Create Employee Phone List	57	(1)
Create Directory	58	(1)
Challenge: Create Directory Booklet	58	(1)
Create Marketing Materials for WV Scouts	59	(2)
Create Data Source Table	59	(1)
Prepare Letter for Merge	59	(1)
Create Mailing Labels	60	(1)
Continue Work on Manual	61	(7)
Creating Materials to Promote the Company	68	(14)
Prepare Fax Cover Sheet, Stationary, and Notepads	69	(3)
Create a Fax Cover Sheet Template	69	(1)
Create a Letterhead Using Merge	70	(1)
Design a Notepad Using a Watermark and Merge	71	(1)
Create Printed, Onscreen, and Online Forms	72	(3)
Create Bookmarks	72	(1)
Create Information Request	73	(1)
Create a Word Form	73	(1)
Challenge: Web Form	74	(1)
Create Fax and Presentation	75	(1)
Create a Fax Using a Template	75	(1)
Create a Presentation from a Word Outline	75	(1)
Create Three-Column Brochure	76	(3)
Thinking Critically	78	(1)
Complete Basic Work on Manual	79	(3)
Preparing Advertising Materials Using Desktop Publishing	82	(18)
Design Gift Certificates	83	(2)
Create General Gift Certificates	83	(1)
Record Certificates Sales	83	(1)
Create Certificates for WV Scouts	84	(1)
Prepare Itineraries	85	(2)
Thinking Critically	85	(2)
Create Newsletter for Print	87	(6)
Prepare Newsletter Page 1	87	(3)
Prepare Newsletter Page 2	90	(2)
Challenge: Prepare April Newsletter	92	(1)
Produce Online Newsletter	93	(2)
Prepare Marketing Brochure	95	(5)
Create Styles for Brochure	95	(1)
Create Title Page	95	(1)
Create Brochure Pages 2 and 3	96	(3)
Challenge: Prepare Brochure Page 4	99	(1)
Creating Training Presentations	100	(13)
Update Existing Presentation	101	(2)
Create and Change Slides	101	(1)
Create an Illustration	102	(1)
Prepare to Present Slide Show	103	(3)
Practice Presenting	103	(1)
Enhance a Presentation	103	(2)
Create Handouts	105	(1)
Create Design Template	106	(2)
Thinking Critically	107	(1)
Edit and Format Presentation	108	(3)
Check Style and Spelling	108	(1)
Edit and Add Slides	109	(1)
Edit Notes Master and Print	109	(1)
Challenge: Create Team Presentation	110	(1)
Create Presentation Using a Wizard	111	(2)
Create Training Presentation	111	(1)
Save Presentation as Web Page	112	(1)
Challenge: Create Hyperlinks to Web Sites	112	(1)
Part 2 Finance and Accounting	113	(100)
Managing Payroll Records	114	(17)
Create Payroll Worksheet for Salaried Employees	115	(7)
Challenge: Use VLOOKUP Formula	120	(1)
Challenge: Learn about Income and Payroll Taxes Online	121	(1)
Thinking Critically	121	(1)
Update Payroll Workbook	122	(1)
Create Payroll Worksheet for Hourly Employees	123	(4)
Change Data in Locked Cells	127	(1)
Add Records and Sort Lists	128	(1)
Create Quarterly Summary Report	129	(2)
Challenge: Create Memo with Worksheet	130	(1)
Thinking Critically	130	(1)
Managing Budgets	131	(12)
Create Budget Worksheet	132	(4)
Update Owner Budget	136	(1)
Challenge: Custom Footer	136	(1)
Copy and Update Budget Sheets	137	(1)
Link Worksheets and Prepare Report (Challenge Job)	138	(2)
Thinking Critically	139	(1)
Create Chart	140	(1)
Prepare Report	141	(2)
Managing Business Travel Documents	143	(18)
Create Request for Travel Template	144	(4)
Process Travel Requests	148	(2)
Travel Request for Carr	148	(1)
Travel Requests for Jackson and Inez	149	(1)
Challenge: Research Travel Options	149	(1)
Create Rafting Competition Presentation	150	(6)
Event Application	150	(2)
Event Presentation	152	(3)
Challenge: Create Application Web Page	155	(1)
Create Expense Report Template	156	(3)
Thinking Critically	158	(1)
Process Travel Expense Report	159	(1)
Correct Expense Report and Prepare Memo	160	(1)
Determining Prices for Trip Packages	161	(12)
Create Trip Package Cost Worksheet	162	(2)
Price Trips Using Goal Seek	164	(2)
Create Profit Margin Report	166	(1)
Work with Scenarios	167	(2)
Prepare Multimedia Presentation	169	(2)
Challenge: Add Link to a Rafting Video	170	(1)
Alphabetize and Filter Lists	171	(2)
Sort the List	171	(1)
Filter the List	171	(1)
Challenge: Filter Using Wild Cards	172	(1)
Performing Statistical Analyses	173	(14)
Design Customer Evaluation Form	174	(2)
Create Data Entry Worksheet	176	(2)
Analyze Feedback Data	178	(2)
Refine and Expand Data Analyses	180	(2)
Add Conditional Formatting and Create Charts	182	(3)
Create Guide Evaluation Sheets	182	(1)
Create Guide Evaluation Chart	182	(1)
Create Average Responses Chart	183	(1)
Thinking Critically	184	(1)
Create Integrated Report	185	(2)
Challenge: Create Correlations Memo	185	(2)
Preparing Financial Documents	187	(14)
Create Balance Sheet Worksheet	188	(3)
Add Graphic and Macro to Template	191	(1)
Create May Balance Sheet	191	(1)
Edit a Template	191	(1)
Access Financial Documents from Web Pages	192	(2)
Create June Balance Sheet	192	(1)
Create Web Page and Email with Link	192	(1)
Challenge: Research Financial Documents on the Web	193	(1)
Create Income Statement Worksheet	194	(3)
Create Second-Quarter Income Statement	194	(2)
Print Ranges and Create a Template	196	(1)
Complete First-Quarter Income Statement	197	(1)
Create and Format Charts	198	(3)
Create Balance Sheet Charts	198	(1)
Create Income Statement Charts	199	(1)
Thinking Critically	200	(1)
Creating Presentations for July 4th Extravaganza	201	(12)
Create July 4th Extravaganza Presentation	202	(2)
Create Registration Presentation	204	(2)
Create Slides	204	(1)
Complete Registration Form	204	(1)
Record Registration Information	205	(1)
Create Events Presentation	206	(1)
Create Clothing Presentation	207	(1)
Create Forms Presentation and Document	208	(2)
Combine Presentations and Create Web File	210	(3)
Insert Slides and Add Navigation Buttons	210	(1)
Create Web File	211	(1)
Thinking Critically	212	(1)
Challenge: Use Pack and Go	212	(1)
Part 3 Operations	213	(86)
Managing Guides and Their Certifications	214	(13)
Edit the Guide Roster Table	215	(3)
Edit Data and Add Fields	215	(1)
Assign a Primary Key	216	(1)
Sort Records	217	(1)
Thinking Critically	217	(1)
Automate Certifications Tracking	218	(4)
Create a Guide Certifications Table	218	(1)
Create a Form and Enter Data	219	(1)
Thinking Critically	220	(1)
Define Relationships	221	(1)
Run Queries and Print Reports	222	(2)
Run and Print Queries	222	(1)
Run and Print a Report	222	(1)
Update Certifications Table	222	(1)
Thinking Critically	223	(1)
Create Queries and Reports	224	(1)
Merge Data with Word Document	225	(2)
Challenge: Research American Red Cross	226	(1)
Thinking Critically	226	(1)
Managing Equipment	227	(14)
Create Equipment Table	228	(2)
Design Equipment Table	228	(1)
Thinking Critically	228	(1)
Create Equipment Table	229	(1)
Challenge: Find Clip Art on the Internet	229	(1)
Create Validity Checks	230	(1)
Create Equipment Data Entry Form	231	(2)
Create a Form	231	(1)
Enter Data	232	(1)
Create Supplier Roster Table	233	(2)
Thinking Critically	234	(1)
Create Supplier Roster Data Entry Form	235	(3)
Create a Data Entry Form	235	(1)
Create a Validation Rule with Referential Integrity	236	(1)
Thinking Critically	237	(1)
Query Equipment and Supplier Tables	238	(3)
Query All Records	238	(1)
Query with Criteria/Conditions	238	(1)
Thinking Critically	239	(1)
Queries with Criteria, AND, and OR	239	(1)
Challenge: Create Queries with Calculated Fields	240	(1)
Managing an Off-Season Speaking Schedule	241	(16)
Create Database Using the Database Wizard	242	(3)
Create a New Database	242	(1)
Modify the Switchboard Form	243	(2)
Customize Database	245	(2)
Review the Database Relationships	245	(1)
Thinking Critically	246	(1)
Delete Reports and Update the Switchboard	246	(1)
Populate Events Management Tables	247	(5)
Enter Data Using a Switchboard Form	247	(1)
Export Data and Link Tables	248	(1)
Enter Data in Datasheet View	249	(1)
Import Data from Excel	250	(1)
Populate the Registration Table	250	(1)
Challenge: Modify Report Design	250	(1)
Add Records Using an AutoForm	251	(1)
Create Events Management Reports	252	(3)
Create a Report and Save in HTML Format	252	(1)
Create a Report with Grouping	252	(3)
Create Multimedia Presentation	255	(2)
Create a Presentation	255	(1)
Modify a Presentation	256	(1)
Managing Information Requests	257	(16)
Manage Prospective Client Data	258	(4)
Create Prospective Client Table	258	(1)
Create Client Data Entry Form	259	(1)
Find, Replace, and Edit Client Data	260	(2)
Answer Prospective Client Requests	262	(3)
Create a Data Access Page	262	(1)
Answer Client Requests	263	(2)
Create Client Tracking System	265	(4)
Create a Prospective Client Trip Table	265	(1)
Create a Subform	266	(2)
Thinking Critically	268	(1)
Answer Management Requests	269	(3)
Create Queries	269	(1)
Create Reports	270	(2)
Create River Statistics Database	272	(1)
Challenge: Research River Data	272	(1)
Creating Graphics in Fireworks MX	273	(12)
Create Image with Animated Text	274	(2)
Create JPEG Image	276	(4)
Create a Money Image	276	(1)
Create a Handbag Image	276	(1)
Create a Camera Image	277	(1)
Add a Curved Text Line	278	(2)
Create Vector Images	280	(2)
Thinking Critically	281	(1)
Challenge: Create Alternate Image	281	(1)
Feather and Crop Image	282	(1)
Work with Sound, Voice, and Video Files	283	(1)
Challenge: Find or Create Video for Presentation	283	(1)
Add Images and Sounds to Presentation	284	(1)
Creating an Intranet with FrontPage	285	(14)
Update Intranet Structure	286	(2)
Thinking Critically	287	(1)
Update Intranet Design Elements	288	(2)
Add a Logo Graphic	288	(1)
Change Fonts and Add Images	289	(1)
Evaluate an Intranet Design	289	(1)
Create Image Map and Add Content	290	(1)
Create a Hot Spot	290	(1)
Add Content to an Intranet Page	290	(1)
Create New Pages and Site Navigation	291	(4)
Create Nature Watch Page	291	(1)
Create a Hazards Page	292	(1)
Create a Navigation Bar	293	(2)
Update Links and Apply Theme	295	(2)
Update Email Link	295	(1)
Apply a Theme	295	(1)
Challenge: Modify an Intranet	296	(1)
Publish Intranet	297	(2)
Part 4 Capstone Project	299	(12)
Preparing for a Trade Show	300	(11)
Prepare Requests for Travel	301	(1)
Create Contacts Database	302	(2)
Create a New Database	302	(1)
Create Promotional Letters	302	(1)
Create Queries and Reports	303	(1)
Prepare Brochure	304	(1)
Create Presentations	305	(2)
Create a Kiosk Presentation	305	(1)
Prepare Mr. Newland's Presentation	306	(1)
Challenge: Research Travel Costs	306	(1)
Complete Follow-up Reports	307	(2)
Prepare Follow-up Correspondence	309	(2)
Prepare Memo to Employees	309	(1)
Prepare Letter to Travel Agents	309	(1)
Thinking Critically	310	(1)
Appendix A Reference Guide	311	(16)
Appendix B Computer Concepts	327	(20)
Appendix C Keyboarding Skill Building	347	(12)
Appendix D Directory of Jobs and Files	359	(6)
Appendix E Microsoft Office Certification Correlation	365	(16)
Index	381