Information Technology 301

ITEC 301: Information Technology Management
Three lecture hours (3).

Prerequisites: ITEC 100

A study of principles, techniques, and tools for the management of information including database management systems, decision support systems, and data warehouses.

 

Detailed Description of Content of Course

A study of principles, techniques, and tools for the management of information including database management systems, decision support systems, and data warehouses. The course is targeted at students that are not in an Information Technology major that may none-the-less have significant roles in the requirements determination, selection, or use of such systems. Topics will include:

  • Data Management
  • Data Warehousing
  • Data Mining
  • Data Retrieval: Report Writers and query facilities
  • Decision Support Systems
  • Systems Architecture (Host-based vs. Client/Server Computing Models)
  • Schema Design
  • Systems Security, Fault Tolerance, Backup and Recovery, Disaster Recovery Planning

Particular focus will be on Database Management Systems as a foundation technology including an overview of end-user technologies that provide more intuitive interfaces to data stores .

 

Detailed Description of the Conduct of the Course

The course is delivered in a lecture/discussion format with demonstration of concepts and applications using multi-media and computer equipment. Classes will occasionally meet in a reserved computer lab. Out-of-class work by students will require hands-on use of information management tools such as spreadsheets, database systems, query facilities, and report writers. Research and analysis of current topics will also be required.

 

Goals and Objectives of the Course

After completing this course, each student will be able to:

  • identify and describe current information technologies in the area of data management
  • be able to construct basic SQL queries
  • be able to use a Query-by-Example Interface
  • show basic proficiency in the use of a report writer
  • demonstrate the ability to move data between applications
  • describe different system architectures available for data based applications and identify when each is appropriate
  • design simple schemas
  • identify technologies that extend the capabilities of database management systems and describe their usefulness.
  • explain the importance of data security, fault tolerance, and backup

 

Assessment Measures

Assessment of the student’s success will be base on the instructor’s selected combination of quizzes, examinations, homework projects, papers, and class presentations.

 

Other Course Information

Requires Multi-media classroom and occasional reservation of lab.

 

Review and Approval

Date Action Approval
March 2006 Updated Robert Phillips, Acting Chair