The purpose of this question is to develop a web page that prompts the user to enter three values about an isosceles triangle, the left coordinates of its base                    , the length of its base and the triangle height. Then the web page calculates the right coordinates of its base  , the coordinates of the triangle vertex  and the length of the equal sides. 

Hint: You can consider that the base of the isosceles triangle is always parallel to x-axis (horizontal base).

The web page should be implemented by using only the basic HTML tags and PHP codes that you learnt in this course. The final code with 2 snapshots should be provided in your answer sheet.

The designed web page should include a title, a header, an input form for entering the required values and an output form for presenting the calculated values or a suitable message when some violations are occurred. The design and the layout of the web page are left intentionally for the student to distinguish his/her TMA form other students and to show his/her creativity in designing the web page.

The PHP part should include at least two PHP function for computing the coordinates of the triangle vertices and length of the triangle sides. 

Exp19 Excel Ch07 Cap Assessment Shipping

Exp19_Excel_Ch07_CapAssessment_Shipping

Project Description:

You work for a company that sells cell phone accessories. The company  has distribution centers in three states. You want to analyze shipping  data for one week in April to determine if shipping times are too long.  You will perform other analysis and insert a map. Finally, you will  prepare a partial loan amortization table for a new delivery van.

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

The Week worksheet contains data   for the week of April 5.
 

  In cell D7, insert the appropriate date function to calculate the  number of   days between the Date Arrived and Date Ordered. Copy the  function to the   range D8:D35.

Next, you want to display the   city names that correspond with the city airport codes.
 

  In cell F7, insert the SWITCH function to evaluate the airport code  in cell   E7. Include mixed cell references to the city names in the  range F2:F4. Use   the airport codes as text for the Value arguments.  Copy the function to the   range F8:F35.

Now you want to display the   standard shipping costs by city.
 

  In cell H7, insert the IFS function to identify the shipping cost  based on   the airport code and the applicable shipping rates in the  range G2:G4. Use   relative and mixed references correctly. Copy the  function to the range   H8:H35.

Finally, you want to calculate a   partial shipping refund if two conditions are met.
 

  In cell I7, insert an IF function with a nested AND function to  determine   shipping refunds. The AND function should ensure both  conditions are met:   Total Days is grater than Total Days Delivery Goal  (cell C3) and Order Total   is equal to or greater than Order Total  Threshold (cell C2). If both   conditions are met, the refund is 50%  (cell C4) of the Shipping Cost.   Otherwise, the refund is $0. Use mixed  references as needed. Copy the   function to the range I8:I35.

The Stats worksheet contains   similar data. Now you want to enter summary statistics.
 

  In cell B2, insert the COUNTIF function to count the number of  shipments for   Austin (cell B1). Use appropriate mixed references to  the range argument to   keep the column letters the same. Copy the  function to the range C2:D2.

In cell B3, insert the SUMIF   function to calculate the total orders  for Austin (cell B1). Use appropriate   mixed references to the range  argument to keep the column letters the same.   Copy the function to the  range C3:D3.

In cell B4, insert the AVERAGEIF   function to calculate the average  number of days for shipments from Austin   (cell B1). Use appropriate  mixed references to the range argument to keep the   column letters the  same. Copy the function to the range C4:D4.

Now you want to focus on   shipments from Houston where the order was greater than $1,000.
 

  In cell C7, insert the COUNTIFS function to count the number of  orders where   the Airport Code is IAH (Cell D1) and the Order Total is  greater than $1,000.   

In cell C8, insert the SUMIFS   function to calculate the total  orders where the Airport Code is IAH (Cell   D1) and the Order Total is  greater than $1,000. 

In cell C9, insert the MAXIFS   function to return the highest order  total where the Airport Code is IAH   (Cell D1) and the Order Total is  greater than $1,000.

On the Map worksheet, insert a   map for the states and revenues. Cut and paste the map in cell C1.

Format the data series to show   only regions with data and show all map labels.

Change the map title to April 5-9   Gross Revenue.

Use the Loan worksheet to   complete the loan amortization table.
 

  In cell F2, insert the IPMT function to calculate the interest for  the first   payment. Copy the function to the range F3:F25. (The results  will update   after you complete the other functions and formulas.)

In cell G2, insert the PPMT   function to calculate the principal  paid for the first payment. Copy the   function to the range G3:G25.

In cell H2, insert a formula to   calculate the ending principal balance. Copy the formula to the range H3:H25.

Now you want to determine how   much interest was paid during the first two years.
 

  In cell B10, insert the CUMIPMT function to calculate the  cumulative interest   after the first two years. Make sure the result is  positive.

In cell B11, insert the CUMPRINC   function to calculate the  cumulative principal paid at the end of the first   two years. Make sure  the result is positive.

You want to perform a what-if   analysis to determine the rate if the monthly payment is $1,150 instead of   $1,207.87.
 

  In cell B15, insert the RATE function to calculate the necessary  monthly rate   given the NPER, proposed monthly payment, and loan. Make  sure the result is   positive.

Finally, you want to convert the   monthly rate to an APR.
 

  In cell B16, insert a formula to calculate the APR for the monthly rate in   cell B15.

Insert a footer on all sheets   with your name on the left side, the  sheet name code in the center, and the   file name code on the right  side.

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

 In a few short paragraphs, explain which cloud services you use (Google, Amazon, iCloud, Verizon, Microsoft One, Dropbox, etc) and what type of information you store (docs, photos, music, other files?). How much space do you have and what does this cost per month? 

Answer the following exercise taken from Ch6. An information system is to be developed to maintain information about assets owned by a utility company such as buildings, vehicles, equipment, etc. It is intended that this will be updatable by staff working in the field using mobile devices as new asset information becomes available. The company has several existing asset databases that should be integrated through this system. Design a layered architecture for this asset management system based on the generic information system architecture shown in Figure 6.8 (also found in Ch6 presentation slides #28, #29). 

You may use the following link which includes PowerPoints from the book.

https://software-engineering-book.com

Exp19_Excel_Ch07_Cap_Real_Estate

Choose one of the 1 Security Topics from the Management of Information Security Book and write your final paper educating the reader on that topic. Use the sub-categories for each Security Topic presented in the book as a guide to your content for the paper.

• Chapter 2 Compliance: Law and Ethics
• Chapter 3: Governance and Strategic Planning for Security
• Chapter 4: Information Security Polic
• Chapter 5: Developing the Security Program
• Chapter 6: Risk Management: Assessing Risk
• Chapter 7: Risk Management: Treating Risk
• Chapter 8: Security Management Models
• Chapter 9: Security Management Practices
• Chapter 10: Planning for Contingencies
• Chapter 11: Security Maintenance
• Chapter 12: Protection Mechanisms

This proposal should be an annotated outline of your paper. Use sample # 2 and 3 as your guide. The samples can be found here. Only write outlines describing what you are going to write about. Do not write paragraphs but make sure it is in outline form.

Content for the paper should have the following at a minimum:

1. Introduction to the topic
2. A description of the each area of the topic
3. How each area provides security for an organization
4. What are the tools and methods used for each area
5. What are the challenges in providing security and describe problems that can occur in each area
6. A conclusion summarizing what you wrote

• Assignment Format: MS Word Document; APA format
• Submission Format: Blackboard Submission
• Length: 2 – 4 pages with a separate reference page
• Citations Required: 5 – 6 Scholarly References

Read The CEO of Starbucks and the Practice of Ethical Leadership and complete the questions at the end of the case study.

Instructions: Please Answer the corresponding questions within 2 pages minimum.

1. Create a presentation (PowerPointr)  on a specific application of binary search trees. That is, present a scenario where you would implement binary search trees. Make sure to give specific details about what the values being stored correspond to. 5-6 slide excluding intoduction. In the note section please explain each slide so that I can understand. Add picture too

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.

• Describe how you would build a PC. Identify the parts used to build  the PC and their alignment to the PC’s primary use. Be specific with  details for each component. What component would you invest in the most?  Explain why.

The first thing we must know before building a computer is what the  purpose of this computer will be. Once we decide on the type of computer  we want to build, we can determine how good each of its components must  be so it can perform the way we need it.

One of my dreams has always been to have a super gaming computer, so I  based my project on this pc build. Please find below everything that I  will need to make my ideal PC a reality.

Motherboard: The motherboard support and connects  all components of a PC, and when it comes to a gaming computer the  motherboard allows the graphics card and processor to perform better. I  chose the MAG B560 TOMAHAWK WIFI Motherboard for my gaming PC.

Central Processing Unit (CPU): The CPU is the brain  of a computer. “This component is what helps the computer to process  input, store data, and output results. Without a CPU, we could not run  programs on a computer.” (CPU: Central Processing Unit | AP CSP ) ( n.d)

My choice for a CPU was Intel Core i9-10850K Comet Lake.

Operating System (OS): The OS is a software that  communicates with the hardware and allows other programs to run. I chose  for the project the professional version of Windows 10 as my OS.

Random Access Memory (RAM): “RAM is the part of your  device that functions like its short-term memory. It keeps track of  what programs are running in the background and what they’re doing, so  when you focus on them again, they can get right back to work.” (McCall,  2021)

I went with the CORSAIR – VENGEANCE RGB PRO for my project.

Hard Drive(s): Hard drive is an important component  for a gaming computer. This will provide storage for your games and (if  fast enough) support the graphics. I decided to go with a Solid-state  drive (SSD) instead of the HDD. SSD’s as we all know by now don’t have  moving parts, giving them an extra advantage over HDD. On top of that,  games will launch and load quicker when installed on an SSD.

Optical Drive: “An optical drive uses a laser or  visible light to read or write to optical discs such as DVDs, Blu-Ray,  and CDs from your computer.” (Optical drives )(n.d). ASUS  BW-16D1X-U Writable Blu-ray Drive was my choice for the project because  besides running in a Blu-ray format, it is also compatible with DVD and  CD format.

Video Graphics: A good graphic card is a very  essential thing to have if you are trying to build a decent gaming  computer. Current games are more advanced when it comes to graphics  capabilities and the size of the game itself, if you have a graphic card  that can’t keep up with these games, your computer won’t function how  you need it. GEFORCE RTX 3080 was my choice for this important  component.

Power Supply Unit (PSU): The power supply is the  beating heart of a PC. A great PSU will give you a longer-lasting  motherboard and will also increase the longevity of the other  components, including the graphics card and processor. I went with  Corsair RM750x as my PSU for my project.

Case: “The primary function of a computer case is to  protect the computer’s components from harm. A secondary function is to  easily transport the computer from place to place.” (What is the function of a computer case? )(n.d). My choice for my CPU Case is CORSAIR Obsidian 500D RGB SE Mid-Tower Case.

Monitor: The monitor is an output device that its  main responsibility is to display the final result of all of your  computer’s image rendering and processing. I selected the Samsung 49”  Odyssey G9 for my PC project.

Keyboard: The main function of a keyboard is to  operate the computer by sending it data. This data often consists of  characters (letters, numbers, line escapes), but can also tell the  computer to perform a function such as change the brightness or eject a  disk from the disk drive.

Mouse: The mouse is an input device that allows to perform different functions such as select and navigate through the PC.

For my computer project, I will spend most of the money on the  Graphics Card and the Monitor. The other components are extremely  important as well, but because I’m trying to build a gaming PC, I will  focus more on enhancing the game’s graphics than anything else.

References:

IAC Publishing. (n.d.). What is the function of a computer case? Reference. Retrieved July 19, 2022, from https://www.reference.com/world-view/function-computer-case-b83f2210878e3090 (Links to an external site.)

Khan Academy. (n.d.). CPU: Central Processing Unit | AP CSP (article). Khan Academy. Retrieved July 19, 2022, from https://www.khanacademy.org/computing/computers-and-internet/xcae6f4a7ff015e7d:computers/xcae6f4a7ff015e7d:computer-components/a/central-processing-unit-cpu#:~:text=The%20CPU%20is%20the%20brain,run%20programs%20on%20a%20computer (Links to an external site.).

McCall, V. (2021, March 15). What is Ram? how your computer’s memory keeps all your programs running smoothly. Business Insider. Retrieved July 19, 2022, from https://www.businessinsider.com/what-is-ram (Links to an external site.)

Optical drives. PC Build Advisor. (n.d.). Retrieved July 19, 2022, from https://www.pcbuildadvisor.com/components/optical-drives/