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

APPLICATION PACKAGE PRACTICAL REVIEW

ACTIVITY

A spreadsheet is require to predict cash flow for a company over the four quarters of a year. Open a blank spreadsheet, enter in the data below and save it as IBIM ACTIVITY 

Month	Jan-Mar	Apr-Jun	Jul-Sep	Oct-Dec
Opening Bank Balance:	€20000
Expenditures
Wages:	€2340	€2340	€2340	€2340
Electricity:	€760	€860	€960	€1060
Overheads:	€1080	€1280	€1480	€1680
Materials:	€6000	€6500	€7000	€7500
Total (expenditures)
Sales Income:	€13290	€13290	€13290	€13290
Profit this quarter
Closing bank balance:

1. Enter in formulae to calculate 'Total (expenditures) for each quarter. (The sum of all the individual expenditures)
2. Enter in formulae to calculate the 'Profit' for each quarter. (Sales income less Total expenditures)
3. Enter in formula to calculate the closing balance for each quarter (The Opening balance plus the profits)
4. Enter in formulae for the 'Opening balance' for each quarter after the first one (=the closing balance of the previous quarter)

QUESTIONS PREVIEW

Q1) Calculation the following table using appropriate application package

SN	Month	Income	Expenses	Saving
1	January	12000	8000
2	February	18000	12000
3	March	15000	23000
4	April	14000	11000
Total

 Calculate Saving as Income - Expense using Table Formula.

 Calculate Total Income, Expense and Saving.

Q2  Sort  out the following  into :manual input devices,direct input devices,and sensors

                Keyboard,scanner,MICR,OCR,light sensor,remote control,barcode reader,camera,temperature sensor,magnetic stripe reader