Computer Systems And Applications TYBCOM Semester VI Manan Prakashan

Content:
Module – I : E-Commerce (18 Lectures)
(a) Definition of E-commerce
(b) Features of E-commerce
(c) Types of E-commerce (B2C, B2B, C2C, P2P)
(d) Business Models in E-commerce (Advertising, Subscription, Transaction Fee, Sales Revenue, Affiliate Revenue)
(e) Major B2C models (Portal, Etailer, Content Provider, Transaction Broker, Market Creator, Service Provider, Community Provider).
(f) E-Commerce Security: Integrity, Nonrepudiation, Authenticity, Confidentiality, Privacy Availability.
(g) Encryption : Definition, Digital signatures, SSL.
(h) Payment Systems : Digital Cash, Online stored value, digital accumulating balance payment, Digital credit accounts, digital checking.
(i) How an Online credit card transaction works. SET protocol.
(j) Limitations of E-commerce.
(k) M-commerce (Definition and Features)
Module – II : Advanced MS-Excel (9 Lectures)
(a) Multiple Spreadsheets
(i) Creating and using templates, Using predefined templates, and Adding protection options.
(ii) Creating and Linking Multiple Spreadsheets.
(iii) Using formulas and logical operators.
(iv) Creating and using named ranges.
(v) Creating Formulas that use reference to cells in different worksheets.
(b) Functions
(i) Database Functions LOOKUP, VLOOKUP, HLOOKUP
(ii) Conditional Logic functions IF, Nested IF, COUNTIF, SUMIF, AVERAGEIF
(iii) String functions LEFT, RIGHT, MID, LEN, UPPER, LOWER, PROPER, TRIM, FIXED
Module – III : Advanced MS-Excel (9 Lectures)
(a) Functions
(i) Date functions TODAY, NOW, DATE, TIME, DAY, MONTH, YEAR, WEEKDAY, DAYS360
(ii) Statistical Functions COUNTA, COUNTBLANK, CORREL, LARGE, SMALL
(b) Data Analysis
(i) Filter with the customized condition.
(ii) The Graphical representation of data Columns, Lines, Pie, and Bar charts.
(iii) Using Scenarios, creating and managing a scenario.
(iv) Using Goal Seek
(v) Using Solver
(vi) Understanding Macros, Creating, Recording and Running Simple Macros. Editing a Macro (Concept only)
Module – IV : Visual Basic (9 Lectures)
(a) Introduction to Visual Basic, Introduction to Graphical User Interface (GUI)
Programming Language (Procedural, Object Oriented, Event-Driven), Writing VB Projects. The Visual Basic Environment
(b) Introduction to VB Controls
Text boxes, Frames, Check boxes, Option button, Designing the User Interface, Default & Cancel property, tab order, Coding for controls using Text, Caption, Value property and Set Focus method
(c) Variables, Constants, and Calculations
Variable and Constant, Data Type (String, Integer, Currency, Single, Double, Date), Naming rules/conventions, Constants (Named & Intrinsic), Declaring variables, Val Function, Arithmetic Operations, Formatting Data.
(d) Decision and Condition
Condition, Comparing numeric variables and constants, Comparing Strings, Comparing Text Property of text box, Compound Conditions (And, Or, Not). If Statement, if then-else Statement, LCase and Ucase function, Using If statements with Option Buttons & Check Boxes. Msgbox (Message box) statement Input Validation : Is Numeric function.
(e) Sub-procedures and Sub-functions, Using common dialog box, Creating a new sub-procedure, Writing a Function procedure. Simple loops using For Next statements and Do while statement and display output using MsgBox Statement.
Note :
(a) Theory 3 lectures per week.
(b) Practical session batch size 20-25, 1 practical = 3 theory lectures per week.
(c) 10 practicals are to be completed in each semester.
SEMESTER – VI
Topic                                        Number of Practicals
Presentation skills                                      1
Advanced MS-Excel                                   6
Introduction to Visual Basic                    3
Minimum 6 practicals are to be recorded in the journal in the Semester VI.
[Minimum 2 on VB, 4 on Advanced MS-Excel]
Suggested list of Practical’s for Semester VI :
1. Preparing a PowerPoint presentation on an E-Commerce website.
2. Calculation of DA, HRA, PF, Gross Salary and Net Salary using MS-Excel.
3. Calculation of Income Tax using MS-Excel.
4. Filtering data and Graphical representation of data using MS-Excel.
5. Using VLOOKUP and HLOOKUP using MS-Excel.
6. Creating and managing a scenario using MS-Excel.
7. Use of Goal Seek and Solver using MS-Excel.
8. Write a project in VB to design a suitable form to add two numbers and display their sum.
9. Write a project in VB to design a suitable form to enter sales and calculate and display the bonus which is 10% of sales.
Write a project in VB to design a suitable form to enter salary and calculate and display the DA which is 90% of salary.
(d) Scheme of Examination
Type                                                           Marks                        Duration
Theory                                                          75                            2½ hours
Practicals                                                      20                     1 hour per batch of 10
Active Participation and Class Conduct          5
Theory Examination Pattern For Semester VI :
All questions compulsory.
Question No.                     Module No.                     Marks               Marks with Internal Option
Q.1                                 Objective Type                11 + 2 + 2                            23
Based on I, (II, III) and IV
Q.2                                           I                                   15                                      30
Q.3                                           II                                 15                                      30
Q.4                                          III                                15                                      30
Q.5                                          IV                                 15                                      30
Practical Examination Pattern – Semester – VI :
Q.No.    Question on                             Marks
1            Advanced MS-Excel                       7
2            Introduction VB Programming        3
3           Journal                                            5
4            Viva                                                5
(e) Practical examination to be conducted 2 to 3 weeks before the theory examination. Marks out of 25 to be submitted to the University before commencement of theory examination.
(f) Software Requirement :
MS-Excel 2010, MySQL version 5 or 5.1, VB 6.0.
(g) Hardware
For a batch of 120 students minimum 10 computers with appropriate hardware and software installed on each computer. During practical hours maximum two student may share one computer.
(h) For in house computing facility fee of rupees 750/- be charged for each student per Semester in the existing fee structure against head of computer fee/computer practical.