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: 16-Jan-23
 

Spring 2023 | CIS-1041-VO09S - Computer Applications


Synchronous Class

Synchronous courses are delivered through a combination of online and regularly-scheduled Zoom sessions. In synchronous classes, students must attend Zoom sessions and actively engage with each other and faculty in course activities and discussions.

Location: Online
Credits: 3 (45 hours)
Synchronous Section: This course has schedule meeting dates and times online via Zoom. See below or consult Self Service - Search for Courses and Sections for specific dates and times.
In-Person Meeting Day/Times via Zoom: Tuesday, 06:00P - 08:00P
Semester Dates: 01-24-2023 to 05-02-2023
Last day to drop without a grade: 02-12-2023 - Refund Policy
Last day to withdraw (W grade): 03-26-2023 - Refund Policy
This course has started, please contact the offering academic center about registration

Faculty

Mario Hankerson
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 course only uses free Open Educational Resources (OER) and/or library materials. For details, see the Canvas Site for this class.


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

Your final grade will be based on the following assessments:

Grade Table
Assignment Category Grade Weight Percentage
Demonstrate Your Learning Forums & Assignments 35%
Quizzes 30%
Projects 25%
Self-Assessments 10%
Total 100%

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.


Participation Expectations

Full participation requires active and thoughtful engagement in class each week. The following habits and skills are important. You'll have the opportunity to self-assess and receive instructor feedback on each of these areas at the mid-point and the end of the semester.

  • Attend class regularly, on-time and for the full session
  • Complete all of the week's reading and assignments before the start of class
  • Listen to others attentively and with an open mind
  • Positively contribute to class discussions and activities
  • Ask questions and seek help when you need it
  • Challenge yourself to do your best work


Missing & Late Work Policy

  • Assignments are due by the deadline noted on the syllabus, even when you need to be absent. Your work (programming assignments) can be emailed or uploaded to Canvas.
  • You are responsible for checking Canvas and getting any notes, materials and assignments for the class you missed. Please reach out and ask questions if anything is unclear.
  • Plan to complete homework for the next class meeting on time. Being absent is not an excuse for not completing any homework assigned that day.
  • Late work in not accepted, except in emergency situations. In the case of an extenuating circumstance, please communicate as early as you can with your instructor about the need to miss class and/or assignments.

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.