JCU Logo

JOHN CABOT UNIVERSITY

COURSE CODE: "CS 110"
COURSE NAME: "Microcomputer Applications"
SEMESTER & YEAR: Summer Session I 2016
SYLLABUS

INSTRUCTOR: Marco Scaramastra
EMAIL: [email protected]
HOURS: MTWTH 11:00 AM 12:45 PM
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:
Office productivity software: advanced features of Word Processing (MS Word), Data management (MS Excel), and Presentation software (MS PowerPoint). Integration between software packages.
LEARNING OUTCOMES:
1      Ability to produce professionally formatted word documents that use tables, graphic elements, and hypertextually indexed navigation.

2      Ability to produce spreadsheets that require calculations and provide dynamic outputs.

3      To build up expertise in the use of functions and statistical analysis.

4      Ability to produce hypertextual presentations by using hyperlinks and action buttons.

5      To know how to produce professional reports integrating different office applications.
TEXTBOOK:
NONE
REQUIRED RESERVED READING:
NONE

RECOMMENDED RESERVED READING:
NONE
GRADING POLICY
-ASSESSMENT METHODS:
AssignmentGuidelinesWeight
Attendance and class participation 10%
Class assignmentsThe course is very practical and students are required to complete and save on their reserved area all exercises assigned in class on a dayly basis.10%
Midterm examThe midterm exam will require students to produce a professionally formatted word document. 20%
Final examThe final exam will require students to produce a purposeful excel worksheet containing data, formulas, and data analysis developed with the help of a set of instructions 25%
PC ProjectThe project will combine into a unified structure the microcomputer applications learnt during the course, namely Word, Excel, and PowerPoint. The guidelines for the computer project will be provided 3 weeks before the end of the course. The project deadline is the day of the final exam.35%

-ASSESSMENT CRITERIA:
AThis level of performance demostrates professional skills in the use of computer applications and the achievement of professional ability in delivering information and providing correct data analys
BThis level of performance demostrates competent skills in the use of computer applications and the achievement of competent ability in delivering information and providing correct data analysis.
CThis level of performance demostrates sufficient/acceptable skills in the use of computer applications and the achievement of a workable ability in delivering information and providing correct data analysis.
DThis level of performance demostrates just sufficient skills in the use of computer applications and the achievement of a borderline ability in delivering information and providing correct data analysis.
FThis level of performance demostrates insufficient skills in the use of computer applications and the failure in achieving a sufficient ability in delivering information and providing correct data analysis.

-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

 

Class



Topic

Assignment

1



MS Word
Mastering the essentials
Basic formatting


2



Advanced formatting
Documents reviewing

Class assignment

3



Tables and graphical elements Desktop publishing

Class assignment

4



Tables and graphical elements Desktop publishing

Class assignment

5



MS Excel
Getting Started

 


6



Entering data into Cells
Formatting Cell

Class assignment

7



Midterm exam


8



Understanding and using Formulas
Using the power of Ranges

Class assignment

9



Understanding and using Functions
Creating Embedded Charts

Class assignment

9



Creating Pivot Tables and Charts
Using Database Functions

Class assignment

10



What-if analysis

Class assignment

11



What-if analysis

Class assignment

12



MS PowerPoint
Preparing slides
Special effects and presentation timing.

Structuring and running a presentation

Class assignment

13



Project Q&A session

Project work

14



Project Q&A session

Project work

15



Final exam