Basic Computer Applications

Topics: Database, Database management system, SQL Pages: 18 (946 words) Published: April 14, 2014
CSE 1021
BASIC COMPUTER
APPLICATIONS

Introduction to BCA & DBMS

CSE 1012 - Basic Computer Applications
2



Lecture : 2hrs/ week
Lab: 2 hrs/ Week



Assessment







1 written test (15%)
1 assignment on Access 2010(15%)
1 Exam (70%)

Lesson Objectives
3










Understand what the basic computer applications are
Provide computer application
To introduce the concept of database and its uses
To discuss about the predecessor of the database
system, the file-based system
To study the database approach
To compare and contrast between the database system
and the file-based system

Use of Computer
4





Look around you and just image where computer are NOT
being used?
Computers are used everywhere:



Supermarket
University
School
Banks
Business
Shopping centre



Everywhere!!!







Question
5



Why do we use computer?

What are the Basic Computer
Applications?
6








Word Processors
Databases
Spreadsheets
Presentation
Communications and
Browsers

Word Processing Functions
7



Type Documents/ Write letters


Edit and format text


Cut/ paste/ delete/ search and Replace



Change font/ color/ background




Create Columns



Generate Tables





Create Outlines/ templates

Insert Pictures/ Graphics

These functions would have been difficult without
word processor

Database Functions
8

 Store

data in the form of tables

 Each

entry is a record

 Data

are kept in an ordered form

 Sort

data (alpha or numeric)

 Match

data

 Merge

data

 Create

specialized reports

Spreadsheet Functions
9

Keep

data in forms of rows and columns

Perform
Sort

Calculations using formulae

data

Create
What

Charts/Graphs

if analysis

Presentation Functions
10

Displays

Text in an interactive way with

different effects
Supports
Creates
Inserts
Use

Navigation

Animation

or Creates Graphics, Sound and Video

for presentations

Browser Functions
11

 Searches/

display pages

 Bookmarks

web sites

 Hyperlinks

to text, virtual tours, etc.

 Rows

of buttons (Home/ backward and forwards/

options menu
 Favorites.

You can add and organize web sites

you have visited in Internet Explorer.

Communications Functions
12

 Allows

synchronous/asynchronous communications

 Sends/Receives

Text

 Sends/Receives

Video/Audio

 Sends/Receives

Attachments

 Archives

Messages

Considerations for using
Basic Applications
13







Word Processing Use with
information that can be paraphrased
or organized in meaningful ways.
Databases Use with information that
has repetitive patterns and can be
easily described.
Spreadsheets Use with sets of
numbers that may repetitive patterns
which can be described with at least
two variables (Row & Column).







Browser Use to access information
or to engage in interactive
learning.
Presentation Use to display
information that can be enhanced
by interactivity.
Communications Use when
interactivity with others will
enhance learning

Question
14



What is the difference between data and
information?

Introduction to Database





What is Data?
 Data are raw facts and figures
What is information?
 Information is processed data
 Example of processing: sorting, calculation, classification 

15

Information = data + meaning

Introduction to Database



What is a Database?
A collection of related data.



What is a Database Management System
(DBMS) ?
Software that manages and controls access to the
database



What is a Database System?
The DBMS software together with the data itself

16

File Base System
17


Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay on Unit 9 Alvarez
  • Computer Studies Essay
  • Visual Basic 6.0 Essay
  • Computer in Technology Essay
  • All About Visual Basic Essay
  • Essay about CGS 2167 Computer Applications syllabus
  • Essay on Questions on Computer Applications
  • computer application in business Essay

Become a StudyMode Member

Sign Up - It's Free