Prerequisite: A working knowledge of PC applications is required, and some experience using and maintaining PC hardware/software is highly recommended. Note: Textbook required Prepare yourself for the A+ Certification exams. This course focuses on the A+ exam objectives by the Computing Technology Industry Associate (CompTIA) and is designed for those responsible for the installation, upgrade, repair, configuration, and troubleshooting of PC systems hardware and software. Participants will demonstrate their ability to diagnose, maintain, and perform minor repairs on PC systems and peripherals.

Note: Textbook required; flash drive recommended In this basic course, you will use Microsoft Access 2010 to design a simple database, build a new database with related tables, manage data in a table, query a database using different methods, design forms and generate reports.

Prerequisite: Windows for the Desktop or equivalent knowledge Note: Textbook required; flash drive recommended In this course, you will work with Access 2010, a powerful database application to store and retrieve data. You will begin with learning basic database terminology. You will learn the objects used in Access, how to construct tables, use forms to display data, create queries to select data and to format reports for data that is retrieved from the database. You will use the wizards to create different objects. You will learn relationships between tables, primary keys, date formats, and you will be able to link tables to create queries. Begin to acquire skills and knowledge to pass the optional MOS exam in Access.

Prerequisite: Windows for the Desktop or equivalent knowledge; Access- One Day or equivalent knowledge Note: Textbook required; flash drive required In the first course in this series, Access: One Day, participants gained all the basic skills needed to work Access tables, relationships, queries, forms, and reports. In this intermediate level course participants will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.

Prerequisite: Windows for the desktop or equivalent knowledge Note: Textbook required; flash drive recommended Learn the commonalities of the Microsoft Office Program and practice using the basic features of Windows Microsoft Word, Excel, and PowerPoint programs.

Note: Textbook required This course discusses computer terminology, hardware, software, operating systems, and information systems relating to the business environment. The main focus of this course is on business application of software, including word processing, spreadsheets, databases, presentation graphics, and business-oriented utilization of the Internet. (BCIS 1305)

Prerequisite: Cisco Exploration 1 Note: Textbook required Learn architecture, operation of routers, and routing protocols; analyze, configure, verify, and troubleshoot RIPv1, RIPv2, EIGRP, and OSPF. (ITCC 1404)

Prerequisite: ITSC 1305 or department chair approval Note: Textbook required This course introduces the architecture, structure, functions, components, and models of the Internet. It describes the use of OSI and TCP layered models to examine the nature and roles of protocols and services at the applications, network, data link, and physical layers. It covers the principles and structure of IP addressing and the fundamentals of Ethernet concepts, media, and operations. The students will build simple LAN topologies by applying basic principles of cabling; performing basic configurations of network devices, including routers and switches; and implementing IP addressing schemes. (ITCC 1401)

Note: Textbook required; flash drive recommended This inviting introductory computer literacy course, covers computer concepts in a highly visual way. Understand the key principles you need to know about hardware, operating systems, productivity software, networks, and the Internet. Information is geared toward the end-user, focusing on partial certification level knowledge required for every worker in today´s wired world and for passing one of the three IC3 certification exams.

Learn to use a computer in a business environment. Begin with the keyboard; learning typing skills. Then get an introduction to the computer hardware. Learn how to use the Windows operating system. Gain a basic understanding of the most popular business applications - MS Word, MS Excel and PowerPoint. Additionally, learn to use the internet and email. All of these skills prepare you to take the optional IC3 certification exam.

Prerequisite: Windows for the Desktop or equivalent knowledge Note: Textbook required; flash drive recommended In this course, you will work with Excel 2010, a powerful spreadsheet application. You will begin by learning to use the data analysis features. Then you will discover the secrets to protecting and sharing your data. By the end of this course, you will know how to work smarter in Excel by using macros for repetitive tasks and by moving data from source to source. You will have gained the necessary skills required to pass the MOS Core exam.

Prerequisite: Windows for the Desktop or equivalent knowledge Note: Textbook required; flash drive recommended In this course, you will work with Excel 2010, a powerful spreadsheet application. You will begin with preparing and formatting techniques. You learn how to insert texts and formulas into cells. You will use simple functions. You will construct charts for you data. You will learn formatting and printing selected ranges. You will learn about workbooks and moving data between workbooks. Begin to acquire skills and knowledge needed to pass the optional MOS Core exam in Excel.

Prerequisite: Excel Basic Skills or equivalent knowledge Note: Textbook required; flash drive recommended In this course, you will work with Excel 2010, a powerful spreadsheet application. You will begin with advanced formatting techniques. Then you will discover the eleven categories of the preprogrammed advanced functions and complex formulas. By the end of this course, you will be well prepared to not only calculate complex data but to present it graphically in PivotTable reports and PivotCharts. You will gain partial skills necessary to pass the MOS Core exam.

Note: Textbook required; flash drive recommended In this course you will create and edit basic Microsoft Excel 2010 worksheets and workbooks. You will learn to create basic formulas and perform basic calculations.

Prerequisite: Excel One Day Intermediate or equivalent knowledge Note: Textbook required; flash drive required In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Prerequisite: Excel One Day or equivalent knowledge Note: Textbook required; flash drive recommended In the first course in this series, Excel - One Day, students gained all the basic skills needed to create, edit, format, and print basic spreadsheets. This continuation provides the next step: to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, students will use Microsoft Office Excel to streamline and enhance spreadsheets with templates, charts, graphics, and formulas.

Prerequisite: ITSC 1305 or Department Chair Approval Note: Textbook required Learn networking essential concepts and implementation; network protocols; transmission media; hardware and software; how to connect servers and clients in a network. (ITNW 1325)

Prerequisite: Basic computer skills and knowledge of Windows Note: Textbook required Learn to create web pages using Hypertext markup language (HTML) and Cascading Style Sheets (CSS). Students will plan content and structure of a basic web page. Topics will include tables, formatting, images and colors.

Prerequisite: ITNW 1308 or ITCC 1401 or department chair approval Note: Textbook required; flash drive recommended This course includes topics such as implementing, administering, and troubleshooting information systems that incorporate servers in a networked computing environment. It also includes managing accounts and resources, maintaining server resources, monitoring server performance, safeguarding data in a Microsoft Windows Server 2008 environment, development of skills necessary to implement, administer, and troubleshoot information systems that incorporate Windows Based Servers in a networked computing environment, setting up servers for various client computers, configuring directory replication, managing licensing, user group accounts, user profiles, administering remote servers, disk resources, creating and sharing resources, implementing permissions and security, fault-tolerance, installing and configuring RAS, performance bottlenecks; and configuring problems. (ITNW 1354)

Prerequisite: Fundamentals of Networking or Cisco Expl1 NW Fundamentals Note: Textbook required; flash drive required This course provides instruction in security for network hardware, software, and data, including physical security; backup procedures; relevant tools, encryption; and protection from viruses. (ITSY 1342)