Info Tool I (Google Forms) of IST 309
Info Tool I (Google Forms)
Background: Your company is looking for a market area for a new product/location. Your assignment is to develop, disseminate, and collect data for a survey on a topic of your choice (related to a new market area for a new product/location). Think of it as a real life scenario, and assess your data to determine what the data tells you about your company’s new product/location.
Requirements: You are required to use Google Docs Form application, ask pertinent questions for your selected topic, and obtain at least 20 survey responses.
Also, you will prepare a professional looking, written report that discusses:
- The goals of your survey
- Detailed analysis of your survey responses
- How this information can be useful for your company (based on your responses, reason 1, reason 2, reason n why X new product/location would be/or not a good idea).
When submitting your paper, you are also required to include the actual responses from the Form’s generator (graphic/spreadsheet). You can include that at the end of your report (but not instead of it), or you can attach it as a separate document.
There is no specific number of pages for this assignment. It has to have enough pages to prove your point and to cover all the requirements.
You will post both the copy of your report and the responses from the Form’s generator on Blackboard, under “Info Tool I (Google Forms)” link.
(https://www.youtube.com/watch?v=XCefN8RHqzg&feature=youtu.be)
UNIT 3
Data and
Defining Big Data
Big Data Generally Consist of:
– Traditional enterprise data
– Machine-generated/sensor data
– Social Data
– Images captured by billions of devices
located around the world
Characteristics of Big Data
• Volume
• Velocity
• Variety
The Database Approach
Database management system (DBMS)
minimize the following problems:
–Data redundancy
–Data isolation
–Data inconsistency
Data Hierarchy
Bit
Byte
Field
Record
File (or table)
Database
Designing the Database
Data model
Entity
Attribute
Primary key
Secondary keys
Entity-Relationship Modeling
• Database designers plan the database
design in a process called entity-
relationship (ER) modeling.
• ER diagrams consists of entities, attributes
and relationships.
– Entity classes
– Instance
– Identifiers
Database Management Systems
Database management system (DBMS)
Relational database model
Structured Query Language (SQL)
Query by Example (QBE)
Normalization
• Normalization is a method for analyzing
and reducing a relational database to its
most streamlined form for:
– Minimum redundancy
– Maximum data integrity
– Best processing performance
• Normalized data is when attributes in the
table depend only on the primary key.
Data Warehousing
Data warehouses and
Data Marts
Organized by business dimension or
subject.
Multidimensional.
Historical.
Use online analytical processing.
Benefits of Data Warehousing
•End users can access data quickly and easily
via Web browsers because they are located in
one place.
•End users can conduct extensive analysis
with data in ways that may not have been
possible before.
•End users have a consolidated view of
organizational data.
Data Marts
• A data mart is a small data warehouse,
designed for the end-user needs in a
strategic business unit (SBU) or a
department.
Knowledge Management
• Knowledge management (KM)
• Knowledge
• Intellectual capital (or intellectual assets)
Knowledge Management System Cycle
•Create knowledge
•Capture knowledge
•Refine knowledge
•Store knowledge
•Manage knowledge
•Disseminate knowledge