1PGDCA1
- FUNDAMENTALS OF COMPUTERS & INFO. TECH.
UNIT-I
Computer System Concepts, Application area, advantage &
disadvantage, Components of a computer system - Control unit, ALU,
Input/Output, Memory, Mother Board, Generations of
computers, Configurations of Computersystem, Typesof
PCs-Desktop, Laptop, Notebook, Palmtop, PDA, Special Purpose computers, Supercomputers Characteristics & area of
Uses, Primary Vs Secondary Memory, RAM, ROM, EPROM, PROM.Various Storage
Devices- Magnetic Disks, Hard Disk Drives, Floppy, Disks, Zip Drive, Optical
Disks, CD, VCD, CD-R, CD-RW, DVD, DVD-RW, Blue Ray Disc, flash drives SD/MMC
Memory cards, Solid-State Drive (SSD).
Input
Devices: Keyboard, Mouse, Trackball, Joystick, Scanners, Digitizingtablet,
Digital Camera, MICR, OCR, OMR, Light pen, Barcode & Barcode Reader, Quick
Response Code (QR Code), Voice Recognition, Touch Screen.Output Devices:
Monitors- Characteristics and types of monitor, Size, Digital,
Analog,Resolution, Refresh Rate, Interlaced/Non-Interlaced, Dot Pitch, Video
Standard- VGA, SVGA, XGA etc. Printers and itsTypes Impact & Non-Impact
printer, Dot Matrix, Inkjet, Laser, Plotter, 3D Printers, Sound Card &
Speakers
Software and Its Need, Types of
Software- System Software, Application Software, System Software- Operating
System- definition & function, Device Drivers & UtilityPrograms,
Introduction & Features of DOS, Windows.
Programming Languages-Machine, Assembly, High Level, 4GL, their Merits
and Demerits, Uses of Assemblers, Compilers and Interpreter.Application
Software and its Types- Word Processing,Spreadsheet, Presentation Graphics,
Data Base Management, Desktop Publishing, communication,Educational, Graphics &
Multimedia, Business Accounting, MIS, Gaming and ERP Software etc.Computer
coding system-ASCII, ISCII and Unicode, Number system of compute Binary, Octal,
Decimal, Hexadecimal their conversion.
Use of communication
and IT, Communication Process,
Component of communication - sender, receiver,
transmission medium & protocol, Communication types- Simplex, Half Duplex,
Full Duplex. Communication Channels- Twisted, Coaxial, Fiber Optic,
Modem-Working and characteristics. Types of network- client/ server and
peer-to-peer networks, Types of connections- Dialup, Leased Lines, ISDN, DSL,
RF, Broad band uses, advantages & disadvantages. Types of Network- LAN,
WAN, MAN, Internet, VI'N etc., Topologies of LAN- Ring, Bus, Star, Mesh and
Tree topologies- structure, uses, advantages & disadvantages. Components of
LAN- Media, NIC, NOS, Network devices - Bridges, HUB, Routers, Repeater,
Gateways uses, advantages & disadvantages
Disk
Operating System (DOS): Introduction, DOS Basics - Drive Name, FAT, File and
Directory Structure and Naming Rules, Booting Process, DOS System Files.DOS
Commands: Internal - DIR, MD, CD, RD, COPY, COPY CON, DEL, REN, External-TREE,
FORMAT, SORT, FDISK, MODE, ATTIRIB, HELP, SYS etc., Concepts of Free/Open
Source and proprietary software, applications and use of computer in various
fields.LINUX: History & Features, Hardware Requirements of Linux, Various
flavors of Linux, Linux Standard Directories, Functions of Profile and Login
Files in Linux, Linux Kernel, Login and Logout from Linux System, Linux
commands- bc, cal, cat, cd, clear, cmp, cp, my, date, find, ls, pwd, mkdir,
more, rm, rmdir, chgrp, chmod, who, whois.
1PGDCA2 - PC
PACKAGES (WORD, EXCEL, POWERPOINT)
UNIT-I
Operating System (Windows
8.1): Overview of Windows Operating System, Basic
Operations - How to start a computer, login, logoff, hibernate,shutdown etc,
Personalizing Desktop-Desktop Background, Screen Saver, Themes, Setting date
& time, Task bar, Files & Folders, Create, Copy, Rename, Moving &
Delete Files & Folders, Create & Using Shortcuts, Recycle Bin.
Accessories-MS Paint, Notepad, WordPad, Windows Media
Player, Calculator, Games, Math Input Panel, Language Settings-How to set other
languages on computer Using Control Panel to add, remove or configuring new or
existing devices and software programmes and fonts, Enhance the performance of
computer- using Disk Clean-up, using Disk Defragmenter, Using Windows Update,
Protecting your computer against viruses.
Using Internet in Windows:
Basic Operations using Internet Browser-Working withbrowsers, Know about WWW,
URL, Search Engines, Searching information on Wikipedia, Subscribing and
reading newspapers online, Typing text in the regional language, Using Google
Maps, Working with Google Apps, Online Ticket Booking,for PAN Card/Passport
/Aadhar Card online, Pay electricity bill and service tax online, Booking gas
refill online, Downloading eBooks.
Modern office activities and their
software requirements, Introduction to OfficeAutomation Suit, Elements of office
suit & area of use. Word-processing, Spreadsheet,Presentation graphics,
Database, Introduction and comparison of various office suites like Apache
OpenOffice, Libre Office, Calligra Suite, WPS office, KOffice, Google
DocsMicrosoft office.
MS Word Basics: Introduction to MS
Office (2013), Introduction toMS Word, Features & area of use. Various
versions of MS Office and their requirements, Working with MSWord, Menus &
Commands, Ribbon, Toolbars & Buttons, Shortcut Menus, Wizards
&Templates, Creating a New Document, Different Page Views and layouts,
Applying various Text Enhancements- Fonts, Styles, Text Attributes, Formatting
Your Text and Documents: Auto format, Paragraph and Page Formatting, Line
spacing, Margins,Borders and Shading, Tabs and Indents, Text Editing using
various features, Bullets,Numbering,
Working with Styles,
Printing &various print
options, Spell Cher' Working with
Headers and Footers.
Tables: Creating a simple
table, Creating a table using the table menu, Entering and editing text in a
table, selecting in table, adding rows, changing row heights, Deleting rows,
Inserting columns, Deleting columns, changing column width, conversion to
andfrom text.
Advanced Features of MSWord-Spell Check, Thesaurus,
Find & Replace, Files, Auto texts, Symbols etc.,Working with Columns, Tabs
& Indents, Margins & Spacemanagement in Document, Page, Column &
Section Breaks, Adding References, Usingfootnote and endnote in documents,
creating automatic Table of Contents, Using Themes, Watermarks, Inserting
Equations & Symbols.
Graphics:
Importing graphics, Clipart, Insert picture, Using Clip Art, Shapes and
SmartArt in documents, using drawing features, drawing objects, text in
drawing. Taking and inserting Screenshots in Documents, Using WordArt and Drop
Cap features in documents. Templates:
Template types, using templates, exploring templates, modifying
templates.
Mail Merge in MS Word,
Mail Merge concept, Envelops & Mailing Labels, Importing and exporting to
and from various formats, Macros tin MS Word: Macro introduction and their use,
recording macros, editing macros, running a macro.
UNIT-IV
MS Excel Spreadsheet Basics & features, concepts
of Workbook & Worksheets, Getting started, Creating a new worksheet, Using
Wizards, Various Data Types, Selecting cells, Entering and editing text,
Entering and editing Numbers, Removing & Resizing of Columns & Rows,
entering and editing Formulas, Referencing cells, moving cells, copying cells,
sorting cell data, inserting rows, inserting columns, Inserting cells, Deleting
parts of a worksheet, clearing
parts of a worksheet, Different Views of
Worksheets.
Formatting: Page setup, Cell Formatting, changing
column widths and Row heights, auto format, changing font sizes and Attributes,
centering text across columns, using border buttons and Commands, changing
colors and shading, hiding rows and columns, Working with Data & Ranges,
Column Freezing, Labels, Hiding, Splitting, merging etc.
Charts: Chart parts and
terminology, chart wizard, different types of charts, printing charts, deleting
charts, linking in spreadsheet, Printing of Workbook & Worksheets with
various options.
UNIT-V
MS PowerPoint: Introduction & area of use, Working with
MS PowerPoint, Creating a New Presentation, Working with Presentation, Using
Wizards; Slides & its different views,
Inserting, Deleting and Copying of Slides; Working with Notes, Handouts, Columns & Lists, Adding
Graphics, shapes, screenshots, Smart Art and charts in presentation, Sounds
and Movies to
a Slide; Working
with PowerPoint Objects,
Designing & Presentation of a Slide Show, change Slide backgrounds, Change
Slide Size, Using Animation and Transitions in presentation,
Advanced Slide options-Manual
& Automatic, Printing Presentations, Notes, Handouts with print option
Slide Master, Handout Master and Notes Master.
Outlook Express: Features and uses,
Configuration and using Outlook Express for accessing emails in office, Add
e-mail accounts to Outlook, Create emails, send and receive emails in outlook.
1PGDCA3(B) - DATABASE USING MS ACCESS
UNIT-I
Introduction to database -What is a Database, Why use a Relational
Database, Overview of Database Design- Data Normalization (Determining tables,
Determining Fields, Determining Relationships) Integrity Rules,'
(Primary/Foreign Key, One-to-Many, Many-to-Many, One-to-One) Introduction to MS
Access (Objects, Navigation).
UNIT-II
Tables in Database, Create
a Table in MS Access- Data Types, Field Properties, Fields: names, types,
properties- default values, format, caption, validation rules Data Entry, Add
record delete record and edit text, Sort, find/replace, filter/ select,
rearrange columns, freeze columns. Edit a Tables- copy, delete, import, modify
table structure, find, replace.
UNIT-III
Working with
Query, Setting up
Relationships- Define relationships, add a
relationship, set a rule for
Referential Integrity, change
the join type, delete
a relationship, save relationship Queries & Filter - difference
between queries and filter, filter using multiple fields AND, OR, advance
filter Queries, create Query with one table, find record with select query,
find duplicate record with query, find unmatched record with query, run query,
save and change query.
UNIT-IV
Working with Forms,
Introduction to Forms Types of Basic Forms: Columnar, Tabular, Datasheet,
Main/Subforms, add headers and footers, add fields to formadd text to form use
label option button, check box, combo box, list box Forms Wizard, Create
Template
UNIT-V
Working with Reports,
Introduction to Reports, Types of Basic Reports: Single ColurYTabular Report
Groups/Total, single table report, multi table report preview repotprint
report, Creating Reports and Labels, Wizard.
1PGDCA4(B) -
PROGRAMMING WITH VB .NET
UNIT-I
Object Oriented
Programming Language - Object Oriented Programming Concepts, Object Oriented
Programming Compared to Traditional Programming Objects, Messages, Methods and
Classes. Control Structures7 Inheritance and Polymorphism, Advantages, Usage.
Program development environment
UNIT-II
Introduction to .NET, .NET
Framework features & architecture, CLR, Common Type System, MSIL,
Introduction to visual studio, Visual BASIC, visual development & event
drive Programming, Methods and events, Variables, Data Type of variables,
Classes & Objects, simple projects in VB.NET, constructor, inheritance,
Access Specifiers, Overloading
UNIT-III
Scope & lifetime of a
variable, Arrays, Collections, Subroutines, Functions, Control flow statements:
conditional statement, loop statement. Msgbox& Input box. Forms: Loading,
showing and hiding forms, Methods and events, GUI Programming with Windows
Form, Textbox, Label, Button, simple projects in VB.NET using these controls
UNIT-IV
More advanced tools,
Listbox, Combobox, Checkbox, PictureBox, Radio Button, Panel, scroll bar,
Timer, Dialog boxes, Designing menus, Advanced projects in VB.NET using these
controls
UNIT-V
Database programming with
ADO.NET Accessing Data using Server Explorer, Creating Connection, Accessing
Data using Data Adapters and Datasets, using Command &Data Reader, data
bind Controls, displaying data in data grid.
Processing AccessDatabase using ADO.NET Object model, Connection object,
Command object, Add,delete, move & update records to dataset. Projects in
VB.NET using database
Comments
Post a Comment