2019 – 2020
Florida Department of Education
Curriculum Framework 

Program Title:	Computer Information Data Specialist
Career Cluster:	Information Technology

CCC	
CIP Number	0611050101	
Program Type	College Credit Certificate (CCC)	
Standard Length	9 credit hours	
CTSO	Phi Beta Lambda, BPA 	
SOC Codes (all applicable) 	15-1121 – Computer Systems Analysts	
CTE Program Resources 	http://www.fldoe.org/academics/career-adult-edu/career-tech-edu/program-resources.stml	

Purpose

The purpose of this program is to prepare students for initial employment as a computer systems analyst. This program may also be used to provide supplemental training for persons previously or currently employed in these occupations.

This certificate program is part of the Computer Information Technology AS degree program (1511010307).

A College Credit Certificate consists of a program of instruction of less than sixty (60) credits of college-level courses, which is part of an AS or AAS degree program and prepares students for entry into employment (Rule 6A-14.030, F.A.C.).

This program offers a sequence of courses that provides coherent and rigorous content aligned with challenging academic standards and relevant technical knowledge and skills needed to prepare for further education and careers in the Information Technology career cluster; provides technical skill proficiency, and includes competency-based applied learning that contributes to the academic knowledge, higher-order reasoning and problem-solving skills, work attitudes, general employability skills, technical skills, and occupation-specific skills, and knowledge of all aspects of the Information Technology career cluster. 

The content includes but is not limited to microcomputer oriented operating procedures, software applications packages, and hardware in order to select the appropriate information technology equipment for a particular microcomputer-based work environment; install information technology equipment, troubleshoot information technology equipment, and support information technology users.

Additional Information relevant to this Career and Technical Education (CTE) program is provided at the end of this document

Standards

After successfully completing this program, the student will be able to perform the following:

01.0	Install, configure, upgrade and troubleshoot computer hardware.
02.0	Install, configure and troubleshoot system and device driver software and implement basic security measures.
03.0	Create and maintain a database.
04.0	Demonstrate knowledge of networking technologies.

2019 – 2020
Florida Department of Education
Student Performance Standards

Program Title:	Computer Information Data Specialist
CIP Number:		0611050101
Program Length:	9 credit hours
SOC Code(s):		15-1121

This certificate program is part of the Computer Information Technology AS degree program (1511010307).  At the completion of this program, the student will be able to:	
01.0	Install, configure, upgrade and troubleshoot computer hardware.  The student will be able to:	
01.01	Describe the architecture and operation of a typical computer system.	
01.02	Describe the use of binary numbers to represent instructions and data and the hardware implications. 	
01.03	Identify various coding schemes including ASCII and other data types.	
01.04	Describe and identify motherboards and their components.	
01.05	Describe the features and types of computer form factors, chassis, power supplies and cooling devices.	
01.06	Describe and identify mass storage devices.	
01.07	Distinguish between the different display devices and their characteristics.	
01.08	Summarize the function and types of adapter and interface cards.	
01.09	Construct and configure a computer system from individual components.	
01.10	Perform file and system management tasks.	
01.11	Perform the installation, configuration, optimization, maintenance, and upgrading of printers and other peripheral devices.	
01.12	Troubleshoot new and existing computers and peripheral devices, and document the problems discovered and the solutions implemented.	
01.13	Troubleshoot client-side network connectivity issues using appropriate tools.	
01.14	Identify potential hazards and implement proper safety procedures, including electrostatic discharge (ESD) precautions and professional operational procedures, safe work environment and equipment handling.	
02.0	Install, configure and troubleshoot software system and device driver software and implement basic security measures.  The student will be able to:	
02.01	Describe the various types of device drivers used by operating systems and the utilities used to install, configure, manage, upgrade and troubleshoot system devices.	
02.02	Describe the device and driver installation process.	
02.03	Identify, install, configure, and troubleshoot device drivers.	
02.04	Verify digital signatures of device drivers.	
02.05	Configure driver policies.	
02.06	Describe the security tools and features in operating systems and how to access them to perform a security audit and update.	
02.07	Install, configure and monitor firewalls to block dangerous incoming and outgoing network traffic.	
02.08	Install, configure and monitor anti-virus software.	
02.09	Perform anti-virus and other security scanning activities to prevent the infiltration of spyware and other malicious software.	
02.10	Install, configure and monitor updates, and perform system audits.	
02.11	Install, configure, upgrade, monitor and optimize security measures and policies.	
02.12	Perform preventive maintenance and activity monitoring for computer and network security.	
03.0	Create and maintain a database.  The student will be able to:	
03.01	Define what a database is and describe the components and structures of relational databases.	
03.02	Explain the fundamental concepts of database design.	
03.03	Design a relational database with multiple tables.	
03.04	Determine the appropriate field data type and field size for fields in a table.	
03.05	Create and modify tables, queries, forms and reports.	
03.06	Insert, update, and delete data and records.	
03.07	Create basic table relationships and relate tables in a database.	
03.08	Identify the data elements by which to relate tables.	
03.09	Describe foreign keys and their use when relating tables.	
03.10	Interpret an entity relationship diagram for modeling a database.	
03.11	Describe the purpose of SQL statements.	
03.12	Define, describe and implement a query.	
03.13	Write and implement basic queries formatted for specific output.	
03.14	Retrieve information from a database by using query and filter tools.	
03.15	Describe the use of SELECT statements including the use of various JOIN, SUBQUERIES, and conditional expressions.	
03.16	Describe the advantages of using an index, and implement different types of indexes on tables.	
03.17	Perform basic database maintenance.	
03.18	Monitor and analyze database performance.	
03.19	Backup and restore a database.	
04.0	Demonstrate knowledge of networking technologies.  The student will be able to:	
04.01	Identify the advantages and disadvantages of networked and non-network environments.	
04.02	Describe current networked environments, such as peer-to-peer and client/server.	
04.03	Identify and discuss issues such as security, privacy and redundancy related to networked environments.	
04.04	Identify and discuss issues related to naming conventions for domains, hosts, users, email, and network devices.	
04.05	Differentiate between telecommunications and data communications.	
04.06	List and define the layers in the OSI and TCP/IP network protocol models.	
04.07	Identify and describe current relevant IEEE network standards.	
04.08	Describe and illustrate the typical logical and physical network topologies, and explain the advantages and disadvantages of each topology.	
04.09	Describe the major functions and implementation of LAN hardware protocols such as Ethernet, and identify the physical components currently in use.	
04.10	Describe the LAN software protocols in current use.	
04.11	Discuss the characteristics of IP addresses and MAC addresses, and mapping between protocol addressing schemes.	
04.12	Differentiate between hardware used to implement different network topologies, including bus, ring and star.	
04.13	Identify and describe the current cable technologies, including shielded and unshielded twisted-pair, coaxial, and fiber optic, and their features including bandwidth, performance, plenum characteristics, and interference rejection.	
04.14	Describe current wireless technologies including Wi-Fi, blue tooth, satellite, microwave, radio and infrared.	
04.15	Describe the advantages and disadvantages of wireless and cable technologies, and identify the environments best suited for each technology.	
04.16	Describe the functions and characteristics of network connectivity hardware, included hubs, repeaters, bridges, switches, access units, routers, and gateways.	
04.17	Describe the hardware needed to connect a local area network to a wide area network and the Internet.	
04.18	Compare and contrast major functions and features of current network operating systems, including directory and other services.	
04.19	Describe the major functions of network server hardware and software components.	
04.20	Install and configure a network server, including the installation of network hardware and software.	
04.21	Describe the major functions of network client hardware and software components.	
04.22	Install and configure network client software on multiple computer platforms with support for multiple network protocols.	
04.23	Describe the function of network storage devices and other peripherals, including NAS, SAN, RAID, tape backup, printers, telecommunications devices, scanners, copiers, imaging devices, and document center equipment.	
04.24	Install and configure storage devices and other peripherals with network access.	
04.25	Install, configure, update and troubleshoot network drivers for network hosts and peripherals.	
04.26	
Configure and troubleshoot network protocol stacks.	
04.27	Describe the characteristics of the current wide area network technologies and determine the most suitable WAN technology for a given situation.	

Additional Information

Laboratory Activities

Laboratory investigations that include scientific inquiry, research, measurement, problem solving, emerging technologies, tools and equipment, as well as, experimental, quality, and safety procedures are an integral part of this career and technical program/course. Laboratory investigations benefit all students by developing an understanding of the complexity and ambiguity of empirical work, as well as the skills required to manage, operate, calibrate and troubleshoot equipment/tools used to make observations. Students understand measurement error; and have the skills to aggregate, interpret, and present the resulting data. Equipment and supplies should be provided to enhance hands-on experiences for students.

Career and Technical Student Organization (CTSO)

Phi Beta Lambda and Business Professionals of America (BPA) are the intercurricular career and technical student organizations providing leadership training and reinforcing specific career and technical skills.  Career and Technical Student Organizations provide activities for students as an integral part of the instruction offered.  

Accommodations

Federal and state legislation requires the provision of accommodations for students with disabilities to meet individual needs and ensure equal access. Postsecondary students with disabilities must self-identify, present documentation, request accommodations if needed, and develop a plan with their counselor and/or instructors. Accommodations received in postsecondary education may differ from those received in secondary education. Accommodations change the way the student is instructed. Students with disabilities may need accommodations in such areas as instructional methods and materials, assignments and assessments, time demands and schedules, learning environment, assistive technology and special communication systems. Documentation of the accommodations requested and provided should be maintained in a confidential file.

Articulation

To be transferable statewide between institutions, this program must have been reviewed, and a “transfer value” assigned the curriculum content by the appropriate Statewide Course Numbering System discipline committee.  This does not preclude institutions from developing specific articulation agreements with each other. For details on articulation agreements which correlate to programs and industry certifications refer to http://www.fldoe.org/workforce/dwdframe/artic_frame.asp .

Additional Resources

For additional information regarding articulation agreements, Bright Futures Scholarships, Fine Arts/Practical Arts Credit and Equivalent Mathematics and Equally Rigorous Science Courses please refer to:
http://www.fldoe.org/academics/career-adult-edu/career-tech-edu/program-resources.stml