Syllabus

Course Description:

The lab portion of this course covers basic aspects of Microsoft Office (particularly Excel and Access), with an overview of how to create a simple webpage with the help of useful web design software. Towards the end of the course, we will elaborate more on how to surf the Internet with the help of different search engines, with an emphasis on useful tips and tools.

Course Objectives:

By the end of the course, you should be able to:

1. Use Excel to execute certain functions.
2. Create forms and reports within Access.
3. Design simple Web page and link it to the Internet.
4. Search the Internet wisely and sufficiently.

Software:

We will use MS Office 2010 for the first half of the semester. Later in the semester, we will use Dreamweaver 8 to complete the assigned project.

 Project:

There will be a small project at the end of the tenth week of the semester. It is an individual project, so each student should submit her own work. The project requires you to download a free trial version of Dreamweaver 8 to build your own website. The website should cover ANY subject that interests you the most. You will present your designed website in front of the class on the submission date. All the project details will be discussed before the project due date.

Grading:

2 Quizzes	Excel and Access	6% (3% each)
1 Small project	Dreamweaver	5%
1 Assignment	Using the Internet	3%
Participation, Attendance, In-lab work		1%

Notes:

• You are expected to attend every lab.
• You are responsible for the materials presented or assigned, whether you attended or not. 
• Due date is the next class from the assigned date. 
• Assignments will not be accepted after the due date.
• There will NOT be any make up quiz nor a markup.

Staying in Touch:

Ask general questions in lab. For individual problems, please talk to me just before or after class or during my office hours. Alternatively, slide a note under my office door or send me an e-mail.

Proposed Course Outline

	Date	Topic	Assignments
1	Weekof 21/3/1434	Course introduction
2	Week of 28/3/1434	Excel
3	Week of 6/4/1434	Excel
4	Week of 13/4/1434	Excel	Quiz 1
5	Week of 20/4/1434	Access
6	Week of 27/4/1434	Access
7	Week of 4/5/1434	Access	Quiz 2
8	Week of 11/5/1434	Mid-Semester Break
9	Week of 18/5/1434	Web design
10	Week of 25/5/1434	Web design
11	Week of 3/6/1434	Web design	Project
12	Week of 10/6/1434	Internet
13	Week of 17/6/1434	Internet
14	Week of 24/6/1434	Internet	Homework Due Date

Helpful links:

1. Microsoft Office 2010: Introductory (Shelly Cashman) by Gary B. Shelly and Misty E. Vermaat. ISBN-10: 1439078386
2. Office 2010 All-in-One for Dummies by Peter Weverka. ISBN: 978-0-470-49748-7
3. Microsoft® Office Professional 2010 Step by Step by Joan Lambert, Joyce Cox, Curtis D. Frye. ISBN-10: 0735626960
4. http://office.microsoft.com/en-us/support/training-FX101782702.aspx
5. http://www.pitt.edu/~poole/Office2010frame.html
6. http://www.learningcomputer.com/index.html