Computer Applications in Business is a Practical subject which involves Theoretical knowledge of Spreadsheets, Web Designing, E-Commerce, MIS. If you know how to operate them, then theory would be easy. Computer Applications in Business provides an overview of the integrated software packages most often used in the workplace. You learn basic features and business applications for the word processor, spreadsheet, database, and presentation software.
The most important part is to know your syllabus, so read through your syllabus first:
Unit I : Advanced Spreadsheets.
A) Multiple Spreadsheets
- Creating and Using templates
- Creating and Linking Multiple Spreadsheets.
- Add Headers/Footers to a Workbook.
- Create Formulas that use references to cells in different worksheets.
- Creating and using named ranges
- Financial functions: FV, PV, PMT, PPMT, IPMT, NPER, RATE, NPV, IRR
- Database Functions VLOOKUP, HLOOKUP
- Conditional Logic Functions IF, COUNTIF, SUMIF
C) Data Analysis
- Using Scenarios, creating and managing a scenario.
- Using Goal Seek.
- Using Solver.
- Pivot Tables – Building Pivot Tables, Pivot Table regions, Rearranging Pivot Table.
- Creating simple macros.
Unit II : Web Designing Using HTML
- Evolution of HTML
- Concept of Hyper Text, Tags
- Structure of an HTML file
- Basic Tags – <head>, <title>, <body>,<h1> to <h6>, <p>, <b>
- Formatting text – Logical and Physical tags
- Style Sheets
- Creating Lists and Tables
- Adding graphics with and without text, alignment.
- Creating links – internal and External, mail links
- Creating Frames
- Creating Forms.
- Understanding How softwares like Front Page, Dream Weaver Create HTML files.
- Uploading HTML Pages using SW like Cute FTP, WS FTP
Unit III : E-Commerce
- Definition Diff. between Ecommerce and E-business
- E-commerce infrastructure, Packet switching, TCP/IP, IP addresses Domain Names. URL 5, HTIP, SMTP, POPMAP, SSI, TELNET, FINGER, TRACERT
- Development of web Browsers Hypertext
- Features of E-Commerce (Advertising)
- Types of E-commerce (B2C, B2B, C2C, P2P)
- Business Models in E-Commerce (Revenue, Advertising, Subscription, Transaction Fee, Sales Revenue, Affiliate Revenue)
- Major B2c models (Portal, Etailer, Content Provider Transaction Broker, Market Creator, Service provider, Community provider.
- E-Commerce Security: Integrity, Non Repudiation, Authenticity, Confidentiality, privacy, Availability.
- Encryption : Definition, Symmetric Key Encryption, DES (Data Encryption Standard), PKI (Public Key Infrastructure) Signatures, Digital Signatures, SSL.
- Payment Systems: Digital Cash, Online stored value digital accumulating balance payment. Digital credit accounts, digital checking.
- How an Online credit card transaction works SET protocol.
- Limitation of E-commerce.
Unit IV : MIS
- Introduction to MIS.
- Meaning Basic Concepts.
- BPS Introduction and Understanding the concept.
- ERP What is ERP? What are its advantages?
- Make sure you attend your practical lectures, because without them you won’t be able to understand your theory.
- The theory is quite like your other theory subjects, understand, refer sources and learn.
- MIS and E-commerce are sections that will be repeated in future, make sure you do them well.
- Advance spreadsheets are HTML in practical application come on the lesser side but in terms of weightage form a very important part, especially the HTML codes and excel commands and shortcuts.