CIS 105 Knowledge Checks Exam Three
What percentage of all data is unstructured?
80%
What is brainstorming in the context of R&D?
A collaborative thought process to generate ideas and directions.
What is a Transaction Processing System (TPS)?
A computerized database system that records and processes day-to-day transaction
What does a summarized report provide?
A condensed version of detailed data for easier analysis.
What is a Business Plan?
A document that outlines a company's goals, strategies, financial forecasts, and operational details.
What is a strategic decision?
A high-level choice that significantly impacts long-term goals and direction.
What is an 'App'?
A self-contained program with a specific purpose.
What is storyboarding in mobile app development?
A series of illustrations arranged in sequence to pre-visualize the appearance and functionality of the app.
What is a Software Development Kit (SDK)?
A set of software development tools enabling programmers to create applications.
What is a spreadsheet?
A software application that allows users to organize, analyze, and manipulate numerical data in a tabular format.
What is a tactical decision?
A specific short-term choice made to implement strategies and achieve immediate objectives.
What are the five core functions that businesses must fulfill?
Accounting, production, research & development, human resources, marketing.
What does the 'Product' aspect of the Four P's of Marketing include?
Actual goods and services offered to customers.
Which software is NOT typically used as a spreadsheet application?
Adobe Photoshop.
What does a Point of Sale (POS) system record?
All pertinent transactions in the TPS database.
What is Quickbase?
An AI product that helps build app interfaces and workflows.
What is the role of a template in mobile app development?
An electronic file that's pre-designed with a custom format and structure ready to be filled in.
What is a database?
An organized collection of data stored and accessed electronically.
What role can AI play in creating a sales forecast?
Analyzing market trends, customer demographics, and spending patterns.
What does BI primarily focus on?
Analyzing past and present data to provide insights
What does the term 'native app' refer to?
Apps that come preinstalled on mobile devices.
What is one of the main differences between BI and AI?
BI requires human intervention for data analysis
Which HR software is known for its user-friendly interface and robust reporting capabilities?
BambooHR.
What is descriptive analytics?
Baseline analytics that define past data
How did the Internet revolutionize software distribution?
By enabling distribution through the World Wide Web.
What is one common way to monetize a mobile app?
Charging per download.
What are expenses in a business context?
Costs incurred by a business in its normal operations to generate revenue.
What does prototyping involve in mobile app development?
Creating a preliminary model of the app that is developed, tested, and refined.
What can spreadsheets be used for in budgeting and financial planning?
Creating budget templates and tracking expenses.
What is the main goal of the research and development (R&D) department?
Creating new products and services or enhancing existing ones.
What is Looker used for?
Data exploration and visualization
What is one key objective of using spreadsheets?
Data organization.
What are dashboards used for?
Depicting specific data analyses through visualization
What type of analytics does BI usually deal with
Descriptive analytics
Who defined the concept of 'The Four P's of Marketing'?
E. Jerome McCarthy.
What is functional testing?
Ensuring that the mobile app prototype is functioning per requirements.
What is data mining?
Examination of vast datasets to discover patterns and connections
What section of a Revenue/Expense spreadsheet forecasts the money spent over the course of a year?
Expense section.
What is the first step in the ETL process?
Extract
What does ETL stand for?
Extract, Transform, Load
What is Big Data?
Extremely large and complex datasets that cannot be easily managed using traditional data processing techniques
What feature allows spreadsheets to perform powerful calculations?
Formulas.
What is GAAP?
Generally Accepted Accounting Principles.
What is the purpose of data visualization?
Graphical representation of data mining analytics and BI results
What tool is often used by HR departments to create an organizational chart?
HR software.
Which marketing software is known for its comprehensive tools for content management, email marketing, and SEO?
HubSpot.
Which tool is used for real-time computer communication in businesses?
Instant messaging.
What question should be asked when assessing the salary listed in the Expense section?
Is the salary realistic and sufficient for the owner's needs?
What is the benefit of using the same SQL query for different report formats?
It ensures consistency and accuracy across different reports.
Why is the 'Your Salary' line item important in the Expense section?
It represents the owner's expected earnings from the business.
What is Tableau known for?
Its intuitive interface and powerful visualization capabilities
What might the bank require in the Expense section of a Revenue/Expense spreadsheet?
Listing all possible expenses, no matter how big or small.
Which software is widely used in engineering, science, and economics for numerical computation and visualization?
MATLAB.
What is the primary function of the human resources department?
Managing personnel and workforce-related matters.
What is the main responsibility of the accounting department?
Measuring and providing financial information.
What might the 'Inventory' line item in the Expense section represent?
Money to buy products from wholesalers.
What did Lily do to manage her new business finances?
Opened a separate bank account and carefully tracked her money.
What is the purpose of project management software like Microsoft Project?
Organizing and managing resources to schedule a project from start to finish.
What is one of the most common uses of a spreadsheet in business?
Predicting future financial outcomes.
What is the responsibility of the production department?
Preparing goods and services for commercial sale.
What is the focus of the marketing department?
Promotion and selling of products or services.
What does the SELECT statement in SQL do?
Queries specific fields from a database.
Which software is widely used by small to medium-sized businesses for accounting?
QuickBooks Online.
What are the three main aspects of reporting?
Reporting Summarization Levels, Analysis & Predictive Reporting, Management Level Reporting.
What are periodic reports?
Reports produced at given intervals such as daily, weekly, or monthly.
Which ERP software is known for supporting a wide range of business processes, including production planning?
SAP ERP.
What does it mean to 'license your code' in app development?
Selling or licensing the programming code to other organizations that prefer to skip the initial development phase.
What is Hadoop used for?
Storing and processing large sets of data across multiple servers
What is a common feature of InVision?
Strong collaboration features and integration with tools like Jira and Slack.
What language is used to query a TPS database?
Structured Query Language (SQL).
What are the three types of data?
Structured, Unstructured, Semi-structured
Which of the following is a programming language used for mobile app development?
Swift (XCode).
What is interruption testing?
Testing how the mobile app reacts to interruptions like notifications, power loss, and network outages.
What is one potential drawback of forecasting overly optimistic sales growth?
The bank might question the growth assumptions.
What does a variance report show?
The difference between actual and forecasted data.
What does the Profit/Loss section of a Revenue/Expense spreadsheet calculate?
The difference between total revenue and total expenses.
What significant event in 2008 transformed the landscape of mobile apps?
The establishment of app stores by major players such as Apple, Google, and Microsoft.
What does the 'Forecasted Monthly Growth %' in the Revenue section indicate?
The expected increase in sales each month.
What does performance testing examine?
The performance and behavior of the mobile app under specific conditions like low battery or bad network coverage.
What is wireframing?
The process of creating a basic visual guide or blueprint of a mobile app's structure and functionality.
What is MapReduce?
The processing arm of Hadoop
What is Business Intelligence (BI)?
The use of data analysis tools and techniques to extract actionable insights from structured data
What is one benefit of using AI tools like Quickbase and AppSheet for app development?
They simplify app development without requiring extensive coding knowledge.
What is the purpose of Email Marketing Software (EMS) like Constant Contact and MailChimp.com?
To assist in designing, sending, and managing email lists of customers.
What is the purpose of a data warehouse?
To consolidate disparate data in a central location
What is the primary purpose of business reporting?
To facilitate sound business decisions.
What is the purpose of the Revenue section in a Revenue/Expense spreadsheet?
To forecast sales and income.
What is the primary purpose of spreadsheets?
To provide a dynamic and user-friendly environment for managing and analyzing numerical data.
What is the purpose of a detailed TPS report?
To provide highly detailed information about every transaction for a given day.
What is trend reporting used for?
To reveal trends or tendencies in a business.
What is the main purpose of Artificial Intelligence (AI)?
To simulate human intelligence in machines
What is the main goal of usability testing?
To verify if the mobile app prototype is achieving its goals and receiving a favorable response from users.
What does revenue refer to?
Total income generated by a business through its primary operations before deducting any expenses.
What are the 'Four V's' of Big Data?
Volume, Velocity, Variety, Veracity
What is collaboration in a business context?
Working together with others to achieve a common goal.
