module 4 & 5 Flashcards
TYPES OF SOFTWARE
helps the user, hardware, and application software to interact and function together. This is essential in managing the whole computer system
system software
TYPES OF SOFTWARE
system software that controls the working of computer hardware and software
operating system
TYPES OF SOFTWARE
system software that helps to maintain the proper and smooth functioning of a computer system
utility software
TYPES OF SOFTWARE
this is what you engage with the most
This is productive end-user programs that help you perform tasks
application software (apps)
TYPES OF SOFTWARE
It is designed to perform a wide range of fundamental functions that a user needs to perform on a system
general purpose applications
TYPES OF SOFTWARE
It is a type of application software designed to fulfill specific business function and operations
* These are presumed to improve the accuracy and efficiency of business operations
business applications
TYPES OF SOFTWARE
It is solely built for some specific organization or user based on business requirements
costum developed applications
TYPES OF SOFTWARE
the type of software that is not used by end-user. Programs that are used to write, develop, test, and debug other software, including apps and system software
programming software
TYPES OF SOFTWARE
any software that is available to use for free. They can be downloaded and installed over the internet without any cost
freeware
TYPES OF SOFTWARE
give common examples of freeware
- Google Chrome
- Skype
- Snapchat
- Adobe reader
TYPES OF SOFTWARE
are software applications that are paid programs, but are made available for free for a limited period of time known as ‘trial period’.
shareware
TYPES OF SOFTWARE
give examples of shareware
- Adobe PhotoShop
- Adobe Illustrator
- Netflix App
- Matlab
- McAfee Antivirus
TYPES OF SOFTWARE
open-source code that is available to use for all users. It can be modified and shared with anyone for any purpose
open source software
TYPES OF SOFTWARE
These are the types of software that are non-free for the programmers. For this software, the source code is the intellectual property of software publishers.
closed source (proprietor software)
CHALLENGES IN SOFTWARE UPDATES
Protecting software from unauthorized access and cyber threats.
security concern
CHALLENGES IN SOFTWARE UPDATES
Ensuring software works seamlessly across different devices and platforms.
compatibility issues
CHALLENGES IN SOFTWARE UPDATES
Keeping up with evolving technologies and framework
rapid technological changes
SPREADSHEET FEATURES
interactive computer application for organization, analysis and storage of data in tabular form
spreadsheet
SPREADSHEET FEATURES
multiple sheets can be
combined to create ___
workbook
SPREADSHEET FEATURES
Built-in tools to showcase your data visually, including bar charts, graphs and pie charts in a variety of styles and colors
visual design
SPREADSHEET FEATURES
It automatically recalculates all dependent formulas every time any value, formula, or name referenced in those formulas is changed
automatic calculations
SPREADSHEET FEATURES
It automatically updates values in cells or ranges in a worksheet that is reference from another worksheet or program.
dynamic updates
SPREADSHEET FEATURES
It provides a set of data analysis tools which you can use to save steps when you develop complex statistical analyses.
data analysis
SPREADSHEET FEATURES
collection of rows and columns
worksheet
SPREADSHEET FEATURES
o It is the Syntax of the operation to be used
o Used to perform calculations
formulas
SPREADSHEET FEATURES
premade formulas
functions
EXCEL
considered the “gold standard of spreadsheets”
microsoft excel
EXCEL ERRORS
When the formula contains some incorrect cell references. Happens mainly when a row or column is mistakenly deleted.
REF! (Reference Error)
EXCEL ERRORS
When a number you are referring to in your formula does not exist.
(ex. when a sheet used in the formula was deleted)
N/A (No Value Available error)
EXCEL ERRORS
When the formula contains numeric values that are not valid.
NUM!
EXCEL ERRORS
When we reference the same cell in which we are writing the function or formula.
Circular Reference Error
EXCEL ERRORS
width of column is too small
(Width Error)
EXCEL ERRORS
when the text is not recognized in the formula
NAME? (Name Error)
EXCEL ERRORS
when a variable mentioned in the formula is wrong
VALUE! (Value Error)
EXCEL ERRORS
attempt to divide a number by zero
DIV/0! (Division Error)
EXCEL ERRORS
when you forget to separate two cell references correctly
NULL! (Null Error)
