Course Syllabus

Spring 2023 | CIS-1430-VR01 - Spreadsheets

In Person Class

Standard courses meet in person at CCV centers, typically once each week for the duration of the semester.

Faculty

Michael Keogh
View Faculty Credentials

Hiring Coordinator for this course: Tapp Barnhill

General Education Requirements

Digital and Technical Literacy

Note

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 catalog year page, and your academic advisor.

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 computer skills are required.

Essential Objectives

1. Demonstrate ability to manage workbook options and settings including multiple workbooks, macros, workbook versions, privacy and protection, comment management, editing and display languages, and language-specific features.
2. Manage and format data using Flash Fill, advanced Fill Series options, custom number formats, data validation, groups, subtotals, and removing duplicate data.
3. Develop proficiency with advanced formulas and functions including but not limited to logical and Boolean functions, nesting multiple functions, date and time functions, and financial functions.
4. Proficiently choose the correct data functions for various application such as VLOOKUP, HLOOKUP, MATCH, and INDEX functions.
5. Summarize data from multiple ranges with the Consolidate feature.
6. Perform what-if analyses with tools such as Goal Seek and Scenario Manager.
7. Troubleshoot formulas with trace precedence and dependence, validate and evaluate formulas using error checking rules, and monitor cells and formulas using the Watch Window.
8. Manage advanced charts and tables including dual axis charts, maps, advanced chart types.
9. Create PivotTables and PivotCharts using slicers, and calculated fields and incorporate styles and appropriate details.
10. Design, plan, and organize spreadsheets that accurately and ethically convey information, thoughts, and ideas.
11. Explain how the use and presentation of data and spreadsheets can be used to persuade, inform, and misinform, particularly around systems of inequality and social change.
12. Evaluate and cite digital information effectively and ethically.

Required Technology

Students in this course will need access to Microsoft (MS) Office. This software is available on CCV lab computers at CCV academic centers and to CCV students free of charge through Office 365 online or by a download of MS Office. Information on how to download the MS Office suite can be found HERE.

The MS Office suite can be installed on Windows 10/11 PC and Macintosh computers and laptops. It cannot be installed on a Chromebook. MS Office on a Macintosh computer does not include all of the features supported by Windows and there are significant menu differences.

If you have difficulty in acquiring or accessing this resource for your course, please contact your advisor or financial aid counselor.

More information on general computer and internet recommendations is available on the CCV IT Support page. https://support.ccv.edu/general/computer-recommendations/

Please see CCV's Digital Equity Statement (pg. 45) to learn more about CCV's commitment to supporting all students access the technology they need to successfully finish their courses.

Required Textbooks and Resources

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

Methods

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, and their overall grade will be reduced by 10% (a full letter grade). If a student misses three (3) classes, they will be unable to meet the course requirements and will therefore receive an “F” for the course. Pretty strict, huh?

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/or 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. They key here is do your best.

3. Grading Philosophy: While the grading calculation is performed by the instructor, the grade is a result of each student's performance with respect to assignments. 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 material 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. Actually I'll cover everything in class and provide additional resources for your review on every topic but this clause covers me just in case. ;)

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, they are responsible for finding out what the specific assignment is for the next class session. It will always be posted in Canvas. 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 via Canvas 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 be 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. Just use spellcheck, okay?

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: http://www.vsc.edu/CCV_Public/Academic_Honesty_CCV_Policy.pdf

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 method of contact is email, and before or after class.

10. Dispute Resolution: A 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.

Evaluation Criteria

Grading Criteria	Category Percent
Homework	60%
Participation	20%
Final Project	20%

Grading Criteria

CCV Letter Grades as outlined in the Evaluation System Policy are assigned according to the following chart:

	High	Low
A+	100	98
A	Less than 98	93
A-	Less than 93	90
B+	Less than 90	88
B	Less than 88	83
B-	Less than 83	80
C+	Less than 80	78
C	Less than 78	73
C-	Less than 73	70
D+	Less than 70	68
D	Less than 68	63
D-	Less than 63	60
F	Less than 60
P	100	60
NP	Less than 60	0

Attendance Policy

Regular attendance and participation in classes are essential for success in and are completion requirements for courses at CCV. A student's failure to meet attendance requirements as specified in course descriptions will normally result in a non-satisfactory grade.

• In general, missing more than 20% of a course due to absences, lateness or early departures may jeopardize a student's ability to earn a satisfactory final grade.
• Attending an on-ground or synchronous course means a student appeared in the live classroom for at least a meaningful portion of a given class meeting. Attending an online course means a student posted a discussion forum response, completed a quiz or attempted some other academically required activity. Simply viewing a course item or module does not count as attendance.
• Meeting the minimum attendance requirement for a course does not mean a student has satisfied the academic requirements for participation, which require students to go above and beyond simply attending a portion of the class. Faculty members will individually determine what constitutes participation in each course they teach and explain in their course descriptions how participation factors into a student's final grade.

Accessibility Services for Students with Disabilities:

1. Provide disability documentation to the Accessibility Coordinator at your academic center. https://ccv.edu/discover-resources/students-with-disabilities/
2. Request an appointment to meet with accessibility coordinator to discuss your request and create an accommodation plan.
3. Once created, students will share the accommodation plan with faculty. Please note, faculty cannot make disability accommodations outside of this process.

Academic Integrity