Discuss an organization’s need for physical security. What methods, approaches, and models can be used by organizations when designing physical security needs? Lastly, explain how these security measures will safeguard the organization.
Please make your initial post substantive. At least one scholarly source should be used in the initial discussion thread. Use proper citations and references in your post.
This week, you watched the Social Media Revolution 2019 #Socialnomics and read The Beginner’s Guide to Social Media. https://moz.com/beginners-guide-to-social-media
Discussion:
As you review the multiple statistics that display in Social Media Revolution 2019 #Socialnomics, and reflecting on what you read about social media, assess the impact of social media in your life.
Question #1:
What role does Social Media play in your life? Are you aware of the social media policies of the organizations where you work, attend school, or volunteer? Have you used social media to resolve problems, participate in a cause you are passionate about, or to learn about UMGC? How does Social Media impact your personal and professional communications?
Topic 2: Digital Humanitarianism
This week you also watched Innovations in Humanitarian Relief (PBS online video) https://www.pbs.org/video/innovation-humanitarian-relief-e6xivw/
Discussion:
In the wake of natural disasters and acts of terror, several tech companies are making an effort to improve traditional responses effort in humanitarian relief.
Question #1:
Do you think that humanitarian aid workers constantly need new ways of thinking, new products and new processes to better respond to disasters? Why or why not?
Topic 3: Cyber Psychology
This week you read: Cyber psychology and cyber behavior of adolescents-the need of the contemporary era https://www.sciencedirect.com/science/article/pii/S1877050917326704
Discussion:
Cyber psychology evaluates how we interact with others using technology, how we can develop technology to best fit our requirements, and how our behavior and psychological states are influenced by technology. Cyber psychology applies psychological theory to explain how individuals interact in cyberspace and how these interactions might affect our offline lives. It offers a new way to define the self and society.
Question #1:
How does technology impact psychology? List at least three advantages and at least three disadvantages.
Question #2:
Do you present yourself differently in different online spaces? In what ways are you different and in what ways are you consistent? Why do you think this is?
This assignment consists of two parts.
Your client is interested in how you will structure the website. Before you begin to write the HTML for your pages, it’s a good practice to create a storyboard that outlines your ideas for colors, font sizes, placement of images, hyperlinks, and sections on each page. Your storyboard and file structure should outline your homepage, inside pages, navigational scheme, and where you plan to add your form. This is a high-level design that you will be adjusting and changing throughout the quarter. You do not need to write this in HTML! In fact, it will save you time if you develop your storyboard in Word, PowerPoint, or Visio first, so you can make adjustments based on feedback.
Here are some online resources to help you think through the process:
Based on your storyboard, you will begin to create your file structure for your site. It is never a good practice to keep all your files in the same folder.
For example, if you are developing a site that sells clothing for men, women, and children, you might have one folder for all the pages that house men’s clothing, another for women’s clothing, and so on.
You can create this portion in Word, indicating where each of your HTML pages will be located, as shown in Section 2.4: Links in Your Text.
This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.
The specific course learning outcome associated with this assignment is:
Grist – SciFi Movies
Printable document for Grist – SciFi Movies:
Grist – SciFi Movies.docx
1) Create a new database by Importing the file below:
Please download the excel import data SciFi Movie – Import.xlsx to use as an import for this assignment
Import Document into Grist.
Be sure the following column options are as stated below:
2) Rename the Table – Movies
3) Create another table called Directors by adding an empty table.
Add the following columns:
Director Number – Column Type – Reference: Movies Table and Director Number
Director Name – Column Type – Text
# of Movies Directed – Column Type – Numeric / Alignment – Centered
Fill in the fields and data from the table below:
Director Number
Director Name
# of Movies Directed
CRN
Christopher Nolan
10
GEL
George Lucas
18
AYW
Andy Wachowski
11
JSC
James Cameron
22
RTZ
Robert Zemeckis
25
TYG
Terry Gilliam
19
JJA
J.J. Abrams
12
SNS
Steven Spielberg
52
AOC
Alfonso Cuaron
15
AWN
Andrew Niccol
7
IOH
Ishiro Honda
59
PLV
Paul Verhoeven
28
4) Create a new page for an overview. Add a widget to new page and select a table for the Movies table with summary data for the Director Number. Remove the Count and Rating Columns.
5) Rename the new page in the navigational bar Movie Overview.
6) Add Widget to page and select the card widget for the Movies table with summary data for the Movie Number. Change the Theme to Blocks. Customize the card by hiding the count field and moving Length-Minutes to the second row. You will have 3 fields going across on the 2nd row.
7) Add widget to page and select the chart widget for the Movies table with a summary of data for the Awards. Change the chart to a pie chart. Hide all series except for Awards and count. Customize layout appropriately.
*When complete, your Movie Overview page should have a Movie summary of the Movies table, a Movies Card widget and a Movies Chart Widget.
8) In the Movies table create a new field name called Movie Rating.
Column Type – Choice: R, PG and PG-13
Update the rest of the table to meet the data below.
Movie Names
Movie Rating
Aliens
R
Back to the Future
PG
E.T.
PG
Gravity
PG-13
Godzilla
PG-13
Inception
PG-13
Gattaca
PG-13
Starship Troopers
R
Star Trek
PG-13
Star Wars
PG
Terminator
R
Twelve Monkeys
R
The Matrix
R
9) Add widget to Movies page and select the chart widget for the Movies table with a summary of data for the Movie Rating. Change the chart to a pie chart. Hide all series except for Movie Rating and count. Customize layout appropriately.
The recent advances in information and communication technology (ICT) has promoted the evolution of conventional computer-aided manufacturing industry to smart data-driven manufacturing. Data analytics in massive manufacturing data can extract huge business values while it can also result in research challenges due to the heterogeneous data types, enormous volume and real-time velocity of manufacturing data.
For this assignment, you are required to research the benefits as well as the challenges associated with Big Data Analytics for Manufacturing Internet of Things.
Your paper should meet these requirements:
Be approximately four pages in length, not including the required cover page and reference page.
Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
Assignments containing different modules 9, 12 and 13 explained in the attached word document.
Write a 4 page APA formatted paper comparing your organization’s disaster recovery and business continuity plans with the best practices outlined in your course text. Content should include, but not be limited to: selecting the DR. team, assessing risks and impacts, prioritizing systems and functions for recovery, data storage and recovery sites, developing plans and procedures, procedures for special circumstances, and testing the disaster recovery plan. Your paper should include an abstract and a conclusion and a reference page with 3-5 references
Risk Handling
1) What do you think is the single greatest physical threat to information systems? Fire? Hurricanes? Sabotage? Terrorism? Discuss this question and provide support for your answer.
2) Some organizations prohibit workers from bringing certain kinds of devices into the workplace, such as cameras, cell phones, and USB drives. Some businesses require employees to use clear or see-through backpacks when carrying personal items. What other devices might not be allowed in certain facilities, and why would they be restricted? The video on Google’s Data Center may give you some ideas to write about for this assignment.
Shelly Cashman Excel 2019 | Modules 1-3: SAM Capstone Project 1a
Ensight Healthcare Consultants
CREATE FORMULAS WITH FUNCTIONS
· Open the file SC_EX19_CS1-3a_FirstLastName_1.xlsx, available for download from the SAM website.
· Save the file as SC_EX19_CS1-3a_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
· With the file SC_EX19_CS1-3a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. Carla Arranga is a senior account manager at Ensight Healthcare Consultants, a consulting firm that works with hospitals, clinics, and other healthcare providers around the world. Carla has created a workbook summarizing the status of the consulting project for Everett Hospital. She asks for your help in completing the workbook.
Go to the Project Status worksheet. Unfreeze the first column since it does not display information that applies to the rest of the worksheet.
2. In cell J1, enter a formula using the NOW function to display today’s date. Apply the Short Date number format to display only the date in the cell.
3. Format the worksheet title as follows to use a consistent design throughout the workbook:
a. Fill cell B2 with the Dark Red, Accent 6, Lighter 40% shading color.
b. Change the font color to White, Background 1.
c. Merge and center the contents of cell B2 across the range B2:H2.
d. Use AutoFit to resize row 2 to its best fit.
4. Format the billing rate data as follows to suit the design of the worksheet and make the data easier to understand:
a. Italicize the contents of cell I2 to match the formatting in cell I1.
b. Apply the Currency number format to cell J2 to clarify that it contains a dollar amount.
5. Format the data in cell A4 as follows to display all of the text:
a. Merge the cells in the range A4:A13.
b. Rotate the text up in the merged cell so that the text reads from bottom to top.
c. Middle-align and center the text.
d. Remove the border from the merged cell.
e. Resize column A to a width of 4.00.
6. Format the data in row 4 as follows to show that it contains column headings:
a. Change “Description” to use Service Description as the complete column heading.
b. Apply the Accent 6 cell style to the range B4:H4.
c. Use AutoFit to resize column D to its best fit.
7. Carla wants to include the actual dollar amount of the services performed in column E. Enter this information as follows:
a. In cell E5, enter a formula without using a function that multiplies the actual hours (cell D5) by the billing rate (cell J2) to determine the actual dollar amount charged for general administrative services. Include an absolute reference to cell J2 in the formula.
b. Use the Fill Handle to fill the range E6:E13 with the formula in cell E5 to include the charges for the other services.
c. Format the range E6:E13 using the Comma number format and no decimal places to match the formatting in column F.
8. Carla needs to show how much of the estimate remains after the services performed. Provide this information as follows:
a. In cell G5, enter a formula without using a function that subtracts the actual dollars billed (cell E5) from the estimated amount (cell F5) to determine the remaining amount of the estimate for general administrative services.
b. Use the Fill Handle to fill the range G6:G13 with the formula in cell G5 to include the remaining amount for the other services.
c. Format the range G6:G13 using the Comma number format and no decimal places to match the formatting in column F.
9. Carla also wants to show the remaining amount as a percentage of the actual amount. Enter this information as follows:
a. In cell H5, enter a formula that divides the remaining dollar amount (cell G5) by the estimated dollar amount (cell F5).
b. Copy the formula in cell H5 to the range H6:H14, pasting only the formula and number formatting to display the remaining amount as a percentage of the actual amount for the other services and the total.
10. Calculate the project status totals as follows:
a. In cell D14, enter a formula using the SUM function to total the actual hours (range D5:D13).
b. Use the Fill Handle to fill the range E14:G14 with the formula in cell D14.
c. Apply the Accounting number format with no decimal places to the range E14:G14.
11. Carla also wants to identify the services for which Ensight has billed more than the full estimate amount.
In the range H5:H13, use Conditional Formatting Highlight Cells Rules to format values less than 1% (0.01) in Light Red Fill with Dark Red Text.
12. Carla imported data about the consultants working on the Everett Hospital project and stored the data on a separate worksheet, but wants to include the data in the Project Status worksheet.
Copy and paste the data as follows:
a. Go to the Consultants worksheet and copy the data in the range B2:G12.
b. Return to the Project Status worksheet. Paste the data in cell J3, keeping the source formatting when you paste it.
13. Carla needs to list the role for each consultant. Those with four or more years of experience take the Lead role. Otherwise, they take the Associate role. List this information as follows:
a. In cell N5 on the Project Status worksheet, enter a formula that uses the IF function to test whether the number of years of experience (cell M5) is greater than or equal to 4.
b. If the consultant has four or more years of experience, display “Lead” in cell N5.
c. If the consultant has less than four years of experience, display “Associate” in cell N5.
d. Copy the formula in cell N5 to the range N6:N13, pasting the formula only.
e. Use AutoFit to resize column N to its best fit.
14. Carla wants to include summary statistics about the project and the consultants. Include this information as follows:
In cell D16, enter a formula that uses the AVERAGE function to average the number of years of experience (range M5:M13).
15. Make the 3-D Clustered Column chart in the range B17:H31 easier to interpret as follows:
a. Change the chart type to a Clustered Bar chart.
b. Use Actual Project Hours as the chart title.
c. Add a primary horizontal axis title to the chart, using Hours as the axis title text.
d. Add data labels in the center of each bar.
16. Delete row 33 since Carla has reformatted the clustered column chart.
17. Go to the Schedule worksheet. Rename the Schedule worksheet tab to Project Schedule to use a more descriptive name.
18. Each service starts on a different date because the services depend on each other. Enter the starting dates for the remaining services as follows:
a. In cell D6, enter a formula without using a function that adds 4 days to the value in cell C6.
b. In cell E6, enter a formula without using a function that subtracts 3 days from the value in cell C6.
c. In cell F6, enter a formula without using a function that adds 2 days to the value in cell E6.
d. In cell G6, enter a formula without using a function that adds 2 days to the value in cell C6.
19. Copy the formulas in Phase 2 to the rest of the schedule as follows:
a. Copy the formula in cell D6 to the range D7:D9.
b. Copy the formula in cell E6 to the range E7:E9.
c. Copy the formula in cell F6 to the range F7:F9.
d. Copy the formula in cell G6 to the range G7:G9.
20. In cell C11, enter a formula that uses the MIN function to find the earliest date in the project schedule (range C6:G9).
21. In cell C12, enter a formula that uses the MAX function to find the latest date in the project schedule (range C6:G9).
Your workbook should look like the Final Figures on the following pages. The value in cell J1 has been intentionally blurred as it will never be constant. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.
Final Figure 1: Project Status Worksheet
Final Figure 2: Project Schedule Worksheet
