PRESENTATION NOTES blah

SPREADSHEET

spreadsheet softwares allow user control numbers. it can make short work that involves calculations. Malleable matrix is a spread sheet doc which is called a worksheet n appears

values: raw material that spresheet calculates like numbers

labels: helps ppl undersand.

replication: basic copy and paste functions

automatic recalculations: changes all data related to the change.

functions: set calculations like square-root button

Macros: custom-designed procedure programs that automats tasks in apps.

templates: ready2use wroksheets

automatic links: when something changes, all linked wrkshts update auto.

line charts: show trends over time

bar charts: similar to line graph but are more opportune when data falls into more categories.

scatter charts: used to discover the relationship btwn two variables.

-->spreadsheet errors are easy to make and over look.

floow basic guidelines to not go into error.

1. plan wrksht b4 entering values, etc.

2. make assumptions as accurate as possible

3. double check every formula

4. make formula readable

money manages:

-sprdshts are seldom used in accounting

-Accounting is complex with rules formulas laws and traditions.

auto mathematics:

mathematic processors include interactive wizard mode , a program langyage tools for creating interactive stuff.

statistics and data analysis:

data is referred to as data. Statistics are very important and diff branch to math.

-its not an absolute answer

we have to test strength of data

scientific visualization:

ises shapes location in space color brightness, and motion to help read for ex: weather.

calculated risks: computer modeling and simulation:

-comps r used to visualize scientific data thats been collected

-comp model=abstraction--a set of concepts and ideals

comp simulation is used for physical, biological and in engineering.

there are many reasons to use comp sim:

1. safety.

2. economy

3. projection

4. visualization

5. replication.

RISKS:

comp sim--

1.gego revisited Ex: weather forecast. atmosphere very complex so sometimes its wrong.

2. making reality fit in the machine--these are very complex so most likey have difficulties

3. illusion of infallibility: they can be very risky

Database Review

1. RDBMS: Rational Database Managment System

2. Three tables that could be part of a doctors patient relational database name, date, lab reults.

3. Searching the database to find specific information is called a: file search

4. We are concerned about the electronic database because anyone can hack into it and check out different peoples social security numbers (etc.) and be able to steal others identity.

5. 3 different social and ethical issues that are related to online databases is, for one, privacy. Databases give lack of privacy by posting up your information and making it available for customer callers to call, etc. Another s/e issue is authenticuity. Ones information ccould not have been updataed and so what would be given out is wrong information. Lastly, Globalization and cultural diversity. People from all over your world can be on the same database from someone else on the otherside of the world.

6. Something that we need to protect electronic databases from is identity theft. we can protect it by firewall and password security.

http://www.cnn.com/2010/TECH/04/05/games.schell/index.html?iref=allsearch

article

topic of discussion.

privacy over info in diff. cultures--

info put on the internet can hurt us. ppl can easily find photos, address, name, etc by ur info on internet n can steal identity. employers have to inform employyees if doin internet use.
chinas news publishing has to keep info on ppl for at least 60 days.

rights of individuals w/ respect to storage of personal data--

regulation issues in europe are very strict n difficult to comprehend. DNA.
invasion of privacy even tho its alsa said to help keep down crimes. Gov. given public access to the ppls phone numbers, etc. US has loose protection laws. anyone can take ur pic, etc.

social consequences in the lease of some data--

if data taken, big problem. u can lose money and be given a crime u didnt comit. social security number, tax info, and other stuff.
database is in a harddrive. all info stays on hardware. when u delete, its not entirely deleted. one can easily get their hands on hardware and recover everything.

ethical issues relating to selling data--

another issue is security. social security numbers can be used to identity theft. there are laws for these issues. database must collect data that is only needed. database must inform owner of collected data. to secure accuresy of info etc.

paper files vs. electronic files--

businesses use electronoic way more than paper. its way easier to search files than paper. databse lets anyone person to check it out. most electronic has flaws tho. a persons info can be on database. even if deleted, its still there. nothing can be deleted unless if you just override it. that whats more private bout paper. you can shred it.

Responsabilities for secure of data and databases--

file boxes conain cell numbers, social sec. numbers, ec give out heckaaaa info on millions of ppl. its easy to follow databse. companies retaining info
to prevent breaches, they neeed firewals, etc. consumers have to be careful with what they give out.

social consequences of outdated or incorrect info in databases--

you have to be very careful with what you give out. a person can go onto a diff. database to get info on you. some databases might not have the correct info on you. if they have wrong info on you u wont get what you services you need.

Review ?s pg. 259 #7-11

7. When you sort a data file, you pretty much re-arrange the files alphabetically.

8.

9. Record matching is used to obtain informaton about youby compiling files by combining information from different databases. As long as the table in the databases share a single unique field, then it will be trivial and quick. And example of this is a Social Security number.

10. Yes we have a legal right to privacy.

pg 134 #2-5

2. Compilers and other translator programs compiles the complete translation of the program in a high-level computer language before the program runs for the first time.

Software applications allow users to control computers and perform certain actions without being a programmer.

System software is a software that handles details like which parts of the computer's memory holds a document including the operating system and utility programs.

3. The opperating system has to be the first one put into the drive because its the one that communicates with the harddrive.

4. Ehh?

5. The single-user operating system allows the user to run multiple applications at the same time by creating tasks. Because the CPU can only perform one process at a time, the OS takes schedules amd also manages virtual memory. Multi-user OSs are responsible for authentication (user names and passwords) and authorization (allowing only those with adminstrative priviliges to install or uninstall application programs).

RQ & DQ #1 pg. 134

RQ:

1. The relationship between a program and an algorithm is that programs starts off as an algorithim written in English or some other human language.

DQ:

1. Writing instructions for a computer may be harder than writing instructions for a human because the computer doesnt have a brain to fully understand a concept and ur language. To make them understand, you have to use codes, etc. Whereas humans just use their brains and dont need everything to be all the way done for them to fully understand.