Desktop Publishing Applications Specialist Certificate

An individual, with or without a college degree, with the goal to acquire or improve computer desktop publishing application skills, will accomplish that goal in this certificate. Emphasis is placed upon the acquisition of results-oriented career business and industry skills.

The desktop publishing certificate is intended for those seeking entry-level positions, as well as for those currently employed, who desire to enhance their job skills. This certificate provides current or prospective employers with tangible evidence of desktop publishing competency, on the part of the certificate completer.

Application courses for the certificate will encourage students to develop a “cross-platform” mastery, which is made possible by offering most on-campus courses in a dual-platform Macintosh and Windows computing environment.

Required courses that cover skills a student already has may be replaced with other CDTP courses at the discretion of the Assistant Dean of Computing Sciences and Information Technology or a desktop publishing professor. An applicant must complete 14 credits at Johnson County Community College.

Suggested/Sample Course Sequence Completion in One Semester

The sequence taken by the student may vary depending on prerequisites, course availability, and personal/ professional responsibilities.

(Major Code 4830; State CIP Code 11.0202)

Prerequisites for Required Courses

Prior to beginning this program students must take the following prerequisite or have taken an equivalent transfer course, or have passed the waiver test, or have obtained a waiver from the program administrator.

CPCA 105Introduction to Personal Computers: Windows1
or CPCA 106 Introduction to Personal Computers: Macintosh

First Five Week Session

CDTP 135Desktop Photo Manipulation I: Photoshop1
CDTP 140Desktop Publishing I: InDesign1
CDTP 145Desktop Illustration I: Illustrator1

Second Five Week Session

CPCA 134Managing Your Macintosh*1
or CPCA 138 Windows for Microcomputers*
CDTP 155Desktop Photo Manipulation II: Photoshop*1
CDTP 160Desktop Publishing II: InDesign*1
CDTP 165Desktop Illustration II: Illustrator*1

Third Five Week Session

CDTP 175Desktop Photo Manipulation III: Photoshop*1
CDTP 168Desktop Publishing III: InDesign*1
CDTP 185Desktop Illustration III: Illustrator*1

Select four of the following ten courses

CPCA 108Word Processing I: MS Word*1
CPCA 123E-Presentation: MS PowerPoint*1
CPCA 125Word Processing II: MS Word*1
CWEB 105Introduction to Web Pages: Dreamweaver*1
CWEB 115Intermediate Web Pages: Dreamweaver*1
CWEB 125Introduction to Dynamic Web Pages: Dreamweaver*1
CWEB 130Introduction to Flash*1
CWEB 140Intermediate Flash*1
CWEB 150Advanced Flash*1

Total Program Hours: 14

Courses

CIS 124   Introduction to Computer Concepts and Applications (3 Hours)

In this introductory, non-technical computer course, students will learn through hands-on assignments to use current computer technologies to enhance personal and professional productivity. This includes current and emerging computer and Internet technologies, as well as desktop and web-based business applications. Students will learn strategies for evaluating the validity, legitimacy, and productivity potential of future technologies as they emerge, as well as how to assess the privacy risks associated with each. 3 hrs. lecture/wk.

CIS 162   Database Programming* (4 Hours)

Prerequisites: CIS 134 or CS 134

This course covers the use of an interactive environment and programming language to create, maintain and manipulate databases using Access as the RDBMS. The use of a command-level database programming language to customize business systems and selectively retrieve information using single or multiple database tables also will be studied. 3 hrs. lecture, 2 hrs. open lab/wk.

CIS 201   Introduction to Information Systems* (3 Hours)

Prerequisites: ACCT 121

This course is an introduction to the use of computers in management, concepts of computer software, hardware, and systems analysis. Applications will include electronic spreadsheets, database management software, graphics and presentation tools, and other special purpose tools. Word processing tools will be used for most graded assignments. Programming will be studied in the context of spreadsheet macros. 3 hrs. lecture/wk.

CIS 201H   HON: Introduction to Information Systems (1 Hour)

One-credit hour honors contract is available to qualified students who have an interest in a more thorough investigation of a topic related to this subject. An honors contract may incorporate research, a paper, or project and includes individual meetings with a faculty mentor. Student must be currently enrolled in the regular section of the courses or have completed it the previous semester. Contact the Honors Program Office, COM 201, for more information.

CIS 204   UNIX Scripting and Utilities* (3 Hours)

Prerequisites: CIS 134 or CS 134

This course will cover the concepts and principles related to scripting for the multi-user, multi-tasking UNIX operating system and its utilities. Students will complete projects in UNIX ranging from using simple commands to writing shell scripts automating repetitive tasks. 3 hrs. lecture/wk.

CIS 208   Mobile Application Development* (4 Hours)

Prerequisites: CS 205

In this course, students will utilize effective design and structured programming techniques to build mobile applications. Topics will include designing interfaces for small screens and varied architectures, processing user events, retrieving and storing data, communicating via the Internet, and deploying applications. 3 hrs. lecture, 2 hrs open lab/wk.

CIS 240   Advanced Topics in Java* (4 Hours)

Prerequisites: CS 205

At the completion of this course, the student should be able to create Java applications for implementation on the Internet and the personal computer. The student will complete projects using Java's built-in features. The course will include generics, input and output streams, serialization, exception handling, multithreading, client-server applications and graphical user interfaces. 3 hrs. lecture, 2 hrs. open lab/wk.

CIS 242   Introduction to System Design and Analysis* (3 Hours)

Prerequisites: CIS 138 or CS 200 or CS 201 or CS 205

Students will study the basic philosophy and techniques of developing and using business information systems. The emphasis will be on the human involvement necessary in systems design and implementation. The course will address the use of specific technical approaches available in information processing. 3 hrs. lecture/wk.

CIS 260   Database Management* (4 Hours)

Prerequisites: CS 200 or CS 201 or CS 205

At the completion of this course, students should be able to understand the characteristics and objectives of database management systems (DBMS). Topics include database environments, data modeling using the entity-relational model, normalization, logical and physical design, the Structured Query Language (SQL), data quality, database administration and related topics. Students will use a relational DBMS , employ associated tools and write programs to manipulate tables. 3 hrs. lecture, 2 hrs. open lab/wk.

CIS 264   Application Development and Programming* (4 Hours)

Prerequisites: CIS 242 and CIS 260 and CIS 235 or CIS 240 or CIS 244 or CS 236 or CS 255

This course helps students develop a significant software project while combining previously learned software development skills with contemporary technologies. Students should work within a team to communicate, plan and implement a software application. Proper interviewing and job searching techniques are also explored. 4 hrs. lecture/wk.

CIS 270   Information Systems Internship* (3 Hours)

Prerequisites: Department appoval and any of the following courses: CS 236 or CS 250 or CS 255 or CIS 235 or CIS 240 or CIS 244

Students will work in an approved training situation under instructional supervision. The internship is designed to give students the opportunity to use skills learned in computer science and information systems courses. Fifteen hours on-the-job training per week will be the usual workload for the student. To be eligible, students must have recently completed a course in the department.

CIS 275   Web-Enabled Database Programming* (4 Hours)

Prerequisites: CS 200 or CS 201 or CS 205

At the completion of this course, the student should be able to create dynamic Web pages containing information accessed from a database. The student will complete projects using Web technologies that interface with a database. The course will include graphics, graphical user interfaces, exception handling and event-driven programming. 3 hrs. lecture, 2 hrs. open lab/wk.

CIS 291   Independent Study* (1-7 Hour)

Prerequisites: 2.0 GPA minimum and department approval

Independent study is a directed, structured learning experience offered as an extension of the regular curriculum. It is intended to allow individual students to broaden their comprehension of the principles of and competencies associated with the discipline or program. Its purpose is to supplement existing courses with individualized, in-depth learning experiences. Such learning experiences may be undertaken independent of the traditional classroom setting, but will be appropriately directed and supervised by regular instructional staff. Total contact hours vary based on the learning experience.

CIS 292   Special Topics: (1-4 Hour)

This course periodically presents specialized topics in computer information systems that are not available in the regularly offered curriculum. Special Topics may be repeated for credit, but only on different topics. Total contact hours vary with topic.

CIS 124

  • Title: Introduction to Computer Concepts and Applications
  • Number: CIS 124
  • Effective Term: Fall 2014
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Description:

In this introductory, non-technical computer course, students will learn through hands-on assignments to use current computer technologies to enhance personal and professional productivity. This includes current and emerging computer and Internet technologies, as well as desktop and web-based business applications. Students will learn strategies for evaluating the validity, legitimacy, and productivity potential of future technologies as they emerge, as well as how to assess the privacy risks associated with each. 3 hrs. lecture/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Discuss current computer and related technology.

  2. Identify computer components and explain the roles of hardware and software in a computer system.

  3. Explain how computer networks function and facilitate digital communication.

  4. Identify the functional components of the World Wide Web and explain how it is a platform for web-based applications.

  5. Evaluate and use web-based applications to better facilitate the creation and consumption of credible web-based content.

  6. Distinguish between various computer and data security threats and recommend appropriate solutions.

  7. Model the ethical and socially responsible use of technology.

  8. Use word processing software to create, edit, and produce professional documents.

  9. Use presentation software to create, edit, and produce professional presentations.

  10. Use electronic spreadsheet software to create, edit, and analyze numerical data.

  11. Use database software to create databases and analyze data.

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.

Method of Evaluation and Competencies:

Tests/Exams (minimum of 4)                         60 - 70% of grade
Projects (minimum of 12)                              20 - 30% of grade
Quizzes, homework                                     10 - 20% of grade
Participation                                                0 – 10% of grade       

Grade Criteria:

90 – 100% = A
80 – 89% = B
70 – 79% = C
60 – 69% = D
0 – 59 % = F

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 162

  • Title: Database Programming*
  • Number: CIS 162
  • Effective Term: Fall 2014
  • Credit Hours: 4
  • Contact Hours: 5
  • Lecture Hours: 3
  • Other Hours: 2

Requirements:

Prerequisites: CIS 134 or CS 134

Description:

This course covers the use of an interactive environment and programming language to create, maintain and manipulate databases using Access as the RDBMS. The use of a command-level database programming language to customize business systems and selectively retrieve information using single or multiple database tables also will be studied. 3 hrs. lecture, 2 hrs. open lab/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Build applications in the graphical user interface interactive environment
  2. Understand and apply database design methodologies
  3. Apply Access macros to database applications
  4. Apply Access event procedures to database applications
  5. Create and compile VBA code
  6. Apply VBA code to database applications
  7. Manipulate objects using object oriented programming techniques
  8. Include error handling and security techniques using VBA
  9. Work with arrays and passing arguments using VBA

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

Method of Evaluation and Competencies:

   Examinations          60% of grade
   Projects/Assignments  40% of grade
                        100%
Grade Criteria:
A = 90%
B = 80%     
C = 70%     
D = 60%     
F = less than 60%

Grade Criteria:

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 201

  • Title: Introduction to Information Systems*
  • Number: CIS 201
  • Effective Term: Fall 2014
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Requirements:

Prerequisites: ACCT 121

Description:

This course is an introduction to the use of computers in management, concepts of computer software, hardware, and systems analysis. Applications will include electronic spreadsheets, database management software, graphics and presentation tools, and other special purpose tools. Word processing tools will be used for most graded assignments. Programming will be studied in the context of spreadsheet macros. 3 hrs. lecture/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Report on the principles and components of information systems.
  2. Report on how information systems meet organizational and business needs.
  3. Identify the role of information systems professionals.
  4. Create a plan for systems development.
  5. Gain experience using software tools to solve business problems.
  6. Develop a conceptual understanding of business problems.
  7. Use problem-solving skills to solve business problems.
  8. Stimulate interest in information systems as a career goal.
  9. Develop an understanding of security issues.

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

Method of Evaluation and Competencies:

Examinations                50% of grade
Projects/Assignments     50% of grade
  Total                    100%

Grade Criteria:
  A = 90 – 100%        
  B = 80 –  89%               
  C = 70 –  79%               
  D = 60 -  69%         
  F =  0 –  59%

Grade Criteria:

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 201H

No information found.

CIS 204

  • Title: UNIX Scripting and Utilities*
  • Number: CIS 204
  • Effective Term: Fall 2014
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Requirements:

Prerequisites: CIS 134 or CS 134

Description:

This course will cover the concepts and principles related to scripting for the multi-user, multi-tasking UNIX operating system and its utilities. Students will complete projects in UNIX ranging from using simple commands to writing shell scripts automating repetitive tasks. 3 hrs. lecture/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Describe computer systems organization, including hardware systems and peripherals; and software, including operating systems, development, and applications.
  2. Report on the history, versions, and standards of UNIX.
  3. Describe UNIX software components and features.
  4. Describe UNIX techniques of memory, disk and device management.
  5. Access the UNIX system.
  6. Manage the UNIX hierarchical directory structure.
  7. Apply UNIX command-line commands to processes, file and directory management, device management, multi-tasks, multi-users, and security.
  8. Create data and script files with the UNIX text editor vi.
  9. Create shell scripts to automate processing, file and directory management, device management, security and other repetitive processes.

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

Method of Evaluation and Competencies:

   A minimum of 2 Examinations 60% of grade
   A minimum of 6 Projects     40% of grade
   Total                      100% of grade

Grade Criteria:
A = 90%
B = 80%     
C = 70%     
D = 60%     
F = less than 60%  

Grade Criteria:

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 208

  • Title: Mobile Application Development*
  • Number: CIS 208
  • Effective Term: Fall 2014
  • Credit Hours: 4
  • Contact Hours: 5
  • Lecture Hours: 3
  • Other Hours: 2

Requirements:

Prerequisites: CS 205

Description:

In this course, students will utilize effective design and structured programming techniques to build mobile applications. Topics will include designing interfaces for small screens and varied architectures, processing user events, retrieving and storing data, communicating via the Internet, and deploying applications. 3 hrs. lecture, 2 hrs open lab/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Install and utilize a mobile application development environment.
  2. Identify design and development challenges for mobile platforms.
  3. Create optimal user interfaces for mobile platforms.
  4. Utilize functionality provided in an application programming interface (API).
  5. Program mobile applications that support a variety of end-user needs.
  6. List the steps in mobile application deployment.

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.

Method of Evaluation and Competencies:

Minimum of 5 programming projects: 30% to 50% of grade
Lab assignments: 20% to 40% of grade
Minimum of two examinations: 30% to 50% of grade
Total: 100%

Grade Criteria:

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 240

  • Title: Advanced Topics in Java*
  • Number: CIS 240
  • Effective Term: Fall 2014
  • Credit Hours: 4
  • Contact Hours: 5
  • Lecture Hours: 3
  • Other Hours: 2

Requirements:

Prerequisites: CS 205

Description:

At the completion of this course, the student should be able to create Java applications for implementation on the Internet and the personal computer. The student will complete projects using Java's built-in features. The course will include generics, input and output streams, serialization, exception handling, multithreading, client-server applications and graphical user interfaces. 3 hrs. lecture, 2 hrs. open lab/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Demonstrate knowledge of the Java programming environment.
  2. Create advanced applications utilizing the Java class libraries.
  3. Utilize data structures.
  4. Debug code and handle exceptions.
  5. Process input and output streams.
  6. Write multithreaded code.
  7. Implement network connectivity.

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.

Method of Evaluation and Competencies:

Labs and Projects    20 - 60%
Assignments              0 - 20%
Quizzes and Exams       30 - 70%
Total                       100%
Grade Criteria:
   A = 90%
   B = 80%     
   C = 70%
   D = 60%     
   F = less than 60%

Grade Criteria:

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 242

  • Title: Introduction to System Design and Analysis*
  • Number: CIS 242
  • Effective Term: Fall 2014
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Requirements:

Prerequisites: CIS 138 or CS 200 or CS 201 or CS 205

Description:

Students will study the basic philosophy and techniques of developing and using business information systems. The emphasis will be on the human involvement necessary in systems design and implementation. The course will address the use of specific technical approaches available in information processing. 3 hrs. lecture/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Have a fundamental understanding of all phases of the systems development life cycle.
  2. Use the techniques presented to analyze a firm's current system.
  3. Conduct a systems study from problem definition through implementation and follow-ups for a case study(s).
  4. Use the basic tools of systems analysis.
  5. Know the role of the systems analyst in the business organization.
  6. Know the importance of feasibility studies and how they are conducted.

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

Method of Evaluation and Competencies:

   Examinations          58% of grade
   Projects/Assignments  42% of grade
                        100%
Grade Criteria:
   A = 90%
   B = 80%     
   C = 70%     
   D = 60%     
   F = less than 60%

Grade Criteria:

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 260

  • Title: Database Management*
  • Number: CIS 260
  • Effective Term: Fall 2014
  • Credit Hours: 4
  • Contact Hours: 5
  • Lecture Hours: 3
  • Other Hours: 2

Requirements:

Prerequisites: CS 200 or CS 201 or CS 205

Description:

At the completion of this course, students should be able to understand the characteristics and objectives of database management systems (DBMS). Topics include database environments, data modeling using the entity-relational model, normalization, logical and physical design, the Structured Query Language (SQL), data quality, database administration and related topics. Students will use a relational DBMS , employ associated tools and write programs to manipulate tables. 3 hrs. lecture, 2 hrs. open lab/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Discuss and utilize database fundamentals.
  2. Apply SQL to practical problems.
  3. Manipulate tables.
  4. Discuss Database Administrator (DBA) issues.

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.

Method of Evaluation and Competencies:

Labs and Projects  20 – 60%
   Assignments          10 – 20%
   Quizzes and Exams    30 – 70%
   Total                        100%

Grade Criteria:
   A = 90%   
   B = 80%     
   C = 70%     
   D = 60%     
   F = less than 60%

Grade Criteria:

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 264

  • Title: Application Development and Programming*
  • Number: CIS 264
  • Effective Term: Fall 2014
  • Credit Hours: 4
  • Contact Hours: 4
  • Lecture Hours: 4

Requirements:

Prerequisites: CIS 242 and CIS 260 and CIS 235 or CIS 240 or CIS 244 or CS 236 or CS 255

Description:

This course helps students develop a significant software project while combining previously learned software development skills with contemporary technologies. Students should work within a team to communicate, plan and implement a software application. Proper interviewing and job searching techniques are also explored. 4 hrs. lecture/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Develop a project plan.
  2. Implement the project plan.
  3. Develop job search and interview skills.
  4. Develop communication skills.

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.

Method of Evaluation and Competencies:

Project-Update Presentations   10 – 30%
Assignments                          0 – 10%
Research Paper                      10 – 20%
Final Project                        40 – 60%
Final Presentation                  10 – 30%
                                         100%

Grade Criteria:
   A = 90%
   B = 80%     
   C = 70%     
   D = 60%     
   F = less than 60%

Grade Criteria:

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 270

  • Title: Information Systems Internship*
  • Number: CIS 270
  • Effective Term: Fall 2014
  • Credit Hours: 3
  • Contact Hours: 0
  • Lecture Hours:
  • Other Hours: 15

Requirements:

Prerequisites: Department appoval and any of the following courses: CS 236 or CS 250 or CS 255 or CIS 235 or CIS 240 or CIS 244

Description:

Students will work in an approved training situation under instructional supervision. The internship is designed to give students the opportunity to use skills learned in computer science and information systems courses. Fifteen hours on-the-job training per week will be the usual workload for the student. To be eligible, students must have recently completed a course in the department.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Describe the company or organization.
  2. Describe the work activities performed during the internship.
  3. Utilize classroom experience and related knowledge in accomplishing work tasks.
  4. Demonstrate effective workplace skills.

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.

Method of Evaluation and Competencies:

1. The internship coordinator will evaluate the student based upon weekly reports and a final summative report.
2. The employing supervisor will be asked to evaluate the student in writing by submitting an evaluation report to the internship coordinator.
3. At least two on-site visits will be made by the internship coordinator. An initial visit will establish internship and workplace expectations, and a final visit will discuss outcomes and the employer’s evaluation.
   
      Employer's Evaluation      50-60%
      Final Report       10-25%
      Weekly Reports   25-40% 
                                   100%
                                   
Grade Criteria:
      A = 90%           
      B = 80%           
      C = 70%           
      D = 60%           
      F = less than 60%  

Grade Criteria:

Caveats:

  1. Transportation to the worksite is the responsibility of the student.
  2. The department can provide students with suggestions of companies and organizations offering internships, but it is the student’s responsibility to secure the internship.

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 275

  • Title: Web-Enabled Database Programming*
  • Number: CIS 275
  • Effective Term: Fall 2014
  • Credit Hours: 4
  • Contact Hours: 5
  • Lecture Hours: 3
  • Other Hours: 2

Requirements:

Prerequisites: CS 200 or CS 201 or CS 205

Description:

At the completion of this course, the student should be able to create dynamic Web pages containing information accessed from a database. The student will complete projects using Web technologies that interface with a database. The course will include graphics, graphical user interfaces, exception handling and event-driven programming. 3 hrs. lecture, 2 hrs. open lab/wk.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Describe the Web development framework.
  2. Develop Web applications.
  3. Enhance Web applications.
  4. Integrate data into Web applications.
  5. Discuss and implement advanced Web-enabled database concepts.

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.

Method of Evaluation and Competencies:

Labs and Projects  20 – 60%
Assignments             0 – 20%
Quizzes and Exams       30 – 70%
                                 100%
 

Grade Criteria:
   A = 90%
   B = 80%     
   C = 70%     
   D = 60%     
   F = less than 60%

Grade Criteria:

Caveats:

None

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.

CIS 291

No information found.

CIS 292

  • Title: Special Topics:
  • Number: CIS 292
  • Effective Term: Fall 2014
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Description:

This course periodically presents specialized topics in computer information systems that are not available in the regularly offered curriculum. Special Topics may be repeated for credit, but only on different topics. Total contact hours vary with topic.

Course Fees:

None

Supplies:

Refer to the instructor's course syllabus for details about any supplies that may be required.

Objectives

  1. Appropriately use terminology related to the special topic. 
  2. Solve problems by using content related to the special topic.
  3. Demonstrate conceptual understanding of the special topic.
  4. Use software related to the special topic.

Content Outline and Competencies:

Varies

Method of Evaluation and Competencies:

See course syllabus.

Grade Criteria:

Caveats:

Varies

Student Responsibilities:

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.