ISE 3024 Data Management for IEs, Spring 2010
1 of 5
Dr. John P. Shewchuk, P.Eng.
Associate Professor, ISE
519D Whittemore Hall (231-3226, firstname.lastname@example.org)
Office hours: M 2-4 PM, W 10 AM - noon
Xin Zeng (214 Durham Hall, email@example.com)
Office hours: M 12:30-1:30 PM, T 9-10 AM, W 1-3 PM
AM section (CRN 13734):
T R 11:00 AM – 12:15 PM
PM section (CRN 13731):
T R 12:30 PM – 1:45 PM
EF 2314, ISE 2404.
Investigation of data management – how data is modeled, acquired, stored, and
utilized – for problem solving in Industrial Engineering.
Manual methods, computerized
spreadsheets, databases, and Web-based databases are explored.
include list manipulation, working with multiple spreadsheets and files, importing data,
and developing effective spreadsheet applications.
Database topics include Entity-
Relationship modeling, relational schema, normalization, and SQL.
and implementation of Web-based databases, via both static and dynamic pages.
Finally, the data management application life cycle (DMALC) is explored.
Having successfully completed this course, you will be able to:
• Select the most appropriate data management approach (manual, spreadsheet,
database, or Web-based database) for a given IE problem.
• Work with multiple Excel worksheets and workbooks simultaneously.
• Import text, database, and Web-based data into Excel.
• Use macros, user controls, data validation, protection, and other elements to
develop effective Excel applications for IE problems.
• Analyze IE problems to identify the pertinent objects, attributes, data types, and
relationships needed for designing a database.
• Design relational databases and improve existing relational databases (normalization).
• Implement relational databases for typical IE problems using MS Access and SQL.
• Develop rudimentary Web-based databases for typical IE problems.
ISE 3024 Data Management for Industrial Engineers