Tuesday, February 28, 2017
bsdi facebook  bsdi twitter  bsdi linkedin  bsdi youtube bsdi google plus

moto

Daffodil Education Network

Admission Going On for the session 2016-17 in Diploma in Computer, Electrical, Civil, Textile, Garments Design & Pattern Making & Medical Technology, Dental,Pathology, Pharmacy

Advanced Computer Application

Course Outline:

Basic Computer Application (BCA)

Knowledge Area

Knowledge Item

Information Technology

Types Computer

⇒ Understand and distinguish between Super Computer, Mainframe Computer, Mini Computer, Micro Computer, Network Computer, Laptop Computer in terms of capacity,, Speed, cost and typical users

Hardware

⇒ Most known Input devices, Output devices, Storage

Software

⇒ Types of Software, Operating System Software, Application Software, System Development

Information Network

⇒ LAN & WAN, Electronic Mail, The Internet

Security & Copyright

⇒ Security, Computer viruses

Using the Computer & Managing Files

First steps with the computer

⇒ Start the Computer

⇒ Shut down the computer properly

⇒ Restart the Computer

⇒ View the Computer’s desktop configuration: date & time, volume settings, desktop display options (e.g. Background options, screen settings, screen saver options etc)

⇒Be able to format a diskette

⇒Use available help functions

Work with Icons

Select and move desktop icons. Recognize basic desktop icons such hard disk, directory tree, directories/folders and files, recycle bin/wastebasket. Create a desktop shortcut icon or a desktop menu allies.

Work with Windows

⇒Recognize the different parts of a desktop Window: title bar, toolbar, menu bar, and status bar, scroll bar etc.

⇒ Understand how to reduce a desktop window, how to resize and scale a desktop window, how to close a desktop window.

⇒ Recognize the different parts of an applications window: title bar, toolbar, menu bar, and status bar, scroll bar etc. Move windows on the desktop

⇒Understand how to reduce an applications window, how to enlarge an applications window, how to resize and scale a desktop window, how to close a application window. Move between open windows.

Directories/Folders

⇒ Understand the basic directory and folders structure on the computer

⇒ Create a directory/folder and a further subdirectory and sub folder

⇒ Examine a directory/folder. View some of the directory/folder attributes: name, size, date when last updated

⇒ Recognized the most widely used types of files in a directory/folder e.g. Word Processing Files, Spreadsheet Files Database files, Image files

⇒ View file attributes e.g. name, size, file type, date last modified etc.

⇒ Rename files and directories /folder

Directories/Folders

⇒ Select a file individually or as part of an adjacent or non‐adjacent group.

⇒ Copy and paste files within directories/folders to make a duplicate copy.

⇒ Make backup copies of data into a diskette

⇒ Use Cut and Paste functions to move files within directories /folders

⇒ Delete files from one or more directories / folders

⇒ Delete selected directories /folders.

 

Directories / Folders

⇒Use the find tool to locate a file or a directory / folder.

⇒ Search by name, date created, file or directory / folder type etc.

Simple Editing

⇒ Launch an editing application or a word processing program and cra file

⇒ Save the file to a directory / folder

⇒ Save the file onto a diskette

⇒ Close the editing application.

Print Management

⇒ Be able to print from an installed printer.

⇒ Change the default printer from an installed printer list

⇒ View a print job’s progress from a desktop print manager

Microsoft Word

Copy, Move & Delete

⇒ Use copy and paste tools to duplicate text within a document. Use cut and paste tools to move text within document

⇒ Copy and move text between active documents

⇒ Delete text

Search & Replace

⇒ Use the search command for a word or phrase within a document.

⇒ Use the replace command for a word or phase within a document

Text Formatting

⇒ Change fonts: Size and Types

⇒ Use italics, embedding, underlying

⇒ Applying different colors to text

⇒ Use alignment and justification options

⇒ Use hyphenation where appropriate

⇒ Indent text

⇒ Change line spacing

⇒ Copy the formatting from a selected piece of text

General Formatting

⇒ Use and set tabs: left, right, center, decimal

⇒ Add borders to the document.

⇒ Use lists (Bulleted and numbered)

Template

⇒ Choose an appropriate document template for use in a specified task

⇒ Work within a template on a specified task

Styles and pagination

⇒ Apply existing styles to a document

⇒ Insert page numbering in a document

Headers & Footers ⇒

Add headers and footers to a document

⇒ Insert date, author, page numbers etc in Headers and Footers

⇒ Apply basic text format options in Headers and Footers

Spelling and Grammar 

⇒ Use a spell‐check program and make changes where necessary

⇒ Use grammar tool and make changes where necessary

Document Setup

⇒ Modify document setup: page orientation, page size etc.

⇒ Modify document margins

Printing

⇒ Installed the uninstalled printer

⇒ Preview a document

⇒ Use basic print options

⇒ Print a document from an installed printer

Tables

⇒ Create standard tables

⇒Change cell attributes: formatting, cell size, color etc.

⇒Insert and delete columns and rows

⇒Add borders to a table

⇒Use the automatic table‐formatting tool

Pictures & Image

⇒ Add an image or graphics file to a document

⇒Add auto shapes to a documents, change line colors, change auto shapes fill colors

⇒Move image and drawn objects

⇒Resize a graphic

Importing Objects

⇒ Import spreadsheet into a documents

⇒Mail merge


Microsoft Excel

First Steps with the word

⇒Open a Spreadsheet application

⇒Open an existing spreadsheet‐mark some modifications and save

⇒Open several spreadsheet and save

⇒Create a new spreadsheet and save

⇒Save an existing spreadsheet onto the hard dist or diskette.

⇒Close the spreadsheet.

⇒Use application Help Functions

⇒Close the spreadsheet application

Adjust Basic settings

⇒Change the spreadsheet view mode

⇒Use the page view modification tool/zoom tool.

⇒Modify toolbar

Document Exchange

⇒Save an existing spreadsheet under another file format: txt file, document template, software type and version number etc

Insert Data

⇒ Enter text in a cell

⇒Enter symbols or special characters in a cell

⇒Enter simple formulas into cell

⇒Use the undo command

Select Data

⇒Select a cell or range of adjacent or non‐adjacent cells

⇒Select a row or column. Select a range of adjacent or non‐adjacent rows or columns

Format cells numbers

⇒Format cells to display different number styles: number of decimal places, number of zeros after the decimal point, with or without commas to indicate thousands

⇒Format cells to display different data styles

⇒Format cells to display different currency symbols

⇒Format cells to display different numbers as percentages

Format cells‐Text

⇒Change text size. Format text: Bold, Italic, font type

⇒Change Text font colors

⇒Adjust text orientation

Format Cells‐Cell Range

⇒Center and align cell contents in a selected cell range: left and right, top and bottom.

⇒Add border effects to a selected cell range

⇒Use a spell check program and make changes where necessary

Spelling

⇒Modify Document margin settings

Document Setup

⇒Modify document margin settings

⇒Adjust document setup to fit one page.

⇒Add a header and footer

⇒Change document orientation‐portrait or landscape, page size etc.

Printing simple spreadsheet document

⇒Use basic print options

⇒Preview a spreadsheet

⇒Print a spreadsheet or a worksheet

⇒Print part of a worksheet or a pre‐defined cell range.

Importing Objected

⇒Import objects into a spreadsheet: Image files. Graphs, Text files etc.

⇒Move and resize imported objects within a spreadsheet.

Charts and Graphs

⇒Produce different types of chart and graphs from spreadsheet figures to analyze data, e.g. pie charts, column charts, bar charts.

⇒Edit or modify a chart or graph: add a title or label, change the scale.

⇒Modify the colors in the chart or graph

⇒Change the chart type

⇒Move or delete charts or graph


Microsoft power point

Start with power point
 

⇒Open Ms power point

⇒Open an Existing power point presentation

 

Understand Power Point Screen

⇒Knowledge about various Bar

Like: Manu Bar

Tool Bar

⇒Understand the overall screen

Power Point Overview

⇒Create New Slide

⇒Change Slide

⇒Apply Design Temples

⇒Effect Setting on slides

⇒Rehearse Time setting on presentation

⇒Run power point slide show

 

Navigation the slide show

⇒Go to next slide

⇒Go to previous slide

⇒Print

⇒Print individual slide in a page

⇒Print more than slide in a page

Internet & Email Communication

First Steps with the Internet

⇒Open a Web browsing application

⇒Understand the makeup and structure of a Web Address.

⇒Display a given Web Page.

⇒Change the Web browser Home Page/Start page.

⇒Save a Web page as a file.

⇒Use application Help Functions.

⇒Close the Web browsing Application.

Adjust Basic Settings

⇒Change view / display modes

⇒Modify toolbar display.

⇒Display images on Web page.

⇒Do not load image files onto web page

Accessing a Web Address

⇒Open a URL and collect data

⇒Open hyperlink or an image link and return to original page.

⇒Browse a specified site and collect data.

Using Search engine

⇒Define search requirements.

⇒Use a key word in a search.

⇒Use common logical operators in a search.

⇒Modify page setup options.

⇒Print a Web page using basic print options.

⇒Present a search report as a printed document.

⇒Open a book marked web page.

 

Create a Book Mark

⇒Open a book marked web page.

⇒Bookmark a Web page

⇒Add web pages to Book folder

Send, Receive

⇒Create a new email account

⇒Sending a message.

⇒Receive a mail with attached file.

⇒Send an email with attached file

⇒Read message

⇒Reply/ reply all messages

⇒Forward messages

⇒Message to several addresses

 

Fees