Subject Name: Information Technology Lab
Class: B.Tech. - I year
Semester: I - SEM
Branch : MBA
Academic Year : 2025 - 2026
Resource Materials: Lab Manual Lab Notes
23MB71 - Information Technology Lab
Prerequisite: Basic knowledge of the fundamentals of computers and their operation.
Exercise-I:
Fundamentals of Computer: CPU, Basic logic gates, Computer Memory and Mass storage devices,
Computer Hierarchy, Input Technologies, Output Technologies, Number Systems
and Arithmetic: Decimal, Binary, Octal, and Hexadecimal Number Systems, Binary Arithmetic. Computer Software: Application and System Software, Programming Languages and their Classification, Assemblers, Compilers and Interpreters, Process of Software Development. Operating Systems- Functions of Operating Systems, Types of Operating Systems (Batch Processing, Multitasking, Multiprogramming and Real-time Systems)
Exercise -II
MSWord: Text Basics, Text Formatting and saving files, Working with Objects, Header & Footers, working with bullets and numbered lists, Tables, Merging Documents, Sharing and Maintaining Documents, Proofing the document, Printing.
Exercise -III
Introductory concepts of MS-EXCEL: Introduction to Excel, formatting Excel workbook, Perform Calculations with Functions, Sort and Filter Data with Excel, Lookup Functions, Data Validations, Logical Functions, WHAT IF ANALYSIS, Protecting and Sharing the workbook, Use Macros to Automate Task, Proofing and Printing.
Working with charts: Charts and Slicers, Create Effective Charts to Present Data Visually, Analyze Data Using PivotTables and Pivot Charts, Array Functions, EXCEL DASHBOARD
Exercise-IV
MS POWER POINT: Setting Up PowerPoint Environment, creating slides and applying themes, working with bullets, and numbering, Working with Objects, Hyperlinks, and Action Buttons, Working with Movies and Sounds, Animation and Slide Transition, and Slide show options.
Exercise-V
Introduction to MS-ACCESS: Exploring Access Environment, designing a Database, creating a Relational Database in Access, Managing Data in a Table, querying a Database, Designing Forms, and Working with Reports.
Photoshop: Basic utilities and tools, that help them to edit a photograph, toolbars, saving files, Using help and resources.
Introduction to Google Forms: Creating, sharing.
Relevant case study discussions in all units
1. Fundamentals of Computers by E. Bala Gurusamy, Publisher: McGraw Hill Education
2. Learning Microsoft® Office 2013 Deluxe Edition Pearson.
3. Foundations of IT, Dhiraj Sharma, Excel books.
1. P.K. Vishwanathan, 2003, Business Statistics, An applied orientation” Pearson.
2. Microsoft Office Professional 2010 Step by Step eBook by Joyce Cox, Joan Lambert, and Curtis Frye.
3. Introduction to Computers and Communications, Peter Norton-Sixth Edition-Tata McGraw-Hill.