JCU Logo

JOHN CABOT UNIVERSITY

COURSE CODE: "CS 110-2"
COURSE NAME: "Microcomputer Applications"
SEMESTER & YEAR: Fall 2014
SYLLABUS

INSTRUCTOR: Khaison Duong
EMAIL: [email protected]
HOURS: MW 11:30 AM 12:45 PM
TOTAL NO. OF CONTACT HOURS: 45
CREDITS:
PREREQUISITES:
OFFICE HOURS:

COURSE DESCRIPTION:
The course will build student competence in micro computer systems. Students will learn practical use of selected Microsoft Office applications. Students will actively participate in collaborative learning.
SUMMARY OF COURSE CONTENT:
Practical use of the Windows environment. File management. MS Word. MS Excel. MS PowerPoint.
LEARNING OUTCOMES:
1      produce well formatted and use key features of MS Word documents .

2     produce spreadsheets with MS Excel and manipulate data meaningfully.

3      produce quality presentations with MS PowerPoint.

TEXTBOOK:
NONE
REQUIRED RESERVED READING:
NONE

RECOMMENDED RESERVED READING:
NONE
GRADING POLICY
-ASSESSMENT METHODS:
AssignmentGuidelinesWeight
Attendance and participation 15
Classwork and assignments4 assignments partially done as classwork25
Projects3 projects (Word, Excel, PowerPoint)30
Final exam 30

-ASSESSMENT CRITERIA:
AOutstanding A 90-100 A- 85-90
BAbove Average B+ 80-85 B 75-80 B- 70-75
CAverage C+ 65-70 C 60-65 C- 55-60
DBelow Average D 50-55
FFailure F 0-50

-ATTENDANCE REQUIREMENTS:
Attendance is mandatory as all lessons will be held in the computer laboratory and will be a combination of theory and practice. Students spending most of the class time using smart-phones or the like will be marked absent.
ACADEMIC HONESTY
As stated in the university catalog, any student who commits an act of academic dishonesty will receive a failing grade on the work in which the dishonesty occurred. In addition, acts of academic dishonesty, irrespective of the weight of the assignment, may result in the student receiving a failing grade in the course. Instances of academic dishonesty will be reported to the Dean of Academic Affairs. A student who is reported twice for academic dishonesty is subject to summary dismissal from the University. In such a case, the Academic Council will then make a recommendation to the President, who will make the final decision.
STUDENTS WITH LEARNING OR OTHER DISABILITIES
John Cabot University does not discriminate on the basis of disability or handicap. Students with approved accommodations must inform their professors at the beginning of the term. Please see the website for the complete policy.

SCHEDULE

Week

Topic

Assignment

1

 

 

Introduction

Writing and text editing

Word templates

 

2

MS Word
Home tab
Basic formatting

Page layout

3

Documents reviewing

Table of contents

Class assignment 1

4

Insert tab

Tables and graphical elements

Class assignment 2

5

References

discovery

6

MS Excel

Entering data into Cells
Formatting Cells

7

Creating multiple sheets

Class assignment 3

8

Understanding and using Formulas

9

Understanding and using Functions
Creating Charts

Class assignment 4

10

Creating Pivot Tables

Class assignment 5

11

What-if analysis

 

 

 

Logic functions and lookup

 

12

MS PowerPoint
Preparing slides
Special effects and presentation timing.

13

Presentations

14

Presentations

15

Final exam