BMBF151

IT Skills Lab -1

L-T-P0-0-3 Credits2 Session2025-26 TypeLab / Practical
Appears in 1 semester

MBA Banking & Financial Services · Sem 1 (Lab)

Syllabus

5 units · 5 lecture hours
Unit1

Unit 1: Conceptual Framework

5 hrs

Hardware: (a) Input devices - keyboard, printing devices, voice speech devices, scanner, MICR, OMR, Bar code reader, digital camera etc. (b) Output devices - Visual Display UNIT, printers, plotters (c) Storage Devices – Magnetic storage devices, Optical storage devices, Flash Memory. Software: Types of software with examples; Introduction to languages, compiler, interpreter and Assembler, Operating System Functions, Types and Classification, Elements of GUI based operating system. Network and Internet: Types of computer networks (LAN, WAN and MAN), Netiquettes, Basic services over Internet like WWW, FTP, Telnet, Gopher,URL, Domain names, Web Browsers, Multimedia and its applications: Concepts of Text, Graphics, Animation, Audio, Images, Video. Multimedia Application in Education, Entertainment, Marketing. Names of common multimedia file formats,

Unit2

Unit 2: Windows and Users Interface (Lab Work)- 7 Hrs

Windows operating System: Introduction and characteristics, Elements of GUI. Using Mouse, My Computer Icon, The Recycle Bin, Status Bar, Start and Menu & Menu-selection, Running an Application, Windows Explorer: Viewing of File, Folders and Directories Creating and Renaming of files and folders Opening and closing of different Windows, Windows Setting: Control Panels, Wall paper and Screen Savers Setting the date and Sound. Concept of menu, Using Help, Using right Button of the Mouse, Creating Short cuts, Basics of Window Setup, Notepad, Window Accessories

Unit3

Unit 3: Word Processor Software (Lab Work) – 8 Hrs

Word processing concepts: Opening, Saving, Closing the file, Opening an existing document, Selecting text, Editing text, Finding and replacing text, printing documents, Creating and Printing Merged Documents, Character and Paragraph Formatting, Page Design and Layout. Editing and Profiling Tools: Checking and correcting spellings. Using Graphics, Tables, Charts, Document Templates and Wizards.

Unit4

Unit 4: Spreadsheet Software (Lab Work) – 10 Hrs

Spreadsheet Package Spreadsheet: Concept and Working Interface, Creating, Saving and Editing a Workbook, Inserting, Deleting Work Sheets, entering data in a cell / formula Copying and Moving from selected cells, handling operators in Formulae. Functions in Spreadsheet: Mathematical, Logical, statistical, text, financial, Date and Time functions, Using Function Wizard. Formatting a Worksheet and Cell: changing data alignment, changing date, number, character or currency format, changing font, adding borders and colors. Printing worksheets, Charts and Graphs – Creating, Previewing, and Modifying Charts. Integrating word processor, spread sheets, web pages.

Unit5

Unit 5: Presentation Software (lab Work) – 8 Hrs

  • Interface of the Presentation Package: Creating, Opening and Saving Presentations. Professional Look of the Presentation: Working in different Design & Views, Working with Slides. Formatting and Editing:
  • Text, Image and Paragraph formatting, Checking Spelling and Correcting Typing Mistakes, Making Notes Pages and Handouts, Drawing and Working with Objects, Adding Clip Art and other pictures, Designing Slide Shows, Running and Controlling a Slide Show, Printing Presentations.
Course Objectives5 points
  • Explain the functioning of computers and their relevance in managerial decision-making.
  • Demonstrate effective use of the Internet and its applications in a business context.
  • Apply word processing software to create, format, and edit professional documents.
  • Provide hands on learning of applications on Spreadsheet software to organize data, perform calculations, and generate analytical reports.
  • Create and design business presentations using presentation software
Course Outcomes (COs)5 outcomes

After completion of the course student will be able to:

  1. CO1Gain in depth knowledge about the functioning of computers and its uses for managers
  2. CO2Learn to use Internet and its applications
  3. CO3Understand and implement Word processing software
  4. CO4Learn applications on Spread sheet softwares
  5. CO5Analyse and learn Presentation software Applying (K4) Synthesizing ( K6)K2, K4, K2, K5 (Knowledge, Applying, Knowledge, Analyse)

Suggested Readings

  1. Nasib Singh Gill – Handbook of Computer Fundamentals, Khanna Publishing House, Delhi
  2. Shrivastava-Fundamental of Computer& Information Systems (Wiley Dreamtech)
  3. Leon A and Leon M - Introduction to Computers ( Vikas, 1st Edition).
  4. ITL ESL – Introduction to Information Technology (Pearson, 2nd Edition).
  5. Introduction to Computers, Norton P. (TATA McGraw Hill)
  6. Leon - Fundamentals of Information Technology, (Vikas)
  7. Satish Jain-BPB's Computer Course Windows 10 with MS Office 2016 (BPB)
  8. Linda Foulkes- Learn Microsoft Office 2019: A comprehensive guide to getting started with Word, PowerPoint, Excel, Access, and Outlook (Packt Publishing Limited)

Official AKTU syllabus

This subject is on page 20, 21 of the original AKTU PDF.

Official AKTU syllabus PDF ↗