Computer Personal Computer App (CPCA)

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

Courses

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

This course is designed to give the student an overview of essential personal computer concepts and skills. Current topics include computer terminology, hardware components, system software, application software, file management, email and the internet. Hands-on, real-world projects will be performed to reinforce the concepts taught. 1 hr. lecture /wk.

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

This course is designed to give the student an overview of essential Macintosh (Mac) computer concepts and skills. Current topics include computer terminology, hardware components, operating system software, application software, file management, email and the internet. Hands-on, real-world projects will be performed to reinforce the concepts taught. 1 hr. lecture/wk.

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

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

Upon successful completion of this course, students will demonstrate proficiency with word processing software on a personal computer. Foundational word processing competencies, including creating, saving and editing documents; inserting and resizing graphic images; creating and applying styles and themes; creating headers and footers; and setting up tables will be covered. Students will also create multipage reports and incorporate desktop publishing concepts and features. 1 hr. lecture/wk.

CPCA 109   Google Apps* (1 Hour)

Prerequisites or corequisites: 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 Google Apps services and applications. Students will explore the most popular Google Apps on the market today, including Google Email, Google Contacts, Google Calendar, Google Docs, Google Drive and Google Sites. Hands-on, practical projects will be performed to reinforce the concepts taught. 1hr. lecture/wk.

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

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

Upon successful completion of this course, students will demonstrate proficiency with 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 or corequisites: CPCA 110 or CPCA 128.

This course is a continuation of CPCA 110, Spreadsheets I: MS Excel, 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 113   Spreadsheets I, II & III: MS Excel* (3 Hours)

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

Upon successful completion of this course, students will demonstrate advanced proficiency with spreadsheet software on the personal computer. Business decision-making worksheet models will be created and modified by entering labels, functions and formulas. Additionally, students will perform manual and automated what-if analyses, manage data in worksheets with tables and database functions, create and edit charts and use multiple worksheets to build consolidated statements. Macros, advanced formulas and data intelligence tools will be covered. 3 hr. lecture/wk.

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

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or CS 134 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 or corequisites: 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, and build supporting queries. The student should be able to transfer data into and out of the database from various file formats, and manipulate data with introductory macro and programming skills. 2 hrs. lecture/wk.

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

Prerequisites or corequisites: CPCA 115.

Upon successful completion of this course, the student should be able to analyze an existing database that is not working properly and apply techniques to convert it into an effective relational database. A case study emphasis will cover different database design and documentation issues. Topics covered include relational database design, using action queries to normalize data and building a user interface. Students will also build complex forms and reports incorporating Visual Basic for Applications (VBA) programming code. 1 hr. lecture /wk.

CPCA 118   Groupware: Outlook* (1 Hour)

Prerequisites or corequisites: 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 the application to compose, send, open and reply to email; organize email; manage calendars; use contact management features; and work with tasks. 1 hr. lecture/wk.

CPCA 120   Computer User Support Skills* (3 Hours)

Prerequisites or corequisites: CPCA 105 or an appropriate score on a waiver test.

Upon successful completion of this course, students should understand key information and skills for user support professionals, including troubleshooting and problem solving, successful verbal and written communication with users, determining a client's specific needs and training end users. 3 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 123   E-Presentation: MS PowerPoint* (1 Hour)

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

Upon successful completion of this course, students will demonstrate proficiency with presentation software on a personal computer. Foundational presentation competencies, including planning, creating and editing a presentation; inserting graphics and objects; creating speaker notes; creating and formatting tables; applying transitions and animations; formatting custom shapes; and creating a self-running presentation, will be covered. 1 hr. lecture/wk.

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

Prerequisites or corequisites: CPCA 108 or CPCA 128.

This is a continuation of CPCA 108, Word Processing I: MS Word. After completing this course students should be able to use advanced concepts and applications of word processing software. The applications include working with templates, creating and modifying styles, customizing themes, generating a table of contents, using mail merge, linking and embedding objects, creating and editing macros, 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, students will demonstrate an in-depth proficiency with word processing, spreadsheet, database and presentation graphics applications. Students will use a current operating system to manage windows and applications, and create and organize files and folders. Students will conduct research on the Internet and apply information in secure documents using ethical and social standards of conduct. 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 a waiver test.

In this career-related course, students will be introduced to essential Macintosh (Mac) computer concepts and skills. Topics include the operating system (OS) tools; third-party utility software installation and use; backup applications and usage techniques; and font management. Hands-on, practical projects will be performed to reinforce the concepts taught. 1 hr. lecture/wk.

CPCA 138   Windows for Microcomputers* (1 Hour)

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

This course is designed to give the student an overview of the Windows Operating System. Topics include personalizing the work environment; advanced personalization and customization techniques; advanced search techniques; managing digital media; and managing networks, security and utilities. Hands-on, real-world projects will be performed to reinforce the concepts taught. 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 228   PC Applications II: MS Office* (3 Hours)

Prerequisites: CPCA 128 or (CPCA 108 and CPCA 110 and CPCA 114).

This course builds on the skills covered in CPCA 128, PC Applications: MS Office. After completing this course students should be able to use advanced concepts and applications of word processing, spreadsheet and database software. Hands-on practical projects will be performed to reinforce the concepts taught. 3 hr. lecture/wk.

CPCA 290   Computer Support Specialist Internship* (2 Hours)

Prerequisites: Department approval.

Students will work in an approved training situation under instructional supervision. The internship is designed to give the student the opportunity to use the knowledge and skills acquired in the Computer Support Specialist program. An average of 40-60 onsite hours will be required along with class assignments for a total of 90 hrs./semester.

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 292   Special Topics:* (1-3 Hour)

Prerequisites: Departmental approval.

This course periodically presents specialized topics in Personal Computer Applications that are not available in the regularly offered curriculum. Special Topics may be repeated for credit, but only on different topics.

CPCA 105

  • Title: Introduction to Personal Computers: Windows
  • Number: CPCA 105
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Description:

This course is designed to give the student an overview of essential personal computer concepts and skills. Current topics include computer terminology, hardware components, system software, application software, file management, email and the internet. Hands-on, real-world projects will be performed to reinforce the concepts taught. 1 hr. lecture /wk.

Supplies:

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

Objectives

  1. Identify current personal computer systems and components.
  2. Manage and organize files and folders.
  3. Use multiple applications to create, save and edit files.
  4. Use email to send and receive messages with attachments.
  5. Use the internet to access information using current browsers and search engines.

Content Outline and Competencies:

I. Personal Computer

A. Identify hardware components.

B. Define the purpose of operating system software.

C. Describe current application software.

D. Discuss peripheral devices.

II. File Management

A. Move, copy, rename, delete and restore files.

B. Organize files and folders.

C. Compress and extract files.

III. Applications

A. Create, save and edit files using multiple applications.

B. Copy data between programs.

C. Work with image and sound files.

IV. Email

A. Discuss and use multiple email clients.

B. Compose and send email.

C. Open and reply to email.

D. Attach and download files.

V. Internet

A. Use the Internet and current web browsers to access information.

B. Use current search engines to search for information.

C. Discuss security threats.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 106

  • Title: Introduction to Personal Computers: Macintosh
  • Number: CPCA 106
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Description:

This course is designed to give the student an overview of essential Macintosh (Mac) computer concepts and skills. Current topics include computer terminology, hardware components, operating system software, application software, file management, email and the internet. Hands-on, real-world projects will be performed to reinforce the concepts taught. 1 hr. lecture/wk.

Supplies:

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

Objectives

  1. Identify current Mac computer systems and components.
  2. Identify current operating system features.
  3. Use multiple applications to create, save and edit files.
  4. Manage and organize files and folders.
  5. Use email to send and receive messages with attachments.
  6. Use the Internet to access information using current web browsers and search engines.

Content Outline and Competencies:

I. Mac Computer

A. Identify hardware components.

B. Define the purpose of operating system software.

C. Describe current application software.

D. Discuss installing programs.

E. Discuss peripheral devices.

II. Operating System

A. Add a user account.

B. Customize the dock.

C. Customize the Share menu.

D. Discuss current operating system features.

III. Applications

A. Create, save and edit files using multiple applications.

B. Copy data between programs.

C. Work with image and sound files.

IV. File Management

A. Copy, move, rename, delete and restore files.

B. Organize files and folders.

C. Compress and extract files.

V. Email

A. Add an email account.

B. Compose and send email.

C. Open and reply to email.

D. Attach and download files.

VI. Internet

A. Use current web browsers to access information.

B. Use current search engines to search for information.

C. Discuss security threats.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 108

  • Title: Word Processing I: MS Word*
  • Number: CPCA 108
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

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

Description:

Upon successful completion of this course, students will demonstrate proficiency with word processing software on a personal computer. Foundational word processing competencies, including creating, saving and editing documents; inserting and resizing graphic images; creating and applying styles and themes; creating headers and footers; and setting up tables will be covered. Students will also create multipage reports and incorporate desktop publishing concepts and features. 1 hr. lecture/wk.

Supplies:

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

Objectives

  1. Create and edit documents.
  2. Navigate and format documents.
  3. Create tables and multipage reports.
  4. Enhance page layout and design.

Content Outline and Competencies:

I. Documents

A. Create, save and edit documents.

B. Adjust paragraph and line spacing.

C. Change margins, alignment and paragraph indents.

D. Apply text effects and copy formatting.

E. Change page orientation.

F. Insert paragraph and page borders.

G. Insert and edit a photo.

II. Navigation and Formatting

A. Work with comments.

B. Create bulleted and numbered lists.

C. Use the Navigation Pane.

D. Format text with styles.

E. Apply a theme to a document.

F. Insert and modify page numbers.

G. Create and modify citations and a bibliography.

III. Tables and Reports

A. Create a multipage 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.

IV. Page Layout and Design

A. Format text in columns.

B. Insert symbols, special characters and graphics.

C. Wrap text around a graphic.

D. Insert and format text boxes.

E. Create and modify WordArt.

F. Rotate and crop a graphic.

G. Add a page border.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 109

  • Title: Google Apps*
  • Number: CPCA 109
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites or corequisites: 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 Google Apps services and applications. Students will explore the most popular Google Apps on the market today, including Google Email, Google Contacts, Google Calendar, Google Docs, Google Drive and Google Sites. Hands-on, practical projects will be performed to reinforce the concepts taught. 1hr. lecture/wk.

Supplies:

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

Objectives

  1. Describe cloud computing and explore current Google services and applications.
  2. Discuss and use Google Email and Contacts.
  3. Describe and use Google Calendar.
  4. Discuss and use Google Docs, Sheets and Slides.
  5. Explain and use Google Drive.
  6. Discuss and use Google Sites.

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 and explore current Google services and applications.

D. Describe getting started with Google Apps.

II. Google Email and Contacts

A. Create a Google account.

B. Create, send and view email and attachments.

C. Organize email.

D. Manage contacts.

III. Google Calendar

A. Schedule events and appointments.

B. Create and manage tasks.

C. Share calendars.

D. Publish calendars and events.

IV. Google Docs, Sheets and Slides

A. Create and format documents, spreadsheets and presentations.

B. Collaborate and add comments.

C. Use Google tools.

D. Publish to the web.

V. Google Drive

A. Upload files and folders.

B. Create new files.

C. Manage files and folders.

D. Sharing files and folders.

VI. Google Sites

A. Create a basic website.

B. Customize web pages.

C. Add web pages.

D. Share a website.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

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

Student Responsibilities:

Disabilities:

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

CPCA 110

  • Title: Spreadsheets I: MS Excel*
  • Number: CPCA 110
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

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

Description:

Upon successful completion of this course, students will demonstrate proficiency with 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.

Supplies:

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

Objectives

  1. Create and edit spreadsheets.
  2. Format spreadsheets.
  3. Build formulas.
  4. Analyze and chart data.

Content Outline and Competencies:

I. Spreadsheets

A. Open, navigate and save a spreadsheet.

B. Enter text, numbers and dates.

C. Manipulate columns and rows.

D. Cut, copy and paste cell data.

E. Print worksheets and formulas.

II. Data and Cell Formatting

A. Modify font styles and color.

B. Format cells.

C. Apply conditional formatting.

D. Copy and paste formatting.

E. Format for printing including headers and footers.

III. Formulas

A. Enter and edit simple formulas.

B. Build formulas with functions.

1. Math and Trig

2. Statistical

3. Financial

4. Date and Time

5. Logical

6. Lookup and Reference

C. Create formulas with relative, mixed and absolute cell references.

D. Copy and paste formulas.

E. Protect cell formulas.

IV. Data Charting and Analysis

A. Build common chart types.

B. Modify and format chart elements.

C. Perform what-if analysis.

D. Use spell check, comments and other reference tools.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 111

  • Title: Spreadsheets II: MS Excel*
  • Number: CPCA 111
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites or corequisites: CPCA 110 or CPCA 128.

Description:

This course is a continuation of CPCA 110, Spreadsheets I: MS Excel, 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.

Supplies:

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

Objectives

  1. Work with tables, PivotTables and PivotCharts.
  2. Manage multiple worksheets and workbooks.
  3. Create workbook applications.
  4. Build advanced formulas using functions.

Content Outline and Competencies:

I. Tables, PivotTables and PivotCharts

A. Create and modify a spreadsheet table.

B. Use spreadsheet tables to edit, sort and filter data.

C. Build table formulas to summarize data.

D. Build PivotTables and PivotCharts to analyze data.

II. Worksheet and Workbook Manipulation

A. Build formulas that reference multiple worksheets.

B. Build formulas that reference multiple workbooks.

C. Build templates.

III. Workbook Applications

A. Apply cell and range names.

B. Validate data entry.

C. Protect worksheets and workbooks.

D. Create, edit and run macros.

IV. Advanced Formulas and Functions

A. Build formulas with multiple nested functions.

B. Build formulas using table syntax.

C. Build formulas that include error checking functions.

D. Build formulas with advanced statistical functions.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 113

  • Title: Spreadsheets I, II & III: MS Excel*
  • Number: CPCA 113
  • Effective Term: 2018-19
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Requirements:

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

Description:

Upon successful completion of this course, students will demonstrate advanced proficiency with spreadsheet software on the personal computer. Business decision-making worksheet models will be created and modified by entering labels, functions and formulas. Additionally, students will perform manual and automated what-if analyses, manage data in worksheets with tables and database functions, create and edit charts and use multiple worksheets to build consolidated statements. Macros, advanced formulas and data intelligence tools will be covered. 3 hr. lecture/wk.

Supplies:

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

Objectives

  1. Create and edit spreadsheets.
  2. Format spreadsheets.
  3. Build formulas.
  4. Analyze and chart data.
  5. Work with tables, PivotTables and PivotCharts.
  6. Manage multiple worksheets and workbooks.
  7. Create workbook applications.
  8. Build advanced formulas using functions.
  9. Analyze data using advanced tools.
  10. Use data intelligence tools.

Content Outline and Competencies:

I. Spreadsheets

A. Open, navigate and save a spreadsheet.

B. Enter text, numbers and dates.

C. Manipulate columns and rows.

D. Cut, copy and paste cell data.

E. Print worksheets and formulas.

II. Data and Cell Formatting

A. Modify font styles and color.

B. Format cells.

C. Apply conditional formatting.

D. Copy and paste formatting.

E. Format for printing including headers and footers.

III. Formulas

A. Enter and edit simple formulas.

B. Build formulas with functions.

1. Math and Trig

2. Statistical

3. Financial

4. Date and Time

5. Logical

6. Lookup and Reference

C. Create formulas with relative, mixed and absolute cell references.

D. Copy and paste formulas.

E. Protect cell formulas.

IV. Data Charting and Analysis

A. Build common chart types.

B. Modify and format chart elements.

C. Perform what-if analysis.

D. Use spell check, comments and other reference tools.

V. Tables, PivotTables and PivotCharts

A. Create and modify a spreadsheet table.

B. Use spreadsheet tables to edit, sort and filter data.

C. Build table formulas to summarize data.

D. Build PivotTables and PivotCharts to analyze data.

VI. Worksheet and Workbook Manipulation

A. Build formulas that reference multiple worksheets.

B. Build formulas that reference multiple workbooks.

C. Build templates.

VII. Workbook Applications

A. Apply cell and range names.

B. Validate data entry.

C. Protect worksheets and workbooks.

D. Create, edit and run macros.

VIII. Advanced Formulas and Functions

A. Build formulas with multiple nested functions.

B. Build formulas using table syntax.

C. Build formulas that include error checking functions.

D. Build formulas with advanced statistical functions.

IX. Advanced Data Analysis

A. Use the What-If Analysis tool.

B. Create one and two-variable data tables.

C. Create and analyze scenarios.

D. Find optimal solutions using Solver.

X. Data Intelligence Tools

A. Create data queries on large data sets.

B. Create data maps and charts.

C. Create and analyze scenarios.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 114

  • Title: Databases I: MS Access*
  • Number: CPCA 114
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 105 or CPCA 106 or CPCA 128 or CIS 124 or CS 134 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.

Supplies:

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

Objectives

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

  1. Describe the purpose and advantages of using relational database software to manage information.
  2. Create and modify tables.
  3. Relate tables with appropriate relationships.
  4. Modify records to add, delete, copy and edit data.
  5. Manipulate data to sort and filter information.
  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 database terminology.

II. Tables

A. Create and modify table structures.

B. Compare and contrast field types.

C. Modify field properties.

D. Create primary key fields.

III. Relationships

A. Compare, contrast and apply different relationships

1. One-to-One

2. One-to-Many

3. Many-to-Many

B. Describe and apply referential integrity.

IV. Data Entry

A. Modify records in datasheets and forms.

B. Explore records in datasheets and forms.

V. Sort and Filter

A. Order records using one or more sort fields.

B. Select records using textual, numeric and date criteria.

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

VII. Forms

A. Create forms with a wide variety of controls such as text boxes, labels, command buttons, images and combo boxes.

B. Modify control properties.

VIII. Reports

A. Create reports with text boxes and labels.

B. Modify report sections and controls to modify create reports.

C. Create expressions to create calculations on groups of records.

Method of Evaluation and Competencies:

40-60%    Quizzes
40-60%    Project

Total = 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 115

  • Title: Databases II: MS Access*
  • Number: CPCA 115
  • Effective Term: 2018-19
  • Credit Hours: 2
  • Contact Hours: 2
  • Lecture Hours: 2

Requirements:

Prerequisites or corequisites: 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, and build supporting queries. The student should be able to transfer data into and out of the database from various file formats, and manipulate data with introductory macro and programming skills. 2 hrs. lecture/wk.

Supplies:

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

Objectives

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

  1. Create advanced queries.
  2. Create advanced forms.
  3. Create advanced reports.
  4. Import and export data from other external files.
  5. Analyze table relationships.
  6. Enhance the user interface with dialog boxes, graphical elements and macros.
  7. Build custom functions and event procedures using Visual Basic for Applications (VBA) programming code.

Content Outline and Competencies:

I. Advanced Queries

A. Build parameter queries.

B. Build crosstab queries.

C. Analyze redundant data.

D. Analyze unrelated records.

E. Create queries to find top values.

F. Create action queries to make tables, append records, delete records and update fields.

G. Join tables within a query.

H. Use basic SQL commands to build a query and retrieve data.

II. Advanced Forms

A. Create forms with subforms.

B. Add tab controls to enhance the design of a form.

C. Create combo boxes to enter data or find data.

D. Add calculations to forms.

III. Advanced Reports

A. Apply multiple sorting and grouping fields.

B. Create calculated controls to subtotal data.

C. Create report totals.

IV. Data Importing and Exporting

A. Import and export data between Access and HTML.

B. Import and export data between Access and spreadsheets.

C. Import and export data between Access and text files.

D. Convert Access data to PDF.

IV. Analyze Relationships

A. Analyze many-to-many relationships.

B. Build one-to-many relationships.

C. Build one-to-one relationships.

D. Describe and apply referential integrity.

V. User Interface Issues

A. Design and develop navigation forms.

B. Create dialog boxes and error message prompts.

C. Create macros to automate common processes.

D. Create command buttons to run macros.

E. Create custom toolbars and menus.

VII. VBA Programming Code

A. Write event procedures to automate common tasks.

B. Create custom functions to calculate values.

C. Test and debug procedures.

Method of Evaluation and Competencies:

40-60%    Quizzes
40-60%    Projects

Total = 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 117

  • Title: Databases III: MS Access*
  • Number: CPCA 117
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites or corequisites: CPCA 115.

Description:

Upon successful completion of this course, the student should be able to analyze an existing database that is not working properly and apply techniques to convert it into an effective relational database. A case study emphasis will cover different database design and documentation issues. Topics covered include relational database design, using action queries to normalize data and building a user interface. Students will also build complex forms and reports incorporating Visual Basic for Applications (VBA) programming code. 1 hr. lecture /wk.

Supplies:

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

Objectives

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

  1. Create a correct relational design.
  2. Apply standard naming and documentation strategies to a relational database.
  3. Use action queries to fix data problems.
  4. Use VBA to automate forms.

Content Outline and Competencies:

I. Database Design Skills

A. Analyze customer data requirements.

B. Design normalized data for a relational database.

II. Documentation

A. Diagram a database schema.

B. Use standard field and object naming conventions.

C. Create metadata for database documentation.

III. Data Conversion

A. Analyze existing data accuracy and consistency.

B. Use action queries to create, update and delete data.

C. Create appropriate lookup tables.

IV. VBA

A. Create event handler procedures to automate forms.

B. Create procedures to trap errors.

Method of Evaluation and Competencies:

40-60%    Quizzes
40-60%    Projects

100%    Total

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 118

  • Title: Groupware: Outlook*
  • Number: CPCA 118
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites or corequisites: 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 the application to compose, send, open and reply to email; organize email; manage calendars; use contact management features; and work with tasks. 1 hr. lecture/wk.

Supplies:

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

Objectives

  1. Compose and manage email.
  2. Manage calendars.
  3. Create and manage contacts.
  4. Create and manage tasks.

Content Outline and Competencies:

I. Email

A. Configure account options.

B. Compose and send email.

C. View and reply to email.

D. Attach a file to an email.

E. Organize email messages in folders.

II. Calendars

A. Configure calendar options.

B. Create and manipulate appointments.

C. Schedule events and meetings.

D. Organize calendars with color categories.

E. Share a calendar.

III. Contacts

A. Create new contacts.

B. Modify contacts.

C. Sort and search for contacts.

D. Manipulate attachments to contacts.

E. Create and manage a contact group.

IV. Tasks

A. Create a new task.

B. Create recurring tasks.

C. Categorize tasks.

D. Assign a task.

E. Create and use notes.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 120

  • Title: Computer User Support Skills*
  • Number: CPCA 120
  • Effective Term: 2018-19
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Requirements:

Prerequisites or corequisites: CPCA 105 or an appropriate score on a waiver test.

Description:

Upon successful completion of this course, students should understand key information and skills for user support professionals, including troubleshooting and problem solving, successful verbal and written communication with users, determining a client's specific needs and training end users. 3 hr. lecture/wk.

Supplies:

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

Objectives

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

  1. Describe the history of computer user support.
  2. Describe common job titles and typical responsibilities of a computer user support specialist.
  3. Demonstrate effective verbal communication and customer service skills required by a computer user support specialist.
  4. Demonstrate effective written communication skills required by a computer user support specialist.
  5. Apply problem solving strategies and tools to troubleshoot computer problems.
  6. Describe how help desks operate.
  7. Discuss the responsibilities of user support managers and supervisors.
  8. Describe strategies used to evaluate computer products and define product standards for an organization.
  9. Demonstrate how to analyze and assess user needs for computer hardware, software and network products and services.
  10. Prepare an end user’s site and install hardware, operating systems, network connectivity and application software.
  11. Plan training activities and prepare training materials for computer users.
  12. Use utility software to diagnose, resolve and repair the variety of problems support specialist encounter.

Content Outline and Competencies:

  1. Computer User Support

    1. Discuss historical changes in computer use.

    2. Describe common categories of end users.

    3. Identify resources needed by end users.

    4. Discuss problems end users experience.

    5. Describe how organizations provide a user support function.

    6. Discuss user support services.

  2. Careers in Computer User Support

    1. Describe common entry level job titles.

    2.  Describe typical responsibilities.

    3. Describe potential career paths.

  3. Customer Service Skills and Verbal Communication Skills

    1. Discuss important verbal communication and customer service skills.

    2. Describe effective verbal communication techniques.

    3. Identify an incident management strategy.

    4. Describe strategies for difficult clients and incidents.

    5. Identify client friendly web sites and Web 2.0.

  4. Written Communication Skills

    1. Describe common types of user support documentation.

    2. Discuss how technical writing differs from other writing.

    3. Describe the technical writing process and strategies.

    4. Identify technical writing tools.

  5. Problem Solving Strategies and Tools

    1. Discuss the troubleshooting process and common computer problems.

    2. Discuss effective communication skills for troubleshooting.

    3. Identify information resources to help solve computer problems.

    4. Describe diagnostic repair tools used to troubleshoot computer problems.

    5. Role-play scenarios to practice problem-solving tools and skills.

  6. Help Desk Operation

    1. Discuss help desk operational procedures.

    2. Describe the multi-level support model.

    3. Discuss the incident management process.

    4. Discuss best practices in help desk operation.

    5. Describe the physical layout of help desk work areas.

    6. Discuss stress associated with help desk work.

    7. Identify hardware and software tools used by support agents, managers and end users.

    8. Discuss help desk industry trends.

  7. User Support Management

    1. Describe the purpose and features of a mission statement.

    2. Discuss items in a typical user support budget.

    3. Describe how a help desk is typically staffed.

    4. Describe support staff training programs.

    5. Discuss how support staff performance might be evaluated.

    6. Identify industry certifications for support associations.

    7. Discuss ethical principles that guide the professional behavior of support workers.

  8. Product Evaluation Strategies and Support Standards

    1. Describe how product and support standards emerged.

    2. Discuss common tools and methods for evaluating and selecting computer products.

    3. Identify information resources and decision-making tools for evaluating and selecting computer products.

    4. Describe typical product standards.

    5. Describe how organizations develop and implement support standards.

  9. End User Needs Assessment Projects

    1. Describe basic strategies for performing end-user needs analysis and assessment.

    2. Discuss the steps analysts use to analyze and assess a user’s needs.

    3. Discuss the common tools that help support specialists conduct a user needs assessment project.

    4. Describe the tasks in managing a user needs assessment project.

    5. Describe project management software tools.

  10. End-User Computers

    1. Describe site preparation steps for computer installations.

    2. Identify pre-installation site preparation tasks.

    3. Explain the tools needed to install hardware.

    4. Discuss the steps to install and configure hardware, operating systems, networks and application software.

    5. Describe ongoing site management tasks.

  11. Computer User Training

    1. Explain the goals of training activities.

    2. Identify steps in the training process.

    3. Plan and prepare a training session.

  12. Utility Software

    1. Describe software utilities and information resources used by support specialists.

    2. Describe categories of common user support utilities.

    3. Identify useful support utilities.

Method of Evaluation and Competencies:

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

40 - 60%    Projects

40 - 60%    Exams

100%    Total

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 121

  • Title: Introduction to Project Management*
  • Number: CPCA 121
  • Effective Term: 2018-19
  • 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.

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 123

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

Requirements:

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

Description:

Upon successful completion of this course, students will demonstrate proficiency with presentation software on a personal computer. Foundational presentation competencies, including planning, creating and editing a presentation; inserting graphics and objects; creating speaker notes; creating and formatting tables; applying transitions and animations; formatting custom shapes; and creating a self-running presentation, will be covered. 1 hr. lecture/wk.

Supplies:

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

Objectives

  1. Plan, create and edit a presentation.
  2. Add media and special effects.
  3. Apply advanced formatting to objects.
  4. Apply advanced animation effects.

Content Outline and Competencies:

I. Presentation

A. Discuss the steps of planning, developing and giving a presentation.

B. Plan, create and edit a new presentation.

C. Manipulate slides.

D. Insert graphics and objects.

E. Create speaker notes.

II. Media and Special Effects

A. Add formatting and special effects to objects.

B. Create and format tables.

C. Apply transitions and animations.

D. Add and modify a video.

E. Compress media.

III. Advanced Object Formatting

A. Create and modify a SmartArt diagram.

B. Create and modify a chart.

C. Insert a textbox and apply WordArt styles.

D. Create a custom shape and apply advanced formatting.

E. Add alt text to graphics.

IV. Advanced Animation Effects

A. Add multiple animations to objects.

B. Set animation triggers.

C. Create and edit hyperlinks.

D. Create a custom color palette.

E. Create a self-running presentation with narration.

F. Save the presentation in other file formats.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 125

  • Title: Word Processing II: MS Word*
  • Number: CPCA 125
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites or corequisites: CPCA 108 or CPCA 128.

Description:

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

Supplies:

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

Objectives

  1. Customize templates, themes and styles.
  2. Use mail merge.
  3. Collaborate and integrate data.
  4. Customize and automate documents.

Content Outline and Competencies:

I. Templates, Themes and Styles

A. Create a new document from a template.

B. Customize document themes.

C. Customize styles.

D. Generate and update a table of contents.

E. Create and use a template.

F. Create building blocks.

II. Mail Merge

A. Create a data source.

B. Insert merge fields.

C. Merge main document and data source.

D. Customize merge results.

E. Convert a table to text.

III. Data Collaboration and Integration

A. Track changes in documents.

B. Compare and combine documents.

C. Embed and modify worksheets and charts.

D. Create and edit hyperlinks.

E. Create and publish a blog post.

IV. Document Customization and Automation

A. Apply advanced text formatting.

B. Translate text.

C. Edit file properties.

D. Automate documents using fields.

E. Create, edit and run macros.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 128

  • Title: PC Applications: MS Office
  • Number: CPCA 128
  • Effective Term: 2018-19
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Description:

Upon successful completion of this course, students will demonstrate an in-depth proficiency with word processing, spreadsheet, database and presentation graphics applications. Students will use a current operating system to manage windows and applications, and create and organize files and folders. Students will conduct research on the Internet and apply information in secure documents using ethical and social standards of conduct. Hands-on, practical projects will be performed to reinforce the concepts taught. 3 hrs. lecture/wk.

Supplies:

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

Objectives

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

  1. Identify and use the components of a computer system.
  2. Use the operating system to manage windows, applications, files and folders.
  3. Produce professional documents.
  4. Produce professional spreadsheets and charts.
  5. Produce professional presentations.
  6. Use a relational database.
  7. Integrate data from multiple applications to create and secure data and documents.
  8. Conduct research on the Internet using social and ethical standards of conduct.

Content Outline and Competencies:

I.Components of a Computer System

A. Identify key components and functionality of hardware.

1. CPU

2. Memory

3. Hard drive

B. Define the purpose of common software programs.

1. Operating system

2. Application programs

C. Identify and use current peripheral devices.

1. Input devices

2. Output devices

3. Storage devices

II. Operating System

A. Copy, move, rename and delete files and folders.

B. Minimize, maximize, restore and resize windows.

C. Launch applications, access help and search for files.

D. Customize the operating system environment.

III. Word Processing

A. Create, edit, save and print documents.

B. Correct spelling and grammar errors.

C. Use the help system.

D. Format text with font and character formatting.

E. Create bulleted and numbered lists.

F. Apply paragraph formatting.

G. Insert and manipulate graphics.

H. Create a multipage report divided into sections.

I. Apply page layout features including headers, footers and margins.

J. Format text with styles.

K. Create, format and edit a table.

L. Create citations and bibliographies.

M. Identify document properties and secure documents.

IV. Spreadsheet

A. Create, edit, save and print workbooks.

B. Enter labels, values and formulas.

C. Use the help system.

D. Apply absolute, mixed and relative cell references in formulas.

E. Create formulas with functions.

F. Insert and delete rows and columns.

G. Move and copy a range of cells.

H. Perform what-if analysis.

I. Format and align labels and values.

J. Apply page layout features including headers, footers and print settings.

K. Use spell check on worksheets.

L. Add comments and graphics to worksheets.

M. Protect cell formulas and secure worksheets and workbooks.

N. Print formulas.

O. Create and modify charts.

V. Presentation

A. Create, edit, save and print presentations.

B. Add, duplicate, rearrange and delete slides.

C. Use the help system.

D. Create handouts and speaker notes.

E. Preview, print and save presentations.

F. Change existing slide layouts.

G. Insert pictures and clip art.

H. Apply presentation themes.

I. Animate objects and bulleted lists.

J. Embed sound and video in presentations.

VI. Database

A. Build tables by defining fields and setting field properties.

B. Specify primary keys.

C. Use the help system.

D. Link tables with one to many relationships.

E. Enter and edit records.

F. Create and run queries to sort and select data.

G. Create and format forms.

H. Create and format reports.

I. Create interfaces to protect and secure data.

VII. Integration

A. Embed charts into documents.

B. Link worksheets to documents.

C. Secure data and files using links and passwords.

D. Create presentations from document outlines.

VIII. Internet Research

A. Develop search techniques for locating information on the Web.

B. Use search engines to conduct searches.

C. Find and evaluate information on the Web.

D. Identify and document Web resources.

E. Discuss and apply copyright laws and principles.

F. Document Web resources according to academic research standards.

Method of Evaluation and Competencies:

40-60%    Quizzes
40-60%    Projects

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 134

  • Title: Managing Your Macintosh*
  • Number: CPCA 134
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

Prerequisites: CPCA 106 or an appropriate score on a waiver test.

Description:

In this career-related course, students will be introduced to essential Macintosh (Mac) computer concepts and skills. Topics include the operating system (OS) tools; third-party utility software installation and use; backup applications and usage techniques; and font management. Hands-on, practical projects will be performed to reinforce the concepts taught. 1 hr. lecture/wk.

Supplies:

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

Objectives

  1. Identify current Mac OS concepts and tools.
  2. Identify and use current third-party utilities.
  3. Install and organize fonts using the OS and third-party utilities.
  4. Discuss the importance of data backup and current data backup techniques.

Content Outline and Competencies:

I. OS

A. Connect an external hard drive.

B. Customize the toolbar and dock.

C. Create and use smart folders.

D. Configure Finder preferences.

E. Use Disk Utility to create a disk image.

II. Utilities

A. Compress portable document format (pdf) files and folders of pdf files.

B. Identify and use file transfer options.

C. Discuss and use antivirus utilities.

D. Identify and use current Mac utilities.

III. Fonts

A. Discuss screen versus printer fonts.

B. Install and organize fonts.

C. Diagnose and replace fonts.

IV. Data Backup

A. Discuss the importance of data backup.

B. Identify and use data backup utilities and techniques.

C. Compress and extract files.

Method of Evaluation and Competencies:

20-40%    Projects/Assignments
60-80%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 138

  • Title: Windows for Microcomputers*
  • Number: CPCA 138
  • Effective Term: 2018-19
  • Credit Hours: 1
  • Contact Hours: 1
  • Lecture Hours: 1

Requirements:

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

Description:

This course is designed to give the student an overview of the Windows Operating System. Topics include personalizing the work environment; advanced personalization and customization techniques; advanced search techniques; managing digital media; and managing networks, security and utilities. Hands-on, real-world projects will be performed to reinforce the concepts taught. 1 hr. lecture/wk.

Supplies:

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

Objectives

  1. Personalize the work environment.
  2. Utilize advanced personalization and customization techniques.
  3. Utilize advanced search techniques.
  4. Manage digital media.
  5. Manage networks, security and utilities.

Content Outline and Competencies:

I. Work Environment

A. Create user accounts.

B. Customize the Start screen.

C. Work with multiple desktops.

D. Customize the taskbar.

E. View and modify folder options.

II. Advanced Personalization and Customization

A. View and configure the Windows Firewall.

B. Defragment and optimize a hard drive.

C. Display and adjust ease of access settings.

D. View privacy settings.

E. Display update and security settings.

III. Advanced Search Techniques

A. Search for a file by specifying properties.

B. View and modify the index.

C. Search for media files using specialized properties.

D. Refine searches using the search box.

E. Configure search box settings.

IV. Digital Media

A. Organize photos using albums.

B. Enhance pictures with editing tools.

C. Work with playlists.

D. Modify Closed Captioning settings.

V. Networks, Security and Utilities

A. Manage Windows Firewall.

B. Protect against computer viruses and malware.

C. Use the Network and Sharing Center.

D. Enable Remote Desktop and Remote Assistance connections.

E. Backup and restore files.

F. Use System Restore features.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 139

  • Title: UNIX*
  • Number: CPCA 139
  • Effective Term: 2018-19
  • 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.

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:

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

CPCA 141

  • Title: Internet I*
  • Number: CPCA 141
  • Effective Term: 2018-19
  • 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.

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:

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

CPCA 151

  • Title: Internet II*
  • Number: CPCA 151
  • Effective Term: 2018-19
  • 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.

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:

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

CPCA 161

  • Title: Introduction to Web Pages using HTML*
  • Number: CPCA 161
  • Effective Term: 2018-19
  • 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.

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:

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

CPCA 228

  • Title: PC Applications II: MS Office*
  • Number: CPCA 228
  • Effective Term: 2018-19
  • Credit Hours: 3
  • Contact Hours: 3
  • Lecture Hours: 3

Requirements:

Prerequisites: CPCA 128 or (CPCA 108 and CPCA 110 and CPCA 114).

Description:

This course builds on the skills covered in CPCA 128, PC Applications: MS Office. After completing this course students should be able to use advanced concepts and applications of word processing, spreadsheet and database software. Hands-on practical projects will be performed to reinforce the concepts taught. 3 hr. lecture/wk.

Supplies:

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

Objectives

  1. Customize templates, themes and styles.
  2. Use mail merge.
  3. Collaborate and integrate data.
  4. Customize and automate documents.
  5. Work with tables, PivotTables and PivotCharts.
  6. Manage multiple worksheets and workbooks.
  7. Create workbook applications.
  8. Build advanced formulas using functions.
  9. Maintain and query a database.
  10. Create forms.
  11. Generate reports.
  12. Modify table design.

Content Outline and Competencies:

I. Templates, Themes and Styles

A. Create a new document from a template.

B. Customize document themes.

C. Customize styles.

D. Generate and update a table of contents.

E. Create and use a template.

F. Create building blocks.

II. Mail Merge

A. Create a data source.

B. Insert merge fields.

C. Merge main document and data source.

D. Customize merge results.

E. Convert a table to text.

III. Data Collaboration and Integration

A. Track changes in documents.

B. Compare and combine documents.

C. Embed and modify worksheets and charts.

D. Create and edit hyperlinks.

E. Create and publish a blog post.

IV. Document Customization and Automation

A. Apply advanced text formatting.

B. Translate text.

C. Edit file properties.

D. Automate documents using fields.

E. Create, edit and run macros.

V. Tables, PivotTables and PivotCharts

A. Create and modify a spreadsheet table.

B. Use spreadsheet tables to edit, sort and filter data.

C. Build table formulas to summarize data.

D. Build PivotTables and PivotCharts to analyze data.

VI. Worksheet and Workbook Manipulation

A. Build formulas that reference multiple worksheets.

B. Build formulas that reference multiple workbooks.

C. Build templates.

VII. Workbook Applications

A. Apply cell and range names.

B. Validate data entry.

C. Protect worksheets and workbooks.

D. Create, edit and run macros.

VIII.Advanced Formulas and Functions

A. Build formulas with multiple nested functions.

B. Build formulas using table syntax.

C. Build formulas that include error checking functions.

D. Build formulas with advanced statistical functions.

IX. Queries

A. Update database records.

B. Create and run a query.

C. Sort and filter data in a query.

1. Query criteria

2. AND OR criteria

3. Conditional operators

D. Use logical operators.

E. Create and format calculated fields.

F. Summarize data with aggregate functions.

G. Create advanced queries.

X. Forms

A. Use form creation tools to create and modify forms.

B. Navigate and modify data in a form.

C. Use form views to modify form controls.

XI. Reports

A. Create and modify a report.

B. Format and distribute a report.

C. Apply conditional formatting.

D. Use report views to modify report controls.

E. Use report sections to group and summarize data.

XII. Tables

A. Create lookup fields.

B. Apply the Input Mask property.

C. Define data validation properties.

Method of Evaluation and Competencies:

40-60%    Projects/Assignments
40-60%    Tests

Total: 100%

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 290

  • Title: Computer Support Specialist Internship*
  • Number: CPCA 290
  • Effective Term: 2018-19
  • Credit Hours: 2
  • Contact Hours: 90
  • Lecture Hours:
  • Other Hours: 90

Requirements:

Prerequisites: Department approval.

Description:

Students will work in an approved training situation under instructional supervision. The internship is designed to give the student the opportunity to use the knowledge and skills acquired in the Computer Support Specialist program. An average of 40-60 onsite hours will be required along with class assignments for a total of 90 hrs./semester.

Supplies:

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

Objectives

  1. Describe the company or organization.
  2. Describe the work activities performed during the internship.
  3. Demonstrate effective workplace skills.
  4. Demonstrate professional behaviors in the workplace.

Content Outline and Competencies:

I. Company or Organization Description

A. Describe the mission, vision and goals.

B. Provide a general outline of the organizational structure.

C. Describe the roles of employees and workflow of the organization.

D. Discuss the products and services of the organization.

II. Work Activities

A. Follow written and oral instructions.

B. Manage time and resources effectively.

C. Demonstrate effective written and oral communication.

D. Participate in meetings and teams as assigned.

E. Follow employer's rules, regulations and policies.

III. Workplace Skills

A. Apply technical skills learned in coursework.

B. Demonstrate analytical and problem-solving skills.

C. Demonstrate acquisition of new knowledge and skills.

D. Perform industry related tasks as specified by intern supervisors.

IV. Professionalism

A. Demonstrate appropriate business behaviors and attire for assigned area.

B. Demonstrate interpersonal skills appropriate to a business environment.

C. Demonstrate the principles of privacy, confidentiality and security.

Method of Evaluation and Competencies:

10-25%    Instructor’s on-site visits and evaluation
25-40%    Weekly work log
50-60%    Evaluation of the student by the intern supervisor

Total: 100%

Grade Criteria:

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

Caveats:

Transportation to the work-site is the responsibility of the student.

Student Responsibilities:

Disabilities:

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

CPCA 291

  • Title: Independent Study*
  • Number: CPCA 291
  • Effective Term: 2018-19
  • Credit Hours: 1 - 7
  • Contact Hours: 1 - 7
  • Lecture Hours:
  • Other Hours: 1 - 7

Requirements:

Prerequisites: 2.0 GPA minimum and department approval.

Description:

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.

Supplies:

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

Objectives

Content Outline and Competencies:

Method of Evaluation and Competencies:

Grade Criteria:

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

Caveats:

Student Responsibilities:

Disabilities:

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

CPCA 292

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

Requirements:

Prerequisites: Departmental approval.

Description:

This course periodically presents specialized topics in Personal Computer Applications that are not available in the regularly offered curriculum. Special Topics may be repeated for credit, but only on different topics.

Supplies:

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

Objectives

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

1.  Appropriately use terminology related to the special topic.

2.  Solve problems by using content related to the special topic.

3.  Demonstrate conceptual understanding of the special topic.

4.  Use software related to the special topic.

Content Outline and Competencies:

Varies

Method of Evaluation and Competencies:

Varies

Grade Criteria:

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

Caveats:

A Special Topics subject may not be repeated within a 24-month period.

Student Responsibilities:

Varies

Disabilities:

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