Scribd
Upload
16 views9 pages

PDC 211 Lectulast

The lecture covers the fundamentals of databases, explaining the concepts of records and fields, and how to create a table in a database. It provides step-by-step instructions for entering data into a table and emphasizes the importance of proper organization. Additionally, it discusses the use of charts in Excel for data analysis and offers guidance on creating charts from data sets.

Uploaded by

lanre adigun
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views9 pages

PDC 211 Lectulast

The lecture covers the fundamentals of databases, explaining the concepts of records and fields, and how to create a table in a database. It provides step-by-step instructions for entering data into a table and emphasizes the importance of proper organization. Additionally, it discusses the use of charts in Excel for data analysis and offers guidance on creating charts from data sets.

Uploaded by

lanre adigun
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 9

LECTURE

PDC 211- COMPUTER APPRECIATION


By Engr. Arolu K. A. Mnse.
Database
Database - a data set distributed in rows and columns for
easily searching, organizing and editing.
All information in the database is contained in the records
and fields:
Record is database (DB) line, which includes information
about one object.
Field is the column in the database that contains information
of the same type about all objects.
In database terminology, rows are called Records, and
columns are called Fields.
A Table as a Database

A table is a type of database where the data is organized


into rows and columns:
Each column represents a database field, which is a single
type of information, such as a name, address, or phone
number;
Each row represents a database record, which is a
collection of associated field values, such as the
information for a specific contact.
Creating a Table
When entering records, keep these guidelines in mind:
Do not leave any blank rows in the table. This includes not
leaving a blank row between the column headings and
the first row of data.
A record must contain data about only one specific item.
A record must also contain all the data in the database
about that item. There can't be information about an item
in more than one row.
Steps in creating a Table
 Step 1: Make sure you have all the required columns and name each
heading properly
 Step 2: Once the headers of the data table are clear, we can easily start
entering the data just below the respective column headings.
 Step 3: Fill all the data carefully.
 Step 4: The final thing you need to do is to convert this data to an excel
table. By selecting the data, press Ctrl + T. (Here you need to make sure
My data has a header checkbox is ticked, and the range is selected
properly.)
 Step 5: Click on OK to complete the table creation.
 Step 6: Give a proper name to the table under the table design tab.
CHART(Data analysis)
Excel is the best tool for database analysis.

A chart is a visual representative of data in both columns and


rows. Charts are usually used to analyse trends and patterns in
data sets
Create a chart
 Select data for the chart.
 Select Insert > Recommended Charts.
 Select a chart on the Recommended Charts tab, to preview the
chart.
 Note: You can select the data you want in the chart and press ALT +
F1 to create a chart immediately, but it might not be the best chart
for the data. If you don’t see a chart you like, select the All
Charts tab to see all chart types.
 Select a chart.
 Select OK.
What is Microsoft Excel?
What is the correct formula to calculate the total of the score
Questions?

You might also like