x

Computer Information Systems: Business Software Specialist II

Download PDF

Academic Programs

Computer Information Systems: Business Software Specialist II - Certificate (B36)

(B36) Certificate

The Business Software Specialist II consists of advanced courses which expand on skills in the programming and the operation of computers. This certificate can also be the means for advancement to higher level positions in an expanding field. Instruction includes hands-on experience with computers and business software applications. Completion of the Business Software Specialist I Certificate is a prerequisite to completing the Business Software Specialist II certificate.

Work and Employment

The rapid spread of computers and computer-based technologies in recent years has generated a need for skilled, highly trained workers. Computers have become essential to the operation of stores, banks, colleges and universities, government agencies, hospitals, factories, and many other profit and non-profit entities in our society. Employment is expected to grow as organizations seek new applications for computers and improvements to the software already in use. Click here for further career information: https://www.svcc.edu/academics/programs/individual/b36.html

Program Contacts at Sauk Valley Community College
Academic Advising, 815/835-6354
Kevin Megill, Associate Professor of Computer Information Systems, 815/835-6251
Greg Noack, Assistant Professor of Computer Information Systems, 815/835-6434

Follow this link for career information.


Total Hours Required - 22 Hours

Major Field Requirements

  • CIS104 - Word Processing Software ( 2 Semester Hours)

    This course will familiarize the user with advanced features of word processing. Course emphasis will include: document creation, document deleting and document printing, editing, formatting with fonts, margins, columns, citations, creating and formatting tables, graphics, themes and building blocks, merging, multipage, styles and templates, references, footnotes, integration with Excel and Access, building forms, collaborating and tracking documents customizing Word, Watermarks CIS 109 or consent of instructor Semester hour(s): 2 Lecture/Lab Hours: 1 lec/2 lab

  • CIS106 - Spreadsheet Software ( 3 Semester Hours)

    This introductory course is designed to acquaint the student with the process of using personal computers to solve spreadsheet problems. In addition to providing the student with a working knowledge of the basic and advanced capabilities of spreadsheet software, the student will be exposed to the use of problem-solving techniques for situations in which spreadsheet solutions are appropriate. Prerequisite: CIS 109 or consent of instructor 3 Semester hour(s) 2 lec, 2 lab/week

  • CIS108 - Database Software ( 3 Semester Hours)

    This introductory course is designed to acquaint the student with the use of Windows-based database management system to solve problems. In addition to providing the student with a working knowledge of the basic and advanced capabilities of a Windows database management system, the student will be exposed to the use of problem-solving techniques for situations in which database management solutions are appropriate. Prerequisite: CIS 109 or consent of instructor 3 Semester hour(s) 2 lec, 2 lab/week

  • CIS109 - Introduction to Computers ( 3 Semester Hours)

    This introductory course consists of the study of computer hardware, software, operating systems and communications, networking, Internet, systems and program development life cycles and their role in business decision making. The use of Internet, multimedia, security, and ethics will be emphasized throughout the course. In addition, laboratory experience will be gained with a survey of Microsoft Windows and business computer software applications programs in word processing, electronic spreadsheets, database management, presentation graphics, and Internet. Prerequisite: None. Students having no experience with computers are encouraged to first take OAS 103-Keyboarding. Illinois Articulation Initiative (IAI): BUS 902 Semester hour(s): 3 Lecture/Lab Hours: 2 lec, 2 lab/week

  • CIS143 - Desktop Publishing Software ( 3 Semester Hours)

    An introduction to desktop publishing in which students will learn to manipulate, edit, store and plot both text and graphic information. Students will also learn how to develop and use artistic graphics necessary to produce business forms, charts, reports, newsletters, brochures and magazines utilizing the microcomputer. 3 Semester hour(s) Lecture/Lab Hours: 1 lec/4 lab

  • CIS132 - Cloud Productivity ( 2 Semester Hours)

    This introductory course is designed to acquaint the student with the use of cloud-based office productivity applications for collaboration, file sharing, project management, note-taking, communication, and organization. Laboratory experience will be gained with a survey of tools including: Google Apps, Microsoft Office 365, Evernote, cloud-based drives, and web conferencing tools. Both desktop and mobile tools will be utilized when applicable. Best practices for the business office and security will be emphasized. Prerequisite: CIS 101 or CIS 109 (concurrent enrollment accepted), or consent of instructor. 2 Semester hour(s) Lecture/Lab Hours: 1 lec/2 lab

  • CIS148 - Business Presentation Graphics ( 1 Semester Hours)

    This course focuses on creating effective and attractive presentation media for business presentations. The student will learn the basics of a software package specifically designed for presentation graphics. In addition to providing the student with a working knowledge of the graphics capabilities of various software packages, the student will be exposed to the use of problem-solving techniques for situations in which graphic solutions are appropriate. Prerequisite: CIS 109 or consent of instructor. Semester hour(s): 1 Lecture/Lab Hours: .5 lec, 1 lab/week

  • CIS229 - Database Management Systems ( 3 Semester Hours)

    This course provides a theoretical approach to database management systems. Topics included are data security, web-enabled systems design and programming for systems, large-scale databases and data warehouses, system requirements, database performance, and SQL for database queries. Physical and logical database design and models will also be examined. Prerequisite: CIS 101 or CIS 109 or consent of instructor. Semester hour(s): 3 Lecture/Lab Hours: 3 lec/week

  • OAS103 - Basic Keyboarding & Doc Proc ( 4 Semester Hours)

    Instruction in keyboard and machine control techniques with the objective of developing a mastery of the keyboard and skill in producing basic and academic reports. 2 Semester hour(s) Lecture/Lab Hours: 4 lab/week

Suggested Program 1 year accelerated

First Semester - 10 Hours

  • CIS109 - Introduction to Computers ( 3 Semester Hours)

    This introductory course consists of the study of computer hardware, software, operating systems and communications, networking, Internet, systems and program development life cycles and their role in business decision making. The use of Internet, multimedia, security, and ethics will be emphasized throughout the course. In addition, laboratory experience will be gained with a survey of Microsoft Windows and business computer software applications programs in word processing, electronic spreadsheets, database management, presentation graphics, and Internet. Prerequisite: None. Students having no experience with computers are encouraged to first take OAS 103-Keyboarding. Illinois Articulation Initiative (IAI): BUS 902 Semester hour(s): 3 Lecture/Lab Hours: 2 lec, 2 lab/week

  • CIS132 - Cloud Productivity ( 2 Semester Hours)

    This introductory course is designed to acquaint the student with the use of cloud-based office productivity applications for collaboration, file sharing, project management, note-taking, communication, and organization. Laboratory experience will be gained with a survey of tools including: Google Apps, Microsoft Office 365, Evernote, cloud-based drives, and web conferencing tools. Both desktop and mobile tools will be utilized when applicable. Best practices for the business office and security will be emphasized. Prerequisite: CIS 101 or CIS 109 (concurrent enrollment accepted), or consent of instructor. 2 Semester hour(s) Lecture/Lab Hours: 1 lec/2 lab

  • CIS143 - Desktop Publishing Software ( 3 Semester Hours)

    An introduction to desktop publishing in which students will learn to manipulate, edit, store and plot both text and graphic information. Students will also learn how to develop and use artistic graphics necessary to produce business forms, charts, reports, newsletters, brochures and magazines utilizing the microcomputer. 3 Semester hour(s) Lecture/Lab Hours: 1 lec/4 lab

  • OAS103 - Basic Keyboarding & Doc Proc ( 4 Semester Hours)

    Instruction in keyboard and machine control techniques with the objective of developing a mastery of the keyboard and skill in producing basic and academic reports. 2 Semester hour(s) Lecture/Lab Hours: 4 lab/week

Second Semester - 12 Hours

  • CIS104 - Word Processing Software ( 2 Semester Hours)

    This course will familiarize the user with advanced features of word processing. Course emphasis will include: document creation, document deleting and document printing, editing, formatting with fonts, margins, columns, citations, creating and formatting tables, graphics, themes and building blocks, merging, multipage, styles and templates, references, footnotes, integration with Excel and Access, building forms, collaborating and tracking documents customizing Word, Watermarks CIS 109 or consent of instructor Semester hour(s): 2 Lecture/Lab Hours: 1 lec/2 lab

  • CIS106 - Spreadsheet Software ( 3 Semester Hours)

    This introductory course is designed to acquaint the student with the process of using personal computers to solve spreadsheet problems. In addition to providing the student with a working knowledge of the basic and advanced capabilities of spreadsheet software, the student will be exposed to the use of problem-solving techniques for situations in which spreadsheet solutions are appropriate. Prerequisite: CIS 109 or consent of instructor 3 Semester hour(s) 2 lec, 2 lab/week

  • CIS108 - Database Software ( 3 Semester Hours)

    This introductory course is designed to acquaint the student with the use of Windows-based database management system to solve problems. In addition to providing the student with a working knowledge of the basic and advanced capabilities of a Windows database management system, the student will be exposed to the use of problem-solving techniques for situations in which database management solutions are appropriate. Prerequisite: CIS 109 or consent of instructor 3 Semester hour(s) 2 lec, 2 lab/week

  • CIS148 - Business Presentation Graphics ( 1 Semester Hours)

    This course focuses on creating effective and attractive presentation media for business presentations. The student will learn the basics of a software package specifically designed for presentation graphics. In addition to providing the student with a working knowledge of the graphics capabilities of various software packages, the student will be exposed to the use of problem-solving techniques for situations in which graphic solutions are appropriate. Prerequisite: CIS 109 or consent of instructor. Semester hour(s): 1 Lecture/Lab Hours: .5 lec, 1 lab/week

  • CIS229 - Database Management Systems ( 3 Semester Hours)

    This course provides a theoretical approach to database management systems. Topics included are data security, web-enabled systems design and programming for systems, large-scale databases and data warehouses, system requirements, database performance, and SQL for database queries. Physical and logical database design and models will also be examined. Prerequisite: CIS 101 or CIS 109 or consent of instructor. Semester hour(s): 3 Lecture/Lab Hours: 3 lec/week

Suggested Program 2 years

First Semester - 5 Hours

  • CIS109 - Introduction to Computers ( 3 Semester Hours)

    This introductory course consists of the study of computer hardware, software, operating systems and communications, networking, Internet, systems and program development life cycles and their role in business decision making. The use of Internet, multimedia, security, and ethics will be emphasized throughout the course. In addition, laboratory experience will be gained with a survey of Microsoft Windows and business computer software applications programs in word processing, electronic spreadsheets, database management, presentation graphics, and Internet. Prerequisite: None. Students having no experience with computers are encouraged to first take OAS 103-Keyboarding. Illinois Articulation Initiative (IAI): BUS 902 Semester hour(s): 3 Lecture/Lab Hours: 2 lec, 2 lab/week

  • OAS103 - Basic Keyboarding & Doc Proc ( 4 Semester Hours)

    Instruction in keyboard and machine control techniques with the objective of developing a mastery of the keyboard and skill in producing basic and academic reports. 2 Semester hour(s) Lecture/Lab Hours: 4 lab/week

Second Semester - 6 Hours

  • CIS104 - Word Processing Software ( 2 Semester Hours)

    This course will familiarize the user with advanced features of word processing. Course emphasis will include: document creation, document deleting and document printing, editing, formatting with fonts, margins, columns, citations, creating and formatting tables, graphics, themes and building blocks, merging, multipage, styles and templates, references, footnotes, integration with Excel and Access, building forms, collaborating and tracking documents customizing Word, Watermarks CIS 109 or consent of instructor Semester hour(s): 2 Lecture/Lab Hours: 1 lec/2 lab

  • CIS106 - Spreadsheet Software ( 3 Semester Hours)

    This introductory course is designed to acquaint the student with the process of using personal computers to solve spreadsheet problems. In addition to providing the student with a working knowledge of the basic and advanced capabilities of spreadsheet software, the student will be exposed to the use of problem-solving techniques for situations in which spreadsheet solutions are appropriate. Prerequisite: CIS 109 or consent of instructor 3 Semester hour(s) 2 lec, 2 lab/week

  • CIS148 - Business Presentation Graphics ( 1 Semester Hours)

    This course focuses on creating effective and attractive presentation media for business presentations. The student will learn the basics of a software package specifically designed for presentation graphics. In addition to providing the student with a working knowledge of the graphics capabilities of various software packages, the student will be exposed to the use of problem-solving techniques for situations in which graphic solutions are appropriate. Prerequisite: CIS 109 or consent of instructor. Semester hour(s): 1 Lecture/Lab Hours: .5 lec, 1 lab/week

Third Semester - 5 Hours

  • CIS132 - Cloud Productivity ( 2 Semester Hours)

    This introductory course is designed to acquaint the student with the use of cloud-based office productivity applications for collaboration, file sharing, project management, note-taking, communication, and organization. Laboratory experience will be gained with a survey of tools including: Google Apps, Microsoft Office 365, Evernote, cloud-based drives, and web conferencing tools. Both desktop and mobile tools will be utilized when applicable. Best practices for the business office and security will be emphasized. Prerequisite: CIS 101 or CIS 109 (concurrent enrollment accepted), or consent of instructor. 2 Semester hour(s) Lecture/Lab Hours: 1 lec/2 lab

  • CIS143 - Desktop Publishing Software ( 3 Semester Hours)

    An introduction to desktop publishing in which students will learn to manipulate, edit, store and plot both text and graphic information. Students will also learn how to develop and use artistic graphics necessary to produce business forms, charts, reports, newsletters, brochures and magazines utilizing the microcomputer. 3 Semester hour(s) Lecture/Lab Hours: 1 lec/4 lab

Fourth Semester - 6 Hours

  • CIS229 - Database Management Systems ( 3 Semester Hours)

    This course provides a theoretical approach to database management systems. Topics included are data security, web-enabled systems design and programming for systems, large-scale databases and data warehouses, system requirements, database performance, and SQL for database queries. Physical and logical database design and models will also be examined. Prerequisite: CIS 101 or CIS 109 or consent of instructor. Semester hour(s): 3 Lecture/Lab Hours: 3 lec/week

  • CIS108 - Database Software ( 3 Semester Hours)

    This introductory course is designed to acquaint the student with the use of Windows-based database management system to solve problems. In addition to providing the student with a working knowledge of the basic and advanced capabilities of a Windows database management system, the student will be exposed to the use of problem-solving techniques for situations in which database management solutions are appropriate. Prerequisite: CIS 109 or consent of instructor 3 Semester hour(s) 2 lec, 2 lab/week