Ranchi University, Jharkhand, General Semester 3, Elementary Computer Application Software Syllabus

Unit - 1 Basic Computer Concept

Unit 1

Basic Computer Concept

1.1 Computer Appreciation Characteristics of Computers

1.2 Input

1.3 Output

1.4 Storage units

1.5 CPU

1.6 Computer System

Unit - 10 Microsoft Power Point (Presentation Package)

Unit 10

Microsoft PowerPoint Presentation Package

10.1 Creating Opening and Saving Presentations

10.2 Creating the Look of Your Presentation

10.3 Working in Different Views

10.4 Working with Slides

10.5 Adding and Formatting Text

10.6 Formatting Paragraphs

10.7 Drawing and Working with Objects

10.8 Adding Clip Art and other pictures

10.9 Designing Slide Shows

10.10 Running and Controlling a Slide Show

10.11 Printing Presentations

10.12 Creating photo album

10.13 Rehearse timing and record narration

10.14 Master slides

Unit - 2 Input and Output Devices

Unit 2

Input and Output Devices

2.1 Input Devices Keyboard Mouse joystick Scanner web cam

2.2 Output Devices Soft copy devices monitors projectors speakers Hard copy devices Printers – Dot matrix inkjet laser Plotters

Unit - 3 Computer Memory and Processors

Unit 3

Computer Memory and Processors

3.1 Memory hierarchy

3.2 Processor registers

3.3 Cache memory

3.4 Primary memory RAM ROM

3.5 Secondary storage devices Magnetic tapes Floppy disks hard disks

3.6 Optical Drives CDROM DVDROM CDR CDRW USB Flash drive

3.7 Mass storage devices USB thumb drive

3.8 Managing disk Partitions

3.9 File System

3.10 Basic Processor Architecture Processor speed Types of processor

Unit - 4 Numbers Systems and Logic Gates

Unit 4

Numbers Systems and Logic Gates

4.1 Decimal number system

4.2 Binary number system

4.3 Octal number system

4.4 Hexadecimal number system

4.5 Interconversion between the number systems

4.6 Basic Logic gates AND OR NOT

4.7 Universal logic gates NAND NOR

Unit - 5 Computer Software

Unit 5

Computer Software

5.1 Computer Software Relationship between Hardware and Software

5.2 System Software

5.3 Application Software

5.4 Compiler

5.5 Names of some high level languages

5.6 Free domain software

Unit - 6 Internet & its uses

Unit 6

Internet its uses

6.1 History of Internet

6.2 WWW and Web Browsers Web Browsing software Surfing the Internet Chatting on Internet

6.3 Basic of electronic mail Using Emails Document handling

6.4 Network definition

6.5 Common terminologies LAN WAN MAN Node Host Workstation Bandwidth

6.6 Network Components Severs Clients Communication Media

6.7 Wireless network

Unit - 7 Operating system-Windows

Unit 7

Operating system Windows

7.1 Operating system and basics of Windows

7.2 The User Interface

7.3 Using Mouse and Moving Icons on the screen

7.4 The My Computer Icon

7.5 The Recycle Bin

7.6 Status Bar

7.7 Start and Menu Menuselection

7.8 Running an Application

7.9 Windows Explorer Viewing of File

7.10 Folders and Directories Creating and Renaming of files and folders

7.11 Opening and closing of different Windows

7.12 Windows Setting Control Panels

7.13 Wallpaper and Screensavers

7.14 Setting the date and Sound

7.15 Concept of menu Using Help

7.16 Advanced Windows

7.17 Using the right Button of the Mouse

7.18 Creating Shortcuts

7.19 Basics of Window Setup

7.20 Notepad

7.21 Window Accessories

Unit - 8 Word Processing

Unit – 8

Word Processing

8.1 Word processing concepts saving closing Opening an existing document

8.2 Selecting text Editing text Finding and replacing text

8.3 Printing documents Creating and Printing Merged Documents

8.4 Character and Paragraph Formatting

8.5 Page Design and Layout

8.6 Editing and Checking Correcting spellings

8.7 Handling Graphics

8.8 Creating Tables and Charts

8.9 Document Templates and Wizards

8.10 Mail merge and Macros

Unit - 9 Microsoft Excel (Spreadsheet)

Unit 9

Microsoft Excel Spreadsheet

9.1 Spreadsheet Concepts Creating Saving and Editing a Workbook

9.2 Inserting

9.3 Deleting Worksheets

9.4 Entering data in a cell formula Copying and Moving from selected cells

9.5 Handling operators in Formulae

9.6 Functions Mathematical Logical statistical text financial Date and Time functions

9.7 Using Function Wizard

9.8 Formatting a Worksheet Formatting Cells changing data alignment changing font adding borders and colors Printing worksheets

9.9 Changing date number character or currency format

9.10 Charts and Graphs – Creating Previewing Modifying Charts

9.11 Integrating word processor spreadsheets web pages

9.12 Pivot table

9.13 Goal seek

9.14 Data filter and scenario manager