Saurabh Computer Applications in Management

JK Business School: 

JK Business School Computers in Management Presentation by : Saurabh Mittal (Faculty IT) PGDBM 2 Years First Semester 2103 PGDBM 3 Years Second Semester

Course Objectives: 

Course Objectives This course focuses on the key elements and basic concepts of Computers and Information technology. It will surely promote administrative and management excellence in the business. IT will be used to promote greater efficiency in administration, management & communication, thereby supporting more effective business environment. The course will provide students with a systematic framework for understanding Information Technology and its application in the business world.

Course Contents: 

Course Contents Basic Components of Computers Systems Computer Applications Computer Organization Operating Systems DOS: Disk Operating System Graphical User Interface Microsoft Office Database Management Systems Relational Database Management Systems Computer Networks Internet Multimedia

Chapter 1 Basic Components of Computers Systems : 

Chapter 1 Basic Components of Computers Systems Computer Applications in Business, Components of Computer System, Central Processing Unit, Digital Signal Processor (DSP) The Main Memory Unit, Random Access Memory, Auxiliary Storage Memory Operating Systems, Interpreter or Translator, Resource manager Hardware, Software System Software, Application Software Chapter 2 Computer Applications

Slide 6: 

Chapter 3 Computer Organization Input Devices Output Devices Chapter 4 Operating Systems History and Evolution, A Brief History of MS-DOS, A Brief History of Windows System

Chapter 5 DOS: Disk Operating System : 

Chapter 5 DOS: Disk Operating System DOS Drives, Wild Cards, Creating, Renaming, Viewing, Editing and Deleting a File. Various Commands, Printing on Screen, Redirection Options Disk Commands, The Config.sys File, The AUTOEXEC.BAT File Commands in DOS, DOS Utilities Collection Windows - A Graphical User Interface (GUI) Main and Accessories Program Group Multitasking Chapter- 6 Graphical User Interface

Chapter- 7 Microsoft Office : 

Chapter- 7 Microsoft Office MS Word Auto Text , Spelling and Grammar, Thesaurus, inserting Images, Auto Shapes and Word Art , Working with Clipart MS Excel Editing and Formatting a Workbook , Conditional Formatting, Charts, Page Setup, Printing, Formulas and Functions, Linking Workbook and Worksheet, How to Create Links between Workbooks, Macros MS-PowerPoint Inserting Charts on Slide, Table Drawing Tools, Table Resizing, Inserting Pictures Onto Slides, Presenting your Presentation, Running a Slide Show/Screen Show

Chapter-8 Database Management Systems: 

Fields, Database Features Advantages of the DBMS Approach File Structures Logical Database Design Relational Database Systems, FoxPro Menus and Pop- ups Chapter-8 Database Management Systems

Chapter – 9 Relational Database Management Systems : 

Chapter – 9 Relational Database Management Systems Relational Model Concepts Characteristics of Relation Relational Constraints and Relational Database Schemas Operations on Relations The Relational Algebra RDBMS Languages Introduction to MS Access Creating, Closing & Saving Database, Working with Queries Working with Reports

Chapter-10 Computer Networks : 

Chapter-10 Computer Networks Local Area Networks (LANs), Metropolitan Area Networks (MANs) Wide Area Networks (WANs) Routing, Network Topology, Transmission Technology, Protocols, Open Systems Inter Connection Reference Model Financial Accounting and Inventory Control Packages Accounting Information System (AIS)

Chapter-11 Internet : 

Chapter-11 Internet Network, Client and Servers, Host and Terminals, TCP/IP WWW: World Wide Web, Hypertext, Uniform Resource Locator (URL) Web Browsers, IP Address, Domain Name, Internet Requirements Web Search Engine, Net Surfing, Bulletin Board Services Compression , Components of Multimedia Viruses and their Types, Effects of Viruses Precautions to Avoid Viruses, Scanners and Vaccines Chapter - 12 Multimedia

Case Studies : 

Case Studies Case Study 1: Reddington India Ltd. Case Study 2: Laxmi Co. Ltd. Case Study 3: Data Tech Ltd. Case Study 4: MNC Case Study 5: XYZ Bank

Assignment: 

Assignment

References:-: 

References:- Deepak Bharioke, Fundamentals of Information Technology, Excel Books, New Delhi Sinha & Sinha – Computer Fundamentals Mansfield – The Compact Guide To MS Office Curtis Frye, Microsoft Access; Plain and Simple, Prentice Hall India B.Ram, Computer Fundamentals, New Age Int. A.S.Tannenbaum , Computer Networks, PHI, N.Delhi. Rajaraman, Fundamentsls of Computers, Prentice Hall of India, N.Delhi

Slide 16: 

Thanks….