Computer Information Systems (107)

107-013. Advanced Microsoft Access. (2 Credits)

Students will learn how to develop relational databases using MS Access. Normalization of data, creating tables with proper attributes that contain a primary key will be demonstrated though lecture and activities. Foreign keys and data types will be developed as tables and relationships are built. Students will learn how to create queries using the QBE wizard. Custom forms and reports will link to the queries.

Prerequisites: 501-107 with a minimum grade of C

See sections of this course

107-029. Project Management for IT. (3 Credits)

Successful Project Management can be a substantial business asset. The Information Technology field as a whole requires students to understand the business needs of an IT project as well as understanding the benefits of successful implementation of a project. This course will teach students the insights of project management. This includes the tools that can help manage IT based projects, and also incorporates Microsoft Project software to enhance the ability to properly manage a project, developing a project charter, team selection, constraints, stakeholder communication, and other project success strategies.

See sections of this course

107-030. Informatn Tech Proj Mgmt Princ. (3 Credits)

Examine factors critical for project success and recent studies regarding the state of information technology project management. Learn how each of the nine project management areas contributes to the successful completion of all projects and how to divide projects into phases in order to clearly identify activities to be completed. Prepare to take industry standard certification courses in project management.

See sections of this course

107-031. Info Tech Project Mgmt Appl. (3 Credits)

Apply project management principles to projects and case studies where unforeseen problems arise and decisions must be made regarding changes to levels of resource allocation. Use Gantt charts, critical path analysis, network diagrams and other techniques to satisfy project constraints such as time, cost and final quality of the deliverable product. Prepare to take industry standard certification courses in project management.

Prerequisites: (107-030 with a minimum grade of C)

See sections of this course

107-032. Info Tech Project Mgmt Tools. (3 Credits)

Learn to use tools that can help manage projects by controlling and scheduling activities and by tracking progress toward measurable outcomes. Use Microsoft Project software to enhance ability to properly manage a project. Discuss the functionality of Microsoft Project and review other software tools and resources available to project managers. Prepare to take industry standard certification courses in project management.

See sections of this course

107-061. Google Technical Support Fund. (1 Credit)

In this course, learners are introduced to the world of information technology, or IT. Participants will learn about the different facets of IT, like computer hardware, the Internet, computer software, and job-related skills. They will also learn about the history of computers, and the pioneers who shaped the world of computing that we know today. This course covers a wide variety of topics, and it is designed to give an overview of what’s to come in the Google IT Support Professional Certificate coursework. People who complete this course will be able to do the following: Understand how the binary system works, Assemble a computer from scratch, Choose an operating system and install it on a computer, Understand what the Internet is, how it works, and the impact it has in the modern world, Learn how applications are created and how they work inside computers, Utilize common problem-solving methods and soft skills in an IT setting.

See sections of this course

107-062. Google Bits Bytes of Network. (1 Credit)

This course is designed to provide a full overview of computer networking. It covers everything from the fundamentals of modern networking technologies and protocols to practical applications and network troubleshooting. People who complete this course will be able to do the following: Describe computer networks in terms of a five-layer model, Understand all of the standard protocols involved with TCP/IP communications, Grasp powerful network troubleshooting tools and techniques, Learn network services like DNS and DHCP that help make computer networks run.

See sections of this course

107-063. Google Operating Systems. (1 Credit)

In this course, participants will learn how to use Windows and Linux, two major operating systems that are core components of IT infrastructures. Through a combination of video lectures, demonstrations, and hands-on practice, students will become familiar with the main components of an operating system and how to perform critical tasks such as managing software, managing users, and configuring hardware. People who complete this course will be able to do the following: Navigate the Windows and Linux file systems using a graphical user interface and a command line interpreter, Set up users, groups, and permissions for account access, Install, configure, and remove software on the Windows and Linux operating systems, Configure disk partitions and file systems, Understand how system processes work and how to manage them, Work with system logs and remote connection tools, Utilize their knowledge of operating systems to troubleshoot common issues in an IT support specialist role.

See sections of this course

107-064. System Admin IT Infrastructure. (1 Credit)

This course will transition learners from working on one computer at a time to working with a whole fleet of computers. Systems administration is the field of IT that’s responsible for maintaining reliable computer systems in multi-user environments. In this course, participants will learn about the infrastructure services that keep all organizations, big and small, up and running. Topics include how to manage and configure servers, and how to use industry tools to manage computers, user information, and user productivity. Finally, the course will explain how to recover an organization’s IT infrastructure in the event of a disaster. People who complete this course will be able to do the following: Utilize best practices for choosing hardware, vendors, and services for an organization, Understand the most common infrastructure services that keep an organization running, how they work, and how to manage infrastructure servers, Manage an organization’s computers and users using the Active Directory and OpenLDAP directory services, Choose and manage the tools that an organization will use, Back up an organization’s data and recover IT infrastructure in the event of a disaster, Utilize systems administration knowledge to plan and improve processes for IT environments.

See sections of this course

107-065. Google IT Security. (1 Credit)

This course covers a wide variety of IT security concepts, tools, and best practices. It introduces threats and attacks and the many ways they can show up, and then discusses encryption algorithms and how they’re used to safeguard data. From there, the course dives into the “three A’s of information security”—authentication, authorization, and accounting. It also covers network security solutions, ranging from firewalls to Wi-Fi encryption options. The course then pulls the subject matter together with a look at how all of those elements can be incorporated into a multilayered, in-depth security architecture. It concludes with recommendations on how to foster a culture of security within a team or an entire organization. People who complete this course will understand the following: How various encryption algorithms and techniques work, and their benefits and limitations, Various authentication systems and types, The difference between authentication and authorization. At the end of this course, learners will be able to do the following: Evaluate potential risks and recommend ways to reduce risk, Make recommendations about how best to secure a network, Help others to understand security concepts and protect themselves.

See sections of this course

107-102. IT Support. (2 Credits)

Develop a comprehensive understanding of the knowledge, skills and abilities necessary to support IT. Get an introduction to IT service management and issue resolution along with debugging, end-user instruction, training and user needs analysis. Develop communication skills, critical thinking, trouble-shooting and professionalism through hands-on labs.

Prerequisites: (Computer Skills Assessment 070 or College Profi - Comp Skills or Work Experience - Comp Skills or 860-702 with a minimum grade of S)

See sections of this course

107-103. IT Business Strategies. (3 Credits)

IT is a critical tool to help support business strategy. IT investment and implementation needs to be aligned with the needs of a business enterprise. Participants completing this course will have the tools and knowledge needed to be successful in a business enterprise and understand how IT relates to the rest of the organization. The IT Business Strategies course explores IT and its relationship with the organization, vendors and the enterprise at the operational, strategic and departmental levels. Topics covered will include international relations and considerations, functional areas within the organization, E-business components and their business impact. Key success strategies such as time and project management, organizational skills, collaboration, and critical business skills will be emphasized.

Prerequisites: (COMPASS-Writing Skills 59 or College Proficiency - Writing or COMPASS/ESL - Grammar 90 or ACT-English 17 or ASSET-Writing Skills 41 or Accuplacer Sentence Skills 082 or Next-Gen Accuplacer Writing 250 or TABE Advanced Language 11.0 or TABE-11 A Language 631 or TABE-12 A Language 631 or Completed Intro College Wrtg or 831-103 with a minimum grade of C) or (Accuplacer ESL Language Use 103 and Accuplacer ESL Sentence Mean 103) and (COMPASS-Reading Skills 75 or ASSET-Reading Skills 40 or Accuplacer Reading Comp 070 or Next-Gen Accuplacer Reading 248 or ACT-Reading 17 or TABE Advanced Reading 11.0 or TABE-11 A Reading 617 or TABE-12 A Reading 617 or COMPASS/ESL - Reading 90 or College Proficiency - Reading or Accuplacer ESL Reading 103 or 838-105 (may be taken concurrently) with a minimum grade of C) or (High School GPA 2.60 or Higher or GED Language Arts-2014 Series 165)

See sections of this course

107-117. IT Co-Op. (2 Credits)

Cooperative Education (Co-Op) integrates classroom theory with valuable work experience specific to the IT student major. Our primary focus is to give students a broader educational experience through work. The IT Co-Op course will focus on goal setting, interpersonal relationships, and project activities during this occupational experience. The WCTC instructor/coordinator will work closely with the work site supervisor toward common educational objectives and goals. This course is specifically geared towards student success in the IT career fields.

Prerequisites: (Approval of Co-op Ed Office )

See sections of this course

107-118. Information Systems Design. (4 Credits)

Practice techniques used in computer programming and systems analysis and review the structure, lines of authority and information needs of the business enterprise. Become familiar with system projects, including preliminary investigations, setting objectives, establishing costs and benefits, and collecting data. Discuss the design techniques used in the development of specifications for outputs, inputs and files as well as the techniques for developing procedures and controls of typical business systems.

Prerequisites: (150-190 with a minimum grade of C or 150-191 with a minimum grade of C or 150-175 with a minimum grade of C) and (152-107 with a minimum grade of C or 152-169 with a minimum grade of C)

See sections of this course

107-119. System Analysis Agile Methods. (3 Credits)

Develop the conceptual and technical foundations needed for effective systems analysis, design and implementation along with project management skills for systems development. Learn the traditional approach to systems analysis with an emphasis on deliverables, as well as Scrum, the agile approach and the basic artifacts of Scrum. Focus on detail analysis, project management and teamwork.

Prerequisites: (150-190 with a minimum grade of C or 150-178 with a minimum grade of C or 150-175 with a minimum grade of C or 152-108 with a minimum grade of C) and (152-107 with a minimum grade of C or 152-168 with a minimum grade of C)

See sections of this course

107-137. IT Internship. (1 Credit)

The IT Internship experience provides valuable work experience specific to the IT student major. Our primary focus is to give students a broader educational experience through work. The WCTC instructor/coordinator will work closely with the work site supervisor toward common educational objectives and goals. This course is specifically geared towards student success in the IT career fields.To complete an internship, WCTC must first verify that students have met the prerequisites. Please contact the Career Connections Department at 262.695.7848 or internshipdepartment@wctc.edu for assistance.

Prerequisites: Approval of Co-op Ed Office

See sections of this course

107-161. IT Service Learn Practicum 1. (1 Credit)

Students will be provided the opportunity to practice the technical skills learned in their network program courses in real-world situations. Students will participate in organized technical service learning projects (arranged by WCTC) to gain hands-on experience in computer, network and technology support. These projects will take place at various local non-profit organizations and will NOT be simulations, but actual technology implementations.

See sections of this course

107-162. IT Service Learn Practicum 2. (1 Credit)

Students will be provided the opportunity to practice the technical skills learned in their network program courses in real-world situations. Students will participate in organized technical service learning projects (arranged by WCTC) to gain hands-on experience in computer, network and technology support. These projects will take place at various local non-profit organizations and will NOT be simulations, but actual technology implementations.

See sections of this course

107-184. IT Capstone. (2 Credits)

The IT Capstone course provides Network Specialist and Computer Support Specialist students the opportunity to showcase their IT knowledge proficiency and is required for graduation. This course is an independent, self-paced, project-based course and requires the student to attend a minimum of three hours of lab time per week. The WCTC faculty will work closely with the student to assess the student’s proficiency in all program outcomes. This course is specifically geared toward student success in the IT career fields.

Prerequisites: Associate Dean approval

See sections of this course

107-401. IT Infrastructure Library. (0.6 Credits)

This course covers the basic fundamental concepts of ITIL, and will identify and describe the phases of the IT Service Management Lifecycle.

See sections of this course

107-405. Beg Robotics Programming Camp. (0.4 Credits)

This exciting LEGO® robotics camp for children ages 9 to 14 will inspire their imaginations and challenge their minds. The course uses LEGOs as a fun tool to explore robotics, mechanical systems, electronics and programming. Students will work in teams of two with the same robots used in the First LEGO League competition. Start with basic concepts including NXT-G interface, MOVE, MOTOR and RESET blocks, turning, math for the robot and other resources. Advanced concepts include light sensors, program control and touch sensors.

Prerequisites: Associate Dean approval

See sections of this course

107-478. Int Java Programming. (3.5 Credits)

This thirty-five hour course is designed to provide students who already have a solid foundational understanding of Java Programming with training in advanced Java concepts. These concepts include Java Technologies, decision structures, Java classes and inheritance and arrays.

See sections of this course

107-601. Beg Robotics Programming Camp.

This exciting LEGO robotics programming camp for children ages 10 to 13 will inspire their imaginations and challenge their minds. The course uses LEGO EV3 Robots as a fun tool to explore robotics and programming. Students will work in teams of two with the same robots used in the First LEGO League competition. Start with basic concepts including EV3 interface, MOVE, MOTOR and RESET blocks, turning, math for the robot and other resources. Advanced concepts include light sensors, program control and touch sensors. PLEASE NOTE: The focus of this camp is on programming concepts. The LEGO robots will be pre-assembled, students will NOT be building with Legos.

See sections of this course