Information Technology

IT1813Introduction to Data Management3 ch (3C)

This course covers the storage, manipulation, and presentation of data. Examples are drawn from various domains, such as sales, business-related, and scientific data. Two software packages are presented for such propose: MS Excel (concepts including formula, data consolidation, and graphical representation) and MS Access (concepts including table design for data storage, queries in both QBE and SQL format, forms, and report generation). Emphasis is placed on the strengths of each tool, and how to benefit from both by importing data from one tool into the other. Macro programming is introduced, so as to create simple applications within these tools. NOTE: This course may not be taken for credit by Computer Science and Information Sciences students. Credit will not be given for both IT 1803 and IT 1813.