Avel-COVID19-Comp Sc & others-ND1- COMPUTER PACKAGES 1

COVID – 19 SIT@HOME

INTEL DEV. CLASS

ND COMPUTER SCIENCE

COMPUTER PACKAGES 1

BY

Committee of Intellectuals [CoI]

@

INTELLECTUAL DEVELOPMENT CONFERENCE CENTER [INTEL CENTER]

COURSE TITLE: COMPUTER PACKAGES I

COURSE CODE: COM 123

QUESTIONS

1a.        Define the following (i) Word Processor (ii) Word Processing  (iii) Smart Art  (iv) Watermarks (4 marks)

b.         State the method to do the following: (i) Save a new MS Word document in compatibility mode (6marks)

(ii) To insert 3 columns            (iii) To insert Header & Footer           (iv) To add buttons to the Quick Access Toolbar

c.          State the name and function of the labeled components of MS Office Word 2007 screen below: (10marks)

2a.       Explain the Spreadsheet application package and state five (5) tasks you can accomplish with it (7marks)

b.         Explain the following (i) Charts   (ii) Relative address    (iii) Absolute Address       (iv) Function  (v) Full handle                         (5marks)

c.          State the name and function of the labeled components of MS Office Excel 2007 screen below: (8 marks)

3ai.      What is a Program Generator?                                                                      (4 marks)

ii.          List any three (3) Examples of Program Generator                                                 (6marks)

bi.        Differentiate between Application Software and Program generator       (4marks)

ii.          What is the importance of SOFTWARE as a component of a computer system?  

c.          Enumerate and explain the three (3) basic hardware sections in computer system         

4ai.      What is the purpose of a computer software acquisition process?               (4 marks)   

ii.          State any three (3) purchased Software as described in computer software Acquisition process                                                                                     (3 marks)

bi.        What do you understand by a BOOTLEGGED Software?                          (2 marks)

ii.          List any three (3) criteria for acquiring software packages                          (6 marks)

ci.         Explain the Package acceptability                                                                (2 marks)

ii.          List four (4) features that must be in place before any package can be accepted

iii.         Explain any two (2) features in c(ii) above                                                  (4 marks)

5ai.      What is a Presentation?                                                                                 (2 marks)

ii.          Mention the four (4) ways you can create a Presentation and explain any two (2) of them                                                                                                                   (6 marks)

b.         State the name and function of the labeled components                           (4 marks)

c.          State the procedure to do the following in MS Office PowerPoint

(i) To add Theme to a presentation   (ii) To apply WordArt  (iii) To add video to a Presentation                                                                                                            (6 marks)

6a.       Define the following: (i) Themes (ii) Slide Animation  (iii) Slide Transition  (iv) WordArt    (v) Handout                                                                           (5 marks)

bi.        State the elements in an MS Office Excel formula                                       (4 marks)

ii.          State the two variants of formula for linking MS Excel worksheets                        (5 marks)

c.          Highlight the steps to create a Chart in MS Excel and give any six (6) examples of charts you know                                                                                           (6 marks)

7ai.       Define System Software                                                                                (4 marks)

ii.          List three (3) types of System Software                                                       (3 marks)

bi.        What is an Operating System?                                                                      (5 marks)

ii.          Mention five (5) functions of Operating System                                           (5 marks)

c.          Distinguish between a tailor – made Application Software and a ready – made Application software with two (2) examples each                                              (8 marks)

COMPUTER PACKAGES I

1a.       Define the following (i) Word Processor (ii) Word Processing  (iii) Smart Art  (iv) Watermarks

1ai.       WORD PROCESSOR: This is a  software program which provides a graphical user interface with better capabilities than a text editor does OR it is a program that allows one to create, edit, format and print document.

ii.          WORD PROCESSING: This is a type of application software used in the production, storage and manipulation of text on a computer or word processor

iii.         SMART ART: This is the collection of graphics one can utilize to organize information within document.

iv.         WATERMARKS: This is a translucent image that appears behind texting a document i.e. options available for picture and text

b.        State the method to do the following: (i) Save a new MS Word document in compatibility mode (6marks) (ii) To insert 3 columns          (iii) To insert Header & Footer   (iv) To add buttons to the Quick Access Toolbar

bi.        SAVING A DOCUMENT

• Click the Microsoft Office button and click save or save as (OR)
• Press CTRL + S            (OR)
• Click the file icon on the quick access toolbar

ii.          TO INSERT 3 COLUMNS    

• Place the cursor on the page you want the column
• Click the insert tab of the Ribbon
• Click the tables button on the table group
• Click insert table and enter the number of rows and columns i.e. (0 rows, 3 columns)

iii.       TO INSERT HEADER & FOOTER  

• Click the insert tab on the Ribbon
• Click header or footer
• Choose a style
• The Header/Footer Design tab will display on the Ribbon
• Choose the information that you would like to have
• Click the close header and footer button when you are done

iv.         TO ADD BUTTONS TO THE QUICK ACCESS TOOLBAR

• Right click on button in the Ribbon
• It is on add to quick access toolbar

c.         State the name and function of the labeled components of MS Office Word 2007 screen below:

c.          1 =>TITLE BAR: Name of the file and application

2 => RIBBON: Made tabs, each tab is made up of group of commands

3 => RULER: To determine page margins

4 => QUICK ACCESS TOOLBAR: Causes commands to be added or removed

5 => VIEW BUTTON: It display different view of the document

6 => ZOOM SLIDE: Used to magnify the applicate window

7 => STATUS BAR: Display information about the document in terms of pages, current pages displayed, word usual e.t.c.

8 =>MS OFFICE BUTTON: Displays file menu of the previous version of word

9 =>SCROLL BAR: Used to reveal hidden part of the windows

10 =>DOCUMENT WINDOW: Work environment area

2a.      Explain the Spreadsheet application package and state five (5) tasks you can accomplish with it

2a.       Spreadsheet is a programmable application that mostly operates on rows and columns of numbers on the screen for an automated calculation

• Forecasting
• Payroll
• Balance sheet presentation
• Result processing
• Preparation of budget

b.        Explain the following (i) Charts   (ii) Relative address    (iii) Absolute Address         (iv) Function       (v) Full handle                   

bi.        CHARTS: These are used to display information in a diagrammatical form. It is a pictoral representation of data.

ii.          RELATIVE ADDRESS: This is an address that reference cells based on the cells current location and will change if the cell holding the formular is copied 

iii.         ABSOLUTE ADDRESS: This is an address that reference cell using their specific addresses and does not change if the cell holding the formular is copied.      

iv.         FUNCTION: This is an inbuilt formula for automated calculation.            

v.         FULL HANDLE: This is a cell pointer’s box that can be clicked and dragged to extend any copy cell’s contents.                                 

c.         State the name and function of the labeled components of MS Office Excel 2007 screen below:

c.          1 =>ACTIVE CELL: It functions as the cell selected in the worksheet

2 =>NAME BOX: Used to display the address of the active cell

3 =>FORMULAR BAR: Used to create formula

4 =>COLUMN HEADERS: Used to identify different columns

5 =>ROW HEADERS: Used to identify different rows

6 =>WORKSHEET TABS: Used to navigate between worksheet in a workbook

7 =>NEW SHEET BUTTON: Used to add new worksheet in a workbook

8 =>SHEET TAB SCROLLING BUTTON: Buttons to scroll the sheet tabs in the workbook

3ai.     What is a Program Generator?                                                            

3ai.      Program Generator is a software program that enables an individual to create a program of their own with less effort and programming knowledge.                                                                                 

ii.        List any three (3) Examples of Program Generator                                   

ii

• Adventure Maker
• Alice
• Stage Cast

bi.       Differentiate between Application Software and Program generator           

bi.        Application Software are software programs to solve specific problems e.g. spreadsheet, accounting software e.t.c. WHILE Program generator is a software program that can be used to help to creates other computer programs e.g. Alice, Adventure maker e.t.c.

ii.        What is the importance of SOFTWARE as a component of a computer system?        

ii.          The importance of SOFTWAREis to tell the computer                   

• What to do
• How to do it               (and)
• When to do it 

c.         Enumerate and explain the three (3) basic hardware sections in computer system

c.         

• Central Processing Unit (CPU)
• Motherboard
• Disk drive

• CENTRAL PROCESSING UNIT (CPU): This is the electronic circuitry with a computer that carries out the instructions of a computer program by performing the basic arithmetic, logical, control and input/output operations specified by the instructions.

• MOTHERBOARD: This is one of the most essential parts of a computer system. It holds together many of the crucial components or a computer, including the CPU, memory and connectors for input and output devices.

• DISK DRIVE: This is a device implementing such a storage mechanism. Noteable types are the hard disk drive containing a non-removable floppy disk, and various optical disc drives and associated optical disc media.

4ai.    What is the purpose of a computer software acquisition process?             

4ai.      The purpose of a computer acquisition procedure is to formalize a uniform standard for computer software acquisition throughout the District                                    

ii.        State any three (3) purchased Software as described in computer software Acquisition process                                                                                              

ii.

• Lease Software
• Bootlegged Software
• Printed Software

bi.       What do you understand by a BOOTLEGGED Software?              

bi.  A Bootleggedis a software applications that are illegally distributed or sold. It similar with privacy and music, audio and video are also consider as part of bootlegged software

ii.        List any three (3) criteria for acquiring software packages                    

ii.         

• Buying from software developer
• Rating from software house
• Buying from software vendors

ci.        Explain the Package acceptability                             

ci.         Package acceptability is the act of a software package been allowed or accepted.

ii.        List four (4) features that must be in place before any package can be accepted

ii.         

• The package must meet users need
• The package should be affordable to those that need them
• The package must meet up with the processing requirement
• The package must be reliable

iii.       Explain any two (2) features in c(ii) above  

iii.

RELIABILITY OF PACKAGE: This is to ensure that the highest possible package reliability standards are achieved and sustained.

MEET USERS NEED: This is to ensure that needs that a user has or the percentage, and which that service must satisfy for the user to get the right outcome of the packages.

5ai.     What is a Presentation?                                                             

5ai.      A Presentation is a collection of slide used to convey information to a selected or targeted audience.

ii.        Mention the four (4) ways you can create a Presentation and explain any two (2) of them

ii.

• Blank slide
• Existing presentation
• Word outline
• Templates

CREATING A PRESENTATION FROM A BLANK SLIDE

• Click the Microsoft Office button
• Click new
• Click blank presentation 

CREATING A PRESENTATION FROM A TEMPLATE

• Click the Microsoft Office button
• Click new
• Click installed template or browse to select the template of your choice 

b.        State the name and function of the labeled components            

b.         1 =>SLIDE: It shows the thumbnail image of slides

2 =>OUTLINE TAB: It shows the content of the slides

3 =>SLIDE PANEL: This is where one enter the content of slides

4 =>NOTES PANEL: This is where note is entered

c.         State the procedure to do the following in MS Office PowerPoint

(i) To add Theme to a presentation  

(ii) To apply WordArt 

(iii) To add video to a Presentation

ci.         TO ADD THEME TO A PRESENTATION  

• Click the design tab
• Choose one of the display them   
•  

ii.          TO APPLY WORDART 

• Click on the insert tab in the Ribbon
• Click on the Word Art option in the text section
• Select the type of Word Art you want
•  

iii.         TO ADD VIDEO TO A PRESENTATION

• Click on insert from the Ribbon
• Click on Video in the media section
• Choose video from file or line, adjust and edit

6a.      Define the following: (i) Themes (ii) Slide Animation  (iii) Slide Transition  (iv) WordArt            (v) Handout                                                                       

6ai.      THEMES: This are designed template that can be applied to an entire presentation that allow for consistency throughout the presentation. 

ii.          SLIDE ANIMATION: These are defined as special effect that can be added to object in a presentation to make them appear animated

iii.         SLIDE TRANSITION: This are effect that are in place when one switch from one slide to the next.

iv.         WORDART: This is a quick way to make text stand out with special effects.

v.         HANDOUT: This is efficient for distributing slides. It can be printed with one, two, three, four, six, or nine slides on a page.

bi.       State the elements in an MS Office Excel formula              

bi.       

• Sheet 1
• Sheet 2
• A
• A1

ii.        State the two variants of formula for linking MS Excel worksheets

ii.         

• Sheet 1 : A1 + Sheet 2 : A1
• Sheet 1 : A : + A1

c.         Highlight the steps to create a Chart in MS Excel and give any six (6) examples of charts you know     

c.          CREATING A CHART IN MS EXCEL

• Select the cell you want the chart
• From the insert tab, click the desired that command
• Choose the desired chart type
• The selected chart will be inserted in the worksheet
• Prechart
• Multiple bar chart
• Graphs
• Histogram
• Component bar chart
• Simple bar chart

7ai.     Define System Software                                      

7ai.       System Software can be defined a software that comes with the system from the manufacture. Hence they are used to tell the computer what to do, how to do it and when to do it.

ii.        List three (3) types of System Software                                  

ii.

• Operating system       Utility Softwares         Application Softwares

bi.       What is an Operating System?                                                 

bi.        An Operating System is a system software that manages computer hardware and software resources and provides common services for computer programs. It performs operations such as scheduling task and controlling peripherals.

ii.        Mention five (5) functions of Operating System     

ii.

Data security              Disk management                  Device controlling

Printing controlling      Memory management          

c.         Distinguish between a tailor – made Application Software and a ready – made Application software with two (2) examples each

c.         

TAILOR MADE APPLICATION SOFTWARE	READY MADE APPLICATION
Training will have to be imported every time a new person is recruited	Trained accounting persons are easily available
It expensive as the development cost is loaded in one software	The price of the software is determined on the basis of number of pieces to be sold
Have facility of secondary back up	Do not have facility of secondary backup
They are software prepared for particular uses	They are software prepared for general users
Examples are PowerPoint, Word Processing e.t.c.	Example are spreadsheet presentation e.t.c.

COURSE TITLE: COMPUTER PACKAGES

COURSE CODE: COM 123

QUESTIONS:

1a(i)     What is the function of the ‘thesaurus’ as used in Ms-Word?                                  

(ii)        Briefly explain ‘cut’, ‘copy’ and ‘paste’ as used in Microsoft environment   

b(i)      Differentiate between ‘print’ and ‘print preview’                                                    

(ii)        List the toggle buttons that you know                                                                    

c(i)       How would you add headers or footers to a document in Ms-Word?                    

(ii)        Distinguish between a ‘special-purpose’ and a ‘general-purpose software package.

2a(i)    Define Word Processing                                                                                             

(ii)        List any four (4) examples of Word Processing Packages that you know              

b(i)      Highlight the steps involve in protecting a document in Ms-Word              

(ii)        State any five (5) items on the Menu bar in Ms-Word                                           

c(i)       What steps are required to create a section break in a document?                       

(ii)        Ms-Word is an example of presentation package; True/False                                

3a(i)    List any five (5) criteria for selecting a software package                                       

(ii)        Mention two (2) advantages and two (2) disadvantages of software packages 

b.         Differentiate between the following:

(i)        Off-shelf application software and custom made application software                

(ii)        Compliers and Interpreters

c(i)       What is an Operating System?                                                                                 

(ii)        Mention any four (4) functions of an operating system                                          

(iii)       Itemise the types of operating systems that you know                                          

4a(i)    What is a Spreadsheet package?                                                                             

(ii)        List any three (3) examples of a(i) above

b.         Enumerate the steps required to change the height of row(s) in a worksheet      

c(i)       What is an active cell?                                                                                               

(ii)        List the steps required to exist Ms Excel                                                                   

d(i)      List and explain the three (3) types of dates in Ms-Excel                                        

(ii)        Mention any two (2) importance of Ms-Excel                                                          

5a.       Differentiate between the following pairs:

(i) Relative and Absolute reference                                                                         

(ii) ‘Save’ and ‘Save As’                                                                                             

b.         Briefly explain the following features of an application software:

            (i) Toolbar       (ii) Dialog box             (iii) Clipboaords          (iv) Buttons               

c.          What steps are required to create a table of six(6) rows and five (5) columns in Ms-Word

d.         with respect to Ms-Word window, describe the following:

(i) Menu bar               (ii) Formatting toolbar                                  

6a.       Define the following concepts in Ms-Excel

(i) Workbook              (ii) Worksheet             (iii) Cell                                               

b(i)      What is the purpose of the ‘Find’ and ‘Replace’ as used in Ms-Word                     

(ii)        Mention the ways by which you can align text in Ms-Word                        

c.          Briefly explain the following technique by which the operating system manages programs and data:

• Multitasking                ii.          Multiprogramming     iii.         Multiprocessing                                                                                              

ANSWEES:

1a(i)   What is the function of the ‘thesaurus’ as used in Ms-Word?                                           Thesaurus is used to provide word nearest in meaning in Microsoft word

(ii)      Briefly explain ‘cut’, ‘copy’ and ‘paste’ as used in Microsoft environment               

            Cut: Is used to permanently remove a text or object from one location to other

Copy: Is used to make a duplicate of text or object

Paste: Is used to place a cut/copied text or object to the point the cursor is blinking

b(i)     Differentiate between ‘print’ and ‘print preview’                                               

Print: is a command used to send a document to the printer in other to have the hard copy

Print Preview: is a command used to determine the outlook of a document. It gives how the document will look like after printing

(ii)      List the toggle buttons that you know                                                                                    Bold, Underline & Italic

c(i)      How would you add headers or footers to a document in Ms-Word?                            

1. Click on view from the main menu    ii.          Click on Header and Footer

(ii)      Distinguish between a ‘special-purpose’ and a ‘general-purpose software package.

            A Special Purpose Package: Is a customized type of application package designed to meet the need/requirement of a particular organization e.g. packages used by various banks

A General purpose package is a general type of application package that is common to everybody computer users e.g. Microsoft Office, Corel Draw e.t.c.  

2a(i)   Define Word Processing                                                                                      

            Word processing is the act of typing and formatting text, numbers, characters e.t.c. using a particular word processor

(ii)      List any four (4) examples of Word Processing Packages that you know                                            Microsoft Word, Word Star, Word Perfect, Multimate

b(i)     Highlight the steps involve in protecting a document in Ms-Word                               

            Click on file from the main menu

Click on Save As

Enter Fine Name 

Click on Tools

Click on Security Options

Enter password to open and modify

Click Ok

Click Save

(ii)      State any five (5) items on the Menu bar in Ms-Word                                                                   File, Edit, Insert, View, Format, Table, Window

c(i)      What steps are required to create a section break in a document?                               Click on insert on the main menu

Click on break

Select page break from the break types

Click Ok

(ii)      Ms-Word is an example of presentation package; True/False

            False

3a(i)   List any five (5) criteria for selecting a software package                                                           

I. Purpose        II. Size on disk             III. Interactivity           IV. User friendly

V. Reliability

(ii)      Mention two (2) advantages and two (2) disadvantages of software packages      

            Advantages

It makes work easier

It makes work faster

Disadvantages

Some customized application packages are expensive

It procure extra cost (operator)

b.        Differentiate between the following:

(i)        Off-shelf application software and custom made application software                            

(ii)        Compliers and Interpreters

            Compiler is a special type of program, which is used to translate an entire high-level language program referred to as the source code into a machine language equivalent of the program.

Interpreter: an interpreter is a program used to convert and execute high level languages by actually executing the source program rather than translating them for execution on the machine.

c(i)      What is an Operating System?                                                                         

An operating system is a master program that coordinates and manages the activities of a computer system.

(ii)      Mention any four (4) functions of an operating system                                                                Functions of Operating System

1. It controls the usage of stored data
2. It controls files management
3. It allows user to instruct the computer
4. It handles communication among computer components

(iii)     Itemise the types of operating systems that you know

Single User Operating System

Multi-User Operating System

4a(i)  What is a Spreadsheet package?                                                                                 

A spreadsheet package is an application program that is in form of a table comprising of rows and columns used for mathematical, statistical, financial (e.t.c.) analysis.

(ii)      List any three (3) examples of a(i) above

            Micro Excel, Lotus 1, Lotus 2

b.        Enumerate the steps required to change the height of row(s) in a worksheet         

            Steps required to change height of rows in a worksheet

1. Place your cursor on the top of the boarder of the row
2. Click and drag to the top when the cursor changes to a 4 edges cross       

c(i)      What is an active cell?                                                                                         

An active cell is the cell that is ready to receive data in excel, its identified by a thick boarder around the cell

(ii)      List the steps required to exist Ms Excel                                                                                 

d(i)     List and explain the three (3) types of dates in Ms-Excel                                                 

(ii)      Mention any two (2) importance of Ms-Excel

1. It is used for statistical analysis
2. It is used for financial analysis / calculations
3. It’s used to compute result

5a.      Differentiate between the following pairs:

(i) Relative and Absolute reference                                                                                     

(ii) ‘Save’ and ‘Save As’                                                                                                          Save: is a command used to save a file for the first time

While

Save As: Save As is a command used to change the properties of a saved file. It’s used to rename a filename, change the location of storage e.t.c.

b.        Briefly explain the following features of an application software:

            (i) Toolbar    (ii) Dialog box        (iii) Clipboaords     (iv) Buttons                        

Toolbars: This is a bar comprising of different types of working tools that helps to facilitate designing of different types on application packages.

Dialog box: A dialog box is a box that provides a particular information on a particular task, it always have a close button and an help button.

Button: Button is a command in form of an image used to perfore a definite task e.g. the save button, close button e.t.c

c.         What steps are required to create a table of six(6) rows and five (5) columns in Ms-Word

                        Click on table from the menu bar

Click on insert

Click on table

Change number of rows to 6 and columns to 5

d.        with respect to Ms-Word window, describe the following:

(i) Menu bar                        (ii) Formatting toolbar               

            Menu bar: The menu bar is a bar that comprises of the following menus

File, Format, Window, Edit, Tools, Help, View, Table

Formatting toolbar: Formatting toolbar consist of functions that can be used to format text and images in Ms-Word, this includes font styles, toggle buttons, aligns e.t.c.

6a.      Define the following concepts in Ms-Excel

(i) Workbook                      (ii) Worksheet                    (iii) Cell                                            

• A workbook is a saved file in Excel. A workbook is the combination of two or more worksheets
• A worksheet is a table like comprising of rows and columns on which data is stored in Ms-Excel
• A cell is Ms-Excel is the intersection of a row and column

b(i)     What is the purpose of the ‘Find’ and ‘Replace’ as used in Ms-Word                           

Purpose of Find and Replace? Find and Replace in Ms-Word is (Find) used to locate the position of a particular word in an Ms-Word document, and found words will be highlighted for east recognition while (Replace) is used to change a particular word to another.

(ii)      Mention the ways by which you can align text in Ms-Word                                            

            Align Left                    Align Centre                Align Right                  Justify

c.         Briefly explain the following technique by which the operating system manages programs and data:

• Multitasking
• Multiprogramming
• Multiprocessing          

            Multi-tasking: This allows more than one program to run concurrently

Multi programming: This is when more than one processes is being processed                                                           simultaneously. 

Multiprocessing: This supports running a program on more than one CPU.