Content Outline and Competencies:

I. Computer and Related Technology

A. Identify current trends and developments in technology.

B. Apply the traditional definition of a computer system to newer, non-traditional computer configurations.

C. Describe the ever-increasing importance of the Internet to all types of societal infrastructures.

D. Discuss how the digital revolution and digital convergence are forever changing the way citizens work and live.

II. Computer Hardware and Software

A. Identify and describe the various hardware components of a computer system.

B. Explain the concept of digitization.

C. Propose new applications for emerging hardware.

D. Categorize and describe various types of application software and their licensing options.

E. Identify the functionality of various types of system software, including operating systems and utilities.

III. Computer Networks

A. Articulate the advantages and disadvantages of a computer network.

B. Identify and define basic network hardware.

C. Compare and contrast wired and wireless networks.

D. Explain how IP addresses and domain names work.

IV. World Wide Web

A. Identify and describe the basic elements that make up the World Wide Web.

B. Identify and analyze features and functions of web browsers and their extensions, evaluating the productivity potential of each.

C. Describe how to search the Web for trustworthy information.

D. Explain the difference between the World Wide Web and the Internet, as well as the services each offers.

E. Define e-commerce and explain how the Web is used for commercial transactions.

V. Web-based Applications

A. Differentiate between past and current generations of web-based applications.

B. Discuss the social and technological developments that advance web-based applications.

C. Describe and compare several of today's most prevalent types of web-based applications.

D. Use and evaluate several of today's most prevalent types of web-based applications.

E. Demonstrate how to manage social media for professional success.

1.  Identify common features of social networking applications.

2.  Extend social media functionality with applications.

3.  Discuss privacy issues related to social networking applications.

4.  Explain how businesses use social networking to enhance customer relations.

5.  Plan for or create professional social media accounts and profiles.

F. Create a new web-based application using existing cloud-based data.

G. Hypothesize about the functionality that may be provided by the next generation of web-based applications.

VI. Computer and Data Security

A. Identify and describe the many factors that may damage data, software, or computer hardware

B. Identify ways to protect data and computers.

C. Recommend an appropriate balance between data privacy and national security for all citizens.

VII. Ethical Use of Technology

A. Explain personal ethical standards regarding legality, common good, and personal well-being.

B. Explain professional ethical standards owed to customers, co-workers and employers.

C. Describe the ethical standards citizens should hold their governments accountable for, including keeping each person safe and minimizing the socioeconomic digital divide.

VIII. Word Processing Application Software

A. Format document text, including paragraphs, alignment, spacing, tabbing, and indents.

B. Enhance document text using bullets, numbering, borders, shading, and hyperlinks.

IX. Presentation Application Software

A. Create slides and incorporate design themes.

B. Utilize various methods of adding text.

C. Insert, modify, rearrange, merge, edit and duplicate shapes.

D. Align and group multiple objects.

E. Utilize slide footers.

X. Spreadsheet Application Software

A. Create a spreadsheet with appropriate data.

B. Use formulas and functions to enhance data analysis.

C. Format a spreadsheet.

D. Create, format and edit charts using spreadsheet data.

XI. Database Application Software

A. Create databases, tables and primary keys.

B. Create relationships between tables.

C. Enter and edit data.

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. 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. 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: