IT Tools for Business Notes
Subject Overview
This Skill Enhancement Course is a hands-on computer literacy workshop — practical exposure to the operating systems and office software every management graduate needs. You'll cover computer fundamentals, data representation and number systems, computer software and memory, and build working proficiency in MS-Word, MS-PowerPoint, and MS-Excel. This is a 2-credit paper across 4 units, designed to be immediately useful in any office role.
Subject at a glance
4
Units
31
Topics
2
Credits
4
Infographics
Unit-wise Syllabus
4 units — open any unit for detailed topic-wise notes, diagrams and important exam questions
- Data
- instruction and information
- characteristics and applications of computers
- input-output devices
- hardware
- software
- humanware and firmware
- block diagram and functional units of a computer
- number systems and their conversion
- 1Input unit
Keyboard, mouse, scanner
- 2CPU: control unit
Directs all operations
- 3CPU: ALU
Does arithmetic and logic
- 4Memory
Stores data and instructions
- 5Output unit
Monitor, printer
Study guide
This unit covers computer basics: data, instructions and information, characteristics and uses of computers, input and output devices, hardware, software, humanware and firmware, the block diagram and functional units and number systems with conversions. Practise binary, octal and hexadecimal conversions.
- Application vs. system software
- compilers and interpreters
- generations of programming languages
- primary and secondary memory
- storage media
- directory and file manipulation in Windows
Translates
Whole program at once
One line at a time
Speed of running
Faster
Slower
Errors
Shown after compiling
Shown line by line
Examples
C, C++
Python, JavaScript
Study guide
You study application versus system software, compilers and interpreters, generations of programming languages, primary and secondary memory, storage media and file management in Windows. Be able to compare a compiler and an interpreter.
- Creating
- formatting
- saving and printing documents
- alignment
- indents
- lists and headers/footers
- mail merge
- creating and designing presentations
- slide sorter view
- slide shows
- inserting graphics
- 1Main document
Letter with placeholders
- 2Data source
Excel list of names and addresses
- 3Insert merge fields
Name, address and so on
- 4Preview results
Check each letter
- 5Finish and merge
Print or email
Study guide
You learn Word and PowerPoint: creating, formatting, saving and printing documents, alignment, indents, lists, headers and footers, mail merge, designing presentations, slide sorter and slide shows. Create a resume and a short presentation as practice.
- Spreadsheet creation and formatting
- charts and graphs
- menu commands and toolbars
- cell editing and protection
- calculation of financial and statistical functions using formulas
Sum
=SUM(A1:A10)
Average
=AVERAGE(B2:B20)
Conditional
=IF(C2>=40,"Pass","Fail")
Lookup
=VLOOKUP(id, table, col, FALSE)
Loan instalment
=PMT(rate, periods, −amount)
Study guide
In Excel you learn spreadsheet creation and formatting, charts, menu commands, cell editing and protection and financial and statistical formulas. Practise building a small budget with formulas and a chart.
Why IT Tools for Business Matters
Office and spreadsheet skills are expected in almost every business role and are commonly tested in internships and placements.
How to Prepare for IT Tools for Business
- Practise on real tasks: a resume, a budget sheet and a presentation.
- Learn keyboard shortcuts for faster work.
- Master Excel functions such as SUM, IF, VLOOKUP and PMT.
IT Tools for Business: Frequently Asked Questions
Why is Excel important for BBA students?
Excel is used for budgeting, analysis and reporting in marketing, finance and operations, making it one of the most valuable business skills.