Estb. 1882

University of the Punjab

Computer Application in Business

1. INTRODUCTION TO COMPUTER SYSTEM

· Computer
· Characteristics of Computers.
· History of Computer
· Generation of Computer
· Types of Computer
· Classification of Digital Computer
· Computer Hardware and Software
· Basic Architecture of Computer System
· Microprocessor
· Types of Memory
· Input/Output Devices
· Computer Software
· Operating Systems or Operating Software
· Programming Languages

2. DATA COMMUNICATION, NETWORKS AND DATA PROCESSING

· Network
· Types of Network
· Analog and Digital Transmission
· Data Processing
· Data Processing Cycle
· Data Processing as a Business Need

3. WINDOWS 2000 PROFESSIONAL

· Windows 2000 Features
· What's New in Windows 2000 Professional?
· Windows 2000 Desktop.
· Start Menu
· Managing Windows 2000 Professional
· Control Panel
· Control Panel Icons
· Desktop Properties
· Date and Time
· Printing
· Task Brand Start Menu
· Managing Files And Folders
· Windows Explorer
· Accessing Windows Explorer
· Opening Items
· Copying and Moving Files
· Delete Files and Folders
· Controlling the View Detail Level
· Sorting the File Listing
· Controlling the Tool Bars
· Customizing the Tool Bars
· Using the History Bar
· Windows Explorer Keyboard Shortcuts . Exercise

4. MICROSOFT WORD 2000

· Main Features of Microsoft Word 2000 . Starting Microsoft Word 2000
· Navigation
· Selection
· Copying.
· Moving.
· New File.
· Undo and Redo
· Help
· Checking Spelling.
· Producing Outputs.
· Printing.
· Formatting Word Document
· Character Formatting or Fonts
· Paragraph Formatting.
· Borders, Lines and Shading.
· Bullets and Numbering.
· Columns.
· Drop Cap.
· Styles.
· Tabs.
· Tables
· Creating Tables
· Auto format.
· Columns.
· Rows.
· Typing and Moving Within a Table
· Spacing
· Converting.

5. MICROSOFT EXCEL 2000

· Using Microsoft Excel 2000
· Main Features of Microsoft Excel 2000 . Working with Excel
· Exiting Excel
· Help
· Naming Cells and Ranges.
· Navigating in a Worksheet
· Selection.
· Undo and Redo
· Editing Workbooks
· Column Width
· Row Height.
· Copying.
· Deleting.
· Editing Data.
· Finding Worksheet Data.
· Hiding.
· Inserting and Deleting.
· Inserting Worksheets
· Naming Worksheets
· Pasting
· Running a Spell Check
· Formatting
· Numbers.
· Alignment
· Fonts
· Borders
· Pattern
· Protection
· Producing Outputs
· Page Setup
· Previewing a Workbook
· Printing
· Windows
· Working With Files And Folders
· Workbooks

6. FORMULAE, FUNCTIONS, CHARTS AND DATA ANALYSIS

· Formulae
· Displaying Formulae
· Entering Functions
· Sub Total
· Multiple Summary Functions
· Auditing
· Charts
· Creating Charts with the help of Chart Wizard
· Changing Chart Types
· Saving Charts
· Aostoipes
· Data Analysis
· Autofilter
· Databases
· Data Forms
· Sorting Database or Excel's Worksheet Data
· Pivot Tables
· Solver
· Goal Seek

7. MICROSOFT POWERPOINT 2000

· Main Features of Microsoft PowerPoint 2000
· Starting Microsoft PowerPoint 2000
· Creating a Presentation
· Editing or Formatting a Text Box
· Views
· Formatting And Slide Show
· Applying Design to you Presentation' s Slides
· Changing a Slide Background
· Picking a new Color and Style for Background
· Changing Slide Layout
· Adding Picture to a Slide
· Transitions
· Visual Transitions
· Text Transitions
· Slide Show
· Testing Slide Show

8. INTERNET AND EMAILS

· Services of Internet.
· Advantages and Disadvantages of Internet
· Website Terminology
· The Guts of the Web
· Terms for the Tools
· What is Web Server?
· Microsoft Internet Explorer and Web Browsers
· Saving Information from a Web Page
· Searching the Internet
· Email using Internet Free Web Sites
· What is Free Mail?
· Free Mail using Hotmail
· Why Sign up to Free Mail
Credit hours/ Marks:- 3

Reference Books

Download Course-Outline