Transcription
Information Systems TechnologyMississippi Curriculum FrameworkComputer Networking Technology (Program CIP: 11.0901 – Computer Systems Network andTelecommunications)Computer Programming Technology (Program CIP: 11.0201 – ComputerProgramming/Programmer, General)Database Administration Technology (Program CIP: 11.0802 – Data Modeling/Warehousingand Database Administration)Data Analytics Technology (Program CIP: 52.1302 – Business Statistics)Network Security Technology (Program CIP: 11.1003 – Computer and Information SystemsSecurity)March 2017Published by:Mississippi Community College BoardDivision of Workforce, Career, and Technical Education3825 Ridgewood RoadJackson, MS 39211Phone: 601-432-6155Email: curriculum@mccb.edu1
FACULTY WRITING TEAM MEMBERSRhonda Posey, Copiah- Lincoln Community CollegeAndrew (Brandon) Sesser, East Mississippi Community CollegeSandy Coleman East Mississippi Community CollegeAaron Brooks, East Mississippi Community CollegeThomas Fortenberry, East Central Community CollegeLaura Sullivan, East Central Community CollegeJo Ponder, Hinds Community CollegeDavid Rose, Hinds Community CollegeWarren (James) Finch, Hinds Community CollegeMichael Pawlik, Holmes Community CollegeCindy Layman, Itawamba Community CollegeTanya Cox, Itawamba Community CollegeDoris McCreary, Itawamba Community CollegeDelena Hukle, Itawamba Community CollegeMitch Dubose, Jones Junior CollegeJennifer Powell, Jones Junior CollegeCurtis Beckman, Meridian Community CollegeTerry Cullum, Meridian Community CollegeBrad Marx, Mississippi Gulf Coast Community CollegeRobin Hayes, Mississippi Gulf Coast Community CollegeAl Huddle, Mississippi Gulf Coast Community CollegeNatasha Lewis, Northeast Mississippi Community CollegeFranklin Cleveland, Northwest Community CollegeTemple Allen, Northwest Community CollegeJeffrey McCoy, Pearl River Community CollegeBrian Miller, Southwest Mississippi Community CollegeADMINISTRATOR WRITING TEAM MEMBERSBrent Duguid, Dean Copiah-Lincoln Community CollegeMelanie Sanders, East Mississippi Community CollegeLarry Miller, Dean Mississippi Gulf Coast Community CollegeAmy Whittington, Holmes Community CollegeSandy Cochran, Dean Jones Junior CollegeBUSINESS AND INDUSTRY CONTRIBUTING TEAM MEMBERSJodi Harris, CISCOJamie Flowers, Concordia UniversityRichard Marx, Passport AmericaEric Oliver, Future Design GroupSean Farrell, Beau RivageThanh Duong, Ocean Springs School DistrictBrandon Roberts, City of BiloxiPatrick Hughes, 4- County EPAMark Minor, Mississippi State Extension CenterShea Hoda, WeyerhaeuserDavid Ellis, BrocadeChamath N. Wijewardau, OCHAllen Ming, YokohamaRobbie Taylor, C Spire2
Jeff McMullen, FNC*Courtney Humphries, FNC*Mark Jenkins, Mississippi Community College Board*Tina White, University of Southern MississippiStan Burton, Burton Computer ResourcesStephen Seal, Poplarville School DistrictNathan Mitchell, Poplarville School DistrictLaith Aljabi, Pearl River County HospitalCarl Smith, King’s Daughters Medical CenterPatrik Brown, Mississippi School of the ArtsKelly Perkins, Hurst Review ServicesDewayne Dunn, Copiah Lincoln School DistrictChris Wages, Ashley FurniturePatrick Medlin, Foresight Innovation TechnologyDarron Michal, General AtomicsSteven Vallarian, CSAKeith Carter, Vectrus (ACE- IT)**Denotes an industry member who attended the writing team meeting.OFFICE OF CURRICULUM AND INSTRUCTION TEAM MEMBERSDr. Angela Bryan, Director of Curriculum and Instruction, Mississippi Community College BoardLaToya Sterling, Curriculum Specialist, Mississippi Community College BoardDr. Teresa Barnes, Curriculum Specialist, Mississippi Community College Board3
The Office of Curriculum and Instruction (OCI) was founded in 2013 under the Division of Workforce,Career, and Technical Education at the Mississippi Community College Board (MCCB). The office is fundedthrough a partnership with The Mississippi Department of Education (MDE), who serves as Mississippi’sfiscal agent for state and federal Career and Technical Education (CTE) Funds. The OCI is tasked withdeveloping statewide CTE curriculum, programming, and professional development designed to meet thelocal and statewide economic demand. Copyright 2017 by Mississippi Community College BoardFor information, please contact curriculum@mccb.edu4
ContentsNATIONAL CERTIFICATION STANDARDS . 8INDUSTRY JOB PROJECTION DATA . 11ARTICULATION . 15TECHNICAL SKILLS ASSESSMENT. 15INSTRUCTIONAL STRATEGIES . 16ASSESSMENT STRATEGIES . 16REVISION HISTORY : . 17PROGRAM DESCRIPTION . 18IST 1113 Fundamentals of Information Technology . 29IST 1124 IT Foundations . 31IST 1134 Fundamentals of Data Communications . 34IST 1143 Principles of Information Security . 36IST 1154 Web and Programming Concepts . 38IST 1163 Database and SQL Concepts . 41IST 1173 Principles of Database Management . 43IST 1183 Essentials of Information Systems Technology . 44IST 1193 Practical Applications in Information Systems Technology . 46IST 1213 Client Installation and Configuration. 48IST 1223 Network Components . 50 IST 1244 Network Administration Using Microsoft Windows Server . 52IST 1254 Network Administration Using Linux . 54 IST 1263 Microsoft Office Applications. 56IST 1273 Career Development . 57IST 1314 Visual BASIC Programming Language . 59IST 1324RPG Programming Language . 60IST 1334 COBOL Programming Language. 61IST 1414 Client –Side Programming . 62IST 1424 Web Design Applications . 63IST 1433 Web Development Using HTML & CSS . 64IST 1483 Fundamentals of Virtualization . 66IST 1513 SQL Programming . 68IST 1523 SQL Programming II . 70IST 1534 Database Architecture and Administration . 72IST 1613 Computer Forensics. 74IST 1624 Network Security Fundamentals . 75IST 1633 Wireless Security and Privacy . 775
IST 1643Network Defense and Countermeasures . 78IST 1714Java Programming Language . 80IST 1723Programming in Python . 81IST 1733 Data Analysis Using Excel . 82IST 1744 SAS Programming I . 83IST 1754 R Programming Language. 85IST 1811 IST Seminar I . 86IST 1821 IST Seminar II . 87IST 2111 IST Seminar III . 88IST 2121 IST Seminar IV . 89IST 2213Network Security . 90IST 2224Network Planning and Design . 93IST 2234Network Implementation . 95IST 2254Advanced Network Administration Using Microsoft Windows Server . 97IST 2264Advanced Network Administration Using Linux . 99 IST 2314 System Analysis and Design . 101IST 2324 Script Programming Language . 102IST 2334 Advanced Visual BASIC Programming Language . 104IST 2344 Database Programming and Design . 105IST 2354 Advanced RPG Programming Language . 106IST 2364 Advanced COBOL Programming Language . 107IST 2374C Programming Language . 109IST 2384Advanced C Programming Language . 110IST 2394Enterprise Resource Planning (ERP) Concepts . 112IST 2424 XML Programming . 113IST 2434 Server-side Programming I . 114IST 2444 Server-side Programming II . 115IST 2454 Mobile Application Development. 116IST 2464 PowerShell Programming . 118IST 2473 E-commerce Strategies. 119IST 2483 Web Server . 121IST 2514 Advanced Architecture and Administration . 122IST 2524 Linux Operating System Fundamentals . 123IST 2534 IT Project Management . 124IST 2584 C# Programming Language . 125IST 2594 Advanced C# Programming Language . 126IST 2613 Windows Security . 1286
IST 2623 Linux/ Unix Security . 130IST 2634 Security Testing and Implementation . 131IST 2724 Advanced Java Programming . 133IST 2734 Data Visualization and Marketing . 134IST 2744 SAS Programming II . 135IST 2753 Big Data Analytics . 137IST 291 (1-6) Supervised Work Experience in Information System Technology . 138IST 292 (1-3) Special Problems in Information System Technology . 139IST 293 (1-3) Special Problems in Information System Technology. 140IST 294 (1-3) Special Problems in Information System Technology. 141RECOMMENDED TOOLS AND EQUIPMENT . 142RECOMMENDED INSTRUCTIONAL AIDS . 142CURRICULUM DEFINITIONS AND T ERMS . 143COURSE CROSSWALK . 1457
NATIONAL CERTIFICATION STANDARDSCompTIACompTIA is a vendor neutral provider of IT certifications. At the time of this revision, CompTIA A (2017edition) comprise CompTIA A 220-#01 and CompTIA A 220-#02. The following overview has beenprepared based directly on information from the CompTIA A certification website at www.CompTIA.org.The certification covers both hardware and software fundamentals that are needed by IT professionals insupport and service technician roles. CompTIA A 220-#01 covers computer technology fundamentals,such as PC installation, configuration, mobile devices, and networking as well as safety procedures andprohibited content. CompTIA A 220-#02 covers installing and configuring PC and mobile operatingsystems, as well as common functions in networking, email and security.In order to receive CompTIA A certification a candidate must pass two exams. The first exam is CompTIAA 220-#01 Certification Exam. The CompTIA A 220-#01 and CompTIA A 220-#02 examinations measuresnecessary competencies for an entry-level IT professional with the equivalent knowledge of at least 12months of hands-on experience in the lab or field. Successful candidates will have the knowledge requiredto assemble components based on customer requirements, install, configure and maintain devices, PCsand software for end users, understand the basics of networking and security/forensics, properly andsafely diagnose, resolve and document common hardware and software issues while applyingtroubleshooting skills. Successful candidates will also provide appropriate customer support; understandthe basics of virtualization, desktop imaging, and deployment.CompTIA A is accredited by ANSI to show compliance with the ISO 17024 Standard and, as such,undergoes regular reviews and updates to the exam objectives. CompTIA Network professionals aretrained to work with a variety of hardware, software and networks. Take your talents wherever your ITambitions lead you.CompTIA Security is the certification globally trusted to validate foundational, vendor-neutral IT securityknowledge and skills. As a benchmark for best practices in IT security, this certification covers the essentialprinciples for network security and risk management – making it an important stepping stone of an ITsecurity career. CompTIA Security meets the ISO 17024 standard and is approved by U.S. Department ofDefense to fulfill Directive 8570.01-M requirements. It is compliant with government regulations under theFederal Information Securit
Database Administration Technology (Program CIP: 11.0802 – Data Modeling/Warehousing and Database Administration) Data Analytics Technology (Program CIP: 52.1302 – Business Statistics) Network Security Technology (Program CIP: 11.1003 – Computer and Information Systems Security) Mar
