JCU Logo

JOHN CABOT UNIVERSITY

COURSE CODE: "CS 110-4"
COURSE NAME: "Microcomputer Applications"
SEMESTER & YEAR: Fall 2015
SYLLABUS

INSTRUCTOR: Alan Bates
EMAIL: [email protected]
HOURS: TTH 7:30PM 8:45PM
TOTAL NO. OF CONTACT HOURS: 45
CREDITS:
PREREQUISITES:
OFFICE HOURS:

COURSE DESCRIPTION:
An introductory course covering the most commonly used microcomputer applications, including the Windows Operating System, word processing, and spreadsheets.
SUMMARY OF COURSE CONTENT:
Practical use of the Windows environment. File management. MS Word. MS Excel. MS PowerPoint.
LEARNING OUTCOMES:
On completion of the course students should be able to produce
1. well formatted MS Word documents making use of key features.

2. spreadsheets with MS Excel and manipulate data meaningfully.

3. 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:
AWork of this quality directly addresses the question or problem raised and provides a coherent argument displaying an extensive knowledge of relevant information or content. This type of work demonstrates the ability to critically evaluate concepts and theory and has an element of novelty and originality. There is clear evidence of a significant amount of reading beyond that required for the course.
BThis is highly competent level of performance and directly addresses the question or problem raised.There is a demonstration of some ability to critically evaluatetheory and concepts and relate them to practice. Discussions reflect the student’s own arguments and are not simply a repetition of standard lecture andreference material. The work does not suffer from any major errors or omissions and provides evidence of reading beyond the required assignments.
CThis is an acceptable level of performance and provides answers that are clear but limited, reflecting the information offered in the lectures and reference readings.
DThis level of performances demonstrates that the student lacks a coherent grasp of the material.Important information is omitted and irrelevant points included.In effect, the student has barely done enough to persuade the instructor that s/he should not fail.
FThis work fails to show any knowledge or understanding of the issues raised in the question. Most of the material in the answer is irrelevant.

-ATTENDANCE REQUIREMENTS:
ATTENDANCE REQUIREMENTS AND EXAMINATION POLICY
Attendance is mandatory as all lessons will be held in the computer laboratory and will be a combination of theory and practice. You cannot make-up a major exam (midterm or final) without the permission of the Dean’s Office. The Dean’s Office will grant such permission only when the absence was caused by a serious impediment, such as a documented illness, hospitalization or death in the immediate family (in which you must attend the funeral) or other situations of similar gravity. Absences due to other meaningful conflicts, such as job interviews, family celebrations, travel difficulties, student misunderstandings or personal convenience, will not be excused. Students who will be absent from a major exam must notify the Dean’s Office prior to that exam. Absences from class due to the observance of a religious holiday will normally be excused. Individual students who will have to miss class to observe a religious holiday should notify the instructor by the end of the Add/Drop period to make prior arrangements for making up any work that will be missed. 
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 Class assignment 1
 
Table of contents
4 Insert tab Class assignment 2
 
Tables and graphical elements
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 Class assignment 4
Creating Charts
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