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:
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?
**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:
Exp22_Word_Ch02_Cumulative_Pool
Exp22 Word Ch02 Cumulative Pool
Word Chapter 2 Cumulative – Pool
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.
Exp19_Excel_Ch11_ML1_Internships
As the Internship Director for a regional university, you created a list of students who are currently in this semester’s internship program. You have some final touches to complete the worksheet, particularly in formatting text. In addition, you want to create an advanced filter to copy a list of senior accounting students. Finally, you want to insert summary statistics and create an input area to look up a student by ID to display his or her name and major.
You want to extract the last four digits of the student’s ID.
#In cell B2 on the Students sheet, extract the last four digits of the first student’s ID using the RIGHT function. Copy the function from cell B2 to the range B3:B42.
Hint: Formula is =RIGHT(Student ID, 4)
#After extracting the last four digits of the ID, you want to align the data.
#Apply center horizontal alignment to the range B2:B42.
Hint: The Home tab contains alignment options.
#The first and last names are combined in column C. You want to separate the names into two columns.
Convert the text in the range C2:C42 into two columns using a space as the delimiter.
Hint: Text to Columns is located on the Data tab.
#You want to convert the text in column F to upper and lowercase letters.
#Use a text function in cell G2 to convert the text in cell F2 into upper and lowercase letters. Copy the function to the range G3:G42.
Hint: Formula is =PROPER(Major)
#Now that you have converted text from uppercase to upper and lowercase, you will hide the column containing the majors in all capital letters.
Hide column F.
Hint: The Home tab contains an option to hide a column.
You want to create a criteria range for the dataset.
#Create a criteria range by copying the range A1:I1 and pasting it in cell A44. Create conditions
for Senior Accounting majors on row 45 and an OR condition for Junior Accounting majors in the respective cells on row 46
You are ready to perform the advanced filter.
#Create an output range by copying the range A44:I44 to cell A48. Perform the advanced filter by copying data to the output range. Use the appropriate ranges for list range, criteria range, and output range
Hint: The Data tab contains the option to perform an advanced filter.
On the Info worksheet, you want to insert a database function based on conditions.
#Display the Info worksheet and insert the DSUM function in cell B2 to calculate the total tuition for junior and senior accounting students. Use the range A1:I42 for the database, Tuition for the field, and the criteria range.
You want to insert database functions to perform calculations.
In cell B3, insert the DAVERAGE function to calculate the average GPA for junior and senior accounting students on the Students worksheet. Use mixed references in the ranges.
You want to identify the highest GPAs for junior and senior accounting majors.
In cell B4, insert the DMAX function to identify the highest GPA for junior and senior accounting students on the Students worksheet. Use mixed references in the ranges.
In cell B5, insert the DMIN function to identify the lowest GPA for junior and senior accounting students on the Students worksheet. Use mixed references in the ranges.
In cell B6, insert the DCOUNT function to count the number of junior and senior accounting
students on the Students worksheet. Use mixed references in the ranges.
In cell B9, insert the DGET function to retrieve the last name of the student who has the ID listed in cell A9. Use the column number representing the Last Name column for the field argument and use the criteria range A8:A9. Edit the function to make the column letters absolute. Copy the DGET function from cell B9 to cell C9. Edit the field number to represent the GPA column.
You want to format the results of the database functions.
Format the range B3:B6 with Comma Style. Decrease the number of decimal places to zero
for cell B6.
You want to identify the location of a particular ID.
Insert the MATCH function in cell B13 to identify the position of the ID stored in cell B12. Use
the range A2:A42 in the Student’s worksheet as the lookup_array argument and look for exact
matches only.
Insert the INDEX function in cell B14 with Students!A$2:I$42 as the array, B$13 that contains the MATCH function as the row number, and 4 as the column number. Copy the function from cell B14 to cell B15. Edit the function to change the column number to 7.
Change the ID in cell B12 to 11282378. The results of the MATCH and INDEX functions
should change.
You want to insert a function to display other functions as text.
Insert the FORMULATEXT function in cell D2 to display the formula that is stored in cell B2.
Copy the function to the range D3:D6 and to the range D13:D15. In cell D8, insert the
FORMULATEXT function to display the function that is stored in cell B9, and in cell D9, insert
the FORMULATEXT function to display the function that is stored in cell C9.
Increase the width of column D to 50.
Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side on all sheets.
In approximately 300 words, discuss security and technical drivers for having an access control policy and the key tenets of that policy. Follow APA standard.
Instructions:
Please follow the APA Format
Please cite the reference properly in text
No plagrism
Require 300 words
