MIS103_Introduction_to_Computer_Applications

= = =Reference Course Outline for:** __ MIS103: Introduction to Computer Applications __ **=

**Credit Hours:**
3

**Course Lead:**
Maheen Ghauri

Course Description:
This course is designed for business students who will soon become professionals in the fast changing business world of today. The goal is to help business students learn how to use computer applications and technologies to improve day-to-day operations, revitalize business processes, and improve business decision making. This course would help them in increasing their efficiency and productivity in both their educational and professional lives. It introduces the entire spectrum of different types of computer applications, providing a fundamental understanding of different types of software being used today. The course focus will be on the basic and advanced features of Microsoft Office Applications (MS Word, MS Excel, MS PowerPoint, MS Access, and MS FrontPage). An introduction to web designing, Outlook Express, and using Adobe applications will be given as well. Students will also be covering the basic concepts of Computer Hardware, Software, Operating Systems, Telecommunications, Databases, as well as the use of the Internet and its essential role in providing a platform for business, commerce, and collaboration processes in today’s networked enterprises and global markets. This is a complete lab based course where students will learn these applications by working on class assignments in the lab.

Prerequisite(s):
This is a core course for BBA students. There is no prerequisite for this course; however students should have basic computer know-how.

Course Objectives:

 * To introduce students to the basic concepts of information technology and systems, and the business uses of the Internet.
 * To develop an understanding of how various applications and technologies can be used by individuals and businesses to improve operations, processes, and decision-making.
 * To practice and apply different Microsoft applications being used by individuals and businesses today, by going through various exercises in and outside the classroom.

Typical Semester in which this course is offered:
Fall

Programs in which course is offered:
BBA

Outline:
2 || **MS WORD 2007 **
 * **WEEK ** ||  **TOPICS **  ||
 * 1 || * Introduction to the basics of IT/IS;
 * Computer Peripherals ; Categories of I/O Devices
 * Types of Software; Difference between system & application software; overview of types
 * Functions of the Operating System
 * What is telecommunications; Telecommunication Hardware and Software being used today
 * Storing data in flat files vs storing data in databases
 * What are databases; Overview of different types of DBMS;
 * The Internet and its business uses / benefits ||

3 || * Inserting Text Boxes; Text Box Features 4 || * Creating Tables 5 || * Creating Hyperlinks and Bookmarks
 * Editing and Formatting Document
 * Spell Check & Grammar, Dictionaries, Thesaurus, Word Count
 * Toolbars, margins, orientation, line spacing, indentation, justification, page breaks
 * Finding & Replacing text
 * Inserting Header/Footer, Page Numbers, date & Time
 * Word Art
 * Watermarks
 * Managing Files & Printing Documents ||
 * Inserting images/cliparts
 * Text Wrapping
 * Creating a Cover Page
 * Page Borders
 * Creating headings, sub headings
 * Table of contents
 * Splitting the page into columns
 * Referencing Styles and Bibliography ||
 * Adding / deleting columns or rows in a table
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Resizing Rows/Columns
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Table Properties & Features
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Cell Alignment
 * Creating and Formatting Shapes
 * Creating and Formatting SmartArt ||
 * How they are used
 * Mail Merging
 * Creating and Editing Recipient List
 * Creating Labels in Mail Merge
 * Creating Envelopes in Mail Merge ||
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;"> 6 || **MS PUBLISHER 2007**

<span style="display: block; font-family: Calibri,sans-serif; font-size: 11pt; text-align: center;">7 || **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">MS EXCEL 2007 **
 * What is Publishing?
 * Creating Layouts
 * Editing Layouts
 * Using Templates
 * Designing Websites
 * //<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Using “Googlesites” to create a Website //** ||

<span style="display: block; font-family: Calibri,sans-serif; font-size: 11pt; text-align: center;">8 || * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Formulas Continued <span style="display: block; font-family: Calibri,sans-serif; font-size: 11pt; text-align: center;">9 || * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">If-Then-Else statements and formulas <span style="display: block; font-family: Calibri,sans-serif; font-size: 11pt; text-align: center;">10 || * **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Graphs ** <span style="display: block; font-family: Calibri,sans-serif; font-size: 11pt; text-align: center;">11 || **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">MS POWERPOINT 2007 **
 * What are Spreadsheets
 * Selecting and Resizing Columns & Rows
 * **Data Formatting**
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Number Formats ( $, %,, etc); Increasing/Decreasing Decimals
 * Data Alignment, Styles, Borders, Fill etc
 * Sorting & Filtering Data
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Basic Operators ( +, -, *, /, brackets)
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Cell References
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Selecting and Printing Data
 * **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Creating Formulas **
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Cell Referencing from another worksheet
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Various Simple and Complex Formula Examples ||
 * **//<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Excel Functions //**
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Using built-in functions
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Typing Functions
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Maths, Statistical, Logical functions, etc ||
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Nesting of If-Then-Else Formulas
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Examples ||
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Creating Graphs (Line, Column, Bar, Pie, Scatter)
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">When and where each graph is used (application)
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Creating legends, axis labels/titles, and chart titles
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Creating 4 quadrant graphs (when values are negative) ||
 * What are slides?
 * Inserting and deleting slides
 * Adding, Inserting & Deleting Slides in the Presentation
 * Slide Designs and themes
 * Inserting Images, Charts, and Videos
 * Using Hyperlinks and Buttons
 * Using Templates & Animations
 * Running a Slideshow; Custom Slide Show; Slide Sorter;
 * Printing a presentation; options ||
 * <span style="display: block; font-family: Calibri,sans-serif; font-size: 11pt; text-align: center;">12 || **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">MS VISIO 2007 **


 * Flow Charts
 * Organizational Charts
 * Complex Diagrams
 * Blueprints ||
 * <span style="display: block; font-family: Calibri,sans-serif; font-size: 11pt; text-align: center;">13 || **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Project Submission **
 * //Groups Presentations//
 * //Report Submission// ||
 * <span style="display: block; font-family: Calibri,sans-serif; font-size: 11pt; text-align: center;">14 || **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">REVISION ** ||

Lab Assignment & Project:
<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Class and home hands-on assignments will be given on a regular basis. Class assignments would be due at the end of the class, and home assignments would be submitted on the respective dates given by the instructor. **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Note: ** <span style="font-family: Calibri,sans-serif; font-size: 11pt;">All assignments are to be hands-on, and soft-copies have to be brought on a USB, or emailed to the instructor by the due date. Handwritten assignments **//will not be accepted.//** Moreover, **//no late assignments//** will be accepted.

Books:
<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Any Microsoft Office XP reference book available in all book stores, as well as the IBA Library.

Web Resources:
<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Any MS training website:

<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Egs: <span style="font-family: Calibri,sans-serif; font-size: 11pt;">[] <span style="font-family: Calibri,sans-serif; font-size: 11pt;">[]

Grading Policy:

 * **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Component ** ||  **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">Frequency **  ||  **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">% **  ||
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Final Exam (Hands-on) * || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">1 || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">30 ||
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Term Exams (Hands-on) * || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">2 || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">30 (15 each) ||
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Term Project || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">1 || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">15 ||
 * * //Final Project// ||  || //<span style="font-family: Calibri,sans-serif; font-size: 11pt;">10 // ||
 * * //Summary report// ||  || //<span style="font-family: Calibri,sans-serif; font-size: 11pt;">5 // ||
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Assignments ||   || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">10 ||
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Quizzes || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">n-1 || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">5 ||
 * <span style="font-family: Calibri,sans-serif; font-size: 11pt;">Class Participation ||  || <span style="font-family: Calibri,sans-serif; font-size: 11pt;">10 ||
 * || **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">TOTAL ** || **<span style="font-family: Calibri,sans-serif; font-size: 11pt;">100% ** ||

Class Time Spent On (In Credit Hours):
Theory: 0.5 Lab-based Activity: 2.5