B COM (Hons) –II year
Fundamentals of Information Technology
Unit – I:
Introduction: Definition, Characteristics and limitations of computers - Impact of computers on Business and Society - Elements of Computers - Hardware-CPU-Primary and Secondary memory-Input and Output devices.
Unit – II:
Evolution of Computers: History and generations of computers. Software: Computer languages – Developing a computer program: Algorithm – Flow Charts – Compilation – Testing and Debugging. Operating Systems: Meaning, Definition, Functions and Types of Operating Systems. Booting process – Disk Operating System: Internal and External Commands – Wild Card Characters – Computer Virus.
Unit – III:
Windows Basics: Desktop – Start menu – Mouse actions.
Word Processing: Meaning and purpose of word processing – Advantages and applications of word processing.
MS WORD: Features - Parts of MS Word application window – Toolbars – Creating, Saving and closing a document – Opening and editing a document - Moving and copying text – Text and paragraph formatting, applying Bullets and Numbering – Find and Replace – Insertion of Objects, Date and Time, Headers, Footers and Page Breaks – Auto Correct – Spelling and Grammar checking – Graphics, Templates and wizards - Mail Merge : Meaning, purpose and advantages – creating merged letters, mailing labels, envelops and catalogs- Working with Tables – Format Painter.
Spreadsheets: Meaning and Purpose of spreadsheet/worksheet – advantages and application of spreadsheet/worksheet.
MS EXCEL: Features of MS Excel – worksheet, workbook, cell, cell pointer, cell address etc., - Parts of MS Excel window – Saving, Opening and Closing workbook – Insertion and deletion of worksheet – Entering and Editing data in worksheet – cell range – Formatting – Auto Fill –Formulas and its advantages – References: Relative, absolute and mixed – Functions: Meaning and Advantages of functions, different types of functions available in Excel – Templates –Charts – Graphs – Macros: Meaning and Advantages of macros, creation, editing and deletion of macros – Data Sorting, Filtering, validation, Consolidation, Grouping, Pivot Table and Pivot Chart Reports.
Unit – IV:
Database concepts: Data, Information, Database, File, Record, Fields- Database Applications – Database organizations.
MS ACCESS: Features, advantages and limitations of MS Access – Application of MS Access – parts of MS Access window – Tables and integrity constraints, Relationships – Designing Tables, Forms, Queries and Reports – Data validity checks – Sorting and filtering.
Multimedia: Meaning, purpose, Usage and application – Images, Graphics, sounds and music – Video presentation devices – Multimedia on web.
MS PowerPoint: Features, advantages and application of Ms Power point – Parts of MS Power point window – Menus and Tool bars – Creating presentations through Auto content wizard, Templates and manually – slide show – saving, opening and closing a Presentation – Inserting, editing and deleting slides –Types of slides - Slide Views- Formatting –Insertion of Objects and Charts in slides- Custom Animation and Transition.
Unit- V:
Modern communication system (Concepts only)- communications – FAX, Voice mail, and information services – E Mail – group communication – Tele conferencing – Video conferencing – File exchange – Bandwidth –common network components, Hosts and servers, workstations, protocol converters, Modems, terminal controllers, routers and gateways – Network Topologies – Network types LAN, MAN, WAN and their architecture – Dial up access – High band width personnel connections – Internet – WWW.
Lab Work:
- MS DOS,MS WORD,MS EXCEL,MS ACCESS,MS PowerPoint,Print Commands
For any other assisstance:- click here
