IS Access Lab In Class Notes

• Microsoft Access 
• Level of Data Base
• Personal Data Base
• Database File Extension for Access 2013
• .accdb
• How to Make A Table
• Switch to Design View
• Name Table
• Label Each Row and Set Each Row Data Type As Short Text
• If a row is specifically a number
• Then set the data type as "number"
• How Do You Make Multiple Rows Primary Keys?
• Hold control and click each row
• Click the primary key button
• Why in the Example are Columns Underlined?
• They are primary keys
• How Do You Make Something Uniquely Identified
• Highlight a row
• Click the Primary Key Button
• How Do You Create a Form For A Table
• Highlight Table
• Click "Form" Under the Create Tab
• How Do You Create Relationships
• Close all tables
• Click Relationships Under Create Tab
• Hold Control and Click all Tables That You Want to Relate
• Click Add
• Close Window
• How To Create a Relationship Between Table Rows
• Drag Rows of the same name into each other
• A window will pop up, that is labeled Edit Relationships
• Check mark 'Enforce Referential Integrity'
• Click Create
• How To Create A Query
• Close all Tables
• Goto Create Tab
• Click Query Design
• Hold Control and Select All Necessary Tables
• Click Add
• Close Window
• Set Each Appropriate Field
• Type the Appropriate Criteria under the Appropriate Field, To Grab Info only on that Criteria
• Microsoft SQLServer 
• Level of Database
• Mid Range Database
• Oracle, IBM DB 2 
• Level of Database
• Enterprise Strength Database System

Persuasive Presentation is Due on August 2nd

August 2nd

Persuasive Presentation is Due

Information Systems Chapter 6

• Why is the Cloud the Future of Most Organizations?
• What Does Elastic Leasing Mean?
• Flexible for Unpredictable Demand
• Organizations only pay for the resources they actually use.
• What is The Cloud?
• Elastic Leasing of computer resources via the internet.
• How do Organizations Pool Resources?
• Many organizations share the same physical hardware through virtualization.
• What is the Benefit Organizations Get From The Economies of Scale of Pooling Resources?
• Average Cost of Production decreases as the size of the operation increases.
• What are Web Farms?
• Enormous data centers, run by major cloud vendors.
• When Would You Not Want to Use The Cloud?
• If the law or standard industry practice, require physical control or possession of data.
• Example
• Some financial institutions if not all, are required to have physical control over its data.
• What network technology supports the cloud?
• Types of Network Technology
• Local Area Network
• Characteristics
• Computers connected at a single physical site.
• Protocol
• Bluetooth
• For transmitting data short distances
• Wired Area Network
• Characteristics
• Computers connected between two or more seperate sites.
• Internet and internets
• Characteristics
• Network of networks
• How are Communication Speeds Expressed?
• Bits
• How is Memory Size Expressed?
• Bytes
• One Byte Equals Eight Bits
• Important ISP Functions
• Provides legitimate internet access
• Gateway to the internet
• Collects money from customers who pay access fees and other charges to telecoms to pay for internet 
• How does the cloud work?
• What Are Packets?
• Messages that are broken down and moved through the internet.
• What Are Carriers?
• Telecom Providers
• What Are Peer Agreements?
• Agreements to exchange traffic among multiple carriers, without paying access fees.
• What is Net Neutrality?
• All data is treated equally
• What is the Bandwidth Problem?
• Some people use more bandwidth than others
• What is a Public IP Address?
• Identifies a particular device on public internet
• What is the ICANN?
• Internet Corporation For Assigned Names And Numbers
• Who assigns Public IP Addresses?
• ICANN
• What is a Private IP Address?
• Identifies a device on a private network
• Probably a LAN Network
• What are the Major Benefits of IP Addresses?
• IP addresses are conserved when multiple computers are on the same public LAN Network.
• Using Private IP addresses eliminates registering for an IP address from ICANN.
• What is IPv4?
• Four Decimal Dotted Notation
• Example
• 123.123.123.123
• What is a Domain Name?
• Defininition
• Unique name affiliated with a public IP address
• Important Notes
• Many domain names can point to the same address
• Domain Names can change their affiliated IP addresses 
• Three Tier Architecture 
• User Tier
• User Computers
• Web Browsers
• Server Tier
• Web Server Computers
• Web Server
• Other Applications
• Computer Server Applications
• Instructions and Data
• Database Tier
• Database Management System
• Database
• What Are SOA Principles?
• SOA 
• Surface Oriented Architecture
• Load Balancers
• Help balance the loads of three tier architecture at each tier.
• Each department formally states the data it expects to receive, with request and data it returns in response
• Every Interaction is Done in The Same Way
• No Department needs to know who works in other departments or how other departments work
• Hierarchy of Protocols Supporting Web Services
• Web Service Protocols
• WSDL/SOAP
• Application Layer Protocols
• smtp
• ftp
• http(s)
• Internet Plumbing Protocols
• Four more layers or protocols
• TCP/IP Protocol Architecture
• How do organizations use the cloud?
• Content Delivery Networks
• System of hardware and software stores user data in multiple geographic locations, and makes data available on demand.
• Benefits
• Minimizes Latency
• Protection From DOS Attacks
• Reduced Delivery Costs For Mobile Users
• Pay as you go
• When They Are Best Used
• Store and Deliver Seldom Used Content
• How can AllRoad Parts use the cloud?
• SASS Products
• Definition
• Software as a service
• Use
• To download stuff
• Provide more added value
• PaaS Services
• Definition
• Platform as a Service
• Use
• Virtualization
• Virtual Machines
• Provide more added value
• IaaS Services
• Definition
• Infrastructure as a Service
• Use
• Machine with possible software already installed
• Level of Service
• Lowest
• Provides basic hardware in the cloud
• May acquire servers to load operating systems on them
• Requires considerable expertise and management
• Not available for small companies
• How can organizations use cloud services securely?
• VPN
• Virtual Private Networks
• Virtual Private Cloud
• Subset of a public cloud with highly restricted, secure access. 
• What is Geotagging?
• Geographical metadata added to everything
• 2025?
• Faster, safer, better, cloud services

Informative Speech Peer Notes

Dina 

Group B #1

Topic: Academic Coaching at UAH

Breaks down points well.

Clearly presented thesis

Used herself as a specific anecdotal example

Tried her best to speak without referring to notes, but did frequently view notes. Though an acceptable amount.

Clearly explained Academic Coaching

Gave stories of personal experience, and of preferences

Referred to sources, and statistics, but did not show a visual aid for number data.

DCoop

 Group B #1

Used comedy as a attention getter, and helped to settle the mood.

Used rhetorical questions

Uses and refers to academic evidence

Uses hypothetical scenarios 

Provides his own and expert opinions

Good use of slides, elaborated on points rather than just reading them

Good use of graphs and charts, he even explains them

Information Systems Independent Study Notes Chapter 4 and Chapter 5

Chapter 4

• What do Business Professionals Need To Know About Computer Hardware?
• CPU
• What is The CPU?
• Central Processing Unit
• The Brain of the Computer
• How Does The CPU Work?
• Works in Conjunction with Random Access Memory 
• Reads data and instructions from memory
• Stores results of computation in memory
• How is CPU Speed Expressed?
• Hertz
• Definition
• The Speed Cycles of CPUs
• Speeds Based On Computers
• Slow Personal Computers
• 1.5 Gigahertz
• Fast Dual Processor PC
• 3+ Gigahertz
• 32 Bit and 64 Bit CPUs
• Needs a 64 Bit Processor, to use more than 4GB of Memory
• Dual Processors vs Quad Processors 
• Have varying CPU speed, function, and cost.
• What Are Basic Types of Hardware?
• Server Farms
• Large Collection of Coordinated Servers
• Tablets
• Personal Computers
• Servers
• Smartphones
• Binary
• Definition
• Programming based on telling the difference between two states.
• Mechanical Methods for Binary
• Reflection
• Magnetic Polarization
• Light Switches
• How Can New Hardware Effect Competitive Strategies?
• Client
• What Do Clients Connect to, to receieve information?
• Servers
• Operating System
• Programs that control the client computer resources.
• Application Programs
• Applications that are processed on Client's Computer.
• Server
• Operating System
• Programs that control the server computer resources.
• Application Programs
• Applications that are processed on Server's Computer.
• What Do Business Professionals Need To Know About Software?
• Virtual Machines
• A Server's Computational Power Remotely Accessed in A Software Application 
• Granting the Illusion that someone has their computer.
• Ownership Vs Licensing
• License Software
• Right to Use A Specified Number of Copies
• It Limits a User's Liability
• Site License
• Costs a Flat Fee
• Installs Software on all company computers or at a specific site
• Open Source
• No license fee
• How Do Organizations Obtain Different Types of Applications?
• Applications You Can Get Off The Shelf
• Horizontal Applications
• Applications You Can Get Off The Shelf And Then Customized
• Horizontal Applications
• Vertical Applications
• Applications You Can Get Custom Developed
• One of a Kind Applications
• What is Firm Ware?
• Software installed into read only memory, the program's logic is designed into device's circuitry 
• Is Open Source Software A Viable Alternative?
• Depends on the Situation's Restraints and Requirements
• Free Open Source Software might require support and operational costs that are higher than normal licensing fees.
• What Are The Differences Between Native And Web Applications?
• Native Applications
• High Skill Level
• High Price
• Sophisticated
• Professional Programmers Only
• Run on any operating system and device
• Limited by the capability of browsers
• Web Applications
• Low to High Skill Level
• Professional Programmers, Web Developers, and Business Professionals Can Use Them
• Vary in Price
• Vary in Sophistication
• Thin-Client Applications
• You get them via the web
• Require Modern Browsers to Run
• Cheaper to Develop
• Cheaper to Maintain
• May Lack Wow Factor
• Why Are Mobile Systems Increasingly Important?
• The World is Connected, People Can Do Things on The Go
• What Are The Challenges of Personal Mobile Devices At Work?
• Advantages
• Cost Savings
• Greater Employee Satisfaction
• Reduced Need for Training
• Higher Productivity
• Reduced Support Costs
• Disadvantages
• Data Loss or Damage
• Loss of Control
• Compatibility Problems
• Risk of Infection
• Greater Support Costs
• 2025?
• New Jobs
• Everything is Connected

Chapter 5

• What is the Purpose of A Database?
• To organize and keep track of things and to organize and keep track of themes.
• Spreadsheets Vs Databases
• Spreadsheets
• Has only a single theme
• Are not made to be able to pull data
• Is good for serving one user
• Databases
• Have multiple themes
• Are made to be able to pull data
• Is good for serving multiple users
• Form
• An User Interface for the purpose of entering data.
• What is a Database?
• Relational Database
• Made up of Tables
• Tables are made up of rows and columns
• Rows and columns have a relationship with one another.
• Multiple Tables can be related with one another
• Meta Data
• Data about Data 
• Tables or Files + Relationship Among Rows in Tables + Meta Data
• What is a Database Management System?
• Program, licensed by vendors, used to create, process, and administer a database. 
• Operations
• Read Data
• Insert Data
• Modify Data
• Delete Data
• SQL
• Structured Query Language 
• Administering the Database
• Set up security system involving user accounts, passwords, permissions, and limits for processing.
• Limit user permissions in very specific ways
• Backs up data, adds structure, improves performance, and removes unwanted data. 
• Summary of Database Administration Tasks
• Operation
• Backup
• Recovery
• Adaptation
• Development
• Create and Staff Database Administration Function
• Form Steering Committee 
• Specify Requirements
• Validate Data Model
• Evaluate Application Data
• How do Database Applications Make Databases More Useful?
• Forms
• View Data
• Insert Data
• Update Data
• Delete Existing Data
• Queries
• Search Based Upon User Provided Data Values
• Reports 
• Generates a structured presentation of the data
• Uses Filters
• Application Programs
• Special operations
• Security
• Data Consistency
• How are Data Models Used For Database Development?
• Components of Entity Relationship Data Model
• Entities
• Something users want to track
• Primary Key
• Shorthand name of an Entity
• Attributes
• Describes entity characteristics
• Identifiers
• Uniquely identifies one entity instance from another instance of an entity.
• Client Side Coding
• Html5
• Css3
• JavaScript
• Server Side Coding
• C#
• Java
• Node.js Java Script
• How is a Data Model Transformed Into A Database Design?
• Normalization
• Converts one badly structured table into two or more well structured tables.
• Goal
• Construct tables with data about a single theme or entity.
• Purpose
• To minimize data integrity problems
• Data Integrity Problems
• Produce incorrect and inconsistent information
• Users loose confidence in information
• Systems gains a poor reputation
• Can only occur if data is replicated
• Summary of Normalization
• Represent Each Entity With A Table
• Entity identifier becomes table key
• Entity attributes become table columns
• Normalize Tables Are Necessary
• Represent Relationships
• Use foreign keys
• Add additional tables for N:M relationships
• What is the User's Role In Development of Databases?
• Users are the final judges
• Users' review of data models is crucial
• Ensure its accuracy reflects users' view of the business.
• Entities must contain all of the data, you and your employees need to do your jobs, and relationships must accurately represent your view of the business.
• User Mistakes will come back to haunt them.
• 2025?
• NOSQL DBMS is the Future

Additional Notes

• Rule of Themes
• For a Single Theme use a...
• Spreadsheet
• For Multiple Themes use a...
• Database

How To Research: Library Notes

• Micheal
• Occupation
• Library Researcher
• Purpose of His Speech
• To teach us how to perform proper research
• Credibility
• He has helped people perform research of all kinds.
• What is Micheal's Outline of the Day?
• Topics
• Building on Research
• Search strategies and tips
• Finding good sources
• Evaluating sources
• Research
• Information Literacy
• Definition
• Recognizing when you need certain information, where to go for it, how to evaluate it, and how to apply it to create something.
• Primary Sources vs Secondary Sources
• Primary Source
• Direct Sources, Data, Facts
• Secondary Source
• Academic, Peer-Reviewed, Sources
• Academic Content vs Popular Content
• Popular Content
• Is based on popular opinion
• Academic Content
• Academic
• Peer-Reviewed
• Written by scholars, experts
• What Websites Have Better Sources
• .edu
• .gov
• .org
• CRAAP Test
• Currency
• Relevance
• Authority
• Accuracy
• Purpose
• Searching Effectively
• Methods
• Search repeatedly using different key words and different databases
• Use filters to narrow your results
• Boolean Logic
• You want to search two different topics, and you want documents that cover one or the other.
• Ex. Topic 1 /or Topic 2
• You want to search two different topics, and you want documents that cover both.
• Ex. Topic 1 /and Topic 2
• You want to search a topic, but you don't want another topic.
• Ex. Topic 1 /not Topic 2
• When Taking Notes
• Make sure to always list the source and the page number of every note you take from a specific source.
• Good Sources
• Britannica
• Oxford Journals
• Oxford Reference Library
• UAH One Search
• What are Research Starters?
• If you search a topic on UAH One Search, you could find a research starter which is a relevant encyclopedia entry.
• How to do Domain Searches?
• site:(.edu,gov,etc)
• Think Tanks
• Definition
• Organization or Institution that conducts research and engages in advocacy in policy, politics, etc.
• Examples of Think Tanks
• Harvard Think Tanks
• Is a database of think tanks 
• Brookings Institute
• Carnegie Endowment for International Peace 
• RAND Corporation

Informative Speech Notes

Three Sources For Informative Speech

1. "Mission". Uahcampuscursive.blogspot.com. N.p., 2016. Web. 12 July 2016.
1. ("Mission")
2. Nobles, Marceilia. Informative Speech Interview. 2016. in person.
1. (Nobles)
3. "ABOUT US.". THE WORLD NEEDS MORE LOVE LETTERS. N.p., 2016. Web. 12 July 2016.
1. ("ABOUT US.")

Interview Notes

• What is your position in Campus Cursive?
• Vice-President
• Do you feel you know a lot about Campus Cursive?
• I feel I know a lot, but not as much as the president.
• Imagine I know nothing about Campus Cursive, what is Campus Cursive and how can I get involved?
• Campus Cursive is a group in which the members write anonymous encouraging notes, and leave them around campus for people to find. 
• If you want to get involved we have meetings under the stairway by Dunkin Donuts in Charger Union, on Friday afternoons. 
• They typically have free donuts. 
• How is Campus Cursive Relevant to the Average UAH Student?
• As far as the giving end, it is a good way for us to know that we are helping people have a better day, and for us to get together.
• On the receiving end, it is to help give those with a bad day, a bright smile and help to change their life for the better.
• How is Campus Cursive an Academic Group on UAH campus?
• We implement writing and creative skills, and you can use it to practice cursive writing.
• What is More Love Letters, and what does it have to do with Campus Cursive?
• More Love Letters is the mother corporation that started long before campus cursive, that does the same thing as campus cursive, but on a larger scale. They send notes to individual people as well as to a cause. Campus Cursive was started by one pretty awesome girl named Elizabeth. Aidan (President) helped Elizabeth to help develop Campus Cursive, he was following the message before Campus Cursive was fully fleshed out.

Annotated Bibliography

"ABOUT US.". THE WORLD NEEDS MORE LOVE LETTERS. N.p., 2016. Web. 12 July 2016.

"Mission". Uahcampuscursive.blogspot.com. N.p., 2016. Web. 12 July 2016.

Nobles, Marceilia. Informative Speech Interview. 2016. in person.