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