Order By Display Density

Microsoft Excel

XCOE 1013 - Excel 2016 Advanced

Perform advanced data analysis, collaborate on workbooks, and automate functionality. You will explore working with multiple worksheets and workbooks, using Lookup functions, auditing formulas, sharing and protecting workbooks, creating Sparklines, and mapping and forecasting data. This class can be taken as part of the Excel Specialist Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Excel 2016 Intermediate or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Lesson 1: Working with Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data
Lesson 2: Using Lookup Functions and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas
Lesson 3: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
Lesson 4: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros
Lesson 5: Creating Sparklines and Mapping Data
Topic A: Create Sparklines
Topic B: Map Data
Lesson 6: Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecasting Data Trends
 
CRN Days Time Date Location Instructor Seats Open
51597 006 MT----- 06:00-09:29 PM 07/31/17-08/01/17 RC 254 Guinn D 13 of 14

SQL and SQL Server

XCDS 1000 - SQL Fundamentals

This course introduces the fundamental concepts of SQL. Work with tables, keys, viewing data and functions. This class can be taken as part of the Access Developer Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Access Advanced or Crystal Reports 2011 Fundamentals or comparable knowledge. Programming Fundamentals is recommended but not required.

CEU Hours: 1.4

Contact Hours: 14

Course Outline:

 1.  Relational database definition, integrity, security

 2.  Design methodology

 3.  Data modeling

 4.  Normalization

 5.  Discuss data warehousing concepts

 6.  Overview of distributed databases

 7.  User views

 8.  SQL data types

 9.  SQL commands (create table, alter table, insert into, etc.)

10.  Types and use of keys 

11.  Joining tables (inner joins, outer joins, self-joins)

12.  Shared update considerations

13.  Privileges and security
 
CRN Days Time Date Location Instructor Seats Open
51474 004 --WR--- 06:00-09:29 PM 08/16/17-08/24/17 RC 234 Guinn D 14 of 14
Clinic Courses (CLI) provide practical application and are offered on or off campus. Instructors supervise/direct student in a simulated or on-site setting.
Face-to-Face Courses (F2F) take place in a classroom. Based on JCCC's Statement of General Education. Students in all classes, including face-to-face classes, are expected to use technology appropriate to the course content and as needed to access web-based course materials. Face-to-face classes typically require access to computer equipment (either at home or in college labs provided for student use) and computing skills utilizing standard office, business and web browsing applications.
Hybrid Courses (HYB) combine face-to-face classroom instruction and the convenience of online web-based learning, resulting in a reduction of the amount of time spent in the face-to-face classroom and a significant increase of time spent studying online materials. Students registered in hybrid courses must attend class meetings as listed in the JCCC Schedule of Classes.
Internships (INT) provide experience to students for on-the-job training with cooperating businesses, agencies, and organizations. The number of hours for each internship varies.
Lab Courses (LAB) are face-to-face classes where students perform tasks as directed by faculty. Faculty members monitor the activity and provide individual and/or group instruction/assistance
Media Courses (MED) deliver all or a portion of instruction through either cable broadcast or pre-recorded video lessons. The videos are available in DVD format from the Billington Library.
Online Courses (ONLNE) use the Internet and a Learning Management System (D2L) to deliver course materials and to facilitate student-instructor, student-content, and student to student interaction. To participate in online courses, the student should have a good understanding of computer hardware and software applications and the Internet.
Continuing Education Online Courses (CEONL) and materials are delivered via the Internet. To participate in online courses, the student should have a good understanding of computer applications and Internet navigation. For more information about this course and other online learning options visit CE Online.
Private (PLV) lessons for credit are available from beginning to advanced in voice, piano, guitar, brass, woodwind and percussion. Lessons are scheduled by arrangement with private music instructors.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Travel Courses (TRV) may require in-class activities as well as traveling to a destination. Students will be responsible for the cost of the travel as well as the course costs.
Seats Open is an approximation of the number of seats available and may not represent the actual number of seats open at the time of registration.
This course is approved by the Kansas Board of Regents for guaranteed transfer among all Kansas public postsecondary institutions. Additional courses may also be eligible for transfer. Please visit the JCCC Registrar to learn more.