Computer Courses

Course: CMP 011 – Computer Orientation I
Semester : 2011 / 2012 (111)

Course Description:
The main objective of this course is to provide students with the required skills for using computers efficiently and for using the common applications of computers which they need during their university study and future careers. It builds upon the knowledge and skills they acquired through their study in high school. The course covers the practical aspects of operating systems, online-based information retrieval, some advanced topics in word processing and a wide range of topics in manipulating data using spread sheets. It is a lab-based course. Hence, students are expected to learn by doing.

Text book:
Title:Microsoft Excel 2010 Introductory
Authored by: June Jamrich Parsons, Dan Oja, Roy Ageloff, and Patrick Carey
Published by: Course Technology, Cengage learning; International edition, 2011
ISBN: 978-0-538-47069-8

Course Objective:

Familiarize with Searching for information.
Learn to use advanced techniques of MS- Word 2010.
Learn to publish documents to the Web.
Learn to use MS-Excel 2010 as spreadsheet software.
Delivering a presentation about a pre-assigned project.

Grading Policy:

Major Exams (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.

Course Schedule:

Week no.	Topic	Hours
1 (10/9/2011)	Electronic library search & Internet Search Engines: Searching for scientific papers in electronic library. Using the Internet Search Engines.	2
2 (17/9)	Advanced topics on Word processing (M.S. Word): Create a cover page. Document themes. Quick styles. Navigate using hyperlinks, document map and thumbnails. Add footnotes. Wrap text around graphics.	2
3 (24/9) EX1	Advanced topics on Word processing (M.S. Word): Create and format tables. Add headers, footers and page numbers. Document publishing on Intranet. Enhancing published document.	2
4 (1/10)	Spread Sheets (M.S. Excel): Session 1.1 of textbook Introducing the Spread sheet concept. Excel menus. Introducing the Case Study.	2
5 (8/10) EX2	Spread Sheets (M.S. Excel): Session 1.2 of textbook Creating and editing a worksheet. Creating an Order Report	2
6 (15/10)	Spread Sheets (M.S. Excel): Sessions 2.1 of textbook Formatting a worksheet.	2
7 (22/10)	Spread Sheets (M.S. Excel): Sessions 2.2 of textbook Designing a Financial Report	2
8 (29/10) M1	Revision and conducting the Major exam
1/11 – 9/11	Hajj Vacation
9 (12/11)	Spread Sheets (M.S. Excel): Session 3.1 of textbook Working with Formulas and Functions.	2
10 (19/11) EX3	Spread Sheets (M.S. Excel):Session 3.2 of textbook Developing a Family Budget	2
11 (26/11)	Spread Sheets (M.S. Excel): Session 4.1 of textbook Charting Worksheet Data. Charting Financial Data	2
12 (3/12)	Spread Sheets (M.S. Excel): Session 4.2 of textbook Charting Worksheet Data. Charting Financial Data (Cont.)	2
13 (10/12) M2	Spread Sheets (M.S. Excel): Sessions 5.1 & 5.2 of textbook Working with tables. Sorting and Filtering data Tracking Museum Art Objects	2
14 (17/12)	Spread Sheets (M.S. Excel): Spread Sheets (M.S. Excel): Session 7.1 of textbook Using Advanced Functions.	2
15 (24/12) EX4	Spread Sheets (M.S. Excel): Session 7.3 of textbook Conditional Formatting.	2
16 (31/12)	Revision	1
Note:: M: a Major exam will take place on Saturday of this week. EX: An Exercise at any day during this week.

Important Dates:
•Major one Exam Saturday 29 October 2011 = 2 Dhul Hejjah 1432 H (M.S. Excel Chaps 1,2 )

•Major two Exam Saturday 10 December 2011 = 15 Muharram 1433 H (M.S. Excel Chaps 3,4 )
• FINAL Exam From 7 Jan to 17 Jan 2012 = 13 Safar to 23 Safar 1433 (M.S. Excel)

For more details>
Email: Hassan_taher@psu.edu.sa

Office: A237
Tel: 01-4948478

Course: CMP 012 – Computer Orientation II
Second Semester: 2011 / 2012 (111)

Course Discription:
This course complements the CMP001 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.

Text book:
Title: Microsoft Access 2010 Introductory
Authored by: 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-PowerPoint 2010.
Learn to publish presentations to the Web.
Learn to use MS-Access 2010 as a Database Management System Tool.
Delivering a project among a team to design, implement and utilize a Database.

Grading Policy:

Major Exams (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.

Course Schedule:

Week no.	Topic	Hours
1 (25/9/2010)	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	2
1/ 11 – 9 / 11	Midterm 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
Note: Ex=Exercise, M=Major Exam

Important Dates:

•Major one Exam Saturday 29 October 2011 = 2 Dhul Hejjah 1432 H (M.S. Access Tutorials 1,2 )
•Major two Exam Saturday 10 December 2011 = 15 Muharram 1433 H (M.S. Access Tutorials 3,4 )

• FINAL Exam From 7 Jan to 17 Jan 2012 = 13 Safar to 23 Safar 1433 H (M.S. Access)

For more details>
Email: Hassan_taher@psu.edu.sa

Office: A237
Tel: 01-4948478