3024-Cover, TOC

3024-Cover, TOC - DATA MANAGEMENT FOR INDUSTRIAL ENGINEERS...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
DATA MANAGEMENT FOR INDUSTRIAL ENGINEERS ISE 3024 Course Notes Spring 2010 1 M S 1y 1 2 3 S1 x1 2 2 S2 y3 S2 y5 S3 y8 S4 y2 S4 y9 S2 x2 S3 x3 S4 x4 John P. Shewchuk, Ph.D., P.Eng. Grado Department of Industrial and p Systems Engineering Virginia Tech
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Table of Contents 1. INTRODUCTION 1.1 Data Management and Industrial Engineering 1-1 2 verview of Data Management Approaches - 1 1.2 Overview of Data Management Approaches 1 11 1.2.1 Manual Filing Systems 1-11 1.2.2 Computerized Filing Systems 1-21 1.2.3 Database Systems 1-25 24 eb- ased Database Systems - 9 1.2.4 Web based Database Systems 1 29 2. INTRODUCTION TO SPREADSHEETS 3. WORKING WITH LISTS IN EXCEL 3.1 Using Find and Replace 3-11 3.2 Sorting Data 3-16 3.3 Managing Data with a Data Form 3-21 3.4 Filtering Data 3-31 3.5 Using Subtotals 3-40 6 reating and Using Pivot Tables - 9 3.6 Creating and Using Pivot Tables 3 49 3.7 Self-Study Computer Assignment 3-61 2010 John P. Shewchuk ISE 3024 Course Notes Table of Contents – 1
Background image of page 2
4. WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS IN EXCEL 4.1 Capacity Planning at AnJoCa Corporation 4-3 4.2 Working with Multiple Worksheets 4-11 4.2.1 Entering Formulae In A Worksheet Group 4-15 22 ormatting a Worksheet Group - 6 4.2.2 Formatting a Worksheet Group 4 16 4.2.3 Working with 3-D References 4-18 4.3 Working with Multiple Workbooks 4-23 4.4 Working with Linked Excel Files 4-44 5 elf tudy Computer Assignment 9 4.5 Self-Study Computer Assignment 4-49 5. DESIGNING USER INTERFACES IN EXCEL 5.1 Protecting Workbooks and Worksheets 5-4 5.1.1 Locking and Unlocking Cells 5-5 5.1.2 Protecting a Worksheet 5-9 5.1.3 Protecting a Workbook 5-12 5.2 Data Validation 5-15 5.2.1 Specifying a Data Validation Procedure 5-16 5.2.2 Specifying an Input Message 5-19 5.3 Providing User Controls and Macros 5-21 5.3.1 MPS – Interface Design 5-29 5.3.2 MPS – Implementation 5-30 2010 John P. Shewchuk ISE 3024 Course Notes Table of Contents – 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
5.3.3 Capacity Planning – Interface Design 5-50 5.3.4 Capacity Planning – Implementation 5-55 5.4 Modifying Screen Elements 5-84 5.4.1 Hiding Excel Elements 5-87 5.4.2 Hiding Workbook, Worksheet Elements 5-91 5.5 Testing the Application 5-94 5.6 Self-Study Computer Assignment 5-97 6. IMPORTING DATA INTO EXCEL 6.1 Planned Lead Times at LJ Machining 6-3 6.2 Importing Data from Text Files 6-12 6.2.1 Text File Basics
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/22/2010 for the course ISE 3024 taught by Professor Staff during the Spring '08 term at Virginia Tech.

Page1 / 11

3024-Cover, TOC - DATA MANAGEMENT FOR INDUSTRIAL ENGINEERS...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online