V S R & N V R COLLEGE, TENALI
AUTONOMOUS NAAC
Re-Accredited
............................................................................................................................................................
DEPARTMENT
OF COMPUTER SCIENCE
B.Com(Computers)-Syllabus
Semester-I
Unit-I
Computer Fundamentals & Photoshop
Unit-I: Introduction to Computers:
Characteristics and limitations of Computer, Block diagram of
computer, types of computers, uses of
computers, computer generations. Number systems: binary,hexa and octal
numbering system- Windows basics: desktop, start menu, icons
.Unit-II:
Input and Output Devices: Keyboard and
mouse, inputting data in other ways, Types of
Software: system software, Application
software, commercial, open source, domain and free waresoftware, Memories:
primary, secondary and cache memory.
Unit –III:
Introduction to Adobe Photoshop: Getting
started with Photoshop, creating and savinga document in Photoshop, page layout
and back ground, Photoshop program window-title bar, menu
bar, option bar, image window, image
title bar, status bar, ruler, pallets, tool box, screen modes,saving files,
reverting files, closing files.
Unit –IV:
Images: working with images, image
size and resolution, image editing, colour modesand adjustments, Zooming &
Panning an Image, Rulers, Guides & Grids- Working with Tool box:Practice
Sessions.
Unit-V:
Layers: Working with layers- layer
styles- opacity-adjustment layers. Filters: The filtermenu, Working with
filters- Editing your photo shoot, presentation –how to create ads, artistic
filter,
blur filter, brush store filter, distort
filters, noice filters, pixelate filters, light effects, differenceclouds,
sharpen filters, printing.
Reference Books:
1.
Reema Thareja, Fundamentals of Computers, Oxford University Press
2.
Adobe Creative Team, Adobe Photoshop Class Room in a Book.
3.
David Maxwell, Photoshop: Beginner's Guide for Photoshop - Digital Photography,
Photo
Editing,
Color Grading & Graphic...19 February 2016.
Semester-II
Information & Communication
Technology-1
Semester-III
Information & Communication
Technology-2
Office Automation Tools
Unit-I
MS-Excel: features of Ms-Excel, Parts of
MS-Excel window, entering and editing data inworksheet, number formatting in
excel, different cell references, how to enter and edit formula in
excel, auto fill and custom fill,
printing options.
Unit-II
Formatting options: Different formatting
options, change row height, formulae andfunctions, Functions: Meaning and
advantages of functions, different types of functions available in Excel.
Unit-III
Charts: Different types of charts, Parts of
chart, chart creation using wizard, chart operations, data maps, graphs,
data sorting, filtering. Excel sub totals, scenarios, what-if analysis Macro:
Meaning and advantages of Macros, creation, editing and deletion of macros -
Creating a
macro, how to run, how to delete a macro.
Unit-IV
MS Access: Creating a Simple Database
and Tables: Features of Ms-Access, Creating a Database, Parts of Access.
Tables: table creation using design view, table wizard, data sheet view,import
table, link table. Forms: The Form Wizard, design view, columnar, tabular, data
sheet, chart wizard.
Unit- V
Finding, Sorting and Displaying Data: Queries
and Dynasts, Creating and using select queries, Returning to the Query
Design, Multi-level sorts, Finding incomplete matches, showing All
records after a Query, saving queries -
Crosstab Queries. Printing Reports: Form and Database Printing. Relational
Databases: Flat Versus Relational, Types of Relationships, Viewing Relationships,
Defining and Redefining Relationships, Creating and Deleting Relationships.
Reference
Books:
1.Ron
Mansfield, Working in Microsoft Office, Tata McGraw Hill(2008)
2.Ed
Bott, Woody Leonhard, Using Microsoft Office 2007, Pearson Education(2007)
3.
Sanjay Saxsena, Microsoft Office, 4.Microsoft Office, BPB Publications
Semester-V
Programming IN C
Unit- I
Introduction to Algorithms and
Programming Languages: Algorithm – Key features of Algorithms – Some more
Algorithms – Flow Charts. Introduction to C: Structure of C Program – Writing
the first C Program – File used in C Program – Compiling and Executing C
Programs – Using Comments – Keywords – Identifiers – Basic Data Types in C
– Variables – Constants – I/O
Statements in C- Operators in C-
Programming Examples – Type Conversion and Type Casting
Unit-II
Decision Control and Looping
Statements: Introduction to Decision Control Statements –
Conditional Branching Statements –
Iterative Statements – Nested Loops – Break and Continue Statement – Go to
Statement
Unit- III
Functions: Introduction – using
functions – Function declaration/ prototype – Function definition –
function call – return statement – Passing parameters – Scope of variables –
Storage Classes – Recursive function
Unit-
IV
Arrays: Introduction – Declaration
of Arrays – Accessing elements of the Array – Storing Values in Array –
Calculating the length of the Array – Operations on Array – one dimensional
array
for inter-function communication – Two
dimensional Arrays –Operations on Two Dimensional Arrays.
Unit-V
Strings:- Introduction string and
character functions.
Reference Books:
1. Reema Thareja, Introduction to C
programming, Oxford University Press.
2. E Balagurusamy, Computing
Fundamentals & C Programming – Tata McGraw-Hill, 2008.
3. Ashok N Kamthane, Programming with
ANSI and Turbo C, Pearson Publisher, 2002.
4. Henry Mulish & Hubert L.Coo Reema
Thareja: The Spirit of C: An Introduction to Modern
Programming, Jaico Publishing House,1996.
Semester-V
Database
Management System
Unit-I
Overview of Database Management System:
Introduction, Data and Information,Database, Database Management System,
Objectives of DBMS, Evolution of Database Management Systems,
Classification of Database Management System.
Unit-II
File-Based System, Drawbacks of
File-Based System , DBMS Approach, Advantages of DBMS, Data Models ,
Components of Database System, Database Architecture, DBMS Vendors and
their Products.
Unit-III
Entity–Relationship Model:
Introduction, The Building Blocks of an Entity– Relationship,
Classification of Entity Sets , Attribute Classification, Relationship Degree, Relationship
Classification, Generalization and Specialization, aggregation and composition,
CODD’S Rules, Relational Data Model ,
Concept of ,Relational Integrity.
Unit-IV
Structured Query Language: Introduction,
History of SQL Standard, Commands in SQL, Data types in SQL, Data
Definition Language (DDL), Selection Operation Projection
Operation, Aggregate Functions, Data
Manipulation Language, Table Modification, Table Truncation, Imposition of
Constraints, Set Operations.
Unit –V
PL/SQL: Introduction, Structure of
PL/SQL, PL/SQL Language Elements ,Data Types,
Control Structure,, Steps to Create a
PL/SQL Program, Iterative Control ,Cursors , Steps to Create a Cursor ,
Procedure, Function ,Packages ,Exceptions Handling, Database Triggers, Types of
Triggers.
Reference Books:
1. Paneerselvam: Database Management
Systems, PHI.
3. David Kruglinski, Osborne, Data
Management System McGraw Hill Publication.
4. Shgirley Neal and Kenneth LC Trunik
Database Management Systems in Business – PHI.
5. Godeon C. EVEREST, Database
Management – McGraw Hill Book Company.
6. MARTIN, Database Management –
Prentice Hall of India, New Delhi.
7. Bipin C. Desai, “An Introduction to
Database Systems”, Galgotia Publications.
8. Korth, Database Management systems.
9. Navathe, Database Management systems.
10. S. Sumathi, S. Esakkirajan,
Fundamentals of Relational Database Management Systems
Semester-V
Web
Technology
Unit-I
Introduction: HTML, XML, and WWW, Topologies,
Bus, Star, Ring, Hybrid, Tree,
Lan,Wan,Man. HTML: Basic HTML, Document
body, Text, Hyper links, Adding more formatting,
Lists, Tables using colors and images.
More HTML: Multimedia objects, Frames, Forms towards
interactive, HTML document heading.
Unit-II
Cascading Style Sheets: Introduction, using
Styles, simple examples, your own styles,
properties and values in styles, style
sheet, formatting blocks of information, layers.
Unit-III
Introduction to JavaScript: What is
DHTML, JavaScript, basics, variables, string
manipulations, mathematical functions,
statements, operators, arrays, functions.
Unit-IV
Objects in JavaScript: Data and objects in
JavaScript, regular expressions, exception
handling, built-in objects, events.
Unit-V
DHTML with JavaScript: Data validation,
opening a new window, messages and
confirmations, the status bar, different
frames, rollover buttons, moving images, multiple pages in
single download, text only menu system.
References:
1. Uttam Kumar Roy, Web Technologies,
Oxford University Press.
2. Black Book HTML 5.0
3. Complete reference HTML 5.0
4. Web Technology, PHI Publications.
No comments:
Post a Comment