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. Computer Information/Keyboarding Skills Course Recommendation

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.

• BTECA 100 Business Keyboarding: Key the Alphabet by Touch (1 credit)
• 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.

3. 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 Information Technology solutions that enable the organization to achieve its goals.

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. Spreadsheet Applications

• CIS 136 Spreadsheet Applications (3 credits)

• Course purpose: Business data resides in spreadsheet silos around a company.  In order to import or export data for your stakeholders, you will learn basic through advanced spreadsheet design and development.

5. Introduction to Computer Programming

• CIS 122 Introduction to Computer Programming (5 credits)

• Course purpose: You will learn introductory concepts of computer program analysis, design and development using modern structured programming methodologies and techniques.

6. 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.

7. Database Management Systems

• CIS 260 Database Management Systems (5 credits)

• Course purpose: You learn concepts, theory, analysis and design of relational database management systems.

8. Human Relations/Psychology/Sociology Course Recommendation

Choose one

• BUS 240 Human Relations in the Workplace (5 credits)

• Course purpose: You will learn how the needs of business or other formal organizations interact with individual needs, leadership styles, formal organizational policies and procedures, and general cultural patterns to determine how human beings act in work situations.

• PSYC& 100 General Psychology (5 credits)
• SOC& 101 Introduction to Sociology (5 credits)

• Course purpose: Acceptable substitution if considering transferring to a four year school.

9. Client-Side Web Development

• CIS 215 Client-Side Web Development (5 credits)

• Course purpose: You will learn how to present data from databases in a web format.

10. Structured Query Language

• CIS 261 Structured Query Language (5 credits)

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

11. Introduction to Object Oriented Programming (OOP)

• CIS 123 Introduction to Object Oriented Programming (OOP) (5 credits)

• Course purpose: You will learn techniques for effective program coding; testing and establishing error handling techniques.

12. English Composition I

• ENGL& 101 English Composition I (5 credits)

• Course purpose: In this field you need to be able to create technical documentation.

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

13. Public Speaking

• CMST& 220 Public Speaking (5 credits)

• Course purpose: In this field you need to be able to make technical presentations.

14. Introduction to Statistics

• MATH& 146 Introduction to Statistics (5 credits)

• Course purpose: In this field you will need to be able to work with analytical data to be able to create data sets from databases and data warehouses.

15. Advanced SQL Programming and Tuning

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

• Course purpose: You will continue to advance you Structured Query Language (SQL) skills by covering advanced topics to develop script files, stored procedures, and procedural language units, as well as diagnose and tune performance problems.

16. Server-Side Web Development

• CIS 216 Server-Side Web Development (5 credits)

• Course purpose: You will learn fundamental concepts of server-side web development.

17. Database Administration Backup and Recovery

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

• Course purpose: You will learn the key tasks and functions required of a database administrator in a production environment.

Action Item: Complete Certification Exam(s)

Please complete certification exam(s) (ex. MTA Database Fundamentals, MTA Software Fundamentals, IIBA ECBA), and begin job readiness preparation for internship and post-graduation job search. 

18. Intermediate Object Oriented Programming (OOP)

• CIS 185 Intermediate Object Oriented Programming (OOP) (5 credits)

• Course purpose: You will learn how to build Dot Net objects using unified modeling language.

19. CCNA 1: Introduction to Networks

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

• Course purpose: You will start to develop your understanding of the architecture, structure, functions, components and models of the Internet and other computer networks.

20. Business Analytics/Intelligence

• CIS 275 Business Analytics/Intelligence (5 credits)

• Course purpose: In this course you will learn how to develop business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. BI tools are used for reporting (SSRS), integration (SSIS), and analysis (SSAS).

21. Installing and Configuring Windows Server

• CNE 232 Installing and Configuring Windows Server (5 credits)

• Course purpose: In order for databases and programs to work correctly you must be able to build your own development environment.  In this course you will learn how to install and configure Windows Server with Active Directory, Network Services, Local Storage, File and Print Services, Group Policy and virtualization.

22. Supervised Internship

• CIS 290 Supervised Internship (5 credits)

• Course purpose: You will gain relevant experience working in a local business environment. This requires 250 hours of supervised work including associated resume preparation, job interviews and internship documentation.

23. CIS Project Capstone

• CIS 264 CIS Project Capstone (5 credits)

• Course purpose: In this course you will demonstrate your proficiency of prior core course outcomes by analyzing, designing, developing, implementing and evaluating a real-life data driven application project using one or more software development life cycles.

Total Credits 106-116

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: 503