Lesson Notes By Weeks and Term - Senior Secondary School 1

SUBJECT: DATA PROCESSING

CLASS:  SS 1

DATE:

TERM: 3rd TERM

REFERENCES

• Data Processing for Senior Secondary Schools by Hiit Plc.
• Modern Computer Studies by Victoria.
• Computing Essentials by Westpatterns Technologies Limited. 

 
WEEK SIX

TOPIC: SPREASHEET III

LOADING EXCEL APPLICATION

Click on all programs, check the programs and click on the Microsoft suites then click on the excel application.

CREATING EXCEL DOCUMENT

Once Excel is open, you can enter data into a file by clicking on a particular cell, then typing 

text, numbers, or formulas. Your changes will be entered into the current cell.

• Press the tab to enter your data and move the active cell to the right of the current one.
• Press enter key to enter your data and move the active cell to the next row, usually to the beginning of that row.
• Use the arrow keys to enter your data and move the active cell in the indicated direction.
• Press the end key, right-arrow key to move to the last cell in a row.

ENTERING DATA IN A WORKSHEET

Locate the cell where you want to enter data on the worksheet and click on the cell. For example point and click on cell A1.

Type in your entry from the keyboard and notice the appearance of the entries in the formula bar with the cell address.

Press ‘Enter’ key.

EVALUATION

1. What are the steps involved in creating a Spreadsheet?
2. Explain how to enter data into Excel.

EDITING DATA IN A WORKSHEET

Wrong entries may either be entirely re-typed or the particular cell/range of cells can be corrected. 

To retype:

Move the cell pointer to the cell to be corrected or re-type the entry and press ‘Enter’

To correct only the mistake:

Move the cell pointer to the cell and double click on the cell.

Make the correction by inserting, deleting or retyping.

Press ‘Enter’.

SAVING A WORKSHEET

Saving for the first time:

Click on ‘Home’ button,

Click ‘Save As’ button and wait for a dialog box to open.

Type in your desire filename (i.e. the name of the document).

Click ‘Save’ button or press enter on the keyboard.

Saving while working (after the first saving).

Click on ‘save’ icon on the Quick Access tool bar or click on ‘office button’ to open the menu.and click ‘save’ from the options.

RETRIEVING A SAVED WORKSHEET

Retrieving a worksheet means to open an already saved worksheet from its location in the computer. This is usually done to view, edit or update the worksheet.

Load/start Microsoft Excel

Click on ‘Office Button’ 

Click ‘Open’ option from the list and wait for a dialog box to open.

Navigate to the file you want to open and double click on it. 

GENERAL EVALUATION

1. Define a cell.
2. State steps involved in saving a worksheet for the first time.
3. Highlight the steps in retrieving a saved document.

READING ASSIGNMENT

A Handbook on Computer Studies for Schools and Colleges by NiyiAdekolegan

WEEKEND ASSIGNMENT

1. ___ is a collection of cells organized into rows and columns where data is stored and manipulated.  A. Worksheet B. Graph C. Workbook D. Active cell
2. ___ is a space in a worksheet formed by the intersection of a row and a column.

1. Workbook B. Sheet C. Cell D. Cell Reference.

1. There are ……… rows per worksheet in Excel. A. 1,048,576 B. 1,048,765 

1. 1,408,576 D. 1,022,333

1. There are ___ columns per worksheet in Excel. A. 16,387 B. 16,384 C. 16,684

1. 15,341

1. The address of a cell is known as ___ A. Cell space B. Cell reference C. Cell Menu

1. Active cell

THEORY

1. Highlight the steps in saving a worksheet
2. In Excel, what do you understand by the term “retrieving”?

WEEKSEVEN

TOPIC: DATABASE MANAGEMENT I

Database is an application that is used to store information in a structured way. It is a collection of records or data in an organized form.

A database management system is a collection of computer software that enables users to define, create and maintain a database. A database management system (DBMS) is a computer application that interacts with the user, other applications and the database itself to capture and analyse data. The general purpose of database management system (DBMS) is designed to allow the definition, creation, querying and administration of database. The DBMS serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remain easily accessible. Database Administrators are those that control the database system. They also control the access and security aspects of the database.

FUNCTIONS OF DBMS

A DBMS makes it possible for users to create, edit and update data in database files. The functions also include

• Concurrent access to the same database at the same time.
• It creates security rules to determine access right of users.
• It improves the integrity of the data in the database.
• It also provides data dictionary for description of data.

 EVALUATION

• What do you understand by database management?

• Who is a database administrator?

EXAMPLES OF DATABASE MANAGEMENT PACKAGES

There are varieties of database management system. Some of these are:

1. Microsoft Access: it is a DBMS developed by Microsoft. It stores data in its own format based on the access jet engine. It has the facilities like importing or linking directly to data stored in other databases.
2. MySQL: it is an open source DBMS. One of the most popular DBMS. 
3. Oracle: it is an object relational database management system.
4. Microsoft SQL server: it was developed by Microsoft. The primary function of this software is to store and retrieve the data as requested by other applications, whether those applications are on the computer or running on other computer across the network.
5. Filemaker: it was begun as a MS–DOS based computer program. It is a cross platform relational database management system.

DATABASE TERMINOLOGIES:

• Rows: are the records.
• Column: is vertical and labeled alphabetically.
• Field: is a group of related characters in a file
• Character: is a single symbol in a file.
• Record: is made of a number of fields that are related together and treated as an entity.

GENERAL EVALUATION

1. List other types of database applications apart fromMs-Acess.
2. List three database terminologies and explain them.
3. What is a record in database?
4. Mention two database packages and briefly on them.

READING ASSIGNMENT

Data Processing for Senior Secondary Education by HiiT Plc.

WEEKEND ASSIGNMENT

• The person that controls the entire database system is called ___ A. database manager. B. database analyst C. computer Analyst D. database administrator.

• A collection of computer software that enables users to define, create and maintain a database is refers to as ___ A. database program B. database management 

1. computer software D. database pro

• One of these DBMS began with MS- Dos. A. MS-Access B. MySQL C. Corel 

1. Filemaker

• The general purpose database management system (DBMS) is designed to allow all except one.  A. definition B. creation, C. querying D. multiplying

• Concurrent in database management means….A. to access by many people at once 

1. One person at a time C. both A and B D. none

THEORY

• List and explain three examples of DBMS.

• List three functions of DBMS.

• Compare Row and Record.