Information Technology

Introduction to PC Productivity Tools
IT 4114 / 3 q.h.

June 25 - July 21
Online

The information age has brought with it new challenges in terms of collecting, analyzing, and disseminating data and information. To address these issues, students will learn to use the most popular productivity tools such as Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Courseware used is approved by the Microsoft Office User Specialist (MOUS) program. The course is taught in a computer lab and consists of in-class demonstrations by instructors. Students are expected to complete out-of-class hands-on assignments. No prior computer experience is necessary.

(formerly Introduction to PC Software)
Not open to students who have taken MIS 4101, MIS 4102, or MIS 4103 Introduction to Data Processing and Information Systems 1, 2, and 3.


Technology and Information Fluency
IT 4115 / 3 q.h.

July 23 - August 18
Online

Introduces students to the terminology and infrastructure of information technology. The course examines all types of computer systems including the microcomputer or PC. Lectures emphasize information technology as it relates to connectivity, communication, digital convergence, hardware, software, storage, security, and new advances in computing. Students get a broad-based overview of computer programming, systems analysis, digital data and databases, and networking.

(formerly Introduction to Computers and Information Systems)
Not open to students who have taken MIS 4101, MIS 4102, or MIS 4103 Introduction to Data Processing and Information Systems 1, 2, and 3.


PC Database Software
IT 4236 / 3 q.h.

June 25 - August 18
Online

This course focuses on the Microsoft Access database management system. Coursework includes creating, querying, and maintaining a database; creating forms, reports, and combo boxes; using the Web feature to publish to the Internet; creating an application system using macros and Object Linking and Embedding (OLE); and two-way integration of data among applications. SQL and Visual Basic concepts are introduced. The course covers topics in scheduling and contact management using Microsoft Outlook. Courseware used is approved for the Microsoft Office User Specialist (MOUS) program. Content is delivered through lectures, in-class demonstrations, cases, and extensive assignments that apply skills. Not for the first-time personal computer user.

(formerly Advanced PC Software.)
Prerequisite: MIS 4102 Introduction to Data Processing and Information Systems 2 or IT 4114 Introduction to PC Productivity Tools or equivalent.


Internet Essentials
IT 4238 / 3 q.h.

June 25 - July 21
Online

Given today's vast databases and the access capabilities afforded by the Internet, understanding how to filter content properly is crucial to avoiding information overload. Students will cover tools, techniques, and technologies used to connect to the Internet, communicate electronically, and do business online. Topics include authoring, distributing, and browsing technologies; TCP/IP; client-server structures; Web/HTTP/HTML; Internet privacy and security, cookies, and viruses; information retrieval, World Wide Web (WWW), and file transfer protocol (FTP); and Internet transactions such as online banking, buying, and selling. The course is taught in state-of-the-art lab facilities. Students will learn basic HTML programming.


HTML Programming
IT 4239 / 3 q.h.

June 25 - August 18
Online

HTML (Hypertext Markup Language) is used to prepare documents for the World Wide Web. This course is an introduction to HTML that focuses on creating practical, attractive Web pages that function on a variety of browsers. Text formatting, tables, links and lists, images, frames, forms, and other topics are included. Cascading Style Sheets are also introduced.

Prerequisite: IT 4238 Internet Essentials.


Visual Basic.NET
IT 4245 / 3 q.h.

June 25 - August 18
Online

This course introduces the student to Visual Basic.NET, an object-oriented, event-driven language. Students will be able to plan and create their own interactive Windows applications. By the end of the course, students will have learned how to work with controls, write If...Then, Case, Do...Loop, and For...Next statements, as well as manipulate variables, constants, sequential access files, and arrays. GUI design skills are emphasized, as well as creating and printing reports, and accessing information in a database.

Prerequisite: IT 4210 Programming Logic or equivalent experience.


XML Fundamentals
IT 4247 / 3 q.h.

June 25 - August 18
Online

Learn to write Extensible Markup Language (XML) documents for the Web. After writing and viewing simple XML documents, custom markup tags and formatting are added using Cascading Style Sheets (CSS) and Extensible Style Language (XSL) style sheets. Students construct a Document Type Definition (DTD) and use it to validate their documents. XML documents are transformed into other formats (such as HTML) for viewing on systems that are not XML-capable. Finally, the course looks at other XML topics such as namespaces, XLinks, and XPointers. Students should be able to write a basic HTML page using a text editor and copy the page to a server.

Prerequisite: IT 4239 HTML Programming.


JavaScript Essentials
IT 4285 / 3 q.h.

June 25 - August 18
Online

In this course, students will learn how to use JavaScript to add dynamic capabilities to Web pages. Topics include image manipulation (rollover effects, random images), form processing and validation techniques, date-time techniques, DHTML Web page development, use of cookies in Web pages, and manipulating plug-ins. Students should have experience developing with HTML.

Prerequisite: IT 4239 HTML Programming.


Java Programming
IT 4286 / 3 q.h.

June 25 - July 21
Online

Students will examine object-oriented components and characteristics including classes, inheritance, and polymorphism. In addition, students will learn how to write, debug, and execute Java programs and how to create Java applets and applications. Practice exercises will make use of Java's Abstract Window Toolkit (AWT). Other techniques covered include threads, multimedia, animation, audio, exception handling, images, Java IO, sequential files, random access files, networking, utility classes, hashtables, string tokenizer, and operations on bits.


Advanced Java Programming
IT 4287 / 3 q.h.

July 23 - August 18
Online

This course will focus on applets, AWT, graphics, event handling, images, Java IO, sequential files, random access files, networking, utility classes, hashtables, string tokenizer, and operations on bits.

Prerequisite: IT 4286 Java Programming.


Database-Driven Web Design 1
IT 4313 / 3 q.h.

June 25 - July 21
Online

This course is for those who want to design websites that interact with relational databases. The open source language PHP is used to create web pages that query, update, and manage MySQL databases. The emphasis is on using basic PHP techniques (loops, conditionals, built-in functions) to interact with existing relational databases. All software used in the course is open source, and runs on a variety of platforms.

(formerly Web Design with PHP and MySQL Part 1)
Prerequisites: IT 4239 HTML Programming and some programming experience.


Database-Driven Web Design 2
IT 4314 / 3 q.h.

July 23 - August 18
Online

This course is for those who want to design websites that interact with relational databases. The open source language PHP is used to create web pages that query, update, and manage MySQL databases. The emphasis is on using basic PHP techniques (loops, conditionals, built-in functions) to interact with existing relational databases. All software used in the course is open source, and runs on a variety of platforms.

(formerly Web Design with PHP and MySQL Part 2)
Prerequisite: IT 4313 Database-Driven Web Design 1.


Database Management Systems
IT 4342 / 3 q.h.

June 25 - August 18
Online

Focuses on designing a database for use in a relational database management system. Includes creating queries, linking files, cross-indexing, designing forms and reports, and other advanced database techniques. Introduces the entity-relationship model. Requires implementing an application program.

(formerly Advanced Database)
Prerequisite: IT 4236 PC Database Software.


Web Services Development
IT 4353 / 3 q.h.

June 25 - August 18
Online

Active Server Pages (ASP) is a technology that allows databases to be incorporated into Web pages. In this course, VBScript and ADO (Active Data Object) techniques are used to connect to, update, and select information from databases, which is then displayed on customized, dynamic Web pages. Topics include installing and configuring ASP and ADO components, recordsets, using SQL to insert and modify data, using cookies, and the use of stored procedures. Students should be familiar with HTML and relational databases and should have some exposure to a programming language.
(formerly Active Server Pages)

Prerequisite: IT 4342 Advanced Database.