CCV Section Grid - Detail
Vermont State Colleges

Web Schedules

Fall 2019
Spring 2019
Summer 2019

Accelerated Courses

Fall 2019
Spring 2019
Summer 2019

Course Planning by Program


Essential Objectives

Web Schedule Summer 2019

Revision Date: 27-Nov-18

CIS-1430-VR01 - Spreadsheets

Synonym: 175901
Location: Rutland
Credits: 3 (45 hours)
Day/Times: Wednesday, 05:30P - 09:00P
Semester Dates: 05-22-2019 to 08-07-2019
Last day to drop without a grade: 06-10-2019 - Refund Policy
Last day to withdraw (W grade): 07-08-2019 - Refund Policy
Faculty: Michael Keogh | View Faculty Credentials
This course has started, please contact the offering academic center about registration
This section meets the following General Education Requirement(s):
Technological Literacy
  1. Many degree programs have specific general education recommendations. In order to avoid taking unnecessary classes, please consult with additional resources like your program evaluation, your academic program page, and your academic advisor.
  2. Courses may only be used to meet one General Education Requirement.

Course Description:

This course provides a comprehensive examination of spreadsheet software. Students will build a variety of spreadsheets using simple and complex formulas, functions, graphics, database features, sorts, linkages within spreadsheet and between spreadsheets, and macros. Basic algebra skills are recommended.

Essential Objectives:

1. Design, build, edit, and format complex and multi-sheet workbooks.
2. Demonstrate simple and conditional formatting of numerical and text data to create readability and appeal of the spreadsheet.
3. Demonstrate principles of good spreadsheet design including planning, documentation, and organization.
4. Use spreadsheet software to present and analyze quantitative information, to draw conclusions from information, and to evaluate the reliability of those conclusions.
5. Demonstrate appropriate use of cell references absolute, relative, and conditional formulas.
6. Apply financial, statistical, mathematical, logical, text, and date functions to build applications.
7. Demonstrate effective use and formatting of graphs to enhance numerical data in spreadsheets.
8. Apply database functionality including tables, filtering, sorting, and queries.
9. Demonstrate the ability to import, export, merge, and convert data to and from external sources using a variety of document types.
10. Demonstrate effective use of linkages among multiple spreadsheets, external workbooks, and templates.
11. Understand how to build, apply, and edit macros to automate routine tasks.
12. Create pivot tables and graphs to display information, forecast results, and compare alternatives.
13. Demonstrate the ability to print and display sections and whole spreadsheets in a form that make them easy to read and use.


Summer 2019 textbook data will be available on April 1. On that date a link will be available below that will take you to eCampus, CCV's bookstore. The information provided there will be for this course only. Please see this page for more information regarding the purchase of textbooks.

The last day to use a Financial Aid advance to purchase textbooks is the 3rd Tuesday of the semester. See your financial aid counselor at your academic center if you have any questions.

Contact Faculty:

Email: Michael Keogh
Hiring Coordinator for this course: Virginia Gellman




1.  Attendance: Class attendance, participation, and preparedness are essential to success in the course. A student may miss one (1) class without penalty. If a student misses two (2) classes, his or her overall grade will be reduced by 10% (a full letter grade). If a student misses three (3) classes, he or she will be unable to meet the course requirements and will therefore receive an “F” for the course. Don't worry too much about'll be psyched to show up to class every week.

2.  Professional and Ethical Conduct. All students are expected to adhere to the highest standards of professional and ethical conduct. Examples of unprofessional conduct include missing class, not fully participating in discussions, submitting work with spelling and/or grammatical errors, and being disrespectful or discourteous to others in class. Examples of unethical conduct would include any type of cheating, plagiarism, asking for extra credit work, asking for time extensions on assignments or otherwise seeking to gain an unfair advantage over others in the class.

3.  Grading Philosophy: Grading is a function performed by the instructor to appraise how well the student comprehends and applies the course material. Although the calculation is performed by the instructor the grade is a result of the student's performance with respect to assignments and examinations. Grades are earned, not given. Students that make a serious attempt to perform well and put forth sincere effort have a good chance of doing well in the course. Students should confer early in the semester if there are indications that the student is having trouble in the course. Both your instructor and the college want you to succeed, learn the material, and ultimately graduate with a good command of theory and application.

4.  Lectures: Lectures are not intended to provide a detailed presentation of all the basic materials but are intended to provide an overview that highlights and clarifies major points. The absence of a discussion of

assigned material does not relieve students of their responsibility to learn and master the content. If you have questions about the text or other materials, please ask.

5.  Assignments: Students are expected to submit all assignments on the due dates designated. No late work will be accepted. If a student has been absent, he or she is responsible for finding out what the specific assignment is for the next class session. If you are unable to attend class, you must still submit your work before the due date.

6.  Assignment Format: All assignments will be submitted electronically, in Excel, via Moodle unless stated otherwise by the instructor.

7.  Writing Standards: Students are expected to use professional business standards in their writing. If grammatical or spelling errors are found, grades will reduced exponentially for each offense. The net result of this method is as follows: 2 point deduction for the first offense, 4 points for 2 offenses, 8 points for 3 offenses, 16 points for 4 offenses, 32 points for 5 offenses, etc. You should be worried about this one but we'll cover spellcheck in week one.

8.  Plagiarism: Plagiarism is unacceptable. It will be immediately reported to the Coordinator of Academic Services (Business division), and the Academic Dean for appropriate action. Please refer to the college's policy on Academic Honesty here:

9.  Open Door Policy: Students should feel free and are encouraged to discuss any concern, question, or issue with me at any time. The preferred methods of contact include email, discussion forums, and/or before or after class.

10.  Dispute Resolution: Any student who has concerns regarding any aspect of a course is encouraged to seek a resolution by discussing the issue in question with me. If we are unable to satisfactorily resolve the issue, the issue will be referred to the Coordinator of Academic Services, Business for resolution.

11.  ADA POLICY: In order to receive accommodations for disabilities in this course, students must make an appointment to see the Americans with Disabilities coordinator in their Academic Center.





Grading Criteria

Category Percent









Please note: In order to receive accommodations for disabilities in this course, students must make an appointment to see the Americans with Disabilities Coordinator in their site and bring documentation with them.

Academic Honesty: CCV has a commitment to honesty and excellence in academic work and expects the same from all students. Academic dishonesty, or cheating, can occur whenever you present -as your own work- something that you did not do. You can also be guilty of cheating if you help someone else cheat. Being unaware of what constitutes academic dishonesty (such as knowing what plagiarism is) does not absolve a student of the responsibility to be honest in his/her academic work. Academic dishonesty is taken very seriously and may lead to dismissal from the College.

Course description details subject to change. Please refer to this document frequently.

To check on space availability, choose Search for Classes.

Return to Rutland Section Grid
Return to Spreadsheets Page

© Community College of Vermont
For support click on: Vermont State Colleges Help Desk and choose the Student and Visitor Login.
Complete the screen that follows as fully as you can.