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