Required Prerequisites

Take as advised.

• CIS 121 Introduction to Computer Information Systems (5 credits)

• Course purpose: This course provides baseline vocabulary for all IT conversations as well as presenting the wide breath of the specialty areas of the field.

• CIS 122 Introduction to Computer Programming (5 credits)

• Course purpose: In this course you will learn introductory concepts of computer program analysis, design and development using modern structured programming methodologies and techniques. This also involves structure charts, pseudocode and flowcharts. Common computer program techniques of documentation, testing and validation, and implementation using the systems development life cycle (SDLC) model, and lab assignments to allow the student to interact with computer technology, hardware and concepts.

• CIS 130 Productivity Software (5 credits)

• Course purpose: In order to document and present IT solutions to IT teams and to stakeholders, you must be proficient in desktop software. You will learn some of the most popular software applications used for word processing, spreadsheet, database management and presentation and note taking purposes using various local and cloud-based storage.

• CIS 134 Modern Computer Technologies (5 credits)

• Course purpose: In this course you will learn about the basics of computer operating systems.

• CNE 241 CCNA 1: Introduction to Networks (5 credits)

• Course purpose: In order for databases and programs to work correctly, you must learn to communicate effectively with networking staff. This course introduces the architecture, structure, functions, components and models of the Internet and other computer networks. The principles and structure of IP addressing and the fundamentals of Ethernet concepts, media and operations are introduced to provide a foundation for the curriculum. By the end of the course, you will be able to build simple local area networks (LANs), perform basic configurations for routers and switches, and implement IP addressing schemes.

• BTECA 100 Business Keyboarding: Key the Alphabet by Touch (1 credit)

• Course purpose: Keyboarding skills are necessary for rapid and efficient implementation of computer commands.

• BTECA 102 Keyboard Skill Development: Alpha and Technical Improvement (1 credit)
• BTECA 103 Keyboard Skill Development: Alphanumeric and Technical Improvement (1 credit)
• BTECA 104 Keyboard Skill Development: Alphanumeric Improvement (1 credit)
• BTECA 105 Keyboard Skill Development: Further Alphanumeric Improvement (1 credit)

• Course purpose:  Keyboarding skills are necessary for rapid and efficient implementation of computer commands. Students with disabilities will need to be proficient in alternative input technologies.

1. College Success

• COLLG 110 College Success (3 credits)

• Course purpose: A foundational course to explore and affirm a career choice and build upon the skills, knowledge, and resources that will support you at Pierce College and beyond.

2. Business Analysis

• CIS 210 Business Analysis (5 credits)

• Course purpose: You will learn tools to analyze the business environment and define stakeholder needs in order to make recommendations for IT solutions that enable the organization to achieve its goals.

3. Systems Analysis and Design

• CIS 280 Systems Analysis and Design (5 credits)

• Course purpose: You will learn systematic approaches to defining needs, creating specifications and designing information systems. Course discussion and hands-on case studies providing practical knowledge and experience. Waterfall and agile systems analysis and design techniques will be used to develop and document effective computer-based information systems projects. You will also learn project management standards and create project plans using currently available project management application software.

Action Item: Meet with Advisor

Use your Success Network!  In your first quarter, meet with your advisor to revisit your career and transfer path, make adjustments to your goals as needed, and plan for your next steps.  

4. Database Management Systems

• CIS 260 Database Management Systems (5 credits)

• Course purpose: You will learn concepts, theory, analysis and design of relational database management systems (RDBMS). This project-based class explores Entity Relationship modeling and database design fundamentals. Practical application includes case study analysis within the health-care industry and comparison to other industries as applicable.

5. Medical Terminology I

• BTECM 150 Medical Terminology I (5 credits)

• Course purpose: Professionals working in the health information technology field need to be literate in the vocabulary of the medical field. This is the first of a two course sequence.

Action Item: Apply for Graduation

Way to go! It is time to apply for graduation. Visit the Pierce College Graduation website for details. https://www.pierce.ctc.edu/graduation

6. Structured Query Language

• CIS 261 Structured Query Language (5 credits)

• Course purpose: In this course you will learn industry-standard language for storing, retrieving, displaying, and updating data in a relational database.

7. Advanced SQL Programming and Tuning

• CIS 269 Advanced SQL Programming and Tuning (5 credits)

• Course purpose: In this course you will continue learning SQL by covering advanced topics to develop script files, stored procedures, and procedural language units, as well as diagnose and tune performance problems.

8. Database Administration Backup and Recovery

• CIS 262 Database Administration Backup and Recovery (5 credits)

• Course purpose: In this course you will learn the key tasks and functions required of a database administrator in a production environment. You will gain experience creating and implementing a database, managing data, expanding the size of the database, implementing basic security and data integrity measures, and granting data access privileges to individual users.

9. Electronic Health Records

• BTECM 257 Electronic Health Records (5 credits)

• Course purpose: Health information technology professionals must understand the medical laws and policies governing the medical data as well as understand how the stakeholders create and use the data. This course will prepare you for the management of health information through the use of electronic health records. You will complete common work tasks and practice data entry while creating a variety of electronic medical records (EMRs) in both inpatient and outpatient settings using training software. The course will also provide background on existing and evolving government-driven standards and regulations as they apply to the health-care environment.

Total Credits without Prerequisites 43

Note: Due to the rapid changes in the IT industry, the Special Topics courses CIS 155 and CNE 155 may be substituted as needed into the CIS or CNE degree programs, on the advice of the CIS/CNE faculty and program coordinator.

Program Code: 529C