|
COURSE DESCRIPTION
Introduction to Information
Processing Systems (0,3) (IME 335)
Required Course
Fall Semester 2007
|
|
2007 - 2008 Catalog Data:
|
Systems engineering
methodology applied to the design of information processing systems
(operating systems, file handling, database management systems,
spreadsheets, etc.) to support engineering decision-making. Prerequisite(s): CS 140, CS 141,
or CS 145 or equivalent and Upper-Division or consent of instructor.
|
|
Textbook(s):
|
For
this course, students will be given 10 specific project assignments. These
assignments will require students to use one or more of the MS Office 2007
Professional software products, so although not required, they should buy
a reference book which covers all the software modules. Office Bible 2007 by Walkenbach, et. Al.,
2007, ISBN 978-0-470-0469-3 is the recommended reference for the first
part of the course and can be Ordered from Amazon.com for about $29.69
new. MS Office Access 2007 Inside
out by Viescas and Conrad 2007, ISBN 0-7356-2325-2 is the reference text
for the second part of the course and will be provided by text book
rental before it is required during the 5th week of the
semester.
|
|
Coordinator:
|
Jacob Van Roekel, Professor of Industrial and
Manufacturing Engineering
|
|
Objectives:
|
Objectives of this
course are to familiarize industrial engineering students with the use of
micro-computers and their application to the solution of industrial
engineering problems. The first 5
weeks of course work will insure computer literacy in operating system,
word processing, web page design, presentations, and spreadsheets. During the remaining nine weeks, the
primary emphasis will be on applying spreadsheets, and database
management systems to industrial engineering problems to include special
file handling and linking of information between software programs. Additional objectives are: to
help students develop their oral and written communications skills
through short reports and presentations during the course.
|
|
Topics and Schedule:
|
1.
Review
of WINDOWS XP Operating System Issues and Student Accounts (1 hour)
2.
Review
of Microsoft Office Enterprise Suite (8 hours)
3.
Spreadsheet
Applications (6 hours)
a.
Command
level and logic structures
b.
Forecasting
Applications
c.
Financial
Applications
d. Matrix Inversion/Multiplication
Applications
4. Logical/Statistical Structures Database
Fundamentals (Access) (15 hours)
5. Special File Handling/Linking Applications
and data transfer techniques from one application to another (2 hours)
6.
Project (12 hours)
|
|
Professional Component:
|
This course introduces design methodologies and
user-centered design to junior-level engineering students. The course is an engineering topics
course with significant engineering design content.
|
|
Course Outcomes:
|
Upon completion of this course students will:
1. Demonstrate effective knowledge and use
of all MicroSoft Office Professional products
2. Be able to develop complex spreadsheet
applications.
- Be able to design a relational
database and develop applications with forms, queries, and reports
using macros, SQL language, event procedures, and expressions.
- Be able to make formal presentations.
|
|
Prepared by:
|
Jacob H. Van Roekel, Professor in Industrial
Engineering
|
|
Date:
|
April 29, 2008
|
|
Program
Educational Objective•Outcome
|
General Course
Outcomes
IME 335 - Introduction to Information
Processing Systems
|
|
|
|
1
|
2
|
3
|
4
|
|
|
1.1
|
|
|
|
|
|
|
1.2
|
|
P
|
P
|
|
|
|
1.3
|
P
|
|
|
|
|
|
1.4
|
|
P
|
P
|
|
|
|
|
|
|
|
|
|
|
2.1
|
|
|
|
|
|
|
2.2
|
|
|
|
|
|
|
2.3
|
|
|
|
|
|
|
2.4
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3.1
|
|
|
|
|
|
|
3.2
|
|
P
|
P
|
|
|
|
3.3
|
|
P
|
P
|
|
|
|
3.4
|
|
|
|
|
|
|
3.5
|
|
|
|
P
|
|
|
|
|
|
|
|
|
|
4.1
|
|
|
|
|
|
|
4.2
|
|
|
|
|
|
|
4.3
|
|
|
|
|
|
|
4.4
|
|
|
|
|
|
|
|
|
|
|
|
|
|
