7 UBMSFSI. 7 -Introduction to Computers

Advertisement

[50 lectures: 3 Credit]

The objectives of the course are:

  1. To provide brief introduction to computer hardware, software and applications development as a background to the identification of potential areas for the use of computers in the management.
  2.  An understanding of application areas and a framework for the use of computers as a management to cope with the changing methods of business ( physical to virtual i.e via internet)
  3.  To familiarize students with recent developments & techniques in Information Technology and develop knowledge of management of computer services activities in institutions engaged in research activities.

 

Unit 1

Computer Fundamentals 12
  1. Introduction
    1. Characteristics of Computers
    2. Evolutions of Computers
    3. Types of Computers

Mini Computers

Micro Computers

 

Mainframe Computers

Super Computers

 

  1. Computer Organization
    1. Input Unit
  1. Output Unit
  2. Storage Unit (Primary and Secondary)
  3. Processing Unit

 

  1. Input and Output Devices
    1. Input Devices

 

Keyboard Devices Point and Draw Devices Data Scanning Devices Digitizer Electronic-Card Reader

 

Speech Recognition Devices Vision-Input System

 

  1. Output Devices

 

Monitors Printers Plotters

 

Screen Image Projectors Voice Response Systems

 

  1. Software Concepts
    1. Introduction
    2. Types of Software

System Software:

 

Operating Systems: Overview: Definition, Functions, Types -Single user, Multiuser. Study of different OS: DOS, Windows NT, Windows 9X, Windows 2000,

 

UNIX, LINUX

 

Supporting Utilities: Back up, Anti-virus, Firewall, Spyware, Screen savers.

 

Application Software: Types Single user, Multiple user, Passport license.

Campus Licence Pirated Software. Commercial SW-Stand Alone, Software

Suites. Freeware, Public Domain SW, Open Source. Word Processing SW,

Spreadsheets, Presentation SW, Database Management SW, PIM.

 

Unit 2    Data Communication and Networks 13
  1. Networking Basics

1. Overview: Definition, Advantages.

 

2. Types: Common Types-LANs, WANs, Hybrid Networks -CANs, MANs,HANs. Intranets and Extranets.

 

3. Networks Structures- Server-Based, Client /Server, Peer to Peer,

  1. Topologies- Star, Bus, Ring.

 

  1. Network Media- Wired-Twisted pair, Co-axial, Fibre Optic and Wireless-Radio and infrared.

 

  1. Network Hardware: NIC’s, Hubs, Bridges, Switches, Routers.

7. Cables: Ethernet, Fast Ethernet, Gigabit Ethernet.

  1. Network Protocols : TCP/IP, IPX/SPX, NETbios/NetBUI.
  2. Digital Data connections: Broadband Connections, DSL Technologies, Cable

Modem     Connections, ATM

 

  1. Internet

1. Overview: Definition, Types of connections, Sharing internet connection, Hot

 

2. Internet Services -, Email, News, FTP, IRC,IM, Online Services, Peer to Peer
Services, Blogs,   Communities, Social Networking websites.
3. WWW: IP addresses, Domain names, URLs. Hyperlinks, HTML,Web
4. Searching the Web: Directories, Search Engines-Boolean Search, Advanced
Search, Meta Search
5. Cyber Crime, Cyber Law, Hacking, Sniffing, Spoofing, Social engineering.
Unit 3 Office packages 13
(A)Word Processor
Word processor,
features of word processor
creating & editing word documents
Formatting documents
working with tables,
using tools, working with menus,
creating flowchart, creating templates,
working with Mail – Merge, Creating Macro.
(B)Presentations with power point :
Creating presentation, working with slides, Different type of slides ,
setting page layout, selecting background & applying design,
adding Graphics to slide, adding sound & Movie,
working with table, creating chart & Graph,
playing a slide show, slide transition, advancing slides,

 

  1. setting time, rehearsing timing,
  2. animating slide, animating objects,
  3. running the show from windows.

 

(C)Using Excel

 

1. Use of Excel sheet, saving, opening & printing workbook, 2. Apply formats in cell & text,

 

  1. Divide worksheet into pages, setting page layout,
  2. protecting your work, password protection
  3. Creating and Using templates
  4. Creating and Linking Multiple Spreadsheets.
  5. Add Headers/Footers to a workbook.

 

4. Create Formulas that use references to cells in different worksheets. 5. Creating and Using named ranges.

 

Unit 4    Advanced Excel & Multimedia 12
(A) Functions in Excel
Financial functions: FV, PV, PMT, PPMT, IPMT, NPER, RATE, NPV, IRR
2. Database functions: VLOOKUP, HLOOKUP
Conditional Logic functions IF, COUNTIF, SUMIF
(B) Data Analysis using Excel
Using Scenarios, creating and managing a scenario
Using Goal Seek.
Using Solver
Pivot Tables -Building Pivot Tables. Pivot Table regions. Rearranging Pivot Table.
Creating simple macros.
(C) Multimedia
What is multimedia?
multimedia computer systems
Multimedia components
Multimedia applications

 

 

 

Suggested List of Practicals

  1.    Practical session covering Study of Hardware devices [ FOR EXAMPLE  monitor,  mouse,  keyboard, computer  data storage,  hard drive disk , system unit (graphic cards, sound cards, memory, motherboard and chips)].

 

  1. Practical session covering Windows Basics: Desktop, Taskbar, start menu, My computer, Recycle bin, Accessories (notepad, calculator, paint etc.) System use, keyboard, mouse operations, Word pad and paint brush, Creating a folder and saving a document, windows shortcuts etc.

 

  1. working with basic DOS commands for example

dir, mkdir, copy, md, cd, del, rd, date, cls etc.

 

  1. Creating & formatting the word document

 

  • Save the document
  • Running the spell checker.
  • Text formatting

 

  • Change the line spacing of the paragraphs
  • Applying a hanging indentation
  • Replacing the word.
  • Insert a soft carriage return.
  • Applying the style Heading
  • Applying page border to the document.

 

  • Adding a header to the document
  • Using bullets points & numbered list.
  • Creating table.

 

  1. a. Using Mail Merge feature to create form letters in Microsoft Word. b. Creating a macro in MS Word.

 

  1. Creating a Power-point presentation by using several features. For example inserting graphics, videos, animation, transition, rehearse timing etc.

 

  1. Working with Excel document creating formulae that use references to cells in different worksheets, Creating and Using named ranges, sorting etc.

 

  1. Working with Financial, Database & Conditional Logic functions in Excel.

 

  1. Data Analysis using Excel.

 

10. Setting up MS outlook.

 

Using Internet: Surfing, browsing, Search engines, E-mail and messenger.

 

 

 

Advertisement
The following two tabs change content below.
We, at BMS.co.in, believe in sharing knowledge and giving quality information to our BMS students. We are here to provide and update you with every details required by you BMSites! If you want to join us, please mail to [email protected]
1 Comment

Leave a reply

Your email address will not be published. Required fields are marked *

*

*

BMS.co.in is aimed at revolutionising Bachelors in Management Studies education, also known as BMS for students appearing for BMS exams across all states of India. We provide free study material, 100s of tutorials with worked examples, past papers, tips, tricks for BMS exams, we are creating a digital learning library.

Disclaimer: We are not affiliated with any university or government body in anyway.

©2019 BMS - Bachelor of Management Studies Community 

A Management Paradise Venture

Ask Us On WhatsApp
or

Log in with your credentials

or    

Forgot your details?

or

Create Account