Sunday, August 22, 2010

Scores for Presentation held on 19/08/2010

Hello students,

I am uploading the excel sheet of your marks scored during the class presentation. Do let me know if there is any doubt.

Monday, August 16, 2010

Syllabus


_COMPUTER FUNDATMENTALS (MS101)
Syllabus
Introduction : Characteristics of Computers; The Evolution of Computers; The Computer
Generations (First Generation(1942-1955), Second Generation (1955 – 1964), Third Generation
(1964 – 1975), Fourth Generation (1975 – 1989), Fifth Generation (1989 – Present)).
Basic Computer Organization : Input Unit; Output Unit; Storage Unit; Arithmetic Logic Unit;
Control Unit; Central Processing Unit; The System Concept.
Number Systems: Non-Positional Number Systems; Positional Number Systems (Binary
Number System, Octal Number System, Hexadecimal Number System); Converting One number
System to Another (Converting to Decimal from Another Base, Converting from Decimal to
Another Base (Division-Remainder Technique), Converting from a Base Other Than 10 to a
Base Other Than 10, Shortcut Method for Binary to Octal Conversion, Shortcut Method for Octal
to Binary Conversion, Shortcut Method for Binary to Hexadecimal Conversion, Shortcut Method
for Hexadecimal to Binary Conversion); Fractional Numbers.
Processor and Memory : The Central Processing Unit (CPU) (The Control Unit, The Arithmetic
Logic Unit (ALU), Instruction Set, Registers, Processor Speed, Types of Processors); The Main
Memory (Storage Evaluation Criteria, Main Memory Organization, Main Memory Capacity, RAM,
ROM, PROM and EPROM, Cache Memory.
Secondary Storage Devices : Sequential and Direct-Access Devices; Magnetic Tape (Basic
Principles of Operation, Types of Magnetic Tapes, Advantages and Limitations of Magnetic
Tapes, Uses of Magnetic Disks); Optical Disk (Basic Principles of Operation, Types of Optical
Disks, Advantages and Limitations of Optical Disks, Uses of Optical Disks); Mass Storage
Devices (Disk Array, Automated Tape Library, CD-ROM Jukebox); Storage Hierarchy.
Input-Output Devices : Input Devices (Keyboard Devices, Point-and-Draw Devices, Data
Scanning Devices, Digitizer, Electronic Card Reader, Voice Recognition Devices, Vision-Input
System); Output Devices (Monitors, Printers, Plotters, Screen Image Projector, Voice Response
Systems).
Computer Languages : Analogy with Natural Languages; Machine Language (Advantages and
Limitations of Machine Language); Assembly Language (Assembler, Advantages of Assembly
Language over Machine Language, Limitations of Assembly Language, Assembly Languages
with Macro Instructions); High-Level Language (Compiler, Linker, Interpreter, Advantages and
Limitations of High-Level Languages); Object-Oriented Programming Languages; Some High-
Level Languages (FORTRAN, COBOL, BASIC, Pascal); Some More High-Level Languages (C
and C++, Java, RPG, LISP, SNOBOL); Characteristics of a Good Programming Language;
Selecting a Language for Coding an Application; Subprogram.
Application Software Packages : Word-Processing Package (What it is?, Commonly Supported
Features); Spreadsheet Package (What it is?, Commonly Supported Features); Graphics
Package (What it is?, Commonly Supported Features); Personal Assistance Package (What it
is?, Commonly Supported Features).
PTU/BOS/MS/210/23-08-2004/BATCH-2004
4
The Internet : Definition (What it is?); Brief History; It’s Basic Services (Electronic Mail, File
Transfer Protocol, Telnet. Usenet News, The World Wide Web); WWW Browsers; Uses of the
Internet.
Classification of Computers : Notebook Computers; Personal Computers (PCs); Workstations;
Mainframe Systems; Supercomputers; Clients and Servers.
MICROSOFT OFFICE 2000
Microsoft Office 2000 : Introduction; Microsoft Word 2000; Microsoft Excel 2000; Microsoft
Access 2000; Microsoft Powerpoint 2000, Microsoft Outlook 2000; Internet Explorer 5.0;
Microsoft FrontPage 2000; Microsoft Publisher 2000; Microsoft PhotoDraw 2000; Microsoft Office
Bar; Using the Mouse (To Click, To double-click, To select, To drag, To scroll, To choose from a
menu, To move a window, To resize a window, To minimize a window, To restore a minimized
window, To maximize a window, To switch windows, To close a window, Remember); Microsoft
Office 2000 and Web (Microsoft Word 2000, Microsoft Excel 2000, Microsoft Access 2000,
Microsoft Powerpoint 2000, Microsoft Outlook 2000, Microsoft FrontPage 2000); Common
Keyboard Commands.
Creating Your Document in Word 2000 : Introduction; Saving the file; Formatting the text,
Alignment of Text; Applying Fonts; Spell Checking; Consulting Thesaurus; Assign Character
Styles (Assign a Character Style, Create a character style); Borders and Shading (Apply
Borders and Shading); Closing of the File; Save as option; Open File (From File menu, From
Open Icon); Printing Your Document.
Proofing Your Document in Word 2000 : Introduction; Editing Tools; AutoCorrect (Add
AutoCorrect Entries Without Formatting, Add New AutoCorrect Entries with Formatting); Auto
Text (Creating an AutoText Entry, AutoComplete Option); AutoFormat (AutoFormat as You Type,
AutoFormat on Command, AutoFormatting Text); Find and Replace; Find; Replace Text; Page
Numbering; Header and Footer (Adding a Header or Footer in Your Document); Footnotes and
Endnotes (Add a Footnote or Endnote).
Creating a Worksheet in Excel 2000 : Introduction; Copying Formula.
Advanced Techniques of Excel 2000 : Introduction; Auditing a Workbook (To Trace the
Precedents for a Formula); Comment Inserting (To Insert a Comment); Formulas That Make
Decisions (How the If function works); Headers and Footers; Merging Workbooks (To merge
workbooks); Outlines (Outline a Worksheet Automatically, Clear Entire Outline, Show or Hide
Outline Symbols, Group Rows or Columns in an Outline, Ungroup Rows or Columns in an
Outline, Remove Group from Outline, Set Outline Options); Printing Column and Row Labels on
Every Page; Protecting a Workbook (To unlock cells so that others can edit the cell contents, To
protect a workbook, To share a workbook); Ranges, Naming (To name a range); References
(Absolute references, Mixed references); Seeking Goals (To seek a goal); Sheets Naming (To
Name a Sheet); Working with Workbooks (Copying Entries Between Workbooks, Moving Sheets
Between Workbooks, Deleting Sheets).
Creating Presentation Using AutoContent Wizard, Creating New Presentation, Creating
Presentation from Template, Changing views.