StudyGuideForExam2-2023F
.pdf
keyboard_arrow_up
School
Rutgers University *
*We aren’t endorsed by this school
Course
110
Subject
Computer Science
Date
Jan 9, 2024
Type
Pages
14
Uploaded by GeneralTeamDeer34
1 Exam 2 Format and Administration
Your EXAM 2 will be given in person on Wednesday, November 15
th
, 2023 DURING YOUR REGULAR CLASS MEETING TIME.
The exam will cover material from WEEKS 6, 7, 8, and 9 (all of Scratch programming UP TO but NOT INCLUDING Scratch lists) and quizzes from weeks 7, 8, 9, and 10. Exam Locations PLEASE NOTE YOUR ASSIGNED LOCATION!!!!! 2:15PM –
3:15PM:
•
Sections 1, 2, 3: FBO-EHA (
Prof. Belowich, HASNAIN)
•
Sections 4, 5: EN-B120
(ANIRUDH, SAHANA)- 4:05PM
–
5:05PM
•
Sections 10, 11: PH 111-
(Prof. Belowich, SHUSHANG
) •
Sections 12, 13, 14
: EN
-
B120
(
SHREYA, VANSHIKA) Format •
The exam is worth 60 points.
•
Bring a writing utensil (pencil or pen). We do not supply these. •
The exam will include: •
30 points: o
Multiple Choice o
Multiple Answer •
30 points: o
Fill-in the blanks o
Write program code o
Give the output of a program segments o
Find/fix errors •
We will provide the SCRATCH REFERENCE SHEET for your use during all parts of the exam. It will be printed in black-and-white (not color). You should practice using this as you prepare for the exam. It can be found in Exam2 Information folder in Canvas. Other requirements •
You are on your honor to complete the exam. •
If you know that one of your classmates has violated the AI policies, it is your responsibility to report the incident to the course coordinator (
fran.trees@cs.rutgers.edu ) or to your instructor, giving all of the details of the situation. Your report of the incident will be considered confidential. The instructor will take the appropriate action and the incident will be investigated.
2 •
Calculators are not to be utilized during the exam. •
Cell phones must be TURNED OFF and out of site. •
If the problem indicates “SHOW ALL WORK” and you do not show your work, you will not receive credit for the problem. •
For multiple choice questions, you are required to CIRCLE the correct answer. WRITING ANSWERS IN THE MARGIN will result in NO CREDIT for those problems.
•
Remember to bring your photo/signature ID and have it ready when you return your completed exam. •
You cannot leave the exam room until you are finished with the exam. You cannot start the exam late if someone has already finished and turned in the exam. Preparation for Exam 2 •
Review the following resources posted in Canvas:
•
Developing Solutions To Problems for examples of IPO-S to Pseudocode to Flowchart to program. •
Algorithms Study Guide and Algorithm Resources to help you with the definitions of the terms. •
_Problems to Solve
and Worksheet_Variables
to help you write code using decision statements and variables and simple loops.
•
Some problems-Make Your Own Blocks and Algorithms Study Guide2 and Making Blocks
to review loops
and blocks:
•
Learning Objectives: WEEK 6
, WEEK 7,
WEEK 8
,
AND WEEK 9
•
Review your assignments. Be sure you understand the solutions to the assignments. If you have trouble with Scratch, visit Lab Support hours. •
In addition to reviewing your assignments, the study guide, and your lecture notes, the problems below may help prepare you for the exam. 1.
What does the sprite say? a.
3 b.
c.
d.
e.
f.
Assume needed input from: 4,6,5,1,2,10,12
4 g.
Assume needed input from: 4,6,5,1,2,10,12 h.
Assume needed input from: 4,6,5,1,-1, 2,10,12 i.
5 j.
k.
2.
Give both the x- and y-coordinates of the points X, A, B, C, and D on the stage below. You can approximate. X_______ A_______ B______ C______ C______ 3.
In the box below, sketch the path followed by the sprite when the following code is executed. Put an S for start, and F for finish and arrows indicating the direction of movement. A B X C D
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
For this portion of the lab design the solution in the following manner:
Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.
arrow_forward
Submission guidelines: The assignment must be submitted by the deadline (earlier submissions are
encouraged) in PDF format through Blackboard using the following file name format:
LastName_FirstName_Assignment_1.pdf. The assignment must be typewritten.
All the assignments in this course are individual work; any overlap between assignment reports will be
penalized.
A bank requires for their customers to access their online banking accounts to provide as
User Id (or user name) the last 8 digits of their bank card number, and a password with a
length between 8 and 12 ASCII characters, including the following restrictions (posted on
their website):
Passwords must have at least 8 characters long and at most 12 characters long, and must include at least
one character from each of the following four character types:
Upper case letters ABC DEF
Lower case letters ghijkl
Numbers 1 2 345 67890
Special characters ! @ # $ % ^ & * (+) = -
The remaining characters of the password must be selected…
arrow_forward
WEEK 3 ASSIGNMENT
This assignment contains two parts. You must complete Part I before moving on to Part II.
Part I:
Using the table you previously worked on, complete the following exercise:
Insert a row into your student table where the last name is "Parker", first name is "Sam" and the ZIP code is "68134". You can determine the values for the remaining columns.
Select a row from your student table where the last name equals "Parker".
Select a row from your student table where the ZIP code is less than "68134".
Select the student first and last name from the student table order by the state column.
Part II:
Complete the following exercise:
Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state.
Using your student table select all students with ZIP codes between “23164” and “98164”.
Using your student table select all students where states are in Florida and New York.
Using your…
arrow_forward
The International Conference on Mathematical Sciences and Technology, Math Tech, is a biennial
conference organised by the School of Mathematical Sciences, USM. This event is open to all
national and international experts, practitioners, researchers, and academics to gather and
share their knowledge.
The details of fees for participation in the conference are shown in the following table.
Category
Local (RM)
International (USD)
Presenter
990
260
Observer
600
150
Note: 1 USD = RM4.20
Assignment Requirement
Part 1: Create Invoice
Construct a C++ program to do the following tasks:
a. Enter the participant's name, category, nationality, accommodation (Yes/No).
b. If the answer for the question on accommodation is Yes, the program will ask for the
number of days. Then the program will call function calcAccommodation() to calculate
the accommodation charges.
calcAccommodation() receives accommodation (Yes/No), number of days and participation
type (local/international) as parameters and…
arrow_forward
Layout
References
Mailings
Review
View
Developer
Help
KOD RENT_CH
Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD
reflects some simplifying assumptions. For example, each book is written by only one author.
Also, remember that the ERD is always read from the "1" to the "M" side, regardless of the
orientation of the ERD components.)
FIGURE P2.15 The Crow's Foot ERD for Problem 19
PUBLISHER
BOOK
publishes
sub mits
writes
CONTRACT
AUTHOR
signs
十
A business rule is an explanation that forces some type of requirement on a particular part of the information
base, like the components inside a field detail for a specific field or the attributes of a given relationship.
tes)
EO
* Accessibility: Investigate
DE
26
bp
arrow_forward
The International Conference on Mathematical Sciences and Technology, MathTech, is a biennial
conference organised by the School of Mathematical Sciences, USM. This event is open to all
national and international experts, practitioners, researchers, and academics to gather and
share their knowledge.
The details of fees for participation in the conference are shown in the following table.
Category
Local (RM)
International (USD)
Presenter
990
260
Observer
150
Note: 1 USD = RM4.20
Assignment Requirement
Part 1: Create Invoice
Construct a C++ program to do the following tasks:
a. Enter the participant's name, category, nationality, accommodation (Yes/No).
b. If the answer for the question on accommodation is Yes, the program will ask for the
number of days. Then the program will call function calcAccommodation () to calculate
the accommodation charges.
calcAccommodation() receives accommodation (Yes/No), number of days and participation
type (local/international) as parameters and return…
arrow_forward
Question 56
arrow_forward
42
Question 5
To make adjustments to your reference markers, you would navigate to the References
tab and open the
and
dialog box.
Bibliography/References
Footnote/Endnote
Table of Contents/References
O References / Citations
arrow_forward
Design a Student Registration Form and store/save data in database file and also apply validation on controls using HTML
arrow_forward
Schema
Patient (patientNo, patName, patAddr, DOB)
Ward (wardNo, wardName, wardType, noOfBeds)
Contains (patientNo, wardNo, admissionDate)
Drug (drugNo, drugName, costPerUnit)
Prescribed (patient No, drugNo, unitsPerDay, startDate, finishDate)
List the detailed information about drugs that have been prescribed more than 100 times since the year 2014.
Create a view of all patient details (patient, ward, drugs) for all patients who are 70 years old or older, excluding ward number and number of beds.
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
A controller action can be used to:
Question 24 options:
a)
Return a view
b)
Return a simple content
c)
return a 404 error code
d)
All the answers are correct
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
Do what is asked
arrow_forward
table not copied
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Related Questions
- For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.arrow_forwardSubmission guidelines: The assignment must be submitted by the deadline (earlier submissions are encouraged) in PDF format through Blackboard using the following file name format: LastName_FirstName_Assignment_1.pdf. The assignment must be typewritten. All the assignments in this course are individual work; any overlap between assignment reports will be penalized. A bank requires for their customers to access their online banking accounts to provide as User Id (or user name) the last 8 digits of their bank card number, and a password with a length between 8 and 12 ASCII characters, including the following restrictions (posted on their website): Passwords must have at least 8 characters long and at most 12 characters long, and must include at least one character from each of the following four character types: Upper case letters ABC DEF Lower case letters ghijkl Numbers 1 2 345 67890 Special characters ! @ # $ % ^ & * (+) = - The remaining characters of the password must be selected…arrow_forwardWEEK 3 ASSIGNMENT This assignment contains two parts. You must complete Part I before moving on to Part II. Part I: Using the table you previously worked on, complete the following exercise: Insert a row into your student table where the last name is "Parker", first name is "Sam" and the ZIP code is "68134". You can determine the values for the remaining columns. Select a row from your student table where the last name equals "Parker". Select a row from your student table where the ZIP code is less than "68134". Select the student first and last name from the student table order by the state column. Part II: Complete the following exercise: Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state. Using your student table select all students with ZIP codes between “23164” and “98164”. Using your student table select all students where states are in Florida and New York. Using your…arrow_forward
- The International Conference on Mathematical Sciences and Technology, Math Tech, is a biennial conference organised by the School of Mathematical Sciences, USM. This event is open to all national and international experts, practitioners, researchers, and academics to gather and share their knowledge. The details of fees for participation in the conference are shown in the following table. Category Local (RM) International (USD) Presenter 990 260 Observer 600 150 Note: 1 USD = RM4.20 Assignment Requirement Part 1: Create Invoice Construct a C++ program to do the following tasks: a. Enter the participant's name, category, nationality, accommodation (Yes/No). b. If the answer for the question on accommodation is Yes, the program will ask for the number of days. Then the program will call function calcAccommodation() to calculate the accommodation charges. calcAccommodation() receives accommodation (Yes/No), number of days and participation type (local/international) as parameters and…arrow_forwardLayout References Mailings Review View Developer Help KOD RENT_CH Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the "1" to the "M" side, regardless of the orientation of the ERD components.) FIGURE P2.15 The Crow's Foot ERD for Problem 19 PUBLISHER BOOK publishes sub mits writes CONTRACT AUTHOR signs 十 A business rule is an explanation that forces some type of requirement on a particular part of the information base, like the components inside a field detail for a specific field or the attributes of a given relationship. tes) EO * Accessibility: Investigate DE 26 bparrow_forwardThe International Conference on Mathematical Sciences and Technology, MathTech, is a biennial conference organised by the School of Mathematical Sciences, USM. This event is open to all national and international experts, practitioners, researchers, and academics to gather and share their knowledge. The details of fees for participation in the conference are shown in the following table. Category Local (RM) International (USD) Presenter 990 260 Observer 150 Note: 1 USD = RM4.20 Assignment Requirement Part 1: Create Invoice Construct a C++ program to do the following tasks: a. Enter the participant's name, category, nationality, accommodation (Yes/No). b. If the answer for the question on accommodation is Yes, the program will ask for the number of days. Then the program will call function calcAccommodation () to calculate the accommodation charges. calcAccommodation() receives accommodation (Yes/No), number of days and participation type (local/international) as parameters and return…arrow_forward
- Question 56arrow_forward42 Question 5 To make adjustments to your reference markers, you would navigate to the References tab and open the and dialog box. Bibliography/References Footnote/Endnote Table of Contents/References O References / Citationsarrow_forwardDesign a Student Registration Form and store/save data in database file and also apply validation on controls using HTMLarrow_forward
- Schema Patient (patientNo, patName, patAddr, DOB) Ward (wardNo, wardName, wardType, noOfBeds) Contains (patientNo, wardNo, admissionDate) Drug (drugNo, drugName, costPerUnit) Prescribed (patient No, drugNo, unitsPerDay, startDate, finishDate) List the detailed information about drugs that have been prescribed more than 100 times since the year 2014. Create a view of all patient details (patient, ward, drugs) for all patients who are 70 years old or older, excluding ward number and number of beds.arrow_forwardCreate 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_forwardA controller action can be used to: Question 24 options: a) Return a view b) Return a simple content c) return a 404 error code d) All the answers are correctarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L