PSU - OYP-Computers

PSU > Orientation Year Program (OYP) - Computers Program

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.

Major Exams (Practical) : 30%
Attendance & Participation : 10%
Exercises : 20%
Final Exam : 40%

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 2

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.

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

Course Description:
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

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.

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) 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