Course: CS120 - Digital Literacy (OER)

Topic outline

General

Welcome to CS120 - Digital Literacy

This course is designed as a survey course to familiarize students with computer concepts including software and hardware, software applications, and living online leading towards digital computer literacy. Instruction in this course is provided through demonstration and discussion. Class time will be provided for practicing concepts as well as working through assignments; however, additional time outside of class will be essential to improve skills and complete the assignments.

This work was created by Sisi Virasak and Ziko Rizk and is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License
Download this course from CommunityArchive@LBCC.
For access to instructor-only content, contact Sisi Virasak, virasas@linnbenton.edu, or Ziko Rizk, rizkz@linnbenton.edu
- Instructor forum (for instructor updates and announcements)
- CS120 Syllabus (Please read carefully!) File 26KB
  
  View
- IMPORTANT - This course leverages the gcflearnfree.org online material. File 741.3KB
  
  View
- LBCC Tutoring Center (Free tutoring is available for CS120) URL
  
  View
- LBCC Students Help desk (Moodle, Gmail, password, etc.) URL
  
  View
- Participation (for instructor use only) Assignment
- Final Project
- Final Project Guidelines File 418.7KB
  
  View
- Final Project Rubric File 13KB
  
  View
- Final Project teams File 16.5KB
  
  View
- Final Project Outline Example File 15.7KB
  
  View
Topic 1

Week #1 - Welcome, Overview of computers (Including Hardware), Windows Operating Systems, and Applications.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, only for your own benefit!
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- What is Moodle? (short video) URL
  
  View
- LBCC Moodle Account (short video) URL
  
  View
- --- Computers
- High-Level Computer Abstraction slide File 53.3KB
  
  View
- What is a Computer? (includes short video) URL
  
  View
- Basic Parts of a Computer (includes short video and interactive buttons) URL
  
  View
- Buttons and Ports on a Computer (includes short video and interactive buttons) URL
  
  View
- Inside a Computer (includes short video) URL
  
  View
- Laptop Computers (includes short video) URL
  
  View
- Mobile Computers URL
  
  View
- --- Windows Operating System
- Understanding Operating Systems - OSs (includes short video) URL
  
  View
- What is Windows? URL
  
  View
- --- Applications
- Understanding Applications (includes short video) URL
  
  View
- Navigating Windows (Includes short video and interactive buttons) URL
  
  View
- Types of Computer Software slide File 39.9KB
  
  View
- Quiz and Assignment
- Week-1 Quiz (Due on Sunday, Oct 1 @ 11:55 pm)
  
  Receive a grade
- Download Week-1 Assignment File 20.8KB
  
  View
- Upload Week-1 Assignment (Due on Sunday, Oct 1 @ 11:55 pm)
  
  Make a submission
Topic 2
Week #2 - Overview Windows 10 Operating System, File System, and Snipping tool.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- Windows 10 Features (includes short video) URL
  
  View
- Getting Started with Windows 10 (includes short video) URL
  
  View
- Personalizing Windows 10 Desktop URL
  
  View
- Customize Windows 10 Start Menu URL
  
  View
- Making Windows 10 Feel More Familiar URL
  
  View
- Tips for Managing Multiple Windows URL
  
  View
- Windows 10 Keyboard Shortcuts URL
  
  View
- --- Drives, Folders, and Files
- Drives, Folders, and Files Slides 240KB
  
  View
- Working with Files (includes short video) URL
  
  View
- Finding your Files (includes short video) URL
  
  View
- Finding Your Files with Search and Libraries (includes short video and interactive buttons) URL
  
  View
- Opening Files with Different Applications URL
  
  View
- Working with Flash Drives URL
  
  View
- --- Snipping Tool
- Snipping Tool Slides File 54.3KB
  
  View
- Working with Snipping Tool (9 mins video) URL
  
  View
- --- PDF File Format
- PDF Files Slides 54.8KB
  
  View
- Quiz and Assignment
- Week-2 Quiz (Due on Sunday, Oct 8 @ 11:55 pm)
  
  Receive a grade
- Download Week-2 Assignment File 19KB
  
  View
- Upload Week-2 Assignment (Due on Sunday, Oct 8 @ 11:55 PM)
  
  Make a submission
Topic 3

Week #3 - Overview of Computer Networks, Internet, Browsers, and Cloud Computing (Google Drive & Microsoft OneDrive).

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- What is the Internet? (includes short video) URL
  
  View
- What Can You Do Online? URL
  
  View
- Connecting to the Internet (includes short video) URL
  
  View
- Using a Web Browser (includes short video) URL
  
  View
- Understanding Hyperlinks URL
  
  View
- Using Search Engines (includes short video) URL
  
  View
- --- Cloud Computing and Google Drive
- Understanding the Cloud (includes short video) URL
  
  View
- All About Google Drive (includes short video) URL
  
  View
- Getting Started with Google Drive (includes short video and interactive buttons) URL
  
  View
- --- MS OneDrive and Office Online
- What is Microsoft OneDrive and Office Online? URL
  
  View
- Getting Started with Microsoft OneDrive (includes short video and interactive buttons) URL
  
  View
- --- Web 2.0, Web 3.0 and Computer Ethics
- Web 2.0 & Beyond Slides File 676.7KB
  
  View
- Computer Ethics Slides File 142.1KB
  
  View
- Quiz and Assignment
- Week-3 Quiz (Due on Sunday, Oct 15 @ 11:55 pm)
  
  Receive a grade
- Download Week-3 Assignment File 19.2KB
  
  View
- Upload Week-3 Assignment (Due on Sunday, Oct 15 @ 11:55 pm)
  
  Make a submission
Topic 4

Week #4 - Overview of Google Gmail, Contacts, Calendar, and Deeper Dive into Google Drive & OneDrive.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- Introduction to Gmail (includes interactive buttons) URL
  
  View
- Sending Email with Gmail (includes short video and interactive buttons) URL
  
  View
- Responding to Email with Gmail (includes short video) URL
  
  View
- Managing Email with Gmail (includes short video) URL
  
  View
- Online Phishing Scams URL
  
  View
- Email Etiquette and Safety (includes interactive buttons) URL
  
  View
- Google Contacts and Calendar (includes interactive buttons) URL
  
  View
- --- Google Drive and Apps
- Understanding Google Privacy (includes short videos) URL
  
  View
- Sharing and Collaborating with Google Drive (Includes short video and interactive buttons) URL
  
  View
- --- MS OneDrive and Office Online
- Create and Share OneDrive Office Documents URL
  
  View
- Quiz and Assignment
- Week-4 Quiz (Due on Sunday, Oct 22 @ 11:55 pm)
  
  Receive a grade
- Download Week-4 Assignment File 21.7KB
  
  View
- Upload Week-4 Assignment (Due on Sunday, Oct 22 @ 11:55 pm)
  
  Receive a grade
Topic 5

Week #5 - Intro to MS Office and Overview of MS Word.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- --- MS Office Options
- IMPORTANT: LBCC MS Office 365 Offer to Students URL
  
  View
- Understanding MS Office 365 and MS Office 2013/2016 Options URL
  
  View
- Understanding MS Office for Mobile Devices URL
  
  View
- --- MS Word
- Getting Started with MS Word (Includes short video, and interactive buttons) URL
  
  View
- Creating and Opening Documents (Includes short video) URL
  
  View
- Saving and Sharing Documents (Includes short video and interactive buttons) URL
  
  View
- Text Basics (Includes short video) URL
  
  View
- Formatting Text (Includes short video) URL
  
  View
- Using Find and Replace (Includes short video) URL
  
  View
- Indents and Tabs (Includes short video) URL
  
  View
- Line Paragraph and Spacing (Includes short video) URL
  
  View
- Lists (Includes short video) URL
  
  View
- Page Layout (Includes short video) URL
  
  View
- Printing Documents (Includes short and Interactive Buttons) URL
  
  View
- Quiz and Assignment
- Week-5 Quiz (Due on Sunday, Oct 29 @ 11:55 pm)
  
  Receive a grade
- Download Week-5 Assignment File 72.4KB
  
  View
- Upload Week-5 Assignment (Due on Sunday, Oct 29 @ 11:55 pm)
  
  Make a submission
Topic 6

Week #6 - Complete MS Word and Intro to Google Docs and OneDrive Word (Including File Format Converting) + Midterm Exam.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- Breaks (Includes short video) URL
  
  View
- Columns (Includes short video) URL
  
  View
- Headers and Footers (Includes short video) URL
  
  View
- Page Numbers (Includes short video) URL
  
  View
- Pictures and Text Wrapping (Includes short video) URL
  
  View
- Tables (Includes short video and Interactive Buttons) URL
  
  View
- Check Spelling and Grammar (Includes short video) URL
  
  View
- --- Google Doc
- Getting Started with Google Docs (Includes short video and interactive buttons) URL
  
  View
- Creating Google Docs (includes short video) URL
  
  View
- Formatting Text and Adding Hyperlinks (includes short video) URL
  
  View
- Using Indents and Tabs (includes short video) URL
  
  View
- Headers, Footers, and Page Breaks (includes short video) URL
  
  View
- Uploading Files to Google Drive (includes short video) URL
  
  View
- Managing your Google Drive Files (includes short video) URL
  
  View
- Converting and Printing Google Docs URL
  
  View
- Sharing and Collaborating with Google Drive (Includes short video and interactive buttons) URL
  
  View
- --- OneDrive Word
- Getting Started with OneDrive (includes short video and interactive buttons) URL
  
  View
- Create and Share Office Documents with OneDrive (includes short video) URL
  
  View
- Working with Office Online (includes short video and interactive buttons) URL
  
  View
- Upload, Sync, and Manage Files (includes short video) URL
  
  View
- Quiz and Assignment
- Week-6 Quiz (Due on Sunday, Nov 5 @ 11:55 pm)
  
  Receive a grade
- Download Week-6 Assignment File 291.3KB
  
  View
- Upload Week-6 Assignment - zipped file (Due on Sunday, Nov 5 @ 11:55 pm)
  
  Make a submission
- Midterm Exam - must be in class!
- Midterm Exam (Multiple-choice, must be in class! Thurs, Nov 2 @ 10:00 am) Quiz
  
  Receive a grade
Topic 7

Week #7 - Overview of MS Excel.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!
**** Saturday, Nov 11 is Veterans Day ****
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- Getting Started with Excel (Includes short video and interactive buttons) URL
  
  View
- Creating and Opening Workbooks (Includes short video) URL
  
  View
- Saving and Sharing Workbooks (Includes short video and interactive buttons) URL
  
  View
- Cell Basics (Includes short video) URL
  
  View
- Modifying Columns, Rows, and Cells (Includes short video) URL
  
  View
- Formatting Cells (Includes short video and interactive buttons) URL
  
  View
- Understanding Number Formats (Includes short video) URL
  
  View
- Working with Multiple Worksheets (Includes short video) URL
  
  View
- Page Layout and Printing (Includes short video and interactive buttons) URL
  
  View
- Intro to Functions (Includes short video) URL
  
  View
- Intro to Formulas (Includes short video) URL
  
  View
- Quiz and Assignment
- Week-7 Quiz (Due on Sunday, Nov 12 @ 11:55 pm)
  
  Receive a grade
- Download Week-7 Assignment File 27.5KB
- Upload Week-7 Assignment (Due on Sunday, Nov 12 @ 11:55 pm)
  
  Make a submission
Topic 8

Week #8 - Complete MS Excel and Intro to Google Sheets and OneDrive Excel (Including File Format Converting).

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- Freezing Panes and View Options (Includes short video) URL
  
  View
- Sorting Data (Includes short video) URL
  
  View
- Filtering Data (Includes short video) URL
  
  View
- Charts (Includes short video) URL
  
  View
- Basic Tips for Working with Data URL
  
  View
- --- Google Sheets
- Getting Started with Google Sheets (Includes short video & interactive buttons) URL
  
  View
- Modifying Columns, Rows and Cells with Google Sheets (Includes short video) URL
  
  View
- Formatting Cells (Includes short video) URL
  
  View
- Creating Simple Formulas (Includes short video) URL
  
  View
- Creating Complex Formulas (Includes short video) URL
  
  View
- --- OneDrive Excel
- Create and Share Office Documents (Includes short video) URL
  
  View
- Working with Office Online (Includes short video and interactive buttons) URL
  
  View
- Quiz and Assignment
- Week-8 Quiz (Due on Sunday, Nov 19 @ 11:55 pm)
  
  Receive a grade
- Download Week-8 Assignment File 250.4KB
  
  View
- Upload Week-8 Assignment - zipped file (Due on Sunday, Nov 19 @ 11:55 pm)
  
  Make a submission
- Final Project Outline
- Upload Final Project Outline File (Due on Sunday, Nov 19 @ 11:55 pm) Assignment
  
  Make a submission
- Final Project Outline Example File 15.7KB
  
  View
Topic 9

Week #9 - Overview of MS PowerPoint and Intro to Google Slides and OneDrive PowerPoint.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!
**** Thursday, Nov 23 is Thanksgiving Day = Holiday ****
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- Getting Started with PowerPoint (Includes short video and interactive buttons) URL
  
  View
- Creating and Opening Presentations (Includes short video) URL
  
  View
- Saving and Sharing (Includes short video) URL
  
  View
- Slides Basics (Includes short video) URL
  
  View
- Text Basics (Includes short video) URL
  
  View
- Applying Themes (Includes short video) URL
  
  View
- Applying Transition (Includes short video) URL
  
  View
- Managing Slides (Includes short video) URL
  
  View
- Printing (Includes short video and interactive buttons) URL
  
  View
- Presenting Your Slides (Includes short video and interactive buttons) URL
  
  View
- Inserting Pictures (Includes short video) URL
  
  View
- Formatting Pictures (Includes short video) URL
  
  View
- --- Google Slides (Talk about and demo)
- Getting Started with Google Slides (Includes interactive buttons) URL
  
  View
- Slide Basics URL
  
  View
- Text Basics (Includes interactive buttons) URL
  
  View
- Adding Pictures and Shapes URL
  
  View
- Adding Transitions and Animations URL
  
  View
- Presenting Your Slides URL
  
  View
- --- OneDrive PowerPoint (Talk about and demo)
- Create and Share Office Documents (Includes short video) URL
  
  View
- Working with Office Online (Includes short video and interactive buttons) URL
  
  View
- Quiz and Assignment
- Week-9 Quiz (Due on Sunday, Nov 26 @ 11:55 pm)
  
  Receive a grade
- Download Week-9 Assignment File 438.6KB
  
  View
- Upload Week-9 Assignment (Due on Sunday, Nov 26 @ 11:55 pm)
  
  Make a submission
Topic 10

Week #10 - Overview of Computer Security, Key System Utilities (Windows Update, Defender, Disk Cleanup, Defrag, Task Manager & Backup), and Intro to MS Office.
IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!
- Reading and Videos
  NOTE: Study modules sequentially and don't move on until you have internalized the module content.
- Introduction to Internet Safety (includes short video) URL
  
  View
- Creating a Strong Password (includes short video) URL
  
  View
- Your Browser's Security Features (includes short video) URL
  
  View
- Safe Online Shopping (includes short video) URL
  
  View
- Understanding Browser Tracking (includes short video) URL
  
  View
- Social Media Privacy Basics (includes short video) URL
  
  View
- --- Computer Security
- Computer Security Slides File 100.5KB
  
  View
- --- Computer Utilities
- Computer Utilities Slides File 94.7KB
  
  View
- --- Purchasing a Computer
- Purchase a Computer Slides File 3.2MB
  
  View
- --- Troubleshooting a Computer
- Troubleshooting a Computer Slides File 388.4KB
  
  View
- Quiz and Assignment
- Week-10 Quiz (Due on Sunday, Dec 3 @ 11:55 pm)
  
  Receive a grade
  
  Week-10 Quiz
- Download Week-10 Assignment File 117.9KB
  
  View
- Upload Week-10 Assignment (Due on Sunday, Dec 3 @ 11:55 pm)
  
  Make a submission
Topic 11
Week #11 - Final Project Presentations on Tues, Dec 5 @ 9:30 am.

To review the Final Project Guidelines, open the Word file by that name on our Moodle site. Each time must complete and upload the following files:
1. Final Project MS Word Report
2. Final Project MS Excel File
3. Final Project MS PowerPoint File
- Final Project Documents
- Upload MS Word Report (Sunday, Dec 3 @ 11:55 pm) Assignment
  
  Make a submission
- Upload MS Excel Graph (Sunday, Dec 3 @ 11:55 pm) Assignment
  
  Make a submission
- Upload MS PowerPoint Presentation File (Sunday, Dec 3 @ 11:55 pm) Assignment
  
  Make a submission

Topic outline

Welcome to CS120 - Digital Literacy

Welcome to CS120 - Digital Literacy

This work was created by Sisi Virasak and Ziko Rizk and is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License

Final Project

Week #1 - Welcome, Overview of computers (Including Hardware), Windows Operating Systems, and Applications.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, only for your own benefit!

Reading and Videos

Quiz and Assignment

Week #2 - Overview Windows 10 Operating System, File System, and Snipping tool.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!

Reading and Videos

Quiz and Assignment

Week #3 - Overview of Computer Networks, Internet, Browsers, and Cloud Computing (Google Drive & Microsoft OneDrive).

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!

Reading and Videos

Quiz and Assignment

Week #4 - Overview of Google Gmail, Contacts, Calendar, and Deeper Dive into Google Drive & OneDrive.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!

Reading and Videos

Quiz and Assignment

Week #5 - Intro to MS Office and Overview of MS Word.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!

Reading and Videos

Quiz and Assignment

Week #6 - Complete MS Word and Intro to Google Docs and OneDrive Word (Including File Format Converting) + Midterm Exam.

Week #6 - Complete MS Word and Intro to Google Docs and OneDrive Word (Including File Format Converting) + Midterm Exam.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!

Reading and Videos

Quiz and Assignment

Midterm Exam - must be in class!

Week #7 - Overview of MS Excel.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!

**** Saturday, Nov 11 is Veterans Day ****

Reading and Videos

Quiz and Assignment

Week #8 - Complete MS Excel and Intro to Google Sheets and OneDrive Excel (Including File Format Converting).

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!

Reading and Videos

Quiz and Assignment

Final Project Outline

Week #9 - Overview of MS PowerPoint and Intro to Google Slides and OneDrive PowerPoint.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!

**** Thursday, Nov 23 is Thanksgiving Day = Holiday ****

Reading and Videos

Quiz and Assignment

Week #10 - Overview of Computer Security, Key System Utilities (Windows Update, Defender, Disk Cleanup, Defrag, Task Manager & Backup), and Intro to MS Office.

IMPORTANT: Make sure to do the "Challenge!" at the end of some gcflearnfree.org modules - not for credit, for your own benefit!

Reading and Videos

Quiz and Assignment

Week #11 - Final Project Presentations on Tues, Dec 5 @ 9:30 am.

Final Project Documents

Saturday, Nov 11 is Veterans Day

Thursday, Nov 23 is Thanksgiving Day = Holiday