Unit 4: softwares and shit Flashcards
What is the application software
the programs that do the work that the user are directly interested in
what does the availability of software depend on?
how its licensed or copyrighted by creators or owners
how can software be obtained? in which forms?
custom software
packaged software
public-domain software
freeware
shareware
rental ware
web application (web app)
custom sfotware
tailored-made software
crafted by individual or team of programmers
has particular function or business purpose
packaged software
copyrighted and mass produced software
offered to variety of users in stores or on the web
users must get license to have it
sign contract agreeing not to duplicate and sell it
public-domain software
not protected by copyright
may be duplicated by anyone
freeware
copyrighted software distributed free of charge
shareware
copyrighted software distributed for free trial period
to continue using, users must pay developer
rental ware
online software
users pay for lease
users download it whenever they want
Web application (web app)
software running on remote internet server
not on personal computer
types of software licenses
site licence
concurrent-user license
multiple-user license
single-user license
site licenses
allow software to be used on all computers at a specific location
concurrent-user licenses
allow a number of copies to be used at one time
multiple-user licenses
specifies the number of people who can use the software
single-user licenses
limits software to one user at a time
pirated software
software obtained illegally in violation of copyright
abandonware
software no longer being sold or supported by publisher
types of application software
entertainment
personal
education
productivity
specialized uses
productivity software
make user more productive at particular tasks:
word-processes
spreadsheets
database managers
may be bundled in office suite
data files
contains data such as words, numbers, pictures, sound, etc
program files
contain software instructions that execute or run when program is opened
source program files
executable files
source program files
contain high level computer instructions in the original form written by programmer
executable files
source program file turn into executable file for computer processsing
instruction on how to perform a task
use executable file by running it
importing files
getting data from another source
converting data into a format compatible to the one we are working with
exporting files
turning data into another format to be used in another program
transmitting data
data compression
removing repetitive elements from data file to have more storage
data can be transmitted faster
later decompress it once more
spreadsheets
used to create tables and financial schedules
enter data into rows and columns on screen
Microsoft excel, Corel Quattro Pro, Apple I-work numbers, etc
important stuff for spreadsheets
cells
cell address
rance
values
labels: descriptive text
cell pointer
formulas in spreadsheets
defines how one sell relates to another mathematically
functions in spreadsheets
built in formulas, such as SUM()
what if analysis
allows users to see what happens to totals when one or more number changes in cells
analytical graphics
worksheet and workbook data can be displayed in graphical form
examples of analytical graphs in spreadsheets
column charts
bar charts
line graphs
pie charts
scatter charts
what is a database
collection of data organized so that contents can easily be accessed, managed and updated
Structured collection of interrelated files in a computer system
what does the database software do
sets up and controls the structure of a database and access to data
Principal microcomputer databases
Microsoft Access,
FileMaker Pro
benefits of databases
Data redundancy is minimized
Data is integrated and stored in a structured fashion
Data in databases has more integrity
Data may include text, numbers, and graphics
what is the relational database
main type of microcomputer database program
Data organized into related tables
Each table contains rows (records) & columns (fields)
Key is field used to sort data
Most frequent key field is social security number
Tables with the same key field are linked together
Querying and displaying records
Database software offers a quick way to locate records
Saving, Formatting, Printing, Copying, Transmitting
Can save results, format them in different ways, print as
reports, copy to other documents, & transmit as email
software suite
Collection of individual programs bundled together in a single package
Most popular are productivity suites
productivity suites
professional-level application programs frequently used in business
usually word processing, spreadsheet, database management, and presentation program
Best-known productivity suite is Microsoft Office.
Others are Apple iWork, Corel WordPerfect Office, Lotus
SmartSuite, and StarOffice
integrated package
Single program for microcomputers
combines the functionality of word processing, spreadsheet, and database management
personal information manager
Software that helps you keep track of and manage information used on a daily basis
presentation graphics software
Uses graphics, animation, sound, data, and information to make visual presentations
like powerpoint and shit
financial software
personal-finance managers
entry-level accounting programs
business financial-management packages
Track income & expenses
Allow checkbook management
Do financial reporting
Offer tax categories to assist with tax record-keeping
May offer financial planning & portfolio management
Tax, accounting, invest
desktop publishing
Involves mixing text & graphics to produce high-quality output for commercial printing
becoming a DTP pro requires training
Computer aided design (CAD)
Programs intended for 2D and 3D design of products, structures, civil engineering drawings, and maps
CAD programs help design buildings, cars, planes, electronic devices, roadways, bridges, subdivisions
CAD/CAM programs: allow CAD programs to be input into computer-aided manufacturing systems that make products
