CS-102: Spreadsheet Programming with MS Excel

Course, prefix, number, & title: CS-102 Spreadsheet Programming with MS Excel

Hours (Class, recitation, Laboratory, studio): 3 class hours, 1 laboratory hour

Credits: 3

Pre-requisites (if any): MA-119 with C or better, or Permission of the Department

Course Description in college catalog:

Introduction to the organization, processing, and analysis of data through programmed spreadsheets, as would apply to data science and related mathematical concepts. Topics include: cell operations, text manipulation, formulas, functions, arrays, charting techniques, pivot tables, conditional formatting, and VBA programming, as they relate to data science.

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

A.S. Liberal Arts and Sciences (Mathematics and Science)

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 use built-in functionality to modify, summarize, and analyze data as they would apply to data science and related mathematical concepts.
• Students will create charts to summarize data (e.g. histogram, comparison charts, box-plot)
• Students will solve problems using the goal seek and what-if features
• Students will import data, organize data in data tables and perform advanced sorting.
• Students will use form controls for data input, validation, and processing
• Students will access and process data from multiple sheets and workbooks
• Students will create pivot tables to summarize and analyze data (e.g. through frequency distributions and cross-tabulations)
• Students will apply abstract reasoning and programming logic to design procedures in pseudocode
• Students will implement VBA procedures, with control structures, to process data
• Students will use mathematical and statistical functions to explore and analyze data: (e.g. Standard Deviation, Correlation, Slope and Intercept, randomization)
• Students will process data using the advanced feature Power Tools: (e.g. Pivot, Query, View, Map)
• Students will be introduced to Error Handling and to Information Ethics: privacy & security
• Students will operate on, and extract components of, strings and date/time values
  

Program-specific outcomes

1. Demonstrate proficiency in factual knowledge, conceptual understanding, and discipline-specific
methodology required for transfer to the junior year in a baccalaureate program in natural science,
mathematics, engineering, or computer science
2. Disciplinary learning:
(b) Demonstrate proficiency in acquiring, processing, and analyzing scientific information in various forms, as
related to the field of concentration.
(c) Proficiently convey information specific to the discipline, through technical writing or oral presentation.
(d) Use current technology or experimental techniques to supplement the fundamental concepts and
methodology used in the field of study.
(e) Work collaboratively to acquire and analyze data, or solve problems in the field of study.

Other program outcomes (if applicable).

1. Integrate knowledge and skills in the program of study

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:

The general guidelines for assessing grades are as follows:

 

Methods

In-class examinations	36%
Projects, Laboratory and homework assignments	34%
Final Examination	30%

The distribution is at the discretion of the instructor.

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.