Untitled

Web Schedules

Fall 2023
Spring 2024
Summer 2024

One Credit Courses

Fall 2023
Spring 2024
Summer 2024

No Cost Textbook/Resources Courses

Fall 2023
Spring 2024
Summer 2024

Low Cost Textbook/Resources Courses

Fall 2023
Spring 2024
Summer 2024

Course Planning by Program

2023-24

Essential Objectives

Course Syllabus


Revision Date: 30-Aug-23
 

Fall 2023 | CIS-1041-VO09F - Computer Applications


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 2023 ends on October 30.


Location: Online
Credits: 3 (45 hours)
Day/Times: Meets online
Semester Dates: 09-05-2023 to 12-18-2023
Last day to drop without a grade: 09-25-2023 - Refund Policy
Last day to withdraw (W grade): 11-06-2023 - Refund Policy
This course has started, please contact the offering academic center about registration

Faculty

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

General Education Requirements


This section meets the following CCV General Education Requirement(s) for the current catalog year:
VSCS 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 hands-on introduction to office application software designed for computers and mobile devices. Topics include cloud applications, presentations, word processing, and spreadsheets. Basic computer and internet skills are required.


Essential Objectives

1. Demonstrate safe computing practices.
2. Demonstrate the ability to create resources and set appropriate permissions for cloud-based files and applications and apply file management principles on local and remote networks.
3. Explain the function and the primary features of a word processing program and create documents appropriate for academic and business environments.
4. Design and build a spreadsheet using professional formatting, names, labels, tables, values, formulas, functions, and absolute and relative references.
5. Use spreadsheet software to present and analyze quantitative information, draw conclusions, and evaluate the reliability of those conclusions.
6. Use presentation software to demonstrate proficiency in using text, graphs, organizational charts, tables, artwork, drawing tools, animation, and multimedia.
7. Demonstrate effective, safe, and ethical searching, evaluating, communicating, and citing of digital information.
8. Discuss legal and ethical issues related to computers and information processing, including fair use standards, academic honesty, and user accessibility.
9. Discuss how digital media perpetuates or disrupts systems of inequality.
10. Determine the appropriate devices and software for a variety of tasks and how to accurately convey information, thoughts, and ideas.


Required Technology

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

Microsoft 365 can be installed on Windows 10/11 PC and Macintosh computers and laptops. It cannot be installed on a Chromebook. Microsoft 365 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.


Evaluation Criteria

Assignments and Discussions: 35%
Quizzes: 25%
Projects: 30%
Self-Assessments: 10%

Attendance and Participation
This grade is based on your weekly participation in class as assigned as well as group and participatory projects. Engaging in activity that is not related to class during class will decrease your Attendance & Participation grade. Students who are late or who leave early will also see a reduction in this grade. Students may miss up to 6 hours of instruction with no impact on grade.

Quizzes
Quizzes are given online with a restricted number of attempts but a 2 week period for completion. Quizzes are based on online videos and reading as well as projects and group work.

Homework
A varying number of homework assignments are assigned weekly based on the content covered for the week.

Projects
There are three cumulative projects based on the material covered in the class allowing students to apply the skills covered in class.

Self-Assessments
Students complete web-based forms to evaluate their class and homework performance on a weekly basis.

This course is taught with textbooks and instructional materials using the Windows operating system and Windows editions of Microsoft 365 (formerly known as Microsoft Office). Students with Mac computers should either reach out to their adviser for help with obtaining a PC to work on this course or find a Windows PC for this course. Mac users who complete this course with a Mac will be responsible for looking up the differences for Microsoft 365 for Mac software.


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

OneDrive and Intro to Cloud Computing

  
  • Windows 10 - GCF Learn Free
  • OneDrive lessons from GCF Learn Free
  
  • 4 introductory discussions on Canvas
  • OneDrive submission practice
  • Create Folders in OneDrive
  • Copy and Share O365 Word Document
  • Create a Google Drive Account
  • Update Canvas Profile Picture
  • Self-Assessment
 

2

Google Drive, Malware, Spyware, Phishing

  
  • Instructor written "Using Google Drive"
  • Instructor written "Overview of Google Docs"
  • Google Drive lessons in GCF Learn Free
  • Phishing handout
  • Website on email phishing
  • Website on web phishing
  
  • Discussion on experience with malware
  • Select a research and presentation topic
  • Create a Course folder in OneDrive
  • Specific file sharing in Google Drive
  • Quiz:Phishing Self-Assessment
  • Self-Assessment
 

3

Word Processing – Templates, Structure, Graphics, Tables

  
  • GCF Learn Free Word
  • Microsoft Word 2019 Step by Step Part 1
  • Microsoft Word 2019 Step by Step Part 2
  
  • Create a document from a template
  • 2030 Resume assignment
  • Open a PDF in Word (not available for Mac computers)
  • Edit text
  • Modify text
  • Tables
  • Add graphic elements
  • Quiz:Hartness Library
  • Self-Assessment
 

4

Research Papers, Page-level Formatting, Copyright/Plagiarism

  
  • Microsoft Word 2019 Step by Step Chapters 9 and 10 and 13
  • Several videos and web articles on copyright and Creative Commons
  • Wikipedia entry on History of Copyright Law
  • Films on Demand video on Plagiarism and Information Ethics
  
  • Online discussion about remixing, stealing, reposting, piracy, sharing, copyright, and plagiarism
  • Format page backgrounds
  • Complete Microsoft Official Academic Course chapter on writing research papers in Word
  • Headers, Footers, page numbers
  • Quiz:Based on Hartness Library video "Plagiarism and Information Ethics"
  • Self-Assessment
 

5

Columns, Markup, Picture Diagrams/3D Models, Search Skills

  
  • Microsoft Word 2019 Step by Step Chapter 7
  • Microsoft Word 2019 Step by Step Chapter 11
  
  • Formatting and Expense Report
  • Formatting a two-column newsletter
  • Mark up documents
  • Picture diagrams OR 3D models
  • 2030 Resume
  • Research topic sources
  • Self-Assessment
  • Quiz:based on Hartness Library video "Effective Internet Searches"
 

6

MailMerge and Intro to Presentations

  
  • Microsoft Word 2019 Step by Step Chapter 13
  • Microsoft Word 2019 Step by Step Chapter 14
  • Life after Death by PowerPoint – YouTube video - Don McMillan
  • How to Avoid Death by PowerPoint – TED Talk – David JP Phillips
  • GCF Learn Free PowerPoint (optional)
  • PowerPoint Step by Step Chapter 1
  • PowerPoint Step by Step Chapter 2
  
  • Mail Merge assignment from MOAC Lesson 11
  • Quiz:Microsoft Office Word
  • Research project storyline worksheet
  • Remove audio from the beginning or end of an audio file
  • Remove audio from the middle of an audio file
  • Create a bad presentation
  • PowerPoint Step by Step Chapter 1 Practice Task(s)
  • PowerPoint Step by Step Chapter 2 Practice Task(s)
  • Self-Assessment
 

7

Create Presentations, Manage Slides

  
  • PowerPoint Step by Step Chapter 3
  • PowerPoint Step by Step Chapter 4
  • PowerPoint Step by Step Chapter 5
  
  • PowerPoint Step by Step Chapter 3 Practice Task(s)
  • PowerPoint Step by Step Chapter 4 Practice Task(s)
  • PowerPoint Step by Step Chapter 5 Practice Task(s)
  • Self-Assessment
 

8

Manage Graphics, Sound, Animation, Notes

  
  • PowerPoint Step by Step Chapter 6
  • PowerPoint Step by Step Chapter 7
  • PowerPoint Step by Step Chapter 8
  
  • PowerPoint Step by Step Chapter 6 Practice Task(s)
  • PowerPoint Step by Step Chapter 7 Practice Task(s)
  • PowerPoint Step by Step Chapter 8 Practice Task(s)
  • Self-Assessment
 

9

Prepare Presentations for Presentation, Multimedia, Presenter View

  
  • PowerPoint Step by Step Chapter 9
  • PowerPoint Step by Step Chapter 10
  • PowerPoint Step by Step Chapter 11
  
  • Create a working presentation
  • Present computer ethics topic
  • Create and share computer ethics topic handout
  • Self-Assessment
 

10

Intro to Spreadsheets – Setup a Workbook, Work with Data and Tables

  
  • Excel Basics with GCF Learn Free
  • Planet Money Podcast Episode 606
  • Microsoft Excel Step by Step Chapter 1
  • Microsoft Excel Step by Step Chapter 2
  
  • Podcast reaction essay
  • Enter and revise data
  • Find and Replace data
  • Manage data with Flash Fill
  • Quiz:Microsoft Office Word
  • Self-Assessment
 

11

Perform Calculations, Change Workbook Appearance, Manage Data

  
  • Microsoft Excel Step by Step Chapter 3
  • Microsoft Excel Step by Step Chapter 7
  • Microsoft Excel Step by Step Chapter 14 (certain parts)
  
 

12

Reorder and Summarize Data, Multiple Sources, Printing Spreadsheets

  
  • Microsoft Excel Step by Step Chapter 3
  • Microsoft Excel Step by Step Chapter 4
  • Microsoft Excel Step by Step Chapter 6
  • Google Sheets Function List
  • GCF Learn Free: Data Validations, IF function, VLOOKUP function
  • More reading on IF, Data Validation, and VLOOKPUP
  
  • Incorporate basic statistical functions
  • Research and find appropriate functions for use in a spreadsheet
  • Chapter 3 practice tasks
  • Chapter 4 practice tasks
  • Self-Assessment
 

13

Formatting & Charts

  
  • Microsoft Excel Step by Step Chapter 9
  • Microsoft Excel Step by Step Chapter 13 (certain parts)
  • Instructor created Canvas pages
  
  • Chapter 9 practice tasks
  • Chapter 13 practice tasks
  • Information around us – chart
  • Evaluate misleading charts
  • Self-Assessment
 

14

Logical Functions, Data Validation

  

Microsoft Excel Step by Step Chapter 5

  
  • Chapter 5 practice tasks
  • Quiz: Microsoft Excel
  • Self-Assessment
 

15

Student Computing Ethics Presentations

  

Classmate computer ethics presentations

  
  • Review classmate presentations
  • 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.

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.