MIS Homework 1r
Sara Al-Essa
ID: 201002374
QSet1.1- Week 1&2
1. What are data, information and knowledge? Provide an example of transformation of data to knowledge using as an example the Accounts Receivable (AC) in the accounting department or personnel data in the HR department.
Data: Consist of raw facts, such as an employee number, total hours worked in a week, inventory part numbers, or sales order.
Example: Calculations, For example: a compilation of sales invoices at the end of the day and see the numbers, types and sizes of goods sold.
Information: A collection of facts organized and processed so that they have additional value beyond the value of the individual facts. knowledge: The awareness and understanding of a set of information and ways that information can be made useful to support a specific task or reach a decision.
2. Type in the following spreadsheet, and format it to look like the sample below.
Type in all text and numbers shown in the spreadsheet below.
Format all numbers as a currency.
Center the spreadsheet heading 'Sales for the Month' across the spreadsheet.
Format all text as displayed in the sample below.
Create formula's to display a total for each sales rep.
Create formula's to display a total for each product.
Create a formula to calculate the total sales for all sales rep's for the month. Assuming that you have 1000 salesman instead of 6, what could be considered data and what information? Display information using graphics? What is needed to create knowledge relating the sales mode of your sales force?
Salesforce Knowledge is a knowledge base where users can easily create and manage content, known as articles, and quickly find and view the articles they need. After you set up Salesforce Knowledge in your organization, users can write, edit, publish, and archive articles using the Articles Management tab or find and view published articles
ID: 201002374
QSet1.1- Week 1&2
1. What are data, information and knowledge? Provide an example of transformation of data to knowledge using as an example the Accounts Receivable (AC) in the accounting department or personnel data in the HR department.
Data: Consist of raw facts, such as an employee number, total hours worked in a week, inventory part numbers, or sales order.
Example: Calculations, For example: a compilation of sales invoices at the end of the day and see the numbers, types and sizes of goods sold.
Information: A collection of facts organized and processed so that they have additional value beyond the value of the individual facts. knowledge: The awareness and understanding of a set of information and ways that information can be made useful to support a specific task or reach a decision.
2. Type in the following spreadsheet, and format it to look like the sample below.
Type in all text and numbers shown in the spreadsheet below.
Format all numbers as a currency.
Center the spreadsheet heading 'Sales for the Month' across the spreadsheet.
Format all text as displayed in the sample below.
Create formula's to display a total for each sales rep.
Create formula's to display a total for each product.
Create a formula to calculate the total sales for all sales rep's for the month. Assuming that you have 1000 salesman instead of 6, what could be considered data and what information? Display information using graphics? What is needed to create knowledge relating the sales mode of your sales force?
Salesforce Knowledge is a knowledge base where users can easily create and manage content, known as articles, and quickly find and view the articles they need. After you set up Salesforce Knowledge in your organization, users can write, edit, publish, and archive articles using the Articles Management tab or find and view published articles