CS 008 Chapter 2

Application Software

a program that performs a useful task for the user, such as productivity, entertainment, and education software

Business Productivity Software (10)

- office application suites

- word processing software

- spreadsheet software

- presentation software

- database software

- personal information software (PIM)

- accounting software

- document management system (DMS)

- project management software

- customer relations management system (CRM)

Office Application Suites

apps designed to work together and to provide a common interface and features

(ex. MS office, G suite, Google drive)

Word Processing Software

application used to create, edit, and format mostly text documents (ex. MS word, Pages for Mac, Google Docs)

Spreadsheet Software

- application that creates electronic worksheets composed of rows and columns that can be used for mathematical application (ex. MS excel, Numbers for Mac, Google sheets)

- cells

- formulas (which makes spd sht so useful)

(can contain functions and does automatic recalculation)

Presentation Software

application used to create electronic presentations such as a set of slides (ex. MS PPT, keynote for Mac, Google slides)

Database Software

- application used to create and manage a database (a collection of information organized in a useful way)

(ex. MS access, SQL server, Oracle)

- can preform queries and create reports

Table

a collection of records in a database, arranged in rows and columns

field

a single piece of information in a record in a database, such as a name, phone number, date, etc.

record

one compete entry in a database table; composed of the individual fields

Personal Information Manager Software

application used to manage your email, calendar and tasks (ex. MS outlook, Google Calender/Gmail

Accounting Software

- application used to track your business finances and generate reports and graphs

- can do expense tracking, invoicing, payroll

(ex. Intuit QuickBooks, FreshBooks)

Document Management System (DMS)

- enables a company to save, share, search and audit electronic documents throughout their life cycle

- storage is key (rather than stored on local drive, stored on server or web, making them more accessible)

(ex. MS sharepoint, Dropbox, Google drive)

Project Management Software

application designed to help complete projects, keep within budges, stay on schedule and collaborate with others (Gantt Chart shows the schedule and progress of a project)

(ex. MS project, Basecamp)

Customer Relations Management System (CRM)

- a system for maintaining customer information and connections

- tracks interactions with customers

- uses analytics (detecting patterns in data) to help make business decisions

Personal Finance Software

helps you keep track of your back accounts, monitor your investments, creates a budget (ex. Quicken, YNAM)

Tax Preparation Software

Allows you to complete your income tax returns yourself on your computer or online (ex. TurboTax)

Photo/Image Editing Software

sophisticated versions of graphics programs used to create and edit images (ex. photoshop, GIMP)

Media Management Software

organizes and plays multimedia files such as music files, videos and podcasts (ex. Windows media player, iTunes, VLC)

Games

- average age: 32-35

- 60% male, 40% female

Educational Software

very broad category (ex. iLearn, canvas)

System Requirements

- the minimum hardware and software specifications required to run an application

- how much storage space is needed, minimum RAM required, minimum CPU etc.

Software Licensing

purchasing software may not mean you own it, you may only be purchasing a license to use the software, normally on a single computer

(EULA: end user license agreement is usually required to accept before software can be installed)

Types of Software (7)

- retail software

- open source

- subscription

- freeware

- donationware

- shareware (trialware)

- freemium

Retail Software

- user pays a fee to use

- grants a proprietary software license, which means ownership of the software remains with the publisher

Open Source

- license grants ownership of the software to the end user

- source code must be made freely available

- user can modify and redistribute software (under same license)

Subscription

- monthly or yearly fee provides access to the software for a limited time

- software updates/ newer versions included

Freeware

- retail software that can be used at no cost for an unlimited period of time

(ex. Apple iTunes)

Donationware

form of freeware where developers accept donations

Shareware (trialware)

- software that can be used for free for a period of time

- at the end of trial period, user is supposed to purchase or remove software

Where to get Software

- boxed software (purchased at stores or online and shipped to you)

- download from website (most popular way)

Web Based Applications

- run in web browser

- no installation needed on user's computer and do not need to update

- platform neutral (they run on any device with supported browser and internet access)

- makes collaboration with other users easy

(ex. google docs, google sheets, google slides, MyITLabs)

Cloud Computing

- takes processing and storage off your hardware and puts it in the cloud (the provider's internet servers)

- can save money in software, hardware and personnel costs

(Cloud service providers: AWS, google, Apple)

Cloud Computing IaaS (infrastructure as a service)

- company uses provider's internet servers instead of purchasing and maintaining their own

- can reduce cost for hardware, software, and support personnel

- can just pay for what is needed, increasing or reducing usage as needed

Cloud Computing PaaS (platform as a service)

- provides a programming environment to develop, test, and deploy web applications

- used to build, deploy and maintain SaaS applications

Cloud Computing SaaS (software as a service)

involves the delivery of applications over the internet (another name for web applications)

Installing

most softwares use an installer which guides the user through a series of steps to install the software

Updating

- need interned connection

- patch (hotfix): addresses an individual problem (bug) when discovered

- service pack: larger, planned update that addresses multiple problems

- software can be configured to automatically install updates

Uninstalling

use uninstalled that came with software, do not just delete files