FYBMS 2014-15 : Introduction to Computers Syllabus

7 UBMSFSI. 7 -Introduction to Computers

[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

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

2. Output Unit
3. Storage Unit (Primary and Secondary)
4. 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

2. 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.

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,

4. Topologies- Star, Bus, Ring.

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

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

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

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

Modem     Connections, ATM

1. Internet

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

6. setting time, rehearsing timing,
7. animating slide, animating objects,
8. running the show from windows.

(C)Using Excel

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

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

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

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)].

2. 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.

3. working with basic DOS commands for example

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

4. 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.

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

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

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

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

9. Data Analysis using Excel.

10. Setting up MS outlook.

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