Comp 1ST Term Note
Comp 1ST Term Note
Computer Studies
Grade 11
1st Term Scheme of Work
ICT class: Getting started with web
Contents
Section A (objective questions) Answer all questions in this section
PRINCETON COLLEGE
9/33 Olatunde Onimole Street, Surulere, Lagos
Third Term Examination 2014 Session
CLASS: SS1
SUBJECT: Computer Studies TIME: 2hrs
SECTION A
1. The computer’s physical parts attached to the system unit are called
A. Hardware units B. Input units C. Output units D. Peripheral
7. Which of the following computing devices did not exist in the pre-computing age
to the 19th century?
A. Napier’s bone B. Abacus C. ENIAC D. Slide Rule
10. The property of a disk that determines the amount of data it may contain is
A. Size B. Volume C. Storage Capacity D. Storage power.
25.A modem and a telephone connection are provided. Other things needed to be
able to connect to a computer to the internet are
A. ISP account and utility software B. Browser and ISP account C.
ISP account and network D. Browser and printer
26.Which of the following software can be used for graphic production?
A. DOS editor B. PC writer C. CorelDraw D. Acrobat reader
29.Evaluate the BASIC statement LET Z = 4*W^2 + 2*Y (Given that W = 5 and Y = 10)
A. 50 B. 80 C. 100 D. 120
39.In a word processing environment the icon “X” will _________ a program when
clicked.
A. Close B. Delete C. Open D. Save
Assignment: Answer all then question in section B of the last term examination.
Objectives
At the end of the lesson students should be able to:
1 Define a database
2. State the benefit of a database
PERIOD: ONE
Contents
Definition of a database
Database can be defined as a collection of operational data (records) stored at a
central location for use by many different users.
A database is a single collection of data for one or more purposes stored with
minimum duplication of data items so as to provide a consistent and controlled pool of
For example, a schools’ database will contain data relating to the students, may
contain data relating to their academic results, school fees, accommodation, parent
information (and so on) for the purpose of managing the students. There can also be a
library database in a school, there can be a database comprising data from all sections
for the effective management of the school. Traditional databases are organized by
fields, records, and files. A field is a single piece of information; a record is one complete
set of fields; and a file is a collection of records.
BENEFIT OF A DATABASE
1. It removes unwanted data
2. It makes correct data available to the user
3. It manages large quantity of data or information
4. Quick, efficient storage and retrieval of data or information.
5. Good security of information
6. Efficient updating of information.
Evaluation
C. Instance D.Relationship
A.Word processing
B. creating databases
C. processing data
D.administrating databases
3. Because it contains a description of its own structure, a database is considered to
be ________ .
A.Described
B. metadata compatible
C. self-describing
C. Instance D.Administrator
6. A field of an entity that can be used to uniquely describe that entity is known as
A.Field B. Record
C. Key D.File
7. Except one, all of the following are benefits of database; which is the one?
A. It helps to avoid redundancy.
B. It manages large quantity of data or information.
C. It provides security.
D. It can be used to design graphical user interface.
Objectives
At the end of the lesson students should be able to state the different forms of database
organization.
Contents
Database Model (Structure)
A database model is a type of data model that determines the logical structure of a
database and fundamentally determines manner in which data can be stored,
organized, and manipulated.
Relational database structure is the most popular example of a database model it uses
a table-based format.
Although, there are many database models, yet the three basic database models are
• Hierarchical database model
• Network database model
• Relational database model
This hierarchy is used as the physical order of records in storage. Record access is done
by navigating through the data structure using pointers combined with sequential
accessing
NETWORK MODEL
The network model organizes data using two fundamental concept called records and
sets. Records contain fields. Sets define one-to-many relationships between records:
one owner, many members.
A record can be an owner in any number of sets, and a member in any number of sets.
Thus the relationship between records and sets is many-to-many.
Relational Database Model
Relational Databases are databases that store information in multiple tables that
are interrelated. In a relational database, a specific column of a table match a column in
another table
The relational model was introduced by E.F. Codd in 1970 as a way to make database
management systems more independent of any particular application.
A relational database uses tables with rows and column to show relationship amongst
data in database. Relational data is very useful in creating multiple tables linked together
using relationship.
Objectives
At the end of the lesson students should be able to:
1. define database management system
2. state different types of DBMS
3. state the features of MS Access
Contents
The database management system is a software that controls the storage,
retrieval and manipulation of data stored in a database.
Using a DBMS makes file easy to store, edit and retrieved effectively. Examples of DBMS
are: Microsoft Access, Dbase IV, Oracle, MYSQL, FoxBASE Plus, and Sybase.
Introduction to MS Access
Microsoft Access is a database management system (DBMS) and a complete
application development environment. Unlike some DBMS programs, Access includes
the tools you need to develop user-friendly interfaces and reports.
Features of MS Access: Interface Components
The Access 2010 user interface provides the ability to work with a database as a
complete file, and the ability to work with individual database objects. The three main
components to the Access 2010 user interface are:
Ribbon
Navigation Pane
A pane on the left side of the program window that displays database objects.
Backstage view
Evaluation
An Access database can contain various types of database objects, including tables,
queries, forms, reports, macros and modules. The following sections briefly introduce
database objects. All database objects can be accessed from the Access Navigation
Pane.
Tables
The basic building block of any database is a table. A database table is similar in
appearance to a list or spreadsheet, in that the data is stored in rows and columns.
The row and column layout is called a datasheet. Each row in the table is a record. Each
record consists of one or more fields, and each column in the table is a field. The
preceding figure shows the Datasheet view of a table named “Vendors.” The table
contains six records (rows), and each record is about a specific vendor. Notice that
each field (column) contains a specific category of information, such as name, address,
phone number and so on for each vendor.
Forms
Forms are commonly used as data entry screens. They are user-friendly interfaces for
working with data, and they often contain elements and command buttons that make
entering data and performing various other tasks quick and easy.
Queries
You use queries to extract subsets of data from one or more tables. The data you want
to retrieve may be stored in several tables, and a query allows you to view data from
several tables in a single datasheet. The result of a query is called a record set or result
set.
Reports
You use reports to print and summarize data. For example, a report such as the one
shown below can group customers by country, and then list pertinent contact
information. Each report is formatted to present the information in the most readable
way possible. You can format any report to fit your requirements and you can create
custom reports as well.
It is possible to run a report at any time and it will always reflect the current state of
the data in the database. Generally, the reports will be printed, but one can also view
them on the screen, export them to another application, or send them as email
messages.
Content
• Set field stdid to Primary Key (Not allow duplicate data for stdid) by Right Click
on that field and choose Primary Key
•
• Click <Ctrl-S> to Save the Table
Foreign Key
Foreign key is a primary key field of a table that exists to another table.
TYPES OF RELATIONSHIP
1. One-To-One Relationship
2. One-to-many relationship
3. Many-to-Many relationship
Simple Access Query
• Open Access 2010 and select a database. Click the "File" tab and select the
"Open" button. Select a database from the recent database list in the File menu
list.
• Click the "Create" tab and select "Query Wizard." Select "Simple Query Wizard"
and click "OK." In the "Tables/Queries" field, select the table that you want to
use in the query. Add field names by clicking the field name and clicking the right
arrow. Click "Next."
Evaluation
Assignment
Evaluation
1. Define Presentation Packages
2. Mention two examples of presentation packages
Assignment
State and describe features of presentation packages
Contents
1. Define PowerPoint
2. Identify various MS PowerPoint tools
3. Create a new PowerPoint Presentation
PowerPoint is a presentation program that you can use to create, edit, and manipulate
slides for on-screen presentations, sending via email, or promoting products or
services on a web page.
PowerPoint includes many features to enhance the look of presentations, including the
ability to set font and size, background color of each slide, animation, or transitions
that will help maintain consistency throughout your presentation.
To the right of the “office” button, in the title bar, we find the "Quick Access toolbar".
By default, this toolbar comes with the "Save", "Undo" and "Redo “buttons. The "Quick
Access" toolbar is the only toolbar wherein we can add or remove buttons. In the
middle of the title bar, we find the name of our file and the name of the application.
On the right side of the title bar we have the "Minimize" "Maximize" and "Close"
buttons.
Under the title bar, we have the "Ribbon". In the "Ribbon", we find all the commands
that can be used, in "PowerPoint".
Clicking a tab displays the various groups in the "Ribbon", depending on the selected
tab,.
For example, the "Home" tab has the "Clipboard", "Slides", "Font", "Paragraph,"
"Drawing" and "Editing" groups.
Creating a New PowerPoint Presentation
1. On a PC, click on the Start menu and select All Programs > Microsoft Office >
Microsoft PowerPoint 2010.
2. PowerPoint opens with the first slide displayed blank. Select the layout for your
presentation by clicking the Design tab.
3. The most commonly used design themes will appear in the center. To preview
more design options, click the down arrow.
4. Select a theme. Clicking it will apply the theme to all the slides in your
presentation.
5. The theme you picked will automatically create a title slide for your
presentation. Click in the appropriate areas on this first slide to type your title
and subtitle.
Creating a new slide
1. To create a new slide where you can add content, click the Home tab and select
New Slide.
2. Clicking the bottom half of New Slide will give you different new slide options.
3. When you've found a slide layout that works, double click it to add it to your
presentation.
4. Click in the various areas of the new slide to add text or images.
Tip
Each item on a PowerPoint slide is defined by a border around it. Items can be moved,
resized, or reformatted in many ways by clicking on them, and they can be copied,
pasted, or deleted at any time. This makes it easy to adapt slides to specific content.
1. Choose File > Save As. Give the presentation a name and be sure to save it in a
location where you can easily find it later.
Evaluation
Assignment
Create a new presentation
• Insert pictures
• Animate the presentation content
• Run a slide show
Objectives
At the end of the lesson students should be able to:
• Define Graphics
• List examples of graphics packages
• Set the features of Corel Draw Environment
Definition of Graphics
ü Paint
ü CorelDraw
ü Adobe Photoshop
ü Havard graphics
ü Print Master
ü Ventura
ü Photoshop Pro
ü Adobe Page Maker
Title Bar
Menu bar
Ruler: Horizontal and vertical borders that are used to determine the size and position
of objects in a drawing
Drawing window
Drawing page
The rectangular area inside the drawing window. It is the printable area of your work
area.
Color palette
A dockable bar that contains color swatches
Docker
Status bar
An area at the bottom of the application window that contains information about
object property such as type, size, color, fill, and resolution. The status bar also shows
the current mouse position.
Standard Toolbar
The toolbar provides quick access to commonly used features. The standard toolbar,
which displays by default, contains buttons that are shortcuts to many of the menu
commands.
The property bar changes dynamically depending on the tool being used and the
number of objects being edited.
The Toolbox
The Toolbox provides you with operational tools.
Tool Description
The Pick tool lets you select and size, skew, and rotate objects.
The Shape tool lets you edit the shape of objects.
The Knife tool lets you cut through objects.
The Eraser tool lets you remove areas of your drawing.
The Smudge brush tool lets you distort a vector object by dragging along its
outline.
The Roughen brush tool lets you distort the outline of a vector object by dragging
along the outline.
The Free transform tool lets you transform an object by using the Free rotation,
Angle rotation, Scale, and Skew tools.
The Virtual segment delete tool lets you delete portions of objects that are
between intersections.
The Zoom tool lets you change the magnification level in the drawing window.
The Hand tool lets you control which part of the drawing is visible in the drawing
window.
The Pen tool lets you draw curves one segment at a time.
The Polyline tool lets you draw lines and curves in preview mode.
The Freehand tool lets you draw single line segments and curves.
The Bézier tool lets you draw curves one segment at a time.
The 3 point curve tool lets you draw a curve by defining the start, end, and center
points.
The Artistic media tool provides access to the Brush, Sprayer, Calligraphic, and
Pressure tools.
The Dimension tool lets you draw vertical, horizontal, slanted, or angular
dimension lines.
The Interactive connector tool lets you join two objects with a line.
The Smart drawing tool converts the freehand strokes that you draw to basic
shapes and smoothed curves.
The Rectangle tool lets you draw rectangles and squares.
The 3 point rectangle tool lets you draw a rectangle by dragging to create the
rectangle baseline and clicking to define its
height.
The Ellipse tool lets you draw ellipses and circles.
The 3 point ellipse tool lets you draw an ellipse by dragging to create the center
line of the ellipse and clicking to define its
height.
The Polygon tool lets you draw symmetrical polygons and stars.
The Spiral tool lets you draw symmetrical and logarithmic spirals.
The Graph paper tool lets you draw a grid of lines similar to that on graph paper.
The Basic shapes tool lets you choose from a full set of shapes, including hexagram,
a smiley face, and a right-angle triangle.
The Arrow shapes tool lets you draw arrows of various shape, direction, and
number of heads.
The Flowchart shapes tool lets you draw flowchart symbols.
The Star shapes tool lets you draw ribbon objects and explosion shapes.
The Callout shapes tool lets you draw callouts and labels.
The Text tool lets you type words directly on the screen as artistic or paragraph
text.
The Interactive blend tool lets you blend two objects.
The Interactive contour tool lets you apply a contour to an object.
The Interactive distortion tool lets you apply a Push or Pull distortion, a Zipper
distortion, or a Twister distortion to an object.
The Interactive envelope tool lets you distort an object by dragging the nodes of
the envelope.
The Interactive extrude tool lets you apply the illusion of depth to objects.
The Interactive drop shadow tool lets you apply a drop shadow to an object.
The Interactive transparency tool lets you apply transparencies to objects.
The Eyedropper tool lets you select object properties, such as fill, line thickness,
size, and effects, from an object on the
drawing window.
The Paint bucket tool lets you apply object properties, such as fill, line thickness,
size and effects, to an object on the drawing
window after selecting these properties using the Eyedropper tool.
The Interactive fill tool lets you apply various fills.
The Interactive mesh tool lets you apply a mesh grid to an object.
The Fill tool lets you set the fill properties.
Assignments
1. List Three features in Corel Draw
2. State two areas of use of COREL DRAW
3. Design your logo using Corel Draw