Course Syllabus

Fall 2022 | CIS-1430-VO05F - Spreadsheets

Flex Class

FLEX courses are online courses with flexible assignment submission, allowing students to manage their completion pace during the semester. FLEX courses remain open for enrollment throughout the first half of the semester. Flex course enrollment for Fall 2022 ends on October 31.

Faculty

Glenn Marvel
View Faculty Credentials
View Faculty Statement
Hiring Coordinator for this course: Debra Grant

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. 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. Demonstrate the ability to create resources, set appropriate permissions, use cloud applications, and apply file management principles to cloud-based files.
5. Use spreadsheet software to present and analyze quantitative information, to draw conclusions from information, and to evaluate the reliability of those conclusions.
6. Demonstrate appropriate use of cell references absolute, relative, and conditional formulas.
7. Apply financial, statistical, mathematical, logical, text, and date functions to build applications.
8. Demonstrate effective use and formatting of graphs to enhance numerical data in spreadsheets.
9. Apply database functionality including tables, filtering, sorting, and queries.
10. Demonstrate the ability to import, export, merge, and convert data to and from external sources using a variety of document types.
11. Demonstrate effective use of linkages to share cell data among multiple spreadsheets, external workbooks, and templates.
12. Create, apply, and edit macros to automate routine tasks.
13. Create pivot tables and graphs to display information, forecast results, and compare alternatives.
14. Demonstrate the ability to print and display sections and whole spreadsheets in a form that make them easy to read and use.
15. Identify the steps needed to display a value from one sheet to another or to a separate workbook.

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.

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

Weekly Schedule

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