NATIONAL INOVATION DIPLOMA
LECTURE SLIDES
COURSE TITLE: Introduction to Computer Application
Packages
COURSE CODE: ICT 121
CREDIT UNITS: 5
SEMESTER: 1
YEAR: 1
COMPUTER APPLICATIONS PACKAGES
Computer Package Acquisition
Definition/description
• The selection of software and its installation poses identical
problems in big organizations, department offices , small offices
and individuals
• Economic conditions of SMEs, available low-cost hardware,
software industry expansion and limited sources of information
don’t make it any easier
• It is nevertheless a very important issue as it can either make or
mar the business
COMPUTER APPLICATIONS PACKAGES
Computer Package Acquisition
Stages of Acquisition
• Identifying the need & defining the job
• Formulate software acquisition strategies
• Selecting the optimal software & putting it into operation
• Monitoring the efficiency of the software selected &
deciding about its maintenance
COMPUTER APPLICATIONS PACKAGES
Computer Package Acquisition
Stages of Acquisition
• Identifying the need & defining the job
Problem Solving
Efficiency
Cost in terms of labor and facility
Accuracy
COMPUTER APPLICATIONS PACKAGES
Computer Package Acquisition
Stages of Acquisition
• Types of Acquisition
Development by corporates
Off-the-shelf purchase (individuals)
• Formulate software acquisition strategies
Produce software in-house
Commission tailor-made packages from a software house
Acquiring application package from a software house
COMPUTER APPLICATIONS PACKAGES
Computer Package Acquisition
Stages of Acquisition
• Selecting the optimal software & putting it into
operation
Organizational type & Purpose
Special & Environmental Projects
Skills-set available in organization
Project management based on strategic planning & skills
distribution
COMPUTER APPLICATIONS: SOFTWARE
Computer Package Acquisition
Stages of Acquisition
• Monitoring the efficiency of the software selected & decide
on the maintenance and updates
Software monitoring – the observation & tracking of all operations and activities involving
users, applications & network services
Software maintenance & update – after purchase service offered to product user for correcting
issues, software modifications and adaptive maintenance to protect the PC and keep software
service functional
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Purpose – for writing formal and informal documents. An easy but well
ordered and professional way to present one’s thoughts and ideas. A
program that enables one to create, edit, format, store and print
documents
Word Processing – writing of letters, memos, job application, query,
formal complaint, note taking, newspaper and magazine publication write-
ups, periodic reports, scientific reports (hard copy, soft copy)
Examples– Microsoft Word, Open office writer, Google Docs, Microsoft
Works, Word Perfect, Notepad
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Terminologies (basic definitions)
Word Processing
Microsoft office
Features & Modus Operandi (MO)
MS Word Application
Application tools
Document handling & Processing
Various operations on MS Word
Automatic save settings
Formatting
Formatting text
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Formatting
Formatting Paragraphs – creating columns
Formatting pages – header & footer
Proof reading a document
Insertion Options
Graphics
Styles, Clip Art, Page break
Adding tables
List
Output command
Using mail merge
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Output command
Track changes – under review button in ribbon
Table of content + references & citations
Setting tab stops
Managing page layout
Printing documents
New options
Design
Transition
View
Tell me
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Other word processing applications
Open office
Notepad
Proof reading a document
Word Perfect
MS Works
Word star
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Terminologies (basic definitions)
Word Processing
A program that enables one create, edit, format, store and print documents. A
means of formal and informal documentation in an ordered and professional
presentation.
Microsoft office (MS office)
MS office is a suite of applications used for data and information processing to
generate intelligible presentation – to enlighten or convince in proposals, to
report on investigation/research. In the suite includes the following:
COMPUTER APPLICATIONS: SOFTWARE
Microsoft Word Microsoft office
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Terminologies (basic definitions)
Microsoft office (MS office)
MS Word – word processing using texts in writeups presented on a plane
background as lines of sentences. Several sentences are arranged together as
paragraphs and some data are arranged in tables
MS Excel – for word and number processing. Is used mainly to gather
numerical data (with option for some comments in texts) in tables and various
layouts of rows and columns as well as charts and diagrams to graphically
present the data collated
COMPUTER APPLICATIONS: SOFTWARE
Microsoft PowerPoint Microsoft Excel
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Terminologies (basic definitions)
Microsoft office (MS office) continued
MS PowerPoint – enables the creation of multimedia presentation
(audio, text and video)in a summarized report containing important
information highlighted into bullet points.
MS Access – a Data Base Management System application i.e. an
application that collates, orderly arrange and store large amounts of
data; an information bank that allows for easy retrieval of parts or all
of the required information
COMPUTER APPLICATIONS: SOFTWARE
Microsoft Word Microsoft Access
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Terminologies (basic definitions)
Microsoft office (MS office) continued
MS InfoPath – enables the design and distribution of online and offline
forms which can be completed (filled) and submitted electronically or used
to develop forms for documentation that could be printed.
MS Publisher – an MS office application specifically for publishing.
Unlike MS word it gives greater options for page layout and various
designs. Can be used to design and create greeting cards, calendars,
newsletters and business cards
COMPUTER APPLICATIONS: SOFTWARE
Microsoft Publisher Microsoft InfoPath
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Terminologies (basic definitions)
Microsoft office (MS office) continued
MS Outlook – application that runs and manages file sharing.
MS OneNote – file and information gathering application. Also
powerful in multi-user collaboration
General concept in MS office Applications
What You See Is What You Get
WYSIWYG
Also related to Garbage In Garbage Out
The user is in control, You design, create, edit, modify, discard, rebuild and eventually
present
COMPUTER APPLICATIONS: SOFTWARE
Microsoft Outlook Microsoft OneNote
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS PACKAGES
System Software (Operating System
Software)
Software Component
• A Desktop is a digital workspace
used to perform tasks
COMPUTER APPLICATIONS: SOFTWARE
System Software – OS
Desktop - Work Environment
Windows, Apple Mac
Features – Screen Layout, Toolbars, Icons
Toolbars – Active operations, default or pinned operations, Start
dialog options, hidden icons, settings for date & time, connectivity
notifications
Icons – Folders/Files (Legacy; Customized)
Screen Layout – background/wall (pixel, contrast/display), other
features to be detailed
COMPUTER APPLICATIONS: SOFTWARE
Computer Application Packages
Application Platforms & Tools
Platforms
Cloud-Based Applications: Applications that are developed in the Cloud (cyber/virtual
platform) and run on the internetwork
Desktop-Based Applications: Applications that require installation on the computer
and are used offline on the computer
Mobile Applications: These are specifically developed to run on mobile server/clients
Platform Applications
MS Office suite is an Application for all platforms
COMPUTER APPLICATIONS: SOFTWARE
Computer Application Packages
Application Platforms & Tools
Platform Applications
Cloud-Based Applications
Google Docs
Microsoft 365
DropBox/Google Drive
Desktop-Based Applications
Windows File Explorer
Adobe Photoshop
Skype
Mobile Applications
Facebook
Instagram & Twitter
Snapchat & Pinterest
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Microsoft Office Applications
Microsoft Word
Features – Screen Layout, Toolbars, Ribbons
Toolbars - Quick Access toolbars, title bars, scroll bars, status
bar, Mini toolbar
Ribbons – dialog box launchers, buttons, Drop down menu
Screen Layout – startup button, status bar and task bar, desktop
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
COMPUTER APPLICATIONS: SOFTWARE
Assignment
Study word processing applications
Revise and research further the features & tools of MS word
PBL …………………….
Developing of table of contents
Developing mail merge
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Ribbon tabs and its features
Actions to be simulated
Use of keyboard in typing – short-cuts, to initiate text editing (text highlighting
& cursor positioning)
Editing and formatting texts – insert & styles
Proofreading
Page formatting – page layout & Print layout
Creating Table of contents, References & Citations
Creating mail merge
Use of key board in typing
keyboard short-cuts, use of letters B to Z and Ctrl
Initiating text editing – Positioning cursor (home, end, add ctrl, x-clicks, Ctrl +
A)
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Ribbon tabs and its features
Editing & Formatting texts
Insert – tables, etc.; ClipArts, Gaphics, etc.
Use of styles and font editing
Other features like paragraphing, font style, etc.
Proofreading
Thesaurus, dictionary
Synonyms
Checking sentences and paragraphs plus apostrophes
Page Formatting
Page layout
Print layout
COMPUTER APPLICATIONS: SOFTWARE
Editing &
Formatting
Inserting
tables &
charts
COMPUTER APPLICATIONS: SOFTWARE
Proof
Reading
Thesaur
us
Synony
ms
COMPUTER APPLICATIONS: SOFTWARE
Page
Formattin
g
Text editing
COMPUTER APPLICATIONS: SOFTWARE
Page
Formatting
Text editing
COMPUTER APPLICATIONS: SOFTWARE
Page
Formatting
Print Layout
COMPUTER APPLICATIONS: SOFTWARE
Quiz 1
1. List 4 types of tool bars you know?
2. Define what a computer is?
3. List the elements of a Computer System with at least one
example each
4. What are the features on the word document window?
5. a. How would you define a desktop?
b. List the features on the desktop task bar?
COMPUTER APPLICATIONS: SOFTWARE
Answers to Quiz 1
1. List 4 types of tool bars you know? 2 marks
Scroll bar, Quick Access tool bar, Status bar, Title bar
2. Define what a computer is? 1.5 mark
A computer is an electronic device (machine) that accepts data (input) processes it
to generate useful information some of which can be stored
3. Name the 2 parts of a computer & give two examples of each 2 mark
Computer hardware – Mouse, Monitor, Keyboard
Computer Software – Operating System, Applications
Procedures – Protocols
User – Humans mainly
COMPUTER APPLICATIONS: SOFTWARE
Answers to Quiz 1 continued
4. What are the features on the word document window? 2 marks
Status bar – document pages, word count, magnification tool, text language
Title bar – document title, minimize, maximize & close options
Ribbon – tabs, groups & commands or options
5. a. How would you define a desktop?
A mobile workspace 1 mark
b. List the features on the desktop task bar?
Start button, running applications, hidden icons, calendar & date settings
1.5 marks
COMPUTER APPLICATIONS: SOFTWARE
Assignment
Write a 15 page term paper about why you chose the
course you are offering
This assignment is individual and not group work so each person’s work must be
unique
The term paper will be based on your specialty unit – NSS, CSE, CHE, TT & MT
The title should be ‘Why I would like to Study Computer Software’
Assignments must be submitted by close of business Tuesday – 19/03/2019
Practice table of content by helping people who have project work or term papers
to submit
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Ribbon tabs and its features
Creating table of contents
The first step is to create/ design a cover page
Decide on the position/page for the table of contents
Insert page numbers on all pages
Introduce text/write up on the subsequent pages after the table of contents page
Make sure the chapters/sections are highlighted as the headings on their pages
Select heading styles (under home title bar go to the styles tab) for each
chapter/section title
Go to the page designated for table of content & select
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Ribbon tabs and its features
Creating table of contents
Go to the ‘table of contents option’ under the references tab
From the table of contents drop down list select your preferred table
of content style
Once the above option is selected, your new table of content is
displayed on the selected page
Modify the appearance of the table of content to your liking
Then update the table of content either manually or automatically
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Ribbon tabs and its features
Creating mail merge
a. Open a blank/new page
b. Go to the mailing tab and select the Start mail merge option
c. On the Start mail merge option click the drop down menu to select step by step mail
merge wizard
d. A menu option’s list opens up to the right of this document
e. The list on the menu displays the following options - Letters, E-mail messages, Envelopes,
Labels & Directory
f. Lets select letters to send to a group of people; these letters can each be
personalized.
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Ribbon tabs and its features
Creating mail merge
g. Having selected letters simply follow the instructions below by clicking the
hyperlink – Next: Starting document
h. On the new menu option tick – Use the current document
i. This means you prefer to use the document you are working on
j. At this point continue to follow the directions i.e. click the hyperlink below
– Next: Select recipients
k. In the new menu side list we will for this course prefer to use the option –
Type a new list
l. After selecting ‘type a new list’ then click the hyperlink - create
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Ribbon tabs and its features
Creating mail merge
m. A dialogue box pops up titled – New Address list
n. The buttons at the bottom of the dialogue box are – Find (pops up saved
data), customize column (to modify or add options for address list), New
entry (adds a new address row), delete entry (removes an existing
address)
o. Select ‘customize column’ so you can remove and add some customer
requirement
p. Having completed the ‘customize columns’ option press enter key and
now complete the address information
q. Having completed the address details click the ok button
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Ribbon tabs and its features
Creating mail merge
r. A dialogue box pops up to allow the saving of this newly created file as
speechdatasource (file name is My Data source which is in the My Document
folder)
s. And then click save; Also do not forget to save this new file
t. Click the Next hyperlink – Write your letter
u. Start your letter on the blank sheet (2 inches from the top) by writing the date
v. Then press enter twice and enter the address block by clicking address block on
the right side menu option
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Ribbon tabs and its features
Creating mail merge
w. Write your letter, particularly the body with exception of
information in the tables
x. When completely written click – Preview letter
Page Layout
References: Bibliography
COMPUTER APPLICATIONS: SOFTWARE
Word Processing
Quiz
1. Reference points in a document are created using which command (a)
bookmark, (b) Hyperlink,(c Email,
2. Which menu enables you to add content to the table of contents a. update
table, b. Add text, c. Add bookmark
3. By default, a footnote is placed in which of the following locations. A.
beginning of document, b. end of document, c. end of page
Answer True OR False
4. Only text formatted with a heading style can be included in a table of
content
5. A bookmark is a reference point in a document
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application
Spreadsheets – MS Excel
Actions to be simulated
Spreadsheets
Introduction to Excel
Create new work sheet, edit rows and columns
Importing & exporting data, graphics, etc. (creating &
modifying graphics)
Names in formulae, for ranges of cells, locating required data
Sorting & filtering data
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated
Calculating subtotals & Auditing worksheet
Perform what-if-analysis
Creating dynamic tables & charts to analyze data (can be
published online as interactive web page)
Application – forecasting project, financial analysis, production
scheduling & control, other forms of modelling
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application
Spreadsheets – MS Excel
Actions to be simulated
Spreadsheets – Interactive computer application for
organization, analysis and storage of data in tabular form
Introduction to Excel – The excel worksheet: a.
Rows(numbers), b. Columns(letters), c. Cell(letter & number), d.
Worksheet (verticals & horizontals), e. Workbook (worksheets
[Sheet Tab]), f. Formula bar, g. Name box,
COMPUTER APPLICATIONS: SOFTWARE
MS
Excel
New/
Blank-
work
sheet
COMPUTER APPLICATIONS: SOFTWARE
MS
Excel
File Menu
Account
COMPUTER APPLICATIONS: SOFTWARE
MS Excel
File Menu
Options
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated
Create new work sheet - Ribbon Tabs – Home, Insert, Page
Layouts, Formulas, Data, Review, View; edit rows and columns
Importing & Exporting data, graphics – includes modifications,
Special Paste
Data names, formulae bar, for cells, ranges of cells,
locating required data - edit rows and columns (Ribbon Tabs –
Home, Insert, Page Layouts
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated
Sorting & filtering data – arrange in alphabetical order,
classification
Calculating subtotals & Auditing worksheet
Creating dynamic tables & charts to analyze data
Dynamic tables & charts (to analyze data) published online
as interactive web page
COMPUTER APPLICATIONS: SOFTWARE
MS Excel
Data
Data
validation
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS Excel
Quiz
1. An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is
available (a. A dialog box or task pane, b. An additional workbook, c. A list of work sheets,
2. Which feature enables you to preview headers and footers, page breaks and other features that will
print? (a. Page Layout, b. Print Layout, c. Screen tips)
3. Which of the following is the intersection of a row & column. (a. range, b. tab, c. cell)
4. Which of the following starts with Save, Undo and Redo and can be customized to contain the
commands you use most frequently. (a. A worksheet, b. The Ribbon, c. The Quick Access Toolbar)
5. The columns in a worksheet are identified by numbers (True/False)
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated
Perform what-if-analysis – using the what-if-
analysis option (Scenarios, Goal Seek & Tables)
Application – forecasting project, financial analysis,
production scheduling & control, other forms of modelling
Identifying Accounting Packages – Peachtree,
DacEasy, Sage, QuickBooks
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated
Review of areas covered – the computer, hardware &
software, software (System software, Program generators &
Application Packages), Application Packages examples, application!!!
Review of Assignment – actual assignment instructions,
actual table of contents, descriptive steps for table of content & mail
merge
Subsequently – Previous page and next page
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Application
Production Scheduling & Control – forms of
modelling and dynamic tables, excel workbooks as
interactive webpages
Accounting & Financial Management – the use of
accounting packages, areas of necessity, details
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
APPLICATION
Accounting & Financial Management
Preparation of financial statements
Preparation of financial disclosures
Mostly big organizations
Monitoring cash flow, controlling costs and improving profitability
And what about accounting?
Skilled in math, book-keeping, auditing, financial analysis & reporting
COMPUTER APPLICATIONS: SOFTWARE
THE NEED FOR ACCOUNTING & FINANCIAL
ANALYSIS
COMPUTER APPLICATIONS: SOFTWARE
THE NEED FOR ACCOUNTING & FINANCIAL ANALYSIS
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS Excel
APPLICATION
Accounting & Financial Management
Financial Management – the practice of management to efficiently and
effectively manage funds in such fashion as to facilitate the accomplishment of
organizational objectives
Accounting – (accountancy) the measurement, processing and communication of
financial information about economic entities e.g. small & medium scale businesses,
corporates
The need? – timely and accurate reports, automation of management reports,
efficient invoicing & records, well managed general ledger
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated
Identifying Accounting Packages:
DacEasy,
Sage,
QuickBooks
Peachtree
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated
Perform what-if-analysis – using the what-if-analysis option,
definition, types (Data tables, Goal Seek, scenarios)
Definition – the manipulation of data while employing formulae
in cells to assess various scenarios or instances
Calculate (Data Tables) – Principal (1,000,000), Interest Rate
(5%), Duration/Time (10)
COMPUTER APPLICATIONS: SOFTWARE
DURATION PAYMENT
Formula PMT (Rate/100, Time/12, Principal)
10
15
20
25
30
COMPUTER APPLICATIONS: SOFTWARE
Loan 100000
Interest 2.00%
Term (Years) 30
= PMT
Monthly Payment
(I/12,Rx12,Principal)
COMPUTER APPLICATIONS: SOFTWARE
Formula = Monthly Payment, Enter
1.00%
1.25%
1.50%
1.75%
2.00%
COMPUTER APPLICATIONS: SOFTWARE
LOAN 200000
INTEREST 3.00%
TERM 30
MONTHLY
=PMT(i/12,Tx12,Principal)
PAYMENT
COMPUTER APPLICATIONS: SOFTWARE
1.00% 1.25% 1.50% 1.75% 2.00% 2.25% 2.50% 2.75% 3.00%
100000
125000
150000
175000
200000
225000
250000
275000
300000
325000
350000
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated – what if analysis
Calculate (Data Tables) – Principal (1,000,000), Interest
Rate (5%), Duration/Time (10)
Analysis – the above tables and calculations were based on 1
and 2 variants i.e. duration (time) only and then duration and initial
credit (Principal)
Result– this analysis is to predict the monthly payments to be
made on the loan
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated
Excel application & Accounting Package
simulations:
What if analysis (Goal seek & scenario)
Exam results sheet
Data security requirements on spreadsheet
Sage
Peachtree
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated – what if analysis
Calculate (Goal seek) – a candidate’s cumulative scores
have been captured, the candidate needs to hit a distinction score
Analysis – the average of the scores need to be calculated and
based on the candidate’s target score the needed exam score must
be calculated
Result– data can be manipulated based on what is available
and what the goal is
COMPUTER APPLICATIONS: SOFTWARE
S/N ASSIGNMENT GRADE
1 Test 1 58
2 Test 2 70
3 Quiz 72
4 Lab 60
5 Final Exam
6 Final Grade
COMPUTER APPLICATIONS: SOFTWARE
TRADER’S SHOP/BUSINESS SCENARIO
SALE OF AKARA
Input 188.378
Unit Price 50
Overhead Cost 8500
Revenue 9418.92
Profit 918.919
Break even 0 Define
Profit Margin 9.7561 %
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated – what if analysis
Calculate (Scenarios) – a company worker seeks to
compare expenses on different salary options
Analysis – calculate the total expense and balance,
compare values (N120k, N150k)
Result– which salary band is preferable
COMPUTER APPLICATIONS: SOFTWARE
Scenario Manager SALARY OPTIONS FOR JOBs
Monthly Income 100,000
Rent 32,500
Transport 5,000
Feeding 12,000
Shopping 18,000
Going Out 10,000
Electricity Bill 4,500
Phone Bill 5,000
Gas 1,500
Water Bill 1,000
Total Expenses 89,500
Balance 10,500
COMPUTER APPLICATIONS: SOFTWARE
Spreadsheet
calculations
What-if-Analysis
Scenario Manager
i. Highlight Monthly
income to water bill
cells
ii. Click – Data tab,
Forecast, what-fi-
analysis and
Scenario manager
COMPUTER APPLICATIONS: SOFTWARE
Spreadsheet
calculations
What-if-Analysis
Scenario Manager
i. Click the ‘Add’ button
ii. Enter for Scenario
names – Original,
Promotion, New
company
iii. Changing cells are the
selected cells
COMPUTER APPLICATIONS: SOFTWARE
Spreadsheet
calculations
What-if-Analysis
Scenario Manager
i. The bars indicate the
list of expenses which
can be modified
ii. Click “ok” to return to
first dialogue box
COMPUTER APPLICATIONS: SOFTWARE
Spreadsheet
calculations
What-if-Analysis
Scenario Manager
i. Any scenario selected
indicates the relevant
column on excel
ii. Items can be deleted,
edited or new items
added
COMPUTER APPLICATIONS: SOFTWARE
Spreadsheet
calculations
What-if-Analysis
Scenario Manager
i. Click the ‘summary’
button
ii. A table with details of
the 3 options are
prese
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated – “IF” formula
Calculate (Exam result) – a class of 4 students have their
cumulative assessment chart being prepared for the final grades
Analysis – apply if condition to set formula for grade calculation
Result– all students have been appropriately graded with their
average scores
COMPUTER APPLICATIONS: SOFTWARE
First Averag
Surname Test 1 Test 2 Practical Exam Total Final Grade
Name e
Frank Spencer 30 50 80 100 260 65 =IF(Cell>=90,”A”,IF(Ce
ll>=80,”B”,IF(Cell>=70,
”C”,IF(Cell>=60,”D”,”F
”)))))
Daniel Aroh
Bunmi Akiode
Kayode Owolabi
Max 50 100 100 150 400 100
Score
COMPUTER APPLICATIONS: SOFTWARE
MS Office Application Spreadsheets – MS
Excel
Actions to be simulated – Data Security
Objective – various options for securing your data or document on the PC
Definition – Data security is a variety of measures implemented to protect and
safely store all personal and corporate information/data from corruption and illegal
access.
Analysis – Key strokes to secure data from PC screen to securing folders and
restricting access to saved documents
Result– data is secured at various levels
COMPUTER APPLICATIONS: SOFTWARE
Data Security
Securing PC from data
access
Key stroke lock
technique
i. Control + Alternate +
Delete (Ctrl + Alt +
Del)
ii. Select “lock” option
COMPUTER APPLICATIONS: SOFTWARE
Data
Security
Securing a
document folder
Right click folder
and select
properties
COMPUTER APPLICATIONS: SOFTWARE
Data Security
Securing a document
folder
Right click folder and
select properties
Under general options
are
i. Make Read-Only
ii. Make hidden
COMPUTER APPLICATIONS: SOFTWARE
Data Security
Securing a
document folder
Under Security
options are
i. Select user
ii. Access restriction
options
