BCA-105 COMPUTER FUNDAMENTALS & OFFICE MANAGEMENT TOOLS
|
Course Code : BCA-51T-105
|
Course Title : Computer
Fundamentals & Office
Management Tools
|
|
Course Credit : 04
|
Hours/Week : 04
|
Introduction to Computers: Characteristics of computers, Evolution of computers.
generation of computers, Block diagram of computer & role of each block, classification of
computers, applications of computers.
Input and Output Devices: Keyboard, pomtmg devices, speech recogn1t1on, digital camera, scanners,
optical scanners. Classification of output devices, printers, plotters. computer
output microfilm (COM), Classification
of output devices, devices- monitors, audio output, projectors, and terminals.
Primary and Secondary Memory: Memory hierarchy, Random access memory (RAM). types of RAM, Read only memory (ROM), types of ROM. Classification of secondary
storage devices, magnetic tape, magnetic
disk, optical disk.
Number Systems: Introduction to number system, Binary, Octal, Hexadecimal, conversion
between number bases, Arithmetic operations on binary numbers.
Alphanumeric- BCD, EBCDIC, ASCII, Unicode.
UNIT- II
Computer Software: Software
definition, relationship between software and hardware. software
categories, system software,
application software, utility
software.
Computer Languages: Introduction,
classification of programming languages. generations of programming languages,
features of a good programming language.
Internet Basics : Introduction, features
of internet, Internet applications,
services of internet, Logical and Physical addressess, Internet Service Provider Domain
name System.
Web Basics :
Introduction to web, web browsers, http/https, URL.
UNIT- III
MS Word: Word processing, MS-Word
features, creating saving and opening
documents in Word, interface, toolbars, ruler, menus, keyboard shortcut, editing, previewing. printing &
formatting a document, advance
features of MS Word, find & replace, using
thesaurus, mail merge, handling
graphics, tables, converting a Word document into various formats like-text, rich text
format, Word perfect, etc.
MS Excel: Worksheet basics, creating
worksheet, entering data into worksheet, data, text dates, alphanumeric values saving & quitting worksheet,
opening and moving around in an existing worksheet, Tool bars and menus, Keyboard shortcuts, working with single and
multiple workbook, working with
formula & cell referencing, Auto sum, coping formulas. absolute and
relative addressing, formatting of worksheet,
previewing & printing
worksheet, Graphs and Charts, Database, macros, multiple worksheets-concepts.
UNIT- IV
Power Point: Creating and viewing a
presentation, managing Slide Shows,
navigating through a presentation, using hyperlinks, advanced navigation with action setting and action
buttons, organizing formats with
Master Slides, applying and modifying designs. adding graphics, multimedia and special effects.
Microsoft Access: Planning a database (tables, queries, forms, reports),
creating and editing database, customizing tables, linking tables,
designing and using forms. modifying database structure, Sorting and Indexing
database, querying a database and generating reports.
|
1.1.
|
INTRODUCTION TO COMPUTERS
|
1
|
|
|
Computer: The Definition
|
1
|
|
1.1.2.
|
Hardware and software
|
2
|
|
1.1.3.
|
Characteristics of Computers
|
2
|
|
1.1.4.
|
Evolution of the Computer
|
4
|
|
|
Generations of Computer
|
6
|
|
1.1.6.
|
Block Diagram
|
9
|
|
|
Classification of Computers
|
11
|
|
|
Applications of Computer
|
13
|
|
1.2.
|
INPUT AND OUTPUT
DEVICES
|
16
|
|
|
-500x500.jpeg "BCA-105 COMPUTER FUNDAMENTALS & OFFICE MANAGEMENT TOOLS")
