UBMSFSII.6 : Computer Applications in Business
Â
[50 lectures: 3 Credit]
Â
The objective of the course is,
- To introduce computer applications in Business environment.
- To introduce DBMS & Web Designing concepts.
- To familiarize students with the concepts & developments in MIS & E-commerce.
Â
| Â | Â | Â | TOPICS | No. of |
| Â | Â | Â | Â | lectures |
| Unit | DBMS using MS-access | 13 | ||
| 1 | Â | 1. | Database basics , | Â |
| Â | Â | 2. | Working with database, | Â |
| Â | Â | 3. | Creating database tables, | Â |
| Â | Â | 4. | Entering data in a table, | Â |
| Â | Â | 5. | Sorting records, | Â |
| Â | Â | 6. | Quering in a database, | Â |
| Â | Â | 7. | Generating reports | Â |
| Â | Â | 8. | Common corporate Database management systems | Â |
| Â | Â | Â | ||
| Unit | Web Designing Using HTML | 13 | ||
| 2 | 1. | Evolution of HTML | Â | |
| Â | 2. | Concept of Hyper Text, Tags | Â | |
| Â | 3. | Structure of an HTML file | Â | |
| Â | 4. | Basic Tags <head>, <title>, <body>, <h1> to <h6>, <p>, <b> | Â | |
| Â | 5. | Formatting text – logical and Physical tags | Â | |
| Â | 6. | Style sheets | Â | |
| Â | 7. | Creating Lists and Tables | Â | |
| Â | 8. | Adding graphics with and without text, alignment | Â | |
| Â | 9. | Creating links internal and External, mail links | Â | |
| Â |
|
 | ||
| Â |
|
 | ||
| Â |
|
 | ||
| Â | webpages. | Â | ||
| Unit | E-Commerce | 12 | ||
| 3 | Â | 1. | Definition ,Difference between E-commerce and E-business | Â |
| Â | Â | 2. | E-commerce infrastructure, | Â |
| Â | Â | 3. | Features of E-commerce (Advertising) | Â |
| Â | Â | 4. | Types of E-commerce (B2C, B2B, C2C, P2P) | Â |
| Â | Â | 5. | Business Models in E-Commerce (Revenue, Advertising | Â |
| Â | Â | Â | Subscription, Transaction Fee, Sales Revenue, Affiliate Revenue) | Â |
| Â | Â | 6. | Major B2c models (Portal, E tailer, Content Provider Transaction | Â |
| Â | Â | Â | Broker, Market Creator, Service provider, Community provider). | Â |
| Â | Â | 7. | E-commerce Security: Integrity, Non Repudiation, Authenticity, | Â |
| Â | Â | Â | Confidentiality, privacy, Availability. | Â |
| Â | 8. | Encryption: Definition, Symmetric Key Encryption, DES (Data | Â |
| Â | Â | Encryption Standard, PKI (Public Key infrastructure) Signatures. | Â |
| Â | Â | Digital signatures. SSL. | Â |
| Â | 9. | Payment Systems: Digital Cash, Online stored value digital | Â |
| Â | Â | accumulating balance payment, Digital credit accounts, digital | Â |
| Â | Â | checking. | Â |
| Â | 10. | How an Online credit card transaction works SET protocol | Â |
| Â | 11. | Limitation of E-commerce. | Â |
| Â | Â | Â | Â |
| Unit | MIS | Â | 12 |
| 4 | MIS- definition, nature & scope | Â | |
| Â | MIS characteristics, functions | Â | |
| Â | Structure of MIS, role of MIS | Â | |
| Â | MIS as a control system, process of management | Â | |
| Â | Application of MIS | Â | |
| Â | Implementation & evaluation of MIS | Â | |
| Â | ERP -What is ERP? What are its advantages? | Â | |
| Â | ERP benefits | Â | |
| Â | Â | Â | Â |
Â
References:
Â
- Introduction to Computers Peter Norton ,,Sixth Edition McGrawHill
- Computer Fundamentals – P.K Sinha ( B.P.B publication )
- Fundamentals of Computer – V.Rajaramanna ( Prentice Hall )
- Computers and Commonsense Hunt, J. Shelley ,Prentice Hall of India
- Fundamentals of Information Technology, A and Leon M,Leon,Vikas 2002
- A first Course in Computers, Saxena, Sanjay, Vikas Publishing 1998
- Fundamentals of Information Technology, Bharioke, Deepak Excel Book, 2000
- Learning Web Design A Beginners Guide HTML, Graphics and Beyond Jennifer Niederst O Reilly Press
- ECommerce Kenneth C Laudon, Carol Traver Pearson Education
- ECommerce Awad Pearson Hall India
- HTML Black Book Steven Holzner Dream Tech Press
- Managing with Information Jerome Kanter Prentice Hall India
- ERPA Managerial Perspective Sadagopan Tata Mcgraw Hill
- Computer in Business – Sanders D – McGraw Hill
- Computers and Information Management – S C Bhatnagar & V Ramant – Prentice Hall
- Internet for Business – Brummer, Lavrej – Cambridge
Suggested List of Practicals:
Â
- To demonstrate use of formatting tags, adding images.
- Working with ordered & unordered list.
- Working with tables.
- To demonstrate use of hyper Links.
- To design webpages using frames.
- To design web forms.
- Creating database & tables, entering data in a table, sorting records.
- Querying in a database.
- To create screen/form layout.
- Generating reports.
6 Comments