Amazon no longer offers textbook rentals. We do!

Integrated Business Projects (Book with CD-ROM)

by: Olinzock, Anthony A.

Integrated Business Projects (Book with CD-ROM)

by: Olinzock, Anthony A.

ISBN 13:
9780538727617
ISBN 10:
0538727616
Edition: 2nd
Format: Hardcover
Copyright: 03/26/2004
Publisher: Cengage Learning
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

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.

Preface

Directory of Applications

xxiii

Introduction

(8)

Part 1 Marketing and Sales

(104)

Preparing Marketing and Administrative Documents

(16)

Create Folders and Prepare Letters

(3)

Answer Donation Request Letter

(2)

Prepare Discount Request Letter

(1)

Challenge: Research Address Formats

(1)

Format Reading List

(2)

Challenge: Internet Research for Articles

(2)

Create Petty Cash Table

(2)

Thinking Critically

(1)

Use Desktop Publishing for Stickers and Thank-You Note

(2)

Format Labels for Stickers

(1)

Design Thank-You Note

(1)

Prepare Section of Policy Manual

(4)

Research River Classifications

(1)

Prepare Injury Follow-up Form

(1)

Creating Personnel Documents

(21)

Create Organization Chart

(1)

Prepare Job Descriptions

(4)

Bus Driver Job Description

(1)

Administrative Assistant Job Description

(3)

Reservationist Job Description

(1)

Create Name Cards

(1)

Prepare Information Sheet

(2)

Continue Work on Manual

(6)

Thinking Critically

(6)

Prepare Guide Information

(5)

Guide Application

(1)

Guide Regulations

(5)

Research Topics Related to Rafting

(1)

Preparing Administrative Documents

(21)

Create List of Food Service Options

(3)

Create Meal Packages Brochure

(1)

Thinking Critically

(2)

Create Meal Packages Form

(1)

Complete Meals Form

(1)

Prepare Agenda and Minutes

(4)

Key Agenda for Meeting

(1)

Create Agenda for Mr. Newland

(2)

Create Minutes

(1)

Challenge: Create WV Scouts Meeting Agendas

(1)

Produce Rafting Checklists

(4)

Prepare Trip Checklist

(1)

Create Sign-up Sheet

(1)

Job 3-4 Generate Employee List and Directory

(1)

Create Employee Phone List

(1)

Create Directory

(1)

Challenge: Create Directory Booklet

(1)

Create Marketing Materials for WV Scouts

(2)

Create Data Source Table

(1)

Prepare Letter for Merge

(1)

Create Mailing Labels

(1)

Continue Work on Manual

(7)

Creating Materials to Promote the Company

(14)

Prepare Fax Cover Sheet, Stationary, and Notepads

(3)

Create a Fax Cover Sheet Template

(1)

Create a Letterhead Using Merge

(1)

Design a Notepad Using a Watermark and Merge

(1)

Create Printed, Onscreen, and Online Forms

(3)

Create Bookmarks

(1)

Create Information Request

(1)

Create a Word Form

(1)

Challenge: Web Form

(1)

Create Fax and Presentation

(1)

Create a Fax Using a Template

(1)

Create a Presentation from a Word Outline

(1)

Create Three-Column Brochure

(3)

Thinking Critically

(1)

Complete Basic Work on Manual

(3)

Preparing Advertising Materials Using Desktop Publishing

(18)

Design Gift Certificates

(2)

Create General Gift Certificates

(1)

Record Certificates Sales

(1)

Create Certificates for WV Scouts

(1)

Prepare Itineraries

(2)

Thinking Critically

(2)

Create Newsletter for Print

(6)

Prepare Newsletter Page 1

(3)

Prepare Newsletter Page 2

(2)

Challenge: Prepare April Newsletter

(1)

Produce Online Newsletter

(2)

Prepare Marketing Brochure

(5)

Create Styles for Brochure

(1)

Create Title Page

(1)

Create Brochure Pages 2 and 3

(3)

Challenge: Prepare Brochure Page 4

(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

Amazon no longer offers textbook rentals. We do!

Integrated Business Projects (Book with CD-ROM)

Integrated Business Projects (Book with CD-ROM)

9780538727617

0538727616

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Integrated Business Projects (Book with CD-ROM)

Integrated Business Projects (Book with CD-ROM)

9780538727617

0538727616

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products