2014 – 2015
Florida Department of Education
Curriculum Framework 

Program Title:	Database Application Development & Programming
Program Type:	Career Preparatory 
Career Cluster:	Information Technology

Secondary – Career Preparatory	
Program Number	9007300	
CIP Number	0511020315	
Grade Level	9-12, 30, 31	
Standard Length	8 credits	
Teacher Certification	BUS ED  1 @2
COMP SCI  6
COMP PROG 7 G	
CTSO	FBLA 
BPA
SkillsUSA	
SOC Codes (all applicable) 	15-1151 – Computer User Support Specialists
15-1131 – Computer Programmers	
Facility Code	212 http://www.fldoe.org/edfacil/sref.asp (State Requirements for Educational Facilities)	
Targeted Occupation List	http://www.labormarketinfo.com/wec/TargetOccupationList.htm	
Perkins Technical Skill Attainment Inventory	http://www.fldoe.org/workforce/perkins/perkins_resources.asp 	
Industry Certifications	http://www.fldoe.org/workforce/fcpea/default.asp 	
Statewide Articulation	http://www.fldoe.org/workforce/dwdframe/artic_frame.asp 	

Purpose

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 the fundamentals of programming and software development; procedural and object-oriented programming; creating regular and specialized applications using standard and extended Structured Query Language (SQL), including testing, monitoring, debugging, documenting, and maintaining database applications. 

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

Program Structure

This program is a planned sequence of instruction consisting of four occupational completion points, with OCPs A, B, and C comprising the Software Development Core.  Secondary or postsecondary students who have previously completed the Software Development Core will not have to repeat the core.  A student who completes the applicable competencies at any occupational completion point may either continue with the training program or exit as an occupational completer.

The following table illustrates the secondary program structure:

OCP	Course Number	Course Title	Length	SOC Code	Level	
A	8207310	Introduction to Information Technology	1 credit	15-1151	2	
B	9007210
9007220	Foundations of Programming 
Procedural Programming	1 credit
1 credit	15-1131	3
3	
C	9007230	Object-Oriented Programming Fundamentals	1 credit	15-1131	3	
D	9007310
9007320
9007330
9007340	Database Design & SQL Programming
SQL Extension Languages I
SQL Extension Languages II
Custom Database Programming	1 credit
1 credit
1 credit
1 credit	15-1131	3
3
3
3	

Academic Alignment Table

Some or all of the courses in this program have been academically aligned to the Florida Standards for Mathematics and the Next Generation Sunshine State Standards (NGSSS) for Science.  The table below contains the results of the alignment efforts by both academic core and Career and Technical Education (CTE) professional educators.  Data shown in the table includes the number of academic standards in the CTE course and the percentage of alignment to the CTE course.

Courses	Anatomy/ Physiology	Anatomy/ Physiology
Honors	Astronomy     Solar/Galactic Honors	Biology 1	Chemistry 1	Earth-Space Science	Genetics	Environmental Science	Marine Science 1	Marine Science 1 Honors	Physical Science	Physics 1	
Course #1	0/74
0%	0/88
0%	0/80
0%	0/83
0%	0/69
0%	0/69
0%	0/69
0%	0/70
0%	0/62
0%	0/66
0%	0/74
0%	0/72
0%	
Course #2	0/74
0%	0/88
0%	0/80
0%	0/83
0%	0/69
0%	0/69
0%	0/69
0%	0/70
0%	0/62
0%	0/66
0%	0/74
0%	0/72
0%	
Course #3	0/74
0%	0/88
0%	0/80
0%	0/83
0%	0/69
0%	0/69
0%	0/69
0%	0/70
0%	0/62
0%	0/66
0%	0/74
0%	0/72
0%	
**   Alignment pending review    						#   Alignment attempted, but no correlation to academic course

Courses	Algebra 1	Algebra 2	Geometry	English 1	English 2	English 3	English 4	
Course #1	0/67
0%	0/75
0%	0/54
0%	0/49
0%	0/48
0%	0/45
0%	0/45
0%	
Course #2	0/67
0%	0/75
0%	0/54
0%	0/49
0%	0/48
0%	0/45
0%	0/45
0%	
Course #3	0/67
0%	0/75
0%	0/54
0%	0/49
0%	0/48
0%	0/45
0%	0/45
0%	
**   Alignment pending review    			#   Alignment attempted, but no correlation to academic course

Florida Standards for Technical Subjects 

Florida Standards (FS) for English Language Arts and Literacy in History/Social Studies, Science, and Technical Subjects are the critical reading and writing literacy standards designed for grade 6 and above.  These standards are predicated on teachers of history/social studies, science, and technical subjects using their content area expertise to help students meet the particular challenges of reading, writing, speaking, listening, and language in their respective fields.  It is important to note that the 6-12 literacy standards in history/social studies, science, and technical subjects are not meant to replace content standards in those areas but rather to supplement them.

This curriculum framework incorporates the grades 9-10 reading and writing literacy standards in the first two courses of this CTE program and grade 11-12 reading and writing literacy standards in the third and fourth courses of this CTE program.  The standards for Mathematical Practices describe varieties of expertise that educators at all levels should seek to develop in their students.  These practices rest on important “processes and proficiencies” with longstanding importance in mathematics education.  This curriculum framework incorporates the appropriate mathematical practices in the first four courses of this CTE program.  

Florida Standards for Mathematics & Language Arts (FS-M/LA)

Some or all of the courses in this program have been aligned to the Florida Standards for Mathematics and Language Arts used in core academic classes.  Data shown in the framework table (column ‘FS-M/LA’) contains the results of these alignment efforts.

Next Generation Sunshine State Standards (NGSSS) - Science 

Some or all of the courses in this program have been aligned to the Next Generation Sunshine State Standards (NGSSS) for Science. These standards are listed next to the content standards.

Common Career Technical Core – Career Ready Practices

Career Ready Practices describe the career-ready skills that educators should seek to develop in their students.  These practices are not exclusive to a Career Pathway, program of study, discipline or level of education.  Career Ready Practices should be taught and reinforced in all career exploration and preparation programs with increasingly higher levels of complexity and expectation as a student advances through a program of study. 

1. Act as a responsible and contributing citizen and employee. 

2. Apply appropriate academic and technical skills. 

3. Attend to personal health and financial well-being. 

4. Communicate clearly, effectively and with reason. 

5. Consider the environmental, social and economic impacts of decisions. 

6. Demonstrate creativity and innovation. 

7. Employ valid and reliable research strategies. 

8. Utilize critical thinking to make sense of problems and persevere in solving them. 

9. Model integrity, ethical leadership and effective management. 

10. Plan education and career path aligned to personal goals. 

11. Use technology to enhance productivity. 

12. Work productively in teams while using cultural/global competence. 

Standards

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

01.0	Methods and strategies for using Florida Standards for grades 09-10 reading in Technical Subjects for student success in Applied Cybersecurity. 
02.0	Methods and strategies for using Florida Standards for grades 09-10 writing in Technical Subjects for student success in Applied Cybersecurity.
03.0	Methods and strategies for using Florida Standards for grades 09-10 Mathematical Practices in Technical Subjects for student success in Applied Cybersecurity.
04.0	Demonstrate knowledge, skill, and application of information systems to accomplish job objectives and enhance workplace performance.  
05.0	Demonstrate comprehension and communication skills. 
06.0	Use technology to enhance the effectiveness of communication skills.  
07.0	Develop an awareness of management functions and organizational structures as they relate to today’s workplace and employer/employee roles.  
08.0	Practice quality performance in the learning environment and the workplace.  
09.0	Incorporate appropriate leadership and supervision techniques, customer service strategies, and standards of personal ethics to accomplish job objectives and enhance workplace performance.  
10.0	Apply mathematical operations and processes as well as financial planning strategies to commonly occurring situations in the workplace to accomplish job objectives and enhance workplace performance.  
11.0	Assess personal strengths and weaknesses as they relate to job objectives, career exploration, personal development, and life goals.  
12.0	Incorporate knowledge gained from individual assessment and job/career exploration to design an individual career plan that reflects the transition from school to work, lifelong learning, and personal and professional goals. 
13.0	Demonstrate human relations/interpersonal skills appropriate for the workplace. 
14.0	Participate in work-based learning experiences.
15.0	Perform e-mail activities. 
16.0	Demonstrate knowledge of different operating systems.  
17.0	Demonstrate proficiency navigating the internet, intranet, and the WWW.  
18.0	Demonstrate proficiency using HTML commands. 
19.0	Demonstrate proficiency in page design applicable to the WWW. 
20.0	Demonstrate proficiency using specialized web design software. 
21.0	Develop an awareness of the information technology industry. 
22.0	Develop an awareness of microprocessors and digital computers. 
23.0	Develop an awareness of programming languages. 
24.0	Develop an awareness of emerging technologies. 
25.0	Demonstrate an understanding of the seven layers of the Open Systems Interface (OSI) model. 
26.0	Demonstrate proficiency using common software applications. 
27.0	Demonstrate proficiency using specialized software applications
28.0	Demonstrate language arts knowledge and skills.
29.0	Demonstrate mathematics knowledge and skills.
30.0	Demonstrate science knowledge and skills.
01.0	Explore the characteristics, tasks, work attributes, options, and tools associated with a career in software development. 
02.0	Demonstrate an understanding of the characteristics, use, and selection of numerical, non-numerical, and logical data types. 
03.0	Distinguish between iterative and non-iterative program control structures.
04.0	Differentiate among high level, low level, procedural, object-oriented, compiled, interpreted, and translated programming languages.
05.0	Describe the processes, methods, and conventions for software development and maintenance.
06.0	Explain the types, uses, and limitations of testing for ensuring quality control.
07.0	Create a program design document using Unified Modeling Language (UML) or other common design tool.
08.0	Describe information security risks, threats, and strategies associated with software development.
09.0	Use oral and written communication skills in creating, expressing and interpreting information and ideas. 
10.0	Solve problems using critical thinking skills, creativity and innovation. 
11.0	Use information technology tools. 
12.0	Methods and strategies for using Florida Standards for grades 11-12 reading in Technical Subjects for student success in Database Application Development & Programming.
13.0	Methods and strategies for using Florida Standards for grades 11-12 writing in Technical Subjects for student success in Database Application Development & Programming.
14.0	Methods and strategies for using Florida Standards for grades 11-12 Mathematical Practices in Technical Subjects for student success in Database Application Development & Programming.
15.0	Design a computer program to meet specific physical, operational, and interaction criteria.
16.0	Create and document a computer program that uses a variety of internal and control structures for manipulating varied data types.
17.0	Create and document an interactive computer program that employs functions, subroutines, or methods to receive, validate, and process user input.
18.0	Create a unit test plan, implement the plan, and report the results of testing.
19.0	Demonstrate leadership and teamwork skills needed to accomplish team goals and objectives. 
20.0	Describe the importance of professional ethics and legal responsibilities. 
21.0	Explain key concepts that distinguish object-oriented programming from procedural programming. 
22.0	Create a project plan that defines requirements, structural design, time estimates, and testing elements.
23.0	Design, document, and create object-oriented computer programs.
24.0	Design a unit test plan for an object-oriented computer program, test and debug the program, and report the results.
25.0	Develop an awareness of the changes taking place in the information age and how they fit into an evolving society.
26.0	Develop the "big picture" of database design and how to best organize data according to business rules and/or client needs.
27.0	Develop the process of creating an entity by identifying relationships.
28.0	Formulate and assemble initial entity relationship by expanding on modeling concepts.
29.0	Consider the degree and optionality of relationships of entities.
30.0	Demonstrate proficiency in early construction stages of the data modeling process by using unique identifiers and many-to-many (M:M) relationships for building entity relationship diagrams.
31.0	Demonstrate proficiency in advanced data constructs by analyzing business requirements and diagramming entities and relationships. 
32.0	Demonstrate proficiency in designing and adding complexity to an entity-relationship model (ERM).  
33.0	Apply complex ERM information by fine-tuning entities and the process for relating them.
34.0	Apply initial database design and normalization by following the set of house rules that determine how items are stored and retrieved.
35.0	Demonstrate proficiency in the technique of normalization by labeling and organizing all items in a database in such a way as to prevent any confusion or mistakes.
36.0	Demonstrate proficiency in table normalization by combining the techniques of an entity relationship model or a top-down, business approach to data with normalization or a bottom-up mathematical approach to data.
37.0	Apply blueprint principles to begin designing a tool for creating a web-based interface access to a database.
38.0	Extend the logical model presentation model by normalizing the data and mapping the management system.  
39.0	Apply techniques for building a storage management system by creating a website using templates and wizards.
40.0	Demonstrate design and functionality by constructing a group business presentation.  
41.0	Demonstrate comprehension of database modeling competency through group presentation.
42.0	Demonstrate comprehension that the database management software is a system for organizing the storage unit (or database) according to business needs and rules, through data integrity constraints.
43.0	Demonstrate comprehension of aspects of SQL language interface by writing basic SQL statements.
44.0	Demonstrate proficiency working with columns, characters, and rows in SQL.
45.0	Demonstrate proficiency in using SQL comparison operators.
46.0	Demonstrate proficiency in using logical comparisons and precedence rules.
47.0	Demonstrate proficiency using SQL single row functions.
48.0	Demonstrate proficiency displaying data from multiple tables.
49.0	Demonstrate proficiency aggregating data using group functions.
50.0	Demonstrate proficiency utilizing subqueries.
51.0	Demonstrate proficiency producing readable output with SQL language interface, reporting tool, and data manipulation language. 
52.0	Demonstrate proficiency creating and managing database objects.  
53.0	Demonstrate proficiency altering tables and constraints implementing views. 
54.0	Demonstrate mastery of creating and implementing views, synonyms, indexes and other database objects. 
55.0	Demonstrate ability to control user access and SQL language interface and reporting tool. 
56.0	Demonstrate comprehension of bundling features of SQL. 
57.0	Demonstrate comprehension working with composite data types by writing executable script files. 
58.0	Describe the differences between SQL and SQL extension languages. 
59.0	Create program blocks. 
60.0	Use variables in program blocks. 
61.0	Recognize lexical units. 
62.0	Recognize data types. 
63.0	Use scalar data types.
64.0	Use various types of joins. 
65.0	Use SQL group functions and subqueries. 
66.0	Write executable statements. 
67.0	Use nested blocks and variable scope. 
68.0	Use good programming practices. 
69.0	Write DML statements to manipulate data. 
70.0	Retrieve data.
71.0	Manipulate data. 
72.0	Use transaction control statements. 
73.0	Use IF conditional control statements. 
74.0	Use CASE conditional control statements. 
75.0	Use basic LOOP iterative control statements. 
76.0	Use WHILE and FOR loop iterative control statements. 
77.0	Use nested loop iterative control statements. 
78.0	Use explicit cursors. 
79.0	Use explicit cursor attributes. 
80.0	Use cursor FOR loops. 
81.0	Use cursors with parameters. 
82.0	Use cursors for update transactions. 
83.0	Use multiple cursors. 
84.0	Handle exceptions. 
85.0	Trap server exceptions. 
86.0	Trap user-defined exceptions. 
87.0	Create procedures. 
88.0	Use parameters in procedures. 
89.0	Pass parameters. 
90.0	Create stored functions. 
91.0	Use functions in SQL statements. 
92.0	Manage procedures and functions. 
93.0	Manage object privileges. 
94.0	Use invoker’s rights. 
95.0	Create packages. 
96.0	Manage package constructs. 
97.0	Use advanced package concepts. 
98.0	Manage persistent state of package variables. 
99.0	Use vendor-supplied packages. 
100.0	Understand dynamic SQL. 
101.0	Understand triggers. 
102.0	Create DML triggers. 
103.0	Create DDL and database event triggers. 
104.0	Manage triggers. 
105.0	Use large object data types. 
106.0	Manage binary types. 
107.0	Manage indexes. 
108.0	Manage dependencies. 
109.0	Program a database application.
110.0	Utilize the basic concepts of database design.
111.0	Utilize SQL and union queries.
112.0	Implement program statements using objects.
113.0	Utilize debugging tools and write error handlers.
114.0	Demonstrate file I/O.
115.0	Create forms and identify all the properties of a form.
116.0	Manipulate data using object models.
117.0	Develop custom controls.
118.0	Utilize API functions.
119.0	Demonstrate database replication and implement database replication using programming tools.
120.0	Analyze and implement security options.
121.0	Implement client/server applications.
122.0	Optimize the performance of a database.
123.0	Perform application distribution.
124.0	Test and debug databases.
125.0	

2014 – 2015
Florida Department of Education
Student Performance Standards

Course Title: 	Introduction to Information Technology
Course Number: 	8207310
Course Credit:	1

Course Description:

This course is designed to provide an introduction to information technology concepts and careers as well as the impact information technology has on the world, people, and industry and basic web design concepts.  The content includes information technology career research; operating systems and software applications; electronic communications including e-mail and Internet services; basic HTML, DHTML, and XML web commands and design; and emerging technologies and web page design.  After successful completion of Introduction to Information Technology, students will have met Occupational Completion Point A, Information Technology Assistant, SOC Code 15-1151.

Florida Standards	Correlation to CTE Program Standard #	
01.0	Methods and strategies for using Florida Standards for grades 09-10 reading in Technical Subjects for student success in the program in which the BTE Core is associated. 		
01.01	Key Ideas and Details		
01.01.1	Cite specific textual evidence to support analysis of science and technical texts, attending to the precise details of explanations or descriptions.
LAFS.910.RST.1.1		
01.01.2	Determine the central ideas or conclusions of a text; trace the text’s explanation or depiction of a complex process, phenomenon, or concept; provide an accurate summary of the text.
LAFS.910.RST.1.2		
01.01.3	Follow precisely a complex multistep procedure when carrying out experiments, taking measurements, or performing technical tasks, attending to special cases or exceptions defined in the text.
LAFS.910.RST.1.3		
01.02	Craft and Structure		
01.02.1	Determine the meaning of symbols, key terms, and other domain-specific words and phrases as they are used in a specific scientific or technical context relevant to grades 9–10 texts and topics.
LAFS.910.RST.2.4		
01.02.2	Analyze the structure of the relationships among concepts in a text, including relationships among key terms (e.g., force, friction, reaction force, energy).
LAFS.910.RST.2.5		
01.02.3	Analyze the author’s purpose in providing an explanation, describing a procedure, or discussing an experiment in a text, defining the question the author seeks to address.
LAFS.910.RST.2.6		
01.03	Integration of Knowledge and Ideas		
01.03.1	Translate quantitative or technical information expressed in words in a text into visual form (e.g., a table or chart) and translate information expressed visually or mathematically (e.g., in an equation) into words.
LAFS.910.RST.3.7		
01.03.2	Assess the extent to which the reasoning and evidence in a text support the author’s claim or a recommendation for solving a scientific or technical problem.
LAFS.910.RST.3.8		
01.03.3	Compare and contrast findings presented in a text to those from other sources (including their own experiments), noting when the findings support or contradict previous explanations or accounts.
LAFS.910.RST.3.9		
01.04	Range of Reading and Level of Text Complexity		
01.04.1	By the end of grade 9, read and comprehend literature [informational texts, history/social studies texts, science/technical texts] in the grades 9–10 text complexity band proficiently, with scaffolding as needed at the high end of the range.
01.04.2	By the end of grade 10, read and comprehend literature [informational texts, history/social studies texts, science/technical texts] at the high end of the grades 9–10 text complexity band independently and proficiently.
LAFS.910.RST.4.10		
02.0	Methods and strategies for using Florida Standards for grades 09-10 writing in Technical Subjects for student success in the program in which the BTE Core is associated. 		
02.01	Text Types and Purposes		
02.01.1	Write arguments focused on discipline-specific content.
LAFS.910.WHST.1.1		
02.01.2	Write informative/explanatory texts, including the narration of historical events, scientific procedures/experiments, or technical processes.
LAFS.910.WHST.1.2		
02.01.3	Write precise enough descriptions of the step-by-step procedures they use in their investigations or technical work that others can replicate them and (possibly) reach the same results.
LAFS.910.WHST.1.3		
02.02	Production and Distribution of Writing		
02.02.1	Produce clear and coherent writing in which the development, organization, and style are appropriate to task, purpose, and audience.
LAFS.910.WHST.2.4		
02.02.2	Develop and strengthen writing as needed by planning, revising, editing, rewriting, or trying a new approach, focusing on addressing what is most significant for a specific purpose and audience.
LAFS.910.WHST.2.5		
02.02.3	Use technology, including the Internet, to produce, publish, and update individual or shared writing products, taking advantage of technology’s capacity to link to other information and to display information flexibly and dynamically.
LAFS.910.WHST.2.6		
02.03	Research to Build and Present Knowledge		
02.03.1	Conduct short as well as more sustained research projects to answer a question (including a self-generated question) or solve a problem; narrow or broaden the inquiry when appropriate; synthesize multiple sources on the subject, demonstrating understanding of the subject under investigation.
LAFS.910.WHST.3.7		
02.03.2	Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the usefulness of each source in answering the research question; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and following a standard format for citation.
LAFS.910.WHST.3.8		
02.03.3	Draw evidence from informational texts to support analysis, reflection, and research.
LAFS.910.WHST.3.9		
02.04	Range of Writing		
02.04.1	Write routinely over extended time frames (time for reflection and revision) and shorter time frames (a single sitting or a day or two) for a range of discipline-specific tasks, purposes, and audiences.
LAFS.910.WHST.4.10		
03.0	Methods and strategies for using Florida Standards for grades 09-10 Mathematical Practices in Technical Subjects for student success in the program in which the BTE Core is associated.		
03.01	Make sense of problems and persevere in solving them.
MAFS.K12.MP.1.1		
03.02	Reason abstractly and quantitatively.
MAFS.K12.MP.2.1		
03.03	Construct viable arguments and critique the reasoning of others.
MAFS.K12.MP.3.1		
03.04	Model with mathematics.
MAFS.K12.MP.4.1		
03.05	Use appropriate tools strategically.
MAFS.K12.MP.5.1		
03.06	Attend to precision.
MAFS.K12.MP.6.1		
03.07	Look for and make use of structure.
MAFS.K12.MP.7.1		
03.08	Look for and express regularity in repeated reasoning.
MAFS.K12.MP.8.1		

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

Note:  This course is pending alignment in the following categories:  NGSSS-Sci.

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
04.0	Demonstrate knowledge, skill, and application of information systems to accomplish job objectives and enhance workplace performance – the student will be able to:		SC.912.L.14.12, 16, 16.10, 17.11, 13, 15, 16, 19, 20; SC.912.N.1.1, 3, 4, 7, 2.2, 5, 3.5, 4.2, 4	
04.01	Develop keyboarding skills to enter and manipulate text and data.	LAFS.910.SL.2.5, LAFS.1112.SL.2.5, LAFS.910.W.2.6, LAFS.1112.W.2.6, LAFS.910.SL.1.2, LAFS.1112.SL.1.2, LAFS.910.L.1.2,  LAFS.1112.L.1.2		
04.02	Describe and use current and emerging computer technology and software to perform personal and business related tasks.	LAFS.910.SL.1.1,  LAFS.910.SL.1.2,  LAFS.910.SL.1.3, LAFS.910.SL.2.4, LAFS.910.SL.2.5,  LAFS.910.SL.2.6, LAFS.910.W.1.2, LAFS.910.W.2.6, LAFS.1112.SL.1.1,  LAFS.1112.SL.1.2,  LAFS.1112.SL.1.3, LAFS.1112.SL.2.4, LAFS.1112.SL.2.5,  LAFS.1112.SL.2.6, LAFS.1112.W.1.2, LAFS.1112.W.2.6		
04.03	Identify and describe communications and networking systems used in workplace environments.	LAFS.910.RI.2.4, LAFS.1112.RI.2.4, LAFS.910.SL.1.2, LAFS.1112.SL.1.2, LAFS.910.W. 2.4, LAFS.910.W. 2.5, LAFS.910.W. 2.6, LAFS.1112.W. 2.4, LAFS.1112.W. 2.5, LAFS.1112.W. 2.6, LAFS.910.W.3.8, LAFS.1112.W.3.8		
04.04	Use reference materials such as on-line help, vendor bulletin boards, tutorials, and manuals available for application software.	LAFS.910.RI.1.1, LAFS.910.RI.1.2, LAFS.910.RI.1.3, LAFS.910.RI.2.4, LAFS.910.RI.2.5, LAFS.910.RI.2.6, LAFS.910.RI.3.7, LAFS.1112.RI.1.1, LAFS.1112.RI.1.2, LAFS.1112.RI.1.3, LAFS.1112.RI.2.4, LAFS.1112.RI.2.5, LAFS.1112.RI.2.6, LAFS.1112.RI.3.7, LAFS.910.RI.4.10, LAFS.1112.RI.4.10		
04.05	Troubleshoot problems with computer hardware peripherals   and other office equipment.	LAFS.910.SL1.1, LAFS.1112.SL.1.1, LAFS.910.SL.2.5, LAFS.1112.SL.2.5		
04.06	Describe ethical issues and problems associated with computers and information systems.	LAFS.910.RI.4.10, LAFS.1112.RI.4.10, LAFS.910.RI.1.1, LAFS.910.RI.1.2, LAFS.910.RI.1.3, LAFS.1112.RI.1.1, LAFS.1112.RI.1.2, LAFS.1112.RI.1.3, LAFS.910.RI.3.8, LAFS.1112.RI.3.8, LAFS.910.W.3.8, LAFS.1112.W.3.8, LAFS.910.W.1.1, LAFS.1112.W.1.1,  LAFS.910.W.1.2, LAFS.1112.W.1.2,   LAFS.910.SL.1.1,  LAFS.910.SL.1.2,  LAFS.910.SL.1.3, LAFS.910.SL.2.4, LAFS.910.SL.2.5,  LAFS.910.SL.2.6,   LAFS.1112.SL.1.1,  LAFS.1112.SL.1.2,  LAFS.1112.SL.1.3, LAFS.1112.SL.2.4, LAFS.1112.SL.2.5,  LAFS.1112.SL.2.6  		
05.0	Demonstrate comprehension and communication skills – the student will be able to:			
05.01	Use listening, speaking, telecommunication and nonverbal skills and strategies to communicate effectively with supervisors, co-workers, and customers.	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		
05.02	Organize ideas and communicate oral and written messages appropriate for information technology environments.	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
05.03	Collaborate with individuals and teams to complete tasks and solve information technology problems.	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		
05.04	Identify, define, and discuss professional information technology terminology appropriate for internal and external communications in an information technology environment.	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.L. 2.3, 3.4, 3.5, 3.6
LAFS.1112.L 2.3, 3.4, 3.5, 3.6		
05.05	Apply the writing process to the creation of appropriate documents following designated business formats.	LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.L.1.1, 1.2
LAFS.1112.L1.1, 1.2		
05.06	Demonstrate an awareness of project management concepts and tools (e.g., timelines, deadlines, resource allocation, time management, delegation of tasks, collaboration, etc.).	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		
06.0	Use technology to enhance the effectiveness of communication skills – the student will be able to:		SC.912.N.1.1, 4, 2.2, 3.5	
06.01	Use database, spreadsheet, presentation software, scheduling, and integrated software packages to enhance communication.	LAFS.910.RI.4.1
LAFS.910.W.4.1
LAFS.1112.RI.4.1
LAFS.1112.W.4.1
MAFS 912.A-CED.1.1		
06.02	Respond to and utilize information derived from multiple sources (e.g., written documents, instructions, e-mail, voice mail) to solve business problems and complete business tasks.	LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.L.1.1, 1.2
LAFS.1112.L1.1, 1.2		
07.0	Investigate management functions and organizational structures as they relate to today’s workplace and employer/employee roles – the student will be able to:			
07.01	Explore, design, implement, and evaluate organizational structures and cultures. 	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.3.7, 3.8, 4.1
LAFS.1112.W.3.7, 3.8, 4.1		
07.02	Explore and demonstrate an awareness of current trends in business and the employee’s role in maintaining productive business environments in today’s global workplace.	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.3.7, 3.8, 4.1
LAFS.1112.W.3.7, 3.8, 4.1		
07.03	Collaborate with individuals and teams to complete tasks and solve business-related problems and demonstrate initiative, courtesy, loyalty, honesty, cooperation, and punctuality as a team member.	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.3.7, 3.8, 4.1
LAFS.1112.W.3.7, 3.8, 4.1		
08.0	Practice quality performance in the learning environment and the workplace – the student will be able to:			
08.01	Assess personal, peer and group performance and identify and implement strategies for improvement (e.g., organizational skills, note taking/outlining, advance organizers, reasoning skills, problem-solving skills, and decision-making skills).	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.3.7, 3.8, 4.1
LAFS.1112.W.3.7, 3.8, 4.1		
08.02	Develop criteria for assessing products and processes that incorporate effective business practices (e.g., time management, productivity, total quality management).	LAFS.910.SL.1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL1.2, 1.3, 2.4, 2.5, 2.6
		
09.0	Incorporate appropriate leadership and supervision techniques, customer service strategies, and standards of personal ethics to accomplish job objectives and enhance workplace performance – the student will be able to:			
09.01	Demonstrate awareness of the following workplace essentials:  Quality customer service; business ethics; confidentiality of information; copyright violations; accepted workplace rules, regulations, policies, procedures, processes, and workplace safety, and appropriate attire and grooming.	LAFS.910.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
10.0	Apply mathematical operations and processes as well as financial planning strategies to commonly occurring situations in the workplace to accomplish job objectives and enhance workplace performance – the student will be able to:			
10.01	Analyze, interpret, compile, and demonstrate the ability to present/communicate data in understandable and measurable terms using common statistical procedures.	LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W. 4.1
LAFS.1112.W. 4.1
MAFS 912.S-ID.1.1
MAFS.9.12.A-APR.4.6
MAFS.912.A-CED.1.3
MAFS.912.S-MD.2.5 B		
10.02	Use common standards of measurement including the metric system in solving work-related or business problems (e.g., length, weight, currency, time).	LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W. 4.1
LAFS.1112.W. 4.1	SC.912.N.1.5	
10.03	Select and use the correct mathematical processes and tools to solve complex problem situations that are typical of business settings and use formulas when appropriate.	LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W. 4.1
LAFS.1112.W. 4.1
MAFS.912.A-CED.1.1, 1.3, 1.4
MAFS 912.A-REI.2.3		
11.0	Assess personal strengths and weaknesses as they relate to job objectives, career exploration, personal development, and life goals – the student will be able to:			
11.01	Use personal assessment tools to identify personal strengths and weaknesses related to learning and work environments.	LAFS.910.SL.1.2
LAFS.1112.SL.1.2
LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1		
11.02	Analyze job and career requirements and relate career interests to opportunities in the global economy.	LAFS.910.SL.1.2
LAFS.1112.SL.1.2
LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W. 4.1
LAFS.1112.W. 4.1		
12.0	Incorporate knowledge gained from individual assessment and job/career exploration to design an individual career plan that reflects the transition from school to work, lifelong learning, and personal and professional goals – the student will be able to:			
12.01	Research, compare, and contrast information technology career clusters (e.g., characteristics needed, skills required, education required, industry certifications, advantages and disadvantages of information technology careers, the need for information technology workers, etc.).	LAFS.910.SL.1.2
LAFS.1112.SL.1.2
LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
12.02	Describe the variety of occupations and professions within the world of information technology including those where information technology is either in a primary focus or in a supportive role.	LAFS.910.SL.1.2
LAFS.1112.SL.1.2
LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W. 4.1
LAFS.1112.W. 4.1		
12.03	Describe job requirements for the variety of occupations and professions within the global world of information technology. 	LAFS.910.SL.1.2
LAFS.1112.SL.1.2
LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W. 4.1
LAFS.1112.W. 4.1		
12.04	Analyze personal skills and aptitudes in comparison with information technology career opportunities.	LAFS.910.SL.1.2
LAFS.1112.SL.1.2
LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W. 4.1
LAFS.1112.W. 4.1		
12.05	Refine and implement a plan to facilitate personal growth and skill development related to information technology career opportunities.	LAFS.910.SL.1.2
LAFS.1112.SL.1.2
LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W. 4.1
LAFS.1112.W. 4.1		
12.06	Develop and maintain an electronic career portfolio, to include, but not limited to the Resume and Letter of Application. 	LAFS.910.SL.1.2
LAFS.1112.SL.1.2
LAFS.910.RI.4.1 
LAFS.1112.RI. 4.1
LAFS.910.W. 4.1
LAFS.1112.W. 4.1		
13.0	Demonstrate human relations/interpersonal skills appropriate for the workplace – the student will be able to:			
13.01	Accept constructive criticism.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
13.02	Demonstrate personal and interpersonal skills appropriate for the workplace (e.g., responsibility, dependability, punctuality, integrity, positive attitude, initiative, respect for self and others, professional dress, etc.).	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
14.0	Participate in work-based learning experiences – the student will be able to:			
14.01	Participate in work-based learning experiences in an information technology environment.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
14.02	Discuss the use of technology in an information technology environment.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
15.0	Perform e-mail activities – the student will be able to:		SC.912.N.1.1, 4, 3.5, 4.1, 2	
15.01	Describe e-mail capabilities and functions.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.02	Identify components of an e-mail message.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.03	Identify the components of an e-mail address.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.04	Identify when to use different e-mail options.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.05	Attach a file to an e-mail message.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.06	Forward an e-mail message.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.07	Use an address book.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.08	Reply to an e-mail message.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.09	Use the Internet to perform e-mail activities.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.10	Identify the appropriate use of e-mail and demonstrate related e-mail etiquette.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.11	Identify when to include information from an original e-mail message in a response.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
15.12	Identify common problems associated with widespread use of e-mail.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
16.0	Demonstrate knowledge of different operating systems – the student will be able to:			
16.01	Identify operating system file naming conventions.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
16.02	Demonstrate proficiency with file management and structure (e.g., folder creation, file creation, backup, copy, delete, open, save).	LAFS.910.W.4.1
LAFS.1112.W.4.1		
16.03	Demonstrate a working knowledge of standard file formats.	LAFS.910.W.4.1
LAFS.1112.W.4.1		
16.04	Explain the history and purpose of various operating systems (e.g., DOS, Windows, Mac, and Unix/Linux).	LAFS.910.W.4.1
LAFS.1112.W.4.1
LAFS.910.RI.4.1
LAFS.1112.RI.4.1		
17.0	Demonstrate proficiency navigating the internet, intranet, and the WWW – the student will be able to:			
17.01	Identify and describe Web terminology.	LAFS.910.L. 2.3, 3.4, 3.5, 3.6
LAFS.1112.L. 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		
17.02	Demonstrate proficiency in using the basic features of GUI browsers (e.g., setting bookmarks, basic configurations, e-mail configurations, address book).	LAFS.910.L. 2.3, 3.4, 3.5, 3.6
LAFS.1112.L. 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		
17.03	Define Universal Resource Locators (URLs) and associated protocols (e.g., .com, .org, .edu, .gov, .net, .mil).	LAFS.910.L. 2.3, 3.4, 3.5, 3.6
LAFS.1112.L. 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		
17.04	Describe and observe Internet/Intranet ethics and copyright laws and regulatory control.	LAFS.910.L. 2.3, 3.4, 3.5, 3.6
LAFS.1112.L. 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		
17.05	Trace the evolution of the Internet from its inception to the present and into the future.	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
17.06	Demonstrate proficiency using search engines (e.g., Yahoo!, Google).	LAFS.910.L. 2.3, 3.4, 3.5, 3.6
LAFS.1112.L. 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		
17.07	Demonstrate proficiency using various web tools (e.g., downloading of files, transfer of files, telnet, PDF, etc.).	LAFS.910.L. 2.3, 3.4, 3.5, 3.6
LAFS.1112.L. 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		
17.08	Identify effective Boolean search strategies.	LAFS.910.RI.4.1
LAFS.1112.RI.4.1		
18.0	Demonstrate proficiency using HTML commands – the student will be able to:			
18.01	Identify elements of a Web page.	LAFS.910.RL.1.1,1.2,1.3,2.4,2.6,3.7,3.9,4.1
LAFS.1112.RL.1.1,1.2,1.3,2.4,2.6,3.7,3.9,4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.910.L.2.3
LAFS.1112.L.2.3		
18.02	Describe individual Web page layouts and content (e.g., writing for the Web, Web structure).	LAFS.910.RL.1.1,1.2,1.3,2.4,2.6,3.7,3.9,4.1
LAFS.1112.RL.1.1,1.2,1.3,2.4,2.6,3.7,3.9,4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.910.L.2.3
LAFS.1112.L.2.3		
18.03	Define basic HTML terminology.	LAFS.910.RL.1.1,1.2,1.3,2.4,2.6,3.7,3.9,4.1
LAFS.1112.RL.1.1,1.2,1.3,2.4,2.6,3.7,3.9,4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.910.L.2.3
LAFS.1112.L.2.3		
18.04	Analyze HTML source code developed by others.	LAFS.910.RL.1.1,1.2,1.3,2.4,2.6,3.7,3.9,4.1
LAFS.1112.RL.1.1,1.2,1.3,2.4,2.6,3.7,3.9,4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.910.L.2.3
LAFS.1112.L.2.3		
18.05	Create Web pages using basic HTML tags (e.g., links, lists, character styles, text alignment, tables).	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
18.06	Use storyboarding techniques for subsequent Web pages (e.g., linear, hierarchical).	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
18.07	Edit and test HTML documents for accuracy and validity.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
18.08	Use basic functions of WYSIWYG editors.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
18.09	Use basic functions of HTML, DHTML, and XML editors and converters.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
18.10	Enhance web pages through the addition of images and graphics including animation.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
19.0	Demonstrate proficiency in page design applicable to the WWW – the student will be able to:			
19.01	Develop an awareness of acceptable Web page design, including index pages in relation to the rest of the Web site.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
19.02	Describe and apply color theory as it applies to Web page design (e.g., background and text color).	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
19.03	Access and digitize graphics through various resources (e.g., scanner, digital cameras, on-line graphics, clipart, CD-ROMs).	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
19.04	Use image design software to create and edit images.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
19.05	Demonstrate proficiency in publishing to the Internet.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
19.06	Demonstrate proficiency in adding downloadable forms to web pages.	LAFS.910.L. 2.3, 3.4, 3.5, 3.6
LAFS.1112.L 2.3, 3.4, 3.5, 3.6		
19.07	Explain the need for web-based applications.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1		
20.0	Demonstrate proficiency using specialized web design software – the student will be able to:			
20.01	Compare and contrast various specialized web design software (e.g., Flash, Shockwave, GoLive, Director, etc.).	LAFS.910.W.4.1
LAFS.1112.W.4.1
LAFS.910.RI.4.1
LAFS.1112.RI.4.1		
20.02	Demonstrate proficiency using use of various specialized web design software (e.g., Flash, Shockwave, GoLive, Director, etc.).	LAFS.910.W.4.1
LAFS.1112.W.4.1
LAFS.910.RI.4.1
LAFS.1112.RI.4.1		
21.0	Develop an awareness of the information technology industry – the student will be able to:			
21.01	Explain how information technology impacts the operation and management of business and society.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
21.02	Explain the emergence of e-commerce and e-government and the potential impact on business and society.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
21.03	Explain the emergence of a paperless society. 	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
22.0	Develop an awareness of microprocessors and digital computers – the student will be able to:			
22.01	Describe the evolution of the digital computer.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
22.02	Explain the general architecture of a microcomputer system.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
22.03	Explain the evolution of microprocessors.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
22.04	Explain software hierarchy and its impact on microprocessors.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
22.05	Explain the need for and use of peripherals.  	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
22.06	Demonstrate proficiency using peripherals.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
22.07	Identify the basic concepts of computer maintenance and upgrades.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
22.08	Differentiate between diagnosing and troubleshooting.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
23.0	Develop an awareness of programming languages – the student will be able to:			
23.01	Explain the history of programming languages.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
23.02	Explain the need for and use of compilers.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
23.03	Explain how compilers work.	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
23.04	Identify the three types of programming design approaches (e.g., top-down, structured, and object-oriented).	LAFS.910.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.1112.L.1.1, 1.2, 1.3, 2.3, 3.4, 3.5, 3.6
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.1.1,1.2,1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.1112.W.1.1,1.2,1.3, 2.4, 2.5, 2.6,3.7, 3.8, 3.9, 4.1
LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
24.0	Develop an awareness of emerging technologies – the student will be able to:			
24.01	Compare and contrast various methods of evaluation for emerging technologies.	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
		
24.02	Demonstrate knowledge of the process of planning upgrades and changeovers.	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
24.03	Compare and contrast emerging technologies and describe how they impact business in the global marketplace (e.g., wireless, wireless web, cell phones, portables/handhelds, smart appliances, home networks, peer-to-peer, etc.).	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
		
25.0	Demonstrate an understanding of the seven layers of the Open Systems Interface (OSI) model – the student will be able to:			
25.01	Identify how types of networks and how they work.	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
25.02	Identify the role of servers and clients on a network.	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
25.03	Identify benefits and risks of networked computing.	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
25.04	Identify the relationship between computer networks and other communications networks (i.e. telephone systems).	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
25.05	Identify Intranets, Extranets and how they relate to the Internet.	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
25.06	Demonstrate basic understanding of network administration.	LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.4.1
LAFS.1112.W4.1
LAFS.910.L.2.3, 3.4, 3.6
LAFS.1112.L.2.3, 3.4, 3.6		
25.07	Describe the evolution of OSI from its inception to the present and into the future.	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
25.08	Explain the interrelations of the seven layers of the Open Systems Interface (OSI) as it relates to hardware and software.	LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.910.W.4.1
LAFS.1112.W4.1
LAFS.910.L.2.3, 3.4, 3.6
LAFS.1112.L.2.3, 3.4, 3.6		
26.0	Demonstrate proficiency using common software applications – the student will be able to:			
26.01	Compare and contrast the appropriate use of various software applications (e.g., word processing, desktop publishing, graphics design, web browser, e-mail, presentation, database, scheduling, financial management, Java applet, music, etc.).	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1

	SC.912.N.1.1, 3, 4, 6, 7, 3.5, 4.2; SC.912.P.10.18	
26.02	Demonstrate proficiency in the use of various software applications (e.g., word processing, desktop publishing, graphics design, web browser, e-mail, presentation, database, scheduling, financial management, Java applet, music, etc.).	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1	SC.912.N.1.1, 3, 4, 1.7, 3.5;	
27.0	Demonstrate proficiency using specialized software applications – the student will be able to:			
27.01	Compare and contrast the appropriate use of specialized software applications (e.g., OLTP, Computer Aided Design, Computer Aided Manufacturing, 3D animation process control, materials management, etc.).	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
27.02	Demonstrate awareness of specialized software applications (e.g., OLTP, Computer Aided Design, Computer Aided Manufacturing, 3D animation, process control, materials management, etc.)	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1		
27.03	Demonstrate the ability to incorporate digital sound.	LAFS.910.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1 
LAFS.1112.RI.1.1, 1.2, 1.3, 2.4, 2.5, 2.6, 3.7, 3.8, 3.9, 4.1
LAFS.910. SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6
LAFS.1112.SL.1.1, 1.2, 1.3, 2.4, 2.5, 2.6		

2014 – 2015
Florida Department of Education
Student Performance Standards

Course Title:	Foundations of Programming 
Course Number:	9007210
Course Credit:	1

Course Description:

This course introduces concepts, techniques, and processes associated with computer programming and software development.  After successful completion of Programming Foundations and Procedural Programming, students will have met Occupational Completion Point B, Computer Programmer Assistant, SOC Code 15-1131.

Florida Standards	Correlation to CTE Program Standard #	
01.0	Methods and strategies for using Florida Standards for grades 09-10 reading in Technical Subjects for student success in Database Application Development & Programming.		
01.01	Key Ideas and Details		
01.01.1	Cite specific textual evidence to support analysis of science and technical texts, attending to the precise details of explanations or descriptions.
LAFS.910.RST.1.1		
01.01.2	Determine the central ideas or conclusions of a text; trace the text’s explanation or depiction of a complex process, phenomenon, or concept; provide an accurate summary of the text.
LAFS.910.RST.1.2		
01.01.3	Follow precisely a complex multistep procedure when carrying out experiments, taking measurements, or performing technical tasks, attending to special cases or exceptions defined in the text.
LAFS.910.RST.1.3		
01.02	Craft and Structure		
01.02.1	Determine the meaning of symbols, key terms, and other domain-specific words and phrases as they are used in a specific scientific or technical context relevant to grades 9–10 texts and topics.
LAFS.910.RST.2.4		
01.02.2	Analyze the structure of the relationships among concepts in a text, including relationships among key terms (e.g., force, friction, reaction force, energy).
LAFS.910.RST.2.5		
01.02.3	Analyze the author’s purpose in providing an explanation, describing a procedure, or discussing an experiment in a text, defining the question the author seeks to address.
LAFS.910.RST.2.6		
01.03	Integration of Knowledge and Ideas		
01.03.1	Translate quantitative or technical information expressed in words in a text into visual form (e.g., a table or chart) and translate information expressed visually or mathematically (e.g., in an equation) into words.
LAFS.910.RST.3.7		
01.03.2	Assess the extent to which the reasoning and evidence in a text support the author’s claim or a recommendation for solving a scientific or technical problem.
LAFS.910.RST.3.8		
01.03.3	Compare and contrast findings presented in a text to those from other sources (including their own experiments), noting when the findings support or contradict previous explanations or accounts.
LAFS.910.RST.3.9		
01.04	Range of Reading and Level of Text Complexity		
01.04.1	By the end of grade 9, read and comprehend literature [informational texts, history/social studies texts, science/technical texts] in the grades 9–10 text complexity band proficiently, with scaffolding as needed at the high end of the range.
01.04.2	By the end of grade 10, read and comprehend literature [informational texts, history/social studies texts, science/technical texts] at the high end of the grades 9–10 text complexity band independently and proficiently.
LAFS.910.RST.4.10		
02.0	Methods and strategies for using Florida Standards for grades 09-10 writing in Technical Subjects for student success in Database Application Development & Programming.		
02.01	Text Types and Purposes		
02.01.1	Write arguments focused on discipline-specific content.
LAFS.910.WHST.1.1		
02.01.2	Write informative/explanatory texts, including the narration of historical events, scientific procedures/experiments, or technical processes.
LAFS.910.WHST.1.2		
02.01.3	Write precise enough descriptions of the step-by-step procedures they use in their investigations or technical work that others can replicate them and (possibly) reach the same results.
LAFS.910.WHST.1.3		
02.02	Production and Distribution of Writing		
02.02.1	Produce clear and coherent writing in which the development, organization, and style are appropriate to task, purpose, and audience.
LAFS.910.WHST.2.4		
02.02.2	Develop and strengthen writing as needed by planning, revising, editing, rewriting, or trying a new approach, focusing on addressing what is most significant for a specific purpose and audience.
LAFS.910.WHST.2.5		
02.02.3	Use technology, including the Internet, to produce, publish, and update individual or shared writing products, taking advantage of technology’s capacity to link to other information and to display information flexibly and dynamically.
LAFS.910.WHST.2.6		
02.03	Research to Build and Present Knowledge		
02.03.1	Conduct short as well as more sustained research projects to answer a question (including a self-generated question) or solve a problem; narrow or broaden the inquiry when appropriate; synthesize multiple sources on the subject, demonstrating understanding of the subject under investigation.
LAFS.910.WHST.3.7		
02.03.2	Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the usefulness of each source in answering the research question; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and following a standard format for citation.
LAFS.910.WHST.3.8		
02.03.3	Draw evidence from informational texts to support analysis, reflection, and research.
LAFS.910.WHST.3.9		
02.04	Range of Writing		
02.04.1	Write routinely over extended time frames (time for reflection and revision) and shorter time frames (a single sitting or a day or two) for a range of discipline-specific tasks, purposes, and audiences.
LAFS.910.WHST.4.10		
03.0	Methods and strategies for using Florida Standards for grades 09-10 Mathematical Practices in Technical Subjects for student success in Database Application Development & Programming..		
03.01	Make sense of problems and persevere in solving them.
MAFS.K12.MP.1.1		
03.02	Reason abstractly and quantitatively.
MAFS.K12.MP.2.1		
03.03	Construct viable arguments and critique the reasoning of others.
MAFS.K12.MP.3.1		
03.04	Model with mathematics.
MAFS.K12.MP.4.1		
03.05	Use appropriate tools strategically.
MAFS.K12.MP.5.1		
03.06	Attend to precision.
MAFS.K12.MP.6.1		
03.07	Look for and make use of structure.
MAFS.K12.MP.7.1		
03.08	Look for and express regularity in repeated reasoning.
MAFS.K12.MP.8.1		

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
31.0	Explore the characteristics, tasks, work attributes, options, and tools associated with a career in software development. – The student will be able to:			
31.01	Describe the evolution of programming and programming careers.  			
31.02	Identify tasks performed by programmers.			
31.03	Describe how businesses use computer programming to solve business problems.			
31.04	Investigate job opportunities in the programming field.			
31.05	Explain different specializations and the related training in the computer programming field.			
31.06	Explain the need for continuing education and training of computer programmers.			
31.07	Explain enterprise software systems and how they impact business.			
31.08	Describe ethical responsibilities of computer programmers.			
31.09	Describe the role of customer support to software program quality.			
31.10	Identify credentials and certifications that may improve employability for a computer programmer.			
31.11	Identify devices, tools, and other environments for which programmers may develop software.			
32.0	Demonstrate an understanding of the characteristics, use, and selection of numerical, non-numerical, and logical data types. – The student will be able to:			
32.01	Identify the characteristics (e.g., size, limits) and uses of different numerical and non-numerical data types.			
32.02	Explain the types and uses of variables in programs.			
32.03	Determine the best data type to use for given programming problems.			
32.04	Identify the types of operations that can be performed on different data types.			
32.05	Evaluate arithmetic and logical expressions using appropriate operator precedence.			
32.06	Explain how computers store different data types in memory.			
32.07	Demonstrate the difference between "data" and "information".			
32.08	Use different number systems to represent data.	MAFS.912.N-Q.1.1		
32.09	Explain how national and international standards (i.e., ASCII, UNICODE) are used to represent non-numerical data.			
32.10	Use Boolean logic to perform logical operations.			
33.0	Distinguish between iterative and non-iterative program control structures–The student will be able to:			
33.01	Explain non-iterative programming structures (e.g., if, if/else and their uses.			
33.02	Explain iterative programming structures (e.g., while, do/while) and their uses.			
34.0	Differentiate among high level, low level, procedural, object-oriented, compiled, interpreted, and translated programming languages. – The student will be able to:			
34.01	Identify the characteristics, uses, and limits of low-level programming languages.			
34.02	Identify the characteristics, uses, and limits of high-level programming languages.			
34.03	Identify the characteristics, uses, and limits of rapid development programming languages.			
34.04	Describe object-oriented concepts.			
34.05	Explain the characteristics of procedural and object-oriented programming languages.			
34.06	Compare and contrast programming languages that are compiled (e.g., C++), interpreted (e.g., Basic, HTML), and translated (e.g., Java).			
35.0	Describe the processes, methods, and conventions for software development and maintenance. – The student will be able to:			
35.01	Describe and explain tools used in software development.			
35.02	Describe the stages of the program life cycle.			
35.03	Compare and contrast alternatives methods of program development (e.g., rapid prototyping, waterfall).			
35.04	List and explain the steps in the program development cycle.			
35.05	Describe different types of documentation used in the program development cycle (e.g., requirements document, program design documents, test plans).			
35.06	Describe the on-going need for program maintenance.			
35.07	Describe different methods companies use to facilitate program updates for enhancements and defects (e.g., how customers receive patches, updates, new versions, upgrades).			
35.08	Describe different methods used to facilitate version control and change management.			
36.0	Explain the types, uses, and limitations of testing for ensuring quality control. – The student will be able to:			
36.01	Explain the uses and limits of testing in ensuring program quality.		SC.912.N.1.1	
36.02	Explain testing performed at different stages of the program development cycle (e.g. unit testing, system testing, user acceptance testing).			
36.03	Describe data and the use of test plans/scripts to be used in program testing.		SC.912.N.1.1	
36.04	Describe and identify types of programming errors (e.g., syntactical, logic, usability, requirements mismatch).			
36.05	Identify the data to be used for boundary conditions.			
36.06	Explain different types of testing (e.g., usability, automated, regression) and testing tools.		SC.912.N.1.1	
37.0	Create a program design document using Unified Modeling Language (UML) or other common design tool. – The student will be able to:			
37.01	Describe different design methodologies and their uses (e.g., object-oriented design, structured design, and rapid application development).		SC.912.N.1.1, 
SC.912.N.3.5	
37.02	Describe tools for developing a program design (e.g., UML, flowcharts, design documents, pseudocode).		SC.912.N.1.1	
37.03	Explain the role of existing libraries and packages in facilitating programmer productivity.			
37.04	Participate and contribute to a design review of a program design developed using a common program design tool (e.g., UML, flowcharts, design documents, pseudocode).		SC.912.N.1.1,
SC.912.N.1.3,
SC.912.N.2.4,
SC.912.N.4.2	
37.05	Write a program design document using UML or other standard design methodology.			
37.06	Define input and output for a program module using UML or other standard design methodology.			
38.0	Describe information security risks, threats, and strategies associated with software development. – The student will be able to:			
38.01	Explain the security risks to personal and business computer users.			
38.02	Identify different types of threats to computer systems.			
38.03	Identify methods to protect against different threats to computer systems.			
38.04	Understand the importance of a disaster/emergency response plan.			
38.05	Identify alternative methods for data storage and backup (e.g., mirroring, fail-over, high availability, types of backups).			
39.0	Use oral and written communication skills in creating, expressing and interpreting information and ideas. – The student will be able to:			
39.01	Select and employ appropriate communication concepts and strategies to enhance oral and written communication in the workplace.		SC.912.N.1.9,
SC.912.N.1.10	
39.02	Locate, organize and reference written information from various sources.		SC.912.N.1.1.6	
39.03	Design, develop and deliver formal and informal presentations using appropriate media to engage and inform diverse audiences.		SC.912.N.1.1.9,
SC.912.N.1.1.10	
39.04	Interpret verbal and nonverbal cues/behaviors that enhance communication.		SC.912.N.1.1.5,
SC.912.N.1.1.6,
SC.912.N.1.1.8	
39.05	Apply active listening skills to obtain and clarify information.			
39.06	Develop and interpret tables and charts to support written and oral communications.	MAFS.912.F-IF.3.9	SC.912.N.1.1.6-11	
39.07	Exhibit public relations skills that aid in achieving customer satisfaction.			
40.0	Solve problems using critical thinking skills, creativity and innovation. – The student will be able to:			
40.01	Employ critical thinking skills independently and in teams to solve problems and make decisions.		SC.912.N.1.1	
40.02	Employ critical thinking and interpersonal skills to resolve conflicts.		SC.912.N.1.3,
SC.912.N.4.1	
40.03	Identify and document workplace performance goals and monitor progress toward those goals. 			
40.04	Conduct technical research to gather information necessary for decision-making.		SC.912.N.1.3,
SC.912.N.1.1.5	
41.0	Use information technology tools. – The student will be able to:			
41.01	Use personal information management (PIM) applications to increase workplace efficiency.			
41.02	Employ technological tools to expedite workflow including word processing, databases, reports, spreadsheets, multimedia presentations, electronic calendar, contacts, email, and internet applications.			
41.03	Employ computer operations applications to access, create, manage, integrate, and store information.			
41.04	Employ collaborative/groupware applications to facilitate group work.			

2014 – 2015
Florida Department of Education
Student Performance Standards

Course Title:	Procedural Programming
Course Number:	9007220
Course Credit:	1

Course Description:

This course continues the study of computer programming concepts with a focus on the creation of software applications employing procedural programming techniques.  After successful completion of Programming Foundations and Procedural Programming, students will have met Occupational Completion Point B, Computer Programmer Assistant, SOC Code 15-1131.

Florida Standards	Correlation to CTE Program Standard #	
42.0	Methods and strategies for using Florida Standards for grades 11-12 reading in Technical Subjects for student success in Database Application Development & Programming.		
42.01	Key Ideas and Details		
42.01.1	Cite specific textual evidence to support analysis of science and technical texts, attending to important distinctions the author makes and to any gaps or inconsistencies in the account.
LAFS.1112.RST.1.1		
42.01.2	Determine the central ideas or conclusions of a text; trace the text’s explanation or depiction of a complex process, phenomenon, or concept; provide an accurate summary of the text.
LAFS.1112.RST.1.2		
42.01.3	Follow precisely a complex multistep procedure when carrying out experiments, taking measurements, or performing technical tasks, attending to special cases or exceptions defined in the text.
LAFS.1112.RST.1.3		
42.02	Craft and Structure		
42.02.1	Determine the meaning of symbols key terms, and other domain-specific words and phrases as they are used in a specific scientific or technical context relevant to grades 11–12 texts and topics.
LAFS.1112.RST.2.4		
42.02.2	Analyze how the text structures information or ideas into categories or hierarchies, demonstrating understanding of the information or ideas.
LAFS.1112.RST.2.5		
42.02.3	Analyze the author’s purpose in providing an explanation, describing a procedure, or discussing an experiment in a text, identifying important issues that remain unresolved.
LAFS.1112.RST.2.6		
42.03	Integration of Knowledge and Ideas		
42.03.1	Integrate and evaluate multiple sources of information presented in diverse formats and media (e.g. quantitative data, video, multimedia) in order to address a question or solve a problem.
LAFS.1112.RST.3.7		
42.03.2	Evaluate the hypotheses, data, analysis, and conclusions in a science or technical text, verifying the data when possible and corroborating or challenging conclusions with other sources of information.
LAFS.1112.RST.3.8		
42.03.3	Synthesize information from a range of sources (e.g., texts, experiments, simulations) into a coherent understanding of a process, phenomenon, or concept, resolving conflicting information when possible.
LAFS.1112.RST.3.9		
42.04	Range of Reading and Level of Text Complexity		
42.04.1	By the end of grade 11, read and comprehend literature [informational texts, history/social studies texts, science/technical texts] in the grades 11–CCR text complexity band proficiently, with scaffolding as needed at the high end of the range.
42.04.2	By the end of grade 12, read and comprehend literature [informational texts, history/social studies texts, science/technical texts] at the high end of the grades 11–CCR text complexity band independently and proficiently.
LAFS.1112.RST.4.10		
43.0	Methods and strategies for using Florida Standards for grades 11-12 writing in Technical Subjects for student success in Database Application Development & Programming.		
43.01	Text Types and Purposes		
43.01.1	Write arguments focused on discipline-specific content.
LAFS.1112.WHST.1.1		
43.01.2	Write informative/explanatory texts, including the narration of historical events, scientific procedures/experiments, or technical processes.
LAFS.1112.WHST.1.2		
43.01.3	Write precise enough descriptions of the step-by-step procedures they use in their investigations or technical work that others can replicate them and (possibly) reach the same results.
LAFS.1112.WHST.1.3		
43.02	Production and Distribution of Writing		
43.02.1	Produce clear and coherent writing in which the development, organization, and style are appropriate to task, purpose, and audience.
LAFS.1112.WHST.2.4		
43.02.2	Develop and strengthen writing as needed by planning, revising, editing, rewriting, or trying a new approach, focusing on addressing what is most significant for a specific purpose and audience.
LAFS.1112.WHST.2.5		
43.02.3	Use technology, including the Internet, to produce, publish, and update individual or shared writing products in response to ongoing feedback, including new arguments or information.
LAFS.1112.WHST.2.6		
43.03	Research to Build and Present Knowledge		
43.03.1	Conduct short as well as more sustained research projects to answer a question (including a self-generated question) or solve a problem; narrow or broaden the inquiry when appropriate; synthesize multiple sources on the subject, demonstrating understanding of the subject under investigation.
LAFS.1112.WHST.3.7		
43.03.2	Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the strengths and limitations of each source in terms of the specific task, purpose, and audience; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and overreliance on any one source and following a standard format for citation.
LAFS.1112.WHST.3.8		
43.03.3	Draw evidence from informational texts to support analysis, reflection, and research.
LAFS.1112.WHST.3.9		
43.04	Range of Writing		
43.04.1	Write routinely over extended time frames (time for reflection and revision) and shorter time frames (a single sitting or a day or two) for a range of discipline-specific tasks, purposes, and audiences.
LAFS.1112.WHST.4.10		
44.0	Methods and strategies for using Florida Standards for grades 11-12 Mathematical Practices in Technical Subjects for student success in Database Application Development & Programming.		
44.01	Make sense of problems and persevere in solving them.
MAFS.K12.MP.1.1		
44.02	Reason abstractly and quantitatively.
MAFS.K12.MP.2.1		
44.03	Construct viable arguments and critique the reasoning of others.
MAFS.K12.MP.3.1		
44.04	Model with mathematics.
MAFS.K12.MP.4.1		
44.05	Use appropriate tools strategically.
MAFS.K12.MP.5.1		
44.06	Attend to precision.
MAFS.K12.MP.6.1		
44.07	Look for and make use of structure.
MAFS.K12.MP.7.1		
44.08	Look for and express regularity in repeated reasoning.
MAFS.K12.MP.8.1		

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
45.0	Design a computer program to meet specific physical, operational, and interaction criteria. – The student will be able to:			
45.01	Choose appropriate data types depending on the needs of the program.			
45.02	Define appropriate user interface prompts for clarity and usability (e.g., user guidance for data ranges, data types).			
45.03	Design and develop program that are designed for efficiency (e.g., less memory usage, less inputs/outputs, faster processing).			
45.04	Identify the software environment required for a program to run (e.g., operating system required, mobile, Web-based, desktop, delivery method).			
45.05	Identify the tools required to develop a program (e.g., editors, compilers, linkers, integrated development environments, application programming interfaces (APIs), libraries). 			
46.0	Create and document a computer program that uses a variety of internal and control structures for manipulating varied data types. – The student will be able to:			
46.01	Use appropriate naming conventions to define program variables and modules (methods, functions).			
46.02	Use a program editor to write the source code for a program.			
46.03	Write programs that use selection structures (e.g., if, if/else).			
46.04	Write programs that use repetition structures (e.g., while, do/while).			
46.05	Write programs that use nested structures.			
46.06	Use internal documentation (e.g., single-line and multi-line comments, program headers, module descriptions, meaningful variable and function/module names) to document a program according to accepted standards.			
46.07	Compile and run programs.			
46.08	Write programs that use standard arithmetic operators with different numerical data types.	MAFS.912.N-Q.1.1,
MAFS.912.A-REI.1.2,
MAFS.912.A-REI.2.3		
46.09	Write programs that use standard logic operators.	 		
46.10	Write programs that use a variety of common data types.	MAFS.912.N-Q.1.1,
MAFS.912.A-REI.1.2,
MAFS.912.A-REI.2.3		
46.11	Write programs that perform data conversion between standard data types.			
46.12	Write programs that define, use, search, and sort arrays.			
46.13	Write programs that use user-defined data types.			
46.14	Demonstrate understanding and use of appropriate variable scope.			
47.0	Create and document an interactive computer program that employs functions, subroutines, or methods to receive, validate, and process user input. – The student will be able to:			
47.01	Write programs that perform user input and output.			
47.02	Write programs that validate user input (e.g., range checking, data formats, valid/invalid characters).			
47.03	Write program modules such as functions, subroutines, or methods.			
47.04	Write program modules that accept arguments.			
47.05	Write program modules that return values.			
47.06	Write program modules that validate arguments and return error codes.			
47.07	Write interactive programs.			
47.08	Write programs that use standard libraries to enhance program function.			
47.09	Participate in a peer code review to verify program functionality, programming styles, program usability, and adherence to common programming standards.			
48.0	Create a unit test plan, implement the plan, and report the results of testing. – The student will be able to:			
48.01	Write a unit test plan that identifies the input data and expected results for program tests.		SC.912.N.1.1	
48.02	Test and debug programs, including programs written by others.			
48.03	Write a test report that identifies the results of testing.		SC.912.N.1.1	
48.04	Trace through the function of a program to ensure valid operation.			
48.05	Identify the system resources used by the program (e.g., memory, disk space, execution time, external devices). 	MAFS.912.N-Q.1.2		
48.06	Create a disaster/emergency response plan for a computer system. 			
49.0	Demonstrate leadership and teamwork skills needed to accomplish team goals and objectives. – The student will be able to:			
49.01	Employ leadership skills to accomplish organizational goals and objectives.			
49.02	Establish and maintain effective working relationships with others in order to accomplish objectives and tasks.			
49.03	Conduct and participate in meetings to accomplish work tasks.			
50.0	Describe the importance of professional ethics and legal responsibilities. – The student will be able to:			
50.01	Evaluate and justify decisions based on ethical reasoning.			
50.02	Evaluate alternative responses to workplace situations based on personal, professional, ethical, legal responsibilities, and employer policies.			
50.03	Identify and explain personal and long-term consequences of unethical or illegal behaviors in the workplace.			

2014 – 2015
Florida Department of Education
Student Performance Standards

Course Title:	Object-Oriented Programming Fundamentals
Course Number:	9007230
Course Credit:	1

Course Description:

This course continues the study of computer programming concepts with a focus on the creation of software applications employing object-oriented programming techniques.  After successful completion of Object-Oriented Programming, students will have met Occupational Completion Point C, Computer Programmer, SOC Code 15-1131.

Florida Standards	Correlation to CTE Program Standard #	
42.0	Methods and strategies for using Florida Standards for grades 11-12 reading in Technical Subjects for student success in Database Application Development & Programming.		
42.01	Key Ideas and Details		
42.01.1	Cite specific textual evidence to support analysis of science and technical texts, attending to important distinctions the author makes and to any gaps or inconsistencies in the account.
LAFS.1112.RST.1.1		
42.01.2	Determine the central ideas or conclusions of a text; trace the text’s explanation or depiction of a complex process, phenomenon, or concept; provide an accurate summary of the text.
LAFS.1112.RST.1.2		
42.01.3	Follow precisely a complex multistep procedure when carrying out experiments, taking measurements, or performing technical tasks, attending to special cases or exceptions defined in the text.
LAFS.1112.RST.1.3		
42.02	Craft and Structure		
42.02.1	Determine the meaning of symbols key terms, and other domain-specific words and phrases as they are used in a specific scientific or technical context relevant to grades 11–12 texts and topics.
LAFS.1112.RST.2.4		
42.02.2	Analyze how the text structures information or ideas into categories or hierarchies, demonstrating understanding of the information or ideas.
LAFS.1112.RST.2.5		
42.02.3	Analyze the author’s purpose in providing an explanation, describing a procedure, or discussing an experiment in a text, identifying important issues that remain unresolved.
LAFS.1112.RST.2.6		
42.03	Integration of Knowledge and Ideas		
42.03.1	Integrate and evaluate multiple sources of information presented in diverse formats and media (e.g. quantitative data, video, multimedia) in order to address a question or solve a problem.
LAFS.1112.RST.3.7		
42.03.2	Evaluate the hypotheses, data, analysis, and conclusions in a science or technical text, verifying the data when possible and corroborating or challenging conclusions with other sources of information.
LAFS.1112.RST.3.8		
42.03.3	Synthesize information from a range of sources (e.g., texts, experiments, simulations) into a coherent understanding of a process, phenomenon, or concept, resolving conflicting information when possible.
LAFS.1112.RST.3.9		
42.04	Range of Reading and Level of Text Complexity		
42.04.1	By the end of grade 11, read and comprehend literature [informational texts, history/social studies texts, science/technical texts] in the grades 11–CCR text complexity band proficiently, with scaffolding as needed at the high end of the range.
42.04.2	By the end of grade 12, read and comprehend literature [informational texts, history/social studies texts, science/technical texts] at the high end of the grades 11–CCR text complexity band independently and proficiently.
LAFS.1112.RST.4.10		
43.0	Methods and strategies for using Florida Standards for grades 11-12 writing in Technical Subjects for student success in Database Application Development & Programming.		
43.01	Text Types and Purposes		
43.01.1	Write arguments focused on discipline-specific content.
LAFS.1112.WHST.1.1		
43.01.2	Write informative/explanatory texts, including the narration of historical events, scientific procedures/experiments, or technical processes.
LAFS.1112.WHST.1.2		
43.01.3	Write precise enough descriptions of the step-by-step procedures they use in their investigations or technical work that others can replicate them and (possibly) reach the same results.
LAFS.1112.WHST.1.3		
43.02	Production and Distribution of Writing		
43.02.1	Produce clear and coherent writing in which the development, organization, and style are appropriate to task, purpose, and audience.
LAFS.1112.WHST.2.4		
43.02.2	Develop and strengthen writing as needed by planning, revising, editing, rewriting, or trying a new approach, focusing on addressing what is most significant for a specific purpose and audience.
LAFS.1112.WHST.2.5		
43.02.3	Use technology, including the Internet, to produce, publish, and update individual or shared writing products in response to ongoing feedback, including new arguments or information.
LAFS.1112.WHST.2.6		
43.03	Research to Build and Present Knowledge		
43.03.1	Conduct short as well as more sustained research projects to answer a question (including a self-generated question) or solve a problem; narrow or broaden the inquiry when appropriate; synthesize multiple sources on the subject, demonstrating understanding of the subject under investigation.
LAFS.1112.WHST.3.7		
43.03.2	Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the strengths and limitations of each source in terms of the specific task, purpose, and audience; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and overreliance on any one source and following a standard format for citation.
LAFS.1112.WHST.3.8		
43.03.3	Draw evidence from informational texts to support analysis, reflection, and research.
LAFS.1112.WHST.3.9		
43.04	Range of Writing		
43.04.1	Write routinely over extended time frames (time for reflection and revision) and shorter time frames (a single sitting or a day or two) for a range of discipline-specific tasks, purposes, and audiences.
LAFS.1112.WHST.4.10		
44.0	Methods and strategies for using Florida Standards for grades 11-12 Mathematical Practices in Technical Subjects for student success in Database Application Development & Programming.		
44.01	Make sense of problems and persevere in solving them.
MAFS.K12.MP.1.1		
44.02	Reason abstractly and quantitatively.
MAFS.K12.MP.2.1		
44.03	Construct viable arguments and critique the reasoning of others.
MAFS.K12.MP.3.1		
44.04	Model with mathematics.
MAFS.K12.MP.4.1		
44.05	Use appropriate tools strategically.
MAFS.K12.MP.5.1		
44.06	Attend to precision.
MAFS.K12.MP.6.1		
44.07	Look for and make use of structure.
MAFS.K12.MP.7.1		
44.08	Look for and express regularity in repeated reasoning.
MAFS.K12.MP.8.1		

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
51.0	Explain key concepts that distinguish object-oriented programming from procedural programming. – The student will be able to:			
51.01	Demonstrate the understanding and use of classes, objects, attributes, and behaviors. 			
51.02	Demonstrate the understanding and use of inheritance.			
51.03	Demonstrate the understanding and use of data encapsulation.			
51.04	Demonstrate the understanding and use of polymorphism.			
52.0	Create a project plan for an object-oriented programming project that defines requirements, structural design, time estimates, and testing elements. – The student will be able to:			
52.01	Write a project plan for completion of a project that includes gathering program requirements, developing the program, and testing it.			
52.02	Write a program requirements document that identifies business purpose, functional requirements, system requirements, and other common components of a requirements document.			
52.03	Design an object-oriented program using UML or another standard design methodology.			
52.04	Work with other team members to develop a project plan for a program.			
52.05	Work with other team members to write a design document for a program with multiple functions and shared data.			
52.06	Participate in design meetings that review program design documents for conformance to program requirements.			
52.07	Estimate the time to develop a program or module.			
53.0	Design, document, and create object-oriented computer programs. – The student will be able to:			
53.01	Compare and contrast recursive functions to other iterative methods.			
53.02	Understand the implementation of character strings in the programming language.			
53.03	Write programs that perform string processing (e.g., string manipulation, string compares, concatenation).			
53.04	Write programs that use user-defined data types.			
53.05	Write object-oriented programs that use inheritance.			
53.06	Write object-oriented programs that use polymorphism.			
53.07	Develop class constructors.			
53.08	Write programs that define and use program constants.			
53.09	Write programs that perform error handling.			
53.10	Participate in program code review meetings to evaluate program code for validity, quality, performance, data integrity, and conformance to program design documents.			
53.11	Write programs that perform dynamic memory allocation. 			
53.12	Write programs that perform effective management of dynamically allocated memory.			
53.13	Update a program module to implement enhancements or corrections and demonstrate appropriate documentation (internal, external) related to version control. 			
53.14	Write programs that use complex data structures (e.g., stacks, queues, trees, linked lists).			
53.15	Write programs that are event-driven.			
53.16	Write programs that perform file input and output (i.e., sequential and random access file input/output).			
53.17	Perform basic database commands including connect, open, select, and close.			
54.0	Design a unit test plan for an object-oriented computer program, test and debug the program, and report the results. – The student will be able to:			
54.01	Develop a test plan for an object-oriented program.		SC.912.N.1.1	
54.02	Write test plans for event-driven programs.		SC.912.N.1.1	
54.03	Write test plans for programs that perform file input and output.		SC.912.N.1.1	
54.04	Perform test and debug activities on object-oriented programs, including those written by someone else.			
54.05	Perform test and debug activities on an event-driven program.			
54.06	Perform test and debug activities on programs that perform file input and output and verify the correctness of output files.			
54.07	Document the findings of testing in a test report.		SC.912.N.1.1	

2014 – 2015
Florida Department of Education
Student Performance Standards

Course Title:	Database Design and SQL Programming
Course Number:	9007310
Course Credit:	1

Course Description:

This course continues the study of computer programming concepts specific to the SQL programming language.  

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
55.0	Develop an awareness of the changes taking place in the information age and how they fit into an evolving society. – The student will be able to:			
55.01	Cite examples of jobs, salary, and opportunities he/she will have as a database programmer.			
55.02	Describe the role a database plays in a business.			
55.03	Understand the importance of clear communication when discussing business informational requirements.			
55.04	Identify important historical contributions in database development and design.			
56.0	Develop the "big picture" of database design and how to best organize data according to business rules and/or client needs. – The student will be able to:			
56.01	Identify and analyze the phases of the database development process.			
56.02	Explain what logical data modeling and database design involve.			
56.03	Compare database development process with that of the application development process.			
56.04	Distinguish between a logical model and a physical implementation.			
57.0	Develop the process of creating an entity by identifying relationships. – The student will be able to:			
57.01	Identify and model various types of entities.			
57.02	Identify naming and drawing conventions for entities.			
57.03	Sequence the steps that are necessary for creation of an entity.			
57.04	Analyze and model the relationships between entities.			
58.0	Formulate and assemble initial entity relationship by expanding on modeling concepts. – The student will be able to:			
58.01	Analyze and model attributes.			
58.02	Identify unique identifiers for each entity.			
58.03	Develop an entity relationship diagram tagging attributes with optionality.			
59.0	Consider the degree and optionality of relationships of entities. – The student will be able to:			
59.01	Create entity relationship models based on information requirements and interviews.			
59.02	Differentiate between one-to-many, many-to-many and one-to-one relationships.			
59.03	Identify relationship between two entities by reading a given diagram.			
59.04	Create a relationship between instances of the same entity.			
59.05	Read an entity relationship model in order to validate it.			
60.0	Demonstrate proficiency in early construction stages of the data modeling process by using unique identifiers and many-to-many (M:M) relationships for building entity relationship diagrams. – The student will be able to:			
60.01	Identify the significance of an attribute that has more than one value for each entity instance.			
60.02	Evaluate appropriate methods of storing validation rules for attributes.			
60.03	Recognize unique identifiers inherited from other entities.			
60.04	Sequence the steps involved in resolving a many-to-many relationship.			
61.0	Demonstrate proficiency in advanced data constructs by analyzing business requirements and diagramming entities and relationships. – The student will be able to:			
61.01	Validate that an attribute is properly placed based upon its dependence on its entity's unique identifier (UID).			
61.02	Resolve many-to-many relationships with intersection entities.			
61.03	Model advanced data constructs including recursive relationships, subtypes, and exclusive relationships.			
61.04	Create exclusive entities and relationships by using subtypes and arcs, respectively.			
61.05	Identify initial layout for presentation and generate a list of action items for members of group.			
61.06	Develop an entity relationship model using subtypes, super-types and an exclusive arc.			
62.0	Demonstrate proficiency in designing and adding complexity to an entity-relationship model (ERM). – The student will be able to:			
62.01	Revise an entity relationship model according to client requirements.			
62.02	Define and give examples of hierarchical and recursive relationships.			
62.03	Differentiate between transferable and non-transferable relationships.			
62.04	Deliver a professional, formal business style presentation.			
62.05	Evaluate and critique presentation layout, design and performance.			
62.06	Construct a model using both recursion and hierarchies to express the same logical meaning.			
63.0	Apply complex ERM information by fine-tuning entities and the process for relating them. – The student will be able to:			
63.01	Describe a relational database and how it differs from other database systems.			
63.02	Define primary keys and foreign keys and describe their purpose.			
63.03	Describe what data integrity refers to and list some constraints.			
63.04	Explain how database design fits into the database development process.			
63.05	Translate an entity-relationship model into a relational database design.			
63.06	Document a database design using table instance charts.			
64.0	Apply initial database design and normalization by following the set of house rules that determine how items are stored and retrieved. – The student will be able to:			
64.01	Demonstrate ability to implement steps for mapping entity relationship models for implementation.			
64.02	Document an initial database design on table instance charts.			
64.03	Recognize raw data and evaluate the steps for creating a data group in unnormalized form (UNF).			
65.0	Demonstrate proficiency in the technique of normalization by labeling and organizing all items in a database in such a way as to prevent any confusion or mistakes. – The student will be able to:			
65.01	Differentiate between unnormalized data and normalized.			
65.02	Move data from an unnormalized form through to a third normal form.			
65.03	Demonstrate ability to test data groups for third normal form compliance.			
65.04	Identify optimized data groups from given groups of normalized data.			
66.0	Demonstrate proficiency in table normalization by combining the techniques of an entity relationship model or a top-down, business approach to data with normalization or a bottom-up mathematical approach to data. – The student will be able to:			
66.01	Compare the normalization and entity relationship modeling (ERM) techniques in terms of strengths and weaknesses.			
66.02	Further define normalization and explain its benefits.			
66.03	Place tables in third normal form.			
66.04	Explain how logical data modeling rules ensure normalized tables.			
66.05	Specify referential integrity constraints and design indices.			
67.0	Apply blueprint principles to begin designing a tool for creating a web-based interface access to a database. – The student will be able to:			
67.01	Evaluate the transformation of business requirements into an initial layout and design for a database.			
67.02	Construct simple web page design for personal work folder.			
67.03	Evaluate existing web sites and determine quality of design.			
68.0	Extend the logical model presentation model by normalizing the data and mapping the management system. – The student will be able to:			
68.01	Formulate a plan of action for the Database Project using skills previously learned in this course.			
68.02	Normalize a logical model to the third normal form (3NF).			
68.03	Create a table in the database using a database authoring tool.			
68.04	Demonstrate ability to edit tables using a database authoring tool.			
68.05	Create forms that will display the table components created with a database authoring tool.			
69.0	Apply techniques for building a storage management system by creating a website using templates and wizards. – The student will be able to:			
69.01	Create a web site that displays the database project home.			
69.02	Link a web site to create a web-enabled interface to the industry database.			
69.03	Edit the forms created and specify appropriate field labels for data entry.			
70.0	Demonstrate design and functionality by constructing a group business presentation. – The student will be able to: 			
70.01	Evaluate and generate criteria for a formal, business presentation.			
70.02	Construct a persuasive group presentation using the guidelines set forth in class.			
71.0	Demonstrate comprehension of database modeling competency through group presentation. – The student will be able to:			
71.01	Deliver a formal business presentation for the class that discusses an entity-relationship model and initial database design.			
71.02	Demonstrate the functionality of the database and the layout/design capabilities of a database authoring tool.			
71.03	Prepare appropriate end-user documentation.			
71.04	Self-assess learning experience through the presentation and demonstration of their final database project.			
72.0	Demonstrate comprehension that the database management software is a system for organizing the storage unit (or database) according to business needs and rules, through data integrity constraints. – The student will be able to:			
72.01	Identify the structural elements of a relational database table.			
72.02	List and describe the system development life cycle.			
72.03	Describe the industry implementation of the relational database management system (RDBMS) and object relational database management system (ORDBMS).			
72.04	Explain how SQL and languages that extend SQL are used in the industry product set.  			
72.05	Identify the advantages of a database management system.			
73.0	Demonstrate comprehension of aspects of SQL language interface by writing basic SQL statements. – The student will be able to:			
73.01	List the capabilities of SQL SELECT statements. 			
73.02	Execute a basic select statement.			
73.03	Differentiate between SQL statements and language commands that extend SQL.			
74.0	Demonstrate proficiency working with columns, characters, and rows in SQL. – The student will be able to:			
74.01	Apply the concatenation operator to link columns to other columns, arithmetic expressions, or constant values to create a character expression. 			
74.02	Use column aliases to rename columns in the query result.			
74.03	Eliminate duplicate rows in the query result.			
74.04	Display the structure of a table.			
74.05	Apply SQL syntax to restrict the rows returned from a query.			
74.06	Demonstrate application of the WHERE clause syntax.			
74.07	Construct and produce output using a SQL query containing character strings and date values.			
75.0	Demonstrate proficiency in using SQL comparison operators. – The student will be able to:			
75.01	Apply the proper comparison operator to return a desired result. 			
75.02	Demonstrate proper use of BETWEEN, IN, and LIKE conditions to return a desired result.			
75.03	Distinguish between zero and the value of NULL as unavailable, unassigned, unknown, or inapplicable.			
75.04	Explain the use of comparison conditions and NULL.			
76.0	Demonstrate proficiency in using logical comparisons and precedence rules. – The student will be able to:			
76.01	Evaluate logical comparisons to restrict the rows returned based on two or more conditions. 			
76.02	Apply the rules of precedence to determine the order in which expressions are evaluated and calculated. 			
76.03	Construct a query to order a results set for single or multiple columns.			
76.04	Construct a query to sort a results set in ascending or descending order. 			
77.0	Demonstrate proficiency using SQL single row functions. – The student will be able to:			
77.01	Perform calculations on data.	MFAS.912.N-Q.1.1,
MFAS.912.C-CN.1.2,
MFAS.912.A-REI.1.2,
MFAS.912.A-REI.2.3,
MFAS.912.F-BF.1.1,
MFAS.912.F-BF.1.2  		
77.02	Modify individual data items.			
77.03	Use character, number and date functions in SELECT statements.			
77.04	Format data and numbers for display purposes.			
77.05	Convert column data types.			
78.0	Demonstrate proficiency displaying data from multiple tables. – The student will be able to:			
78.01	Construct select statements to access data from more than one table using equity and non-equality joins. 			
78.02	Use outer joins through viewing data that generally does not meet a join condition. 			
78.03	Join a table to itself.			
79.0	Demonstrate proficiency aggregating data using group functions. – The student will be able to:			
79.01	Identify the available group functions and describe their use.			
79.02	Demonstrate the ability to group data through the use of the GROUP BY clause.			
79.03	Demonstrate the ability to include or exclude grouped rows by using the HAVING clause.			
80.0	Demonstrate proficiency utilizing subqueries. – The student will be able to:			
80.01	Write a query with an embedded subquery.			
80.02	Evaluate and perform a multiple-column subquery.			
80.03	Describe and explain the behavior of subqueries when null values are retrieved.			
80.04	Create a subquery in a FROM clause.			
81.0	Demonstrate proficiency producing readable output with SQL language interface, reporting tool, and data manipulation language. – The student will be able to:			
81.01	Produce queries that require an input variable.			
81.02	Customize the SQL language interface and reporting environment using SET commands for control.			
81.03	Produce more readable output through the use of the column and break commands.			
81.04	Describe data manipulation language (DML) and describe various DML statements.			
81.05	Utilize data manipulation language (DML) through inserting, updating and deleting rows from a table.			
81.06	Control transactions using COMMIT and ROLLBACK statements.			
82.0	Demonstrate proficiency creating and managing database objects. – The student will be able to:			
82.01	Describe the main database objects.			
82.02	Create tables and alter their definitions.			
82.03	Describe the data types that can be used when specifying column definition.			
83.0	Demonstrate proficiency altering tables and constraints implementing views. – The student will be able to:			
83.01	Create, drop, rename and truncate tables using SQL.			
83.02	Identify and describe various constraints including not null, unique, primary key, foreign key, and check.			
83.03	Create and maintain constraints including adding, dropping, enabling, disabling, and cascading.			
83.04	Recognize views and explain how they are created, how they retrieve data and how they perform DML operations.			
84.0	Demonstrate mastery of creating and implementing views, synonyms, indexes and other database objects. – The student will be able to:			
84.01	Create views, retrieve data through a view, alter the definition of a view and drop a view. 			
84.02	Categorize information by using Top-N queries to retrieve specified data.			
84.03	Identify the features of a sequence and display sequence values using a data dictionary view.			
84.04	Identify the characteristics of a cached sequence.			
84.05	Modify and remove a sequence using a SQL statement.			
84.06	Identify the features of private and public synonyms.			
84.07	Identify characteristics of an index and describe different types.			
84.08	Create and remove an index using a SQL statement.			
85.0	Demonstrate ability to control user access and SQL language interface and reporting tool. – The student will be able to:			
85.01	Identify the features of database security.			
85.02	Create users using SQL statements.			
85.03	Grant and revoke object privileges using a SQL language interface and reporting tool.			
86.0	Demonstrate comprehension of bundling features of SQL. – The student will be able to:			
86.01	List and describe the benefits of extension languages to SQL.			
86.02	Recognize the basic SQL block and its sections.			
86.03	Declare SQL variables and describe their significance.			
86.04	Execute a SQL block.			
87.0	Demonstrate comprehension working with composite data types by writing executable script files. – The student will be able to:			
87.01	Recognize the significance of the executable section and decide when to use it.			
87.02	Write statements in the executable section.			
87.03	Describe the rules of nested blocks.			
87.04	Identify and utilize appropriate coding conventions.			
87.05	Create a script that will select, insert, and update data in a table.			

2014 – 2015
Florida Department of Education
Student Performance Standards

Course Title:	SQL Extension Languages I
Course Number:	9007320
Course Credit:	1

Course Description:

This course continues the study of computer programming concepts specific to extensions of the SQL programming language.  

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
88.0	Describe the differences between SQL and SQL extension languages. – The student will be able to:			
88.01	Describe SQL extension languages.			
88.02	Differentiate between SQL and SQL extension languages.			
88.03	Explain the need for and benefits of SQL extension languages.			
89.0	Create program blocks. – The student will be able to:			
89.01	Describe the structure of a program block.			
89.02	Identify the different types of program blocks.			
89.03	Identify program programming environments.			
89.04	Create and execute an anonymous block.			
89.05	Output messages in program blocks.			
90.0	Use variables in program blocks. – The student will be able to:			
90.01	Describe how variables are used in program blocks.			
90.02	Identify the syntax for using variables.			
90.03	Declare and initialize variables.			
90.04	Assign new values to variables.			
91.0	Recognize lexical units. – The student will be able to:			
91.01	Describe the types of lexical units.			
91.02	Describe identifiers and identify valid and invalid identifiers.			
91.03	Describe and identify reserved words, delimiters, literals, and comments.			
92.0	Recognize data types. – The student will be able to:			
92.01	Describe the data type categories.			
92.02	Give examples of scalar, composite, and large object (LOB) data types.			
92.03	Identify when an object becomes eligible for garbage collection.			
93.0	Use scalar data types. – The student will be able to:			
93.01	Declare and use scalar data types.			
93.02	Define guidelines for declaring and initializing variables.			
94.0	Use various types of joins. – The student will be able to:			
94.01	Construct and execute SELECT statements using an equijoin.			
94.02	Construct and execute SELECT statements using a non-equijoin.			
94.03	Construct and execute SELECT statements using an outer join.			
94.04	Construct and execute SELECT statements that result in a Cartesian product.			
95.0	Use SQL group functions and subqueries. – The student will be able to:			
95.01	Construct and execute an SQL query using group functions to determine a sum total, an average amount, and a maximum value.			
95.02	Construct and execute an SQL query that groups data based on specified criteria.			
95.03	Construct and execute an SQL query that contains a WHERE clause using a single-row subquery.			
95.04	Construct and execute an SQL query that contains a WHERE clause using a multiple-row subquery.			
96.0	Write executable statements. – The student will be able to:			
96.01	Construct variable assignment statements.			
96.02	Construct statements using built-in SQL functions.			
96.03	Differentiate between implicit and explicit data type conversions.			
96.04	Describe when implicit data type conversions take place.			
96.05	List the drawbacks of implicit data type conversions.			
96.06	Construct statements using functions to explicitly convert data types.			
96.07	Construct statements using operators.			
97.0	Use nested blocks and variable scope. – The student will be able to:			
97.01	Understand the scope and visibility of variables.			
97.02	Write nested blocks and qualify variables with labels.			
97.03	Describe the scope of an exception.			
97.04	Describe the effect of exception propagation in nested blocks.			
98.0	Use good programming practices. – The student will be able to:			
98.01	List examples of good programming practices.			
98.02	Insert comments into code.			
98.03	Follow formatting guidelines when writing code.			
99.0	Write DML statements to manipulate data. – The student will be able to:			
99.01	Construct and execute a statement to insert data into a table.			
99.02	Construct and execute a statement to update data in a table.			
99.03	Construct and execute a statement to delete data from a table.			
99.04	Construct and execute a statement to merge data into a table.			
100.0	Retrieve data. – The student will be able to:			
100.01	Identify SQL statements that can be directly included in an executable block.			
100.02	Construct and execute an INTO clause to hold values returned by a single-row SELECT statement.			
100.03	Construct statements that retrieve data.			
101.0	Manipulate data. – The student will be able to:			
101.01	Construct and execute statements that manipulate data with DML statements.			
101.02	Describe when to use implicit or explicit cursors.			
101.03	Create code to use SQL implicit cursor attributes to evaluate cursor activity.			
102.0	Use transaction control statements. – The student will be able to:			
102.01	Define a transaction and give an example.			
102.02	Construct and execute a transaction control statement.			
103.0	Use IF conditional control statements. – The student will be able to:			
103.01	Construct and use an IF statement.			
103.02	Construct and use an IF-THEN-ELSIF-ELSE statement.			
103.03	Create PL/SQL to handle null conditions in an IF statement.			
104.0	Use CASE conditional control statements. – The student will be able to:			
104.01	Construct and use CASE statements.			
104.02	Construct and use CASE expressions.			
104.03	Include syntax to handle null conditions in a CASE statement.			
104.04	Include syntax to handle Boolean conditions in IF and CASE statements.			
105.0	Use basic LOOP iterative control statements. – The student will be able to:			
105.01	Describe the types of LOOP statements and their uses.			
105.02	Create a program containing a basic loop and an EXIT statement.			
105.03	Create a program containing a basic loop and an EXIT statement with conditional termination.			
106.0	Use WHILE and FOR loop iterative control statements. – The student will be able to:			
106.01	Construct and use the WHILE looping construct.			
106.02	Construct and use the FOR looping construct.			
106.03	Describe when a WHILE loop is used.			
106.04	Describe when a FOR loop is used.			
107.0	Use nested loop iterative control statements–The student will be able to:			
107.01	Construct and execute a program using nested loops.			
107.02	Evaluate a nested loop construct and identify the exit point.			
108.0	Use explicit cursors. – The student will be able to:			
108.01	List the guidelines for declaring and controlling explicit cursors.			
108.02	Create code to open a cursor and fetch a piece of data into a variable.			
108.03	Use a simple loop to fetch multiple rows from a cursor.			
108.04	Create code to close a cursor.			
109.0	Use explicit cursor attributes. – The student will be able to:			
109.01	Define a record structure.			
109.02	Create code to process the row of an active set using record types in cursors.			
109.03	Use cursor attributes to retrieve information about the state of an explicit cursor.			
110.0	Use cursor FOR loops. – The student will be able to:			
110.01	List and explain the benefits of using Cursor FOR loops.			
110.02	Create code to declare a cursor and manipulate it in a FOR loop.			
110.03	Create code containing a Cursor FOR loop using a subquery.			
111.0	Use cursors with parameters. – The student will be able to:			
111.01	List the benefits of using parameters with cursors.			
111.02	Create code to declare and manipulate a cursor with a parameter.			
112.0	Use cursors for update transactions. – The student will be able to:			
112.01	Create code to lock rows before an update using the appropriate clause.			
112.02	Explain the effect of using NOWAIT in an update cursor declaration.			
112.03	Create code to use the current row of the cursor in an UPDATE or DELETE statement.			
113.0	Use multiple cursors. – The student will be able to:			
113.01	Explain the need for using multiple cursors to produce multilevel reports.			
113.02	Create code to declare and manipulate multiple cursors within nested loops.			
113.03	Create code to declare and manipulate multiple cursors using parameters.			
114.0	Handle exceptions. – The student will be able to:			
114.01	Describe the advantages of including exception handling code.			
114.02	Describe the purpose of an EXCEPTION section in a program block.			
114.03	Create code to include an EXCEPTION section.			
114.04	List the guidelines for exception handling.			
115.0	Trap server exceptions. – The student will be able to:			
115.01	Distinguish between errors defined by the server and those defined by the programmer.			
115.02	Differentiate between errors that are handled implicitly and explicitly by the server.			
115.03	Write code to trap a predefined server error.			
115.04	Write code to trap a non-predefined server error.			
115.05	Write code to identify an exception by error code and by error message.			
116.0	Trap user-defined exceptions. – The student will be able to:			
116.01	Write code to name a user-defined exception.			
116.02	Write code to raise an exception.			
116.03	Write code to handle a raised exception.			

2014 – 2015
Florida Department of Education
Student Performance Standards

Course Title:	SQL Extension Languages II
Course Number:	9007330
Course Credit:	1

Course Description:

This course continues the study of computer programming concepts specific to extensions of the SQL programming language.  

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
117.0	Create procedures. – The student will be able to:			
117.01	Differentiate between anonymous blocks and subprograms.			
117.02	Identify the benefits of using subprograms.			
117.03	Describe a stored procedure.			
117.04	Create a procedure.			
117.05	Describe how a stored procedure is invoked.			
118.0	Use parameters in procedures. – The student will be able to:			
118.01	Describe how parameters contribute to a procedure.			
118.02	Define a parameter.			
118.03	Create a procedure using a parameter.			
118.04	Invoke a procedure that has parameters.			
118.05	Distinguish between formal and actual parameters.			
119.0	Pass parameters. – The student will be able to:			
119.01	List the types of parameter modes.			
119.02	Create a procedure that passes parameters.			
119.03	Identify methods for passing parameters.			
119.04	Describe the default option for parameters.			
120.0	Create stored functions. – The student will be able to:			
120.01	Describe the difference between a stored procedure and a stored function.			
120.02	Create a program block containing a function.			
120.03	Identify ways in which functions may be invoked.			
120.04	Create a program block that invokes a function that has parameters.			
121.0	Use functions in SQL statements. – The student will be able to:			
121.01	Describe where user-defined functions can be called from within an SQL statement.			
121.02	Describe the restrictions on calling functions from SQL statements.			
121.03	Describe the purpose of the Data Dictionary.			
121.04	Differentiate between the three types of Data Dictionary views.			
121.05	Write SQL SELECT statements to retrieve information from the Data Dictionary.			
122.0	Manage procedures and functions. – The student will be able to:			
122.01	Describe how exceptions are propagated.			
122.02	Remove a function and a procedure.			
122.03	Use Data Dictionary views to identify and manage stored procedures.			
123.0	Manage object privileges. – The student will be able to:			
123.01	List and explain several object privileges.			
123.02	Explain the function of the EXECUTE object privilege.			
123.03	Write SQL statements to grant and revoke object privileges.			
124.0	Use invoker’s rights. – The student will be able to:			
124.01	Contrast invoker’s rights with definer’s rights.			
124.02	Create a procedure that uses invoker’s rights.			
125.0	Create packages. – The student will be able to:			
125.01	Describe a package, its components, and the reasons for use.			
125.02	Create packages containing related variables, cursors, constants, exceptions, procedures, and functions.			
125.03	Create a program block that invokes a package construct.			
126.0	Manage package constructs. – The student will be able to:			
126.01	Explain the difference between public and private package constructs.			
126.02	Designate a package construct as either public or private.			
126.03	Specify the syntax to drop a package.			
126.04	Identify Data Dictionary views used to manage packages.			
126.05	Identify the guidelines for using packages.			
127.0	Use advanced package concepts. – The student will be able to:			
127.01	Write packages that use the overloading feature.			
127.02	Write packages that use forward declarations.			
127.03	Explain the purpose of a package initialization block.			
127.04	Identify restrictions on using packaged functions in SQL statements.			
128.0	Manage persistent state of package variables. – The student will be able to:			
128.01	Identify persistent states of package variables.			
128.02	Control the persistent state of a package cursor.			
129.0	Use vendor-supplied packages. – The student will be able to:			
129.01	Describe two common uses for vendor-supplied packages.			
129.02	Use the syntax to specify messages for a vendor-supplied package.			
129.03	Identify the exceptions used in conjunction with vendor-supplied packages.			
130.0	Understand dynamic SQL. – The student will be able to:			
130.01	Identify the stages through which all SQL statements pass.			
130.02	Describe the reasons for using dynamic SQL to create an SQL statement.			
130.03	List statements supporting Native Dynamic SQL.			
131.0	Understand triggers. – The student will be able to:			
131.01	Describe database triggers and their uses.			
131.02	Differentiate between a database trigger and an application trigger.			
131.03	List the guidelines for using triggers.			
131.04	Compare and contrast database triggers and stored procedures.			
132.0	Create DML triggers. – The student will be able to:			
132.01	Create a DML trigger and identify its components.			
132.02	Create a statement level trigger.			
132.03	Describe the trigger firing sequence options.			
132.04	Create a DML trigger that uses conditional predicates.			
132.05	Create a row level trigger.			
132.06	Create a row level trigger that uses OLD and NEW qualifiers.			
132.07	Create an INSTEAD OF trigger.			
133.0	Create DDL and database event triggers. – The student will be able to:			
133.01	Describe the events that cause DDL and database event triggers to fire.			
133.02	Create a trigger for a DDL statement.			
133.03	Create a trigger for a database event.			
133.04	Describe the functionality of the CALL statement.			
133.05	Describe the cause of a mutating table.			
134.0	Manage triggers. – The student will be able to:			
134.01	View trigger information in the Data Dictionary.			
134.02	Disable and enable a database trigger.			
134.03	Remove a trigger from the database.			
135.0	Use large object data types. – The student will be able to:			
135.01	Compare and contrast LONG and LOB data types.			
135.02	Describe LOB data types and how they are used.			
135.03	Differentiate between internal and external LOBs.			
135.04	Create and maintain LOB data types.			
135.05	Migrate data from LONG to LOB.			
136.0	Manage binary types. – The student will be able to:			
136.01	Define binary column data type.			
136.02	Create directory objects and view them in the Data Dictionary.			
136.03	Manage and manipulate binary types.			
137.0	Manage indexes. – The student will be able to:			
137.01	Create and manipulate user-defined records.			
137.02	Create an index.			
137.03	Describe the difference between records, tables, and indexes.			
138.0	Manage dependencies. – The student will be able to:			
138.01	Describe the implications of procedural dependencies.			
138.02	Contrast dependent objects and referenced objects.			
138.03	View dependency information in the Data Dictionary.			
138.04	Use a script to create the objects required to display dependencies.			
138.05	Use views to display dependencies.			
138.06	Describe how to minimize dependency failures.			

2014 – 2015
Florida Department of Education
Student Performance Standards

Course Title:	Custom Database Programming
Course Number:	9007340
Course Credit:	1

Course Description:

This course continues the study of computer programming concepts specific to specialized applications of the SQL programming language.  

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
139.0	Program a database application. – The student will be able to:			
139.01	Utilize loop statements.			
139.02	Given a scenario, use arithmetic, comparison, and pattern-matching operators.			
139.03	Create user-defined functions.			
139.04	Utilize common built-in functions.			
139.05	Declare variables in modules and procedures.			
139.06	Declare arrays, and initialize elements of arrays.			
139.07	Declare and use object variables and collections, and use their associated properties and methods.			
139.08	Declare symbolic constants, and make them available locally or publicly.			
139.09	Respond to events.			
140.0	Utilize the basic concepts of database design. – The student will be able to:			
140.01	Apply basic concepts of normalization.			
140.02	Utilize the cascade update and cascade delete options.			
141.0	Utilize SQL and union queries. – The student will be able to:			
141.01	Utilize SQL to write common queries.			
141.02	Refer to objects by using SQL.			
141.03	Utilize union queries.			
142.0	Implement program statements using objects. – The student will be able to:			
142.01	Determine when to use data access objects.			
142.02	Differentiate between objects and collections.			
142.03	Write statements that access and modify database objects.			
142.04	Utilize data access objects.			
142.05	Select appropriate methods and property settings for use with specified objects.			
143.0	Utilize debugging tools and write error handlers. – The student will be able to:			
143.01	Trap errors.			
143.02	Utilize debugging tools to suspend program execution, and to examine, step through, and reset execution of code.			
143.03	Debug code samples.			
143.04	Utilize the Debugger to monitor variable values.			
143.05	Write an error handler.			
144.0	Demonstrate file I/O. – The student will be able to:			
144.01	Read from files.			
144.02	Write to files.			
144.03	Utilize record locking.			
145.0	Create forms and identify all the properties of a form. – The student will be able to:			
145.01	Choose form-specific and report-specific properties to set.			
145.02	Choose control properties to set.			
145.03	Assign event-handling procedures to controls in a form.			
145.04	Define and create form and report modules.			
145.05	Identify the scope of a form or report module.			
145.06	Open multiple instances of a form, and refer to them.			
145.07	Assign values to form properties.			
145.08	Use form methods.			
146.0	Manipulate data using object models. – The student will be able to:			
146.01	Connect to a data source.			
146.02	Open a recordset.			
146.03	Insert, update, delete and find data.			
147.0	Develop custom controls. – The student will be able to:			
147.01	Set properties for custom controls.			
147.02	Customize user interface controls.			
148.0	Utilize API functions. – The student will be able to:			
148.01	Properly declare functions.			
148.02	Use the by value and by reference parameters.			
149.0	Demonstrate database replication and implement database replication using programming tools. – The student will be able to:			
149.01	Make a database replicable.			
149.02	View a synchronization schedule.			
149.03	Explain how synchronization conflicts are resolved.			
149.04	Identify the advantages of using replication of synchronization.			
149.05	Identify the changes that the database engine makes when it converts a nonreplicable database into replicable database.			
150.0	Analyze and implement security options. – The student will be able to:			
150.01	Analyze a scenario, and recommend an appropriate type of security.			
150.02	Explain the steps for implementing security.			
150.03	Analyze code to ensure that it sets security options.			
150.04	Write code to implement security options.			
151.0	Implement client/server applications. – The student will be able to:			
151.01	Demonstrate SQL pass through queries and application queries.			
151.02	Access external data.			
151.03	Trap errors that are generated by the server.			
151.04	Optimize connections.			
151.05	Optimize performance for a given client/server application.			
152.0	Optimize the performance of a database. – The student will be able to:			
152.01	Differentiate between single-field and multiple-field indexes.			
152.02	Optimize queries.			
152.03	Restructure queries to allow faster execution.			
152.04	Optimize performance in distributed applications.			
152.05	Optimize performance for client/server applications.			
153.0	Perform application distribution. – The student will be able to:			
153.01	Prepare an application for distribution.			
153.02	Analyze various methods to distribute a client/server application.			
153.03	Distribute custom controls with an application.			
153.04	Provide online help.			
154.0	Test and debug databases. – The student will be able to:			
154.01	Implement error handling.			
154.02	Test and debug library databases.			

Additional Information

Laboratory Activities

Laboratory investigations, including the use of scientific research, measurement, and laboratory technologies are an integral part of this course.  These activities include instruction in the use of safety procedures, tools, equipment, materials, and processes related to these occupations.  Equipment and supplies should be provided to enhance hands-on experiences for students.

Special Notes

The occupational standards and benchmarks outlined in this secondary program correlate to the standards and benchmarks of the postsecondary program with the same Classification of Instructional Programs (CIP) number.

Career and Technical Student Organization (CTSO)

Future Business Leaders of America (FBLA), Business Professionals of America (BPA), and SkillsUSA are the appropriate career and technical student organizations for 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.  The activities of such organizations are defined as part of the curriculum in accordance with Rule 6A-6.065, F.A.C.

Cooperative Training – OJT

On-the-job training is appropriate but not required for this program.  Whenever offered, the rules, guidelines, and requirements specified in the OJT framework apply. 

Accommodations

Federal and state legislation requires the provision of accommodations for students with disabilities as identified on the secondary student’s Individual Educational Plan (IEP) or 504 plan or postsecondary student’s accommodations’ plan 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.

In addition to accommodations, some secondary students with disabilities (students with an IEP served in Exceptional Student Education (ESE)) will need modifications to meet their needs.  Modifications change the outcomes or what the student is expected to learn, e.g., modifying the curriculum of a secondary career and technical education course.  Note: postsecondary curriculum and regulated secondary programs cannot be modified.

Some secondary students with disabilities (ESE) may need additional time (i.e., longer than the regular school year), to master the student performance standards associated with a regular Occupational Completion Point (OCP) or a Modified Occupational Completion Point (MOCP).  If needed, a student may enroll in the same career and technical course more than once.  Documentation should be included in the IEP that clearly indicates that it is anticipated that the student may need an additional year to complete an OCP/MOCP.  The student should work on different competencies and new applications of competencies each year toward completion of the OCP/MOCP.  After achieving the competencies identified for the year, the student earns credit for the course.  It is important to ensure that credits earned by students are reported accurately.  The district’s information system must be designed to accept multiple credits for the same course number for eligible students with disabilities.

Articulation

For details on articulation agreements which correlate to programs and industry certifications refer to http://www.fldoe.org/workforce/dwdframe/artic_frame.asp.

Bright Futures/Gold Seal Scholarship

Course substitutions as defined in the Comprehensive Course Table for this program area may be used to qualify a student for Florida’s Gold Seal Vocational Scholarship, providing all other eligibility requirements are met.  Eligibility requirements are available online at https://www.osfaffelp.org/bfiehs/fnbpcm02_CCTMain.aspx. 

Fine Arts/Practical Arts Credit

Many courses in CTE programs meet the Fine Arts/Practical Arts credit for high school graduation (http://www.fldoe.org/articulation/CCD/files/pacourses1314.pdf).  A listing of approved CTE courses is published each year as a supplemental resource to the Course Code Directory (http://www.fldoe.org/articulation/CCD/default.asp).