SCHEME OF WORK FOR COMPUTER JSS 2

SCHEME OF WORK FOR COMPUTER JSS 2
1. Classification of computer
2. Concept of the computer system, component of computer system
3. The computer system, the hardware component
4. The computer system, the software and people ware
5. Computer software and type of software
6. Operating system
7. Unit of storage in computer
8. Computer files and file organization, data hierarchy

USING COREL DRAW

How to use Corel Draw. Using Corel Draw to draw the rectangle and add text. The toolbox helps you create, shape, colour, and edit graphics from a set of fly outs and buttons. In the procedure below, you will begin to create a new name tag by using the rectangle, text and shape tools.

COMPUTER GRAPHICS PACKAGE

A graphic is a digital representation of drawing, chart or photographs. It can also be called a picture or image which contains no motion or animation. Graphic package is an application that can be used to create and manipulate images on a computer. Computer graphics are used in many applications including science, engineering, advertising, multimedia production etc. They are related to all activities where static and animated pictures and images are created, processed, manipulated using specialized hardware and computer software. Data in form of images are easy to understand and interpret.

MICROSOFT POWERPOINT

What is Microsoft Power Point?
Microsoft PowerPoint is a presentation program that is incorporated in Microsoft Office suite package. It offers word processing, outlining drawing, graphing and presentation management tools

Starting a presentation with Microsoft PowerPoint

There are two ways of starting Microsoft PowerPoint

Click on start button, choose All Programs and click PowerPoint
Double click on the icon of PowerPoint document and PowerPoint opens with the document already loaded.

PRESENTATION PACKAGE

A presentation package is a software package used to display information in the form of a slide show. It provides the resources necessary to give a professional presentation for meetings, lectures, speeches or other similar situations. It enables graphic images to be inserted and manipulated in slide show.

Examples of presentation package

Microsoft PowerPoint
Lotus Freelance graphics

INTERNET (PRACTICAL ON INTERNET)

E-mail is a method of sending digital messages from one computer to another. E-mail is short for Electronic Mail. E-mail is received instantly by the users email provider and mails stay in the mailbox until accessed by the users. Mail boxes have storage limit (limited amount of emails which they can hold and once full you cannot receive any more email until you delete older messages).

To use email, you must have an email address. Email address can be web based (like yahoo mail or Gmail or hosted internally like outlook express on the school computer).

Creating a yahoo mail account

Steps to yahoo account

Open the browser and go to login.yahoo.com/account/create or edit.yahoo.com/registration. A page will show up with registration form at the center of the page.
Type your “first name” in the first field box
Type your ‘last name” in the second field box

FILE ORGANISATION

File organisation refers to the way in which data is stored in a file and the methods by which it can be accessed. Database is stored as a collection of files. Each file is a sequence of records. A record is a sequence of fields. Data is usually stored in the form of records.

Records usually describe entities and their attributes e.g. an employee record represents an employee entity and each field value in the record specifies some attributes of that employee such as Name, Birth_date, salary etc. Organizing a file depends on what kind of file it happens to be.

NORMAL FORM

Normalization of Database

Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like insertion, updates and deletion Anomalies.

It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables.

Normalization is used for mainly two purposes.

Eliminating redundant (useless) data
Ensuring data dependencies make sense i.e. data is logically stored.

DATA MODELLING

Data modeling is a process used to define and analyze data requirements needed to support the processes within the scope of corresponding information system in an organization.

Creating simple data mode

Microsoft Access offers one table, queries, forms, reports, macros and modules and these will be created before creating a data model.

Table: All data are stored in table i.e. MS. Access stores data in tables and can exist as a simple file that allows basic data as a single file that allows basic data storage and retrieval.
Query: This is used to add, change, delete or update data in database. It enables one to find or operate on the data in the tables.
Forms: These are screens used for displaying data. It is a screen that displays the output of data.
Reports: This is used for outputting of data. It is a screen that displays the output of data.
Pages: This is used to enter or display data online.

DATA MODEL

Data Model can be defined as abstract model whose purpose is to describe how data can be used and represented effectively. A data model is a picture or description which shows how data are to be arranged to serve a specific purpose it determines the structure of data and the information is to be contained, how the information will be used and how items in database will be related to each other.

Types of data model

Database model
Data structure diagram
Entity-relationship model
Geographic data model
Generic data model
Semantic data model
Database Model: A databa

COMPUTER ETHICS AND SAFETY

COMPUTER ROOM MANAGEMENT AND ETHICS.

Ethics is a set of principles that govern the behaviour of a group of individuals. Computer ethics are set of moral rules or principles that regulate the use of computer. This deals with ways of taking good care of computer room.

DATABASE APPLICATION

DATABASE APPLICATION:
STARTING MICROSOFT ACCESS

To start Microsoft Access, follow the steps below:

Click start button, the program menu
Move to the MS Office menu
Click on MS Access

Once Access is running, an initial screen will be displayed. From the initial screen, you can either (i) create a new blank database (ii) open an existing database

Choose blank database and specify a new filename for the database.

Click on the OK button to create the new database. Creating a table using the design view tables is the foundation of every database.

APPLICATION SOFTWARE

Application Software:
These refer to the program used to solve a particular type of problem or variety of similar problems. Mostly, application programs are produced by an organisation for its specific tasks.
Types of application software
There are two major types of application software. These are:
(1)Users’ Application Program
(2)Application Package
Users’ Application Programs: These consist of programs written specifically for individual application. They are also called customized software

UTILITY PROGRAMS AND TRANSLATORS

TRANSLATORS are programs used in converting programs written in other languages to machine language. They are also called language processors. The computer can only execute programs written in machine codes.
UTILITY PROGRAMS refer to programs designed to help analyse, configure, optimize and maintain the computer. They focus on low the computer resources operate. They reside in the memory until summoned by the user or the operating system.

WORD PROCESSING

Word processing software is used to manipulate a text document, such as a resume or a report. You typically enter text by typing, and the software provide tools for copying, deleting various type of formatting.

Word processor is an electronic device or computer software application, which performs the task of composing, editing, formatting and printing of documents. 

Some of the functions of word processing software include:

Creating, editing, saving and printing document
Copying, pasting, moving and deleting text with a document
Formatting text, such as font type, bolding, underlining or italicizing
Creating and editing table
Inserting elements from other software, such as illustrations or photographs.
Correcting spelling and grammar.

OPERATING SYSTEM

Operating System is a set of programs which takes over the operation of the computer to the point of being able to allow a number of programs to be run on the computer without intervention by an operator. It acts as an interface between the user and the hardware. It controls and allocates hardware resources on the computer. 
Examples are MS DOS, MS Window, Linux, Unix, Novell, Macintosh, PC DOS, Android, etc.

FUNCTION OF OPERATION SYSTEM

It serves as the communication link between user and the hardware.
It controls selection and operation of input and output devices.
It handles file operation
It gives a complete record of all that happens during processing.

COMPUTER SOFTWARE

Computer Software is refers to collection of programs (instructions) that cause the hardware to work. A program is a written instruction for a computer to perform a specific task.

These are thousands of programs that one can run on a computer. For instance, a graphic program can be used to design an album greeting cards, a word processor can be used to type a letter, memo or term papers.

Computer software is so important that without it, no computer system can work.

TYPES OF SOFTWARE