Untitled

Web Schedules

Fall 2023
Spring 2023
Summer 2023

One Credit Courses

Fall 2023
Spring 2023
Summer 2023

No Cost Textbook/Resources Courses

Fall 2023
Spring 2023
Summer 2023

Low Cost Textbook/Resources Courses

Fall 2023
Spring 2023
Summer 2023

Course Planning by Program

2023-24

Essential Objectives

Course Syllabus


Revision Date: 02-Jan-23
 

Summer 2023 | CIS-1041-VO04Y - Computer Applications


Online Class

Online courses take place 100% online via Canvas, without required in-person or Zoom meetings.

Location: Online
Credits: 3 (45 hours)
Day/Times: Meets online
Semester Dates: 06-27-2023 to 08-14-2023
Last day to drop without a grade: 07-06-2023 - Refund Policy
Last day to withdraw (W grade): 07-25-2023 - Refund Policy
Open Seats/Section Limit: 8/20 (as of 05-29-23 8:15 AM)

Faculty

Amy Moore
View Faculty Credentials

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 hands-on introduction to office application software designed for computers and mobile devices. Topics include cloud applications, presentations, word processing, and spreadsheets. Basic computer skills are required.


Essential Objectives

1. Describe the threat of computer malware, spyware, and phishing and 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. Demonstrate an ability to access, navigate, and participate in a virtual learning environment.
11. 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 (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


*** This is a no cost textbook or resource class ***

This course uses one or more textbooks/books/simulations, along with free Open Educational Resources (OER) and/or library materials.

Summer 2023 textbook/book details will be available on 2022-11-28. On that date a link will be available below that will take you to eCampus, CCV's bookstore. The information provided there will be specific to this class. Please see this page for more information regarding the purchase of textbooks/books.

CIS-1041-VO04Y Link to Textbooks for this course in eCampus.

For Open Educational Resources (OER) and/or library materials details, see the Canvas Site for this class.

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

  • Small-group and whole-class discussion
  • Online discussion forums
  • Lecture
  • Mini-lecture videos and emails
  • Online reading and videos from library and software vendors
  • Small group activities
  • In-class procedures with application software
  • Online exams
  • Word processing and Spreadsheet projects
  • Presentation project with discussion
  • Homework practicals

Evaluation Criteria

Attendance and Participation: 10%
Quizzes: 25%
Homework: 30%
Projects: 25%
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.


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.


Missing & Late Work Policy

All modules begin on a Tuesday. Assignments, Self-Assessments, and Discussions are due the upcoming Sunday at midnight. Quizzes and Projects are due the following Sunday at midnight.

Nothing is late until it is graded. I repeat, nothing is late until it is graded. If you do not have a 0, know that your work will be graded as not late.

If you do get a grade less than 100, you are welcome to redo and resubmit your work to improve your grade no matter your score. This includes getting a 0 for not submitting work. If you do submit work after it has been graded 0, LEAVE A COMMENT explaining why the work is late. Instructor will take this into consideration when deciding on the -20% for late work.

Instructor may take 20% off work that has already been graded 0 when late, meaning, you may only get 80% of your possible grade. The instructor's goal is to help all students succeed in this course and late work with communication (leaving a comment) will mostly not be graded late if it is an occasional thing. Responses to forums, which you class mates rely on, are likely to be graded -20% regardless of comments.

THIS IS AN ACCELERATED CLASS. The weekly schedule in this course description is for 15 weeks. These "weeks" in the syllabus will be distributed over 7 weeks, with 2 or 3 modules due per week and "week 15" will be scheduled the last day of the course.


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.