MGMT 345 1st EditionExam # 2 Study Guide Lectures: 11 - 17Lecture 113 Parts of an Interview:-Cultural (for the company/person fit)-Behavioral (scenarios- what would you do if…?)-Statistical (personal accomplishments)Access Lab #1First download the seed database for the assignment off of D2L under week 7 content. When opening tabs, right click to select design view. Rather than using your DawgTag as the Lab Manual instructs, add your own name as Student 6. Under Instructor, under design view, correct the spelling of “City”Under both the “classes” and “student enrollment” sections, be sure that all of the spelling is exactly the same as the Lab Manual. If it is not, there are many technical issues and the lab mustbe redone. Lecture 12Access Lab # 2:For Access Lab #2, there are no special additional instructions other than what is provided in thelab manual. The only thing to make a special note of, when finishing the assignment, make sure you have closed the Navigation Pane and reopened it so that “Add New” is not visible. Lecture 13- SWOT: strength, weakness, opportunities, &threats- Saved $20 million on employee’s salaries (analytical)o Cut loss of employees by ½ o Using Big Data to do that- Big Data Sets are large, diverse, complex, longitudinal & distributedCover long periods of time- Videos online: 1 million hours of new videos being uploaded on the web- Sources: Instruments Email Sensors Video Transitions Click ScreensAll Other Digital*have IPs (were running out)Everything has IPs nowIOT: “Internet of Things”- Continuous Planning CyclePlan AssessDo Adjust- There’s a danger in putting in databases: access to all the informationo Ex: Target information breach- Data Model: created on in Access- Moshe ZLoof: IBM research, created a visual query o Mid 1970a- Michael Dell- no chairs in conference rooms; quicker meetingso Founder of Dell- 3 sales KPIso Sales growth, sales opportunities, product performance- OLTP & OLAP work together- 3 types of Data in Big Datao Structuredo Semi-structured XBRLo Unstructured- blogging, YouTube, Pinterest, tweets, etc.  Text, video- Facebook wants to map out the web by the like button- Clustered Documents- Netflix recommendations- Networked Documents- graph databaseso Will show: 6 degrees of separation theory- we are separated by 6 degrees- Expert Systems- if then situations until you get to the problem - Digital dashboard is changing in real timeLecture 14Access #3 Assignment was extended until noon on Saturday. Using query wizard you use “QBE” or query by example. Under the Create tab, select query wizard, simple query, choose class id and name, select semester, select student id, last name, first name. Name the query. Under Report wizard, select all the fields from the query and rename the Report. Repeat the same steps for the next queries and reports, and follow the lab manual for formatting and specifics.Lecture 15Make to Stock vs. Make to Order:An example of a make to stock item would be a Toyota model car. The amount of stock is determined by forecasting. An example of a make to order item would be a Bugatti. These are cars that are not made until a specialized order is placed. Toyota Prius:In recent years the Toyota Prius had a problem with auto acceleration leading to runaway cars. The custom software that was used to develop the Prius’ system had not gone through enough testing (or had a lack of testing), which led to the glitch, which led to the problem. Software as a Service: SaaSWith current software as a service, there is no need to continuously buy new updates. The software continuously updates itself. Amdocs: The largest group in telecommunications. Lecture 16This lab will be due Sunday night. The first step is to customize “class enrollment.” Right click to enter design view. The see through boxes are labels and the non-see through boxes are data from the database. Right click the first name, click total, click count records. Create a label for it, click the Aa button and draw it to the left of “count” call it “students enrolled”Line up all the boxes so that when you look at the report in print preview it all looks neat. Create a Student Enrollment Query from design view, enter [Enter student ID #] for a popupLabel the individual student enrollment and create an extra column for credit hours. Label that too. Lecture 17There are a few specific things from the labs that will be found on the test:The Relationship Diagram has 2 tables. 1 primary key and the name of 2 primary keys. Student ID and Student. You need to know what a Primary Key identifies. There is a visual error between instructor assignments and classes. The problem is with instructor assignments. Know the dominant use of forms and queries.Popup “criteria” Sum= the mathematical function used for counting