Computer Concepts 5

bitmap

.bmp

GIF (graphics interchange format)

.gif

absolute reference

A cell reference that does not change when the formula containing that reference is moved to a new location

Relational database management system (RDBMS) or relational database

A database that consists of a collection of tables, each of which contains information on a specific subject.

spreadsheet

A grid of cells that contain numbers and text; in Microsoft Excel, a spreadsheet is called a worksheet. Organize data in rows and columns

Structured Query Language (SQL)

A language that provides a standardized way to request information from a relational database system.

macros

A named set of instructions written in the Visual Basic programming language that perform tasks automatically in a specified order.

Apple iWork

A productivity suite for computers running macOS and iPhones and iPads running the iOS operating system

responsive design

A way to provide content so that it adapts appropriately to the size of the display on any device

bitmap (raster)

Consist of grids of tiny dots called pixels and have a fixed resolution and cannot be resized without altering image quality

G Suite

Google's web-based productivity applications for creating documents, spreadsheets, presentations, email, and calendars.

local applications

apps you install on your computers hard drive. These programs have features and capabilities. Ex) Microsoft suite of applications for word processing, spreadsheets, databases and email and presentations you can install locally in your computer.

database

collection of data organized in a manner that allows access, retrieval, and reporting of that data. With database software you can you can create, access, manage by adding updating and deleting data from the database

field

column containing a specific property for each record, such as a person, place, object, event or idea. fields are defined by their data type such as text, data, number. assigned a field name that describes data field

graphics apps let you...

create multimedia to include in letters, reports, presentations, spreadsheets and other documents

mobile first design

design principle centered on building apps to work on mobile devices first bcs they typically have more restrictions ex) smaller screen

animations

effects applied to an object that make them appear, disappear, or move. Can add visual appeal to a presentation when used carefully Ex) entrance, exit, photo can fade in

reference apps

encyclopedia, dictionaries, data bases, social media, shopping apps

query

extracts data from one or more database tables according to criteria that you set

Databases can be stored in a...

file on a hard disk drive, solid state drive, an external drive or in cloud storage

vector

format for storing digital images that tend to be simple images composed of shapes, lines, diagrams. They use mathematical equations, not pixels. Can be enlarged with out losing quality. Used by most business logos

Microsoft office online

free web based version offering basic features of word processing, spreadsheets, and presentation software.

records (also called tuple)

in Access and Excel. A row of data in a table, representing a complete set of field values for a specific person, place, object or event or idea

database software

keep track of addresses, contacts, collections, and more. -online shop to find products -large databases store billions pieces of data and handle hundreds of thousands users at a time

cell

location formed by the intersection of a column and a row. Ex) cell K11 is located at the intersection of column K & row 11

Microsoft Office 365

microsoft productivity suite which includes word processing, spreadsheets, presentation apps as well as Microsoft Outlook for email, Microsoft One Note for note taking, & Microsoft Office for databases

platform specific

mobile apps designed for a specific operating system. Ex) android vs iPhone versions of apps

word processing software

most widely-used application software, used to create, edit, and format documents that consist primarily of text.

slide master

overall template for a presentation formatted with a theme, customized title and text fonts, backgrounds, and other objects that appear on slides in the presentation

Microsoft Access

popular relational database for personal computers (& small businesses)

presentation

powerpoint document that lets you create and deliver dynamic, professional looking message to an audience in the form of a slideshow

fomat

process of changing appearance of text and objects. Font size, style, color, special effects

Application software (software applications, or apps)

programs that help you perform specific tasks when using your computer or smartphone. With apps you can create documents, edit photos, record videos, etc

web based applications (or web apps)

programs that you access over the internet, in a web browser on a computer or your mobile device. Bcs they run on internet, they offer collaborative features & store files you create in the cloud. Ex) Microsoft Office Online

SQL & Oracle

provide advanced database solution for enterprise use

Device management apps

provides tools for maintaining your personal device.

Internet of Things (IoT)

refers to objects, "things", such a thermostat, coffee maker, that have capability to send data from attached electronic sensors

Charts (sometimes called graphs)

represent data using bars, columns, pies, lines or other symbols to make data easier to understand and easier to see the relationship among the data

portable apps

run from removable storage, such as an external hard drive, flash drive, or from the cloud. Connect external hard drive or flash drive to computer and run the application. Cloud; useful for when running out of storage

when databases have multiple users accessing it, a....

server solution is usually the best. Ex) Oracle, Microsoft SQL Server, MySQL allow to organize large amounts of data, and have many users update it simultaneously

Because many users can access databases at the same time, databases can be quite large. Enterprise databases usually run on a shared computer called server.

server: powerful, high capacity computer you can access using the internet or other network; stores files and "serves" them, that is makes files available to users

worksheet

single sheet in a workbook file that is laid out in a grid of rows and columns

presentation software

software programs used to organize and present information in the form of an electronic slideshow

synchronize

some apps are available as both a web app and a mobile app. you can synchronize the data & activity between them, so actions will be consistent across all devices

cross platform

tools that developers can use to build apps that work on multiple platforms, rather than writing different code for Android or iPhone. They rely on tools such as HTML5, JavaScript, CSS

graphics apps

used to create digital sketches, resize or add special effects to digital photos, add titles, and credits to videos. -tools for creative drawings -modeling 3D objects -editing photos and videos

transitions

visual effects that occur as you move from one slide to another. Manner in which a slide appears on the screen in place of the previous slide

view-only link or read-only access

way to share files so others may read the file, but cannot change it

mobile app

web app that runs on a mobile device. Mobile web apps usually have a responsive design. Some require ability to connect to the internet

many app developers prefer...

web apps because they run on all devices. web apps rely on: HTML (display info), JavaScript (manage apps performance), CSS (Cascading Style Sheets, format info).

productivity apps

when you are writing a letter or report, maintaining a budget, creating slides for a presentation, you are using productivity apps. (Word processing apps, presentation apps, spreadsheet apps, may include email databases, notetaking)

"big data"

when you update FB status, send a tweet, purchase from Amazon, all these activities are stored in a database. These databases grow quickly. Big data refers to a collection so large and complex that it is difficult to process using relational database applications

presentation apps

you can create slides with graphics, text, images or videos

File manager app

you can file, store, locate, and organize files in your devices storage or cloud ex) anti-virus, anti spyware

mobile or m-commerce

apps that let you use your mobile device to make online purchases of goods and services such as ubereats or amazon

Apache OpenOffice

An open source suite of productivity apps. You can download OpenOffice at no cost from a web server on the internet & install the apps on your computer

video editing apps

Apps that allow you to modify a segment of a video, called a clip. Reduce length of video clip, reorder series of clips, add specific effects

photo and image editing apps

Apps that provide the capabilities of paint apps and let you enhance and modify existing photos and images.

mobile apps

apps that you access on a smartphone or tablet. Used to increase personal productivity. Check email, travel directions, etc. Bcs screens are small, they focus on a single task email, searching web, sending text

Many vendors bundle their individual apps into a...

Productivity suite (or collection of productivity apps). Ex. Microsoft Office 365, Apple iWork, G Suite, Apache Office

Graphics software

When you need a new banner for your website, edit a photo, or create a logo

relative reference

a reference that changes when the formula containing that reference is moved to a new location

web app

accessed by visiting a website in a browser

productivity apps

allow you to create documents for business and personal use. word processing apps to create letters, reports, or documents.

graphics & media apps

allow you to interact with digital media. With photo editing apps you can modify digital images ex) cropping, filters

native app

an app written for specific operating system and installed on a computer or mobile device. Native apps can take advantage of specific features of the devices on which they are installed. Ex) smartphone camera, contact list, microphone. Many require internet connection for full functionality

Native App

an app you can download or install on your mobile device. Developed specifically for a mobile device

paint apps

app designed for drawing pictures, shapes, and other graphics with various on screen tools, such as text, pen, brush, eyedropper, paint bucket

Web App

app you can access from browser of desktop or mobile device

personal interest apps

apps that give you tools to pursue your personal interests,. Travel, mapping, news apps