Search results for 'Chapter'

WBG310 Week 3 Lab Interactive Web Page Scripting with Lab

Scenario/Summary
Using the skills acquired in the tutorials from Chapter 5, build a web page of your own design that has jQuery-programmed event handlers. Find errors and omissions in existing files and repair them to function correctly.

Deliverables
W3iLab_1.html. Zip the file and submit your assignment.

Lab Steps
STEP 1: Open the Template
Open jsTemplate.html from Week 1.
Save the file as w3_Lab3.html.

STEP 2: Collect jQuery Library File
Use the link to jQuery at Google as shown here, and as described in the week lesson:
<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
...or, download the current jQuery library file from https://jquery.com/download/ (https://jquery.com/download/) and place the file in the _js folder.
Note: You may need to right-click on the download link an and then select "Save Link as...", or "Download Linked File as . . ." depending on your browser.

STEP 3: Set the Source for the Library File
1. If you download your own copy, create a set of script tags above the current script tag set, and set the src to the library file in Step 2.

STEP 4: Create jQuery Functions for Events
1. Set an id="p1" for the first paragraph <p>.
2. Create the document ready function for your page as explained in the text in Chapter 4.
3. Within the document function, create an event handler that will append the contents of the ‘more’ div tag with the message ‘You Clicked!’. Include a line break. The expected results are pictured below.

STEP 5: Create jQuery Functions for Events
1. Create a textbox inside the form. Name the new input element with id=“box1”
2. Create a function that changes the background color of the box to light blue when the box gains the focus.
3. Create a function that changes the background color of the box to pink when the box loses the focus. Hint: Blur.

STEP 6: Create jQuery Functions for Events
1. Create a button next to the textbox on the form. Make the button read, ‘Relay a Message.’
2. Create a function that appends the contents of the results DIV when clicked. The message should be ‘Here is your message’ or something similar. The expected results are pictured below.

STEP 7: Create jQuery Functions for Events
1. When the page loads (onload), hide the form.
2. Change the value of #p1 to ‘Relay a Message’ and make it a hyperlink with the href="#"
3. Reset the function for the paragraph click event.
Include the designation in the identifier for the anchor tag.
Have the form slide down. Use the ‘slow’ modifier.
4. In the button click event, reset the message to come from the textbox. Hint: Use .val() to collect the user input. Include a line break with the message. The expected results are pictured below.

STEP 8: Prep for Turn-In
1. When your application functions as expected, zip the file submit your assignment.

Python 11.24 LAB: Output values in a list below a user defined amount - functions

Write a program that first gets a list of integers from input. The input begins with an integer indicating the number of integers that follow. Then, get the last value from the input, and output all integers less than or equal to that value.

Ex: If the input is:
5
50
60
140
200
75
100

the output is:
50
60
75
The 5 indicates that there are five integers in the list, namely 50, 60, 140, 200, and 75. The 100 indicates that the program should output all integers less than or equal to 100, so the program outputs 50, 60, and 75.

Such functionality is common on sites like Amazon, where a user can filter results.

Your code must define and call the following two functions:
def get_user_values()
def output_ints_less_than_or_equal_to_threshold(user_values, upper_threshold)

Utilizing functions will help to make your main very clean and intuitive.

Note: This is a lab from a previous chapter that now requires the use of functions.

Microsoft Visual Basic 2012 Shelly Cashman Chapter 6 Case Problem 8 Galaxy Hotel

Create a requirements document and a Use Case Definition document, and design a Windows application based on the case project shown in Figure 6-135:

The Galaxy Hotel ask you to write a Windows application that computes the occupancy rate of the hotel. Occupancy rate is a percentage that is equal to the number of rooms sold divided by the total number of room available. The hotel has seven floors. The user should use an InputBox function to respond to two questions about each floor. How many rooms are occupied on that floor? How many rooms on floor are vacant? Display which floor you are asking about in each question. Display how many rooms are occupied and vacant on each floor in a ListBox object. After the user has entered all the information, display the following results: the total number of rooms at hotel, the number of occupied rooms, the number of vacant rooms. Also display the occupancy rate as a percentage, such as 61%. Nonnumeric values should not be accepted. Do not accept negative numbers. Publish the application after testing it.

Microsoft Visual Basic 2012 Shelly Cashman Chapter 6 Case Problem 5 Distance Traveled Calculator

Design a Windows application and write the code that will execute according to the program requirements shown in Figure 6-132. Before writing the code, create an event planning document for each event in the program. Create a Use Case Definition document for the application.

REQUIREMENTS DOCUMENT
Date submitted: December 5, 2014
Application title: Vacation Distance Calculator Windows Application

Purpose: This application computes the number of miles traveled given the speed limit and the number of days traveled while driving cross country.

Program Procedures: In a Windows application, enter the speed limit and the number of days you plan to travel across the country. You will enter the number of hours you would like to drive for each of the days, based on places you plan to visit as you drive and other factors. For example, the first day you plan to drive only 4 hours because you are driving after work. The application displays the distance that you are able to travel for the entire trip based on the speed limit and the hours driven.

Algorithms, Processing, Conditions:
1. The application opens displaying a title. The user enters the speed limit and the and number of days you plan to drive.
2. The user clicks the Distance button to request the number of hours you plan to drive each day. The result of the total number of miles you plan to drive over the entire trip will be displayed.
3. A File menu contains a Clear and an Exit option. The Clear menu item clears the result and the entered number of miles per hour and time traveled. The Exit menu item closes the application.

Notes and Restrictions:
1. Nonnumeric values should not be accepted.
2. The number of hours for one day of travel should not exceed 20 hours.

Comments:
1. The application allows decimal entries.

Murach's MySQL 3rd Edition Chapter 11 Exercise 2 and 4

2. Write a script that contains the CREATE TABLE statements needed to implement the following design in the EX schema:

These tables provide for members of an association, and each member can be registered in one or more groups within the association.
The member_id and committee_id columns are the primary keys of the Members and Committees tables, and these columns are foreign keys in the Members_Committees table.
Include any contraints or default values that you may think are necessary.
Include statements to drop these tables if the already exist.

4. Write an ALTER TABLE statement that adds two new columns to the Members table created in exercise 2.
Add one column for annual dues that provides for three digits to the left of the decimal point and two to the right. This column should have a defualt value 52.50.
Add on column for the payment date.

Murachs MySQL 3rd Edition Chapter 15 Exercise 1 and 2

1. Write a script that creates and calls a stored procedure named insert_glaccount. First, code a statement that creates a procedure that adds a new row to the General_Ledger_Accounts table in the AP schema. To do that this procedure should have two parameters, one for each of the two columns in this table. Then, code a CALL statement that tests this procedure. (Note that this table doesn't allow duplicate account descriptions.)

2. Write a script that creates and calls a stored function named test_glaccounts_description. First, create a function that tests whether an account description is already in the General_Ledger_Accounts table. To do that, this function should accept one parameter for the account description, and it should return a value of 1 if the account description is in the table or 0 if it isn't. (Note: If a SELECT statement doesn't return any data, it raises a NOT FOUND condition that your function can handle.)

Murach's MySQL 3rd Edition Chapter 14 Exercise 1 and 2

1. Write a script that creates and calls a stored procedure named test. This procedure should include a set of three SQL statements coded as a transaction to reflect the following change: United Parcel Service has been purchased by Federal Express Corporation and the new company is named FedUP. Rename one of the vendors and delete the other after updating the vendor_id column in the Invoices table.
If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

2. Write a script that creates and calls a stored procedure named test. This procedure should include a set of two SQL statements coded as a transaction to delete the row with an invoice ID of 114 from the Invoices table. To do this, you must first delete all line items for that invoice from the Invoice_Line_Items table.
If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

CYB/130 Week 4 Python LAB 5.23: Exact change - functions
Write a program with total change amount as an integer input that outputs the change using the fewest coins, one coin type per line. The coin types are dollars, quarters, dimes, nickels, and pennies. Use singular and plural coin names as appropriate, like 1 penny vs. 2 pennies.

Ex: If the input is:
0
or less, the output is:
no change

Ex: If the input is:
45
the output is:
1 quarter
2 dimes

Your program must define and call the following function. The function exact_change() should return num_dollars, num_quarters, num_dimes, num_nickels, and num_pennies.
def exact_change(user_total)
Note: This is a lab from a previous chapter that now requires the use of a function.

CYB/130 Week 4 Python LAB 5.21: Leap year - functions
A year in the modern Gregorian Calendar consists of 365 days. In reality, the earth takes longer to rotate around the sun. To account for the difference in time, every 4 years, a leap year takes place. A leap year is when a year has 366 days: An extra day, February 29th. The requirements for a given year to be a leap year are:
1) The year must be divisible by 4
2) If the year is a century year (1700, 1800, etc.), the year must be evenly divisible by 400
Some example leap years are 1600, 1712, and 2016.
Write a program that takes in a year and determines whether that year is a leap year.

Ex: If the input is:
1712
the output is:
1712 is a leap year.

Ex: If the input is:
1913
the output is:
1913 is not a leap year.

Your program must define and call the following function. The function should return true if the input year is a leap year and false otherwise.
def is_leap_year(user_year)

Note: This is a lab from a previous chapter that now requires the use of a function.