Computer Information Systems (CIS)

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 142   Beginning Programming using Python (4 Hours)

In this introductory course, students will create computer applications that perform tasks and solve problems. Students will utilize fundamental logic, problem-solving techniques and key programming concepts to design, develop and test modular applications written in the Python programming language. 3 hrs. lecture, 2 hrs. open lab/wk.

CIS 162   Database Programming* (4 Hours)

Prerequisites: 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 introduces students to contemporary information systems and demonstrates how these systems are used throughout global organizations. Students will study key information system components and learn how these components are best leveraged by businesses. This course also provides an introduction to systems and development concepts, technology acquisition and various types of emerging or prevalent application software. 3 hrs. lecture/wk.

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

Prerequisites: Honors department approval.

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: CS 134 or CIS 142.

This course will cover the concepts and principles related to scripting for the multiuser, multitasking 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 CS 235 or CIS 240 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 235 or CS 236 or CS 250 or CS 255 or CIS 240.

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)

Prerequisites: Department approval.

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: 2018-19
  • 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.

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:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 142

  • Title: Beginning Programming using Python
  • Number: CIS 142
  • Effective Term: 2018-19
  • Credit Hours: 4
  • Contact Hours: 5
  • Lecture Hours: 3
  • Lab Hours: 2

Description:

In this introductory course, students will create computer applications that perform tasks and solve problems. Students will utilize fundamental logic, problem-solving techniques and key programming concepts to design, develop and test modular applications written in the Python programming language. 3 hrs. lecture, 2 hrs. open lab/wk.

Supplies:

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

Objectives

Upon successful completion of this course, the student should be able to:

  1. Describe software development careers and types of software applications.
  2. Describe and convert among data representations.
  3. Apply different problem-solving techniques.
  4. Write computer programs that utilize fundamental statements and processes.
  5. Break solutions into more manageable code using functions.
  6. Use built-in objects and implement elementary user-defined objects.
  7. Write computer programs that respond to events.

Content Outline and Competencies:

I. Software Development Careers and Software Applications

A. Describe different types of careers available to software developers.

B. Identify real-world applications that are based upon computer programs.

II. Data Representation

A. Convert characters to and from ASCII (American Standard Code for Information Interchange) code.

B. Convert among binary, decimal and hexadecimal numbers.

C. Identify the representation of a zero and one as electrical voltages in volatile memory.

III. Problem-Solving Techniques for Software Development

A. Represent problems and solutions.

1. Use flowcharts to represent logical flow

2. Use pseudo-code to represent algorithms

3. Use hierarchy charts to represent relationships among modules

B. Implement top-down design by breaking a larger problem into smaller, more manageable units.

C. Explain the software development life cycle.

D. Use elementary strategies to test solutions.

E. Trace program flow manually.

IV. Fundamental Statements and Processes

A. Create variables by assigning values.

B. Differentiate among data types.

C. Build expressions with arithmetic, relational and logical operators.

D. Implement one-way, two-way and multi-way if statements.

E. Simplify logic using De Morgan’s Law.

F. Use while and for loops.

G. Process user input.

H. Generate user output.

I. Create and manipulate lists.

J. Create and manipulate dictionaries.

V. Functions

A. Call built-in and user-defined functions.

B. Pass parameters.

C. Process returned values.

D. Write functions.

VI. Object-Oriented Programming

A. Identify advantages of object-oriented techniques.

B. Utilize built-in objects and methods.

C. Create elementary user-defined classes.

1. Create and utilize constructors to initialize instance variables

2. Create and call methods

D. Instantiate objects from classes.

VII. Event-driven Programming

A. List different types of event triggers.

B. Use built-in classes to capture events.

C. Write event handlers to process events.

Method of Evaluation and Competencies:

Students will complete a minimum of 20 computer programs and complete at least two exams.

20-60%    Labs and Projects
10-40%    Exercises
20-60%    Quizzes and Exams

Total: 100%

Grade Criteria:

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

Caveats:

Students must be proficient in keyboarding and in performing tasks with a Windows or Macintosh operating system. Operating system and office application courses are available in CPCA and CIS to enhance these skills.

Student Responsibilities:

Disabilities:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 162

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

Requirements:

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

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:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 201

  • Title: Introduction to Information Systems*
  • Number: CIS 201
  • Effective Term: 2018-19
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Requirements:

Prerequisites: ACCT 121.

Description:

This course introduces students to contemporary information systems and demonstrates how these systems are used throughout global organizations. Students will study key information system components and learn how these components are best leveraged by businesses. This course also provides an introduction to systems and development concepts, technology acquisition and various types of emerging or prevalent application software. 3 hrs. lecture/wk.

Supplies:

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

Objectives

Upon successful completion of this course, the student should be able to:

  1. Explain how and why information systems are used today.
  2. Identify the components of information systems.
  3. Discuss the role of information systems in globalization.
  4. Describe how businesses utilize information systems to gain a competitive advantage.
  5. Explain the major components of an information systems infrastructure.
  6. Describe data storage and management.
  7. Describe how information systems are enabling new forms of commerce.
  8. Describe emerging technologies that enable new forms of business collaboration.
  9. Discuss business intelligence and its role in decision-making.
  10. Illustrate how enterprise systems foster stronger business relationships and enforce organizational structures and processes.
  11. Describe how organizations develop and acquire information systems.
  12. Discuss how to secure information systems resources.
  13. Evaluate the ethical concerns that information systems raise in society.

Content Outline and Competencies:

I. Information Systems Today

A. Describe the primary roles that information systems play in organizations.

B. Provide examples of how businesses, nonprofits and governments depend on information systems.

C. Provide examples of how information technology departments depend on information systems.

D. Discuss the increasing obligation of all employees to harness the power of information systems and minimize risk.

E. Identify several research areas in the discipline of management information systems (MIS).

II. Information Systems Components

A. Describe the main components of an information system and the role that each plays.

B. Distinguish between data, information and knowledge.

C. Describe the business value of information.

III. The Role of Information Systems in Globalization

A. Describe how enterprise information systems empower organizations to expand globally.

B. Explain the role the World Wide Web plays in globalization.

C. Illustrate the role business intelligence plays in data-driven decision making about global customers.

D. Describe how collaborative technologies enable global, virtual teams.

E. Describe an organization’s ethical concerns, privacy issues and security complications introduced by globalization.

IV. Information Systems as Competitive Advantage

A. Identify Porter’s five competitive forces that shape industry competition.

B. Explain the effect of disruptive innovations, government policies and complementary products/services on the competitive forces.

C. Describe the value chain and where it offers opportunities for strategic information systems.

D. Distinguish between the business use of information systems for competitive advantage and competitive necessity.

V. Information Systems Infrastructure Components

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

B. Identify and cite examples of the two major types of software.

C. Describe how software is created.

D. Describe the major types of networks and the transmission media they use.

E. Give examples of network protocols.

F. Explain the importance of enterprise architecture.

G. Describe how enterprise architecture has evolved over time.

VI. Databases and Data Warehouses

A. Explain the nature of information resources in terms of structure and quality.

B. Discuss how metadata can be used to describe these resources.

C. Compare file processing systems to databases and explain the database’s advantages.

D. Describe how a relational database is planned, accessed and managed.

E. Describe how the normalization process works.

F. Explain why multiple databases emerge and how master data management addresses the challenge of integration.

G. Describe how a data warehouse is created.

H. Explain the challenges and value of big data.

I. Explain how the human element and ownership issues affect information management.

VII. E-Commerce and M-Commerce

A. Explain how an organization identifies its desired Web strategy.

B. Provide examples of different website information architectures, including the importance of usability and accessibility.

C. List the prevalent software tools used for Web development.

D. Differentiate between e-commerce and m-commerce by explaining how each work.

E. Explain the various ways organizations market their websites.

F. Discuss how the Web continues to evolve by incorporating emerging technologies.

VIII. Collaborative Business Technologies

A. Describe prevalent collaborative technologies and the features that each offers for communications and productivity.

B. Describe Web 2.0 technologies that facilitate collaboration.

C. Explain how unified communications contribute to collaboration.

D. Recognize the features of online environments that can affect human behavior and group dynamics.

E. Identify strategies to make virtual teams more productive and successful.

IX. Business Intelligence

A. Define business intelligence.

B. Describe the three levels of decision-making that business intelligence supports.

C. Identify the major sources of business intelligence and provide examples of their usefulness.

D. Explain several approaches to data mining and analytics that improve data-driven decision making.

E. Explain why Web analytics is valuable for understanding customers.

F. Describe how business intelligence is visualized through dashboards, portals and mashups.

G. Explain the role that the human element plays in business intelligence initiatives.

X. Enterprise Information Systems

A. Explain the role that financial and asset management information systems play in an organization.

B. Discuss the importance of financial reporting and the increasing burden of compliance.

C. Define human capital management and identify its major components.

D. Describe several metrics used to quantify aspects of human capital.

E. Define supply chain management.

F. Describe the metrics, technologies and information systems that support supply chain processes.

G. Define customer relationship management and its role in an organization.

H. Describe the metrics and information systems that support customer relationship management.

I. Explain the importance of enterprise resource planning systems.

J. Describe how enterprise resource planning systems are created, integrated and implemented.

XI. Development and Acquisition of Information Systems

A. Illustrate the seven phases of the systems development life cycle.

B. Describe three major software development strategies.

C. Explain why organizations choose one software development strategy over another for particular projects.

D. Explain how organizations decide whether to build or buy an information system.

E. List the steps used to buy an information system.

F. Identify several ways in which the human element is important for systems development and procurement.

XII. Information Systems Security

A. Describe information privacy and strategies to protect it.

B. Explain how organizations identify threats and assess vulnerabilities.

C. Discuss how organizations develop administrative and technical controls to mitigate risks.

D. Explain why human behavior is often the weakest link for security and provide strategies for counteracting this weakness.

XIII. Information Systems Ethics

A. Define ethics.

B. Describe ethical frameworks.

C. Explain the relationship between ethics and the law.

D. Explain how intellectual property and plagiarism challenge information ethics.

E. Describe technologies that control access to digital content.

F. Explain why human behavior is often the weakest link for ethics and privacy, and provide strategies for counteracting this weakness.

Method of Evaluation and Competencies:

60-70%    Tests/Exams (minimum 4)
10-20%    Case Studies (minimum 8)
10-20%    Quizzes, homework
0-10%      Participation

Total: 100%

Grade Criteria:

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

Caveats:

1. Depending on students’ home computer configuration, completion of some homework assignments in the JCCC computer lab or alternate location may be required.

Student Responsibilities:

Disabilities:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 201H

  • Title: HON: Introduction to Information Systems*
  • Number: CIS 201H
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: Honors department approval.

Description:

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.

Supplies:

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

Objectives

Content Outline and Competencies:

Method of Evaluation and Competencies:

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 204

  • Title: UNIX Scripting and Utilities*
  • Number: CIS 204
  • Effective Term: 2018-19
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Requirements:

Prerequisites: CS 134 or CIS 142.

Description:

This course will cover the concepts and principles related to scripting for the multiuser, multitasking 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.

Supplies:

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

Objectives

Upon successful completion of this course, the student should be able to:

  1. Describe computer system hardware, software and development.
  2. Describe UNIX history, features and components.
  3. Access UNIX and implement commands.
  4. Create UNIX shell scripts.

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 History, Features and Components

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. Define portability and device independence.

2. Define multitasking.

3. Define multiuser.

4. Explain the 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 Access and Commands

A. Access the system.

1. Log in to UNIX.

2. Change passwords.

3. Log out of UNIX.

B. Employ special shell and file characters.

C. Utilize UNIX commands.

1. Manage files and directories.

2. Manage processes.

3. Manage devices.

4. Implement multitasking.

5. Create and modify data and script files with the “vi” editor.

6. Run UNIX utilities.

IV. UNIX Shell Scripts

A. Employ control structures.

B. Implement stream input and output.

C. Manage, automate and schedule processes.

D. Develop scripts for networking.

Method of Evaluation and Competencies:

40-60%    A minimum of 2 Examinations
40-60%    A minimum of 6 Projects

Total:    100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 208

  • Title: Mobile Application Development*
  • Number: CIS 208
  • Effective Term: 2018-19
  • 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.

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:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 240

  • Title: Advanced Topics in Java*
  • Number: CIS 240
  • Effective Term: 2018-19
  • 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.

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:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 242

  • Title: Introduction to System Design and Analysis*
  • Number: CIS 242
  • Effective Term: 2018-19
  • 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.

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:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 260

  • Title: Database Management*
  • Number: CIS 260
  • Effective Term: 2018-19
  • 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.

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:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 264

  • Title: Application Development and Programming*
  • Number: CIS 264
  • Effective Term: 2018-19
  • Credit Hours: 4
  • Contact Hours: 4
  • Lecture Hours: 4

Requirements:

Prerequisites: CIS 242 and CIS 260 and CS 235 or CIS 240 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.

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:

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

Caveats:

Student Responsibilities:

Disabilities:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 270

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

Requirements:

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

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.

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:

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

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:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 275

  • Title: Web-Enabled Database Programming*
  • Number: CIS 275
  • Effective Term: 2018-19
  • 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.

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:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).

CIS 291

No information found.

CIS 292

  • Title: Special Topics:*
  • Number: CIS 292
  • Effective Term: 2018-19
  • Credit Hours: 1 - 4
  • Contact Hours: 1 - 4
  • Lecture Hours: 1 - 4

Requirements:

Prerequisites: Department approval.

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.

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:

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you are a student with a disability and if you are in need of accommodations or services, it is your responsibility to contact Access Services and make a formal request. To schedule an appointment with an Access Advisor or for additional information, you may send an email or call Access Services at (913)469-3521. Access Services is located on the 2nd floor of the Student Center (SC 202).