[academia_course_sections title=”Information Technology Undergraduate Certificate”][academia_course_lesson icon_type=”fontawesome” icon_fontawesome=”fa fa-file-text” badge=”lecture” title=”ITC 3001: Personal Computer Fundamentals” icon_tool_tip=”TEXT” estimate_time=”3 HOURS”]

Description

Fundamentals of personal computers are examined with an emphasis on current application software. Provides an overview of personal computers, operating systems, and Internet technologies. Includes extensive and valuable hands-on experience using several applications in the Microsoft Office Suite.

Objectives

1. Explain the fundamentals of computer hardware and computer software.
2. Demonstrate fundamental techniques within a word-processing application.
3. Demonstrate fundamental desktop-publishing techniques by designing the layout for a professional file.
4. Perform fundamental data-manipulation techniques.

PreRequisites

None

Textbook(s)

8.91

* Disclaimer: Textbooks listed are based on the last open revision of the course. Prior revisions and future revisions may use different textbooks. To verify textbook information, view the course syllabus or contact the AU Bookstore at bookstore@AU.EDU.GL

[/academia_course_lesson][academia_course_lesson icon_type=”fontawesome” icon_fontawesome=”fa fa-file-text” badge=”lecture” title=”ITC 3450: Introduction to Data Communication” icon_tool_tip=”TEXT” estimate_time=”3 HOURS”]

Description

An examination of data communications fundamentals, including the transmission and reception of data signals, networking and network architecture, and communications protocols. Provides a baseline level of knowledge for success in industry and preparation for networking certifications, including the Network , Microsoft Certified Systems Administrator (MCSA), Microsoft Certified Systems Engineer (MCSE), Certified Novell Administrator (CNA), and Cisco Certified Network Associate (CCNA) designations.

Objectives

1. Differentiate between several data networking standards, including the seven layers of the Open Systems Interconnection (OSI) reference model and the Transmission Control Protocol/Internet Protocol (TCP/IP) stack.
2. Classify common network hardware and utilities used for troubleshooting.
3. Examine the concepts of switching and routing, regarding local area network servers (LANs) and wide area network solutions (WANs).
4. Explain how Microsoft Windows network communication protocols are implemented in a TCP/IP network.
5. Illustrate network diagrams for network topologies.

PreRequisites

1. ITC 3001

Textbook(s)

* Disclaimer: Textbooks listed are based on the last open revision of the course. Prior revisions and future revisions may use different textbooks. To verify textbook information, view the course syllabus or contact the AU Bookstore at bookstore@AU.EDU.GL

[/academia_course_lesson][academia_course_lesson icon_type=”fontawesome” icon_fontawesome=”fa fa-file-text” badge=”lecture” title=”ITC 4010: System Analysis and Design” icon_tool_tip=”TEXT” estimate_time=”3 HOURS”]

Description

Exploration of structured systems analysis and design terminology and techniques. Presents a foundation in systems design and documentation necessary for effective communication and career advancement for all technology professionals.

Objectives

1. Identify Information Technology tools and services that satisfy the needs of various organizational structures.
2. Recognize design methodologies, to include prototyping, development life cycle and structured analysis.
3. Examine the use of data flow diagrams, data dictionary definitions, and Structured English as used in the Information Technology field.
4. Apply techniques of system analysis and design to an information systems problem.
5. Assess the value of information technology when addressing global, national, and local industry needs.

PreRequisites

1. ITC 3001

Textbook(s)

* Disclaimer: Textbooks listed are based on the last open revision of the course. Prior revisions and future revisions may use different textbooks. To verify textbook information, view the course syllabus or contact the AU Bookstore at bookstore@AU.EDU.GL

[/academia_course_lesson][academia_course_lesson icon_type=”fontawesome” icon_fontawesome=”fa fa-file-text” badge=”lecture” title=”ITC 4150: Database Design and Implementation” icon_tool_tip=”TEXT” estimate_time=”3 HOURS”]

Description

A comprehensive coverage of database systems design, development, and implementation. Examines the tools and techniques necessary in creating data models and subsequent database designs. Provides hands-on experience using diagramming tools.

Objectives

1. Examine the relevance and components of relational databases.
2. Create documentation throughout the database development lifecycle.
3. Identify business rules, entities, relationships, and attributes for a specific database scenario.
4. Create a logical and physical database design.
5. Demonstrate database normalization techniques.
6. Utilize Structured Query Language (SQL) to create and interact with a database.
7. Apply solutions to identified database security Issues.

PreRequisites

1. ITC 3001

Textbook(s)

* Disclaimer: Textbooks listed are based on the last open revision of the course. Prior revisions and future revisions may use different textbooks. To verify textbook information, view the course syllabus or contact the AU Bookstore at bookstore@AU.EDU.GL

[/academia_course_lesson][academia_course_lesson icon_type=”fontawesome” icon_fontawesome=”fa fa-file-text” badge=”lecture” title=”ITC 4210: Programming Concepts and Problem Solving” icon_tool_tip=”TEXT” estimate_time=”3 HOURS”]

Description

An introduction to solving computer programming problems using Visual Basic. Includes principles that translate easily to many other modern programming languages. Focuses on user interfaces, program structure, language syntax, and implementation details. Requires Visual Basic.

Objectives

1. Demonstrate the ability to use the fundamental functions within programming software.
2. Utilize a programmer’s problem-solving process toward creating solutions.
3. Develop a user interface for a computer program.
4. Write an expression containing arithmetic operators by declaring variables, declaring constants, and formatting a program’s numeric output.
5. Locate and resolve syntax and logic errors by stepping through the code and by using breakpoints.
6. Write an If…Then…Else statement as an integral part of a computer program.
7. Compose both a nested selection structure and also a multiple-alternative selection structure.
8. Utilize testing methods within a computer program to both verify the program’s functionality and also detect and prevent unwanted user input.
9. Construct a looping condition for a computer program by using an InputBox function, a Do…Loop statement, and an arithmetic assignment operator.
10. Develop a complete computer program for the purpose of solving a problem by determining a control structure, using major functions, and preparing an appropriate user interface.

PreRequisites

1. ITC 4010

Textbook(s)

* Disclaimer: Textbooks listed are based on the last open revision of the course. Prior revisions and future revisions may use different textbooks. To verify textbook information, view the course syllabus or contact the AU Bookstore at bookstore@AU.EDU.GL

[/academia_course_lesson][academia_course_lesson icon_type=”fontawesome” icon_fontawesome=”fa fa-file-text” badge=”lecture” title=”ITC 4230: Programming Concepts and Problem Solving II” icon_tool_tip=”TEXT” estimate_time=”3 HOURS”]

Description

An advanced study of programming-related problem solving using Visual Basic. Covers object-oriented concepts such as classes, reusability, and encapsulation. Requires Microsoft Visual Basic.

Objectives

1. Write the syntax for a computer program to perform advanced loops.
2. Create a sub procedure and a function procedure.
3. Use a two-dimensional array to store, access, and search for elements within a computer program.
4. Utilize structures and sequential-access files as integrated components of a computer program.
5. Perform string-manipulation techniques within a computer program.
6. Connect an application to a Microsoft Access database.
7. Create a new class by using the syntax in Microsoft Visual Basic.
8. Create a Web application by using ASP.NET.

PreRequisites

1. ITC 4210

Textbook(s)

* Disclaimer: Textbooks listed are based on the last open revision of the course. Prior revisions and future revisions may use different textbooks. To verify textbook information, view the course syllabus or contact the AU Bookstore at bookstore@AU.EDU.GL

[/academia_course_lesson][academia_course_lesson icon_type=”fontawesome” icon_fontawesome=”fa fa-file-text” badge=”lecture” title=”ITC 4310: Web Design and Development” icon_tool_tip=”TEXT” estimate_time=”3 HOURS”]

Description

Presents web design principles and techniques coupled with practical experience in the design and creation of websites. Includes coverage of the latest tools, trends, and issues relating to computers and technology.

Objectives

1. Explain the interactive and multimedia elements of a web page.
2. Analyze the phases of the web development life cycle.
3. Demonstrate the use of common web page formatting features.
4. Recommend solutions to compatibility and accessibility issues.
5. Apply web design principles to the design and creation of a website.
6. Examine current trends in website design and development.

PreRequisites

None

Textbook(s)

* Disclaimer: Textbooks listed are based on the last open revision of the course. Prior revisions and future revisions may use different textbooks. To verify textbook information, view the course syllabus or contact the AU Bookstore at bookstore@AU.EDU.GL

[/academia_course_lesson][/academia_course_sections]