Grossmont College Collaboration Information System Essay
- Thank about yourself, there are many roles you play inyour life. Now in the class, you are a student. You are also an individual, a family member. Maybe you are also an employee or a business owner. Reflect on all the decision you have made (for example, going to school, whether to go to a party you are invited, which major to study, etc.) Give examples for each of the three levels of decision making (i.e. Operational, Managerial, Strategical decisions). Then explain how you should best make those decision (structured, unstructured, collaboration needed, etc.
- MS Project Exercise. Download the attached “Ch7-MSProject.docx” word file. Follow the instruction to complete the exercise and paste the Gantt Chart below.
- MS Access: Suppose that you have been asked to assist in the managerial decision about how much to increase pay in the next year. Specifically, you are tasked to determine if there are significant salary differences among departments in your company. You are given an Access database with a table of employee data with the following structure EMPLOYEE(Name, Department, Specialty, Salary)
where Name is the name of an employee who works in a department, Department is the department name, Specialty is the name of the employee’s primary skill, and Salary is the employee’s current salary. Assume that no two employees have the same name. Design and run Access queries to obtain the answers to these questions, using the data in the file Ch7-Problem3.accdb. You have been asked to answer the following queries:
a. List the names, department, and salary of all employees earning more than $100,000.
b. List the name and specialties of all employees in the marketing dept.
c. Compute the average maximum and minimum salary of employees.
d. Compute the average, minimum, and maximum salary of employees in the Marketing department.
e. Compute the average, minimum, and maximum salary of employees in the Information Systems department.
f.Compute the average salary for employees in every department. Use Group By.
g..Explain how the data in your answer contributes to the salary increase decision.
h .Suppose other team members want to use your Access application. Name three ways you can share it with them and describe the advantages and disadvantages of each.