Computer Systems And Applications
TYBCOM Semester VI
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, Non repudiation, Authenticity, Confidentiality, Privacy Availability.
(g) Encryption : Definition, Digital ignatures, 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, Adding protection option.
(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.
(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)
(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 customized condition.
(ii) The Graphical representation of data Column, Line, 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 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.
(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.
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.
|BOARD||Maharashtra State Board|
|SUBJECT||Computer Systems And Applications TYBCOM Semester VI|