Exploring Getting Started with Integrated Projects

Dr. Robert T. Grauer Dr. Robert T. Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he has been honored with the Outstanding Teacher Award in the School of Business.  He is the vision behind the Exploring Series, which is about to sell its 3 millionth copy.   Dr. Grauer has written more than 50 books on programming and information systems.  His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels.   Dr. Grauer also has been a consultant to several major corporations including IBM and American Express.  He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.   Judith Scheeren Judith Scheeren is a professor of computer technology at Westmoreland County Community College in Youngwood, Pennsylvania where she received the Outstanding Teacher award.  She holds an M.S.I.S. She holds an M.S. from the University of Pittsburgh and an advanced certificate in online teaching and learning from the University of California at Hayward.  She has several years of experience in the computer industry with Fortune 500 companies.  She has developed and written training materials for custom applications in both the public and private sectors.  She also has written books on desktop publishing.

CONTENTS

 

CASE 1|Integrated Case Study: The Totally Fit

Wellness Center

 

Objectives 1

Totally Fit Revenue Workbook and Chart (Excel) 2

Report to the President (Word and Excel) 3

Presentation to the President (Powerpoint

and Excel) 4

Last-Minute Change (Word, Excel,

and Powerpoint) 5

Importing Data (Access And Excel) 7

A Relational Database (Access) 8

Access Objects: Queries and Reports (Access) 9

Worksheet Tables (Excel) 10

Worksheet Calculations (Excel) 11

Presentation to the Board (Powerpoint

and Excel) 12

Letter to the Board (Word and Excel) 13

Mailing Labels (Access) 14

Create a Home Page (Excel) 15

Submission Checklist (Word) 16

 

CASE 2|Integrated Case Study: Alternate Airways 18

 

Objectives 18

Alternate Airways Revenue Workbook

and Chart (Excel) 19

Report to the President (Word and Excel) 20

Presentation to the President (Powerpoint

and Excel) 21

Last-Minute Change (Word, Excel,

and Powerpoint) 23

Importing Data (Access and Excel) 24

A Relational Database (Access) 25

Access Objects: Queries and Reports (Access) 26

Worksheet Tables (Excel) 27

Worksheet Calculations (Excel) 28

Presentation to the Board (Powerpoint

and Excel) 29

Letter to the Board (Word and Excel) 30

Mailing Labels (Access) 31

Create a Home Page (Excel) 32

Submission Checklist (Word) 33

 

 

CASE 3|Integrated Case Study: University Housing 35

 

Objectives 35

University Housing Revenue Workbook

and Chart (Excel) 36

Report to the Provost (Word and Excel) 37

Presentation to the Provost (Powerpoint

and Excel) 38

Last-Minute Change (Word, Excel, and

Powerpoint) 39

Importing Data (Access and Excel) 41

A Relational Database (Access) 42

Access Objects: Queries and Reports (Access) 43

Worksheet Tables (Excel) 44

Worksheet Calculations (Excel) 45

Presentation to the Trustees (Powerpoint

and Excel) 46

Letter to the Trustees (Word and Excel) 47

Mailing Labels (Access) 48

Create a Home Page (Excel) 49

Submission Checklist (Word) 50

 

INDEX