27

SS1 Data Processing Lesson Notes Plan- Third Term. To get complete notes and plan for week 5-10, reach out us.

SS1 DATA PROCESSING SCHEME OF WORK

WEEK TOPIC

1. REVISION.

2. WORD PROCESSING I.

3. WORD PROCESSINGII.

4. WORD PROCESSING III.

5. SPREADSHEET I.

6. SPREADSHEET II.

7. SPREADSHEET III.

8. DATABASE MANAGEMENT I.

9. DATABASE MANAGEMENT II.

10. DATABASE MANAGEMENT III.

11. REVISION.

12. EXAMINATION.

REFERENCES

• Data Processing for Senior Secondary Schools by Hiit Plc.

• Modern Computer Studies by Victoria.

• Computing Essentials by Westpatterns Technologies Limited. 

Read Also: SSS3 Mock English Essay Past Question: Continuous Writing Practice

WEEK ONE

TOPIC: WORD PROCESSING

Word processing is the phrase used to describe using a computer to create, edit and print documents. It is also the creation, input, editing and production of a document with a computerized device. A word processing package enables you to type in and manipulate text.  It helps you to enter, store, format, copy and print text.  It is software that turns the computer into a sophisticated typewriter. The word processing software allows you to determine how you want the finished page to look i.e. page size, line, width, margin etc.  Once you are satisfied that everything looks all right, you can print out any number of copies on paper.

BASIC FEATURES

The basic functions are 

• Text editing 

• Word wrap 

• Creating documents.

• Text can be typed, inserted, deleted. 

• Text can also be centered between left and right margins.

• Headers and footers

• Page numbering.

 

Functions include layout setting, copy, move, search and replace text can be copied or moved within the document and any occurrence of text can be replaced with another block of text.

MICROSOFT WORD

EVALUATION

1. What is word processing?

2. What is the difference between a text editor and a notepad?

USES OF WORD PROCESSING

1. It allows saving of works for future purposes.

2. Word processing packages come with many handy features such as borders, text layout etc.

3. It allows plenty of professional quality document templates.

4. Easy to detect and correct mistakes.

5. It allows correction of spellings and grammar.

6. Inserting elements from other software such as illustrations and photographs.

GENERAL EVALUATION

1. What do you understand by text editing?

2. Explain header and footer.

3. State uses of word processing.

4. Mention three basic functions of word processing.

READING ASSIGNMENT

Computing Essentials by Westpatterns Technologies Limited, P. 24

WEEKEND ASSIGNMENT

1. A phrase that is used to describe using a computer to create, edit and print documents is known as __ A. word processor B. word processing C. ms-word D. corelprocessing

2. ___ enables you to manipulate texts. A. Processing B. word processor C. Ms-Corel 

D. Corel

3. Word processing packages come with these features except……A. borders B. margins 

C. templates D. images

4. All of these is an advantage of Word processing except……  A. easy to detect errors. B. it allows professional works. C. documents are not safe. D. none

5. Features of word processing include all except………..A. copy B. page Numbering C. imaging Text D. margin alignment.

THEORY

1. What is the difference between a text editor and a notepad?

2. List THREE basic functions of a word processing.

WEEK TWO

TOPIC:WORD PROCESSING II

Examples of Word Processor: 

A word processor is a computer software application that performs the task of creation and printing of electronic documents. There are several types of word processors; they include Word Perfect, Word Star, MS-Word, Loco Script, Ami-Pro, Word Craft, and WordPad etc.

1. Microsoft Word: it is part of the Microsoft office suite. Word consistently wins the title of the most widely word processing program worldwide. Besides basic word processing functions. Word also has desktop publishing capabilities. All the Microsoft office programs have the capacity to work together. An excel worksheet can exist within a word document. Word also has the power to easily merge with Excel lists or from an access database files.

2. Corel Word Perfect: word perfect suite contains several software programs essential for business and home users. The suite comes with WordPerfect word, QuattroPro spreadsheet program, Corel presentations and WordPerfect mail.

3. OpenOffice: The OpenOffice suite includes a word processor, spreadsheet, presentation program, database and graphics editor. As with Microsoft office, the OpenOffice programs also work with one another.

EVALUATION

1. Define word processor.

2. List the types of word processors.

The simplest programs that do word processing are known as text editors. These programs are designed to be small, simple and cheap. Almost all operating system made comes with at least one text editor built in. most editors are saved files in a special format called ASCII (American Standard Code for Information Interchange). Text editors are wonderful programs. The most common text editor is the notepad which comes with windows. Others are:

• Edit which comes with Disk Operating System (DOS).

• SimpleText which comes with Macintosh.

The major difference between a text editor and word processor is that word processors have special features that are used to beautify texts. They have varieties of colors and other icons while the text editors can only accept text with little features such as changing of font’scolors, sizes, etc. The common type of text editor is the notepad that comes with window systems.

GENERAL EVALUATION

1. Why is Microsoft Word preferred over other word processor?

2. Differentiate between a text editor and a word processor.

3. List two types of text editor.

4. What is Microsoft word?

READING ASSIGNMENT

Computing Essentials by Westpatterns Technologies Limited. P. 25

WEEKEND ASSIGNMENT

1. Computer software that performs the task of creation and printing of electronic documents is called…….A. word package. B. word Processor C. excel package 

D. corelpage

2. Which of these word processors has the ability to merge Excel lists? A.corel word     B. word perfect C. microsoft word D. pagemaker

3. The “Ms” in Ms-Word stands for…………A. miss B. miscellaneous C. macros        D. microsoft.

4. Word processor includes all except………….A. word perfect B. word corel C. word Star D.  Loco Script

5. Microsoft Word is preferred to other word processing packages because A. it is cheap B. it is more friendly C. it accepts data faster D. none

THEORY

1. State the benefits of Microsoft word over other word processors.

2. Name other programs that come with Corel Suite.

WEEK THREE

TOPIC:WORD PROCESSING III

CREATING A WORD DOCUMENT

Click on the start icon to display the start icon to display the start menu and then click on the Microsoft word icon. The program gives you an empty one to type.

HOW TO SAVE A DOCUMENT

• Start a new document in word and type your text.

• Click file in the top left hand corner of the screen.

• From the menu, choose save as.

• A ‘Save As’ dialogue box will come up. It will show the folder where you will be saving. 

• Type in the name of your document and click save.

NOTE: You can also save your document using the shortcut “Ctrl S”

 

SAVING FORMATS

Documents can be saved in different file formats depending on what purpose you intend to use it for. Click on the down arrow to the right save in section of the dialog box, which will display a drop down menu, choose the file format you want for your document. File formats include HTML, PDF, RTF etc.

OPENING MS WORD DOCUMENT

• On the menu bar, click file and then click open icon. 

• Click the folder and the file you want to open.

• Click the file.

• Click open.

 

GENERAL EVALUATION

1. Highlight steps in loading word document.

2. Explain how to create ms word document.

3. Highlight how to save a new document in ms word.

4. List two types of document format.

 

READING ASSIGNMENT

Essential Computing by Western Patterns. P. 21

 

WEEKEND ASSIGNMENT

1. File option is always in the……… hand corner of the screen. A. left hand B. right handC. middle hand D. none

2. A ‘save’ dialogue box will come up when you click ___ A. edit B. save C. Open D. A and B

3. All except one are examples of text editor. A. Edit B. SimpleText C. Both A and B D. None

4. Word processor includes all except ___ A. word perfectB. word corel C. word star 

D. loco script

5. The last step when saving a document is —- A. click open B. click on save C. rename your folderD. C and B

 

THEORY

1. Highlight how to create a word document.

2. How do you save your document in a different format?

WEEK FOUR

TOPIC:SPREADSHEET I

DEFINITION OF SPREADSHEET: A spreadsheet is a collection of cells organized into rows and columns where data is stored and manipulated. The spreadsheet is known as worksheet. A spreadsheet begins with row number one and column A. A cell is a space in a worksheet formed by the intersection of a row and a column. Each cell can contain a number, text or formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook. Each cell has an address called Cell Referencee.g. A1, B3, C7 etc. combination of more than one sheet is referred to as workbook. The worksheets can accept thousands of rows of data and columns in form of fields.Active Cell is recognized by heavy border surrounding. It is the cell that is currently worked upon.

A SPREADSHEET

CONTENT OF SPREADSHEET

When you are setting out a spreadsheet, you have to enter values, labels and formulas.

• VALUES: Values are those numbers you already know before starting the spreadsheet operation. These values are inserted into cells of the spreadsheet.
• LABELS: Labels are words you enter to explain the values. You would not just enter a list of numbers without explanation. Putting labels next to each of the numbers makes it easier for to check it through.
• FORMULA: Formulas are the mathematical equations you insert into the cells. Formulas are commands that instruct the computer on what to do.

EVALUATION

1. Define a worksheet.
2. What do you understand by cell reference?

USES OF SPREADSHEET

There are various uses of spreadsheet. It uses varies according to the intended purpose. Some of its uses are as follows:

1. Spreadsheets are used for administrative functions. 
2. Spreadsheets are used for creating reports.
3. They are used for preparation of daily sales.
4. They are used in computing school results.
5. They are used for project budgeting control.
6. They are used for drawing balance sheets.
7. Excel can store and calculate the data as directed using existing data.
8. Spreadsheet can be used for analysis and decision making.
9. It makes calculations much easier than working things out yourself.

GENERAL EVALUATION

1. State the uses of spreadsheet.
2. Excel can be used to create analysis, Explain.
3. What is an active cell?
4. What are the contents in spreadsheet?

READING ASSIGNMENT: Modern Computer studies by Victoria, page 25

WEEKEND ASSIGNMENT

1. A cell can also reference another cell in the same……..A. worksheet B. workbook 

1. cellular D. sheet

1. Spreadsheet can be used for data analysis and…………making A. cell B. decision 

1. data D. reference

1. The………….. can contain thousands of rows of data and columns in form of fields. A. cell B. worksheet C. reference cell D. excel
2. The cell that is been currently worked upon is known as ……………cell. A. current B. active C. reference D. initial
3. A ……….. can also reference another cell in the same worksheet. A. cell B. sheet 
4. worksheet D. none

THEORY

• Define an active cell.

• List and explain the THREE major contents in a spreadsheet.
• Related:SS1 Data Processing Lesson Notes Plan- Third Term