Working with Data
The function to be used to sort a data set containing teacher salaries by the Dubuque school district in the math department with the highest salary.
What is =MAXIFS()
A row of data is also called this.
What is a record.
A1 is an example of this in an Excel spreadsheet
What is a relative reference.
Traffic prediction, email spam and malware filtering, image recognition, and speech recognition all use this.
What is machine learning.
The IT employee that would have overall responsibility for the organizations systems.
What is the CIO.
If you wanted to count up the number of courses that you took that were accounting, business and sport management, this is the number of criteria rows you would include?
What us 3
A students network ID would be a good example of this for a database.
What is a primary key.
This is a good choice because it is distinct to the student. First or last name, zip code etc. would not work because more than 1 student could have those.
If you left all the criterion fields blank when using =DSUM() this should be the result.
What is the same as =SUM()
This is typically the starting point for building a successful Machine Learning model.
What is training the ML Algorithm with training data.
Before using Excel's subtotal feature, you should do this.
What is sort the data.
This is a tool that might be easier than using a database function ie. =DAVERAGE()
What is a Pivot table
If you were going to sort records in a database, how many sort keys should you include?
What is "Enough so each record can be uniquely sorted."
If you wanted to compute your GPA for all 1 and 2 credit courses this is the criteria that would work.
What is <3
This ML "learning technique" would require the least amount of human intervention, e.g., the computer is left to "figure it out"?
What is unsupervised learning.
The following skills/areas of expertise are needed in an organization to train or hire employees to develop this type of system: Applied Statistics, Machine Learning, Signal Processing, Operations Research and more.
What is a prescriptive analytics systems?
If you wished to perform a simple linear regression and display this on a chart, this chart type would be the most appropriate to use.
What is a XY Scatterplot Chart
SQL or structured Query Language is typically used to manage data in this system.
What is a Relational Database Management System.
This is the character that is used for termination for a SQL command. ie. it ends the statement with this.
What is a semi-colon (;)
Machine Learning (ML) requires this to help "train" the model?
What is known results.
SQL syntax rules say that you should write your SQL commands in this case.
What is "It does not matter"- SQL is case-insensitive.
Suppose you had a list of student's grade records (student, course, grade). This would be the field that was most relative to create a report from an instructors perspective.
What is course.
This has commands that can create tables, alter field characteristics, select/sort or filter records and delete or drop tables.
What is SQL
SQL was developed in the 1970s by Don Chamberline and Ray Boyce while working at this company?
What is IBM?
To sort the records from one table in an SQL query, this clause must be included?
What is ORDER BY
Who is going to crush this final?
What is everyone!