Posts in category: Uncategorized

Java programming using intellij.

Q1: Celsius Temperature Table

The formula for converting a temperature from Fahrenheit to Celsius is

C = 5 / 9 ( F − 32 )

where F is the Fahrenheit temperature and C is the Celsius temperature. Write a method named celsius that accepts a Fahrenheit temperature as an argument. The method should return the temperature, converted to Celsius. Demonstrate the method by calling it in a loop that displays a table of the Fahrenheit temperatures 0 through 20 and their Celsius equivalents.

Q2: Test Average and Grade

Write a program that asks the user to enter five test scores. The program should display a letter grade for each score and the average test score. Write the following methods in the program:

• calcAverage—This method should accept five test scores as arguments and return the average of the scores.• determineGrade—This method should accept a test score as an argument and return a letter grade for the score, based on the following grading scale:

Score ​Letter Grade

90–100​​ A

80–89 ​​B

70–79 ​​C

60–69 ​​D

Below 60 ​​F

Q3: Conversion Program

Write a program that asks the user to enter a distance in meters. The program will then pre-sent the following menu of selections:

1. Convert to kilometers

2. Convert to inches

3. Convert to feet

4. Quit the program

The program will convert the distance to kilometers, inches, or feet, depending on the user’s selection. Here are the specific requirements:

• Write a void method named showKilometers, which accepts the number of meters as an argument. The method should display the argument converted to kilometers. Convert the meters to kilometers using the following formula:

kilometers = meters * 0.001

• Write a void method named showInches, which accepts the number of meters as an argument. The method should display the argument converted to inches. Convert the meters to inches using the following formula:

inches = meters * 39.37

• Write a void method named showFeet, which accepts the number of meters as an argument. The method should display the argument converted to feet. Convert the meters to feet using the following formula:

feet = meters * 3.281

• Write a void method named menu that displays the menu of selections. This method should not accept any arguments.• The program should continue to display the menu until the user enters 4 to quit the program.• The program should not accept negative numbers for the distance in meters.• If the user selects an invalid choice from the menu, the program should display an error message.

Here is an example session with the program, using console input. The user’s input is shown in bold.

Enter a distance in meters: 500 [Enter]

1. Convert to kilometers

2. Convert to inches

3. Convert to feet

4. Quit the program

Enter your choice: 1 [Enter]

500 meters is 0.5 kilometers.

1. Convert to kilometers

2. Convert to inches

3. Convert to feet

4. Quit the program

Enter your choice: 3 [Enter]

500 meters is 1640.5 feet.

1. Convert to kilometers

2. Convert to inches

3. Convert to feet

4. Quit the program

Enter your choice: 4 [Enter]

Bye!

Q4: Present Value

Suppose you want to deposit a certain amount of money into a savings account, and then leave it alone to draw interest for the next 10 years. At the end of 10 years, you would like to have $10,000 in the account. How much do you need to deposit today to make that happen? You can use the following formula, which is known as the present value formula, to find out:

P = F / ( 1 + r ) n

The terms in the formula are as follows:

• P is the present value, or the amount that you need to deposit today.• F is the future value that you want in the account. (In this case, F is $10,000.)• r is the annual interest rate.• n is the number of years that you plan to let the money sit in the account.

Write a method named presentValue that performs this calculation. The method should accept the future value, annual interest rate, and number of years as arguments. It should return the present value, which is the amount that you need to deposit today. Demonstrate the method in a program that lets the user experiment with different values for the formula’s terms.

Deliverables:

1. Source codes – 4 X 20 = 80%2. Screenshots of the program output. – 4 X 5 = 20%

Note: Sparingly comment your java source code, save all the files in your_lastname_lab_2 folder, zip it, and upload for grading.

Thank you!

#Exp19_Excel_Ch12_Cap_Bulldog_Collectibles

 #Exp19_Excel_Ch12_Cap_Inventory 

Project Description:

You are the operations manager for Bulldog collectables, a small  start-up company that deals with sports memorabilia. As you prepare to  document your inventory, you decide to utilize a template to save time.  To complete this task, you will create a worksheet based on an  Office.com template; you will also use the Macro Recorder and Visual  Basic for Application to automate sorting and calculations within the  workbook.

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

Delete the Inventory Pick List   and Bin Lookup worksheets.

Delete the INVENTORY PICK LIST   and BIN LOOKUP icons located  respectively in cells E2 and F2. Then Clear all   existing Data  Validation in the range A1:K15.

Delete the values in the range   B5:J15.

Record a macro named Sort, be sure to use relative    references. Ensure the macro sorts the data in the table in ascending  order   based on SKU (column A). Stop the Macro Recorder and Save the  workbook as a   Macro-Enabled Template.

Create a form control button   that spans the cell E2:E3. Assign the Sort macro and edit the button text to Sort.

Use the VBA Editor to create a   new module.
 

  Type the following VBA code to create a custom Inventory Value  function then   save and exit the VBA Editor (be sure to leave a blank  line between each line   and before End Function):
 

Function   InventoryValue (QTY, COST)
 

InventoryValue   = QTY * COST
 

Click cell J5 and use the newly   created InventoryValue function to  calculate the value of the inventory for   each item in column I.

Use the VBA Editor to create a   new module named ProtectWorkbook. Type the following VBA statements to create the   sub procedure (leave appropriate line spacing).
 

Sub   ProtectWorkbook()
 

‘Protect   workbook using the password eXploring
Worksheets(“Inventory   List”).Protect Password:=”eXploring”

Insert a new module named UnprotectWorkbook. Type  the following VBA   statements to create the sub procedure and then save  and exit the VBA Editor   (leave appropriate line spacing).
 

Sub   UnprotectWorkbook()
 

‘Unprotect   workbook using the password eXploring
Worksheets(“Inventory   List”).Unprotect Password:=”eXploring”

Insert a Form Control Button   spanning cells F2:F3 named Unprotect. Assign the UnprotectWorkbook macro to the newly   created Control Button.

Insert a Form Control Button   spanning the range G2:H3 named Protect. Assign the macro ProtectWorkbook.

Insert the comment Inventory   based on values in column J. in cell B3 (include the period).

Insert the comment Count of   items in column C.   in cell C3 (include the period).

Inspect the document for private   information and hidden properties.  Save the file when prompted then remove   Document Properties and  Personal Information, and Headers and Footers.
 

  Note: Mac users, from the Excel menu, open your preferences, click  Security,   and then click the check box to Remove personal information  from this file on   save. Delete any headers or footers in the workbook.

Check the document for   accessibility issues. Use the Accessibility  Checker pane to change the cell   styles to Normal in order to repair  the issue.

Check the document for   compatibility with Excel 2010, 2013, and 2016.
 

  Note: Mac users, skip this step.

Insert a new worksheet named Code.

Open the VBA Editor, open Module   1, and copy the code. Paste the code in the Code worksheet starting in cell   A1. 

In the VBA Editor, open Module   2, and copy the code. Paste the code in the Code worksheet starting in cell   A22. 

In the VBA Editor, open the   ProtectWorkbook, and copy the code. Paste the code in the Code worksheet   starting in cell A28. 

In the VBA Editor, open the   UnprotectWorkbook module, and copy the  code. Paste the code in the Code   worksheet starting in cell A35. 

Close the VBA Editor and save   the workbook as an xlsx file (not Macro-Enabled).

Close EXP19_Excel_Ch12_CAP_Inventory.xlsx. Exit Excel. Submit the file   as directed.

2 discussions 

1 assignment

PFA for details.

How do I make money

For this week you will return into the Changepoint PPM tool and continue working on the project that

you created in prior weeks. As a project goes through the execution phase, project control is critical to

ensure that a project stays within the constraints of time, cost, and scope. A project manager will use

different monitoring techniques to help keep the project within these constraints. If a project incurs

changes, becomes delayed, or costs become higher, a project manager will execute change control to

document and determine how to handle the change.

Once a project is completed, the project team should complete a final project report, which is the

administrative record of the completed project, which identifies all its functional and technical

components as well as other important project history. It includes all the strengths and weaknesses of

the project as it progressed and offers a final assessment of what went right (or wrong) throughout the

life of the project. It is essentially a “lessons learned” document of the project.

1. Log back into the Changepoint PPM (Daptiv) tool.

2. If not already existing, add a deliverable related to Project Close in your project with a work

packages titled “Perform Lessons Learned Workshop” and “Complete Project Close Report.”

3. Flag all tasks as complete

a. Complete this by either selecting each task and setting the status as Done, or you

may use your shift key and select all tasks (first task -> hold shift key -> last task).

Then right click on Status and choose ‘Mark as Complete’

4. Close all risks

a. Complete this by going to your Risk list, and updating the status for each to ‘Risk

Resolved’

5. Add in at least four (4) lessons learned

a. You will be creative with this assignment and make up some lessons learned that

you believe you may have learned from completing the project.

b. Steps:

i. Go to ‘Lessons Learned’ on the left menu

ii. Click ‘Add’ on the top

iii. Complete the fields: Lesson Type, Topic, Lesson, and Impact.

iv. Repeat to add in at least three different lessons learned.

6. Update project status to complete

a. Using the ‘Status’ button in the top right.

b. Update the ‘State” field to ‘Completed’

c. Update the ‘Phase’ field to ‘Close Out’

d. Within the Update Notes add in 2-3 sentences on what you learned this week. Also

add in 1-2 sentences about your experience with Daptiv.

7. Runs/save a project report and submits to the instructor for grading

assignment

Week Three Assignment

Do a bit of research on CWE, Common Weakness Enumeration.Write a brief overview of their scoring system.Pick one of common weaknesses identified on their site and describe it.
Your assignment should be 200-300 of your own words. 

 Week Three Discussion

Read the section in this week’s reading assignment on secure passwords.

Then pick and three passwords: one not secure, one acceptable, and one very secure. Then write a brief description of the passwords you have chosen, indicating why they are secure or not secure.t

Read and respond to at least two other students Discussions.

Post between 200 and 300 words.

 Excel is probably the most popular spreadsheet software for PCs. Why? What can we do with this package that makes it so attractive for modeling efforts?
Your response should be 250-300 words.

There must be at least one APA formatted reference (and APA in-text citation) to support the thoughts in the post.  Do not use direct quotes, rather rephrase the author’s words and continue to use in-text citations.

Exp19_Word_Intro_CapAssessment_Research

Project Description:

As you near graduation from college, you plan to apply to various graduate schools. You have prepared a draft of a statement of purpose that you will include in an application packet to each university to which you apply. You modify the statement of purpose so that it is attractive and error free. In addition, you include such items as a table, picture, header, footer, and footnote, formatting text in columns where appropriate. Finally, you use mail merge to prepare personalized copies.

Start   Word. Download and open the file named Exp19_Word_AppCapstone_IntroAssessment_Research.docx. Grader has automatically added   your last name to the beginning of the filename.

Apply the Slice document theme.   Select all text in the document, and change the font to Bookman Old Style.   Change the font size to 12. Adjust the right and left margins to 1.5″.

Insert a header (select Edit   Header). Type Adams in the left section of the header. Insert a right-aligned page   number, selecting Plain Number. Close the header.

Insert a manual page break   before the second paragraph on the second page, beginning with On behalf of the faculty and staff.

Select all text that displays   before the newly inserted page break and double-space the selected text.   Remove any paragraph spacing from the selected text.

Move to the beginning of the   document and press ENTER. Remove the First line indent from the newly   inserted blank paragraph. At the new paragraph, type Statement of   Purpose and   apply bold formatting to the title. Center the title.

A footnote enables you to   clarify or expound on a statement in the body of the document without   cluttering the document with more text. Unlike a footer, a footnote only   displays on the page in which it is cited.
 

  In the second paragraph on the first page, place the insertion point after   the period at the end of the sentence that ends with by the University of Arizona. Insert a footnote that reads The Three   Minute Thesis Competition is open to all academic disciplines at the   university.   (include the period).

Modify the Footnote style,   changing the font to Bookman Old Style and the font size to 12.

Change the word sophomore in the first sentence on the   first page to student.

Insert a footer (select Edit   Footer) and type 2022 Fall in the footer space. Change the footer font to   Bookman Old Style and change the footer font size to 12. Close the footer.

Newsletters are often formatted   in columns, as is the one that is included in this document. By using section   breaks, you can format each section independently of others.
 

  Select all text on pages 4 and 5 and format it in two columns. Insert a   Continuous section break before the words On   behalf of the faculty and staff at the top of the fourth page.

Click before the newly inserted   section break at the top of the fourth page and change the column setting to   One. Type Welcome to the College of Business and press ENTER twice. Select Welcome to the College of Business and   apply the Title style. Reduce the font size to 22. Center the newsletter   title.

Add a bottom border with a   weight of 1 1/2 to the text Welcome to   the College of Business.

Pictures and graphics are often   included in newsletters, adding interest and style. Even so, those objects   should be incorporated relatively seamlessly with surrounding text, requiring   that you wrap text appropriately and size graphics so they are attractive but   not overbearing.
 

  Place the insertion point before the words The College of Business at the beginning of the second body   paragraph on the fourth page. Insert the University.JPG picture, downloaded with this   project. Change the picture style to Reflected Rounded Rectangle. Resize the   picture height to 1″ and select Square text wrapping.

Place the insertion point after   the period ending the first paragraph on the second page (ending in upon graduation). Press ENTER. Remove   the First line indent. Insert a 2-column by 6-row table. Change the width of   the second column to 1″.

Type Course in the top left cell and press TAB. Type Grade in the next cell on the first   row. Press TAB. Complete the table as shown below:
 

  Course Grade
Int.   Microeconomics A
Int.   Macroeconomics B
Public   Finance B
Business   Calculus A
Contemporary   Economics A

Insert a row above the first row   in the table. Merge all cells in row 1 and type Major Courses Completed in row 1. Apply Align Center   alignment to row 1. Apply a table style of Grid Table 4 – Accent 6 (row 4,   column 7 under Grid Tables). Center the table horizontally.

Add a caption below the table.   The caption should read Table 1: Major Courses Completed at the University of Arizona. (Do not include the period.) Center the caption.

Create a custom watermark to   display at a diagonal, with the text Copy in Blue (column 8 in Standard colors). 

Check spelling and grammar in   the document. Correct the misspelling of analyzed   and the hyphenation of first-time.   If the check does not suggest a change for   first time, manually correct it in the second to last paragraph in the   left column on page 5, changing first   time to first-time. Ignore all   other grammatical and clarity concerns.

Replace the dash dividing the   words organization and Fortune 500 in the first paragraph on   the fourth page with an Em Dash symbol.

Select the paragraph beginning   with I hope you will accept the   challenge on the last page (including the paragraph mark). Apply shading   of Red, Accent 6, Lighter 60% to the selected paragraph.

Begin a mail merge, selecting   recipients from an existing list—Graduate_Schools.xlsx,   using Sheet1$. Sort the data source in ascending order by University and   filter to select only those universities with an Area equal to W.

Replace [University Name] in the first paragraph on the third page with   the merge field of University. Be sure to include the brackets with text to   be replaced. Ensure that a space precedes and follows the newly inserted   University placeholder. Preview the results and then finish the merge,   choosing to edit individual documents and merging all records.

Select the entire merged   document and copy it. Switch to Exp19_Word_AppCapstone_IntroAssessment_Research,   move the insertion point to the end of the document, and insert a manual page   break. At the top of the new page, paste the copied text. The original   document to which you pasted the merged data now contains 15 pages. Save Exp19_Word_AppCapstone_IntroAssessment_Research   and close all open documents without saving.

Save Exp19_Word_AppCapstone_IntroAssessment_Research. Close all other   open files without saving. Submit   Exp19_Word_AppCapstone_IntroAssessment_Research as directed.

Task : Analyze the incident response process.

Requirements:

An “event” is any observable occurrence in a computer, device, or network. Think of an event as being anything that you may see reported in a log file. Events can be good or bad. Any event that results in a violation of or poses an imminent threat to the security policy is called an “incident.” An incident can occur at any point from the desktop or mobile device level to the servers and infrastructure that make a network work.

1. 1. Would the process of incident response change if a crime was intentionally committed versus an accidental event, such as an employee who clicks a phishing email link? That is, would the process of detecting, identifying, resolving, and documenting system or network intrusions change? Why or why not?

Fully address the question(s) in this task ; provide valid rationale for your choices, where applicable.