FIT

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:

1. MS DOS,MS WORD,MS EXCEL,MS ACCESS,MS PowerPoint,Print Commands
 

 

 

To download it :-                  Click here

For any other assisstance:- click here