Activity Guide - Exploring One Column - Unit 9 Lesson 2
.pdf
keyboard_arrow_up
School
University of California, Berkeley *
*We aren’t endorsed by this school
Course
3025
Subject
Computer Science
Date
May 11, 2024
Type
Pages
3
Uploaded by KidSeaUrchin2332 on coursehero.com
Unit 9 Lesson 2
Activity Guide - Exploring One Column
Bar Charts
Do This
●
Make a bar chart for each column in the "Dogs" dataset and categorize it as either "useful" or "not useful" by
placing that column name in the table below.
Useful
Not Useful
Min lifespan
Max life span
Min height
Max height
Min weight
Max weight
Name
Breed Group
Bred For
Temperament
Image
Chart
Paste one of the charts that you believe is "useful" in the space below.
Questions
1.
What is one piece of information someone could learn from the chart you pasted?
a.
No breed of dog in this dataset lives more than 20 years.
Computer Science Principles
1
Unit 9 Lesson 2
2.
Do you notice any patterns in which charts are or are not useful?
a.
Numeric data and discrete data work for charts.
Histograms
Do This:
●
Make a histogram for the "Max Weight" column of the "Dogs" data set and choose the "Bucket Size" that you
think is most helpful for interpreting the data.
Chart
Questions
3.
What bucket size did you choose? Why do you think this is the most helpful bucket size for this chart?
a.
I chose 10 first, but that made too many bars, so it was harder to read. A bucket size of 20 was easier
to read but still showed some detail for the larger dogs.
4.
What is the most common range of maximum weights for dog breeds?
a.
60-80 pounds
5.
What is the least common range of maximum weights for dog breeds?
a.
160-180 and 200-220
Computer Science Principles
2
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
Transcribed Image Text
A summer camp offers a morning session and an afternoon session. The list morningList contains the names of all children attending the morning session, and the list afternoonList contains the names of all children attending the afternoon session. Only children who attend both sessions eat lunch at the camp. The camp director wants to create lunchList, which will contain the names of children attending both sessions. The following code segment is intended to create lunchList, which is initially empty. It uses the procedure IsFound (list, name), which returns true if name is found in list and returns false otherwise. FOR EACH child IN morningList { <MISSING CODE> Which of the following could replace <MISSING CODE> so that the code segment works as intended? IF (IsFound (afternoonList, child)) { A APPEND (lunchList, child)
arrow_forward
Week 4 IPO
Assignment Content
There are 4question Create IPO chart
q1. When Trina began her trip from New York to Florida, she filled her car's tank with
gas and
reset its trip meter to zero. After traveling 324 miles, Trina stopped at a gas station to refuel; the
gas tank required 17 gallons.
arrow_forward
Favorite Color
Rank the following colors according to your preference with 1 being the most preferred and 5 the least preferred color.
Survey Result: (50 respondents)
Favorite Color Ranking
1st
2nd
3rd
4th
5th
Blue
8
7
9
15
11
Red
16
9
7
9
9
Yellow
11
14
11
5
9
Violet
4
11
17
10
8
Green
11
9
6
11
13
Instructions: Create a preference schedule for the rankings cast by your respondents.
arrow_forward
in visual c# add customer id from customer table to booking table which has a customer id column. they are primary key and foriegn key and are linked in realtionship table in access file. when button is clicked insert first name into booking table in first name column. This should automaically copy customer id to booking table in customer id column without coding
arrow_forward
Pig Latin "ILLUSTRATE" operator runs a mapreduce job
Select one:
True
False
arrow_forward
Drop down box method works well for small Excel data validation lists that are unlikely to ever change.
TRUE OR FALSE
arrow_forward
Task 4:
You have been given a spreadsheet that contains details of invoices. The column headers for the
spreadsheet are:
date, invoice number, invoice amount, invoice tax, invoice total, cust number, cust name, cust street, cust
city, cust state, cust postal code, cust nation, product code, product price, product quantity, salesrep
number, salesrep first name, salesrep last name, salesrep district, district name, and district size.
Create a high fidelity data model. In other words, list the set of tables (=entities) with their respective
column headers. If easier, and alternatively, you can draw an ERD diagram. (Optional: Add some sample
data).
arrow_forward
Menu option C The program reads in data from HowManyHours.txt, displays a report header with the report creator’s name, employee id, and department and who they created the report for. The body of the report displays the total number of students who used the program, the average credits taken, and the average study hours. In the following format –STUDY HOURS REPORT Created for Dr. Payne, A004567893 Dept: Computer Science
Created By: Karen Smith, A00494928Dept: Advising
Total Students: 3Average Credits: 9.00Average Study Hours: 20.00Menu option DThank the user for using the programTerminates the program
arrow_forward
If you modify a dimension style, all
dimensions that use that style in the
drawing are automatically updated.
true
Error
*
arrow_forward
Task 4:
The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
arrow_forward
Subject
SubjectNO
Student
SUB_Name
STD_Name
Pre SUB
Specialization
STD NO
Registration
SubjectNO
STD NO
REG date
Q1) Write procedure to print the registration dates for all subjects that are
registered by student whose name "ALI".
h
17
arrow_forward
Detailed answer .I will Upvote the correct and detailed answer. Thank you
arrow_forward
LAB - Select horses with logical operators
The Horse table has the following columns:
• ID integer, primary key
• RegisteredName - variable-length string
• Breed - variable-length string
• Height-decimal number
• BirthDate - date
Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
arrow_forward
Truth table:
Please make sure the truth table is correct and it has no mistakes.
Correct the truth table if there are mistakes.
arrow_forward
A 'SubWay' sub order has many items that may be included on the order. The order may contain choices such as breads, meats, toppings, condiments. Each order has an ID, name, and order date. Breads have a 'best used by date' and type such as white, rye, wheat, etc. Meats have a 'expiration date' and type such as turkey, ham, roast beef. Toppings and condiments have their own characteristics as well. Draw entities and represent any mutually exclusive relationships. Include optionality, cardinality, relationship names, attributes, UIDs and entities.
arrow_forward
True or False Rather than showing multiple rows at once, a Details view lets the user see one row at a time.
arrow_forward
v Question Completion Status:
Moving to another question will save this response.
Question 3
The values returned by range (12, 20, 2) returns
O 20, 18, 16, 14, 12
O 12, 14, 16, 18
O 12, 14, 16, 18, 20
O 20,18, 16, 14
A Moving to another question will save this response.
G 4)
arrow_forward
Create a formula that provides the start date of a project as follows:
In cell H4, begin to enter a formula using the INDEX
Use the Lookup table (range A2:E23) as the array.
For the row_num argument, use the MATCH
Use the Project ID (cell H2) as the lookup_value for the MATCH function.
Use the ID column (range A2:A23) as the lookup_array for the MATCH function.
Specify an exact match (0) for the MATCH function.
Use the Start Date column (column 4) as the column_num for the INDEX function.
arrow_forward
1- Display contact First name and contact Last name for customers after sorting the customersby their contact Last name in ascending order.2- selects the order line items (orderNumber, orderlinenumber) from the “orderdetails” table.Also, display the subtotal (quantityOrdered * priceEach) for each line item and sorts the resultset based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantity ordered(itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition “total”greater than 1000.8- Display product code, product…
arrow_forward
Question 20 (1 point)
You have a flexbox with child boxes in a row. You want the child boxes to be displayed in the
opposite order in which they appear currently. Which code do you use?
1) flex-flow: column-reverse
2) flex-flow: row-reverse
3) flex-flow: row-order-reverse
4) flex-flow: reverse
arrow_forward
Correct answer will be appreciated.else downvoted.
arrow_forward
need all questions answred from 2 to 7
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Related Questions
- Transcribed Image Text A summer camp offers a morning session and an afternoon session. The list morningList contains the names of all children attending the morning session, and the list afternoonList contains the names of all children attending the afternoon session. Only children who attend both sessions eat lunch at the camp. The camp director wants to create lunchList, which will contain the names of children attending both sessions. The following code segment is intended to create lunchList, which is initially empty. It uses the procedure IsFound (list, name), which returns true if name is found in list and returns false otherwise. FOR EACH child IN morningList { <MISSING CODE> Which of the following could replace <MISSING CODE> so that the code segment works as intended? IF (IsFound (afternoonList, child)) { A APPEND (lunchList, child)arrow_forwardWeek 4 IPO Assignment Content There are 4question Create IPO chart q1. When Trina began her trip from New York to Florida, she filled her car's tank with gas and reset its trip meter to zero. After traveling 324 miles, Trina stopped at a gas station to refuel; the gas tank required 17 gallons.arrow_forwardFavorite Color Rank the following colors according to your preference with 1 being the most preferred and 5 the least preferred color. Survey Result: (50 respondents) Favorite Color Ranking 1st 2nd 3rd 4th 5th Blue 8 7 9 15 11 Red 16 9 7 9 9 Yellow 11 14 11 5 9 Violet 4 11 17 10 8 Green 11 9 6 11 13 Instructions: Create a preference schedule for the rankings cast by your respondents.arrow_forward
- in visual c# add customer id from customer table to booking table which has a customer id column. they are primary key and foriegn key and are linked in realtionship table in access file. when button is clicked insert first name into booking table in first name column. This should automaically copy customer id to booking table in customer id column without codingarrow_forwardPig Latin "ILLUSTRATE" operator runs a mapreduce job Select one: True Falsearrow_forwardDrop down box method works well for small Excel data validation lists that are unlikely to ever change. TRUE OR FALSEarrow_forward
- Task 4: You have been given a spreadsheet that contains details of invoices. The column headers for the spreadsheet are: date, invoice number, invoice amount, invoice tax, invoice total, cust number, cust name, cust street, cust city, cust state, cust postal code, cust nation, product code, product price, product quantity, salesrep number, salesrep first name, salesrep last name, salesrep district, district name, and district size. Create a high fidelity data model. In other words, list the set of tables (=entities) with their respective column headers. If easier, and alternatively, you can draw an ERD diagram. (Optional: Add some sample data).arrow_forwardMenu option C The program reads in data from HowManyHours.txt, displays a report header with the report creator’s name, employee id, and department and who they created the report for. The body of the report displays the total number of students who used the program, the average credits taken, and the average study hours. In the following format –STUDY HOURS REPORT Created for Dr. Payne, A004567893 Dept: Computer Science Created By: Karen Smith, A00494928Dept: Advising Total Students: 3Average Credits: 9.00Average Study Hours: 20.00Menu option DThank the user for using the programTerminates the programarrow_forwardIf you modify a dimension style, all dimensions that use that style in the drawing are automatically updated. true Error *arrow_forward
- Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.arrow_forwardSubject SubjectNO Student SUB_Name STD_Name Pre SUB Specialization STD NO Registration SubjectNO STD NO REG date Q1) Write procedure to print the registration dates for all subjects that are registered by student whose name "ALI". h 17arrow_forwardDetailed answer .I will Upvote the correct and detailed answer. Thank youarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage