BMB151BMBA151BMBAB107BMLS151

IT Skills-1

L-T-P0-0-3 Credits3 Session2024-25 TypeLab / Practical
Appears in 5 semesters · 5 branches

MBA General · Sem 1 (Lab, code BMB151) · MBA Agribusiness Management · Sem 1 (Lab, code BMBAB107) · MBA Business Analytics · Sem 1 (Lab, code BMBA151) · MBA Health Care & Hospital Management · Sem 1 (Lab, code BMB151) · MBA Logistics & Supply Chain Management · Sem 1 (Lab, code BMLS151)

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 hours

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 hours

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 hours

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 hours

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
  • To provide knowledge about the functioning of computers and its uses for managers
  • To provide hands on learning on Internet and its applications
  • To provide hands on learning on Word processing software
  • To provide hands on learning of applications on Spreadsheet software
  • To provide hands on learning on 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 softwareK2, K4, K6, K4, K2, K5 (Knowledge, Applying, Synthesizing, 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 18, 19 of the original AKTU PDF.

Official AKTU syllabus PDF ↗