Template

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)







School: Clintondale Community Schools

Date: 07-Jan-08

Program Name: Computer Specialist (Microsoft Server 2000 Networking)

CIP Code:

CTE Instructor: T. Spanke

Post Secondary School: Clintondale Community Schools

Evaluator:





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

SECTION # 1

MICHIGAN STANDARDS

CAREER AND EMPLOYABILITY SKILLS

4 3 2 1 N 4 3 2 1 N

APPLIED ACADEMIC SKILLS

Apply basic communication skills, mathematical processes

and apply technology in work-related situations

Reading, English & Language Arts

Read a technical manual and write a clear & logical report explaining

MI 1 the information using standared business English. x ongoing

1 Give a verbal report on reading from a technical manual. ongoing

Read a case study and identify the details about the situation, define

technical terms, jargon, or words with multiple meanings based on

MI 2 context, and summarize the conclusion.

Relate the results of study to a similar situation in a verbal or writen x ongoing

report. x

Take a verbal and written position on a topic and use correct grammar

MI 3 to defend it. z ongoing

Mathematics

Approach practical and workplace problems using a variety of

MI 4 mathematical techniques. x ongoing

Problems include making conversions between the metric system and

non-English systems of measurement, mixed units (such as hours and

minutes), and can require serveral steps to finding a solution. x

Research how math is used in the workplace and make a presentation

MI 5 detailing the process. x

Listening & Presentation Skills

M 6 Use correct grammar to communicate verbally. x ongoing

Listen to a presentation and record important information. Report

M back identifying central themes and use key points to explain how the

I 7 message applies to a similar situation. x ongoing

Technology

M Apply technology to workplace or career situation. Include research

I 8 and a written paper. x

CAREER PLANNING

M Organize career information and labor market trends from a variety of

I 1 sources. x ongoing

M Explain the advantages and disadvantages of working for self, others,

I 2 being an employee of a large or small organization. x Chap 1





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 1

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

M 3 Analyze information & preferences from work-based opportunity. x

M Interpret information from a variety of career assessments to identify

I 4 career interests and abilities. x ongoing

M Apply a decision-making model and use career assessment

I 5 information to choose a career pathway. x ongoing

M 6/7 Annually review EDP and include plan for continuing education. x yearly

DEVELOPING AND PRESENTING INFORMATION

M 1 Gather, interpret, analyze, and refine data. x ongoing

M 2 Analyze and synthesize information and data from muiltiple sources. x ongoing

M Plan and transform ideas and requirements into a concept, service, or

I 3 product. x ongoing

M Assess the quality of the concept, service, or product using a

I 4 predetermined standard. x

Develop a plan to market a new product, service, or concept which

M includes identifying of customers, a graphic presentation, product

I 5 requirements, and costs. x

M Practice and demonstrate presentation skils using a variety of media

I 6 and interpretive data. x

PROBLEM SOLVING

M Apply a problem solving model to a workplace situation that involves

I 1 setting goals, implementing and evaluating results. x ongoing

Identify typical problems that occur in a workplace and use a problem

M solving model to devise solutions, compare alternatives to past

I 2 solutions, and predict their success. x ongoing

PERSONAL MANAGEMENT

Responsibility

M Demonstrate regular attendance, promptness, and staying with a task

I 1 until satisfacotry completion. x ongoing

M 2 Complete assignments with minimum supervision and meet deadlines. x ongoing

M Use mistakes as learning opportunities, demonstrate persistence and

I 3 adaptability to change. x ongoing

M 4 Initiate projects and extra activities for personal satisfaction. x ongoing

Self-Management

M Monitor & evaluate accurately one's progress towards a goal or

I 5 completion of a project. safety practices and drug-free behavior in

Demonstrate health and x ongoing

M 6 school & workplace setting. x ongoing

M Obtain a driver license and demonstrate driving skills and safety

I 7 and/or use public transportation. x

M 8 Prioritize and accomplish tasks independently. x ongoing

M Use appropriate personal expression and relate to school and work

I 9 settings. x ongoing

Ethical Behavior

Demonstrate etlhical behavior in school, work, and community

M 10 situations. x ongoing

M 11 Describe employer-employee rights necessary to maintaining

Demonstrate appropriate behaviors and responsibilities. x ongoing

M 12 employment. x ongoing

M 13 Demonstrate positive personal qualities as a group leader. x ongoing



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 2

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Respect for Self and Others

M View accomplishments or failures of self and others accurately and in

I 14 a positive manner. x ongoing

M Understand how to make improvements and ask for help from adults

I 15 as needed. x ongoing

M Offer encouragement and ideas to others as they work toward attaining

I 16 their goals. x ongoing

M Provide for customer needs and expectations in a helpful and

I 17 courteous manner. x ongoing

M 18 Respect other points of view. x ongoing

M Demonstrate customer service skills in an appropriate setting by

I 19 listening, suggesting solutions, and communicating the issues at hand. x ongoing

ORGANIZING SKILLS

Time

M Determine goals and develop an action plan to accomplish them

I 1 within a given time frame. x

M Read time charts and work schedules and perform tasks within time

I 2 constraints of school or the workplace. x

M 3 Prioritize tasks and revise schedules as needed. x

Money

M Estimate costs and prepare a detailed budget for a school-based or

I 4 work-based project. x

M Report the costs of various components of a budget and adjust budget

I 5 items as needed. x

M Understand compensation practices and financial management and

I 6 explain how financial resources can be used effectively and x

Materials

M Utilize materials, tools, and processes to complete a task related to a

I 7 career selection. x ongoing

M Compile a list of materials and supplies needed in advance of an

I 8 assignment.

Acquire resources in a timely fashion and take responsibility for their x ongoing

M 9 care. x ongoing

M Identify and prepare tools, equipment, space, and facilities appropriate

I 10 for a task. x ongoing

M 11 Work within constraints of safety precautions and available resources. x ongoing

Human Resources

M Learn cooperation and leadership in a team at school or in a workplace

I

M 12 setting. and communicate with members of a team using varied

Organize x ongoing

I 13 methods of communications.

M Recognize the individual roles of team members, delegate tasks, and

I 14 give feedback on performance. x ongoing

M Acknowledge and utilize the skills, abilities, and input of all member

I 15 of a team. x ongoing

TEAMWORK

Group Participation

M Exhibit teamwork skills including trust and loyalty to group, and

I 1 demonstrate connectedness to group members, values, and culture. x ongoing







11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 3

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

M Take personal responsibility for influencing and accomplishing group

I 2 goals. x ongoing

M Demonstrate understanding of how effective teams operate within

I 3 organization and diverse settings. x ongiong

M 4 Solve a career/work-related problem as a member of a team. x ongoing

Conflict Resolution

M Demonstrate leadership by listening to others and asking appropriate

I 6 questions to clarify a problem or issue. x ongoing

M 7 Summarize a problem clearly and in appropriate detail. x ongoing

M Suggest constructive alternatives with confidence that will help

I 8 resolve a conflict. x ongoing

M Compromise and/or build consensus within a group and summarize

I 9 the decision of the group while maintaining respect for minortiy x ongoing

M Participate in the implementation of a group's decision and evaluate

I 10 the results. x ongoing

M Show sensitivity to others' thoughts and opinions and relate them to

I 11 the resolution process. x

Diversity

M Understand and respect the concerns of members of cultural, gender,

I 12 age, and ability groups. of differences of people in a work/school

Be respectful of a variety x

M 13 setting. x ongoing

M Demonstrate ability to work with others with different backgrounds,

I 14 cultures, and abilities. x ongoing

Leadership

M 15 Demonstrate leadership ability in a work or school setting. x ongoing

Recognize and take advantage of leadership opportunities that give

M direction to other team members, or that encourage other members to

I 16 complete tasks. x ongoing

NEGOTIATION SKILLS

Using correct terminology, clarify the problem or issue to be

M 1 negotiated. x

M Identify, organize, and define ideas from various sources to logically

I 2 support a position and use these ideas in debate. x ongoing

Demonstrate objectivity in assessing other viewpoints by considering

M all sides of an issue, using past experience, data and logical analysis,

I 3 and showing respectful behavior towards others. x

M Responsibily challenge existing policies and procedures and identify

I 4 new solutions or policy changes. x ongoing

UNDERSTANDING SYSTEMS AND USING

TECHNOLOGY

M 1 Identify trends and how they affect changes within a system. x

M 2 Demonstrate an understanding of business systems. x ongoing

M Compare management systems and consider how employees function

I 3 and adapt to change within them. x

M 4 Describe the technical systems related to a career interest area. x

M Diagnose and make necessary corrections or improvements to a

I 5 technical system in a business, industry, or simulated work place x







11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 4

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Describe how changes in technology have impacted business and

M industry, identify current trends, and recommend how a technical

I 6 system might be improved. x

M Demonstrate the use of equipment and machines to solve practical or

I 7 work-based problems. use of a variety of on-line technological

Demonstrate effective x ongoing

M 8 resources. x ongoing

M Determine what kind of application is needed for a given task and use

I 9 effectively. x ongoing

M Use technologies as tools for communication of technical or work-

I 10 related information.

Use technology effectively in solving problems in an area of career x ongoing

M 11 interest. x ongoing

M Understand and demonstrate basic computer hardware and software

I 12 installation and maintaining efficient machines. x ongoing

M Demonstrate ability to adapt to different software applications,

I 13 comparing and contrasting specfic functions and applying them to x ongoing

EMPLOYAB ILITY SKILLS

M Continue the EDP process which includes an annual review with

I 1 student and counselor and notification of parents. x ongoing

M Participate in work-based opportunities such as job-shadowing,

I 2 mentorships, work experiences, etc. x yearly

M Show ability to market oneself by preparing for and completing an

I 3 interview process. x

M Accurately complete records/documents to support job applications

I 4 (inquiry letters, resume, references, evaluations, follow-up letters). x yearly

M Use a portfolio, resume, record of attendance, certifricates, and/or

I 5 transcript as self-marketing tools to demonstrate interest and x yearly

M Apply career and labormarket information to seek and obtain

I 6 employment and/or pursue educational goals. x ongoing

Research availability of educational programs, financial requirements,

M and resource and complete an application process as appropriate for

I 7 career goals.the need for lifelong learning in a rapidly changing job

Understand x yearly

8 market. x ongoing



TECHNOLOGY SKILLS

BASIC OPERATIONS AND CONCEPTS

Discuss emerging technology resources (e.g., podcasting, webcasting,

M compressed video delivery, online file sharing, graphing calculators,

I 1 global positioning software) x ongoing

M Identify the capabilities and limitations of emerging communication

I 2 resources. x

M Understand the importance of both the predictable and unpredictable

I 3 impacts of technology. x yearly

Identify changes in hardware and software systems over time and

M discuss how these changes might affect the individual personally in

I 4 his/her role as a lifelong learner. x

M 5 Understand the purpose, scope, and use of assistive technology. x

M Understand that access to online learning increases educational and

I 6 workplace opportunities. x ongoing

M Be provided with the opportunity to learn in a virtual environment as a

I 7 strategy to build 21st century learning skills. x ongoing





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 5

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

M Understand the relationship between electronic resources,

I 8 infrastructure, and connectivity. x

M Routinely apply touch-typing techniques with advanced accuracy,

I 9 speed, and efficiency. x ongoing

M Assess and solve hardware and software problems by using online

I 10 help or other user documentation and support. x ongoing

M Identify common graphic, audio, and video file formats (e.g., jpeg, gif,

I 11 bmp, mpeg, wav) x ongoing

M 12 Demonstrate how to import/export text, graphics, or audio files. x ongoing

M Proofread and edit a document using an application’s spelling and

I 13 grammar checking functions. x ongoing

SOCIAL, ETHICAL, AND HUMAN ISSUES

M Identify legal and ethical issues related to use of information and

I 1 communication technology. x ongoing

Analyze current trends in information and communication technology

M and assess the potential of emerging technologies for ethical and

I 2 unethical uses. x

M Discuss possible long-range effects of unethical uses of technology

I 3 (e.g., virus spreading, file pirating, hacking) on cultures and society. x ongoing



M Discuss the possible consequences and costs of unethical uses of

I 4 information and computer technology. x

M Identify ways that individuals can protect their technology systems

I 5 from unethical or unscrupulous users. x ongoing

M Demonstrate the ethical use of technology as a digital citizen and

I 6 lifelong learner. x

M Explain the differences between freeware, shareware, and commercial

I 7 software. x ongoing

M 8 Adhere to fair use and copyright guidelines. x

M Create appropriate citations for resources when presenting research

I 9 findings. x

M Adhere to the district acceptable use policy as well as state and federal

I 10 laws. x yearly

M Explore career opportunities and identify their related technology skill

I 11 requirements. x yearly

M Design and implement a personal learning plan that includes

I 12 technology to support his/her lifelong learning goals. x

TECHNOLOGY PRODUCTIVITY TOOLS

M Complete at least one online credit, or non-credit, course or online

I 1 learning experience. x

Use technology tools for managing and communicating personal

M information (e.g., fi nances, contact information, schedules, purchases,

I 2 correspondence) x ongoing

M 3 Have access to and utilize assistive technology tools. x ongoing

Apply advanced software features such as an application’s built-in

M thesaurus, templates, and styles to improve the appearance of word

I 4 processing documents, spreadsheets, and presentations. x

M Identify technology tools (e.g., authoring tools or other hardware and

I 5 software resources) that could be used to create a group project. x







11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 6

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

M Use an online tutorial and discuss the benefits and disadvantages of

I 6 this method of learning. x ongoing

M 7 Develop a document or file for inclusion into a web site or web page. x

M Use a variety of applications to plan, create, and edit a multimedia

I 8 product (e.g., model, webcast, presentation, publication, or other x yearly

M Have the opportunity to participate in real-life experiences associated

I 9 with technology-related careers. x ongoing

TECHNOLOGY COMMUNICATIONS TOOLS

M Identify and describe various telecommunications or online

I 1 technologies (e.g., desktop conferencing, listservs, blogs, virtual x

Use available technologies (e.g., desktop conferencing, e-mail,

M groupware, instantmessaging) to communicate with others on a class

I 2 assignment or project. x ongoing

Use a variety of media and formats to design, develop, publish, and

M present products (e.g.,presentations, newsletters, web sites) to

I 3 communicate original ideas to multiple audiences. x

Collaborate in content-related projects that integrate a variety of media

(e.g., print, audio, video, graphic, simulations, and models) with

M presetation, word processing. Publishing, database, graphics design, or

I 4 spreadsheet applications. x

M Plan and implement a collaborative project using telecommunications

I 5 tools (e.g., groupware, interactive web sites, videoconferencing) x

TECHNOLOGY RESEARCH TOOLS

M Compare, evaluate, and select appropriate internet search engines to

I 1 locate information. x ongoing

Formulate and use evaluation criteria (authority, accuracy, relevancy,

M timeliness) for inforamtion located on the internet to present research

I 2 findings. x spell correct

M Determine if online sources are authoritative, valid, reliable, relevant,

I 3 and comprehensive. x ongoing

M 4 Distinguish between fact, opinion, point of view, and inference. x

M 5 Evaluate resources for stereotyping, prejudice, and misrepresentation. x

M Develop a plan to gather information using various research strategies

I 6 (e.g., interviews, questionnaires, experiments, online surveys) x

TECHNOLOGY PROBLEM-SOLVING and

DECISION-MAKING TOOLS

M Use a variety of technology resources (e.g., educational software,

I 1 simulations, models) for problem solving and independent learning. x

Describe the possible integration of two or more information and

M communication technology tools or resources to collaborate with

I 2 peers, community members, and field experts. x

Formulate a research question or hypothesis, then use appropriate

information and communication technology resources to collect

M relevant information, analyze the findings, and report the results to

I 3 multiple audiences. x









11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 7

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

SECTION #2

MICHIGAN TECHNICAL SKILLS

n/a

SECTION # 3

CLUSTER PATHWAY SKILLS

CAREER AND EMPLOYABILITY SKILLS

4 3 2 1 N 4 3 2 1 N

I PROGRAMMING AND SOFTWARE I

Identify and analyze customer software needs and

A requirements. 1

1 Gather data to identify customer requirements. 1.1

a Gather information using interviewing strategies. 1.1 x

b Identify input and output requirements. 1.1 x ongoing

c Identify system processing requirements. 1.1 x ongoing

d Clarify specifications using questioning techniques. 1.1 x ongoing

Identify hardware, networking, and software system

e functional requirements. 1.2 x

Demonstrate knowledge of nonfunctional requirements

(e.g., security, integrity response time, reliability, support,

f and documentation). 1.2

2 Conduct needs analysis. 1.2

a Gather information on problems from users. 1.2 x ongoing

b Perform workflow analysis to determine user needs. 1.2 x

c Analyze existing procedures. 1.2 x ongoing

d Define business problem to be solved by the application. 1.2 x ongoing

3 Development software requirements specification. 1.3

Demonstrate knowledge of the use, structure, and contents

a of a requirements specification document. 1.3 x

b Define system and software requirements. 1.3 x ongoing

c Develop informal specifications. 1.3 x ongoing

d Develop formal specification. 1.3 x

e Resolve conflicting Requirements. 1.4 x

f Review and verify specification with customer. 1.4 x ongoing

Analyze requirements/specifications using current

4 approaches. 1.4

Demonstrate knowledge of how to use software

a methodologies to analyze a real-world problem. 1.4 x ongoing

b Identify constraints. 1.4 x

Demonstrate knowledge of modeling and analyzing

functional requirements (e.g., dataflow diagrams, process

c specifications, and a data dictionary). 1.4 x





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 8

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Demonstrate knowledge of modeling and analyzing data

requirements (e.g., Jackson diagrams, entity relationship

d diagrams, and relations). 1.4 x

5 Use available reference tools as appropriate. 1.5

Access needed information using company and

manufacturers' references (e.g., procedural manuals,

a documentation standards, work flowcharts). 1.5 x ongoing

Produce IT-based strategies and project plan to solve

B the specific problem. 2

1 Define scope of work for the programming project. 2.1

a Define scope of work to meet customer needs. 2.1 x ongoing

Demonstrate knowledge of the key functions and

b subsystems of the software product. 2.1 x ongoing

Demonstrate knowledge of software development process

c and issues. 2.1 x

d Demonstrate knowledge of the system life-cycle approach. 2.1 x

Demonstrate knowledge and skills of working in a

2 software development team. 2.2

a Identify resources and risks. 2.2 x

Demonstrate knowledge of cross-functional team

b structures and team members' roles. 2.2 x

3 Design project plan. 2.3

Demonstrate knowledge of project budgeting, scheduling,

a and control issues related to software development. 2.3 x

b Demonstrate knowledge of software development 2.3 x

c Develop implementation plan. 2.3 x

C Define and analyze system and software requirements. 3

Identify new IT technologies and assess their potential

1 importance and impact in the future. 3.1

a Identify new technologies relevant to information 3.1 x ongoing

Assess the importance of new technologies to future

b developments. 3.1 x

c Identify system processing requirements. 3.1 Chap 2

d Identify data communication trends and major current 3.1 x Chap 2

2 Explain new and emerging classes of software. 3.2

a Identify new and emerging classes of software. 3.2 x ongoing

b Determine compatibility of hardware and software. 3.2 x ongoing

3 Understand elements and types of information 3.3

Identify the elements of the information processing cycle

a (I.e., input, process, output, and storage). 3.3 x yearly

Explain measurement techniques for increased

4 productivity due to information systems 3.4



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 9

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

a Identify metrics for measurements. 3.4 x

Measure increases in productivity realized by the

b implementation of information systems. 3.4 x

Identify new and emerging drivers and inhibitors of

c information technology change. 3.4 x

Demonstrate the effective use of tools for software

D development. 4

1 Apply tools for developing software applications. 4.1

a Demonstrate knowledge of software development 4.1 x

b Use prototyping techniques. 4.1 x

c Use appropriate Configuration Management tools. 4.1 s ongoing

d Use appropriate issues tracking tools. 4.1 x

e Demonstrate knowledge of reuse and components. 4.2 x

2 Apply language specific programming 4.2

a Develop programs using appropriate language. 4.2 x ongoing

Use appropriate development environment for the selected

language (e.g., compilers, debuggers, test generation, static

b analyzer, etc.). 4.2 x ongoing

c Use user interface development tools. 4.2 x

Demonstrate knowledge of how to use computer-aided

3 software engineering (CASE) tools. 4.3

a Use appropriate requirement analysis tools. 4.3 x

b Use appropriate modeling and analysis tools. 4.3 x

c Use requirement tracking tools. 4.3 x

Demonstrate knowledge of software reuse, design pattern,

d and components. 4.3 x

Demonstrate knowledge of the software development

E process. 5

Demonstrate knowledge of software development

1 methodology. 5.1

a Demonstrate knowledge of the information system life 5.1 x

Demonstrate knowledge of system analysis issues related

b to design, testing, implementation, and maintenance. 5.1 x ongoing

c Record and analyze process. 5.1 x

Identify the use of program design tools in a software

d development process. 5.1 x ongoing

Identify roles on team members/customers in the software

e development process. 5.2 x

f Identify current information life cycle models. 5.2 x

F Design a software application. 6

1 Create design specification for a computer application. 6.1





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 10

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Demonstrate knowledge of the principles of program

design (e.g., structured, object oriented, event-driven) to

a analyze real-world problems. 6.1 x

b Perform a logical design. 6.1 x

c Document design specification according to defined 6.1 x

d Design system input, output, processing, and interfaces. 6.1 x

e Review system design with management and users. 6.2 x

f Use current computer-aided software engineering (CASE) 6.2 x

Demonstrate comprehension of the trade-off involved

2 in design choices. 6.2

Demonstrate knowledge of the characteristics and the uses

a of processing (e.g., batch, interactive, event-driven, object- 6.2 x ongoing

Identify basic concepts of algorithm and data structure

b development. 6.2 x

Demonstrate knowledge of different data types (e.g.,

c numeric, alphanumeric, tables, etc.). 6.2 x chap 1

d Identify constraints. 6.2 x

Demonstrate knowledge of nonfunctional requirements

(e.g., security, integrity response time, cost, dependability,

e migration, etc). 6.3 x

f Demonstrate knowledge of modular design concepts. 6.3 x

Demonstrate knowledge of the features, functions, and

g architectures of client/server computing. 6.3 x ongoing

Apply the principles of effective information

3 management, information organization, and 6.3

a Demonstrate knowledge of database management 6.3 x

b Define the objectives of a client/server application. 6.3 x ongoing

c Implement online transition processing. 6.3 x ongoing

d Design static and dynamic online processing systems. 6.3 x

e Employ interface techniques. 6.4 x ongoing

Demonstrate knowledge of computing/networking

4 hardware and software architecture. 6.4

Demonstrate knowledge of how data is stored, organized,

managed and retrieve in various computer and network spell

a architecture. 6.4 correct

Demonstrate knowledge of software architectures for

b different classes of applications. 6.4

G Produce (code) a computer application. 7

1 Demonstrate knowledge of programming language 7.1

ongoing

Demonstrate knowledge of he hardware-software procedur

a connection. 7.1 x al



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 11

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Demonstrate knowledge of the concepts of data and

b procedural representation. 7.1 x

ongoing

Demonstrate knowledge of the basic principles for procedur

c analyzing a programming languages. 7.1 x al

Demonstrate knowledge of the basics of structured, object-

d oriented, and even-driven programming. 7.1 x Chap 5

ongoing

Demonstrate knowledge of how a programming language procedur

e can support multitasking and exception-handling. 7.2 x al

Demonstrate proficiency in developing an application

2 using an appropriate programming language. 7.2

Demonstrate knowledge of current key programming

languages and the environment they are used in (e.g.,

a C,C++, Visual Basic, Java, RPG, COBOL, Assembler). 7.2 x

Translate data structure and program design into code in

b an appropriate language. 7.2 x ongoing

Demonstrate knowledge of key constructs and commands

c specific to a language. 7.2 x ongoing

Understand the range of languages used in software

3 development. 7.3

Demonstrate knowledge of the range of languages used in

a software development. 7.3 x ongoing

Demonstrate knowledge of program development

4 methodology. 7.4

Demonstrate knowledge of how to resolve program

a implementation issues (e.g., debugging, documentation, 7.4 x ongoing

Demonstrate knowledge of software development issues

b (e.g., correctness, reliability, and productivity). 7.4 x ongoing

Demonstrate knowledge of code analysis issues related to

c design, testing, implementation, and maintenance. 7.4 x ongoing

Demonstrate knowledge of how to design and implement

d programs in a top-down manner. 7.4 x ongoing

Demonstrate knowledge of how to translate algorithmic

e and modular design to develop a program. 7.5 x ongoing

f Demonstrate knowledge of structured/modular 7.5 x ongoing

Demonstrate knowledge of how programming control

g structures are used to verify correctness. 7.5 x chap 10

Use code development tools (debugger, integrated

h development environments). 7.5 x chap 1

G Produce (code) a computer application. 7





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 12

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Demonstrate knowledge of basic software systems

5 implementation. 7.5

a Use appropriate programming language. 7.5 x daily

b Analyze and prepare logic using program flowchart. 7.5 x

c Review design (e.g., peer and/or user walkthought). 7.5 x

d Compile and debug code. 7.5 x daily

e Prepare code documentation. 7.6 x

f Prepare unit testing plan. 7.6 x daily

g Conduct unit testing and bug fixes. 7.6 s daily

6 Develop software requirements/specifications. 7.6

Access needed information using company and

manufacturers' references (e.g., procedural manuals,

a documentation standards, work flowcharts). 7.6 x daily

b Divide design specifications into logical process blocks. 7.6 x daily

c Identify parameters. 7.6 x daily

d Follow specifications or drawings. 7.6 x daily

e Record process (e.g., using flowchart, step-by-step 7.7 x

f Record data. 7.7 x

7 Resolve problems with integration if they occur. 7.7

a Troubleshoot unexpected results. 7.7 x daily

b Fix code. 7.7 x daily

H Demonstrate knowledge of software testing. 8

1 Develop test plan. 8.1

a Access needed information using appropriate reference 8.1 x daily

b Define test procedures. 8.1 x

c Analyze requirements and design specifications. 8.1 x

d Develop test cases using requirements and design 8.1 x

2 Perform testing & validation. 8.2

a Perform integration testing. 8.2 x

b Perform regression testing. 8.2 x

c Help with user-acceptance test. 8.2 x

d Validate user documentation. 8.2 x

e Document discovered errors. 8.3 x

3 Document test results. 8.3

a Document errors discovered. 8.3 x

b Perform defect tracking. 8.3 x

4 Develop software testing audit trails. 8.4

a Record error correction procedures and actions. 8.4 x

I Perform quality assurance tasks to produce quality 9

1 Demonstrate knowledge of software quality assurance. 9.1

a Demonstrate knowledge of Software QA process. 9.1 x





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 13

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Demonstrate knowledge of the standards/requirements for

b Software QA. 9.1 x

Develop team relationships to support software quality

c assurance tasks. 9.1 x

Perform software quality assurance tasks to produce a

2 quality software product. 9.2

Identify standards and issues related to I/O programming

a and design of I/O interfaces. 9.2 x

Use customer satisfaction in determining product

b characteristics (e.g., cost, user-friendliness). 9.2 x

Recognize the relationship between dependability,

c functionality, ease of use, etc. 9.2 x

d Conduct code walkthrough and/or inspection. 9.2 x

Follow established procedures for testing, identifying

e problems, and tracking resolutions. 9.3 x

J Perform maintenance and customer support functions. 10

1 Analyze software technical support needs. 10

a Identify maintenance and support requirements. 10 x ongoing

b Apply information and data analysis techniques. 10 x daily

c Define scope of work to meet customer support needs. 10 x

2 Perform customer service. 10

a Access needed information using appropriate reference 10 x Chap 2

Provide help to first line-user support personnel to answer

b user question. 10 x

c Provide troubleshooting for software. 10 x daily

d Perform system-tuning function. 10 x

x

x

e Diagnose problems within system. 10 x

f Perform technical functions required by customer/user. 10

g Communicate and document technical support provided. 10

3 Perform software maintenance activities. 10

Following organizational procedural in communicate and

a document maintenance tasks. 10 x

b Identify and analyze problem. 10 x daily

c Analyze and propose solutions. 10 x daily

d Implement solutions in code and documentation. 10 x daily

Release software and documentation updates according to

e procedures. 10 x as needed









11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 14

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

I ACADEMIC FOUNDATIONS I

II COMMUNICATIONS II

PROBLEM SOLVING AND CRITICAL THINKING

III SKILLS III

IV INFORMATION TECHNOLOGY APPLICATIONS IV

V SYSTEMS V

VI SAFETY, HEALTH AND ENVIRONMENT VI

VII LEADERSHIP AND TEAMWORK VII

VIII ETHICS AND LEGAL RESPONSIBILITY VIII

IX EMPLOYABILITY AND CAREER IX

X TECHNICAL SKILLS X

IX EMPLOYABILITY AND CAREER IX

Information Services

SECTION # 1

CLUSTER FOUNDATIONS

SECTION # 4

CLUSTER FOUNDATION SKILLS

4 3 2 1 N 4 3 2 1 N

I ACADEMIC FOUNDATIONS I

Demonstrate Language Arts knowledge and skills

required to pursue the full-range of career and post-

A secondary education opportunities within the IT career 1

1 List actively. 1.1 x

Adapt language (diction/structure, style) for audience,

2 purpose, situation. 1.2 x

3 Collect/Organize oral and written information. 1.3 x

Compose/edit (agenda, audio-visuals, bibliographies,

drafts, forms/documents, notes, oral presentations, as

4 reports, technical terminology). 1.4 x needed

Comprehend oral and written information

(cause/effect, comparisons/contrasts, conclusions,

context, purpose, charts/tables/graphs, as

5 evaluation/critiques, mood, persuasive text, sequence, 1.5 x needed

Evaluate oral and written information (accuracy,

adequacy/sufficiency, appropriateness, clarity,

conclusions/ solutions, fact/opinion, propaganda, as

6 relevancy, validity, relationship of ideas). 1.6 x needed

Identify (oral and written) assumptions, purpose,

7 outcomes/solutions, and propaganda techniques. 1.7 x

Predict from oral and written information trends,

8 outcomes/solutions. 1.8 x





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 15

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Present form and informal speech, discussion,

9 information requests/supplying, interpretation, 1.9 x

1.1

10 Use library, text and Internet resources. 0 x daily

Demonstrate Mathematics knowledge and skills

required to pursue the full-range of career and post-

B secondary education opportunities within the IT career 2

Identify whole numbers, decimals, fractions, complex

1 numbers, polynomials, geometrical figures. 2.1 x daily

Apply basic arithmetic add, subtract, multiply, and

2 divide operations. 2.2 x daily

Applied relational (equal, not equal, greater than, less

3 than, etc.) and logical expression. 2.3 x daily

Understand the relationship of data and measurements

4 to the problem 2.4 x daily

Produce mathematical formulae, expressions, and/or

5 sequence of solution steps from problem statements. 2.5 x daily

Analyze problem statements for missing/irrelevant

6 data, estimate/exact values, inconsistent parameters. 2.6 x daily

7 Construct charts/tables/graphs from functions and 2.7 x chap 8

Describe problem solving techniques (for example:

8 successive approximation, trial and error). 2.8 x

Demonstrate Science knowledge and skills required to

pursue the full-range of career and post-secondary

C education opportunities within the IT career cluster. 3

Analyze/evaluate conclusions, conflicting data,

controls, data, inferences, limitations, questions,

1 sources of errors, variables. 3.1 x

Use computers for information processing,

2 mathematical applications and problem solving. 3.2 x daily

Apply/use scientific methods in qualitative and

quantitative analysis, data gathering, direct & indirect

3 observation, predictions, problem identification. 3.3 x

II COMMUNICATIONS II

Comprehend and use reading strategies to learn

A meaning, technical concepts, vocabulary, and follow 1

Determine and use reading strategy (skimming,

reading for detail, reading for meaning and critical

1 analysis) to determine purpose of text. 1.1 x

a Use reading strategy to achieve intended purpose. 1.1 x daily

b Identify purpose of text. 1.1 x

c Identify complexity of text. 1.1 x



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 16

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

d Explain purpose of text. 1.1 x

Analyze information, read to learn meaning, technical

2 concepts, vocabulary, and follow directions. 1.2

a Determine relevance, accuracy and appropriateness to 1.2 x daily

b Identify complexities and discrepancies in information. 1.2 x

Analyze information presented in a variety of formats,

c such as tables, lists, figures. 1.2 x chap 5

d Identify key technical concepts and vocabulary. 1.2 x daily

e Follow all instructions as specifically given. 1.3 x daily

Interpret, transcribe and communicate information,

data, and observations to apply information learned

3 from reading to actual practice. 1.3 x daily

a Explain meaning of new terms, vocabulary and concepts. 1.3 x daily

b Interpret technical materials used. 1.3 x daily

c Summarize overall meaning of text. 1.3 x daily

Write specific steps for applying information learned to

d task or new situation. 1.3 x

Write set of directions for others sharing information

e learned and applying that to task or new situation 1.4 x

Locate, organize & reference written information from

various sources to communicate with co-workers &

B clients/participants. 2

Locate written information to communicate with co-

1 workers and clients/participants. 2.1 x

a Identify topic. 2.1 x weekly

Conduct search of information using card catalog,

b keywords, and/or search engines. 2.1 x daily

Locate variety of resources such as books, journals, and

c magazines. 2.1 x daily

d Locate information from electronic forms including the 2.1 x daily

e Organize resources to use key information. 2.2 x daily

Organize information to use in written and oral

2 communications. 2.2

a Read and take notes from selected resources. 2.2 x as needed

b Prepare outline that emphasizes major points with 2.2 x

c Present information in organized, easy-to-follow manner. 2.2 x

Prepare working bibliography according to MLA, APA,

d CBE, Chicago, depending on the warranted language 2.2 x

Document the source and proper reference for written

3 information. 2.3 x

Prepare a bibliography according to MLA, APA, CBE,

a Chicago, depending on the warranted language style. 2.3 x



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 17

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

b Use parenthetical, footnotes and endnotes text citations 2.3 x

c Follow plagiarism and copyright rules and regulations. 2.3 x

Use correct grammar, punctuation and terminology to

C write and edit documents. 3

Compose multi-paragraph writing clearly, succinctly,

1 and accurately to write documents. 3.1 x

a Organize and arrange information for effective coherence. 3.1 x

b Report relevant information in order of occurrence. 3.1 x

c Interpret information, data, and observations correctly. 3.1 x as needed

d Present main ideas and supporting facts. 3.1 x

Use description of audience and purpose to prepare

2 written documents. 3.2

a Use technical terms and concepts. 3.2 x daily

spell

b Incorporate an duse references effectively and accurately. 3.2 correctly

c Report objective and/or subjective information. 3.2

Use correct grammar, spelling, punctuation and as

3 capitalization to prepare written documents. 3.3 x needed

a Use correct grammar and sentence structure. 3.3 x

b Use correct spelling. 3.3 x daily

c Use correct punctuation and capitalization. 3.3 x daily

Use computer skills to design and develop written and as

4 supporting material. 3.4 x needed

Use word processing software to develop text, charts,

a graphs or figures correctly. 3.4 x as needed

b Use presentation software to prepare visual support 3.4 x as needed

Format written documents with correct font and layout for

c easy reading. 3.4 x as needed

Develop and deliver formal and informal presentations

D using appropriate media to engage and inform 4

Prepare oral presentation to provide information for

1 intended purpose and audience. 4.1 x

Know subject matter well enough to be independent of

a written aids. 4.1 x

Identify characteristics of the audience and adjust to their

b ability to understand. 4.1 x

c Use technical terms and concepts correctly. 4.1 x as needed

Use proper organization and structure to achieve

d coherence of major points. 4.1 x

Identify and prepare support materials to accompany

2 oral presentation. 4.2 x





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 18

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Identify media and visual aids appropriate to

a understanding of topic. 4.2 x

Prepare visual aids and support materials for easy viewing

b and without error. 4.2 x

Operate any equipment used with support materials

c smoothly and efficiently. 4.2 x

Deliver presentation to sustain listener's attention and

3 interest. 4.3 x

a Deliver presentation without grammatical error. 4.3 x

Speak clearly with appropriate volume, rate and gestures

b while making and maintaining appropriate eye contact. 4.3 x

Use support materials in the presentation that enhance the

c understanding of the topic and interest level of the 4.3 x

d Stay within presentation time parameters. 4.3 x

e Evaluate listener's interest and receptiveness. 4.4 x

Use verbal and nonverbal feedback strategies to engage

f discussion and adjust message and delivery. 4.4 x

g Respond to questions and comments on presentation. 4.4 x

Interpret verbal and nonverbal behaviors to enhance

E communication with co-workers and 5

1 Interpret verbal behaviors to enhance communication. 5.1 x

a Identify verbal cues. 5.1 x

b Observe voice speed, voice quality and tone. 5.1 x

c Explain message conveyed by verbal behaviors. 5.1 x

2 Interpret nonverbal behaviors to enhance 5.2 x

a Identify nonverbal cues. 5.2 x

Observe eye contact, facial expressions, posture, gestures

b and other body language. 5.2 x

c Explain message conveyed by nonverbal behaviors. 5.2 x

F Apply active listening skills to obtain and clarify 6

1 Interpret message/information given to clarify 6.1 x

a Determine familiarity of discussion. 6.1 x

Respond accordingly using appropriate verbal and non

b verbal language. 6.1 x

c Explain the message given in your own words. 6.1 x

Respond with restatement and clarification techniques

2 to clarify information. 6.2 x

a Ask questions to seek or confirm understanding. 6.2 x

b Paraphrase and/or repeat information. 6.2 x

c Record and summarize information in written notes. 6.2 x

Follow directions and/or respond in a positive way with

d clear, concise comments. 6.2 x



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 19

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Interpret and use tables, charts, and figures to support

G written and oral communications. 7

Develop tables, charts and figures to support written

1 and oral communication. 7.1 x

Compile facts and arrange in an organized manner for a

a table, chart or figure. 7.1 x

b Document sources of data. 7.1 x

Determine most appropriate way to display data for

c effective coherence. 7.1 x

Prepare table, chart, graph or figure for inclusion in

d publication or presentation. 7.1 x

Interpret tables, charts and figures used to support

2 written and oral communication. 7.2 x

a Evaluate reference or source of data for authenticity and 7.2 x

b Explain information presented in table, charts and figures. 7.2 x

Prepare written summary of findings expressed in tables,

c charts and figures. 7.2 x

Demonstrate sensitivity in communicating with a

H diverse workforce. 8

Understand factors and strategies for communicating

1 with a diverse workforce. 8.1 x

Identify (e.g., culture, ethnicity, equity, special/exceptional

a needs) that impact communication. 8.1 x

Identify strategies for successful communication with a

b diverse workforce. 8.1 x

Demonstrate ability to communicate and resolve

2 conflicts with a diverse workforce. 8.2

a Determine communication style appropriate for listener(s). 8.2 x

b Bridge communication styles. 8.2 x

c Establish guidelines for dealing with conflict. 8.2 x

I Conduct meetings 9

1 Plan and schedule meetings. 9.1 x

a Plan meeting. 9.1 x

b Set agenda. 9.1 x

c Schedule meeting. 9.1 x

d Reserve meeting room. 9.1 x

e Invite appropriate personnel. 9.2 x

f Identify need for outside speakers. 9.2 x

g Assign someone to take minutes. 9.2 x

2 Run meetings. 9.2 x

a Make introductions. 9.2 x

b Invite questions, comments, and group participation. 9.2 x



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 20

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Determine appropriate action, time frame, and person

c accountable for identified tasks. 9.2 x

d Monitor time. 9.2 x

e Publish minutes in timely manner. 9.3 x

J Build customer relations. 10

Demonstrate knowledge of organization's offerings

1 and or customers' importance to the organization. 10 x

Identify organizations' products and services (including

a own strengths as a sales agent). 10 x as needed

b Recognize the importance of all customers to the business. 10 x as needed

Demonstrate ability to assist customers in a as

2 professional manner. 10 x needed

a Determine customers' individual needs. 10 x as needed

Project a professional business image (e.g., appearance,

b voice, grammar, word usage, enunciation, nonverbal 10 x as needed

Interact with customers and colleagues in a professional

manner (e.g., prompt, friendly, courteous, respectful,

c helpful, knowledgeable, understandable). 10 x as needed

Effectively use organizational protocols and systems to

3 fulfill customer service requirements. 10 x

a Comply with established business protocols and company 10 x

b Communicate company policies to customers. 10 x

Handle merchandise returns in accordance with customer

c service policy. 10 x

Handle customer complaints in accordance with customer

d service policy. 10 x

Facilitate customer service through the maintenance of key

e information systems. 10 x

Ensure that customer's needs are met and that

4 customer base is maintained. 10 x

Follow through on commitments made to customers (e.g.,

a special orders, delivery specifications, new items). 10 x

b Maintain customer base. 10 x

K Perform scheduling functions to meet customer needs. 11

1 Schedule customer appointments. 11 x

a Create calendars/schedules. 11 x

b Maintain appointment calendars. 11 x

c Process requests for appointments. 11 x

d Verify appointments. 11 x

e Notify customers of changes in schedule. 11 x

f Manage scheduling conflicts. 11 x

2 Document results of customer appointments. 11 x



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 21

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

a Document results. 11 x

PROBLEM SOLVING AND CRITICAL THINKING

III SKILLS III

Guide progress in assigned areas of

A responsibility/accountability. 1 x

1 Set goals. 1.1 x yearly

Set short- and long-term goals for assigned areas of

a responsibility/accountability. 1.1 x yearly

b Demonstrate commitment to establish goals and vision. 1.1 x yearly

2 Monitor and adjust goals. 1.2 x yearly

a Obtain support for goals. 1.2 x as needed

b Provide support for goals. 1.2 x daily

c Monitor goal achievement. 1.2 x as needed

d Adjust goals. 1.2 x as needed

3 Communicate and recognize goal achievement. 1.3

a Communicate goal achievement. 1.3 x

b Provide recognition for goal achievement. 1.3 x

B Conduct technical research. 2

1 Determine audience and information needs. 2.1 x

a Identify target audience. 2.1 x

b Define research questions. 2.1 x

2 Gather information. 2.2 x

a Determine priorities for the information that should be 2.2 x

b Identify potential sources of information. 2.2 x

c Target audience/user group as a key information source. 2.2 x

d Identify subject-matter experts. 2.2 x

Evaluate potential sources of information based on

e established criteria (e.g., affordability, relevance). 2.3 x

f Conduct interviews with selected human information 2.3 x

g Gather information from selected print and electronic 2.3 x

3 Evaluate information. 2.3 x

Determine the accuracy and completeness of the

a information gathered. 2.3 x

C Produce a quality product/service. 3

1 Understand product/service design. 3.1

Design product (e.g., using brainstorming, thumbnail

a sketches, rendering). 3.1 x

Consider customer satisfaction in determining product

characteristics (e.g., usefulness, price, operation, life,

b reliability, safety, cost of operation). 3.1 x

Use reliability factors effectively to plan for and create

2 products/services. 3.2 x



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 22

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

a Consider reliability factors (e.g., cost, human, 3.2 x

Achieve reliability through maintainability, good design,

b design simplification, and design redundancy. 3.2 x

c Recognize the relationship of maintainability and 3.2 x

d Align cost components with quality objectives. 3.2 x

Classify quality costs (e.g., preventive, evolution, pre-

e delivery failures, post-delivery failures). 3.3 x

3 Test and maintain product/services. 3.3 x

a Test products for reliability. 3.3 x

b Initiate predictive maintenance procedures. 3.3 x

Demonstrate knowledge of the process required to

D evaluate and verify the nature of a problem. 4

1 Understand information systems theory and practice. 4.1 x

Demonstrate knowledge of the underlying concepts of the

a information systems discipline. 4.1 x as needed

Demonstrate knowledge of methods for achieving

b productivity in knowledge work. 4.1 x

Apply general systems theory to the analysis and

c development of an information system. 4.1 x as needed

d Identify procedures for formal problem solving. 4.1 x as needed

Demonstrate knowledge of the fundamental concept of

e information theory and organizational system processes. 4.2 x

f Identify the essential properties of information systems. 4.2 x

Demonstrate knowledge of the process required to

E solve a problem. 5 x

Understand information systems problem solving as

1 techniques and approaches. 5.1 x needed

a Demonstrate knowledge of problem-solving steps and 5.1 x as needed

Summarize application planning, development, and risk

b management for information system. 5.1 x

c Identify potential problems in system implementation. 5.1 x as needed

d Demonstrate knowledge of the information analysis 5.1 x

e Demonstrate knowledge of information technology 5.2 x

Demonstrate an ability to evaluate and verify the

F appropriateness of a solution to a problem. 6 x

Evaluate information systems problem solving

1 techniques and approaches. 6.1 x

a Demonstrate knowledge of decision-making skills and 6.1

b Demonstrate knowledge of critical thinking skills and 6.1

Summarize application planning, development, and risk

c management for information system. 6.1

d Identify potential problems in system implementation. 6.1



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 23

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

e Determine whether prototyping system is feasible. 6.2

f Develop a plan using data-oriented techniques. 6.2

g Evaluate systems engineering considerations. 6.2

Determine software design process, from specification to

h implementation. 6.2

i Appraise software process and product life-cycle models. 6.2

6.1

j Assess software design methods and tools. 10

Demonstrate knowledge of information organization

G principles. 7

1 Understand information organization principles. 7.1

Demonstrate knowledge of group support technology for

a common knowledge requirements. 7.1

b Demonstrate knowledge of the information analysis 7.1

c Demonstrate knowledge of information technology 7.1

Demonstrate knowledge of methods for achieving

d productivity in knowledge work. 7.1

H Demonstrate knowledge of design principles. 8

1 Understand and employ design and color principles. 8.1

a Demonstrate knowledge of the two-dimensional picture 8.1

Demonstrate knowledge of the principles and elements of

b design and their relationship to each other. 8.1

Demonstrate knowledge of the nature of color and color

c harmonies. 8.1

Assess the impact of various color harmonies on a two-

d dimensional picture plan. 8.1

Assess how color affects the principles of line, value,

e shape and form. 8.2

IV INFORMATION TECHNOLOGY APPLICATIONS IV

Use Personal Information Management

A (PIM)/Productivity applications. 1

1 Manage personal schedule and contact information. 1.1

Identify PIM applications such as MS Outlook, Lotus

a Notes, and others. 1.1

b Create tasks (to-do) list. 1.1

Manage daily/weekly/monthly schedule using applications

c such as Notes, MS Outlook, etc. 1.1

2 Create memos and notes. 1.2

a Create reminder for oneself. 1.2

Create and send notes, informal memos, reminder using

b PIM applications such as Lotus Notes, MS Outlook, and 1.2

B Use Electronic Mail applications. 2



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 24

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

1 Use email to communicate within and across 2.1

a Access email system using login and password functions. 2.1

b Access email messages received. 2.1

Create e-mail messages in accordance with established

business standards (e.g., grammar, word usage, spelling,

c sentence structure, clarity, e-mail etiquette). 2.1

d Demonstrate knowledge of e-mail etiquette. 2.1

e Send e-mail messages. 2.2

2 Use email to share files and documents. 2.2

a Access email attachments. 2.2

b Attach documents to messages 2.2

c Save e-mail messages/attachments. 2.2

Demonstrate knowledge of contamination protection

d strategies for email. 2.2

C Use Internet Applications. 3

1 Search fro information and resources. 3.1

a Select search engine(s) to use. 3.1

b Select appropriate search procedures and approaches. 3.1

c Locate information using search engine(s) and Boolean 3.1

d Navigate web sites using software functions. 3.1

2 Access and evaluate Internet resources. 3.2

a Access business and technical information using the 3.2

b Access commercial, government, and education resources. 3.2

c Evaluate Internet resources (e.g., accuracy of information). 3.2

D Use Writing/Publishing applications. 4

Prepare simple documents and other business

1 communications. 4.1

a Retrieve existing documents. 4.1

Create documents (e.g., letters, memos, reports) using

b existing forms and templates. 4.1

c Safeguard documents using name and save functions. 4.1

d Format text using basic formatting functions. 4.1

Employ word processing utility tools (e.g., spell checker,

e grammar checker, thesaurus). 4.2

Prepare reports and other business communications,

2 integrating graphics and other non-text elements. 4.2

Use advanced formatting features (e.g.,

a headers/footers/dropped caps, indexing). 4.2

b Place graphics in document. 4.2

Enhance publications using different fonts, styles,

c attributes, justification, etc. 4.2

d Enhance publications using paint/draw functions. 4.2



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 25

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

3 Prepare complex publications. 4.3

a Create new word processing forms, style sheets, and 4.3

b Prepare publications using desktop publishing software. 4.3

c Format new desktop publishing files. 4.3

d Output desktop publishing files. 4.3

E Use Presentation applications. 5

Prepare presentations for training, sales and

1 information sharing. 5.1

Create computer presentation and handouts in accordance

a with basic principles of graphics design and visual 5.1

b Insert graphic elements (e.g., graph, clip art, table) in a 5.1

c Edit presentations. 5.1

2 Deliver presentations, with supporting materials. 5.2

Identify hardware items that support presentation software

a (e.g., scanners, digital cameras, printers, and projection 5.2

b Print a single slide, and entire presentation, an outline, and 5.2

c Run slide shows manually and automatically. 5.2

F Use Spreadsheet applications. 6

1 Create a spreadsheet. 6.1

a Create spreadsheets. 6.1

b Retrieve existing spreadsheets. 6.1

c Edit spreadsheets. 6.1

d Save spreadsheets. 6.1

e Print spreadsheets. 6.2

2 Perform calculations and analysis on data. 6.2

a Group worksheets. 6.2

b Create charts and graphs from spreadsheets. 6.2

c Perform calculations using simple formulas. 6.2

d Input/process data using spreadsheet functions. 6.2

G Use Database applications. 7

1 Manipulate data elements. 7.1

a Enter data using a form. 7.1

b Locate/replace data using search and replace functions. 7.1

Process data using database functions (e.g., structure,

c format, attributes, relationships, keys). 7.1

2 Manage, analyze and report on interrelated data 7.2

a Search a database table to locate records. 7.2

b Sort data using single-and multiple-field sorts. 7.2

c Perform single- and multiple-table queries (e.g., create, 7.2

d Print forms, reports, and results of queries. 7.2

e Verify accuracy of output. 7.3

H Use Collaborative/Groupware applications. 8



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 26

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Facilitate group work through management of shared

1 schedule and contact information. 8.1

a Manage daily/weekly/monthly schedule using 8.1

b Maintain shared database of contact information. 8.1

Facilitate group work through management of shared

2 files and online information. 8.2

a Organize, store, and share files in network directories. 8.2

b Organize, store, and share files using web sites. 8.2

Organize, store, and share files using document libraries or

c databases. 8.2

Facilitate group work through instant messaging or

3 virtual meetings. 8.3

a Participate in virtual group discussions and meetings. 8.3

I Use Computer Operations applications. 9

1 Manage computer operations. 9.1

a Apply basic commands of operating system software. 9.1

b Employ desktop operating skills. 9.1

2 Manage file storage. 9.2

a Apply appropriate file and disk management techniques. 9.2

b Differentiate between files and directories. 9.2

c Determine file organization. 9.2

Demonstrate knowledge of the system utilities used for

d file management. 9.2

3 Compress or alter files. 9.3

a Convert file formats. 9.3

b Unpack files using compression software. 9.3

c Convert existing files. 9.3

Use Computer-based Equipment (containing

embedded computers (or processors) used to control

J electromechanical devices). 10

1 Operate computer driven equipment and machines. 10

a Secure needed supplies and resources. 10

b Follow power-up and log-on procedures. 10

c Interact with/respond to system messages using console 10

d Run applications/jobs in accordance with processing 10

e Follow log-off and power-down procedure(s). 10

2 Use installation and operation manuals. 10

a Access needed information using appropriate reference 10

Troubleshoot computer driven equipment and

3 machines and access support as needed. 10

a Test system using diagnostic tools/software. 10

b Repair/replace malfunctioning hardware. 10



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 27

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

c Reinstall software as needed. 10

d Recover data and/or files. 10

e Restore system to normal operating standards. 10

V SYSTEMS V

A Characterize the nature of business. 1

1 Understand types and functions of businesses. 1.1

a Identify types of business organizations and functions. 1.1

b Identify business reporting and information flow. 1.1

Define stakeholder relationships (e.g., customers,

c employees, shareholders, and suppliers). 1.1

Understand functions and interactions of departments

2 within a business. 1.2

a Demonstrate knowledge of the components of a business 1.2

Identify the ways in which organizational functions are

b interdependent. 1.2

c Identify types of communication channels (e.g., formal, 1.2

d Define the role of strategic planning in business. 1.2

B Demonstrate knowledge of the nature of IT in business. 2

1 Understand the functions of information systems in 2.1

Determine how business activities interface data

a processing functions. 2.1

Differentiate between the role of information systems

b within a company and their role in a global environment. 2.1

Measure increases in productivity realized by the

c implementation of information systems. 2.1

Demonstrate knowledge of the operation of cross-

C functional teams in achieving project goals. 3

Understand the importance of cross-functional teams

1 in achieving IT project goals. 3.1

Consider the benefits of using a cross-functional team

a policy and procedure development. 3.1

b Identify desired group and team behavior in an IS context. 3.1

Explain/discuss general strategies for maximizing

organizational learning and productivity in a high tech

D environment. 4

Understand strategies for maximizing productivity in a

1 high tech environment. 4.1

Assess the importance of new technologies to future

a development and to the future knowledge worker 4.1

Demonstrate knowledge of methods for achieving

b productivity in knowledge work. 4.1

c Create/maintain an environment supportive of 4.1



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 28

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

VI SAFETY, HEALTH AND ENVIRONMENT VI

A Maintain a safe working environment. 1

Understand health and safety standards and concepts

1 in the workplace. 1.1

Demonstrate knowledge of the relationship between

a health, safety, and productivity. 1.1

Identify health and safety standards established by

b government agencies. 1.1

Access needed safety information using company and

manufacturers' references (e.g., procedural manuals,

c documentation, standards, and flowcharts). 1.1

d Ensure maintenance of a clean work area. 1.1

Solve safety problems using problem solving, decision-

e making, and critical thinking strategies. 1.2

f Demonstrate knowledge of ergonomics and repetitive 1.2

VII LEADERSHIP AND TEAMWORK VII

Demonstrate knowledge of the skills needed for

A leadership in the IT environment. 1

Understand key approaches to successful leadership in

1 the IT environment. 1.1

Demonstrate knowledge of how to apply team methods to

a empower coworkers. 1.1

b Establish goals and objectives for IS. 1.1

c Define mission and critical success factors. 1.1

d Identify desired group and team behavior in an IS context. 1.1

Build interpersonal skills with individuals and other

B team members. 2

1 Understand best practices for successful team 2.1

Analyze the interdependence of empathetic listening,

a synergy, and consensus building. 2.1

b Define roles within the group decision-making process. 2.1

Demonstrate knowledge of how to apply team methods to

c empower coworkers. 2.1

2 Apply best practices for successful team functioning. 2.2

Apply knowledge of group dynamics promote teamwork,

a leadership, and empowerment. 2.2

b Promote teamwork, leadership, and empowerment. 2.2

c Identify strategies for fostering creativity. 2.2

VII

VIII ETHICS AND LEGAL RESPONSIBILITY I

Demonstrate appropriate knowledge and behaviors of

A legal responsibilities and of positive cyber-citizenry. 1



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 29

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

1 Understand legal issues faced by IT professionals. 1.1

Demonstrate knowledge of the legal issues that face

a information technology professionals. 1.1

Identify issues and trends affecting computers and

b information privacy. 1.1

Demonstrate knowledge of the rights and

B responsibilities of IT workers. 2

1 Understand the rights and responsibilities of IT 2.1

a Identify generally accepted business ethics. 2.1

Demonstrate knowledge of federal laws governing

b discrimination and harassment. 2.1

Demonstrate knowledge of key concepts related to

c employment discrimination. 2.1

Demonstrate sensitivity to diversity, including differences

in gender, culture, race, language, physical and mental

d challenges, and family structures. 2.1

Establish procedures for maintaining the confidentiality of

e client information. 2.2

Demonstrate knowledge of social, ethical, and legal

C issues in the information technology field. 3

1 Understand ethical issues in the IT field. 3.1

Analyze the social implications of decisions made and

a actions taken as an information technology professional. 3.1

Demonstrate knowledge of the ethical issues that face

b information technology professionals. 3.1

2 Understand legal issues in the IT field. 3.2

Determine the practical implications of lawsuits in terms

of good will, client relations, the bottom line, diversion of

a company resources, cash flow and accounts receivable. 3.2

b Demonstrate knowledge of basic business law concepts. 3.2

IX EMPLOYABILITY AND CAREER IX

Explain written organizational policies, rules and

A procedures to help employees perform their jobs. 1

Locate appropriate information on organizational

1 policies in handbooks and manuals. 1.1

a Identify the contents of various organizational 1.1

Determine the appropriate document (s) for specific job

b responsibilities and work assignments. 1.1

Discuss how specific organizational policies and rules

2 influence a specific work situation. 1.2

Locate and identify specific organizational policy, rule or

a procedure to assist with a given situation. 1.2



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 30

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Articulate how a specific organizational policy, rule or

b procedure will improve a given situation. 1.2

Identify and demonstrate positive work behaviors and

B personal qualities. 2

Demonstrate self-discipline, self-worth, positive

1 attitude, and integrity in a work situation. 2.1

a Demonstrate regular attendance. 2.1

b Follow company dress and appearance standards. 2.1

c Exhibit pride in work. 2.1

d Demonstrate leadership and teamwork. 2.1

Demonstrate flexibility and willingness to learn new

2 knowledge and skills. 2.2

a Exhibit the ability to handle stress. 2.2

b Display initiative and open-mindedness. 2.2

Participate in company orientation and training programs

c with enthusiasm. 2.2

d Identify progressive strategies that will impact efficiency 2.2

3 Exhibit commitment to the organization. 2.3

a Follow established rules, regulations and policies. 2.3

b Explain employer/management responsibilities. 2.3

c Demonstrate cost effectiveness. 2.3

d Demonstrate time management. 2.3

e Complete all tasks thoroughly. 2.4

Identify and explore career opportunities in one or

C more career pathways. 3

Locate and identify career opportunities that appeal to

1 personal career goals. 3.1

Locate and interpret career information for at least one

a career cluster. 3.1

b Identify job requirements for three career pathways. 3.1

Identify educational and credentialing requirements for

c three careers. 3.1

2 Match personal interests and aptitudes to selected 3.2

a Identify personal interests and aptitudes. 3.2

b Identify job requirements and characteristics of selected 3.2

Compare personal interests and aptitudes with job

c requirements and characteristics. 3.2

Modify career goals based on results of personal interests

d and aptitudes with career requirements and characteristics. 3.2

Develop a personal career plan to meet career goals

D and objectives. 4





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 31

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Develop career goal and objectives to plan future

1 career direction. 4.1

a Identify career that matches individual interests and 4.1

b Develop career goal with time frame. 4.1

c Identify goals and objectives for reaching and advancing 4.1

2 Develop strategies to reach career objectives. 4.2

a Write a list of strategies for achieving educational 4.2

b Identify strategies for obtaining employment experiences. 4.2

c Write a time line for achieving career goals and objectives. 4.2

d List alternatives and potential changes. 4.2

E Demonstrate ability to seek and apply for employment. 5

1 Use multiple resources to locate job opportunities. 5.1

a Identify resources for finding employment. 5.1

Analyze resources to determine those that are most

b appropriate for desired career. 5.1

Compare job requirements with personal qualifications,

c interests, and aptitudes. 5.1

Select job that matches personal qualifications, interests,

d and aptitudes. 5.1

2 Prepare a resume and letter of application to apply. 5.2

a Identify respective employer's submission requirements. 5.2

b Gather information and prepare rough draft of resume. 5.2

c Put resume in proper format. 5.2

Write letter of application for specific job opening in

d correct format without error. 5.2

3 Complete an employment application to obtain 5.3

a Gather information for application. 5.3

Complete all questions on application with appropriate

b and honest answers. 5.3

c Sign and date application. 5.3

d Attach any supporting material required or requested. 5.3

e Submit full application package to employers. 5.4

4 Interview to obtain employment. 5.4

a Dress appropriately for interview. 5.4

b Exhibit professional conduct before, during and after 5.4

c Explain your qualifications and interests clearly and 5.4

d Answer all questions honestly and concisely. 5.4

e Write follow-up letter after the interview. 5.5

Demonstrate ability to evaluate and compare

F employment opportunities and accept employment. 6

Evaluate and compare employment opportunity to

1 individual needs and career plan. 6.1



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 32

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

a Identify job advantages and disadvantages. 6.1

b Compare job benefits to individual needs. 6.1

c Compare job opportunities and responsibilities to career 6.1

2 Accept or reject employment. 6.2

a Make decision to accept or reject employment. 6.2

b Write acceptance or rejection letter without error. 6.2

c Complete employment forms upon acceptance. 6.2

Provide examples of how IT is transforming business

G in various industries. 7

1 Understand the impact of IT on business. 7.1

Demonstrate knowledge of how both PCs and larger

computer systems impact people and are used in

a business/industry/government and other institutions. 7.1

Demonstrate knowledge of the impact of computers on

career pathways in business/industry (e.g., how computers

b have eliminated and created jobs). 7.1

Demonstrate knowledge of the impact of computers on

c access to information and information exchange 7.1

Demonstrate knowledge of ethical issues that have

d surfaced in the information age. 7.1

Demonstrate knowledge of the relationship between

H lifelong learning and IT career development. 8

Demonstrate knowledge of IT as a constantly changing

1 and fast growing field. 8.1

a Identify present and future IT employment opportunities. 8.1

Demonstrate knowledge of the potential impact of IT on

b future society. 8.1

c Identify the importance of lifelong learning in the IT field. 8.1

Identify education and training requirements for

2 selected career pathways. 8.2

a Identify certification and/or degree requirements. 8.2

b Identify required knowledge and skills for career ladder. 8.2

Identify education and training opportunities available

3 for selected career pathway. 8.3

a Research educational and training opportunities. 8.3

b Identify present and future IT education and training 8.3

Design a lifelong learning plan that ties in with career

c advancement plan. 8.3

Demonstrate knowledge of career

I development/progression patterns in the IT industry. 9

1 Identify career development patterns in the IT 9.1





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 33

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Identify education and training requirements for IT career

a pathways. 9.1

Identify and understand the benefits of membership in

2 professional IT organizations. 9.2

Identify professional organizations in the area of

a information technology. 9.2

Identify benefits derived from membership in specific

b professional organizations. 9.2

X TECHNICAL SKILLS X

Demonstrate knowledge of the hardware components

A associated with information systems. 1

1 Understand the fundamentals of operating systems. 1.1

a Identify major operating system fundamentals and 1.1

2 Explain the role of number systems in information 1.2

a Identify the role the binary system in information systems. 1.2

Demonstrate knowledge of number systems and internal

b data representation. 1.2

3 Identify computer classifications and hardware. 1.3

Identify the three main classifications of computers (I.e.,

a micro-mid-range, and mainframes). 1.3

b Identify major hardware components and their functions. 1.3

Identify the hardware associated with telecommunications

c functions. 1.3

d Identify types of computer storage devices. 1.3

4 Understand elements and types of information 1.4

Identify the elements of the information processing cycle

a (I.e., input, process, output, and storage). 1.4

Identify types of processing (e.g., batch, interactive, event-

b driven, object-oriented). 1.4

5 Use available reference tools as appropriate. 1.5

Access needed information using company and

manufacturers' references (e.g., procedural manuals,

a documentation, standards, work flowcharts). 1.5

Demonstrate knowledge of the classes of software

B associated with information systems. 2

1 Explain the key functions and applications of software. 2.1

a Demonstrate knowledge of the key functions of systems 2.1

Demonstrate knowledge of widely used software

applications (e.g., word processing, database management,

b spreadsheet development). 2.1

Demonstrate knowledge of the function and operation of

c compilers and interpreters. 2.1



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 34

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Understand the range of languages used in software

2 development. 2.2

Demonstrate knowledge of the range of languages used in

a software development. 2.2

3 Understand how data is organized in software 2.3

Demonstrate knowledge of how data is organized in

a software development. 2.3

4 Explain new and emerging classes of software. 2.4

a Identify new emerging classes of software. 2.4

C Explore the future of information technologies. 3

Explain measurement techniques for increased

1 productivity due to information systems 3.1

Measure increases in productivity realized by the

a implementation of information systems. 3.1

Identify new IT technology and assess their potential

2 importance and impact in the future. 3.2

a Identify new technologies relevant to information 3.2

Assess the importance of new technologies to future

b developments and to future knowledge worker 3.2

Identify new and emerging drivers and inhibitors of

c information technology change. 3.2

Demonstrate knowledge of basic data communications

D components and trends. 4

Explain data communications procedures, equipment

1 and media. 4.1

a Demonstrate knowledge of key communications 4.1

Demonstrate knowledge of the uses of data

b communication equipment. 4.1

c Demonstrate knowledge of types of communications 4.1

2 Understand data transmission codes and protocols. 4.2

a Demonstrate knowledge of data transmission codes and 4.2

Explain the differences between local and wide area

3 networks. 4.3

a Distinguish between local area networks and wide-area 4.3

4 Understand data communications trends and issues. 4.4

a Identify data communication trends. 4.4

b Identify major current issues in data communications. 4.4

E Demonstrate technical knowledge of the Internet. 5

1 Understand Internet protocols. 5.1

Demonstrate knowledge of the Transmission Control

a Protocol/Internet Protocol (TCP/IP) suite. 5.1





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 35

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Demonstrate knowledge of simple Network Management

b Protocol (SNMP). 5.1

Demonstrate knowledge of IP forwarding, encapsulation,

c and fragmentation. 5.1

2 Explain Domain Name Server (DNS). 5.2

a Demonstrate knowledge of the Domain Name Server 5.2

Understand Internet security issues and systems

b available for addressing them. 5.2

c Demonstrate knowledge of Internet Security issues. 5.2

d Identify available Internet security systems. 5.2

F Access the Internet. 6

1 Use and troubleshoot Internet connection. 6.1

a Connect to the Internet. 6.1

b Test Internet connection. 6.1

2 Explain the components of Internet software. 6.2

Demonstrate knowledge of the components of Internet 6.2

a software. 1

3 Install and use Internet software. 6.3

a Explore browser features. 6.3

b Install Internet software. 6.3

Download free software upgrades and shareware from the

c Internet. 6.3

d Unpack files using compression software. 6.3

4 Understand virus protection procedures. 6.4

a Demonstrate acute awareness of virus protection 6.4

G Utilize Internet services. 7

1 Use web browser software. 7.1

Navigate web sites using software functions (e.g.,

a Forward, Back, Go To, Bookmarks). 7.1

b Bookmark web addresses (URLS). 7.1

Apply search procedures to locate information on the

2 Internet. 7.2

a Select search engine(s) to use. 7.2

b Select appropriate search procedures and approaches. 7.2

c Locate information using search engine(s) and Boolean 7.2

3 Obtain, compile and evaluate information from the 7.3

a Access business and technical information using the 7.3

b Access library catalogs on the Internet. 7.3

c Access commercial, government, and education resources. 7.3

Compile a collection of business sites (e.g., finance and

d investment). 7.3

e Evaluate Interpret resources (e.g., accuracy of 7.4



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 36

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

4 Install and download software from the Internet. 7.4

a Download files from FTP archives. 7.4

b Retrieve online tools. 7.4

c Download/convert Internet programming files. 7.4

d Install/configure web browser. 7.4

e Explore the multimedia capabilities of the World Wide 7.5

f Add plug-ins and helpers to the web browser. 7.5

g Archive files. 7.5

5 Use the Internet to communicate and collaborate. 7.5

a Communicate via e-mail using the Internet. 7.5

b Subscribe to mailing lists. 7.5

c Participate in newsgroups. 7.5

d Explore collaboration tools. 7.5

e Participate in online audio and video conferencing. 7.6

f Explore electronic commerce. 7.6

H Install and configure software programs. 8

Ensure that hardware and software system

1 components are compatible prior to performing 8.1

Identify hardware requirements (e.g., processor, memory,

a disk space, communications printers, monitors). 8.1

b Determine compatibility of hardware and software. 8.1

Ensure that software to be installed is licensed prior to

2 performing installation. 8.2

a Verify conformance to licensing agreement. 8.2

Perform installation accurately and completely, using

3 available resources as needed. 8.3

Install given application/system software on various

a platforms in accordance with manufacturer's procedures. 8.3

Disable/uninstall software that may interfere with

b installation of new software. 8.3

Differentiate between procedures for an upgrade and for a

c new installation. 8.3

Differentiate between stand-alone and network installation

d procedures. 8.3

e Select appropriate installation options (e.g., default, 8.4

f Configure software to appropriate operating system 8.4

Configure macros, tools, and packages to accomplish

g simple organizational and personal tasks. 8.4

h Convert data files if required. 8.4

i Verify software installation and operation. 8.4

4 Resolve problems with installation if they occur. 8.4

a Troubleshoot unexpected results. 8.4



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 37

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Access needed help using manufacturers' technical help

b lines or Internet sites. 8.4

c Formulate new installation procedure if needed. 8.4

5 Perform customization as requested. 8.5

a Customize software to meet user preferences. 8.5

6 Clearly document procedures for future use. 8.6

a Document step-by-step installation and configuration 8.6

I Demonstrate knowledge of web page basics. 9

1 Explain the features and functions of web browsing 9.1

Demonstrate knowledge of the role of browsers in reading

a files on the World Wide Web (text-only, hypertext). 9.1

b Identify how different browsers affect the look of a web 9.1

c Demonstrate knowledge of the characteristics and uses of 9.1

Explain the features and functions of web page design

2 software. 9.2

Compare/contrast the features and functions of software

a editors available for designing web pages. 9.2

3 Understand the differences between a client and 9.3

a Differentiate between a client and a server. 9.3

Understand how bandwidth affects data transmission

4 and on-screen image. 9.4

Demonstrate knowledge of how bandwidths affect data

a transmission and on-screen image. 9.4

Explain the benefits of hosting a web site on a local

5 server vs. at an ISP (Internet Service Provider). 9.5

Compare the advantages and disadvantages of running

a your own server vs. using a server provider. 9.5

J Operate system. 10

1 Configure/modify system as needed. 10

a Secure needed supplies and resources. 10

b Review automated scheduling software. 10

c Identify data requirements. 10

d Identify scheduling priority in programming. 10

Build system software command structures using

e operating system macro facilities for computer systems. 10

Apply knowledge of operating systems principles to

2 ensure optimal functioning of system. 10

a Apply basic commands of operating system software. 10

b Apply appropriate file and disk management techniques. 10

c Employ desktop operating skills. 10

d Handle materials and equipment in a responsible manner. 10

e Follow power-up and log-on procedures. 10



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 38

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

f Interact with/respond to system messages using console 10

g Run applications/jobs in accordance with processing 10

h Follow log-off and power-down procedures(s). 10

3 Use available reference tools as appropriate. 10

a Access needed information using appropriate reference 10

4 Document procedures and actions. 10

a Develop audit trails. 10

K Perform standard computer backup procedures. 11

1 Explain the need for regular backup procedures. 11

a Recognize the need for regular backup procedures. 11

2 Configure & maintain backup system. 11

11.

a Load backup software. 21

b Load compression drive backup software. 11

c Install surge suppression protection. 11

d Identify battery backup equipment. 11

e Maintain battery backup system. 11

3 Perform backup procedures. 11

a Perform restore operation using backup software. 11

Perform restore operation using compression drive backup

b software. 11

L Describe system components. 12

1 Understand CPUs. 12

Demonstrate knowledge of central processing unit (CPU)

a control and architecture. 12

b Identify CPU modes of operations. 12

2 Understand operating systems. 12

a Demonstrate knowledge of operating system architecture 12

b Identify operating system goals. 12

Demonstrate knowledge of operating system structuring

c methods, layered models, and the object-server model. 12

Differentiate between microcomputer, minicomputer, and

d mainframe operating systems. 12

e Demonstrate knowledge of network operating systems. 12

f Define the role of memory management in an operating 12

Demonstrate knowledge of the commands used to handle

g tasks in operating systems. 12

h Demonstrate knowledge of interface theory in an 12

3 Understand the fundamentals of operating systems. 12

a Demonstrate knowledge of the basics of process 12

Demonstrate knowledge of the system utilities used for

b file management. 12



11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 39

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

M Maintain security requirements. 13

Understand potential security threats to information

1 systems. 13

Demonstrate knowledge of potential internal and external

a threats to security. 13

2 Assess security threats and develop plan to address. 13

a Maximize threat reduction. 13

b Assess exposure to security issues. 13

c Implement countermeasures. 13

d Ensure compliance with security rules, regulations, and 13

e Demonstrate knowledge of virus protection strategy. 13

f Implement security procedures in accordance with 13

3 Implement and document security procedures. 13

a Maintain confidentiality. 13

b Load virus detection and protection software. 13

c Identify sources of virus infections. 13

1..3

d Remove viruses. 4

e Report viruses in compliance with company standards. 13

f Implement backup and recovery procedures. 13

g Follow disaster plan. 13

Provide for user authentication (e.g., assign passwords,

h access level). 13

i Document security procedures. 13

N Employ computer system interfaces. 14

1 Configure systems to provide optimal system 14

a Define hardware-software interface issues for a computer 14

Identify standards and issues related to I/O programming

b and design of I/O interfaces. 14

Interface peripheral devices/controllers in the computer

system (e.g., software and hardware interrupts, exceptions,

c Direct Memory Addressing [DMA], bus structures). 14

Apply concepts of privileged instructions and protected

e mode programming. 14

Configure peripheral device drivers (e.g., disk, display,

f printer, modem, keyboard, mouse, network). 14

Apply advanced I/O concepts (e.g., disk catching, data

compression, extended memory, magnetic disk/CD-ROM

g storage and formats). 14

h Allocate disk space, non-sharable resources, and I/O 14

O Maintain system. 15





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 40

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Implement queries and reports to provide access to

1 critical system information. 15

a Create a query to extract information from a file. 15

b Create a query to extract information from multiple files. 15

c Create reports from queries. 15

d Create and use logical files. 15

e Develop a display screen for use with high-level language 15

f Access needed information using appropriate reference 15

2 Ensure that system is functioning optimally. 15

a Monitor system status and performance. 15

b Run diagnostics. 15

c Respond to system messages. 15

Perform preventive maintenance procedures on computer

d and peripheral devices. 15

e Handle materials and equipment in a responsible manner. 15

Optimize windows environment to maximize performance

f of desktop resources. 15

g Review automated scheduling software. 15

3 Fix and document system problems. 15

a Fix recoverable problems. 15

b Restore system. 15

c Document computer system malfunction(s). 15

d Document software malfunction(s). 15

P Provide support and training. 16

Provide Help Desk service to computer users within

1 the organization. 16

a Operate help desk. 16

b Employ desktop productivity tools. 16

c Support computer users. 16

2 Provide training. 16

a Train computer users. 16

3 Ensure that network is functioning within 16

a Support Network Operating Center (NOC). 16

Demonstrate knowledge of the operations of Network

b Operating Center (NOC). 16

Demonstrate a basic knowledge of quality assurance

Q concepts. 17

Explain the history and standards of key quality

1 management initiatives. 17

Demonstrate knowledge of the historical evolution of

a quality assurance/total quality management (e.g., Deming, 17





11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 41

GAP ANALYSIS Macomb County

National Cluster: Information Technology

National Pathway: Business, Management, Marketing, and Technology

Michigan Program: Computer Programming/Microsoft Certified Technology Specialist(MCTS)





RATING SCALE:









Secondary Delivery

4 = Exceeds criteria and/or able to teach task

State Standards









Post Secondary

National Codes

3 = Accomplishes task to criteria

Local Task ID

2 = Accomplishes task with help Code/

1 = Exposed to the task Delivery

N = Not exposed to task Point

Demonstrate knowledge of changes brought about by

b quality leaders in the world. 17

c Demonstrate knowledge of the ISO 9000 process. 17

Demonstrate knowledge of the standards/requirements for

d the Baldridge award. 17

Demonstrate knowledge of successful efforts by industry

e to improve quality and/or reduce costs. 17

Explain the terminology, role and benefits of quality

2 within an organization. 17

a Demonstrate knowledge of quality management 17

b Identify the role of quality within the organization. 17

c Identify the features and benefits of quality planning. 17

3 Explain the elements of a quality management system. 17

Demonstrate knowledge of the control devices used in

a functional areas (e.g., SPC, equipment). 17

Demonstrate knowledge of the relationship among

b organizational structures, policies, procedures, and quality 17

c Identify internal and external customers. 17

d Differentiate between prevention and detection. 17

e Differentiate between variable and attribute data. 17

f Identify types of control charts. 17

Demonstrate knowledge of how statistical techniques are

g used to control quality (e.g., SPC, DOE, CR). 17









11/16/2011 C:\Docstoc\Working\pdf\0feb07e4-de76-4245-9dfa-c76ab35d1979.xls 42