APPLICATION PRACTICE PACKAGE.

....Scoring life goals

The table shows the distribution of seats and textbooks to selected schools by the government of The Federal Republic of Nigeria.

SCHOOL	SEAT	BOOK
Queens College, Yaba	250	300
FGC, Enugu	250	250
Kings College, Lagos	350	400
FGC, Okigwe	190	180
FGC, Oyo	260	250
FGC, Benin	340	200
FGC, Sokoto	290	200
FGGC, Zamfara	185	180
FGGC, Umuahia	230	195
FGC, Okposi	150	145
FGGC, Kaduna	400	350

a) Open an MS-Excel environment and enter the data in the table.
(b) Using appropriate commands in MS-Excel produce;
(i) A composite bar chart to illustrate the distribution;
(ii) The sum of each commodity;
(iii) A pie chart for each commodity.

courtsey currentschool.

OBJECTIVES FOR WORD PROCESSING PACKAGE.

Please do a study of this for word processing package for each of the objectives:

Below is a list of objectives covered in the Word Package

.. · Add page breaks

 · Insert Headers and Footers

 · Align Text                                                                               · Insert Page Numbers

 · Change Zoom Settings                                                              · Insert Rows and Columns

· Changing Document Views                                                      · Insert text from a file

· Checking Individual Spelling and Grammar Errors                  · Mail Merge

 · Copy and move text                                                                    · Margins, indents, alignment, tabs

 · Create a Table · Move and Resize the Clip Art Object                 · Create a WordArt Object

 · Opening, Saving and Closing an Existing Document                  · Crop a graphic

 · Outline, Table of Contents & Index                                     · Cutting & pasting, copying & pasting

 · Print to printers (hard) and files (soft)                                 · Display Non Printing characters

· Set tabs Preview and print documents                               · Fonts, bold, italics, underlining, subscript & small caps

 · Set Text Wrapping options                                                  · Format page numbers

 · Shading, shadowing borders, color                                      · Format text and paragraphs

· Tracking changes & comments                                               · Highlight text

· Use filenames and folders for organizing documents                · Hyperlink

 · Use Find, Replace, and Go To                                        · Insert a Picture or Clip Art Object

· Use Format Painter                                                                 · Insert and delete text

 · Use Template documents, forms, etc.                             · Insert bulleted and numbered lists in a document

 · Use Undo and Redo                                                        · Insert fields in headers and footers

 · Used Advanced Positioning options for Clip Art

word-stydy-guide

POWERPOINT ACTIVTY

Prepare and present a 5 minute-PowerPoint presentation on “MY FIRST DAY IN SCHOOL”, using the guidelines below.

SLIDE 1: Type the topic for presentation in bold and upper case.

SLIDE 2: (a) Type the subtitle: “Presentation Outline”,

                 (b) Type the presentation outline item as follows:

                                   (i)   Name of school;

                                   (ii)  My first day in school;

                                  (iii)  The first place I visited in school;

                                  (iv)   An unforgettable experience on my first day in school.

            SLIDE 3: Describe each item on slide 2 above using a short sentence.

            SLIDE 4: (a) Type out the compliment for your audience.

                             (b) Insert a Clip Art object below your compliment.

            Save your work ON YOUR DESKTOP

            

courtesy...waec

EXCEL IF FUNCTION

check this link for the conditional IF function

https://www.youtube.com/watch?v=yTY60PVZaRg

DATA P[ROCESSING ACTIVITY

DATA P[ROCESSING ACTIVITY
NOTE:send answers as comment on the blog.Thanks.

(a) List: (i) Three application areas of a word  processing program
(ii)  Three  types of data item.

(b) Identify the four data types available in Table 2 below

Table 2
Student I.D.       Name          Date of Birth      Score in Computer studies           Gender
A 00022            Odi, G.A.        13/10/97                   38                                            M
C 00021          Zakari, M.         15/05/98                  71                                            M
B 00023      Ngozi Tella          16/09/96                     62                                           F

AP[P[LICATION P[ACKAGE....

Ndibaba corporation...ICT facilitator and sup[p[ort.

Open Excel to a blank worksheet.

Create a spreadsheet like the one below. Enter all the numbers.

o   Change the formatting of the numbers to dollars.

o   Make the grid around the cells visible.

o   Insert the title “Monthly Budget” and center and merge it.

§  Change the font to Baker Signet, size 18.

§  Make the text white and the fill black.

o   Insert the subtitle “January 2005 – June 2005.”

§  Change the font to Baker Signet, size 10

§  Make text white and fill black.

§  Center and merge it.

o   Total the expenses at the bottom of each month.

§  Widen columns if necessary so numbers can be seen.

o   Put a dark border around the edges of the document.

o   Change the amount for gasoline in June from $60 to $70.

o   Figure out the average for each row. You must know the formula on your own!

o   Center and bold the headings (months and average)

§  Change the font to BakerSignet on the headings

§  Bold the headings in column A.

§  Change the font to BakerSignet.

o   Add a header with your name.

  

NOTE:change the font to available one if you can not find the required font as instructed.

seasons GrEEtInGs..

APPLICATION PACKAGE PRACTICAL

Q1)

 In a new worksheet, create a table and insert the following information. Use different fonts for different columns.

1. Names of people (at least 20)

2. Their ages

3. Number of years they have worked

4. Salary per month

5. Show housing, medical, travel and hardship allowances, and columns


B. Using the table to do the following:

1. (a) Calculate the total salary for each person and grand total for all persons.
(b) Calculate Average, Minimum, Maximum.

2. Show a graph of the their salaries

3. Copy and paste your graph from sheet 1 to sheet 2, name your graph sheet ‘CHARTS’

4. Add columns where necessary to include: leave payment, over time payment and sick off amount, and then calculate the net salary