Institute of Business Administration: Faculty of Computer Science

INSTITUTE OF BUSINESS ADMINISTRATION: FACULTY OF COMPUTER SCIENCE

Subject: Introduction to Computer Applications

Course Code: MIS 103

Instructor’s Name: Shama Siddiqui

Room # MTL-4

Class Timings Tues/Thurs: 2:30 to 3:45 pm

Counseling Hours: Main Campus: Tues/Thurs: 1:30 – 2.15 pm

City Campus: By Appointment

Ext: 1636

Course Aim & Objectives

The Course provides a fundamental understanding of computer applications with the focus on Microsoft Office Applications (Microsoft Word, Excel, PowerPoint, Publisher and Visio). The aim is to familiarize students with the Microsoft Office environment and to enable them to perform basic, intermediate and advanced word processing, spreadsheet, and presentation operations.

Marks Distribution

2 Mid terms / 40 %
Final / 40 %
Quizzes / 15 %
Assignments / 5 %

Weeks

/ Proposed Topics
1 / Course Outline Overview
MS WORD 2013
Typing and editing Text, Generating Random Text, Formatting Document; toolbars, margins, automatic formatting, Spell check & Grammar checking, using dictionaries, Text Boxes, Objects, Formatting Paragraphs, Applying Bullets and Numbering, Borders to text, Borders to pages, Applying Drop Caps, Change Case, sorting text, Using multiple columns, Adding pictures from files or internet, Using Captions, Water marks, creating a newsletter.
2 / Creating Tables, Adding / deleting columns and rows in a table, Creating and Formatting a table, Adding and Deleting Rows, Columns and Cells, Splitting Rows, Columns and Cells, Merging Table Cells, Sorting data in tables, Creating Graphics in a document, Using Graphics Toolbar, Creating Boxes, Lines, Ovals and Grouping operations, Formatting Graphics, Create flowchart using shapes option, creating an invoice.
3 / Creating Headings, Making Table of Contents, Making Indexes, cover page, Making table of figures and list of tables, Inserting Foot Notes and End Notes, Referencing, In-text Citations, Bibliography, Citation Styles (APA, MLA & Harvard), Using Hyperlinks, Cross referencing for pictures and tables, Adding Header & Footer, Formatting Header and Footer, Adding objects in Header & Footer, Section Break, Page Break, Inserting Comments, Inserting Book Marks, Inserting Other Objects, Inserting comments, track changes, compare different versions of a file, merge different versions, restrict editing.
4 / Using Mail Merging, Creating Source Document, Creating address list, Inserting Merge Fields, Creating Letters, envelopes and Labels in Mail Merge, Sorting Records in Source Data, Filtering out recipients.
Using Filtering and Query in Mail Merge
5 / Publisher
Creating brochure, business card, and website.
Using mail merge to create letters and envelopes.
6 / FIRST MIDTERM
7 / Excel
Introduction to Spreadsheet, Moving around Spreadsheet and Menu Bar, Data Formatting, Dragging Text, Adding data by Auto Fill, Inserting & Deleting Rows, Columns, Finding & Replacing Worksheet Data, Formula in Spreadsheets, Spreadsheet Functions, Typing functions, Auto-sum Button to sum ranges, Using Functions to find Statistical & logical Information, Using Functions to find Logical Information, Using If Function (Sumif, Averageif), Using Nested Functions in IF analysis, Using D formulas (Dcount, Dsum, DcountA, Daverage).
Using Functions to find Date, Time and Math Information, Using V-lookup and H-lookup Functions, Using Conditional Formatting.
8 / Creating and Printing Excel Charts, Using Chart Design and layout Options, Creating Charts for given Equations.
9 / Sorting Data in Excel, Filtering Data using Auto Filter and advanced filter, Working With Macros, Consolidating data from multiple sheets and workbooks
10 / Making Pivot Table & pivot chart, Summarizing Data with Pivot Tables, Excel Views (Normal, Page Layout, Print Preview, Page Break)
11 / SECOND MIDTERM
12 / What-if Analysis (Goal Seek, Scenario Manager)
Power Point
Moving around Power Point and Manu bar, Moving Through a Presentation, Adding, Inserting & Deleting Slides in the Presentation, Types of Slides, Entering Slide Contents, Inserting Clip-Art Pictures, Inserting Videos, Working with Templates, & Color Schemes, Running a Slide show with options, Using Speaker notes.
13 / Working with Animation, transition and Media Clips, Using Header Footer, Using Slide Master, Using and Inserting Organization Chart, Printing and presenting a slide show, Using Slides, Using Outline, Printing Options, Creating Custom Shows, Using Slide Master Option
14 / MS Visio
Creating Gantt Charts, Flow Charts, Timing Diagrams
15 / REVISION
16 / FINAL EXAM

Page 1 of 2