This is an archived copy of the Spring 2015 Catalog. To access the most recent version of the catalog, please visit http://catalog.jccc.edu/.

Computer Personal Computer App (CPCA)

Courses

CPCA 105   Introduction to Personal Computers: Windows (1 Hour)

This introductory course is designed to give the beginning computer user an overview of the personal computer. The student will gain confidence in basic computing skills and concepts through a hands-on approach. Topics include an introduction to computer terminology, hardware, system software, application software, e-mail, and the Internet. 1 hr. lecture /wk.

CPCA 106   Introduction to Personal Computers: Macintosh (1 Hour)

This introductory course is designed to give the beginning computer user an overview of the Macintosh personal computer. The student will gain confidence in basic computer skills and concepts through a hands-on approach while becoming familiar with a Macintosh computer and its primary uses. Topics include computer software, hardware and terminology; as well as an introduction to the Macintosh operating system, word processing, drawing, spreadsheets and database management. 1 hr. lecture/wk.

CPCA 108   Word Processing I: MS Word* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CIS 124 or CPCA 128 or appropriate score on a waiver test

This course provides an introduction to the concepts and real-world applications of microcomputer word processing software. Foundational word processing competencies, including creating, saving, printing and editing word processing files; searching and replacing text; creating headers and footers; inserting and resizing graphic images; setting up tables; creating and applying styles, and creating mail merge letters, will be covered. Students will also create multiple-page reports and incorporate desktop publishing concepts and features. 1 hr. lecture/wk.

CPCA 109   Google Apps* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CIS 124 or CPCA 128 or appropriate score on a waiver test

This course provides an introduction to the concepts and real-world applications of Google Apps services and applications. Students will explore the most popular Google Apps on the market today, including Google Email, Google Calendar, Google Talk, Google Docs, Google Sites and Google Start Page. Hands-on, practical projects will be performed to reinforce the concepts taught. 1hr. lecture/wk.

CPCA 110   Spreadsheets I: MS Excel* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CIS 124 or CPCA 128 or appropriate score on a waiver test

Students will learn concepts and uses of spreadsheet software on the personal computer. Business decision-making worksheet models will be created and modified by entering labels, functions and formulas. Various formatting techniques will be applied to enhance the appearance of printed worksheets. Students will also learn to display the worksheet data graphically with the charting capabilities of the software. 1 hr. lecture/wk.

CPCA 111   Spreadsheets II: MS Excel* (1 Hour)

Prerequisites: CPCA 110 or CPCA 128

This course is a continuation of CPCA 110, Spreadsheets on the Microcomputer I, and will provide the student with intermediate level of spreadsheet concepts. Using typical business scenarios, the student will perform manual and automated "what-if" analyses, manage data in worksheets with tables and database functions, and use multiple worksheets to build consolidated statements. Basic macros will be introduced. 1 hr. lecture/wk.

CPCA 114   Databases I: MS Access* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or an appropriate score on a waiver test

This course provides an introduction to the concepts and real-world applications of microcomputer relational database software. Foundational database competencies, including building tables, defining fields, relating tables, entering and editing data, filtering, and sorting will be covered. Students will query the database to select, calculate and summarize information. Students will build and customize forms and reports. 1 hr. lecture/wk.

CPCA 115   Databases II: MS Access* (2 Hours)

Prerequisites: CPCA 114

Upon completion of this course, the student should be able to design and define a relational database; create custom forms and reports for data entry, updating and presentation; and build the necessary queries to support these objects. The student should be able to transfer data into and out of the database from various file formats; use database software to develop Web pages and hyperlinks; and manipulate the data and database with introductory macro, query language and programming skills. The course contains a capstone project in which the student uses all the skills learned to create a working database for a client based on a real-world situation. 2 hrs. lecture/wk.

CPCA 117   Databases III: MS Access* (1 Hour)

Prerequisites: CPCA 115

Upon successful completion of this course, the student should be able to analyze an existing database solution that is not working properly, import the data into Access and use action queries and SQL to normalize the database into an effective rational database. A case study emphasis will cover different database design and documentation issues. Students will also build complex forms and reports using Visual Basic for Applications programming code. 1 hr. lecture /wk.

CPCA 118   Groupware: Outlook* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or an appropriate score on a waiver test

This course provides an introduction to the concepts and applications of today's robust email systems. Students will use tha application to compose, send and receive e-mail; post and organize discussion messages; manage calendars, appointments, tasks, to-do lists; use contact management features; and work with instant messaging. 1 hr. lecture/wk.

CPCA 121   Introduction to Project Management* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or an appropriate score on a waiver test

Upon completion of this course, the student should be able to effectively manage projects using project management software. Students will learn about project management goals and terminology, create a project schedule and use project management methodologies and tools such as the Gantt chart, critical path method (CPM) and program evaluation review technique (PERT) chart to update a project and communicate project progress to others. Students will use other project management techniques such as applying resources, leveling overallocations, evaluating constraints and analyzing planned versus projected schedule and budget variables. 1 hr. lecture/wk.

CPCA 122   Assistive Technology (1 Hour)

This introductory course is designed to give the student with or without disabilities an overview of the personal and the adaptive hardware and software available. The student will gain confidence in basic computer skills and concepts through a hands-on approach while becoming familiar with the adaptive software and hardware available on the campus. 1 hr. lecture/wk.

CPCA 123   E-Presentation: MS PowerPoint* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CIS 124 or CPCA 128 or an appropriate score on a waiver test

Upon completion of this course, students should be able to organize and produce an effective on-computer or slide-generated presentation, complete with printed speaker notes and handouts plus overhead transparencies, using the basic features of a presentation graphics program. Students will use master pages, template files, text formatting, color schemes, various drawing tools, the automated outline feature and animation dissolve sequence and incorporate photographs. 1 hr. lecture/wk.

CPCA 125   Word Processing II: MS Word* (1 Hour)

Prerequisites: CPCA 108

This is a continuation of CPCA 108, Word Processing on Micros I. After completing this course students should be able to use advanced concepts and applications of word processing software. The applications will include working with templates, creating and modifying styles, customizing themes, creating a table of contents, using mail merge, linking and embedding objects, creating web pages, creating and editing macros, and customizing Word and automating parts of a document.. 1 hr. lecture/wk.

CPCA 128   PC Applications: MS Office (3 Hours)

Upon successful completion of this course, the student should be able to use the current version of Windows to create and organize files and folders and perform essential file management procedures such as copying, moving, deleting and renaming files and folders. An in-depth proficiency will also be attained with the use of the current version of MS Office Suite, word processing, spreadsheet, and presentation graphics applications. Hands-on, practical projects will be performed to reinforce the concepts taught. 3 hrs. lecture/wk.

CPCA 134   Managing Your Macintosh* (1 Hour)

Prerequisites: CPCA 106 or an appropriate score on an assessment test. Course offered in spring only

In this career-related course, students will be introduced through lecture material and hands-on practical projects to the essential concepts of file organization, utility software installation and use, font management and backup techniques. 1 hr. lecture/wk.

CPCA 138   Windows for Microcomputers* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or an appropriate score on an assessment test

At the completion of this course, the student will be able to discuss the components of the Windows desktop, use the Windows Help system, create and organize a folder system on a disk, perform file management commands, customize the Windows desktop environment, use the Search tool to locate files and folders, and perform file backup and disk maintenance procedures. The student will also be able to use performance monitoring tools, add hardware and software to the system, and use basic MS DOS directory and file management commands. 1 hr. lecture/wk.

CPCA 139   UNIX* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or assessment test

This course will introduce students to the major commands of the Unix operating system. E-mail, the VI editor and Telnet will be covered. Basic file and disk management projects will be completed in this course. 1 hr. lecture/wk.

CPCA 141   Internet I* (1 Hour)

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or appropriate score on an assessment test

This course will introduce the student to the commands and techniques required to effectively access the resources of the Internet. Students will use Windows applications to browse the Internet, locate and retrieve information and send and receive electronic mail and address security issues on the internet. 1 hr. lecture/wk.

CPCA 151   Internet II* (1 Hour)

Prerequisites: CPCA 141 or an appropriate score on an assessment test

This course will cover the commands and techniques required to effectively use various Internet application tools. The student will also use Windows and non-Windows applications to locate information, download and upload files, and create a Web page. Additionally the course will cover basic LINUX commands and publish a Web page to a Web server. 1 hr. lecture/wk.

CPCA 161   Introduction to Web Pages using HTML* (1 Hour)

Prerequisites: CPCA 151 or an appropriate score on an assessment test

This course will cover the commands and techniques required to create and publish World Wide Web pages using HyperText Markup Language. Topics covered will include basic text layout, background colors, formatting, ordered and unordered lists, tables, frames that include graphic images in a page and linking to other Web pages. 1 hr. lecture/wk.

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

CPCA 105

  • Title: Introduction to Personal Computers: Windows
  • Number: CPCA 105
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Description:

This introductory course is designed to give the beginning computer user an overview of the personal computer. The student will gain confidence in basic computing skills and concepts through a hands-on approach. Topics include an introduction to computer terminology, hardware, system software, application software, e-mail, and the Internet. 1 hr. lecture /wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Identify and use the basic components of a microcomputer system.
  2. Use the features of a graphical user interface.
  3. Use the operating system to manage files and folders.
  4. Use application programs to create, save, edit and print files.
  5. Create or copy graphic images and sound files.
  6. Use e-mail to send and receive messages with attachments.
  7. Use the Internet to access information, including current technology issues.

Content Outline and Competencies:

I. Microcomputer Concepts  
   A. Identify the hardware components of a microcomputer system
      1. Identify the properties of various microprocessors (CPUs)
      2. Explain the role of random access memory in computer storage and
processing
         a. Identify the most common amounts of RAM in a microcomputer
         b. Explain the types and characteristics of RAM
      3. Identify the types and characteristics of common peripheral
devices in a microcomputer system
         a. Storage devices (Indicate common current storage capacity.)
            1) Hard drive
            2) USB (flash) drive
            3) CD
            4) Network drive
         b. Input devices
            1) Keyboard
            2) Mouse
         c. Output devices
            1) Printer
            2) Monitor
   B. Identify and use common microcomputer software
      1. Name the two broad categories of software
         a. Operating System software
         b. Application software
      2. Define the purpose of operating system software
      3. Use operating system software to perform basic operational tasks
         a. Start the computer and run multiple programs
         b. Manage multiple windows
            1) Move
            2) Resize
            3) Minimize
            4) Maximize
         c. Use menus, toolbars, and panes
         d. Use Windows Help and Support
      4. Define the purpose of application software
      5. Use application software to perform specific tasks
         a. Start an Application Program
         b. Create, Open, Edit, and Save a word processing document
         c. Edit and format text
         d. Create or copy a graphic
         e. Copy data between programs
         f. Print a document
         g. Play a video or sound clip

II. File Management Concepts
   A. Identify and use file management skills to organize files and
folders
      1. Define the purpose of file management
      2. Open and view My Computer and Windows Explorer
         a. View the Folders list
         b. Create and rename files and folders
         c. Copy files and folders
         d. Move files between folders
         e. Delete and restore files and folders
         f. Change folder options
         g. Change file and folder list view
         h. Save files in designated folders
      3. Display disk and folder information
      4. Compress files and folders

III. Internet and E-Mail Concepts
   A. Identify and use the Internet and Web browsers to access
Information
      1. Connect to the Internet
      2. Open a Web page and follow links
      3. Search the Web
      4. Preview and Print a Web page
   B. Use e-mail to send and receive messages with attachments
      1. Compose and send e-mail
      2. Retrieve, read, and respond to e-mail
      3. Attach a file to an e-mail message

Method of Evaluation and Competencies:

      Minimum of five projects      60% of grade
      Minimum of two examinations   40% of grade
                  Total            100% 
   
Grade Criteria:
      90 -100% A
      80 - 89% B
      70 - 79% C
      60 - 69% D
       0 - 59% F

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.

CPCA 106

  • Title: Introduction to Personal Computers: Macintosh
  • Number: CPCA 106
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Description:

This introductory course is designed to give the beginning computer user an overview of the Macintosh personal computer. The student will gain confidence in basic computer skills and concepts through a hands-on approach while becoming familiar with a Macintosh computer and its primary uses. Topics include computer software, hardware and terminology; as well as an introduction to the Macintosh operating system, word processing, drawing, spreadsheets and database management. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Identify the basics of a Macintosh computer system from starting up the operating system, using the mouse, working with menus, folders and icons to shutting down the operating system.
  2. Initialize a new disk, copy, delete and move files.
  3. Define and describe four basic software applications of word processing, spreadsheets, database management and graphics.
  4. Open and use a word processing application to enter, format, edit text, and to print and save a word-processed file.
  5. Open and use a spreadsheet application to enter data, copy, format and enter formulas, create a chart and to print and save the worksheet as a spreadsheet file.
  6. Open and use a database to create a data file, perform a search, sort the data, insert graphics, and to print and save the database file.
  7. Open and use a graphics application to create, draw and edit, and to print and save drawing images as a graphics file.

Content Outline and Competencies:

I. Macintosh Personal Computer System
   A. Ks, megs, gigs and disks
      1. Define bits, bytes, kilobytes.
      2. Describe floppy disks.
      3. Initialize a new floppy disk.
      4. Lock and unlock a disk.
      5. Define megabytes, gigabytes.
      6. Label disks.
      7. Discuss hardware and software.
   B. Starting up
      1. Turn the Macintosh on.
      2. Define internal and external hard disk.
      3. Discuss other attached devices.
      4. Use the monitor.
      5. Insert a disk into a drive.
      6. Insert a CD into a CD-ROM drive.
   C. The mouse
      1. Use the pointer
      2. Use the mouse.
      3. Move the mouse.
      4. Access and use the mouse control panel.
      5. Connect the mouse.
      6. Clean the mouse.
   D. Desktop and finder
      1. Define the desktop.
      2. Define the finder.
      3. Organize the desktop.
      4. Understand how to hide others.
      5. Clean up the desktop.
      6. Select desktop colors or patterns.
   E. Menus
      1. Choosing a menu command.
      2. Use pop-out, pop-up, and contextual menus.
      3. Understand gray vs. black commands.
      4. Use keyboard shortcuts.
      5. Understand ellipses in the menus.
   F. Important keys
      1. Define modifier keys.
      2. Use command, option (Alt), control keys.
      3. Use spacebar, F keys, arrow keys.
   G. Windows
      1. Identify title bar.
      2. Moving the window.
      3. Identify the active window.
      4. Use size, zoom, collapse and close boxes.
      5. Use scroll bars, arrows, and boxes.
      6. Organize desktop windows.
   H. Folders, icons and files
      1. Create and name a new folder.
      2. Open and put a file into a folder.
      3. Define disk, folder, application and document icons.
      4. Move and rename icons.
      5. Open an application.
      6. Open a document from the desktop.
      7. Discuss rules for naming files.
      8. Copy and select files.
      9. Describe save vs. save as.
      10.   Use the trash can.
      11.   Choose a printer.
      12.   Print a document.
      13.   Print the desktop.

II. Applications  
   A. Word processing concepts
      1. Demonstrate opening a document.
      2. Move the insertion point.
      3. Demonstrate entering text.
      4. Define word wrap.
      5. Define paragraphs (hard carriage returns).
      6. Demonstrate inserting and deleting text.
      7. Define defaults.
      8. Define toggle.
      9. Use application help feature.
     10. Demonstrate assigning attributes, line spacing, and alignments to
text.
     11. Demonstrate inserting graphic image into document.
     12. Describe creating a header.
   B. Spreadsheet concepts
      1. Enter new data into a worksheet.
      2. Insert a new row into a spreadsheet.
      3. Create and edit formulas.
      4. Use built-in functions.
      5. Copy data and formulas into new cells.
      6. Create a chart.
      7. Copy a chart to a document.
   C. Database concepts
      1. Create a database file.
      2. Demonstrate defining fields.
      3. Demonstrate adding new records to the file.
      4. Discuss sorting records.
      5. Create a columnar report layout.
   D. Drawing concepts
      1. Demonstrate selecting tools.
         a.  Describe tools in toolbox.
      2. Discuss how to select colors.
      3. Create and draw image.
      4. Copy image to clipboard.
   E. Clipboard
      1. Describe the clipboard.
      2. Demonstrate the methods of placing items on clipboard.
      3. Demonstrate pasting the contents of the clipboard.
   F. Multitasking
      1. Demonstrate opening multiple documents.
      2. Demonstrate switching between applications.
      3. Describe copying data between applications.

III. Folders and File Management Concepts
   A. Selecting a drive
      1. Select drive on which file is to be saved.
   B. Creating folders
      1. Create a folder in the root directory.
      2. Create a folder within another folder.
      3. Demonstrate opening and closing folders.
   C. Copying files and folders
      1. Copying a file to another drive.
      2. Copying a file to another folder.
   D. Moving files and folders
      1. Moving a file to another drive.
      2. Copying a file to another folder.
   E. Renaming files and folders
      1. Rename a file.
      2. Rename a folder.
   F. Deleting files and folders
      1. Delete a file.
      2. Delete a folder.

Method of Evaluation and Competencies:

Minimum of 4 projects    80% of grade
Minimum of 1 quiz        20% of grade
Total                   100% 

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

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.

CPCA 108

  • Title: Word Processing I: MS Word*
  • Number: CPCA 108
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CIS 124 or CPCA 128 or appropriate score on a waiver test

Description:

This course provides an introduction to the concepts and real-world applications of microcomputer word processing software. Foundational word processing competencies, including creating, saving, printing and editing word processing files; searching and replacing text; creating headers and footers; inserting and resizing graphic images; setting up tables; creating and applying styles, and creating mail merge letters, will be covered. Students will also create multiple-page reports and incorporate desktop publishing concepts and features. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Start Windows and the word processing software and understand the technical terminology used.
  2. Create, save, and manage word-processing files, and perform editing of word-processing text.
  3. Master page layout and printing techniques.
  4. Search and replace text, use the spell checking, thesaurus, and grammar checking features, and master character formatting.
  5. Perform paragraph formatting and creation of headers and footers.
  6. Insert and resize a graphic image.
  7. Set up tables in word-processing text and insert objects into documents.
  8. Attach a template and apply styles.
  9. Create a table; add rows and shading to a table.
  10. Create, edit, and format a mail merge form letter.
  11. Identify and use desktop publishing features.

Content Outline and Competencies:

I. Word Processing Concepts
   A. Define word processing terms
   B. Discuss features of word processing software
   C. Discuss the importance of creating professional documents

II. Work with Documents
   A. Create, save, and print a document
   B. Correct errors and undo and redo changes
   C. Adjust paragraph and line spacing
   D. Check spelling and grammar
   E. Change margins, alignment, and paragraph indents
   F. Emphasize points with bullets and numbering
   G. Change fonts, font sizes, and font styles
   H. Change the document theme
   I. Proofread the document

III. Multiple-Page Reports
   A. Create a multi-page report divided into sections
   B. Create and edit a table
   C. Sort rows in a table
   D. Modify a table's structure
   E. Create footnotes and endnotes
   F. Set tab stops
   G. Create headers and footers
   H. Insert a cover page

IV. Desktop Publishing and Mail Merge
   A. Identify desktop publishing features
   B. Create columns
   C. Insert and edit graphic images
   D. Wrap text around a graphic
   E. Use symbols and special typographic characters
   F. Add a page border
   G. Perform a mail merge
   H. Create a blog post

Method of Evaluation and Competencies:

Minimum of four projects      60% of grade
Minimum of two examinations   40% of grade
                             100% 
Grade Criteria:
   90 - 100%   A
   80 -  89%   B
   70 -  79%   C
   60 -  69%   D
    0 -  59%   F

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.

CPCA 109

  • Title: Google Apps*
  • Number: CPCA 109
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CIS 124 or CPCA 128 or appropriate score on a waiver test

Description:

This course provides an introduction to the concepts and real-world applications of Google Apps services and applications. Students will explore the most popular Google Apps on the market today, including Google Email, Google Calendar, Google Talk, Google Docs, Google Sites and Google Start Page. Hands-on, practical projects will be performed to reinforce the concepts taught. 1hr. 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 cloud computing and current Google services and applications.
  2. Discuss and use Google Email.
  3. Describe and use Google Calendar.
  4. Explain and use Google Talk.
  5. Discuss and use Google Docs.
  6. Explain and use Google Sites.
  7. Discuss the Google Start Page.

Content Outline and Competencies:

I. Cloud Computing and Current Google Services and Applications
   A. Describe cloud computing.
   B. Discuss the advantages and disadvantages of cloud computing.
   C. Discuss current Google services and applications.
   D. Identify Google services and applications that require the establishment of a Google account.
   E. Identify Google services and applications that don’t require a Google account.

II. Google Apps Email
   A. Create a Google email account.
   B. Create, send and view email attachments.
   C. Organize email.
   D. Use chat.
   E. Create, send and view email using mobile devices.

III. Google Calendar
   A. Create and organize a schedule.
   B. Create and share events and meetings.
   C. Organize and search events.
   D. Publish calendars and events.

IV. Google Talk
   A. Identify other users online.
   B. Create and reply to instant messages.
   C. Create voice calls.
   D. Manage contacts.
   E. Manage chats.

V. Google Docs
   A. Create or upload basic documents, spreadsheets and presentations.
   B. Create and share files.
   C. Define and use on-screen chat.
   D. Organize and store files.
   E. Publish work as a Web page.

VI. Google Sites
   A. Create a basic website.
   B. Communicate and collaborate with others.
   C. Discuss and use on-screen chat.
   D. Organize and store files.
   E. Organize an offsite.

VII. Google Start Page
   A. Discuss the purpose of the Start Page.
   B. Identify changes that can be made by the user and the administrator.
   C. Discuss the steps to make changes to the Start Page based on the needs of the user.

Method of Evaluation and Competencies:

Assignments and Quizzes  60 - 80%
Exams  20 - 40%
Total  100%

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

Grade Criteria:

Caveats:

Every student will be required to create a separate Google email account.

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.

CPCA 110

  • Title: Spreadsheets I: MS Excel*
  • Number: CPCA 110
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CIS 124 or CPCA 128 or appropriate score on a waiver test

Description:

Students will learn concepts and uses of spreadsheet software on the personal computer. Business decision-making worksheet models will be created and modified by entering labels, functions and formulas. Various formatting techniques will be applied to enhance the appearance of printed worksheets. Students will also learn to display the worksheet data graphically with the charting capabilities of the software. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Analyze problems to determine whether they can be solved with spreadsheet software.
  2. Work through sample problems, such as budget preparation and expense monitoring.
  3. Enter and align labels and numbers.
  4. Enter functions, formulas with relative and absolute cell referencing.
  5. Copy formulas and data from a cell or range to another cell or range on the worksheet.
  6. Edit the contents of cells.
  7. Erase a specific area of the worksheet
  8. Insert and delete rows and columns in a worksheet
  9. Format numbers to display specific attributes.
  10. Format cells or ranges to display lines, shading and fonts that differ from default settings.
  11. Save a worksheet file to a specific directory or drive.
  12. Retrieve a worksheet file from a specific directory or drive.
  13. Define and create charts (graphs) from specified data in a worksheet.
  14. Add or modify specific titles and legends in a chart.
  15. Print ranges, entire worksheets and charts with specified headers and footers.

Content Outline and Competencies:

I. Introduction to Spreadsheets 
   A. Overview of Spreadsheets
   B. Characteristics of the Specific Spreadsheet Program

II. Work with the Specific Spreadsheet
   A. Load the Program
   B. Move Around the Spreadsheet
   C. Enter Labels, Values and Formulas
   D. Save and Retrieve
   E. Use the Command Menus and Tool Icons
   F. Enter Headers and Footers

III. Utilize Spreadsheet commands
   A. Copy Formulas
   B. Use Predefined Functions
   C. Insert and Delete Rows and Columns
   D. Use Help Features
   E. Perform Range Operations

IV. Employ Charts
   A. Define Manual and Automated Charts
   B. Position in Same Worksheet or Separate Worksheet
   C. Specify Bar, Pie and Line Styles
   D. Enter Titles, Legends, and Data Display

Method of Evaluation and Competencies:

Evaluation of student mastery of course competencies will be
accomplished using the following methods:

A minimum of four projects      40% of grade
A minimum of two examinations   60% of grade
Total                          100%
   
Grade Criteria:
   90 - 100%   A
   80 -  89%   B
   70 -  79%   C
   60 -  69%   D
    0 -  59%   F

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.

CPCA 111

  • Title: Spreadsheets II: MS Excel*
  • Number: CPCA 111
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 110 or CPCA 128

Description:

This course is a continuation of CPCA 110, Spreadsheets on the Microcomputer I, and will provide the student with intermediate level of spreadsheet concepts. Using typical business scenarios, the student will perform manual and automated "what-if" analyses, manage data in worksheets with tables and database functions, and use multiple worksheets to build consolidated statements. Basic macros will be introduced. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Perform what-if analysis by manual substitution of pertinent data.
  2. Apply the program's automated what-if analysis tool(s).
  3. Identity the elements of a database list.
  4. Sort data, query and maintain data lists.
  5. Filter records, and use the VLOOKUP function in database lists.
  6. Insert, delete, and copy worksheets in a workbook.
  7. Combine multiple worksheet files.
  8. Group worksheets for group editing.
  9. Create consolidated reports by referencing cells and ranges in multiple worksheets.
  10. Define and use named ranges in a worksheet.
  11. Record and run macros.

Content Outline and Competencies:

I. Review 
   A. Use command lines
   B. Generate charts
   C. Print Worksheets

II. Prepare and Examine What-If Alternatives
   A. Seek Solutions by Trial and Error Method
   B. Use Software Specific Goal Seeking Features
      1. Solver
      2. Create Versions and Scenarios

III. Create Worksheet Databases
   A. Create Database
   B. Set Up and Make Data Entries
   C. Sort on Single or Multiple Keys
   D. Do Criteria Searches
   E. Use Filters in Searches
   F. Use VLOOKUP

IV. Work with Multiple Worksheets
   A. Organize Worksheets in a Workbook
   B. Name/Rename Worksheets
   C. Insert Worksheets
   D. Delete Worksheets
   E. Move Worksheets
   F. Define and Use Range Names
   G. Create a Consolidation Worksheet
   H. Use Group Edits

V. Use Macros
   A. Record a Macro
   B. Run a Macro
   C. Briefly describe complex macros

Method of Evaluation and Competencies:

A minimum of four projects     40% of grade
A minimum of two examinations  60% of grade
                              100%
Grade Criteria:
   90 - 100%   A
   80 -  89%   B
   70 -  79%   C
   60 -  69%   D
    0 -  59%   F

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.

CPCA 114

  • Title: Databases I: MS Access*
  • Number: CPCA 114
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or an appropriate score on a waiver test

Description:

This course provides an introduction to the concepts and real-world applications of microcomputer relational database software. Foundational database competencies, including building tables, defining fields, relating tables, entering and editing data, filtering, and sorting will be covered. Students will query the database to select, calculate and summarize information. Students will build and customize forms and reports. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives


  1. Relate the purpose and advantages of using relational database software to real world information management problems.
  2. Create field names, define field data types, identify primary keys, and edit the appropriate field properties in building and modifying tables.
  3. Add, delete, copy, and edit records in a datasheet and form.
  4. Link tables with appropriate relationships.
  5. Sort and filter data.
  6. Build queries to select, calculate, and summarize fields and records.
  7. Create and modify forms to enter and maintain data.
  8. Build and modify reports.

Content Outline and Competencies:

I. Database Concepts
   A. Explain the purposes for a database
   B. Describe the advantages of a database
   C. Define the terms: Field, Record, Table, Primary Key Field, Query,
Form, Report 

II. Database Software Overview
   A. Create and modify a table structures
   B. Enter and update data using datasheets  
   C. Create and modify select and summary queries 
   D. Enter and update data using a query datasheet 
   E. Create and modify data entry forms
   F. Enter and update data using a form
   G. Create and modify reports 

III. Database Structure
   A. Compare and contrast different field types 
   B. Compare, contrast, and apply different relationships, including:
      1. One-to-One
      2. One-to-Many
      3. Many-to-Many
   C. Use referential integrity

IV. Queries
   A. Create select queries
   B. Develop criteria to limit the recordset using logical and
mathematical operators
   C. Create calculated fields 
   D. Create summary fields using functions such as Sum, Average, and
Count
   E. Apply simple and complex filters

V. Forms
   A. Create forms with a wide variety of bound and unbound controls
   B. Modify controls 

VI. Reports
   A. Use report sections and controls to create simple and complex
reports
   B. Use expressions to create calculations on groups of records

VII. Database Management
   A. Compact a database
   B. Backup a database

Method of Evaluation and Competencies:

A minimum of two quizzes:        40% - 60% of grade
A minimum of five projects:      40% - 60% of grade
                                100%

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

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.

CPCA 115

  • Title: Databases II: MS Access*
  • Number: CPCA 115
  • Effective Term: Spring 2015
  • Credit Hours: 2
  • Contact Hours: 2
  • Lecture Hours: 2

Requirements:

Prerequisites: CPCA 114

Description:

Upon completion of this course, the student should be able to design and define a relational database; create custom forms and reports for data entry, updating and presentation; and build the necessary queries to support these objects. The student should be able to transfer data into and out of the database from various file formats; use database software to develop Web pages and hyperlinks; and manipulate the data and database with introductory macro, query language and programming skills. The course contains a capstone project in which the student uses all the skills learned to create a working database for a client based on a real-world situation. 2 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. Design a 3-5 table relational database from a set of customer reports and documentation.
  2. Build a working 3-5 table relational database according to customer requirements.
  3. Create the necessary queries, forms, reports, and macros to support a customer's documented requirements (3-5 objects per object type).
  4. Create parameter queries, filters, complex criteria matching, action, update queries, and introductory SQL statements.
  5. Create text boxes, combo boxes, subforms, list boxes, command buttons, and other bound, unbound, and calculated controls on forms.
  6. Create reports using advanced features such as grouping and calculated controls, and graphs.
  7. Import and export data from other file types such as text, spreadsheets, and HTML.
  8. Enhance the graphical user interface with dialog boxes and GUI screens.
  9. Create macros and macro groups, and attach them to command buttons, object events, and toolbars.
  10. Build basic functions and event procedures using VBA programming code.

Content Outline and Competencies:

I. Demonstrate a mastery of the introductory concepts learned in CPCA
114

II. Advanced Queries
   A. Build a query using complex query criteria involving multiple
fields
   B. Build a parameter queries
   C. Build a crosstab queries
   D. Analyze redundant data 
   E. Analyze unrelated records 
   F. Create a query to find top values
   G. Create action queries that make tables, append records, delete
records, and update fields
   H. Join tables within a query
   I. Use basic SQL commands to build a query and retrieve data

III. Advanced Forms
   A. Analyze the need for subforms controls and create them
   B. Use tab controls to enhance the design of a form
   C. Create combo boxes
   D. Add calculations to forms

IV. Advanced Reports
   A. Use multiple sorting and grouping fields
   B. Create calculated controls for multiple groups
   C. Create report totals

V. Importing and Exporting Data with other Programs
   A. Exporting Access data to HTML
   B. Export data to a spreadsheet
   C. Import CSV, XML, or other text files
      
VI. Analyze Relationships
   A. Analyze Many-to-Many Relationships
   B. Build One-to-Many Relationships
   C. Build One-to-One Relationships

VII. User Interface Issues
   A. Design and develop an end-user interface for the database
   B. Develop dialog boxes, error message prompts, and command buttons
   C. Create macros to automate common processes
   D. Create command buttons to run macros
   E. Create custom toolbars and menus

VIII. Introduction to database programming statements
   A. Use events to run macros and programming code
   B. Create procedures to update and change database properties
   C. Explain modules and use them to create procedures
   D. Create functions to calculate new values
   E. Test procedures using debug features

IX. Use database startup options for the following purposes:
   A. Setting appropriate levels of security
   B. Making the database easier to use

Method of Evaluation and Competencies:

A minimum of 3 quizzes     40% - 60% of grade
A minimum of 10 projects   40% - 60% of grade
                          100%

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

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.

CPCA 117

  • Title: Databases III: MS Access*
  • Number: CPCA 117
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 115

Description:

Upon successful completion of this course, the student should be able to analyze an existing database solution that is not working properly, import the data into Access and use action queries and SQL to normalize the database into an effective rational database. A case study emphasis will cover different database design and documentation issues. Students will also build complex forms and reports using Visual Basic for Applications programming code. 1 hr. lecture /wk.

Course Fees:

None

Supplies:

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

Objectives


  1. Analyze an existing database that is not working as intended, and determine the proper way to normalize the data.
  2. Import data into a database from multiple sources.
  3. Use action and update queries and SQL to fix data problems.
  4. Build forms with advanced controls.
  5. Understand object-oriented language as it relates to objects, collections, and events.
  6. Use VBA to automate forms.

Content Outline and Competencies:

I. Apply database design skills and documentation requirements to real
world cases
   A. Analyze data reporting and analysis needs.
   B. Normalize data.
   C. Diagram a database schema
   D. Use standard field and object naming conventions
   F. Create metadata for database documentation

II. Use database tools and SQL to import and scrubb data
   A. Analyze existing data accuracy and consistency
   B. Use import tools to bring data from various sources into a database
   C. Use action queries to create, update, and delete data
   D. Use SQL statements to create, update, and delete data

III. Use object-oriented programming to manipulate the database
   A. Manipulate objects in forms and reports
   B. Manipulate events in forms and reports

IV. Use Visual Basic for Applications to manipulate the database
   A. Use VBA to automate forms
   B. Use VBA to trap errors
   C. Use VBA to create functions

Method of Evaluation and Competencies:

A minimum of two quizzes:     40% - 60% of grade
A minimum of five projects:   40% - 60% of grade
                             100%

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

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.

CPCA 118

  • Title: Groupware: Outlook*
  • Number: CPCA 118
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or an appropriate score on a waiver test

Description:

This course provides an introduction to the concepts and applications of today's robust email systems. Students will use tha application to compose, send and receive e-mail; post and organize discussion messages; manage calendars, appointments, tasks, to-do lists; use contact management features; and work with instant messaging. 1 hr. 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 the purpose and typical features of a robust e-mail system.
  2. Send, receive, reply to, sort, delete, print, and file e-mail messages.
  3. Attach and receive files, format e-mail and configure distribution lists.
  4. Post, read, and respond to posted messages in shared databases, folders, or discussion groups.
  5. Manage personal and group calendars, set appointments, set events, manage tasks and todo lists.
  6. Organize and manage contacts and address books.
  7. Use instant messaging features.

Content Outline and Competencies:

I. Overview of E-Mail Applications
   A. Discuss e-mail history and its relationship to the growth of
local area networks and the Internet
   B. Compare today's features of e-mail to early products

II. Software Interface
   A. Use the interface to navigate throughout the features of the
software
   B. Customize the interface to meet the needs of the user


III. Messages
   A. Receive, view, send, forward, print, and delete f messages
   B. Insert e-mail signatures
   C. Organize, sort, and search messages using folders, flags, filters
   D. Create e-mail with file attachments
      1. Receive, view, launch, and save file attachments
      2. Send file attachments
   E. Discuss and use advanced delivery options
   F. Use advanced formatting features such as tables, formatted text,
hot
spots, links, collapsible sections, and HTML e-mail

IV. Address Book and Contacts
   A. Create, edit, and delete contacts
   B. Create, edit, and delete groups
   C. Use personal and global address books
   D. Find, track, and organize contacts

V. Calendars and Scheduling
   A. Create and edit calendar entries such as appointments, events, and
reminders
   B. Use the calendar to schedule group meetings
   C. Create and edit tasks/ to do list

VI. Instant Messaging
   A. Send and receive instant messages

   B. Attach and send files with instant messaging

Method of Evaluation and Competencies:

A minimum of 2 quizzes     40% - 60% of grade
A minimum of 5 projects    40% - 60% of grade
                          100%

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

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.

CPCA 121

  • Title: Introduction to Project Management*
  • Number: CPCA 121
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or an appropriate score on a waiver test

Description:

Upon completion of this course, the student should be able to effectively manage projects using project management software. Students will learn about project management goals and terminology, create a project schedule and use project management methodologies and tools such as the Gantt chart, critical path method (CPM) and program evaluation review technique (PERT) chart to update a project and communicate project progress to others. Students will use other project management techniques such as applying resources, leveling overallocations, evaluating constraints and analyzing planned versus projected schedule and budget variables. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Plan projects and create project schedules
  2. Break projects into tasks, milestones, and phases
  3. Analyze and estimate task durations
  4. Analyze task sequence and schedule them appropriately
  5. Analyze task relationships and apply them appropriately
  6. Assign resources to tasks
  7. Estimate start and finish dates of tasks, phases, and project
  8. Evaluate the project's critical path
  9. Use various techniques including task, resource, and date analysis to modify the schedule
  10. Track a project baseline
  11. Communicate the project plan using PERT, Gantt, and other charts and reports
  12. Track project progress using actual vs. planned data
  13. Use advanced project tools such as pooling resources and sharing projects to make the project more manageable

Content Outline and Competencies:

I. Introduction to Project Management
   A. Explain the goals of project management
   B. Write the phases of project management
   C. Apply project management terminology to a real case, including:
      1. Task
      2. Duration
      3. Relationship
      4. Resource
      5. Critical Path
   D. Explain how project management software enhances project management

II. Project Planning 
   A. Set project goals
   B. Analyze a project and break it into tasks, milestones, and phases
   C. Analyze tasks to create task sequencing
   D. Analyze tasks to create appropriate durations 
   E. Analyze tasks to create task relationships, including:
      1. Finish-to-Start
      2. Start-to-Start
      3. Finish-to-Finish
   F. Create project resources

III. Project Creation
   A. Enter and edit tasks, phases, milestones, and durations
   B. Enter and edit task relationships
   C. Assign resources to tasks
   D. Use various charts to view project
      1. Gantt
      2. PERT
   E. Use various techniques to analyze the critical path

IV. Project Communication
   A. Calculate project schedules and costs
   B. Preview and print appropriate charts and reports
   C. Develop a project baseline

V. Track Progress
   A. Enter and update actual vs. scheduled tasks, durations, and resource
allocations
   B. Compare baseline versus actual schedule and cost projections using
various charts and reports
   C. Use various task, duration, constraint, and resource variables to
control projects that are off schedule or over budget

VI. Advanced Project Management
   A. Manage resources across multiple projects
   B. Use advanced project management tools such as resource leveling 
   C. Customize reports
   D. Consolidate multiple projects into one master project

Method of Evaluation and Competencies:

A minimum of 2 quizzes     40% - 60% of grade
A minimum of 5 projects    40% - 60% of grade
                          100%

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

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.

CPCA 122

  • Title: Assistive Technology
  • Number: CPCA 122
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Description:

This introductory course is designed to give the student with or without disabilities an overview of the personal and the adaptive hardware and software available. The student will gain confidence in basic computer skills and concepts through a hands-on approach while becoming familiar with the adaptive software and hardware available on the campus. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Identify the basic components of a standard microcomputer system.
  2. Recognize the standard and modified keyboard.
  3. Point, click, double-click, and drag with an adaptive mouse.
  4. Open and select menu commands using the appropriate tools.
  5. Select a drive, format a disk, create a new folder, remove a folder, copy and/or move a file, and delete a file through file management.
  6. Create, save, edit, and print the contents of a simple file using standard and adaptive software and hardware.
  7. Navigate and identify elements on an Internet web page.
  8. Identify and access Assistive Technology available at Johnson County Community College.
  9. List the characteristics of various disabilities with reference to the Americans with Disabilities Accessibility Requirements Act.
  10. Acquire experience with Screen Reading, Reduced Motion, Voice Input and Print Access software.
  11. Perform the appropriate steps to shut down the computer system.

Content Outline and Competencies:

I. Microcomputer Basics
   A. Identify hardware
      1. Define the CPU
      2. Define storage devices
      3. Describe RAM
      4. Describe ROM
   B. Define operating system concepts
      1. Locate Microsoft Windows accessibility options
      2. Identify application programs
      3. Experience using Assistive Technology programs

II. The Keyboard
   A. Manipulate a standard keyboard
   B. Control a modified keyboard
   C. Type using the keypad
   D. Identify numeric keypad
   E. Utilize intermediate keypad
   F. Identify function keypad

III. The Johnson County Community College Computer Systems
   A. Recognize the jccc.net computer network components
   B. Log in to access class schedules
   C. Find Pipeline account
   D. Check grades online
   
IV. Disabilities and Assistive Technologies
   A. Identify disabilities
      1. Blindness
      2. Low vision
      3. Learning disabilities
      4. Orthopedic disabilities
   B. Gain academic independence through the use of Assistive Technology
   C. Demonstrate JAWS screen reading systems
   D. Execute screen magnification systems
   E. Control print access systems
   F. Control reduced motion systems

V. Screen Reading System, Window Bridge
   A. Recognize keyboard layouts
   B. Demonstrate synthesizer control keys
   C. Stop the automated voice controls
   D. Apply, in exercises, the reading commands
   E. Control the pointer with Windows MouseKeys
   F. Interact with the Window Bridge control panel

VI. Screen Magnification System, ZoomText
   A. Load ZoomText
   B. Select ZoomText User Interface
   C. Close ZoomText
   D. Minimize and maximize ZoomText
   E. Enter Zoom modes

VII. Print Access Systems, Kurzweil  3000
   A. Identify key functions of Kurzweil  3000
   B. Access the  Kurzweil  3000 menus
   C. Discuss the "Where Am I" key
   D. Select text and objects
   E. Execute the scan key
   F. Navigate in Kurzweil  3000
   G. Start the speak key
   H. Utilize the Escape key
   I. Identify the main menu
   J. Use Windows High Contrast for reading documents
   K. Create a document
   L. Scan a document

VIII. Using the Johnson County Community College Library resources
   A. Tour of Assistive Technology in the campus Library 
   B. Describe Adaptive Technology available in the library

Method of Evaluation and Competencies:

Examinations          50% of grade
Projects/Assignments  50% of grade
                     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.

CPCA 123

  • Title: E-Presentation: MS PowerPoint*
  • Number: CPCA 123
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CIS 124 or CPCA 128 or an appropriate score on a waiver test

Description:

Upon completion of this course, students should be able to organize and produce an effective on-computer or slide-generated presentation, complete with printed speaker notes and handouts plus overhead transparencies, using the basic features of a presentation graphics program. Students will use master pages, template files, text formatting, color schemes, various drawing tools, the automated outline feature and animation dissolve sequence and incorporate photographs. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Set up a presentation template.
  2. Import and place text and graphics.
  3. Create text and graphic elements using all tools.
  4. Position items exactly using alignment features.
  5. Alter type specifications to adjust style, size, weight and justification.
  6. Create template formats from within the application.
  7. Check spelling.
  8. Create effective dissolves, wipes and other transitions.
  9. Save, duplicate, close and print overheads and speaker notes.

Content Outline and Competencies:

I. Introduction To Presentation Graphics
   A. Describe basic computer hardware
   B. Describe the operating system attributes

II. Use Presentation Graphics Software
   A. Create and save a presentation file
   B. Set automatic outlining attributes for slides
   C. List basic tools
   D. Create text formatting
   E. Use template files
   F. Create master pages
   G. Create drawn images
   H. Integrate animation dissolve sequences
   I. Create color schemes
   J. Copy, cut, delete and paste items
   K. Print a presentation
   L. Save and close a presentation

III. Create Hands-on Project, including:
   A. Create a one minute on-computer presentation
   B. Create, import and align graphic images
   C. Use special effects for slide transitions
   D. Incorporate text specifications for style, size, weight and
justification
   E. Print speaker notes and handouts for the visual presentation
   F. Print presentation images

Method of Evaluation and Competencies:

Completion of one multi-slide project.
Completion of four projects, one quiz, one final project

The course grade will be based on the following allocation:

4 projects       50% of grade
1 Quiz           20% of grade
1 Final Project  30% of grade
                100%

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

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.

CPCA 125

  • Title: Word Processing II: MS Word*
  • Number: CPCA 125
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 108

Description:

This is a continuation of CPCA 108, Word Processing on Micros I. After completing this course students should be able to use advanced concepts and applications of word processing software. The applications will include working with templates, creating and modifying styles, customizing themes, creating a table of contents, using mail merge, linking and embedding objects, creating web pages, creating and editing macros, and customizing Word and automating parts of a document.. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Create and modify a template.
  2. Add text to a template.
  3. Create a new document from a template.
  4. Create, modify, and apply styles.
  5. Create and customize a document theme.
  6. Create and edit an outline and table of contents.
  7. Create, edit, and format mail merge form letters and mailing labels.
  8. Track changes and make comments in a document.
  9. Embed and modify a worksheet.
  10. Modify and update a linked chart.
  11. Create and format a Web page.
  12. Insert and edit hyperlinks.
  13. Customize the program and automate parts of a document.
  14. Create, edit, and save macros.

Content Outline and Competencies:

I. Templates and Outlines
   A. Create a new document from an installed template
   B. Save, open, and delete a new template
   C. Understand themes, styles, and style sets
   D. Customize the document theme
   E. Create and modify a style
   F. Use outline view
   G. Create a table of contents
   H. Use the Research task pane

II. Mail Merge
   A. Describe the mail merge process
   B. Select or create a main document
   C. Select or create a data source
   D. Edit the main document
   E. Edit an existing data source
   F. Merge the main document and data source
   G. Sort records
   H. Create mailing labels
   I. Convert tables to text

III. Advanced Formatting Techniques
   A. Track changes in a document
   B. Insert and delete comments
   C. Accept and reject changes
   D. Compare and combine documents
   E. Embed and modify a worksheet
   F. Modify and update a linked chart

IV. Web Pages
   A. Create and format a Web page
   B. Insert and edit hyperlinks
   C. Save a Word document as a Web page
   D. View a Web document in a Web browser

V. Customize and Automate Word
   A. Create and modify styles within a document template
   B. Use smart tags
   C. Create a watermark
   D. Create and insert Quick Parts
   E. Customize AutoCorrect
   F. Work with Columns and different widths
   G. Manage document properties
   H. Automate parts of a document using fields

VI. Macros
   A. Record and run macros
   B. Edit macros using Visual Basic
   C. Import and run Visual Basic macros
   D. Record an AutoMacro

Method of Evaluation and Competencies:

Minimum of four projects     60% of grade
Minimum of two examinations  40% of grade
Total                        100% 

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

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.

CPCA 128

  • Title: PC Applications: MS Office
  • Number: CPCA 128
  • Effective Term: Spring 2015
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Description:

Upon successful completion of this course, the student should be able to use the current version of Windows to create and organize files and folders and perform essential file management procedures such as copying, moving, deleting and renaming files and folders. An in-depth proficiency will also be attained with the use of the current version of MS Office Suite, word processing, spreadsheet, and presentation graphics applications. Hands-on, practical projects will be performed to reinforce the concepts taught. 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. Create and organize folders on a disk drive using WIN commands
  2. Execute WIN file management commands such as copying, deleting and renaming files
  3. Launch applications using the WIN graphical user interface
  4. Create, edit and print documents using the Word word-processing application software
  5. Create, format and print Excel spreadsheets and charts
  6. Create PowerPoint presentation slides incorporating multimedia and transition effects
  7. Send and receive email, interact with the world wide web and conduct Internet searches using the Netscape browser.

Content Outline and Competencies:

I. Windows Operating System
   A. Discuss the components of a personal computer system and the
function of each
   B. Organize the disk drive by creating folders for files and
sub-folders
   C. Perform copy, move, rename and delete file management commands
   D. Perform minimize, maximize, restore and resize screen functions
   E. Launch applications, find help and find files

II. Word Word-Processing Application
   A. Execute startup and exiting the word-processing application
   B. Discuss the components of the word-processing window
   C. Choose commands using toolbars and menus
   D. Correct spelling errors with the spell checker
   E. Create, save and print a document
   F. Use the help system
   G. Open, rename and save a previously saved document
   H. Move the insertion point around the document to insert or delete
text
   I. Select text
   J. Delete text
   K. Use UNDO and REDO edit commands
   L. Move and copy text around the document
   M. Find and replace text
   N. Change margins, alignment and indents
   O. Format text with boldfacing, underlining, italicizing, font size and
font style
   P. Create a multi-page report divided into sections
   Q. Center a page between margins
   R. Create a header or footer
   S. Perform page numbering
   T. Attach a style template
   U. Create a table
   V. Perform math in a table and add/delete rows
   W. Widen table columns, add shading and align table text

III. Excel Spreadsheet Application
   A. Execute starting and exiting the spreadsheet application
   B. Discuss the major components of the spreadsheet application window
   C. Navigate a workbook and worksheet
   D. Open, save, print and close a worksheet
   E. Enter text, numbers and formulas
   F. Correct mistakes
   G. Perform what-if analysis
   H. Clear cell contents
   I. Use the spreadsheet help system
   J. Discuss the differences between absolute, mixed and relative cell
referencing
   K. Use functions in formulas
   L. Insert and delete rows and columns
   M. Use the UNDO and REDO editing commands
   N. Move and copy a range of cells
   O. Format and align values and text
   P. Create headers and footers
   Q. Spell check the worksheet
   R. Copy formulas using the fill handle
   S. Add comments and graphics to the worksheet
   T. Protect cell formulas
   U. Print formulas 
   V. Create and edit various types of charts
   W. Discuss object linking and embedding(OLE)
   X. Embed wordart, clipart and other graphics in a spreadsheet
   Y. Link a worksheet to a word processing document

IV. Powerpoint Presentation Graphics
   A. Execute startup and exiting Powerppoint
   B. Discuss the components of the Powerpoint window
   C. Edit presentation text
   D. Insert and delete slides
   E. Open an existing presentation
   F. Use the Powerpoint Help system
   G. Create speaker notes
   H. Preview, print and save a presentation
   I. Resize and move graphics and text boxes
   J. Change existing slide layouts
   K. Insert pictures and clipart
   L. Create an organization chart
   M. Draw and manipulate graphic objects
   N. Apply a design template and use the Master slide
   O. Find and replace text
   P. Build a graph and create a table
   Q. Apply special effects to a slide
   R. Import an outline from Word into Powerpoint and export it back to
Word
   S. Embed sound and video multimedia effects in slides
   T. Link and modify an Excel chart
   U. Use the Slide Navigator and Meeting Minder
   V. Set up a self running presentation

Method of Evaluation and Competencies:

Examinations and quizzes   62.5% of grade
Twelve projects            37.5% of grade
                          100%

Projects will be completed using Word, Excel, PowerPoint application
software, as well as the Windows operating system, to demonstrate mastery
of the above competencies.

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

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.

CPCA 134

  • Title: Managing Your Macintosh*
  • Number: CPCA 134
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 106 or an appropriate score on an assessment test. Course offered in spring only

Description:

In this career-related course, students will be introduced through lecture material and hands-on practical projects to the essential concepts of file organization, utility software installation and use, font management and backup techniques. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Install desk accessories, fonts, sounds and control panels and extensions
  2. Recover from a system crash using several techniques
  3. Install and configure virus detection software
  4. Install and manage fonts
  5. Create compressed archives of files
  6. Create backups of data 

Content Outline and Competencies:

I. Install and maintain system components
   A. Decompress a system file
   B. Select an external hard drive for startup
   C. Mount a disk image
   D. Run Disk First Aid
   E. Find items with Apple's Sherlock application
   F. Install a control panel
   G. Install a desk accessory
   H. Install a font
   I.  Create a screen capture
   J. Rebuild the desktop file
   K. Customize an icon's color with the Color Picker

II. Use Apple and third party utility applications
   A. Print a HyperCard stack
   B. Create an Apple Script to shut down a Mac
   C. Repair and optimize a volume(disk or hard drive)
   D. Increase processing memory for applications
   E. Install a task bar using the application GoMac

III. Manage fonts
   A. Plan font organization
   B. Rename a font suitcase
   C. Install fonts outside the System Folder
   D. Decompress font resources
   E. Turn on fonts with Adobe Type Manager Deluxe

IV. Creating backups
   A. Reduce the size of files and folders with compression software
   B. Create self-extracting archives
   C. Calculate file size and compression percentages

Method of Evaluation and Competencies:

A minimum of 4 projects    70% of grade
A minimum of 1 examination 30% of grade
                          100%

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

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.

CPCA 138

  • Title: Windows for Microcomputers*
  • Number: CPCA 138
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or an appropriate score on an assessment test

Description:

At the completion of this course, the student will be able to discuss the components of the Windows desktop, use the Windows Help system, create and organize a folder system on a disk, perform file management commands, customize the Windows desktop environment, use the Search tool to locate files and folders, and perform file backup and disk maintenance procedures. The student will also be able to use performance monitoring tools, add hardware and software to the system, and use basic MS DOS directory and file management commands. 1 hr. 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 the various components of the Windows desktop.
  2. Use Windows Help in problem situations.
  3. Create folders and sub-folders.
  4. Open and use applications to save and retrieve data files to and from specified folders.
  5. Transfer information from one application to another with the clipboard.
  6. Share information among various Windows applications using Object Linking and Embedding (OLE).
  7. Use Windows Find to locate files, folders, and software.
  8. Create and use Desktop objects.
  9. Create shortcuts to folders, documents, and applications.
  10. Customize the Windows Environment, the Start Menu, and installed devices.
  11. Use the MS DOS mode of Windows 

Content Outline and Competencies:

I. Exploring the Basics
   A. Execute startup and shutdown of Windows
   B. Discuss the objects of the Windows desktop
   C. Use the mouse to point to objects
   D. Run software applications and switch between them
   E. Use the controls in a window
   F. Use the Windows Help system

II. Working with Files
   A. Use the format utility to initialize a disk
   B. Create, print and save a file
   C. Open and edit a file
   D. Discuss the rules for naming files
   E. Switch to the web style interface
   F. View files and change view options
   G. Perform file management operations such as move, copy, delete and
rename a file
   H. Navigate the Explorer window

III. Organizing Files with Windows Explorer
   A. Use Windows Explorer to view the structure of folders and files
   B. Use Windows Explorer to select, create and rename folders
   C. Use Windows Explorer to perform file management operations such as
moving, copying and deleting files and folders
   D. Create a printout showing the structure of files and folders
   E. Use the MS DOS mode to create directories, change directories,
manage files and launch applications

IV. Customizing the Desktop for Increased Productivity
   A. Position a document icon on the desktop
   B. Create and delete shortcuts
   C. Change the desktop appearance
   D. Use the Control Panel to access system settings
   E. Use power management features
   F. Customize the mouse
   G. Customize accessibility settings

V. Bringing the World Wide Web to the desktop
   A. Discuss the structure of the Internet and the World Wide Web
   B. Use the Exploring window to view, open, navigate and print web
pages
   C. Download a file
   D. Enable Active Desktop to add, move, resize, close and remove Active
Desktop items
   E. Subscribe to and unsubscribe to a channel
   F. Customize folders with Web content using Web view
   G. Modify taskbar toolbars

VI. Finding Files and Data
   A. Use the Windows Find utility
   B. Use Quickview to view files
   C. Search for objects on the Internet using query and subject searches
   D. Search with the Search Explorer bar

VII. Working with Graphics
   A. Use the Paint accessory program to open, edit and save a graphic
image file
   B. Use the various drawing tools in the Paint program
   C. Add color, format text and flip and stretch a graphic
   D. Copy and paste portions of a graphic

VIII. Object Linking and Embedding
   A. Insert data from other documents into the WordPad accessory program
   B. Use copy, cut and paste to transfer data from one document to
another
   C. Use the Calculator accessory
   D. Use the Clipboard viewer to view the contents of the clipboard
   E. Use Object Linking and Embedding to insert a graphic and a video
clip in a document
   F. Discuss and use Windows multimedia accessories

IX. Hardware, Printers and Fonts
   A. Print a document to the active printer and to a different printer
   B. Use the print queue to pause, remove and reorder print jobs
   C. Discuss serial, parallel and USB ports for connecting printers to a
computer
   D. Use the Add Printer Wizard
   E. Use the Print Troubleshooter
   F. Discuss Plug and Play
   G. Open the fonts window to examine fonts installed on a computer
   H. Use the System Information Utility to get system information

X. Disk Maintenance
   A. Use the Disk Cleanup accessory to remove unwanted files
   B. Restore deleted files from the recycle bin
   C. Use Scandisk to check for disk errors
   D. Use the disk Defragmenter to defragment a disk
   E. Use the task Scheduler to schedule disk maintenance tasks
   F. Use the Backup and Restore utilities
   G. Create a Startup disk

Method of Evaluation and Competencies:

Examinations and quizzes     50% of grade
A minimum of five projects   50% of grade
                            100%
                            
Grade Criteria:
   90 - 100%   A
   80 -  89%   B
   70 -  79%   C
   60 -  69%   D
    0 -  59%   F

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.

CPCA 139

  • Title: UNIX*
  • Number: CPCA 139
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or assessment test

Description:

This course will introduce students to the major commands of the Unix operating system. E-mail, the VI editor and Telnet will be covered. Basic file and disk management projects will be completed in this course. 1 hr. 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 UNIX software components and features.
  2. Access the UNIX system.
  3. Manage UNIX directories, files and processes.
  4. Create UNIX initialization files.
  5. Execute UNIX utilities. 

Content Outline and Competencies:

I. Describe UNIX software components and features, including:
   A. Multi-tasking
   B. Multi-user
   C. Shells and shell programming
   D. Security

II. Access the UNIX System
   A. Login/Logout
   B. Change Password

III. Manage UNIX directories, files and processes, including:
   A. Create, change, list and remove directories
   B. Copy, move, display, create and change permission on files
   C. Originate, kill and check the status of processes
   D. Manipulate foreground and background processes

IV. Create and Edit Initialization files, including:
   A. .profile
   B. .kshrc

V. Perform tasks using UNIX utilities, including:
   A. e-mail
   B. vi editor
   C. telnet
   D. ftp

Method of Evaluation and Competencies:

Six projects   60% of grade
Two exams      40% of grade
   Total      100%   

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

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.

CPCA 141

  • Title: Internet I*
  • Number: CPCA 141
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or appropriate score on an assessment test

Description:

This course will introduce the student to the commands and techniques required to effectively access the resources of the Internet. Students will use Windows applications to browse the Internet, locate and retrieve information and send and receive electronic mail and address security issues on the internet. 1 hr. 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 the history and development of the Internet.
  2. Organize favorites to effectively store web addresses.
  3. Evaluate Search Engines for best results.
  4. Employ email to effectively send and receive messages including attachments.

Content Outline and Competencies:

I. Introduction To Internet
   A. Describe the history of Internet
   B. List Hardware components of Internet

II. Internet Applications
   A. Explore the World Wide Web using a Web Browser
   B. Identify hypertext links and URL addresses
   C. Manage multiple tabs in a web browser
   D. Explain the use of the History command
   E. Identify security issues 

III. Favorites
   A. Add a favorite
   B. Modify favorites
   C. Organize favorites

IV. Search Engines
   A. Use multiple search engines to search the Internet
   B. Apply Boolean Operators to search expression
   C. Save retrieved information

V. Electronic Mail 
   A. Set up an e-mail account
   B. Add contacts to an address book
   C. Send e-mail messages
   D. Send e-mail messages with attachments
   E. Read and reply to e-mail messages

Method of Evaluation and Competencies:

Projects       60% of course grade
Examinations   40% of course grade
              100%

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

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.

CPCA 151

  • Title: Internet II*
  • Number: CPCA 151
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 141 or an appropriate score on an assessment test

Description:

This course will cover the commands and techniques required to effectively use various Internet application tools. The student will also use Windows and non-Windows applications to locate information, download and upload files, and create a Web page. Additionally the course will cover basic LINUX commands and publish a Web page to a Web server. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Use Telnet software to establish an Internet connection.
  2. Use a Windows application to compress and decompress files
  3. FTP a file from a remote host using a Windows FTP client.
  4. FTP a file from a remote host using a FTP commands at the UNIX prompt.
  5. Subscribe to and cancel a listserv subscription
  6. Manage UNIX directories, files and permissions.
  7. Converse with other people on the Internet.
  8. Define HTML and use of HTML markup tags.
  9. Use Notepad to create a homepage with headings, text and hyperlinks to other Web resources.
  10. View and copy HTML source code. 

Content Outline and Competencies:

I. Use Electronic Mail To Subscribe and Send Messages
   A. Use a windows and non-windows application to send and receive
electronic mail
   B. Create address book and distribution lists

II. Connect To a UNIX System
   A. Login/Logout
   B. List contents of directories
   C. Create directories
   D. Change directories
   E. Remove files and directories
   F. Change permission on flies

III. Locating And Retrieving Information
   A. Locate FTP resources.
   B. Upload and download files with a Windows-based FTP client
application.
   C. Use a window's program to compress and decompress downloaded files.

IV. Creating a Web Page
   A. Design a Web Page
   B. Use Notepad to create a Web Page
      1. Insert headings and text
      2. Create hyperlinks to connect to other Web resources
   C. View and copy HTML source code
   D. Place Web page on provider's server

Method of Evaluation and Competencies:

A Minimum of 1 Project        60% of course grade
A Minimum of 1 Examination    40% of course grade
                             100%
Grade Criteria:
   90 - 100%   A
   80 -  89%   B
   70 -  79%   C
   60 -  69%   D
    0 -  59%   F

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.

CPCA 161

  • Title: Introduction to Web Pages using HTML*
  • Number: CPCA 161
  • Effective Term: Spring 2015
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 151 or an appropriate score on an assessment test

Description:

This course will cover the commands and techniques required to create and publish World Wide Web pages using HyperText Markup Language. Topics covered will include basic text layout, background colors, formatting, ordered and unordered lists, tables, frames that include graphic images in a page and linking to other Web pages. 1 hr. lecture/wk.

Course Fees:

None

Supplies:

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

Objectives

  1. Design a Web Page
  2. Create text for Internet web pages.
  3. Use text enhancement (headlines, color) in web pages.
  4. Use URLs in web pages.
  5. Create a table with a web page.
  6. Include graphic images in a web page.
  7. Use images to link to other web pages. 

Content Outline and Competencies:

I. Overview of HTML
   A. List the advantages of HTML
   B. Explain the limitations of HTML
   C. Describe the use of angle brackets
   D. Explain case-sensitivity 

II. Create Simple HTML Document
   A. Identify required applications
   B. Format text, including:
      1. Font style
      2. Size, justification, blinking
   C. Apply required HTML tags in a document, including:
      1. Title tags
      2. Head tags
      3. Body tags
   D. Provide for text, link, and background color
   E. Display and preview an HTML document

III. Using Headlines and Paragraph Tags
   A. Create Headlines
   B. Format Paragraphs

IV. Creating a Document with URLs
   A. Create a http URL
   B. Create a ftp URL
   C. Create a Gopher URL
   D. Create a mailto URL

V. Lists
   A. Create bullet lists
   B. Create numbered list
   C. Compose and construct menu list
   D. Nest lists

VI. Create Tables
   A. Use preformatted text
   B. Create heading, row, and data tags
   C. Provide for cell alignment
   D. Create a Boxed Table

VII. Images
   A. Format an Inline Image
   B. Define and use helper applications
   C. Use inline image as a hyperlink

VIII. Special Features
   A. Place Ruler Lines
   B. Use Special Characters

Method of Evaluation and Competencies:

Projects      60% of course grade
Examinations  40% of course grade
             100%

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

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.

CPCA 291

No information found.