Content Outline and Competencies:

I. The Information Society
   A  Enumerate several current uses of computers
   B. Identify current trends and developments in computing
   C. State and evaluate ethical and sociological issues resulting from
progress in technology
   D. Articulate the influence of mass storage and manipulation of data on
society and business

II. Categories of Computer Systems
   A. Name the hardware categories based on computing power
   B. List the characteristics of each hardware category
   C. Identify the capabilities common to all categories: input, output,
processing, storage

III. Hardware Components of a Microcomputer System
   A. Explain the purpose and distinguishing characteristics of a CPU
   B. Describe the role of Memory and the significance of the amount of
Memory
   C. List several peripheral devices used for input, output, storage, and
communications

IV. Operating System Software
   A. Use operating system software to organize, copy, delete, and move
files
   B. Identify screen elements of the operating system using proper
terminology
   C. Distinguish between program files and data files
   D. Use operating system software to personalize the desktop
   E. Use operating system software to access application software and to
work with more than one application at a time
   F. Use operating system software to determine the hardware
specifications of a pc system

V. Business Application Software
   A. Summarize the capabilities of commercial business application
software
   B. Identify screen elements common to all applications
   C. Use word processing software to enter, edit, print, and save
documents
   D. Use spreadsheet software to enter, edit, print, and save worksheets
   E. Create formulas, including functions, to solve business problems
using worksheets
   F. Use database software to enter, edit, print, and save a database
   G. Create and evaluate queries to manipulate data in tables
   H. Use presentation software to prepare and present a slide
presentation
   I. Select appropriate application software to accomplish common
business practices

Content Outline and Competencies:

I. The Visual Basic Environment
   A. Describe .Net and the Graphical User Interface (GUI) revolution
   B. Use mouse techniques
   C. Define the Visual Basic project

II. Visual Basic Objects
   A. Describe an object
   B. Describe Visual Basic's limited implementation of objects
   C. Define Visual Basic forms and properties
   D. Describe and use the toolbox

III. Sample Project
   A. Save the project
   B. Add control objects to the form
   C. Set the properties for the control objects
   D. Run the project
   E. Describe and use onLine help

IV. Menus
   A. Explain the Visual Basic menu system, including
      1. The debug menu
      2. The help menu
   B. Add a menu to a project
   C. Add input and message boxes
   D. Explain and demonstrate user-defined functions
   E. Explain control arrays

V. Event-driven Processing
   A. Respond to form events
   B. Write event procedures, including:
      1. Click events
      2. Change events
      3. Mouse events
   C. Describe the events and properties of the ListBox
   D. Describe the events and properties of the ComboBox

VI. Data Validation and Dialog Boxes
   A. Test input with nested if statements
   B. Build a message  

VII. Subprocedures and Functions
   A. Explain general procedures
   B. Describe and use subprocedures
   C. Describe and use user-defined Functions

VIII. Introduction to Scope
   A. Use static variables
   B. Define local variables
   C. Define public, private and global variables

IX. The Multiform Project
   A. Demonstrate communication between forms
   B. Use the F8 key to execute a program line by line
   C. Set break points
   D. Check variable values while running

X. File handling in Visual Basic
   A. Sequential file processing
      1. Create a sequential file
      2. Access a sequential file
   B. Random-access file processing 
      1. Create a sequential file
      2. Access a sequential file

XI. More File handling Techniques
   A. Recognize the end of file (EOF)
   B. Update files, sequential and random
   C. Use the type statement to define a record
   D. Save files 

XII. Introduction to Database
   A. Explain databases
   B. Create a database using the data manager
   C. Add data to the database with data manager

XIII. Use the Data Control to Interact with a Database
   A. Display data from a database through bound controls
   B. Describe events of the data control
      1. Write code for the validate event
      2. Write code for the reposition event
   C. Query the database
      1. Use the findfirst method
      2. Search manually
      3. Join data from multiple tables

Content Outline and Competencies:

I. Define a relational database
   A. Describe database components
   B. Describe database architecture

II. Create a relational database
   A. Create tables
   B. Create fields and properties with referential integrity

III. Write statements to perform queries
   A. Perform simple and action queries
   B. Perform multiple queries

IV. Create forms and reports
   A. Use various wizards for object creation
   B. Create forms with bound and unbound controls
   C. Create reports for end user and printer
   D. Create subforms for updates
   E. Use macros to create forms

V. Add procedures and functions to the database
   A. Write procedures and functions with variables and constants
   B. Work with objects and their methods and properties
   C. Create record object

Content Outline and Competencies:

I. Infrastructure of the networked economy
   A. Explain network designs
   B. Discuss IPv6 (Internet protocol version 6)
   C. Explain P2P (Peer to Peer)
   D. Explain VOIP (Voice Over Internet Protocol)

II. Data formats
   A. Discuss TPS  (transaction processing system)
   B. Discuss XML (eXtensible markup language)
   C. Discuss XBRL (eXtensible business reporting language)

III. Develop Information Systems
   A. Analyze roles of Information System Designers
   B. Analyze roles of Information System Employees
   C. Create professional resume

IV. Organizational memory
   A. Appraise the importance of retaining complex sets of data
   B. Design systems to record and organize documents and artifacts
   C. Apply organizational memory to learn from the past

V. Perceptive software
   A. Describe role of perceptive software
   B. Use perceptive software to increase hand eye coordination

VI. Ecommerce strategies and technologies
   A. Describe and discuss PHP (scripting language)
   B. Describe and discuss SQL (structured query language)
   C. Describe and discuss ASP (active server pages)

VII. Database management
   A. Build a database stryctyre
   B. Manage records – Sort and filter records
   C. Manage records – Delete records
   D. Manage records – Add records

VIII. Supply chain / RFID (radio frequency ID)
   A. Explain use of RFID to control inventory
   B. Describe integration of RFID into manufacturing process


IX. Crime and security issues
   A. Prevent hacking
   B. Protect against unauthorized access and use
   C. Access systems - Explain possessed knowledge
   D. Access systems - Describe biometric systems

X. Privacy and ethical issues
   A. Demonstrate how Cookies are created
   B. Explain WEB bugs and spyware
   C. Discuss E-Mail privacy
   D. Demonstrate how to avoid spam
   E. Protecting privacy - Safeguard E-Mail address
   F. Protecting privacy - Protect personal information
   G. Protecting privacy - Use filters to eliminate unwanted email
   H. Honoring copyrights, trademarks and patents
   I. Software types - Describe commercial software packages
   J. Software types - Describe shareware software packages
   K. Software types - Describe freeware software packages
   L. Software types - Explain the purpose of public domain software

XI. Cybercrime
     A. Analyze theft of data prevention methods
     B. Explain identity theft prevention methods
     C. Describe online auction fraud
     D. Explain internet scams, spoofing and phishing
     E. Avoid software piracy
     F. Describe digital counterfeiting
     G. Explain cyberstalking

Content Outline and Competencies:

I. Computer Systems
   A. Describe systems hardware and peripherals
   B. Define operating systems, development, and applications software
   C. Outline memory management, disk management and device management

II. UNIX Features
   A. Report on the history, versions and standards
   B. List and Describe Software components
      1. Describe the kernel
      2. Compare and contrast various shell flavors
      3. Describe commands, utilities and applications
   C. Describe UNIX Features
      1. Clarify portability and device independence
      2. Define multi-tasking
      3. Define multi-user
      4. Explain concept of programmable shells
      5. Explain built-in security
   D. Explain the file system
      1. Describe the hierarchical directory structure
      2. Describe file attributes
      3. Describe path names

III. UNIX Commands
   A. Access the system - login, change password, logout
   B. Employ special shell and file characters
   C. Utilize commands in the following categories 
      1. File and directory management
      2. Process management
      3. Device management
      4. Multi-tasking
      5. Text editing using vi
      6. Shell scripting
      7. Utilities

IV. UNIX Scripts for Automating Processes 
   A. Employ control structures
   B. Stream input & output
   C. Manage processes
   D. Schedule processes
   E. Develop scripts for networking

Content Outline and Competencies:

I. Introduction to Mobile Applications
   A. Discuss the landscape of mobile applications including the major
companies involved, the hardware/software used, and statistics related to
mobile application market share and prevalence.
   B. Describe the unique functionality presented by mobile devices.
   C. List the steps involved in installing and configuring a mobile
application development environment.
   D. Open and explore a mobile application development environment.

II. Interface Design and Development
   A. Discuss the design challenges for small and varied screen sizes.
   B. Discuss optimal screen design including usability considerations.
   C. Create screen layouts that include menus, textboxes, buttons, and
images.
   D. Configure screen layouts to account for differing mobile devices.

III.  Code Development
   A. Discuss and implement coding standards.
   B. Write code using common coding constructs such as variables,
selection statements, loops, arrays or lists, and objects.
   C. Create applications that process user input to perform simple
tasks.
   D. Create applications built upon a common application programming
interface.
   E. Run and debug applications using a device emulator.

IV. Data Storage and Retrieval
   A. Create applications that store and retrieve data from a text file.
   B. Create applications that query and update databases.

V. Network Connectivity
   A. Create applications that connect to the Internet.
   B. Create applications that retrieve and process Internet data.

VI. Application Deployment
   A. Transfer a completed application to a mobile device.
   B. Test the application on the mobile device.
   C. List the steps in global application deployment.
   D. Discuss the challenges and potential cost in global application
deployment.

Content Outline and Competencies:

I. Create programs using strings and the String Library
   A. Employ string I/O
   B. Copy, compare, search for and extract strings
   C. Test and Validate string input
   D. Convert string data to numeric data

II. Describe object principles
   A. Explain correct syntax
   B. Use public, private and protected data elements
   C. Use in-line and regular functions in programs

III. Incorporate inheritance and function overloading in programs
   A. Describe and use constructors and destructors
   B. Define the base class
   C. Use inherited classes
   D. Use multiple inheritance

IV. Program pointers and dynamic memory in C++
   A. Use pointers
   B. Use new and delete operators
   C. Declare dynamic memory arrays
   D. Define and use pointers to objects
   E. Define objects containing pointers

V. Describe and use the C++ I/O system
   A. Use the input and output classes
   B. Program constructors and destructors
   C. Employ random file I/O
   D. Incorporate error checking and recovery
   E. Format output

VI. Describe and use operator overloading
   A. Describe syntax
   B. Explain usage
   C. Overload the extraction  ( << ) and insertion ( >> ) operators

VII. Explain and use advanced concepts
   A. Create virtual functions and abstract classes
   B. Use the copy constructor
   C. Program friend functions

VIII. Program for DOS Graphics
   A. Create points and lines
   B. Create circles and arcs
   C. Save and restore programs

Content Outline and Competencies:

I. The Java Programming Environment
   A. Install the Java compiler and tools.
   B. Navigate the Java directories.
   C. Compile and run Java programs.
   D. Use editors to create graphical applications.

II. Advanced Applications with Java Class Libraries
   A. Build applications using trees.
   B. Employ tables in applications.
   C. Create programs using progress monitors, sliders and tool bars.
   D. Create shapes and drawings.
   E.  Manipulate images.
   F.  Utilize advanced printing techniques.
   G. Program data transfer between applications with the
clipboard.
   H. Program data transfer with drag and drop.
   I. Create user interaction through menus, buttons and acceleration
keys.

III. Data Structures
   A. Program for data using vectors and bit sets.
   B. Employ hash tables, linked lists and stacks.

IV. Exceptions and Debugging
   A. Catch errors and throw exceptions.
   B. Use a debugger.

V. Input and Output Streams
   A. Create programs using file objects, reader objects and writer
objects.
   B. Create programs using file dialogs.
   C. Open, read, edit and update files.

VI. Multithreading
   A. Describe and use thread properties, priorities and groups.
   B. Program thread synchronization.
   C. Create programs with animation using threads.

VII. Networking
   A. Connect to and implement servers.
   B. Send data to and retrieve data from a remote site.
   C. Describe Web security.

Content Outline and Competencies:

I. Define and Describe Fundamental Concepts, Philosophies, and Trends
   A. Describe the systems analyst
   B. Define the business and its users as a system
   C. Explain the system development life cycle
   D. List and describe structured methodologies

II. Employ Systems Analysis Tools and Techniques
   A. Perform a systems analysis
   B. Employ fact finding techniques
   C. Create data flow diagrams
   D. Produce a data dictionary
   E. Use procedure specification tools

III. Employ System Design Tools and Techniques
   A. Perform a system design
   B. Write output specifications
   C. Write file specifications
   D. Write input specifications
   E. Compose terminal dialogue specifications
   F. Produce a system flowchart
   G. Program specifications

IV. Describe a System Implementation

Content Outline and Competencies:

I. Introduction to C#
   A. Define CLI.
   B. Explain the .NET architecture.
   C. Describe where C# fits into the framework.

II. Review of Fundamental Programming Structures
   A. Write a simple C# program.
   B. Define identifiers and keywords.
   C. Discuss style considerations.
   D. Define basic C# Types.
   E. Work with arrays.
   F. Review expressions.
      1. Operators
      2. Enumeration
      3. Blocks
      4. Precedence
   G. Review flow of control structures.
      1. "if"
      2. Loops
      3. "break"
      4. "continue"
      5. "return"

III. Examine Debugging
   A. Use pre-processing directives.
   B. Learn how to use the debugger.

IV. Work with Objects and Component Concepts
   A. Define object-oriented programming.
   B. Define components.
   C. Define properties.
   D. Describe and use inheritance features
      1. Casting, abstract classes and interfaces
      2. Protected access
      3. Constructors and destructors

V. Handle Exceptions and Errors
   A. Use "try/catch" blocks.
   B. Use "finally" blocks.
   C. Handle exceptions.
   D. Design your own exceptions.

VI. Define Delegates and Events
   A. Delegates
      1. Define
      2. Create
   B. Events
      1. Define event handlers
      2. Fire events

VII. Create Structs
   A. Identify the class/struct relationship.
   B. Examine Trade-offs.

VIII. Implement Interfaces
   A. Define abstract class versus Interface.
   B. Define Interface members.

IX. Perform Conversions
   A. Define implicit versus explicit conversions.
   B. Examine value type conversion.
   C. Examine reference type conversions.

X. Program Graphical User Interfaces
   A. Create windows.
   B. Create controls.
   C. Define N-Tier architecture.

XI. Define File I/O and Serialization
   A. Create streams.
   B. Define Serialization.

XII. Examine Database Programming with ADO.NET.
   A. Make connections.
   B. View data.
   C. Manipulate data.
 
XIII. Examine Web Applications with ASP.NET.
   A. Create a simple web page.
   B. Create controls.
 
XIV. Define Multi-Threading
   A. Create new threads.
   B. Define synchronization.
 
XV. Examine C# Collections
   A. Define pre-existing collections.
      1. ArrayList
      2. BitArray
      3. Hashtable
      4. Queue
      5. SortedList
      6. Stack
   B. Create collection interfaces.
   C. Create a collection.
 
XVI. Define Garbage Collection
   A. Examine automatic memory management.
   B. Control garbage collection.

Content Outline and Competencies:

I. Database Fundamentals
  A. Discuss the history of databases.
  B. Use information related to basic database concepts.
  C. Design and implement relations.
  D. Utilize keys.
  E. Discuss and utilize null values.
  F. Discuss and utilize functional dependencies and normalization.
  G. Create logical designs.
  H. Generate the Data Definition Language (DDL).
  I. Create physical tables from the DDL.

II. SQL Application to Practical Problems
  A. Discuss SQL concepts.
  B. Write SQL.
  C. Analyze SQL result sets.
  D. Analyze table properties.

III. Table Manipulation 
  A. Write code to connect to database tables.
  B. Write code to process database tables.
  C. Create triggers.
  D. Create stored procedures.

IV. DBA Issues
  A. Discuss concurrency.
  B. Discuss security.
  C. Discuss backup and recovery.
  D. Discuss locking and deadlocks.
  E. Discuss transactions.

Content Outline and Competencies:

I. Project Plan Development
   A. Determine technologies to be used.
   B. Interview business partners to determine system requirements.
   C. Develop an informal project timeline.
   D. Finalize an initial plan.

II. Project Implementation
   A. Create initial prototype.
   B. Demonstrate a working prototype to the class.
   C. Participate in code reviews of other teams’ code.
   D. Create detailed test plans.
   E. Execute test plans.
   F. Demonstrate prototype to business partners for feedback.
   G. Finalize all code.

III. Job Search and Interview Skills
   A. Tour the Career Development Center.
   B. Complete a resume.
   C. Participate in mock interviews.

IV. Communication Skills
   A. Write a research paper and present results.
   B. Present periodic project updates.
   C. Deliver a formal, final presentation to students, JCCC staff, business partners, local businesses and other interested parties.

Content Outline and Competencies:

I. Company or Organization Description
   A. Describe the mission and goals.
   B. Provide a general outline of the organizational structure and where the student fits into that structure.
   C. Identify and describe the products and services.
   D. Identify and describe the products and services with which the student was directly involved during the internship.

II. Work Activities Description
   A. Document activities and accomplishments.
   B. Submit periodic, reflective reports.

III. Classroom Experience and Related Knowledge
   A. Apply technical skills learned in coursework.
   B. Apply problem-solving and analysis skills.
   C. Obtain and apply new knowledge and skills. 
   D. Complete non-trivial tasks.

IV. Workplace Skills
   A. Follow written and oral instructions.
   B. Demonstrate effective written and oral communication.
   C. Demonstrate interpersonal skills appropriate to a business environment.
   D. Participate in meetings and teams as assigned.
   E. Manage time and resources effectively.
   F. Follow the employer’s rules, regulations and policies.
   G. Demonstrate appropriate workplace ethics.

Content Outline and Competencies:

I. The Web Development Framework 
  A. Discuss client-server architecture and interaction.
  B. Discuss core programming language and database features.
  C. Discuss and utilize an Integrated Development Environment (IDE).

II. Web Applications 
  A. Utilize Web forms and controls.
  B. Handle exceptions.
  C. Implement state management.
  D. Utilize markup languages.

III. Enhanced Web Applications 
  A. Perform validation.
  B. Demonstrate use of advanced controls.
  C. Enhance page design.
  D. Implement navigation.

IV. Data Integration
  A. Utilize core language support.
  B. Bind data to controls.
  C. Use data controls.
  D. Manipulate files, streams and tables.

V. Advanced Web-Enabled Database Concepts
  A. Discuss security fundamentals.
  B. Implement caching techniques.
  C. Discuss performance issues.
  D. Discuss deployment of Web applications.

Content Outline and Competencies: