2014 – 2015
Florida Department of Education
Curriculum Framework 

Program Title:	Oracle Software Engineering
Career Cluster:	Information Technology

CCC	
CIP Number	0511020311	
Program Type	College Credit Certificate (CCC)	
Program Length	33 credit hours	
CTSO	Phi Beta Lambda, BPA	
SOC Codes (all applicable) 	15-1132 – Software Developers, Applications	
Targeted Occupation List	http://www.labormarketinfo.com/wec/TargetOccupationList.htm	
Perkins Technical Skill Attainment Inventory	http://www.fldoe.org/workforce/perkins/perkins_resources.asp 	
Statewide Articulation	http://www.fldoe.org/workforce/dwdframe/artic_frame.asp 	

Purpose

This certificate program is part of the Database Technology AS degree program (1511010306).  

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

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

The content includes but is not limited to database systems, software, programming and analysis and design of databases.

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

Standards

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

01.0	Demonstrate proficiency in developing and operating a database.
02.0	Demonstrate proficiency in manipulating a database and creating tables and data structures.
03.0	Demonstrate proficiency in developing applications and using the procedure builder tool.
04.0	Demonstrate proficiency in creating SQL procedural language blocks of application code that can be shared by multiple forms, reports and data management applications.
05.0	Demonstrate proficiency in creating a complete forms application using Developer/2000 while working in a graphical user interface (GUI) development environment.
06.0	Demonstrate proficiency in designing multiple forms applications.
07.0	Demonstrate proficiency in developing a variety of standard and custom reports using the reports component of Developer/2000 in a client/server environment.

2014 – 2015
Florida Department of Education
Student Performance Standards

Program Title:	Oracle Software Engineering
CIP Number:		0511020311
Program Length:	33 credit hours
SOC Code(s):		15-1132

This certificate program is part of the Database Technology AS degree program (1511010306).  At the completion of this program, the student will be able to:	
01.0	Demonstrate proficiency in developing and operating a database. – The student will be able to:	
01.01	Build a relational database.	
01.02	Query, display, and format data.	
01.03	Save, retrieve, and run queries.	
01.04	Build and format reports.	
01.05	Group and summarize data.	
02.0	Demonstrate proficiency in manipulating a database and creating tables and data structures. – The student will be able to:	
02.01	Insert, update, automatically generate, and delete data.	
02.02	Control transaction processing.	
02.03	Create, confirm, modify and remove tables to store data.	
02.04	Apply business rules to ensure data integrity.	
02.05	Restrict user access to tables.	
02.06	Improve query performance.	
03.0	
Demonstrate proficiency in developing applications and using the procedure builder tool. – The student will be able to:	
03.01	Develop programs in PL/SQL.	
03.02	Insert and manipulate data with PL/SQL.	
03.03	Manage and execute program units using the object navigator and the PL/SQL interpreter.	
03.04	Define and compile procedures using the program unit editor.	
03.05	Control the execution of a PL/SQL program unit.	
03.06	Test possible solutions by making changes to variables and procedures at runtime.	
04.0	Demonstrate proficiency in creating PL/SQL procedural language blocks of application code that can be shared by multiple forms, reports and data management applications. – The student will be able to:	
04.01	Nest sub-queries within another SQL procedural language command.	
04.02	Develop applications using procedural capabilities.	
04.03	Insert and manipulate data with SQL procedural language.	
04.04	Use the procedure builder tool to develop and debug SQL procedural language code.	
04.05	Manage and execute program units using the object navigator and the SQL procedural language interpreter.	
04.06	Define environmental requirements for peripherals and media.	
04.07	Define and compile procedures using the program unit editor.	
04.08	Control the execution of an SQL procedural language program unit.	
05.0	Demonstrate proficiency in creating a complete forms application using Developer/2000 while working in a graphical user interface (GUI) development environment. – The student will be able to:	
05.01	Build a new data block using an existing table specification.	
05.02	Save and run a form module from the designer.	
05.03	Develop a master/detail form module.	
05.04	Identify characteristics of each forms file storage type.	
05.05	Create forms containing check boxes, radio groups, containing list items, display items, image items and buttons.	
05.06	Start additional forms with the same transaction and session.	
05.07	Enhance the default menu.	
05.08	Add basic menu items.	
05.09	Attach a menu module to a forms module.	
05.10	Save and run a form module from the designer.	
06.0	Demonstrate proficiency in designing multiple forms applications. – The student will be able to:	
06.01	Redefine function keys and determining when key triggers should be used or avoided.	
06.02	Cause a form module to respond to mouse movement and mouse button actions.	
06.03	Create trigger code to interact with windows.	
06.04	Build robust multiple form transactions.	
06.05	Choose between different ways of invoking forms.	
06.06	Pass data between forms using parameter lists.	
06.07	Control coded events and methods.	
07.0	Demonstrate proficiency in developing a variety of standard and custom reports using the reports component of Developer/2000 in a client/server environment. – The student will be able to:	
07.01	Design and execute a simple report.	
07.02	Manage the appearance and display of data in reports with layout objects.	
07.03	Customize the display of data in reports.	
07.04	Tailor the appearance of simple and advanced business reports.	
07.05	Integrate text and graphics in reports.	
07.06	Import charts and graphs from the graphics component of Developer/2000.	
07.07	Apply the packaged functions and procedures supplied with the reports component of Developer/2000.	
07.08	Write queries to retrieve data.	
07.09	Manage the structure of data in reports using data objects.	
07.10	Determine how to best produce reports by analyzing report structures.	
07.11	Filter report information from the database server.	
07.12	Implement graphics into reports.	
07.13	Build modules in Developer 2000 reports for use with other Developer/2000 tools.	
07.14	Manage module storage and security.	
07.15	Build reports in which the end user supplies values at runtime to control report output.	

Additional Information

Laboratory Activities

Laboratory activities are an integral part of this program.  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. 

Career and Technical Student Organization (CTSO)

Phi Beta Lambda and Business Professionals of America (BPA) 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.

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.

Articulation

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