Back to ITWorks website
Teacher Certification Codes
itWORKS.OHIO Message Board
Information Technology Occupational Definitions
Information Technology Unit Matrix
Calendar of events
Information Technology Panel Participant Lists
Recomended Hardware and Software
Certification Crosswalk Summaries
 
MCP
 
 
 
 
 
 
Academic Linkages Summary
 
Other Web Sites of Interest
CERTIFICATION CROSSWALK SUMMARY
AREA OF CERTIFICATION: Microsoft Certified Professional (MCP)
WHAT IS MICROSOFT CERTIFIED PROFESSIONAL? For those who want to demonstrate expertise with a particular Microsoft product, the Microsoft Certified Professional credential is offered. Candidates may pass additional Microsoft certification exams to further qualify their skills with Microsoft BackOffice Products, development tools, or desktop applications.
MICROSOFT CERTIFIED PROFESSIONAL CROSSWALK WITH OHIO INFORMATION TECHNOLOGY COMPETENCY PROFILE
The competencies listed below were identified by a panel of industry and education representatives to be addressed in MCP Certification.

PLEASE NOTE:
X = competency is addressed
O = competency is partially addressed
Unit MCP
Unit 3: Data Communications
3.3 Demonstrate proficiency with electronic mail X
Unit 4: Programming Theory
4.1 Demonstrate knowledge of programming language concepts X
4.2 Apply the process of algorithm and structured code development X
4.3 Demonstrate knowledge of the stages of program development X
Unit 5: Applied Programming Languages
5.1 Apply computational and logical operations X
5.2 Apply techniques for building applications X
5.3 Apply language specific programming techniques X
5.4 Debug programs X
Unit 7: Software Development
7.1 Demonstrate knowledge of software development methodology X
7.4 Code programs X
7.9 Demonstrate knowledge of data structures X
Unit 8: Software Systems Management
8.1 Install/configure software programs X
Unit 15: Internet
15.2 Demonstrate advanced knowledge of the Internet X
15.3 Access the Internet X
15.4 Utilize Internet services X
Unit 16: Web Page Design
16.1 Demonstrate knowledge of web page basics X
16.2 Demonstrate knowledge of Internet programming basics X
16.3 Apply knowledge of basic web programming X
16.4 Apply knowledge of web hosting X
16.6 Format page layout X
Unit 19: Operating Systems
19.1 Describe system components X
19.2 Demonstrate knowledge of computer memory X
19.3 Demonstrate knowledge of auxiliary storage X
19.4 Maintain security requirements X
19.5 Operate system X
19.6 Maintain system X
19.7 Perform standard computer backup procedures X
19.9 Employ computer system interfaces X
Unit 21: Network Architectures
21.5 Demonstrate knowledge of the TCP/IP protocol X
21.6 Demonstrate knowledge of basic communication protocols X
21.7 Install basic system architectures using current Windows operating system software X
Unit 22: Network Operating Systems
22.1 Demonstrate knowledge of the general characteristics of network operating systems X
22.2 Demonstrate knowledge of network operating systems (i.e., Novell NetWare, Windows NT, LINUX, UNIX, IBM Network, AppleTalk) X
22.3 Install network system X
Unit 23: Wide-Area Networks
23.3 Design WAN systems X
Unit 24: Network Management
24.1 Demonstrate knowledge of network management activities and procedures X
24.2 Demonstrate knowledge of network applications X
24.3 Solve network applications problems X
24.5 Design network security systems X
24.6 Perform network installation procedures X
24.7 Build Ethernet networks X
24.8 Perform network operation procedures X
24.9 Perform hardware and desktop support X
24.10 Perform network administration X
24.11 Perform network maintenance and diagnostics and testing X
24.12 Explain disaster recovery and business continuance X
Unit 26: Database Management System Basics
26.1 Demonstrate knowledge of Database Management System (DBMS) basics X
26.2 Employ computational and logical operators X
26.3 Develop report-preparation programs X
26.4 Develop database programs X
26.5 Employ a DBMS X
26.6 Manage implementation of a DBMS X
26.7 Monitor a DBMS X
Unit 27: Database Administration
27.1 Apply databases to actual situations and business problems X
27.2 Apply data modeling techniques X
27.12 Identify backup and recovery requirements for physical models X
27.14 Identify physical database characteristics X
Unit 28: Data Warehousing
28.1 Demonstrate knowledge of basic data warehousing concepts X
28.3 Perform data entry and updating X
28.4 Perform data retrieval X
28.5 Apply data X
Unit 29: Application Development Life Cycle
29.3 Develop computer programs in accordance with programming theory X
29.4 Test programs X
Unit 33: System Installation and Maintenance
33.2 Install system X
33.3 Perform software configuration and loading X
33.4 Monitor the information system X
33.6 Manage backup and recovery, both on- and off-site X
33.7 Troubleshoot problems X
33.9 Perform software upgrades and fixes X
Unit 34: System Administration and Control
34.2 Apply data structure concepts to the storage and retrieval of data X
34.3 Query a database X
34.4 Create menus and display screens using system utilities X
34.6 Transfer files between mid-range and microcomputer systems X