S13_MIS103_Intro_to_Comp_Applications

= = =MIS103: Introduction to Computer Applications=

Program:
BBA

Semester:
Spring 2013

Instructor:
Shama Siddiqui

**Course Lead:**
Maheen Ghauri

**Credit Hours:**
3

Prerequisite(s):
No Prerequisites

Course Description:
This course provides a fundamental understanding of MS office Applications to the students.

Course Objectives:
The Course provides a fundamental understanding of computer applications with the course focus on the Microsoft Office Applications (Microsoft Word, Publisher, Excel, PowerPoint, and Visio). Some fundamentals such as software, hardware, networks, internet and emails will be discussed. In addition, the students will be taught to create simple websites using Google Sites and Publisher. The fundamental aim of the course is to familiarize students with the Microsoft Office environment.

Books:
No Books recommended. Any online office manual or tutorial can be used.

Grading Policy:

 * 2 Mid terms || 40 % ||
 * Final || 40 % ||
 * Quizzes || 15 % ||
 * Assignments || 5 % ||

Uploaded Reference Course Outline:
|| ||
 * ==**Topics Covered in the Course **== ||
 * S.No || Date of the lecture || Topic of Lecture || Additional Reference Material ||
 * 1 || 20-02-13 || Paragraph Allignments, Columns. || [[file:Exercise 1.docx]][[file:Exercises 2.docx]] ||
 * 2 || 27-02-13 || Table of Contents, Index || [[file:Exercise 3.docx]] ||
 * 3 || 04-03-2013 || Headers and Footers || [[file:Exercise 4.docx]] ||
 * 4 || 06-03-2013 || Working with Shapes || [[file:Exercise 5.docx]] ||
 * 5 || 20-03-2013 || Working with Tables || [[file:Exercise 6.docx]] ||
 * 6 || 20-03-2013 || Creating and formatting a real document || [[file:Exercise 7.docx]] ||
 * 7 || 25-03-2013 || Mail-Merge || [[file:Exercise 8.docx]] ||
 * 8 || 01-04-2013 || Creating a Salary Sheet || [[file:Excel Exercise 1.docx]] ||
 * 9 || 03-04-13 || Creating a Marks Sheet || [[file:Excel exercise 2.docx]] ||
 * 10 || 08-04-13 || Vlookup and Hlookup || [[file:Excel exercise 3.docx]] ||
 * 11 ||  ||   || [[file:Excel Exercise 4.docx]] ||
 * 12 ||  ||   || [[file:Excel Exercise 5.docx]] ||
 * 13 || 10-04-2013 || D-Formulas || [[file:Excel Exercise 6.docx]] ||
 * 14 ||  ||   || [[file:Formula Practice Sheet1.xlsx]] ||
 * 15 ||  ||   || [[file:MacroPractice.xlsx]] ||
 * 16 || 15-04-2013 || Graphs || [[file:Excel Exercise 7.docx]] ||
 * 17 || 17-04-2013 || Quiz 2 Data Files || [[file:Fruits.xlsx]]
 * 18 || 29-04-2013 || Filters || [[file:EXCEL EXERCISE 8.docx]] ||
 * 19 || 29-04-2013 || Sorting || [[file:Excel Exercise 9.docx]] ||
 * 20 || 06-05-2013 || Pivot Tables || [[file:Excel Exercise 10.docx]] ||
 * 21 ||  ||   || [[file:Product.xlsx]] ||
 * 22 ||  ||   || [[file:Customer.xlsx]] ||
 * 23 ||  ||   || [[file:Order.xlsx]] ||
 * 24 || 08-05-2013 || Quiz 3 || [[file:quiz_3.docx]] ||
 * 25 ||  ||   || [[file:Salesperson.xlsx]] ||
 * 26 ||  ||   || [[file:Magazines.xlsx]] ||
 * 27 || 13-05-2013 || Letter heads, brochures, etc || [[file:Publisher Exercise.docx]] ||
 * 28 || 20-05-2013 || Practising PowerPoint || [[file:PowerPoint Exercise.pdf]]
 * 29 || 22-05-2013 || Quiz 4 || [[file:quiz 4.pptx]] ||
 * 30 || 27-05-2013 || Practice with Word || [[file:Practice1.pdf]] ||
 * 31 || 29-05-2013 || Practice with Excel || [[file:Practice2.xlsx]] ||

Assignments
1. Create the document using MS Word, and submit both in soft and hard copies. email at shamasiddiqui@iba.edu.pk. submission deadline: 17th March, 12.00 pm. points: 4



2. Submission due: 20th May 2013. points: 3



3. Submission due: 22nd May 2013. points: 3



4. Portfolio Submission points: 5