2007/2008 Competency-Based Task/Competency List

Tasks/competencies designated by bullets in the left-hand column are considered essential statewide and are required of all students. In some courses, all tasks/competencies have been identified as essential. Tasks/competencies without bullets are considered optional; they and/or additional tasks/competencies may be taught at the discretion of the school division. Tasks/competencies marked with an asterisk (*) are considered sensitive, and teachers should obtain approval by the school division before teaching them.

6661
36 weeks		 Advanced Database Design and Management (Oracle)
TASKS/COMPETENCIES
  Implementing Virginia's CTE Course Requirements
• 001 Demonstrate Virginia's Workplace Readiness Skills in course activities.
• 002 Apply Virginia's All Aspects of Industry elements in course activities.
• 003 Identify Internet safety issues and procedures for complying with acceptable use standards.
  Participating in the Student Organization
• 004 Identify the purposes and goals of the student organization.
• 005 Explain the benefits and responsibilities of membership in the student organization as a student and in professional/civic organizations as an adult.
• 006 Demonstrate leadership skills through participation in student organization activities, such as meetings, programs, and projects.
  Learning the Fundamentals of Java as an Object-Oriented Programming Language
• 007 Describe Java's place in computer-language history.
• 008 Explain how Java relates to the Internet.
• 009 Explain the fundamentals of object-oriented programming.
• 010 Describe the general form of a Java program, including variables, program flow control, main, and methods statements.
• 011 Create and compile a block of code.
• 012 Recognize Java keywords.
• 013 Describe the various naming conventions.
• 014 Identify the key components of the Java Development Kit (JDK).
• 015 Describe the Java Virtual Machine (JVM).
  Distinguishing Key Elements of Java
• 016 Use Java's simple data types.
• 017 Initialize and assign variables.
• 018 Describe the scope rules of a variable.
• 019 Apply type conversion (casting) in expressions.
• 020 Use the arithmetic operators.
• 021 Compare relational and logical operators.
• 022 Input characters from the keyboard.
• 023 Navigate the Java API.
  Controlling Program Flow
• 024 Use the full forms of the "if" and "for" loop and switch statements.
• 025 Use the "while" loop.
• 026 Use the "do-while" loop.
• 027 Employ "break" and "continue" statements effectively.
• 028 Identify appropriate situations in which to use control statements.
  Introducing Classes, Objects, and Methods
• 029 Identify class and method definitions.
• 030 Differentiate between classes and objects.
• 031 Explain an object and its operations (or methods).
• 032 Create a method, and return a value from a method.
• 033 Use parameters in a method.
• 034 Add a constructor to a class.
• 035 Overload a constructor.
• 036 Describe garbage collection and the finalize ( ) method.
• 037 Apply the "this" reference.
  Using Data Types and Operators
• 038 Use single and multidimensional arrays.
• 039 Use various formats to initialize arrays.
• 040 Apply the bitwise operators.
• 041 Create objects of type String and utilize their methods.
  Understanding Methods and Classes
• 042 Define the public and private access modifiers.
• 043 Pass and return objects/primitive parameters to methods.
• 044 Use class variables and class methods where appropriate.
• 045 Apply recursive methods.
• 046 Create and use recursive methods and variables.
• 047 Describe nested and inner classes.
  Using Inheritance
• 048 Use inheritance to define new classes.
• 049 Describe the difference between a superclass and a subclass.
• 050 Explain how inheritance affects member access.
• 051 Use "super" to call superclass constructors and members.
• 052 Create a multilevel class hierarchy.
• 053 Explain when constructors are called in a class hierarchy.
• 054 Apply superclass references to subclass objects.
• 055 Demonstrate how to override methods.
• 056 Create abstract methods and classes.
• 057 Use the keyword "final" to prevent inheritance.
• 058 Explain the purpose and importance of the Object class.
  Using Packages and Interfaces
• 059 Create and implement an interface, utilizing its variables.
• 060 Extend an interface.
• 061 Create and import a package.
• 062 Describe how a package affects access to its programs.
• 063 Explain the purpose of the Thread class and the Runnable interface.
  Handling Exceptions
• 064 Explain the purpose of exception handling.
• 065 Write code to demonstrate how "try" and "catch" work together to handle an exception.
• 066 Create an exception handler.
• 067 Identify the consequences of an unhandled exception.
• 068 Use multiple "catch" statements.
• 069 Nest "try" blocks.
• 070 Throw an exception.
• 071 Use the methods of Throwable.
• 072 Create an original exception class.
  Using Java's I/O System
• 073 Describe a stream.
• 074 List the main byte and character stream classes.
• 075 Use predefined streams.
• 076 Read input from the keyboard.
• 077 Write output to the monitor.
• 078 Use the byte streams for file I/O.
• 079 Read and write binary data.
• 080 Use the character-based streams for console I/O.
• 081 Use the character-based streams for file I/O.
• 082 Create and manipulate streams in Java.
  Understanding Multithreaded Programming Support
• 083 Describe the fundamentals of multithreading.
• 084 Create multiple threads.
• 085 Describe the life cycle of a thread.
• 086 Change a thread's priority.
• 087 Describe the purpose of synchronization.
• 088 Create synchronized methods.
• 089 Perform thread communication.
• 090 Suspend, resume, and stop threads.
  Creating Applets, Events, and Other Topics
• 091 Create a new Java applet.
• 092 Explain applet fundamentals, including its architecture.
• 093 Handle the passing of parameters into an applet from an HTML page.
• 094 Describe which methods are called by the browser and when they are called.
  Introducing Integrated Design Environment or Development Tool
  095 Build and execute Java applications, using development tool.
  096 Modify Java application source code.
  097 Create new projects and applications in a development environment.
• 098 Design and create a program to meet user needs.
  Preparing for Industry Certification
• 099 Describe the process and requirements for obtaining industry certifications related to this course.
• 100 Identify testing skills/strategies for a certification examination.
• 101 Demonstrate ability to successfully complete selected practice examinations (e.g., practice questions similar to those on certification exams).
  Developing Employability Skills
• 102 Investigate job opportunities, using the Internet and other sources.
• 103 Investigate careers in the information technology field.
• 104 Research certification and educational opportunities.
• 105 Compose or update a printed résumé.
• 106 Prepare an electronic résumé.
• 107 Create a letter of application.
• 108 Complete an electronic application form.
• 109 Create an interview follow-up letter.
• 110 Identify the steps to follow in resigning from a position.
• 111 Update portfolio containing representative samples of student's work (e.g., program design, source code, technical documentation and design, source code, and output).
• 112 Deliver an oral presentation of portfolio.
• 113 Identify potential employment barriers for nontraditional groups and ways to overcome barriers.