IT 300 - Advanced PC Office Applications

Institution:

Keystone College

Subject:

Description:

Continues the concepts in IT 200 and covers advanced topics within word processing (Word), spreadsheets (Excel), and database concepts (Access). Topics include development of on-screen forms, macros, advanced table techniques, and management of long documents through cross-referencing, indexes, and tables of contents. Students learn advanced spreadsheet techniques including problem solving, scenario management, importation of data, and automation techniques using macros and visual basic code. Database topics include cross tab, unmatched and action queries, and task automation with macros and Visual Basic for Applications code. Hands-on lab activities provide exposure to business applications to prepare students for business and industry usages. Prerequisite: IT 200. Spring, $40 fee, 3 hours demonstration, discussion, and hands-on assignments, 3 credits.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.keystone.edu

Phone Number:

(570) 945-8000

Regional Accreditation:

Middle States Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.