Monday, November 20, 2017
bsdi facebook  bsdi twitter  bsdi linkedin  bsdi youtube bsdi google plus

moto

Daffodil Education Network

Admission open for Diploma in Hotel Management with Internship. Also in short course: F&B Production, F&B Service, House Keeping, Front Office with Internship. Please call for details : 01713493243, 01713493246.

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