COSI118 Course Outline

Text:

Weeks Topics Laboratory
Activities		 Assignments, Quizzes or Tests
1
  1. Introduction of the course
  2. Management of folders
  3. Winows10 & Office 2019
  4. Word - Creating Documents with Word

Save a file
Word - Module 1 		Create folders at MS Teams
Assignments of Word Module 1
2 Word - Editing and Formatting Documents Word - Module 2 Assignments of Word Module 2
Computer Concepts I:
  1. A Computer System:
  2. The Components of a Computer:
    • Input Devices
    • Output Devices
    • CPU
    • Memory
    • Storage
Research Paper

Research Paper

3 Word - Formatting Text and Graphics Word - Module 3 Assignments of Word Module 3

Quiz 1: Computer Hardware

  • Input Devices
  • Output Devices
  • CPU
  • Memory
  • Storage
4 Key for Hands-On Word Test
  • Header Area: name & page numbers on right side
  • Title on the center of line
  • First line indentation
  • numbers & bullets
  • footnote
  • citation & change appearance & bibliography
  • page break
  • left & right tabs with leading dots and border & shading
  • insert pictures & resize them
  • insert shapes & move it
  • insert a smart-art
 Hands-On Word Test Hands-On Word Test
5 Introduction to Excel

Excel - Getting Started with Excel

Excel Module 0

Excel Module 1

Assignments of Excel Module 0.

Assignments of Excel Module 1.
6 Excel - Formatting a Worksheet

Computer Concepts II:
Storage Devices:

Excel Module 2 Assignments of Excel Module 2

Quiz 2: Storages

  • Difference between Memory & Secondary Storage
  • Size of Storage
  • Read, Write, Erase
Excel - What-If Analysis, If statement, and Charts Excel Module 2B

Assignments of Excel Module 2B
7 Excel - Analyzing Data Using Formulas

Excel - Working with Charts

 Excel Module 3

Excel Module 4

Assignment of Excel Module 3

Assignment of Excel Module 4
8 Computer Concepts III:
  1. Computer Hardware
  2. Computer Software:

Sample Excel Test

Send the Sample Excel Test  file.

Quiz 3: Computer Software / Hardware
Key for Hands-On Excel Test
  • Type a title for a sheet and merge/center in the row.
  • Insert a time stamp.
  • Wrap a text into two layers.
  • Format numbers with "$" signs / Show only 2 decimal places.
  • Rename a sheet / Copy a sheet to another sheet.
  • Be able to do calculation with +, -, *, or /.
  • Be able to find sum, average, max, min and data is on the right range.
  • Know when to use absolute address / relative address.
  • How to use "if" function to make decision.
  • Be able to do what-if-analysis (Change data or result?).
  • Be able to do and read a pie chart / column chart correctly.
 Hands-On Excel Test Hands-On Excel Test
9 PowerPoint - Creating a Presentation in PowerPoint

Computer Concepts IV:
Networks and Internet - Security

 PowerPoint
Module 1

Network & Security Video

Assignment of PowerPoint Module 1.

Quiz 4 - Networks and Internet
10 PowerPoint - Modifying a Presentation PowerPoint
Module 2
 		 Assignment of PowerPoint Module 2
11

PowerPoint - Inserting Objects into a Presentation

PowerPoint
Module 3

Module 3 - Part 1 Video
Module 3 - Part 2 Video

Assignment of PowerPoint Module 3
12 Keys for PowerPoint Test
  • Set design template
  • Be able to use WordArt
  • Set bullets in different levels
  • Duplicate slide & convert text into smart-art
  • Subtract two shapes and type a textbox
  • Create a chart with data
  • Add information in footer
  • Set a transition
 Hands-On PowerPoint Test Hands-On PowerPoint Test
13-14 Intro to iPad software: Numbers, Pages
Numbers User Guide for Mac 		iPad project:
- table in Numbers
- list in Pages
- adding a video in Numbers		 Project in iPad
15 Review and Final Comprehensive Test