UBMSFSI. 7 – Introduction to Computers – 50 lectures, 3 credit.
Introduction to Computers is introduced in BMS course to provide brief introduction to computer hardware, software and application development as a background to the identification of potential areas for the use of computers in the management. The subject creates 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). The subject aims to familiarize BMS students with recent development and techniques in information technology and develop knowledge of management of computer services activities in institutions engaged in research activities.
Introduction to Computers has 4 main units which are as follows:
Unit 1 – Computer Fundamentals – 12 lectures
Unit 2 – Data Communication and Networks – 13 lectures
Unit 3 – Office packages – 13 lectures
Unit 4 – Advanced Excel and Multimedia – 12 lectures
The topics covered in Unit 1 – Computer Fundamentals are as follows:
- Characteristics of Computers
- Evolutions of Computers
- Types of Computers – Mini, micro, mainframe and super
- Input Unit
- Output Unit
- Storage Unit – Primary and Secondary
- Processing Unit
Input and Output Devices
1) Input Devices
Point and Draw Devices
Data Scanning Devices
Digitizer Electronic Card Reader
Speech Recognition Devices
2) Output Devices
Screen Image Projectors
Voice Response Systems
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.
- Backup, anti-virus, firewall, spyware, screen savers.
- Types single user,
- multiple user,
- passport license,
- campus licence pirated software,
- commercial SW- stand alone,
- software suites,
- public domain SW,
- Open source,
- Word processing SW,
- Presentation SW,
- Database management SW,
The topics covered in Unit 2 – Data Communication and Networks are as follows:
- Overview: Definition, Advantages
- Types: Common types – LANs,WANs, Hybrid Networks – CANs, MANs, HANs. Intranets and Extranets.
- Networks structures – Server based, client / server, peer to peer.
- Topologies – Star, bus, ring
- Network media – wired – twisted pair, co-axial, fibre optic and wireless – radio and infrared.
- Network hardware: NICs, Hubs, Bridges, Switches, Routers.
- Cables: Ethernet, Fast Ethernet, Gigabit Ethernet.
- Network protocols: TCP/IP, IPX/SPX, NETbios/NetBUI.
- Digital Data connections: Broadband connections, DSL Technologies, Cable modem connections, ATM
- Overview: Definition, types of connections, sharing internet connection, hot spots.
- Internet services: Email, news, FTP, IRC, IM, Online services, peer to peer services, blogs, communities, social networking websites
- WWW: IP addresses, domain names, URLs, hperlinks, HTML, Web browsers
- Searching the web: Directories, search engines – Boolean search, advanced search, meta search engines.
- Cyber crime, cyber law, hacking, sniffing, spoofing, social engineering.
The topics covered in Unit 3 – Office Packages are as follows:
- Word processor,
- Features of word processor,
- Creating and editing word documents,
- Formatting documents,
- Working with tables,
- Using tools, working with menus,
- Creating flowchart, creating templates,
- Working with mail – merge, creating macro.
Presentations with power point:
- Creating presentation, working with slides, different types of slides,
- Setting page layout, selecting background and applying design,
- Adding graphics to slide, adding sound and movie,
- Working with table, creating chart and graph,
- Playing a slideshow, slide transition, advancing slides,
- Setting time, rehearsing timing,
- Animating slide, animating objects,
- Running the show from windows.
- Use of Excel sheet, saving, opening and printing workbook,
- Apply formats in cell and text,
- Divide worksheet into pages, setting page layout,
- Protecting your work, password protection,
- Creating and using templates,
- Creating and linking multiple spreadsheets,
- Add headers /footers to a workbook,
- Create formulas that use references to cells in different worksheets,
- Creating and using named ranges.
The topics covered in Unit 4 – Advanced Excel and Multimedia are as follows:
Functions in Excel:
- Financial functions: FV, PV, PMT, PPMT, IPMT, NPER, RATE, NPV, IRR
- Database functions: VLOOKUP, HLOOKUP
- Conditional Logic functions: IF, COUNTIF, SUMIF
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.
- What is multimedia?
- Multimedia computer systems
- Multimedia components
- Multimedia applications.
The list of reference books for Introduction to Computers subject is as follows:
- Introduction to Computers – Peter Norton, Sixth Edition, McGraw Hill
- Computer Fundamentals – P.K. Sinha – B.P.B. Publication
- Excel – Missing Manual, Mathew McDonald, O Reilly Press
- Fundamentals of Computer – V. Rajaramanna, Prentice Hall
- Computers and Commonsense Hunt – J. Shelley, Prentice Hall of India
- Fundamentals of Information Technology – A and Leon M., Leon, Vikas 2002
- A first course in Computers, Saxena, Sanjay, Vikas Publishing 1998
- Fundamentals of Information Technology, Bharioke, Deepak Excel Book 2000
The suggested list of practicals for Introduction to Computers subject is as follows:
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 and 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 documents
- Adding a header to the document
- Using bullet points and 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 powerpoint 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 and Conditional Logic functions in Excel
9) Data analysis using Excel
10) Setting up MS Outlook.
Using internet: surfing, browsing, search engines, email and messenger