Monthly Archives: June 2023

Discussion post

You are a bank manager and you are helping a new bank teller understand the kind of accounts the bank offers. If a customer comes in asking to open a new savings account, the teller needs to ask what kind of account—passbook savings or certificate of deposit—the customer would like to open. Remind the customer that all accounts with our bank are insured by the FDIC. You should explain that all accounts earn some interest; a savings account’s interest is compounded monthly. You should assign a unique account number after accepting the customer’s initial deposit. If the customer chooses to receive statements electronically, the system will send an e-mail with a monthly statement; if the customer chooses not to, then a paper statement will be sent by mail quarterly.

If savings account is a class, give an example of each of the following as it relates to that savings account. Explain your reasoning behind your example.

 Pick one of the following terms for your research: Strategic philanthropy, locus of control, ethical culture, ethical awareness, or normative approach.  

–  The paper should have a ‘Definition, Summary and Discussion’ headings ( Summary should have 150-200 words and discussion should have 300-350 words. )

– Attach minimum 2 references

– Absolutely no plagiarism, attach a plagiarism report with a 0% similarity index

1 page and a half

 Research two (2) private investigation firms that specialize in digital forensics.  Write a page and a half describing the following:

• Mission and description of the two firms researched
• Describe four common services each firm offers (it is possible each of the two firms offers the same services)
• Describe four rules of law that affect digital forensics in a private firm

Chapter 9 introduces blockchain advantages in the artistic content creation and delivery business. Do you create or acquire artistic content? (art, music, etc.) Discuss how the changes covered in chapter 9 would affect you personally. Would adopting blockchain technology change your art production or consumption practices?

PROJECT 1: CENSUS DATA

OBJECTIVE
The purpose of this project is to demonstrate your understanding of the following course concepts:

1. How to create and navigate within workbooks.
2. How to enter data and format cells.
3. How to format worksheets and workbooks.
4. How to create, edit, and format tables.
5. How to modify tables.
6. How to use functions and formulas.
7. How to calculate and transform data.
8. How to create and modify charts.

PROJECT DESCRIPTION
You are working as part of a group creating a report that includes data from the most recent census. Your task is to create and format a worksheet using information from the census.gov website and chart the data.

1. Create a new workbook and save it as Project1_Census.xlsx.
2. Identify three U.S. cities of your choice and enter the city and state names in cells A4, A5, and A6.
3. Open a web browser and navigate to the data.census.gov website. Use the most recent census data to locate the population, median age, number of housing units, and median income for each city (e.g. type “median income in Maryland” in the search box at the top of the page).
4. Enter the information into the respective cells in the worksheet, as shown in the image below but using cities of your own choosing. Note: If you are unable to locate the necessary data, either choose a different city or perform a search for another website containing the necessary data.

PROJECT 1 FIGURE 1

5. Format the data table using techniques you have learned to present the data in a visually appealing form such as:

a. Set the column widths appropriately.
b. Set labels alignment appropriately.
c. Apply borders, gridlines and shading to the table as desired.
d. Set the columns labels alignments appropriately.
e. Align the worksheet vertically and horizontally on the page.

6. Enter a formula to find Average Household Income for all THREE cities.
7. Enter a formula to find the Total Population for all THREE cities.
8. Create charts that present the data for each of the four categories of data. Decide which chart types will best present the data. (Hint: If you are not sure which types to use, consider selecting he data and using the Recommended Chart button to narrow down and preview suitable choices.)
9. Place each chart on a separate sheet and format the charts to best present the data in a clear, attractive format.
10. Give each worksheet a descriptive name and color the tabs using theme colors. Reorder the sheets so that the data table appears first, followed by the charts.
11. Save and submit the workbook to the Assignment Folder.

SUBMISSION REQUIREMENTS
Please submit the following to your Assignments Folder:

1. The completed Project1_Census.xlsx file.
2. Submit a Project Reflection (see below).

PROJECT REFLECTION
Answer the following questions when you submit your assignments files.

a. Describe a situation in daily life when someone would use Microsoft Excel.
b. You made several decisions while creating the workbook for this assignment: how to lay out the data in the worksheet and which chart types to use. What was the rationale behind each of these decisions?
c. What issues or challenges did you face completing this project? 

• 5.1 Provide a brief definition of network access control.
• 5.2 What is an EAP?
• 5.3 List and briefly define four EAP authentication methods.
• 5.4 What is EAPOL?
• 5.5 What is the function of IEEE 802.1X?
• 5.6 Define cloud computing.
• 5.7 List and briefly define three cloud service models.
• 5.8 What is the cloud computing reference architecture?
• 5.9 Describe some of the main cloud-specific security threats.

**Please Check The Word Document For Guidelines**

**Please Do As Required**

part 1 

Using Internet and/or the Library, research and complete the following: 

In 1,000 or more words respond to the following: 

Explain the Stuxnet virus. Be sure to cover what its goals were thought to be, how successful it was in accomplishing those goals, the possible methods of initial system infections, how it was discovered, and the long-term implications of Stuxnet relative to cyber-warfare. 

part 2: 

In 200 or more words for each answer, respond to the following: 

• Construct a security policy for the physical domain. 

 Exp22_Word_Ch02_Cumulative_Pool

 Exp22 Word Ch02 Cumulative Pool

Word Chapter 2 Cumulative – Pool

Project Description:

You and a friend from college are starting a new business, Pool Pros, a pool maintenance and supplies operation. You plan to have on hand various documents and brochures related to pool ownership, one of which you are working with now. You will use skills presented in this chapter to format text, adjust alignment and indents, bullet and number lists, and incorporate various types of graphic objects that help describe the process of caring for a pool.

Start Word. Download and open   the file named Exp22_Word_Ch02_Cumulative_Pool.docx.   Grader has automatically added your last name to the beginning of the   filename. Ensure that nonprinting characters are displayed.

Select crystal-clear perfection at the end of the first body paragraph   and bold it. Select all text and change the font to Arial. Change the   alignment of selected text to Justify.

Select the first two body   paragraphs on page 1 and adjust the line spacing to 1.5. Ensure that   paragraph spacing before and after is 0 pt for the selected paragraphs. Apply   a First line indent for the two paragraphs of 0.5″. 

Select all subheadings that are   formatted in bold and change the font size to 14. 

Select the four paragraphs that   precede the Get Rid of Debris   heading, beginning with Check the   pool’s water balance and ending with Add   an algaecide. Add a Box, double-line border with ¾ line weight and a color of   Blue-Gray, Text 2 (fourth column, first row). Shade the bordered area with Blue-Gray, Text 2 Lighter 60%   (fourth column, third row under Theme Colors).

Display the ruler. Click or   position the insertion point at the top of the document and press ENTER.   Click or select the newly inserted blank paragraph. Drag or move the First   line indent marker back to the left margin to remove the First line indent   from the blank paragraph.

Set a left tab at 1″ and a   right tab at 5″. Ensure that the right tab includes a dash leader. Press   TAB and type Your Pool. (Do not type the period.) Press TAB and type Your Way. (Do not type the period.) Change the font for Your Pool and Your Way to Lucida Calligraphy. Bold both text items on the first   line and change the font size to 10.

Click or position the insertion   point before the second sentence in the first body paragraph at the top of   page 3. The sentence begins with Add   more in hot weather. Delete the preceding space and period that ends the   first sentence. Insert an Em dash symbol and change the case of Add   to add.

Select the four paragraphs in   the shaded area near the top of page 1. Apply numbering, choosing Number   alignment: Left (1., 2., 3.).

Click or position the insertion   point at the top of the document and insert WordArt, selecting Fill: Blue,   Accent color 1; Shadow (row 1, column 2). Type Pool Maintenance. (Do not type the period.)   Change the font size of Pool   Maintenance to 24 and change the Text Fill to Black, Text 1. Ensure that WordArt   font is Arial. Wrap text at Top and Bottom and visually center the WordArt   horizontally on the first line 

Click or position the insertion   point at the end of the document and press ENTER. Insert SmartArt, selecting   Basic Cycle. Display the Text pane. Type Get rid of debris beside the first bullet. Type Vacuum pool beside the second bullet. Type Adjust   chemicals beside   the next bullet. Type Backwash filter and Add chlorine beside the next two bullets. Close the Text pane.

Adjust the SmartArt height to   3″ and the width to 5″. Choose Polished SmartArt style and change colors to Gradient Range   – Accent 3 (row 5, column 3). Choose text wrapping of Square. Align the   SmartArt object in the center relative to margins.

Click or position the insertion   point at the top of the document. Insert a Sun shape from the Basic Shapes category. Draw the   shape approximately 1″ wide and 1″ high, near the left margin on the top line   of the document. Using the Shape Format tab, adjust the height and width to   exactly 1″.

Change the shape fill of the sun   to Yellow. Insert a Cloud shape from the Basic Shapes category, sizing it to   be approximately ¾” high and ¾” wide. Position the shape so that it   overlaps the top right corner of the Sun shape. Change the shape fill of the   cloud to Light   Gray, Background 2. Send the cloud to the back so that it appears to be   peeking out from behind the sun.

Group the cloud and sun shapes   into one object. Duplicate the shape and drag the copy to the right, aligning   it at the right margin on the same line as the WordArt heading. Align the   first shape at the left margin, approximating a mirrored placement of the   copied shape.

Draw a text box of any size near   the middle of page 2. Copy the first sentence in the document, On a searing summer day, a swimming pool   is a welcome respite from the heat. (Include the period.) Paste the   copied sentence in the text box. Adjust text box height to 1″ and width   to 3″. Choose Tight text wrapping.

Change the font size of text in   the text box to 14 and change the font to Tahoma. Center the text. Click or press   Align in the Arrange group on the Shape Format tab and align the text box in   the middle and also in the center of the page. If the text box awkwardly   divides a heading, drag or move it down slightly to better position it   visually. Remove the outline from the text box and apply a shape fill of   Blue-Gray, Text 2, Lighter 80%.

View the document in Multiple   Pages and check for any poorly placed headings. Insert a page break before Vacuum the Pool at the bottom of page   1. Insert a page break before Add   Chlorine to the System at the bottom of page 2.

Save and close Exp22_Word_Ch02_Cumulative_Pool.docx.   Exit Word. Submit the file as directed.