Cs-001 072 Course Delivery Schedule

University College - Yanbu Preparatory Year Program COURSE DELIVERY SCHEDULE & POLICY Preparatory Computers – I (CS 001) Credit Hours – 3 [LT(1), LB(2)] Second Semester - Academic Year 2007-08 Course Instructor(s): Mirza Abrar Baig (Course Coordinator) Office: Faculty Room # 2 Telephone: 3932961 Ext. 116 Email: [email protected] Office Hours: As Displayed on office door Adnan Sualeh Office: Faculty Room # 2 Telephone: 3932961 Ext. 116 Email: [email protected] Office Hours: As Displayed on office door Lecture/Laboratory Schedule: HOUR(S) Lecture / Week 1 Lab. / Week 2

Khurram Tanvir Office: Faculty Room # 2 Telephone: 3932961 Ext. 116 Email: [email protected] Office Hours: As Displayed on office door

VENUES Class Room Computer Lab

Required Textbook(s) (TB): Handouts Reference Book(s) (TB): Timothy J. O., Leary and Linda I, Computing Essentials 2005 Complete Edition w/ Student CD (Paperback) ISBN: 0072256486, Publisher: McGraw-Hill/Irwin, Edition: 16th, Year: 2004

Course Delivery and Lecture Schedule

WEEK

1 16 – 20 February

Reference to the Chapter/Section of the Book or Other Material Given to Students

TOPICS

Introduction to computer systems • What is a computer • Information Systems • Introduction to computer software • Introduction to Computer Hardware • Types of computers Introduction to Devices • Definition • Types of I/O devices

Updated by: Mirza Abrar Baig

Homework / Assignment / Quiz /Exam etc. Date

HO1

Page 1 of 7

2 23 – 27 February

3 01 – 05 March 4 08 – 12 March

5 15 – 19 March

6 22 – 26 March

7 29March – 02 April

• Keyboard • Mouse • Monitors • Printers • Floppy Disk • Hard Disk • Optical Disk and Disk Formatting Computer Software • Definition • Types of software • System Software and its types • Computer Problems • Utility Programs • Features of Application Software

•

Typing Practice

•

Typing Practice

HO2

HO3

Assignment 1

HO3

Introduction to Microsoft Windows • Starting and closing windows • Windows Desktop Description • Moving About in Windows • Changing Computer Time • Using Menus and Commands • Using Find And Help Options Ms Windows (Continued) • Understanding Folders • Managing Files • Storage Devices • Using My Computer • Windows Explorer • Copying, Moving and Deleting Files • Creating Shortcut and Folders • Adding Program to Menus • Formatting a Floppy Disk • Windows Utilities Ms Word • Introduction • Word Screen Description • Using Word Commands • Using Office Assistant

Updated by: Mirza Abrar Baig

HO4

Assignment – 2

HO4

HO5

Lab Exam 1

Page 2 of 7

8 05 – 09 April

10 19 – 23 April

11 26 – 30 April 12 03 – 07 May

13 10– 14 May

14 17 – 21 May

Ms Word (Continued) • Correcting Spelling and Grammar Mistakes • Inserting o Numbers o Header/Footer o Page Breaks Ms Word (Continued) • Tables, Pictures and Clipart • Using Charts and Graphics • Paragraph Formatting • About Essays • About Letters and Memos Ms Power Point • Creating Power Point presentations • Modifying slides Ms Power Point • Enhancing a presentation with graphics and charts • Build and effective multimedia slide show Ms Excel • Introduction • Create a new workbook • Change the color of cell gridlines • Delete sheets • Display or hide a workbook or a worksheet • Display or hide rows or columns • Hide cell gridlines • Insert a new worksheet • Name cells in a workbook • Rename, move or copy a worksheet • Entering and editing data • Insert a symbol • Formatting data • Copying, moving, filtering and sorting data Ms Excel (Continued) • Working with data and building charts • Chart types • Chart Elements • Chart Building

Updated by: Mirza Abrar Baig

HO5

Mid Term Exam

HO5

Assignment - 3

HO6

HO6

HO7

Assignment - 4

HO7

Page 3 of 7

15 24 – 28 May

Creating Simple Numerical Applications with MS Excel Internet and web applications • What is Internet? • What are web applications? • HTML

16 31May – 04 June

REVISION

17 - 18 June

FINAL EXAMINATION

HO 7 HO 8

Lab. Exam 2

Updated by: Mirza Abrar Baig

Page 4 of 7

Practical Laboratory Schedule

WEEK

Reference to the Chapter/Section of the Book or Other Material Given to Students

TOPICS

1

Practical Demonstration of Computer System

Lab Sheet – 1

2

Using Microsoft Windows XP

Lab Sheet – 2

3

Using utility programs in MS Windows XP

Lab Sheet – 3

4

Typing practice

Lab Sheet – 4

5

Typing Practice

Lab Sheet – 4

6

Creating a basic document in MS Word and effective document formatting

Lab Sheet – 5

7

Laboratory / Project Report Submission Date

Lab Assignment 1

Lab. Exam 1

8

Structuring documents with tables

Lab Sheet – 6

9

Creating formal letters, envelopes and labels with Mail Merge

Lab Sheet – 7

Mid Term Exam

Planning and building a presentation 10

Enhancing a presentation with graphics and animation

Lab Sheet – 8

11

Building and formatting worksheets

Lab Sheet – 9

12

Working with Formulas, functions and Charts

Lab Sheet – 10

13

Internet and web applications introduction

Lab Sheet – 11

14

Lab. Exam 2

15

Revision

16

Final Term Exam

Lab Assignment 2

Instructional Tools and Evaluation Methods: Updated by: Mirza Abrar Baig

Page 5 of 7

Lectures, Class Project, Lab. Exercises, Lab. Work, Homework, Quizzes, Assignment, Lab. Quizzes, Lab. Assignments

Course Assessment and Evaluation: (Provided Later) • • • • • • •

Homework & Participation Quizzes Mid Term Examination Lab Work / Class Project Lab (Exam 1) Lab (Exam 2) Final Exam

05 % 10 % 15 % 10 % 10 % 15 % 35 %

Final Grades: An overall grade will be assigned on the following grading scale. 95 90 85 80 75 70 INTERVAL 100 <95 <90 <85 <80 <75 4.00 3.75 3.50 3.00 2.50 2.00 POINTS LETTER A+ A B+ B C+ C GRADE

65 <70 1.50

60 <65 1.00

D+

D

0 - <60 0 F

Course/Class Policies: •

Class Attendance and Absenteeism Students are required to attend all classes and lab meetings. Regular attendance in their class/laboratory sessions will be very helpful to maintain a satisfactory progress throughout their course. Attendance will be strictly enforced and evaluated according to the Student Attendance Control Criteria announced by the UCY. Any student who exceeds the maximum allowable absence limit during the course will earn him a denial notice (DN) grade. The maximum allowed limit for this course is 5 (five) which include both excused and unexcused absences.

•

Policy on Late Lab. / Project Report and Written Work Assignments are due at the beginning of the class on the date indicated in the course schedule or on the Assignment. If the due date is extended, you will be informed of this through notice board. Assignments will not be accepted after the classroom discussion occurs. Such discussion would provide an unfair advantage to those who are preparing/submitting the assignment after the fact. At the instructor's option, late assignments may be evaluated to provide feedback, but WILL NOT BE GRADED. Late assignments will receive a grade of zero.

•

Academic Integrity

Updated by: Mirza Abrar Baig

Page 6 of 7

Cheating in any form will not be tolerated and could lead to severe consequences. Academic work submitted by the students in the form of homework, assignments or project must be the result of their own effort. •

General Behavior Students must maintain a good behavior both in and outside their classes. They are required to keep their mobile phones switched off while attending their class/Laboratory sessions or writing their exams. Any student who engages in a behavior that disrupts the learning environment may face disciplinary action under the UCY code. Students must also maintain a smoke free environment in all college facilities.

•

Academic Integrity Cheating in any form will not be tolerated and could lead to severe consequences. Academic work submitted by the students in the form of homework, assignment, or a project must be the result of their own effort.

•

Make-Up Exam Policy A student who has missed an exam will be allowed to sit in a make-up exam only if he or she provides a medical report from a government hospital/clinic.

•

General Behavior Students must maintain a good behavior both in and outside their classes. They are required to keep their mobile phones switched off while attending their class/laboratory sessions or writing their exams. Any student who engages in a behavior that disrupts the learning environment may face disciplinary action under the UCY code. Students must also maintain a smoke free environment in all college facilities.

Updated by: Mirza Abrar Baig

Page 7 of 7