CIS-206: Spreadsheet Business Applications and Data Analytics

Course, prefix, number, & title: CIS-206 Spreadsheet Business Applications and Data Analytics

Hours (Class, recitation, Laboratory, studio): 2 class hours , 3 laboratory hours; offered in spring

Credits: 3

Pre-requisites (if any): CIS-101 and students must complete any developmental requirements in Mathematics (see Proficiency in Math and English) prior to taking this course. Offered in Spring.

Course Description in college catalog:

Students will apply spreadsheet concepts to real-world business situations and strengthen their ability to analyze business problems, examine alternative solutions, and implement solutions using software. Topics include spreadsheet design, efficient/effective data handling, computational analysis, decision support, graphs, templates and macros, advanced statistical, financial, and database functions, use of data tables, logical functions and formulas and lookup tables.

Academic programs for which this course serves as a requirement or an elective:

A.A.S. Office Administration and Technology

Certificate Program – Computer Information Systems

Certificate Program – Office Administration Assistant

General Education Outcomes: Below is a listing of General Education Outcome(s) that this course supports.

1. Use analytical reasoning to identify issues or problems and evaluate evidence in order to make informed decisions

2. Reason quantitatively as required in various fields of interest and in everyday life

3. Apply information management and digital technology skills useful for academic research and lifelong learning

Course-specific student learning outcomes:

Students will achieve the following course objectives:

1. To introduce the student to the most popular electronic spreadsheet available.
2. To provide a complete educational environment for learning Microsoft Excel.
3. The textbook has been approved by Microsoft as a study guide for the Microsoft Office User Specialist (MOS) Expert exam for Excel.
4. To teach the fundamentals of:
   • Managing financial data
   • Creating, editing and formatting worksheets
   • Working with charts and graphics
   • Working with Excel lists and pivot tables
   • Working with multiple worksheets and workbooks
   • Using one and two variable data tables
   • Using Goal Seek and Solver
   • Using Lookup functions
   • Creating macros using Macro Recorder
   • Importing data

5. To develop critical thinking skills in problem solving.
6. To become a “power user” – one who can select the most efficient approach to completing a task by choosing from keyboard shortcuts, menus, dialogue boxes and toolbar buttons.

Program-specific outcomes

Use business application software and analytical reasoning and apply technological tools to solve business problems by creating and analyzing databases, developing and evaluating spreadsheets, and constructing web pages.

Methods by which student learning will be assessed and evaluated; describe the types of methods to be employed; note whether certain methods are required for all sections:

1. Student Participation & Homework
2. Hands on laboratory assignments
3. Hands on work outside the classroom/Lab
4. Hands on exams
5. Project(s) implementation

Academic Integrity policy (department or College):
Academic honesty is expected of all students. Any violation of academic integrity is taken extremely seriously. All assignments and projects must be the original work of the student or teammates. Plagiarism will not be tolerated. Any questions regarding academic integrity should be brought to the attention of the instructor. The following is the Queensborough Community College Policy on Academic Integrity: "It is the official policy of the College that all acts or attempted acts that are violations of Academic Integrity be reported to the Office of Student Affairs. At the faculty member's discretion and with the concurrence of the student or students involved, some cases though reported to the Office of Student Affairs may be resolved within the confines of the course and department. The instructor has the authority to adjust the offender's grade as deemed appropriate, including assigning an F to the assignment or exercise or, in more serious cases, an F to the student for the entire course." Read the University's policy on Academic Integrity opens in a new window(PDF).

Disabilities
Any student who feels that he or she may need an accommodation based upon the impact of a disability should contact the Office of Accessibility Services in Science Building, Room S-132, 718-631-6257, to coordinate reasonable accommodations for students with documented disabilities. You can visit the Office of Accessibility Services website.