module 5: software and apps

operators

+, -, *, and /

pros of mobile apps (3)

-can be created quicker -can access info on the go -voice input and smart on-screen keyboard simplify interactions

cons of mobile apps (3)

-not as fast and have fewer features -poorly designed apps can turn ppl away -typing using a small on-screen keyboard can be hard

range of mobile app cost

1-5 dollars

what do spreadsheet formulas always start with

=

workbook

A collection of related worksheets contained within a single file.

what do web apps rely on to format info

CSS ( cascading style sheets )

server

a computer that you access using the internet or network, stores files and serves them

view only link/read only access

access the file to read but cant change it

productivity apps

allows you to create documents for business and personal use

graphics and media apps

allows you to interact w digital media

device management app example

antivirus apps or file manager app

what do web apps rely on to display info

HTML 5

what do Android developers use to write apps

Java

native app

app written for a specific operating system and installed on a computer or mobile device •Can take advantage of specific features of the devices on which they are installed Many require an Internet connection to provide full functionality. Some can run offline and will store information on your device until they can synchronize with the cloud.

platform specific

apps are designed for specific operating system like android or iphone

mobile applications

apps that you can access on smartphones and tablets

local applications

apps you can install on your computers hard drive

insertion point

blinking vertical line to mark your place (pointer but when selected when you type)

what does a column chart compare

categories of data to one another

relative reference

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

absolute reference

cell reference that doesnt change when the formula containing that reference is moved to a new location

what does a line chart track

change over time

formatting text

changing font, size, color, special effects

database

collection of data organized in a manner that allows access, retrieval, and reporting of that data

productivity suite

collection of productivity apps •Versions to install on a computer, mobile device, or run in the cloud in a browser •Web and mobile versions are often simpler and contain the most basic and popular features •Some are free, and some require you to purchase a license or subscription •Storing documents in the cloud allows for collaboration

presentation

contains a series of slides with a specific layout based on content

pivot tables

create meaningful data summaries to analyze worksheets containing large amounts of data

presentation software

create professional looking digital slide shows

presentation app

create slides that visually communicate ideas, messages, and other info

relational database management system

database that consists of a collection of tables wehre items are organized in columns and rows •Data is organized into tables of records and stored electronically •The software displays commands and work areas appropriate to the view for your task

mobile first design

designers/developers start building apps to work on mobile devices first bc they have more restriction

cross-platform

developers build apps that work on multiple platforms, rather than writing different code for android or iOS devices

page orientation

direction in which content is printed on the page, portrait or landscape

template

doc that has been preformatted for a specific purpose

animation

effects applied to an object that make the object appear, disappear, or move

documents

files you create in a word processing program

filter

filter worksheet data to display only values you want to see

personal interest apps

give you tools to pursue your interests

conditional formatting

highlight cells that meet a certain criteria

what does a stacked area chart show

how several values change over time in the same graphic

graphics app

include tools for creating drawings, modeling 3d dimensional objects, and editing photos/vids

argument of a function

info necessary for a formula or function to calculate an answer

what do web apps rely on to manage the apps performance

javascript

worksheets

laid out in a grid of rows and columns, one page of a spreadsheet they use letters to identify each column and consecutive numbers to identify each row

SQL (Structured Query Language)

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

spreadsheet app

let you interact w numbers, charts, graphics, text and data to make calculations and store numbers

mobile commerce or m-commerce

lets you use your mobile device to make online purchases of goods and services

scroll bars

lines along the edges that let you navigate to scroll through docs

cell

location formed by the intersection of a column and a row (one little box)

cell address

location of a cell in a worksheet

microsoft office 365

lots of microsoft apps for multiple uses, originally made for computers running microsoft windows operatingsystem but it also available as web apps

relational database example for personal computers

microsoft access

example of mobile web app vs. native web app

mobile - amazon.com, native - amazon app

style

named collection of formats that are stored together and can be appleid to text or objects

word processing software

one of the most widely used types of application software where you can create docs and reports, resize and change fonts, add photos, etc.

Design Effective Presentations

Organize with a beginning, middle, and end •Focus on one topic at a time •Choose appropriate backgrounds, colors, and fonts •Use graphics wisely •Use animations and transitions carefully •Use spelling and grammar checks •Check equipment in advance •Speak loudly and clearly •Don't read the slides •Try not to stand behind a podium or in one place •Use technology to enhance your presentation •Involve the audience •Do a dry-run beforehand

appache openoffice

open source suite of productivity app, alternative bc no fee to pay

slide master

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

what do pie charts compare

parts to the whole

built in function

perform financial, mathematical, logical, date and time, and other calculations

graphics and media apps examples

photo editing apps

app store

place to locate and download apps for your mobile device

function

predefined computation or calculation

g suite

productivity site from google available for ChromeOS computers and other operating systems as a web app (google docs, google slides, google sheets)

apple iwork

productivity suite for computers running macOS and iPhones and ipads running iOS operating system, can use apple pencil and works with iCloud storage device

application software

programs that help you perform specific tasks when using your computer or smartphone

web apps

programs that you can access over the internet, in a browser on your computer or on your mobile device

document management tools

protect and organize files and let you share your docs w others

communications apps

provide tools for sharing or recieving information

device management apps

provides tools for maintaining your computer or mobile device

charts

represent data using bars, columns, pie, lines with visualization

records

rows of data

portable apps

run from a removable storage device such as an external hard drive or flash drive or the cloud

trendlines/sparklines

simple charts to visually summarize changes in value over time w graphs

macros

small programs you create to perform steps you repeat frequently

formatting features

Select a presentation design •Format text •Set a slide's dimensions, aspect ratio, and orientation •Change text direction and align text •Resize graphics •Add SmartArt graphics that display text in predesigned configurations to convey lists, processes, and other relationships •Format charts and worksheets to present numerical data •Move, align, and group objects •Use transitions and animations •Use presentation templates and slide masters •Add headers and footers •Display slides on a large monitor or project them to a screen as a slide show •Store presentations in the cloud •Share by copying the HTML embed code provided by the presentation app's share option and pasting it into a blogpost or webpage

spreadsheets

Spreadsheets •Let you interact with numbers, charts, graphics, text, and data •Can perform calculations on data stored in a grid of cells and recalculate values automatically when the data changes

sort

sort data by values in a column to arrange them in increasing/decreasing order

what are the two development tools iOS uses to write apps

swift or Objective-C

onscreen keyboard

tapping or swiping over screen to type

what if analysis

test multiple scenarios by temporarily changing variables to see the impact on calculations

responsive design

the app is optimized for display in a browser on a mobile device, regardless of screen size or orientation

how is a web app accessed

visiting a website in a browser

transitions

visual effects that occur as you move from one slide to another

synchronizing data

when you synchronize data that is from an app that has both a web app and a mobile app so your info is consistent on both devices

slide show

your slides when presented on a large monitor or projected

A function:

• a predefined calculation •Built-in and custom functions

Database software (DBMS)

•A collection of data organized in a manner that allows access, retrieval, and reporting of that data •Add, update, and delete data •Filter, sort and retrieve data from the database •Create forms and reports •Database applications •Track contacts, schedules, possessions, or collections •Process orders, track inventory, maintain customer lists, or manage employee records •Store customer relationship management data •Represents a query in SQL (Structured Query Language) •Because many users may need to access a database at the same time and they can be quite large, enterprise databases generally run on a server •Data can be exported into other programs, such as a spreadsheet program, where you can create charts to visualize data that results from a query •Data can be exported to other formats, including HTML, to publish to the web

web app

•Accessed by visiting a website in a browser •A mobile app is a web app that runs on a mobile device •Mobile web apps often have a responsive design •Many developers prefer web apps since they run on all devices Some apps are available both as native and web apps

Key Features of presentation software

•Can help organize content and create professional-looking digital slide shows •Each slide has a specific layout based on its content, and each layout has predefined placeholders for these items •Display presentations in different views •Add main points as a bulleted list, graphics, or images •Provide design ideas •Spelling check, formatting, researching, sharing, and publishing online

analyze data

•Conditional formatting •Sort and filter data •Use what-if analysis •Use trendlines or sparklines and pivot tables •Automate worksheets with macros •Create charts

Formatting

•Format text by changing font type, size, style, color, and special effects •Specify a document's margins and the page orientation •Specify styles for a document's title, headings, paragraphs, quotes, and more •Many productivity suites offer built-in templates for creating different kinds of documents

key features of spreadsheet software

•Formatting tools to change a worksheet's appearance •Page layout and view features •Printing features •Web capabilities to share workbooks online, add hyperlinks, and save worksheets as webpages •Developer tools to add customized functions •Tools to analyze data

formulas

•Formulas, or computation rules, calculate values using cell references, numbers, and arithmetic operators

manage documents

•Offers tools to edit, share, protect, and save documents •Copy text and graphics from one document (or spreadsheet or database) to another •By storing documents in the cloud, you can share documents with several people who can read, edit, and comment on the same document at the same time •You can restrict access to a document by providing a view-only link or read-only access

App Features

•Represented on the desktop by an icon or tile •Can be run by double-clicking or tapping •Open in a window •Have menus that give options to access different features of the program •Have buttons to click or tap to give commands or perform actions •Some are available as both a web and a mobile app and can synchronize data

Mobile Apps

•Touch the screen to interact with mobile apps •Use an on-screen keyboard to enter information •Many mobile devices come preinstalled with apps •You can organize apps into groups by category •Apps are represented by icons on your screen •An app store is used to find and download apps

argument

•information necessary for a formula or function to calculate an answer