COMPUTER SYSTEMS AND APPLICATIONS – PAPER II

Authors Name KIRAN BAROT , SANJAY D DEORE , SANDEEP S GUPTA
ISBN 13 9789388293792
Publisher
Edition Second
Pages 208
Language English
Publishing Year Nov-19

Email on info@pragationline.com if e-book is not found.

Print version 175
  • Print Version: The estimated delivery date of the print version is approximately 3 to 5 working days from the date of placing the order

  • For any queries write to info@pragationline.com

Add to Cart Go to Library Add to Cart Buy Now
download-app-scan
download-app
Description

Chpt 1. E-Commerce (Module I)
(a) Definition of E-commerce, Features of E-commerce, Types of E-Commerce (B2C, B2B, C2C, P2P), Limitation of E-commerce.
(b) Business models in E-Commerce (Advertising, Subscription, Transaction Fee, Sales Revenue, Affiliate Revenue), Major B2B models (Portal, Etailer, Content Provider, Transaction Broker, Market Creator, Service Provider, Community Provider).
(c) E-Commerce Security: Integrity, Non repudiation, Authenticity, Confidentiality, Privacy, Availability.
(d) Encryption: Definition, Digital Signatures, SSL.
(e) Payment Systems: Digital Cash, Online stored value, Digital accumulating balance payment, Digital credit accounts, digital checking.
(f) How an online credit card transaction works. SET protocol.
(g) M-Commerce (Definition and Features).

Chpt 2. Working on Multiple Spreadsheets on Excel 2010 (Module II & III)
(a) Creating and using templates, using predefined templates, Adding protection option.
(b) Creating and linking Multiple Spreadsheets.
(c) Using formulas and logical operators, Creating formulas that use reference to cells in different worksheets.
(d) Creating and using named ranges.

Chpt 3. Inbuilt Functions in Excel (Module II & III)
(a) Database functions : LOOKUP, VLOOKUP, HLOOKUP.
(b) Conditional logic functions : IF, Nested IF, COUNTIF, SUMIF, AVERAGEIF.
(c) String functions : LEFT, RIGHT, MID, LEN, UPPER, LOWER, PROPER, TRIM, FIXED.
(d) Date functions : TODAY, NOW, DATE, TIME, DAY, MONTH, YEAR, WEEKDAY, DAYS360.
(e) Statistical functions : COUNTA, COUNTBLANK, CORREL, large, small

Chpt 4. Data Analysis in Excel (Module II & III)
(a) Filter with customized condition.
(b) The Graphical representation of data Column, Line, Pie and Bar charts.
(c) Using Scenarios, creating and managing a scenario. Using Goal Seek. Using Solver.
(d) Understanding Macros, Creating, Recording and Running Simple Macros. Editing a Macro (Concept only).

Chpt 5. Introduction to Visual Basic (Module IV)
(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 and Cancel property, tab order, Coding for controls using Text, Caption, Value Property and Set Focus Method.

Chpt 6. Variables, Constants and Calculations in Visual Basic (Module IV)
(a) Variable and Constant, Data Type (String, Integer, Currency, Single, Double, Date).
(b) Naming rules/conventions, constants (Named and Intrinsic), Declaring variables, Val function, Arithmetic operations, Formatting Data.

Chpt 7. Decision and Condition in Visual Basic (Module IV)
(a) 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 statement with Option Buttons and Check Boxes. Msgbox (Message Box) statement Input Validation : Is Numeric function.
(b) 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.

– Question Bank – Practical Problems on Excel and Visual Basic
– Model Question Paper – Solved

0
    0
    Your Cart
    Your cart is emptyReturn to Shop
      Calculate Shipping
      Apply Coupon