Course / CMP012 – Computer Orientation II
Semester / 111 Year 2011/2012
Credits / 1 (0,2,0)
Prerequisite / CMP011
Course Description / This course complements the CMP011 course. Its main objective is to provide students with the advanced computer skills which they need to use during their university study and future careers. The course introduces the computer applications and the practical aspects on how to protect data and fundamental troubleshooting tasks. The course covers some advanced topics in Presentation tools and introduces database concepts and how to use Database Management System tools. It is a lab-based course. Hence, students are expected to learn by doing.
Textbook / Title: Microsoft Access 2010 Introductory
Authoredby: Joseph J. Adamski
Published by: Course Technology, Cengage learning, 2011
ISBN: 978-0-538-47097-1
Course Objective /
  • Learn the practical computer basic skills: applications, installation and troubleshooting.
  • Learn to use advanced techniques of MS-PowerPoint2010.
  • Learn to publish presentations to the Web.
  • Learn to use MS-Access2010 as a Database Management System Tool.
  • Delivering a project among a team to design, implement and utilize a Database.

Grading Policy / Major Exam (Practical) / 30%
Attendance& Participation / 10%
Exercises / 20%
Final Exam / 40%
Attendance Policy /
  • Attendance is very important (getting 8 absences or more means DN).
  • No Medical or Social excuses will be accepted.

Important Dates
Major Exams /

M1: Saturday 10 December 2011 = 15 Muharram 1433 H

/ M.S. Access
Tutorials 1,2

M2: Saturday 29 October 2011 = 2 Dhul Hejjah 1432 H

/ M.S. Access
Tutorials3,4
FINAL Exam / From 7Jan to 17Jan 2012 = 13 Safar to 23Safar 1433 / M.S. Access
Course Schedule
WEEK No / Topic / Hours
1 (10/9/2011) /

Basic Skills:

Basic computer installation. Basic computer troubleshooting.

Introduction to Computer applications.

/ 2
2 (17/9) / Advanced topics on Presentations (M.S. PowerPoint):
Inserting graphic objects, text boxes, changing the presentation design, Master slides, adding animation effects and animated graphics. / 2
3 (24/9) EX1 / Advanced topics on Presentations (M.S. PowerPoint):
Controlling the slide show, speaker notes, control printing, charts, timing, custom shows, hyperlinks and publishing presentations on Intranet. / 2
4 (1/10) / Introduction to Databases (M.S. Access):
Creating a database:Tutorial 1 of Textbook (Session 1.1)
Creating a database to contain Customer, Contract, and Invoice data. / 2
5 (8/10) EX2 / Creating a database:Tutorial 1 of Textbook (Session 1.2)
Creating a database to contain Customer, Contract, and Invoice data. / 2
6 (15/10) / Building a Databases and Defining Table Relationships: Tutorial 2 of Textbook (Session 2.1)
Creating the Invoice and Customer tables. / 2
7 (22/10) / Building a Databases and Defining Table Relationships: Tutorial 2 of Textbook (Session 2.2)
Creating the Invoice and Customer tables. / 2
8 (29/10) M1 / Revision and conducting the Major exam / 1
1/ 11 – 9 / 11 / Hajj Vacation
9 (12/11) / Maintaining and Querying a Database: Tutorial 3 of Textbook (Session 3.1)
Updating and Retrieving Information about Customers, Contracts &Invoices. / 2
10 (19/11)EX3 / Maintaining and Querying a Database: Tutorial 3 of Textbook (Session 3.2)
Updating and Retrieving Information about Customers, Contracts &Invoices. / 2
11 (26/11) / Creating Forms and Reports: Tutorial 4 of Textbook (Session 4.1)
Using Forms and Reports to display Customer and Contract data. / 2
12 (3/12) / Creating Forms and Reports: Tutorial 4 of Textbook (Session 4.2)
Using Forms and Reports to display Customer and Contract data. / 2
13 (10/12) M2 / Advanced Queries: Tutorial 5 of Textbook (Session 5.1)
Pattern match and Parameter queries, logical operators, conditional values. / 2
14 (17/12) / Enhancing Table design: Tutorial 5 of Textbook (Session 5.2)
Crosstab, Find Duplicates, Find Unmatched Queries. Top values Query / 2
15 (24/12)EX4 / Enhancing Table design: Tutorial 5 of Textbook (Session 5.3)
Lookup fields, Input masks, Validation rules and Memo fields. / 2
16 (31/12) / Revision and Global Exercises / 1
  • M: a Major exam will take place on Saturday/ Sunday of this week.
  • EX: An Exercise at any day during this week.

Teacher
Email
Office / Telephone
Lab
Times
Director / Hassan Taher Daoud / Office: A 237 / Telephone: 4948478

1