1 / 8

Computer Application in Business

Computer Application in Business. M. Com Part 1, Central College, Lahore Instructor: Shahid Imran. Computer Application in Business. Course Outline Part A 50 Marks Computer Concepts Word Processing Spread Sheet Database Management System Part B 50 Marks Practical Demonstration.

lucy-fulton
Download Presentation

Computer Application in Business

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Computer Application in Business M. Com Part 1, Central College, Lahore Instructor: Shahid Imran

  2. Computer Application in Business • Course Outline • Part A 50 Marks • Computer Concepts • Word Processing • Spread Sheet • Database Management System • Part B 50 Marks • Practical Demonstration

  3. Computer Application in Business • Paper Pattern • 1 Objective MCQs type question • 4-5 other questions • 2-3 questions from Computer Concepts • 1 question from word processing • 1 question from spread sheets • 1 question from database management system

  4. Computer Concepts • Introduction to Computer Sciences • Characteristic, use and history of Computer • Types, Classification and Generation of Computer • Computer Parts, input devices, output devices and storage devices • Computer Memory, CPU, Buses, Ports • Computer Software, Operating System, Computer Applications and Languages • Computer Networks, Internet, Emails, Data Communication • Computer Crimes, Computer Viruses • Operating and Managing MS-Windows

  5. Word Processors • Use of MS-Word, Inserting, Editing and Formatting data • Page setup, Printing documents • Using Hyperlinks, Tabs, Footnotes, Columns • Working with Tables, Objects, Mail Merge, Macros • Practical Assignments

  6. Spread Sheet • Use of MS-Excel, Inserting, Editing and Formatting data • Using Formulas, Basic, statistical, financial, logical, date & time, lookup and database functions, • Cell references, Charts, Page setup and Printing • Working with filters, validation, sorting, Auditing features • Using Pivot tables, Goal seeks and subtotals • Practical Assignments

  7. Database Management System • DBMS, RDBMS, Working with MS-Access, data types • Creating Tables, Inserting and Editing data • Relational Database, Primary key and Foreign Keys • Creating Queries of different types • Creating, modifying and formatting forms • Creating, modifying and formatting reports • Exchanging data with other tools • Practical Assignments

More Related