JCU Logo
JOHN CABOT UNIVERSITY

COURSE CODE: "CS 110-1"
COURSE NAME: "Microcomputer Applications"
SEMESTER & YEAR: Spring Semester 2012
SYLLABUS

INSTRUCTOR: Sassun Raffaele
EMAIL: [email protected]
 HOURS: MW 13:00-14:15
TOTAL NO. OF CONTACT HOURS: 45
CREDITS:
PREREQUISITES:
OFFICE HOURS:
COURSE DESCRIPTION:
This course is intended to give the student the knowledge to use microcomputer systems in their most commonly used applications.
SUMMARY OF COURSE CONTENT:
  The elements of Microcomputer Systems, what they can and cannot do, Management Information Systems, History of Computers. Microcomputer Systems architecture and hardware. Operating Systems: Windows XP. Windows Environment, Usage of mouse, Applications Setup, Editing files, MS-DOS Commands, Batch Files. Word Processing: basic and advanced commands. Spreadsheets: Excel, Business Graphics, Macro Programming. Integration between software packages.Hardware and  Software evaluation.
LEARNING OUTCOMES:

At the end of the course the student will be able to:

Identify and use appropriate software for word-processing and spreadsheet applications.

Feel comfortable using the basic features of Windows Operating System and of the Office application packages.

Define, design and program a small computerized Information System.

Choose appropriate hardware and use different equipment.
TEXTBOOK:
NONE
REQUIRED RESERVED READING:
NONE

RECOMMENDED RESERVED READING:
NONE
GRADING POLICY
-ASSESSMENT METHODS:
AssignmentGuidelinesWeight
AttendanceAttendance in class10
Quizzes4 to 5 quizzes during the course40
ProjectTeam Project to be completed by the end of course20
FinalFinal exam30

-ASSESSMENT CRITERIA:

Outstanding A                                95-100

A-                                                 90-95

Above Average B+                                   85-90

B                                                                80-85

B-                                                  75-80

Average C+                                     70-75

C                                                   65-70

C-                                                 60-65

Below Average D                              55-60

Failure F                                           0-55
-ATTENDANCE REQUIREMENTS:
Attendance is compulsory. This because all the lessons will be held in the computer laboratory and will be a combination of theory and practice. Students that will fail to attend at least 8 lessons out of 10 will get an "F" grade.
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

The course is divided in fourteen units.

  1. Introduction, History, Hardware, Operating systems.
  2. Windows XP environment: Icons, Group programs, Mouse features, My Computer, Commands related to hardware. Driver settings. Usage of Control Panel.
  3. Mastering Windows XP. Usage of Explorer. Paint. Notepad. Calculator
  4. Subdirectories: MD, CD, RD. Disk commands: DIR, COPY, FORMAT, DISKCOPY, DEL. System configuration.
  5. Introduction to Word Processing. Creating and editing text.
  6. Word Processing: editing, saving/recalling, blocks, copy/remove, find/replace, printing. Checking document.
  7. Formatting text. Style settings. Templates.
  8. More on printing and printers, control codes. Advanced features in WP: Tables and Graphics.
  9. Spreadsheet: Introduction. The screen. Creating and Editing cells. Titles. Making calculations. Constants and Variables. Block commands.
  10. Formulas. Absolute and Relative Cell addressing. IF, $, AND, OR
  11. Charts. Cell Reference Functions. SUM, COUNT, COUNTA, MIN, MAX, AVERAGE, SUMIF, COUNTIF
  12. Lookup Tables. VLOOKUP, HLOOKUP, COUNTBLANK
  13. String Functions. CONCATENATE, LEFT, RIGHT, MID, FIND, REPLACE, LEN,  LOWER, UPPER, PROPER, REPT, TRIM, VALUE. Logical Functions. INDIRECT, ISERROR, ISNA
  14. Database elements. Database functions. Statistic Functions. Macros. Importing and Exporting Data. DSUM, DCOUNT, DMIN, DMAX, DAVERAGE, SUBTOTAL