Task #1 Character and String Class Methods

  

Task #1 Character and String Class Methods
 

2. In the Time.java file,add conditions to the decision structure which validates
the data. Conditions are needed that will
a) Check the length of the string
b) Check the position of the colon
c) Check that all other characters are digits
3. Add lines that will separate the string into two substrings containing hours and
minutes. Convert these substrings to integers and save them into the instance
variables.
4. In the TimeDemo class,add a condition to the loop that converts the user’s
answer to a capital letter prior to checking it.
5. Compile,debug,and run. Test out your program using the following valid
input:00:00,12:00,04:05,10:15,23:59,00:35,and the following invalid input:
7:56,15:78,08:60,24:00,3e:33,1:111.
 

Task #2 StringTokenizer and StringBuilder classes
1. Copy the file secret.txt(code listing 10.3) from www.aw.com/cssupportor as
directed by your instructor. This file is only one line long. It contains 2
sentences.
2. Write a main method that will read the file secret.txt,separate it into word
tokens.
3. You should process the tokens by taking the first letter of every fifth word,
starting with the first word in the file. These letters should converted to capitals,
then be appended to a StringBuilder object to form a word which will be printed
to the console to display the secret message.

GO19_AC_CH03_GRADER_3E_HW – Textbook Publishers 1.0

GO19_AC_CH03_GRADER_3E_HW – Textbook Publishers 1.0

  

Project Description:

In this project, you will use a database to track textbooks and publishers for science courses. You will create forms, add and delete records by using a form, filter records, and modify a form in Layout view and Design view.

     

Start Access. Open the file Student_Access_3E_Textbook_Publishers.accdb downloaded with this   project. View the relationship between the 3E Publishers table and the 3E   Science Textbooks table. One publisher can provide many textbooks for science   courses. Close the Relationships window.

 

Use   the Form tool to create a form based on the 3E Publishers table. Save the   form as 3E Publisher Form   and then display the form in Form view.

 

Using   the 3E Publisher Form, add the following new record to the underlying 3E   Publishers table:

  

Field

Data

 

Publisher ID

PUB-1008

 

Publisher Name

Hidden Hills     Publishing Co

 

Address

5100 Live Oak St

 

City

Dallas

 

State

TX

 

Postal Code

75201

 

Phone Number

(214) 555-0857

 

Publisher Web Site

http://www.hhpubco.pub

 

   Find the record for the Publisher ID of PUB-1006, and then delete the record.   Find the record for the Publisher ID of PUB-1008, and change the Column Size   Width in the Print dialog box to 7.5 inches. Save the form.

 

Use   the Filter By Form tool to create a filter for the Publisher Form that   displays records with a State of CA Or TX.   After verifying that three records match the filter criteria, toggle the   filter off to display all seven records. Save and close the form.

 

Use   the Form Wizard to create a form based on the 3E Science Textbooks table. Add   the following fields (in this order) to the form: Course(s), Textbook Name,   Publisher ID, Price Per Book, and # Books. Apply a columnar layout, and name   the form 3E Science Textbook   Form.

 

With   the 3E Science Textbook Form displayed in Layout view, apply the Stacked   layout to all of the controls. Apply the Ion Boardroom theme to this form   only.

 

With   the 3E Science Textbook Form displayed in Layout view, select the title—3E Science   Textbook Form. Change the font size to 16, apply bold, and change the   font color to Dark Purple, Text 2 (under Theme Colors, in the fourth column,   the first color). Save the form.

 

   With the 3E Science Textbook Form displayed in Layout view, from the Field   List pane, add the Textbook ID field to the form directly above the Textbook   Name controls. Close the Field List pane. In the form, move the # Books   controls directly above the Price Per Book controls.

 

With   the 3E Science Textbook Form displayed in Layout view, display Record 9.   Change the width of the Textbook Name text box control to 4 inches (the widths of all of the text   box controls change). Save the form.

 

With   the 3E Science Textbook Form displayed in Layout view, select all six text   box controls, and change the background color to Orange, Accent 4, Lighter   80% (under Theme Colors, in the eighth column, the second color).

 

With   the 3E Science Textbook Form displayed in Layout view, select all six label   controls, and change the font color to Orange, Accent 4, Darker 50% (under   Theme Colors, in the eighth column, the last color). For the same controls,   change the width to 1.75   inches.

 

With   the 3E Science Textbook Form displayed in Layout view, select the six label   controls and the six text box controls. Change the font size to 12, and change the height to 0.25 inch. Save the form.

 

With   the 3E Science Textbook Form displayed in Design view, change the height of   the Form Footer section to 0.5 inch. Add a label control to the Form Footer   section that displays Texas Lakes Science   Books.

 

Still   in Design view and with the label control in the Form Footer section   selected, change the font color to Orange, Accent 4, Darker 50% (under Theme   Colors, in the eighth column, the last color). Apply bold to the label   control and change the width to 2.2   inches. For the same label control, set the Top property to 0.1 inch and the Left property to 1.95 inches. Close the Property Sheet, save   the form, and then close the form.

 

Save   and close the database, and then submit for grading.

Exp22_Excel_Ch07_Cum_HotTubs

#Exp22_Excel_Ch07_Cum_HotTubs 

#Exp22 Excel Ch07 Cum HotTubs 

#Excel Chapter 7 Cumulative – Ultimate Hot Tubs 

  

Project Description:

You are a data analyst for Ultimate Hot Tubs, which has locations in five states. You want to analyze sample sales data and create a map to indicate sales by state. In addition, you want to create a loan amortization template that can be used to show customers.

Steps to Perform:

     

Start Excel. Download and open   the file named Exp22_Excel_Ch07_Cum_HotTubs.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

 

Your first task is to use date   functions to identify the day of the week each order was placed.
 

  In cell D2, insert the WEEKDAY function to return the serial number   representing the weekday that the first hot tub was ordered (cell E2). Copy   the function to the range D3:D12.

 

The result of the WEEKDAY   function is a serial number. You will format it to display as a day of the   week and left-align the results.
 

  Select the range D2:D12. Apply a custom number format dddd to display the actual weekday.   Apply Left horizontal alignment.

 

You want to calculate the number   of days between the order date and date the store received the hot tub.
 

  In cell G2, insert the DAYS function to calculate the number of days between   the Date Ordered and Date Received for the first hot tub. Apply Center horizontal   alignment. Copy the function to the range G3:G12.

 

Next you will use logical   functions. First, you will use the SWITCH function to switch the codes PD and   CR for Paid in Full and Credit, respectively.
 

  In cell C2, insert the SWITCH function to evaluate the first value in the   Code column. Switch PD for Paid in Full and switch CR for Credit. Use text strings for the last four function arguments. Copy the   function to the range C3:C12. 

 

Now, you will issue a store   credit toward cleaning supplies if orders took over 45 or 70 days as a   goodwill gesture.
 

  In cell I2, insert the IFS function. Evaluate if the Days for the first hot   tub order was greater than 70. If so, return $100. If the Days for the hot   tub was greater than 40, return $50. Otherwise, return $0. Use cell   references to the criteria thresholds and store credits located in the range   H15:I16. Use relative and mixed references correctly. Copy the function to   the range I3:I12.

 

Finally, you will create a   nested IF function that displays Send Gift Basket for customers who bought   either the Luxury or Serenity model and paid in full.
 

  In cell J2, insert an IF function with a nested AND function with a nested OR   function. The function should display Send Gift Basket if these conditions are met:   (1) the model was either Luxury or Serenity and (2) the hot tab was Paid in Full. If the conditions are false,   use an empty text string “”. Use text within the arguments and   appropriate relative cell references. Copy the function to the range J3:J12.

 

Your assistant created a section   for summary statistics below the main dataset. You will calculate the average   number of days between the order and received dates.
 

  In cell B15, insert the AVERAGEIF function to calculate the average number of   days for the Luxury model. Use mixed references to the range and criteria   range. Use a relative reference to cell A15 that contains the model name. Do   not type text as the criteria argument. Apply Number format with 0 decimal   places and apply Center horizontal alignment. Copy the function to the range   B16:B17 and preserve the existing border in cell B17.

 

 

In cell C15, insert the COUNTIF   function to calculate the quantity of each hot tub model. Use mixed   references for the range and a relative reference to the first model in cell   A15. Apply Center horizontal alignment. Copy the function to the range   C16:C17 and preserve the existing border in cell C17.

 

Now, you will identify the   highest price for the Luxury hot tub model.
 

  In cell E15, insert the MAXIFS function to calculate the highest-price Luxury   model purchased on credit. Use mixed references to the range and criteria   range arguments. Use a relative reference to the model name in cell A15. Use   a mixed reference to the word Credit in cell E14.

 

Now, you will identify the   average price for the Serenity hot tub model.
 

  Copy the function in cell E15 to cell E16 and preserve the existing border in   cell E16. Edit the function in cell E16 to calculate the average price of the   Serenity model purchased on credit. If you used correct mixed and relative   references in the original function, the only edit is to change the function   name to AVERAGEIFS.

 

 

Now, you are ready to enter the   last conditional formula.
 

  Copy the function in cell E15 to cell E17 and preserve the existing border in   cell E17. Edit the function in cell E17 to calculate the lowest price of the   Bubbles model purchased on credit. If you used correct mixed and relative   references in the original function, the only edit is to change the function   name to MINIFS.

 

Your assistant created a list to   summarize the annual sales for the top five states. You will create a map to   visually depict the data.
 

  Display the Map worksheet. Select the range A3:B8 and insert a map. Cut the   map and paste it in cell D1.

 

Change the map title to Annual Hot   Tub Sales and   apply Blue, Accent 5, Darker 50% font color to the chart title.

 

You will add the final touches   to the map.
 

  Set 2.8″ height and 4.6″ width. Show all data labels.

 

Customers often want to see a   breakdown of loan payments. Your assistant started a loan amortization table   for you. Now, you are ready to complete it. First, you will calculate the   APR.
 

  Display the Loan worksheet. In cell B3, insert the RATE function. Use the   cell references to the price, term, and monthly payment. Multiple the result   by 12 using a cell reference to calculate the APR. Make sure the function   returns a positive value.

 

Next, you want to enter the due   dates.
 

  In cell A8, insert the EDATE function to return the next month’s payment due   date. Copy the function to the range A9:A18.

 

Now, you want to format the   results of the EDATE function.
 

  Select the range A8:A18. Apply the Short Date number format, Align Right   horizontal alignment, and indent once. 

 

In cell E1, insert the CUMIPMT   function to calculate the cumulative interest. Use cell references to   calculate the periodic rate, nper, present value (price) starting period, and   ending period. Make sure the function returns a positive value.

 

In cell E2, insert the CUMPRINC   function to calculate the cumulative principal through the sixth month   payment. Use cell references for all arguments. Make sure the function   returns a positive value.

 

You are ready to enter a formula   to calculate interest payments.
 

  In cell C7, insert the IPMT function to calculate the first month’s interest   payment. Use relative and mixed cell references correctly. Copy the function   to the range C8:C18.

 

Now, you are ready to insert a   function to calculate principal payment.
 

  In cell D7, insert the PPMT function to calculate the first month’s   principal. Use relative and mixed cell references correctly. Copy the   function to the range D8:D18.

 

The last column will display the   remaining balance after each payment.
 

  In cell E7, insert a formula to calculate the remaining balance by   subtracting the first principal repayment from the original price. Insert a   formula in cell E8 to calculate the remaining balance by subtracting the   second principal repayment from the first month’s remaining balance. Copy the   formula to the range E9:E18.

 

Format the range C7:E18 with   Accounting Number Format.

 

Save and close Exp22_Excel_Ch07_Cum_HotTubs.xlsx. Exit   Excel. Submit the file as directed.

Foundations 2

 Read the bottom of p.160 through the top of p. 161.
Now take a road trip.  If you don’t drive, ride with a friend, or ride the bus.  Think about what you are feeling as the vehicle starts, speeds up, moves, slows down, and stops.  Considering the position of the vehicle as the function, explain what you notice in terms of the function and its first, second, and third derivatives.  How do you measure each of these, both by using the vehicle’s instruments and by what you feel acting on your body? 

Note:  Be safe!  Obey speed limits and other laws of the road.  You can test these phenomena without driving fast. 

Once you have posted, respond to one other post. Do not focus on length, but instead focus on clear and original thoughts.  As always, your work must be your own.  

Week 6 Assignment – Mitigating Risks

There are multiple ways to bring threats and vulnerabilities to  light. Common practices and lessons learned can help us explore for  known or common threats.

Write a 3–4 page paper in which you:

  1. Explain the differences in threat, vulnerability, and exploit  assessments for information systems and define at least two tools or  methods to perform each type.
  2. Describe at least two tools or methods used to implement both  physical and logical security controls (four in total), then identify  the type of security personnel that would be used to implement each and  discuss their roles and responsibilities.
  3. Describe three considerations when translating a risk  assessment into a risk mitigation plan, then discuss the differences  between a risk mitigation plan and a contingency plan. 
  4. Explain the two primary goals to achieve when implementing a  risk mitigation plan and discuss the methods of mitigation for common information system risks.
  5. Use at least two quality resources in this assignment. Note:  Wikipedia and similar websites do not qualify as quality resources. The  Strayer University Library is a good location for resources.

The specific course learning outcome associated with this assignment is:

  • Examine the placement of security personnel and their functions in an organization.

“The Limit of Instruction-level parallelism in SPEC95 Applications “

 

Read the attached Research paper : “The Limit of Instruction-level parallelism in SPEC95 Applications ” 

Write a Reflection Report that summarizes the attached research paper in your own words, You have to address the following:

  • The problem discussed
  • The proposed solutions
  • Your thoughts about the solutions (which one would you select and why)
  • The challenges associated with the solution proposed
  • Your overall perception.

paper

Read the attach paper and write a comprehensive summary/review of the paper as follows: 

  • Make sure to identify strength and weakness this research paper
  • Minimum of 500 words 
  • Plagiarism free & Quoting Free
  • Upload your response as pdf/word file 
  • This assignment should be in APA format and have to include at least two references ( from the paper reference as needed to support your review/summary)