Workshop on IT Tools for Business and E-Commerce Notes
Subject Overview
This Skill Enhancement Course is a hands-on workshop rather than a theory-heavy paper — practical exposure to the computer and office-software skills every commerce graduate needs. You'll cover computer fundamentals and the Windows operating system, then build working proficiency in MS-Word and MS-PowerPoint, followed by MS-Excel for financial and statistical calculations. The workshop closes with an introduction to e-commerce — website design, digital payment systems, and e-commerce security. This is a 2-credit paper across 4 units, designed to be immediately useful rather than exam-theory-only.
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
- Meaning
- features
- advantages and limitations of computers
- input/output units
- CPU
- primary and secondary memory
- operating system functions
- application vs. system software
- directory and file manipulation in Windows
Examples
RAM, ROM, cache
Hard disk, SSD, pen drive
Speed
Very fast
Slower
Volatile
RAM is volatile
Non-volatile
Capacity
Smaller
Larger
Study guide
This unit builds computer fundamentals: the meaning, features, advantages and limitations of computers, input and output units, the CPU, primary and secondary memory, operating system functions, application versus system software and file and directory management in Windows. Learn to explain primary and secondary memory with examples.
- Creating
- saving
- formatting and printing documents
- alignment
- lists and headers/footers
- mail merge
- creating and designing presentations
- slide sorter view
- slide shows
- inserting graphics
- 1Create the main letter
- 2Connect a data source
Excel list of names and addresses
- 3Insert merge fields
Name, address, amount
- 4Preview
Check each letter
- 5Finish and merge
Print or email
Study guide
You learn to create professional documents and presentations: creating, saving, formatting and printing in Word, alignment, lists, headers and footers, mail merge, and creating and designing PowerPoint presentations with slide sorter, slide shows and graphics. Practise mail merge; it is a practical skill used in offices.
- Spreadsheet creation and formatting
- charts and graphs
- toolbars and menu commands
- cell editing and protection
- calculation of financial and statistical functions using formulas
Total
=SUM(B2:B20)
Condition
=IF(C2>=50000, "Target met", "Below")
Loan instalment
=PMT(rate/12, months, -loan)
Lookup
=VLOOKUP(A2, Prices, 2, FALSE)
Count with condition
=COUNTIF(D2:D50, "Paid")
Study guide
In Excel you create and format spreadsheets, charts and graphs, edit and protect cells and use formulas for financial and statistical functions. Practise common functions such as SUM, IF, VLOOKUP and PMT with real business data.
- E-commerce vs. traditional commerce
- features and benefits of e-commerce
- website components and design
- corporate websites and portals
- internet advertising
- electronic payment systems
- security issues in e-commerce
B2B
Business to business, e.g. IndiaMART
B2C
Business to consumer, e.g. online stores
C2C
Consumer to consumer, e.g. OLX
C2B
Consumer to business, e.g. freelancers
Study guide
This unit introduces e-commerce: how it differs from traditional commerce, its features and benefits, website components and design, corporate websites and portals, internet advertising, electronic payment systems and security issues. Know the main online payment methods and the common security threats.
Why Workshop on IT Tools for Business and E-Commerce Matters
Office and e-commerce skills are expected from every commerce graduate and are often tested in placement drives and accounting job interviews.
How to Prepare for Workshop on IT Tools for Business and E-Commerce
- Build a sample resume, a business letter with mail merge and a small Excel budget.
- Learn keyboard shortcuts for Word and Excel.
- Study the main e-commerce models (B2B, B2C, C2C) with examples.
Workshop on IT Tools for Business and E-Commerce: Frequently Asked Questions
What is e-commerce?
E-commerce is the buying and selling of goods and services over the internet.
Why learn Excel in B.Com?
Excel is used for accounting, budgeting, analysis and reporting in almost every commerce job.