IL_EX365_2021_5a_ZacharySutton_Report_1
.xlsx
keyboard_arrow_up
School
Northern Arizona University *
*We aren’t endorsed by this school
Course
360
Subject
Computer Science
Date
Dec 6, 2023
Type
xlsx
Pages
13
Uploaded by MegaResolve8522
Zachary Sutton
GE ver. 17.0.1-rc0000
1.
1/1
Format a range as a table.
Apply a table style.
2.
0/1
Add a data validation rule to a range.
Add an input message to a data validation rule.
Add an error alert to a data validation rule.
3.
1/1
Remove a duplicate record from a table.
Add a record to a table.
4.
1/1
Sort a table.
5.
1/1
Format a table.
6.
1/1
Use an Advanced filter to copy data.
Change the column width.
7.
1/1
Remove a filter from a table.
8.
1/1
Apply a table style.
9.
1/1
Delete a record from a table.
10.
1/1
Add a column to a table.
Enter text in a cell.
Create a formula.
Change the number format.
Insert a total row in a table.
Summarize table data with a total row.
11.
1/1
Create a formula using a function.
12.
0/1
Create a formula using a function.
13.
0/1
Create a formula using a function.
14.
1/1
Filter a table.
Sort a table on multiple ranges.
15.
1/1
Format a table.
Filter a table.
16.
2/2
Add print titles to a worksheet.
17.
2/2
Format a range as a table.
18.
2/2
Enter values into a range.
Format a range as a table.
Apply a table style.
Set the name of a table.
19.
0/2
Create a formula using a function.
In the Course Details worksheet, the formula in cell E14 should contain the XLOOKUP function.
20.
2/2
Create a formula using a function.
SUBMISSION #1 | SCORE IS:
20
OUT OF
25
Justin Douglas is the director of professional development at the Georgia Medical Center. In addition to training
courses offered to employees, the Georgia Medical Center also hosts continuing education seminars for medical
professionals around the country. Justin has been tracking both types of courses in an Excel workbook and asks for
your help in managing and analyzing the data.
Go to the
Training
worksheet. Justin wants to sort and filter the data on the worksheet, which lists the employees
and the training courses they have requested.
Format the range A3:G43 as a table with headers using the
Lime, Table Style Light 9
table style.
The training courses are offered in two sessions. Justin wants to make sure that employees who enter training
course data enter only "1" or "2" in the Session column.
Create a data validation rule for the Session column as follows:
a. For all cells in the Session column, create an in-cell drop-down data validation rule that accepts only entries from
a list.
b. Use
1, 2
as the Source values.
c. Provide an input message that uses
Sessions
as the title and the following sentence as the input message:
Enter the number of sessions.
d. Apply a Stop style error alert that uses
Number of sessions
as the title and the following sentence as the error
message:
Enter 1 or 2.
In the Training worksheet, the data validation rule in the range E4:E43 should have an input message titled
"Sessions" with the input message "Enter the number of sessions."
In the Training worksheet, the data validation rule in the range E4:E43 should have an error alert that uses the
Stop style with the title "Number of sessions" and the error message "Enter 1 or 2."
Justin received a request from another employee who wants to take a training course and wants to delete any
duplicate records from the table. Add and remove records as follows:
a. Find and remove a record with a duplicate Employee ID number.
b. Add a new record to the end of the table and then insert the data shown in Table 1, using the in-cell drop-down
list to enter the Session value.
The table is currently sorted by course name, but Justin prefers to have it sorted by employee ID so that he can find
the employee records quickly.
Sort the table in ascending order (smallest to largest) by the values in the Employee ID column.
Apply a table style option to bold the employee IDs in the first column of the table to make it easier to differentiate.
After Justin receives a request from an employee, he contacts the department manager for approval so that the
employee can attend the course. He wants to print a list of employees who have not been approved for training
courses.
Use an advanced filter to provide this information for Justin as follows:
a. In cell I4, enter
No
as the value to use for filtering the criteria range.
b. Create an advanced filter that copies the results to another location.
c. Use the table of employee and training course data (range
A3:G43
) as the List range.
d. Use the information you set for filtering (range
I3:I4
) as the Criteria range.
e. Copy the results to the range starting in cell
I6
.
f. Resize columns I:O to their best fit.
Go to the
Continuing Education
worksheet, which includes a filtered table named Courses.
Remove the filter from the Courses table to display all the records.
Apply the
Lime, Table Style Light 9
table style to the Courses table to use a format similar to other tables in the
workbook.
Justin notices that no one has enrolled in Session 2 of the Holistic Nursing course (Course ID 6755).
Remove the record for Course ID 6755 from the table.
Georgia Medical Center charges a per person fee for attending a continuing education course to cover the costs of
hiring medical experts to teach the courses. Justin wants to display the total amount charged for each course, the
total for all courses, and the number of continuing education courses offered.
Provide this information for Justin as follows:
a. Insert a new column in the table to the right of the Open Seats column.
b. Use
Total Charged
as the column heading of the new column.
c. In cell H7, enter a formula without using a function that uses structured references to multiply the price of the
first course (
[@Price]
) by the number of people enrolled (
[@Enrolled]
).
d. Apply the Accounting number format with zero decimal places to the newly created column.
e. Add a
Total Row
to the Courses table, which automatically totals the amounts in the Total Charged column.
f. In cell B29, use the total row to display the count of the continuing education courses.
Justin has created an area in the range J1:L4 for looking up data in the Courses table. First, he wants to find the
number of people enrolled in a specific course. He has already entered the course ID in cell J2.
Look up the number of people enrolled in the course with Course ID 6120 as follows:
a. In cell J4, begin to enter a formula using the
VLOOKUP
function.
b. Use the Course ID in cell
J2
as the value to look up.
c. Use the
Courses
table as the table to search.
d. Display the value in column
6
of the table.
e. Specify an exact match (
FALSE
) for the range lookup.
Justin also wants to calculate the total charges for courses offered in a specific session. He has already entered the
session number in cell K2.
Calculate the total charges for courses offered in Session 3 as follows:
a. In cell K4, begin to enter a formula using the
DSUM
function.
b. Use the
Courses
table (range A6:H29) including the headers and the data as the formula database.
c. Use the
Total Charged
field header (in cell H6) as the field to summarize.
d. Use the values Justin set up in the range
K1:K2
as the criteria.
In the Continuing Education worksheet, the formula in cell K4 should use Courses[[#Headers],[Total Charged]]
as the field argument.
The third calculation Justin wants to make is to identify the number of open courses, which are courses that have at
least one open seat.
Calculate the number of open courses as follows:
a. In cell L4, begin to enter a formula using the
DCOUNTA
function.
b. Use the
Courses
table (range A6:H29) including the headers and the data as the formula database.
c. Use the
Open Seats
field header (in cell G6) as the field to count.
d. Use the values Justin set up in the range
L1:L2
as the criteria.
In the Continuing Education worksheet, the formula in cell L4 should use the Open Seats field header as the
field argument.
Justin wants to list the courses in each session that are priced at more than $500.
Filter and sort the Courses table as follows:
a. Use a number filter in the Price column to display courses with prices greater than $500. (
Hint
: Click the Filter
button in the Sort & Filter group on the Data tab to display the filter arrows in the table.)
b. Sort the filtered table in ascending order first by Session and then by Price.
Go to the
All Courses
worksheet, which includes a table named All_Courses that lists training and continuing
education courses. Justin wants to identify courses concentrating on the emergency room (ER).
a. Apply banded rows to the All_Courses table.
b. Filter the All_Courses table using a custom AutoFilter to display only course names beginning with "ER".
Prepare the
All Courses
worksheet for printing by using the data in row 6 as the print titles.
Go to the
Course Details
worksheet, which includes course data such as classroom locations and instructor
evaluations.
Justin included a table named Locations in the range A3:C9 but does not plan to filter or sort the data or use any
other table features with it. Convert the Locations table to a range.
Justin needs to insert a table listing the courses available online. Insert the new table as follows:
a. Beginning in cell A11, enter the data shown in Table 2.
b. Format the range A11:C14 as a table using the
Lime, Table Style Light 9
table style, specifying that the table
has headers.
c. Use
Online
as the name of the new table.
The Evaluations table in the range E3:I9 ranks the six most popular courses and notes the average evaluation
scores that the four full-time instructors received. Justin has created an area in the range E11:F14 for looking up
data in the Evaluations table.
Look up the average evaluation score earned by instructor Egan for the Emergency Care course:
a. In cell E14, begin to enter a formula using the
XLOOKUP
function.
b. Use the instructor name in cell
E12
as the value to look up.
c. Use a structured reference to the header row of the
Evaluations
table as the table to search.
d. Return the value in the range
E4:I4
.
Find the rank in popularity of a course listed in the Evaluations table as follows:
a. In cell F14, begin to enter a formula using the
MATCH
function.
b. Use the course name in cell
F12
as the value to look up.
c. Use the
Instructor
column in the Evaluations table (range E4:E9) as the column to search.
d. Specify an exact match (
0
) for the match type.
Illustrated Excel 365/2021 | Module 5: SAM Project 1a
Author:
No
Illustrate
Georgia Medical Center
MANAGE AND ANALYZE TABLE DATA
Zachary Sutton
ote: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from t
ed Excel 365/2021 | Module 5: SAM Project 1a
Training Courses - Spring
Employee ID
Employee Name
Department
Course
Session
Hours
Approved
2002
Carol Ferrin
Nursing
Business Writing
1
3
Yes
2009
Robert Beyler
Operations
Project Management
2
4
Yes
2011
Dale Hasse
Financial
Time Management
1
2
No
2017
Anna Huang
Medical surgical
Time Management
1
2
Yes
2018
Stefan Sayavong
Medical nonsurgica
Conflict Communication
2
4
No
2025
Kara Polenz
Financial
Business Writing
2
3
Yes
2029
John Martelli
Human resources
Interpersonal Effectivenes
1
3
Yes
2030
Lakisha Newens
Financial
Medical Terminology
1
8
No
2033
Kim Maramoto
Medical nonsurgica
Project Management
1
4
Yes
2037
Clifford Gates
Nursing
Conflict Communication
1
4
Yes
2042
Tina Hernandez
Human resources
Interpersonal Effectivenes
2
3
Yes
2044
Oscar Jackson
Medical surgical
Conflict Communication
2
4
Yes
2048
Abe Khan
Operations
Medical Terminology
1
8
No
2051
Melissa Rendall
Human resources
Business Writing
1
3
Yes
2052
Anita Mora
Nursing
Time Management
2
2
Yes
2056
Sarah Sanchez
Nursing
Time Management
2
2
Yes
2059
Arden Kellor
Financial
Interpersonal Effectivenes
1
3
Yes
2062
Nicole Singh
Medical nonsurgica
Conflict Communication
2
4
Yes
2068
Tyrell Fisher
Operations
Project Management
1
4
No
2073
Javier Guadalupe
Nursing
Interpersonal Effectivenes
1
3
No
2075
Mason Ramos
Nursing
Interpersonal Effectivenes
1
3
Yes
2080
Kendall Briggs
Nursing
Conflict Communication
2
4
Yes
2087
Ming-Li Chang
Human resources
Medical Terminology
1
8
Yes
2089
Amanda Atalla
Medical nonsurgica
Business Writing
2
3
Yes
2095
Jennifer Scott
Nursing
Project Management
1
4
Yes
2100
Mike Graf
Operations
Time Management
2
2
Yes
2106
Rosa Linder
Financial
Business Writing
2
3
No
2110
Ben McCord
Nursing
Interpersonal Effectivenes
1
3
Yes
2118
Tamila Patel
Financial
Business Writing
2
3
Yes
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
1.6
Using SQL Server (Not Oracle)
arrow_forward
Q7: Using the AIRPORT KLX Table (Textbook page 131), describe an example that illustrates the insertion anomaly.
Q8: Using the AIRPORT KLX Table (Textbook page 131), describe an example that illustrates the deletion anomaly.
Q9: Using the AIRPORT KLX Table (Textbook page 131), describe an example that illustrates the modification anomaly.
arrow_forward
4:04
l LTE
4:04
i LTE
DB Quiz No.5 (12:30@ULJI selga)
DB Quiz No.5 (12:30@ouI selga)
CREATE TABLE Institution (name
VARCHAR(50),country VARCHAR(50).year
CREATE TABLE HighDegree
(professorID INT REFERENCES
Professor(ID).projectID INT REFERENCES
Project(ID),schoolName
VARCHAR(50),institutionName
VARCHAR(50), FOREIGN KEY
(schoolName,institutionName)
REFERENCES
School(name.,insitutionName), PRIMARY
KEY (professorID, studentID, schoolName,
institutionName);
O Number
INT,
(name, country):
PRIMARY KEY
O
Name and Num
WA
The following is an instance of the relation:
CREATE TABLE Author (researcherlD INT
REFERENCES Researcher(ID),.paperID INT
REFERENCES Paper(ID).PRIMARY KEY
(researcherlD, paperID));
O Name
Based on the above, indicate for each of the
following sets of attributes whether it is a
key for Articles Table?
CREATE TABLE PartOf (professorID INT
REFERENCES Professor(ID), studentID INT
REFERENCES Researcher(ID),PRIMARY
KEY (professorID, projectID);
Indicate which one of the following…
arrow_forward
3.9 LAB - Select lesson schedule with inner join
The database has three tables for tracking horse-riding lessons:
Horse with columns:
ID - primary key
RegisteredName
Breed
Height
BirthDate
Student with columns:
ID - primary key
FirstName
LastName
Street
City
State
Zip
Phone
EmailAddress
LessonSchedule with columns:
HorseID - partial primary key, foreign key references Horse(ID)
StudentID - foreign key references Student(ID)
LessonDateTime - partial primary key
Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.
Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs.
arrow_forward
<!--
Instructions
============
1. Generate a table using the data in the <script> tags below.
The table columns should be generated dynamically based on the data. They should not be hardcoded.
2. Clicking on a table header should sort the table by the column that was clicked on.
Clicking the same column a second time should sort in descending order.
You may use third-party libraries, but you cannot use any built-in table components.
Feel free to style the table however you like with CSS.
-->
<!DOCTYPE html>
<html lang="en">
<head>
<metacharset="utf-8" />
</head>
<body>
<divid="root">TODO: generate table</div>
</body>
<script>
vardata=[
{
Username: "booker12",
Identifier: "9012",
"First Name": "Rachel",
"Last Name": "Booker",
},
{
Username: "grey07",
Identifier: "2070",…
arrow_forward
Android Studio
arrow_forward
Exercise 3: Multiple Scatter plots
Generate scatter plots between every pairs of numerical columns from the "iris" dataframe as a set of subplots
arrow_forward
Create pseudo code for this algorithm.
arrow_forward
Information Techfiology department
Q-Design a system for car parking database, should have at least tables. In addition to build
schema, the required is:
1- write all instruction's to do this structure.
2- Make new field with titles comments to first table has data type integer.
3- Edit the new field to be character data type.
4- Remove any column from any table.
arrow_forward
# coding: utf-8
# ### Section 6 Homework - Fill in the blanks
# Import the packages needed to perform the analysis
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
import warnings
warnings.filterwarnings('ignore')
# Import the data
mov = pd._('P4-Section6-Homework-Dataset.csv', encoding = 'latin1')
# check columns in dataset and rename the column without spaces
mov._=[]
# Explore the dataset
mov._()
# Check the summary of the dataframe
mov._()
# Check the structure of the dataframe
mov._()
# Explore the categorical variable Studio, used in the assignment
mov.Studio._()
# Find the number of categories in Studio
len (mov.Studio._)
# Explore the categorical variable Studio, used in the assignment
mov.Genre._()
# Find the number of categories in Studio
len (mov.Genre._)
# convert Studio,Movie Title,Genre,Director,Day of Week to categorical variable
mov.Studio=mov.Studio.astype('category')
mov.Genre=mov._._
mov._ =mov._._…
arrow_forward
Open your text editor and create a new document named model.php
model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing.
updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.
arrow_forward
True/False
8. Matrix algebra is a theoretical way of manipulating a database.
9. The union of tables A and B is a table containing all rows that are in either table A or table B or in both table A and table B.
10. The intersection of two tables A and B is the set of all rows that are in table A but that are not in table B.
arrow_forward
There are three tables in this database (see image). Write MYSQL code for:
(1) Create a trigger “insert_inventory” on table “Inventory”. The trigger is fired after a row is inserted in table “Inventory”. After a row is inserted in table “inventory”, the “itemid”, the insertion time, and the action is inserted in table “Inventory_history”. The action is set to ‘add an item’. The oldprice is set to null. Test your trigger by inserting a row into Inventory and displaying the contents of Inventory_history. (2) Create a trigger “change_quantity” on table “Transaction”. The trigger is fired after a row is inserted in table “Transaction”. After a row is inserted in table “Transaction”, update the “quantity” in table “Inventory”. For example, if 3 iWatch are sold, then the quantity of iWatch in table “Inventory” is decreased by 3. Test your trigger by inserting a row into Transaction and displaying the contents of the relevant row in Inventory. (3) Create a trigger “change_price” on table…
arrow_forward
Q9, Q10, Q11, Q12
arrow_forward
variants/3212612/take/5/
CATEGORY
Sort the items into whether they are benefits or risks of a search engine keeping a record
of your search history.
To place a category, press the item in the answer box, then press the box under the corre-
sponding category.
benefits
Add an answer item!
Answer Bank
risks
Add an answer item!
You can refer back to information you read earlier.
You can see which search result links you have not yet pressed.
A friend may see an embarrassing web search.
A family member may see an ad for a gift you secretly bought for them.
A related search will auto-complete so you do not need to type the whole thing.
Someone with access to search cata could create a scam related to your interests.
arrow_forward
BbPython Online - 2022 Fall ET 574 X
= CO
Bing
Links
H
Remaining Time: 1 hour, 42 minutes, 51 seconds.
Question Completion Status:
P
Online Python - IDE, Editor, Con X Bb Take Test: ET574 Coding Final Ex
bbhosted.cuny.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_2271631_1&course_ic
QUESTION 7
Implement the following:
1) Write a function randFive() with one parameter n.
2) randFive() create five random integers in the range (1, n) inclusive.
3) Five numbers should be stored in a list as the return value.
Call the function, randFive() with the argument, 100.
5) Print the result of the function call.
randFive() can generate any five numbers.
Make sure to precisely match the output format below.
Write your code in the ANSWER area provided below (must include comments if using code is not covered in the course).
Example Output
[1, 20, 9, 84, 46]
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
BIUS Paragraph V Arial
0
P
QUESTION 8
4
Click Save and Submit to save and…
arrow_forward
Suppose a school wants to store the data of teachers and the subjects they teach.
They create a table that looks like this: Since a teacher can teach more than one
subjects, the table can have multiple rows for a same teacher. Apply Second Normal
Form on this table.
teacher id
subject
teacher age
401
Maths
34
402
Physics
32
403
Biology
28
404
Physics
30
405
Chemistry
37
arrow_forward
#Fill in comments to spec.
import sqlite3from contextlib import closing
from Objects import Player, Lineup
conn = None
def connect():global connif not conn:DB_FILE = "player_db.sqlite"conn = sqlite3.connect(DB_FILE)conn.row_factory = sqlite3.Row
def close():if conn:conn.close()
def get_players():return None #remove this line when code is added.# SQL statement to select all 7 fields for all players
# Use a with statement to execute the query
# Create a lineup object# use a loop to populate the lineup object with player objects# return the lineup object
def get_player(playerID):return None #remove this line when code is added.# SQL statement to select all 7 fields for a player
# Use a with statement to execute the query & return a player object if the player exists
def add_player(player):return None #remove this line when code is added.# SQL statement to insert 6 fields for a player added to the table
# Use a with statement to execute the query
def delete_player(player):return None…
arrow_forward
Scenario:
You have been tasked with building a URL file validator for a web crawler. A web crawler is an application that fetches a web page, extracts the URLs present in that page, and then recursively fetches new pages using the extracted URLs. The end goal of a web crawler is to collect text data, images, or other resources present in order to validate resource URLs or hyperlinks on a page. URL validators can be useful to validate if the extracted URL is a valid resource to fetch. In this scenario, you will build a URL validator that checks for supported protocols and file types.
arrow_forward
Add features to add and delete entries.
arrow_forward
using xamapp to write an php code for send message and store it in the database when click in the send message button
the sendmassage table is as in the picture uploaded
arrow_forward
In python pandas, how to extract rows of a dataframe where one column has specific numeric value?
arrow_forward
Create a set of lookup tables.
arrow_forward
Describe comments in mdl file.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
Related Questions
- 1.6 Using SQL Server (Not Oracle)arrow_forwardQ7: Using the AIRPORT KLX Table (Textbook page 131), describe an example that illustrates the insertion anomaly. Q8: Using the AIRPORT KLX Table (Textbook page 131), describe an example that illustrates the deletion anomaly. Q9: Using the AIRPORT KLX Table (Textbook page 131), describe an example that illustrates the modification anomaly.arrow_forward4:04 l LTE 4:04 i LTE DB Quiz No.5 (12:30@ULJI selga) DB Quiz No.5 (12:30@ouI selga) CREATE TABLE Institution (name VARCHAR(50),country VARCHAR(50).year CREATE TABLE HighDegree (professorID INT REFERENCES Professor(ID).projectID INT REFERENCES Project(ID),schoolName VARCHAR(50),institutionName VARCHAR(50), FOREIGN KEY (schoolName,institutionName) REFERENCES School(name.,insitutionName), PRIMARY KEY (professorID, studentID, schoolName, institutionName); O Number INT, (name, country): PRIMARY KEY O Name and Num WA The following is an instance of the relation: CREATE TABLE Author (researcherlD INT REFERENCES Researcher(ID),.paperID INT REFERENCES Paper(ID).PRIMARY KEY (researcherlD, paperID)); O Name Based on the above, indicate for each of the following sets of attributes whether it is a key for Articles Table? CREATE TABLE PartOf (professorID INT REFERENCES Professor(ID), studentID INT REFERENCES Researcher(ID),PRIMARY KEY (professorID, projectID); Indicate which one of the following…arrow_forward
- 3.9 LAB - Select lesson schedule with inner join The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs.arrow_forward<!-- Instructions ============ 1. Generate a table using the data in the <script> tags below. The table columns should be generated dynamically based on the data. They should not be hardcoded. 2. Clicking on a table header should sort the table by the column that was clicked on. Clicking the same column a second time should sort in descending order. You may use third-party libraries, but you cannot use any built-in table components. Feel free to style the table however you like with CSS. --> <!DOCTYPE html> <html lang="en"> <head> <metacharset="utf-8" /> </head> <body> <divid="root">TODO: generate table</div> </body> <script> vardata=[ { Username: "booker12", Identifier: "9012", "First Name": "Rachel", "Last Name": "Booker", }, { Username: "grey07", Identifier: "2070",…arrow_forwardAndroid Studioarrow_forward
- Exercise 3: Multiple Scatter plots Generate scatter plots between every pairs of numerical columns from the "iris" dataframe as a set of subplotsarrow_forwardCreate pseudo code for this algorithm.arrow_forwardInformation Techfiology department Q-Design a system for car parking database, should have at least tables. In addition to build schema, the required is: 1- write all instruction's to do this structure. 2- Make new field with titles comments to first table has data type integer. 3- Edit the new field to be character data type. 4- Remove any column from any table.arrow_forward
- # coding: utf-8 # ### Section 6 Homework - Fill in the blanks # Import the packages needed to perform the analysis import pandas as pd import matplotlib.pyplot as plt import seaborn as sns import warnings warnings.filterwarnings('ignore') # Import the data mov = pd._('P4-Section6-Homework-Dataset.csv', encoding = 'latin1') # check columns in dataset and rename the column without spaces mov._=[] # Explore the dataset mov._() # Check the summary of the dataframe mov._() # Check the structure of the dataframe mov._() # Explore the categorical variable Studio, used in the assignment mov.Studio._() # Find the number of categories in Studio len (mov.Studio._) # Explore the categorical variable Studio, used in the assignment mov.Genre._() # Find the number of categories in Studio len (mov.Genre._) # convert Studio,Movie Title,Genre,Director,Day of Week to categorical variable mov.Studio=mov.Studio.astype('category') mov.Genre=mov._._ mov._ =mov._._…arrow_forwardOpen your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.arrow_forwardTrue/False 8. Matrix algebra is a theoretical way of manipulating a database. 9. The union of tables A and B is a table containing all rows that are in either table A or table B or in both table A and table B. 10. The intersection of two tables A and B is the set of all rows that are in table A but that are not in table B.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education