×
Log in to StudySoup
Get Full Access to UH - MIS 3300 - Study Guide - Midterm
Join StudySoup for FREE
Get Full Access to UH - MIS 3300 - Study Guide - Midterm

Already have an account? Login here
×
Reset your password

UH / Biology / BIOL 3300 / What symbol indicates absolute references?

What symbol indicates absolute references?

What symbol indicates absolute references?

Description

School: University of Houston
Department: Biology
Course: Introduction to Computers and Management Information Systems
Professor: Emese felvegi
Term: Fall 2016
Tags:
Cost: 50
Name: Exam 1 Review
Description: Contains review question explanations and specifics to remember from the lectures.
Uploaded: 09/25/2017
6 Pages 71 Views 2 Unlocks
Reviews


MIS Exam 1 Study Review


What is porter’s five forces model?



From SAM Review Questions

∙ Data Labels: descriptive text for individual data markers

∙ Column Headings are letters (A- XFD), Row Headings are numbers (1-1 million+) ∙ 11 different types of functions

∙ Internal Data Sources: come from within the entity

∙ Add Gridlines to Chart

∙ INT rounds to the nearest integer

∙ Read Only Memory v. Random Access Memory

∙ Chart Sheets: only have the chart in them, no workbook spaces ∙ MM/DD/YYYY is a date formatting

∙ Absolute References have a $ in front of them Don't forget about the age old question of What do blogs provide for readers that the traditional media can't?

∙ =SUM( cell references )


What is an understanding and ability to put into practice?



Don't forget about the age old question of What is the difference between the parasympathetic and sympathetic systems?

∙ Soft Copy: non-physical presentation of data (screen, not CD (hard copy)) We also discuss several other topics like What is the salary wage exp if you have a depreciation exp of 10,500?

∙ Quick Analysis: pop up with suggested additions to the worksheet when you  select certain data

∙ Dates are right aligned

∙ Supercomputers have high storage capacity

∙ Italic and Bold are examples of Font Styles

∙ =IF(Logical Test, If true, If false)

∙ Autofill: pulling down the bottom right corner to logically complete or copy  formula

∙ Pie slices showcase one data portion, not multiple

∙ Porter’s Five Forces Model If you want to learn more check out What is the communication between cells, tissues, and systems?

∙ Dates and Times default to numbers


What is porter’s competitive advantage?



∙ Data is processed and turned into information

∙ Usefulness of Information to users determines the information processing  system’s success

∙ Format Painter tool

∙ 8 bits = 1 byte

∙ CPU is the heart of the computer

∙ ENIAC was an early computer, very large and only capable of performing simple  calculations

∙ Editing Min/Max of Data Bars

∙ Sparklines

∙ =MIN and =MAX

∙ =AVERAGE

∙ =VLOOKUP( lookup value, table to look in, which column to retrieve from ) ∙ =COUNT Don't forget about the age old question of What is the meaning of general seed?

Specifics from Lecture

∙ Data > Database > Process > Information

∙ Data Processing makes data usable, into information

∙ Literacy: understanding and ability to put into practice

∙ MIS Development

o Printing Press (Gutenberg)

o Digital (Von Newmann, Turing)

∙ Porter’s Competitive Advantage

o Cost Leadership

o Differentiation

o Niche Market

∙ Porter’s Five Forces Model

o Buyer Power of choice

o Supplier Power

o Threat of Substitutes

o Threat of New Entrants to market

o Rivalry Among Competitors

∙ Computer History

o Abacus

o Pascal’s Mechanical Calculator

o Binary Code (Leibniz) Don't forget about the age old question of What is the meaning of a cation?

o Beginnings of the computer (Babbage)

o Theorizes the idea of a computer (Turing [The Imitation Game]) 2

o Code Language (Grace Hopper)

o IBM- Super Computer Watson

∙ CPU works with the memory unit (RAM and secondary long term storage) ∙ Edward Tufte (no chart junk)

3

MIS Exam 1 Study Review

From SAM Review Questions

∙ Data Labels: descriptive text for individual data markers

∙ Column Headings are letters (A- XFD), Row Headings are numbers (1-1 million+) ∙ 11 different types of functions

∙ Internal Data Sources: come from within the entity

∙ Add Gridlines to Chart

∙ INT rounds to the nearest integer

∙ Read Only Memory v. Random Access Memory

∙ Chart Sheets: only have the chart in them, no workbook spaces ∙ MM/DD/YYYY is a date formatting

∙ Absolute References have a $ in front of them

∙ =SUM( cell references )

∙ Soft Copy: non-physical presentation of data (screen, not CD (hard copy))

∙ Quick Analysis: pop up with suggested additions to the worksheet when you  select certain data

∙ Dates are right aligned

∙ Supercomputers have high storage capacity

∙ Italic and Bold are examples of Font Styles

∙ =IF(Logical Test, If true, If false)

∙ Autofill: pulling down the bottom right corner to logically complete or copy  formula

∙ Pie slices showcase one data portion, not multiple

∙ Porter’s Five Forces Model

∙ Dates and Times default to numbers

∙ Data is processed and turned into information

∙ Usefulness of Information to users determines the information processing  system’s success

∙ Format Painter tool

∙ 8 bits = 1 byte

∙ CPU is the heart of the computer

∙ ENIAC was an early computer, very large and only capable of performing simple  calculations

∙ Editing Min/Max of Data Bars

∙ Sparklines

∙ =MIN and =MAX

∙ =AVERAGE

∙ =VLOOKUP( lookup value, table to look in, which column to retrieve from ) ∙ =COUNT

Specifics from Lecture

∙ Data > Database > Process > Information

∙ Data Processing makes data usable, into information

∙ Literacy: understanding and ability to put into practice

∙ MIS Development

o Printing Press (Gutenberg)

o Digital (Von Newmann, Turing)

∙ Porter’s Competitive Advantage

o Cost Leadership

o Differentiation

o Niche Market

∙ Porter’s Five Forces Model

o Buyer Power of choice

o Supplier Power

o Threat of Substitutes

o Threat of New Entrants to market

o Rivalry Among Competitors

∙ Computer History

o Abacus

o Pascal’s Mechanical Calculator

o Binary Code (Leibniz)

o Beginnings of the computer (Babbage)

o Theorizes the idea of a computer (Turing [The Imitation Game]) 2

o Code Language (Grace Hopper)

o IBM- Super Computer Watson

∙ CPU works with the memory unit (RAM and secondary long term storage) ∙ Edward Tufte (no chart junk)

3

Page Expired
5off
It looks like your free minutes have expired! Lucky for you we have all the content you need, just sign up here