Untitled

Web Schedules

Fall 2022
Spring 2022
Summer 2022

One Credit Courses

Fall 2022
Spring 2022
Summer 2022

Course Planning by Program

2022-23

Essential Objectives

Course Syllabus


Revision Date: 04-Jan-22
 

Summer 2022 | CIS-1430-VO02F - 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 Summer 2022 ends on July 8.


Location: Online
Credits: 3 (45 hours)
Day/Times: Meets online
Semester Dates: 05-24-2022 to 08-15-2022
Last day to drop without a grade: 06-13-2022 - Refund Policy
Last day to withdraw (W grade): 07-11-2022 - Refund Policy
Open Seats/Section Limit: 6/20 (as of 05-18-22 8:05 PM)

Faculty

Amy Moore
View Faculty Credentials
View Faculty Statement
Hiring Coordinator for this course: Debra Grant

General Education Requirements


This section meets the following VSC General Education Requirement(s) for Catalog Year 21-22 and later:
Digital and Technical Literacy
    Note
  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 catalog year 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. 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 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

CIS-1430-VO02F Link to Textbooks/Resources Information for this course in eCampus.

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

  • Online discussion
  • Mini-lecture
  • Procedures with application software
  • Online exams
  • Extensive use of tools in Canvas
  • Homework with application software

Evaluation Criteria

Homework: 30%
Projects: 35%
Exams: 30%
Online Self-Assessment Surveys: 5%

Exams are to be complete online in the Canvas environment and are based on reading, videos, class projects, and lecture notes. These assessments are usually taken outside the normal classroom time at the student's own pace. Quizzes are posted and available in conjunction with the material covered by the quizzes.

Homework is assigned in conjunction with each topic covered in the course and usually weekly. Every week will have any number of homework assignments. For any homework that does not have a specific grading rubric, students must attempt to complete the homework. Any legitimate attempt is considered a 100% effort so long as the student presents challenges to completing the work at the beginning of the next class. Late homework will receive a grade at something less than 100%. Simply uploading the starting file, for example, is not considered a legitimate attempt at homework. Homework assignments will typically have a significant amount of instruction and/or be related to single tools.

Projects will be completed throughout the semester. Projects are more involved than homework and require regular work toward completion. These assignments will use tools already covered by homework assignments but come with the expectation the student will APPLY the knowledge previously learned and will not come with more thorough instruction from the instructor. Students are welcome to use tutor.com and other tools for assistance with these assignments.


Grading Criteria

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

 HighLow
A+10098
A Less than 9893
A-Less than 9390
B+Less than 9088
B Less than 8883
B-Less than 8380
C+Less than 8078
C Less than 7873
C-Less than 7370
D+Less than 7068
D Less than 6863
D-Less than 6360
FLess than 60 
P10060
NPLess than 600


Weekly Schedule


Week/ModuleTopic  Readings  Assignments
 

1

Spreadsheet Basics

  

The Smart Method - Basic Skills - Session 1

  
  • Saving files
  • Using Versions feature (Windows only)
  • Create a Google Account
  • Update Canvas profile picture
  • Quiz on reading
  • Self-Assessment
 

2

Basic Skills Continued - Cloud Computing

  

The Smart Method - Basic Skills - Session 2

The Smart Method - Essential Skills - Session 3 Lessons 12 & 13

The Smart Method - Expert Skills - Session 8

Cloud Computing writing included in assignments on Canvas

  
  • Using Canvas and Google Drive
  • Anonymous vs. Specific Sharing
  • Intro to O365 and File Sharing
  • Basic Skills Lessons 2-1 through 2-17
  • Understanding lineal and exponential series
  • Using automatic and manual Flash Fill
  • Mortgage worksheet - References, Copying, PMT function
  • Quiz on Basic Skills Session 2
  • Self-Assessment
 

3

Formatting & Efficiency Tools

  

The Smart Method - Essential Skills - Session 3

The Smart Method - Essential Skills - Session 4

  
  • Mixed References
  • Create a Template
  • Check Spelling
  • Formatting tools
  • Mix of skills from Essential Skills - Session 4
  • Quiz on Essential Skills - Session 3
  • Self-Assessment
 

4

Conditional Formatting, In-Cell Graphing, Advanced Functions (Part 1)

  

Essential Skills: Session 4 - Lessons 15-17

Expert Skills: Session 3 – Lessons 1-16

Instructor video: “Functions and Sparklines Applied"

  
  • Conditional formatting
  • Sparklines
  • Rotate text
  • More sparklines and formatting
  • Advanced functions
  • Project: Functions and Sparklines Applied
  • Project: Essential Skills Session 4 Challenge
  • Quiz on Essential Skills Session 4
  • Quiz on Expert Skills Session 3
  • Self-Assessment
 

5

Tables and Ranges

  

The Smart Method Expert Skills - Session 1

  
  • Lessons from Expert Skills Session 1
  • End of Session Exercise - Expert Skills Session 1
  • Quiz on Expert Skills Session 1
  • Self-Assessment
 

6

Forms, Names, and Formula Auditing

  

The Smart Method - Expert Skills - Session 4

Instructor written instructions on Microsoft O365 and Google Drive Forms

YouTube videos and Microsoft and Google forms

Goodwill Community Foundation tutorials on Google forms

  
  • Make a Microsoft Office 365 quiz or survey and share with class
  • Make a Google Drive quiz or survey and share with class
  • Complete Expert Skills - Session 4 lessons
  • Quiz on Expert Skills Session 4
  • Self-Assessment
 

7

Sheets and Books, Charts and Graphs

  

The Smart Method - Essential Skills - Session 5

Lecture articles about Charts

  
  • Essential Skills Session 5 Lessons
  • Essential Skills Session 5 end of Session Exercise
  • Project: Information around Us
  • Self-Assessment
 

8

Maps

  

The Smart Method - Expert Skills - Session 9

Instructor lecture on 3D Maps and included links

Instructor video on Google Maps & Spreadsheets

  
  • Make a Google Map from a spreadsheet
  • Make an Excel 2D or 3D Map
  • Self-Assessment
 

9

Advanced Functions (Part 2)

  

The Smart Method - Expert Skills - Session 3

  
  • Complete Expert Skills Session 3 Lessons
  • Quiz - Expert Skills Session 3
  • Self-Assessment
 

10

Data Integrity, Subtotals, Validations

  

The Smart Method - Expert Skills - Session 2

  
  • Expert Skills Session 2 end of session Exercise
  • Project: Make a reusable Order Form
  • Quiz - Expert Skills Session 2
  • Self-Assessment
 

11

Working across Worksheets and Workbooks

  

The Smart Method - Essential Skills - Session 6

  
  • Share previous graphical work (map or chart)
  • Essential Skills Session 6 end of session Exercise
  • Quiz - Essential Skills Session 6
  • Self-Assessment
 

12

Printing with Excel, Excel Forms

  

The Smart Method - Essential Skills - Session 7

The Smart Method - Expert Skills - Session 7

  
  • Expert Skills Session 7 end of session Exercise
  • Quiz - Essential Skills Session 7
  • Quiz - Expert Skills Session 7
  • Self-Assessment
 

13

Hyperlinks and Office Integration

  

The Smart Method - Expert Skills - Session 6

  
  • Expert Skills Session 6 end of session Exercise
  • Quiz - Expert Skills Session 6
  • Self-Assessment
 

14

Pivot Tables

  

The Smart Method - Expert Skills - Session 8

  
  • Expert Skills Session 8 end of session Exercise
  • Self-Assessment
 

15

What-If Analysis and Data Security

  

The Smart Method - Expert Skills - Session 5

  
  • Expert Skills Session 5 end of session Exercise
  • Self-Assessment
 

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.


Missing & Late Work Policy

As this is a Flex course, missing assignments will be graded beginning the last week of the semester.

There is no "late work" in this class.


Accessibility Services for Students with Disabilities:


CCV strives to mitigate barriers to course access for students with documented disabilities. To request accommodations, please
  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


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.





Return to Section Menu

Return to Section List