Archive for month: January, 2024

Exp19_Excel_Ch01_ML1_Rentals

Exp19 Excel Ch01 ML1 Rentals

Excel Chapter 1 Mid-Level 1 – Rentals

 

Project Description:

You manage a beach guest house in Ft. Lauderdale containing three types of rental units. Prices are based on peak and off-peak times of the year. You need to calculate the maximum daily revenue for each rental type, assuming all units are rented. In addition, you need to calculate the discount rate for off-peak rental times. Finally, you will improve the appearance of the worksheet by applying font, alignment, and number formats.

 

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

 

You want to format   the main title to have a consistent appearance to other documents and   spreadsheets.

Apply the Heading 1 cell style to the range A1:G1.
Hint: Cell Styles is on the Home tab.

 

You want to apply a   similar, complementary style to the date, which is below the main title.
Apply the 20% – Accent1 cell style to the range A2:G2.

 

The Peak Rentals   heading is centered over the related data in columns C and D. You want the   Off-Peak Rentals heading to be centered over its related data.
Merge and center Off-Peak Rentals   in the range E4:G4.
Hint: Merge and Center is on the Home tab.

 

To help other people   know that the Off-Peak Rentals heading is related to three columns of data,   you want to apply a fill color to that heading. You will choose a different   color to distinguish these data columns from the fill color used for the Peak   Rentals heading.
Apply Blue fill color (the eighth color below Standard Colors) and White,   Background 1 font color to cell E4.
Hint: Fill Color and Font Color are on the Home tab.

 

Three headings   (Maximum Revenue, Maximum Revenue, and Discount Rate) do not fully display on   the fifth row. Instead of widening the columns, you want to wrap the headings   within their respective cells. This will enable you to maintain the column   width appropriate for the data below the headings.
Center and wrap the headings on row 5.
Hint: Use the Home tab.

 

You are ready to   calculate the Peak Rentals Maximum Revenue that can be earned. The maximum   revenue is the total revenue if all rental units are rented.
In cell D6, enter a formula that calculates the Peak Rentals Maximum Revenue.
Hint: Formula is: No. of Units*Daily Rate

 

The Discount Rate is   the percentage off of the Peak Rentals Per Day Rate used to calculate the   Off-Peak Rentals Per Day rate. The Studio Apartment rents for $120 Off-Peak,   which is 80% of the $149.95 Peak rate. Therefore, the Discount Rate for the   Off-Peak Per Day rate is 20%.
In cell G6, enter a formula that calculates the Discount Rate for the   Off-Peak rental price per day.
Hint: Formula is: 1-(Off-Peak Rentals Daily Rate/Peak Rentals Daily Rate)

 

You created formulas   for the Peak Rentals Maximum Revenue and the Discount Rate for the Off-Peak   Rentals for the Studio Apartment rental type. Now you want to copy the   formulas to the remaining rental types so that you don’t have to create formulas   again.
Copy the formula in cell D6 to cells D7:D8. Copy the formula in cell G6 to   cells G7:G8.
Hint: Use the fill handle.

 

The values in the   columns are hard to read with varying number of decimal points. The   Accounting Number Format will align the decimal points and display dollar   signs to improve the appearance of the monetary values.
Format the range C6:F8 with Accounting Number Format.
Hint: Accounting Number Format is on the Home tab.

 

The Discount Rate   formula results are displayed as decimal points. However, formatting the   values as percentages will align decimal points and clearly indicate the   percentages.
Format the range G6:G8 in Percent Style with one decimal place.
Hint: Look in the Number group on the Home tab.

 

You applied a solid   blue to the Off-Peak Rentals heading, so you will apply a complementary   lighter blue fill color to the data below that heading.
Apply Blue, Accent 1, Lighter 80% fill color to the range E5:G8.
Hint: The Fill Color palette contains an option for selecting more colors to   customize.

 

A solid red fill is   applied to the Peak Rentals heading. You will select a complementary custom   fill color for the data below that heading.
Select the range C5:D8 and apply a custom fill color with Red 242, Green 220,   and Blue 219.
Note, Mac users, in the Colors dialog box, click the Color Sliders tab and   then select the RGB Sliders.
Hint: On the Home tab, in the Font group, click Fill Color, and then click More   Colors.

 

Answer the first   question below the worksheet data. Apply Yellow highlight color to the   correct answer in either cell A16, A17, or A18.

 

Answer the second   question below the worksheet data. Apply Yellow highlight color to the   correct answer in either cell A22, A23, or A24.

 

Answer the third   question below the worksheet data. Change XX.X%   to the correct percentage in cell A28.

 

Now that the   worksheet contains formulas and is formatted, you are ready to apply Page   Setup options to prepare the worksheet to be printed, if needed.
Select Landscape orientation, center the data horizontally on the page, and   apply the setting to fit to one page.
Hint: The Page Layout tab contains options needed.

 

It is important to   provide identification information in a footer of the worksheets. In   particular, the textbook series name, the worksheet name, and the file name   help identify the worksheet.
Insert a footer with the text Exploring Series on the left side, the sheet   name code in the center, and the file name code on the right side.
Hint: Use the Insert tab or the Page Layout tab to insert a footer.

 

To preserve the   original data, you make a copy a worksheet so that you can manipulate the   data or if you want to review the formulas.
Create a copy of the Rental Rates worksheet, place the new sheet to the right   side of the original worksheet, and rename the new sheet as Formulas.
Hint: Display a shortcut menu from the sheet tab.
 

You want to display   the formulas and set print options so that it will be easier to read and   interpret the rental formulas on a printout, if needed.
On the Formulas worksheet, display cell formulas, and set options to print   gridlines and headings.
Hint: Use the Formulas tab on the ribbon.

 

Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

In this assignment, you are taking on the role of a person who is responsible for raising awareness of the threats and posted by phishing messages.  The target audience is the faculty members and administrators at Adelphi.  You want to create an example of a phishing message that can be used to demonstrate effective techniques used by such messages and help train faculty and administration to avoid falling for such scams.

For this part, your team will design an effective phishing message.  Your design must include a subject line and a message body.  In the message body, you can use the following placeholders to make the phish more realistic:

• [FIRST]        First name of recipient
• [LAST]         Last name of recipient
• [EMAIL]       Email address included in the message
• [URL]           URL of a phishing landing page (you can specify the text that would be displayed for the link)

Be creative as you want, as long as you keep the tone and content “business appropriate.”  Remember the target audience and tailor your messages for the target audience.

If you want to incorporate graphics feel free to do so.  You can submit either an email text (with appropriate placeholders) or a PDF of a formatted message.

 

Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Back up strategies

Back up strategy is the planned and well-organized data protection using a backup policy that authorizes the backup responsibilities to the most appropriate and right persons or offices and also sets the duplication time cycles. In other words, it is the action of copying physical or virtual documents or files into a secondary data file to act as a security or bank of preservation to ensure that even if the original file gets lost, their data will be restored. Every IT officer ion any company understands the vitality of having a backup for all the necessary information and data in the office. He also understands the necessity of ability to retrieve or restore the data (Hutchinson Et al, 1999). Our computers and systems may experience system outage, hardware failure, natural disaster or other instances of data loss. Attempts to back up ones data started ages ago even before the invention of electronic technology. Even though, electronic technology has been improving day in day out in a more sophisticated way.  Today we have many methods that we can use for backing up our data as discussed below.

Use of external hard drive: These technologies have been in use for quite some time and it has been very helpful in backing up data and information. They come in different sizes, strategies, shapes and have different storage capacities.  All these types of hard drives work in the same manner and experience the same shortcomings and merits. Many of them come with backup software that is compatible with windows and other third-party backup software. It is very fast and convenient especially when backing up larger data. It is portable and not easily affected by the worms. The only disadvantage that is alarming is the initial cost of the hard drives.

Network storage:  the use of Network Attached Storage (NAS) has become very rampant in many businesses today. The only big issue with NAS is that its initial cost is very high. In comparison, it’s more effective because one NAS can be used to secure data for all the computers in an office instead of buying many hard discs for all the computers.  On the other hand, not all the windows version is compatible with NAS.

Cloud backup strategies: This is a strategy that is becoming so popular in the recent technology. It involves sending a copy of the files over an internet platform to an offsite server. The cloud backups are controlled by the company and charge an agreed fee either monthly or annually. The provider gives you a certain capacity depending on the much you pay for. Retrieving the files from the internet depends on the speed and the strength of the internet available thus making it slower than other methods (Ofek, Cakeljic and Gagne, 2002). The good thing about the cloud back up is the accessibility. With other strategies like hard drives, if you forget or misplace them, then accessing the data will not be possible. With cloud storage, the data can be retrieved anywhere any time provided there is internet and a computer gadget

 

References

 

Hutchinson, N. C., Manley, S., Federwisch, M., Harris, G., Hitz, D., Kleiman, S., & O’Malley, S. (1999, February). Logical vs. physical file system backup. In OSDI (Vol. 99, pp. 239-249).

Ofek, Y., Cakeljic, Z., & Gagne, M. (2002). U.S. Patent No. 6,397,308. Washington, DC: U.S. Patent and Trademark Office.

Y.Ueno, N.Miyaho, and S.Suzuki, 2009, “Disaster Recovery Mechanism using Widely Distributed Networking and Secure Metadata Handling Technology”, Proceedings of the 4th edition of the UPGRADE-CN workshop, pp. 45-48.

Vijaykumar Javaraiah, Brocade Advanced Networks, and Telecommunication Systems (ANTS), 2011, “Backup for Cloud and Disaster Recovery for Consumers and SMBs,” IEEE 5th International Conference, 2011.

 

Directions:

· Responses to classmates should not be “I agree” or “I like the way you stated that.” These responses should again be insightful, offering an opinion or facts based on your research and experiences. The response to one classmate should be a minimum of 125 words. See APA criteria for citing resources. You must provide a minimum of a reference, in APA format, in your original response.

Describe and discuss at least two backup strategies. Discuss the use of cloud backup strategies, as well?.

Directions:

· Students are required to post one original response to the discussion questions each week, as well as a response to one classmate. Original responses should not be a word for word rehashing of what is stated in the readings, but rather an integration of the concepts and additional insights, either from real world experience or additional sources. It should be a 280 word response to the question. See APA criteria for citing resources. You must provide a minimum of a reference, in APA format, in your discussion.

 

Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Question 1 (1 point)

Select the line of Java code that will correctly declare a float variable named average and assign the variable a value of 3.4.

Question 1 options:

	None of the above
	int average; average = 3.4;
	int average = 3.4D;
	int average = 3.4f;
	int average = 3.4;

Save

Question 2 (1 point)

Select the correct line of Java code to assign 1000 to an int variable named myValue.

Question 2 options:

	int myValue = 1000;
	int myValue = 0x3E8;
	int myValue = 0b1111101000;
	All of the above
	None of the above

Save

Question 3 (1 point)

Which of the following is an invalid Java statement:

Question 3 options:

	System.out.println(“Hello, World! “);
	int d = 14;
	d++;
	x + y/100;
	None of the above

Save

Question 4 (1 point)

Which of the following statements is a comment in Java

Question 4 options:

	/ This is a test
	public class Hello {
	// This is a test. //
	(String[] args)
	None of the above

Save

Question 5 (1 point)

Will the following Java code compile and run?

public class QuizItem  {    public static void main(String[] args)       {           final int age = 38;      System.out.println(“Age is ” + Age);    } }

Question 5 options:

	Yes
	No

Save

Question 6 (1 point)

What is the output from the following Java code?

public class Week1Quiz {

public static void main (String[] args) {

System.out.println (“Welcome”);

System.out.println (“to”);

System.out.print (“UMUC!”);

}

}

Question 6 options:

	Welcome to UMUC!
	No output as the code will not compile.
	Welcome to UMUC
	None of the above
	WelcometoUMUC

Save

Question 7 (1 point)

What character is assigned to the variable myChar in the following line of Java code?

char value = ‘\u0023’;

Question 7 options:

	#
	y
	null
	?
	X

Save

Question 8 (1 point)

Will the following Java code compile and run without errors? public class QuizItem  {    public static void main(String[] args)       {           final int age = 38;      age = 39;       System.out.println(“Age is ” + age);    } }

Question 8 options:

	Yes
	No

Save

Question 9 (1 point)

You are designing a program for users to enter whole numbers that range from -200 to 2147483648. What Java data type will best satisfy this range of numbers?

Question 9 options:

	int
	long
	byte
	char
	short

Save

Question 10 (1 point)

Given the following sequence of Java code: int var = 4; var++; var = var + 2; var–; var = -var;   What is the final value of var?

Question 10 options:

	4
	-6
	8
	-9
	None of the above

Save

Question 11 (1 point)

You are designing a program for users to enter whole numbers that range from -100 to 127. What Java data type will best and most efficiently satisfy this range of numbers?

Question 11 options:

	int
	char
	byte
	long
	short

Save

Question 12 (1 point)

Given the following sequence of Java code: int var1 = 9; int var2 = 12; boolean failure = false; int result = failure ? var1 : var2; What is the value of result after executing the code?

 

Question 12 options:

	12
	9:12
	9
	3
	0.75

Save

Question 13 (1 point)

Select the Java code that will correctly declare a boolean variable named success and assign it a value of false.

Question 13 options:

	Boolean success = true;
	int success = false;
	None of the above
	boolean success = 1;
	boolean success = 0;

Save

Question 14 (1 point)

Given the following sequence of Java code: int var1 = 9; int var2 = 12; int var3 = 12;   Which of the following statements evaluate to true

Question 14 options:

	var1 != var2
	var1 < var2
	var1 <= var2
	var2 == var3
	All of the above

Save

Question 15 (1 point)

What is the output from the following Java code?

public class Week1Quiz {

public static void main (String[] args) {

System.out.print (“Welcome”);

System.out.print (“to “);

System.out.println (“UMUC”);

System.out.print (“!”);

}

}

Question 15 options:

	WelcometoUMUC
	Welcome to UMUC
	Welcome to UMUC !
	No output as the code will not compile.
	None of the above

Save

Question 16 (1 point)

What Java keyword can used to create a named constant?

Question 16 options:

	static
	default
	final
	enum
	public

Save

Question 17 (1 point)

If we declared the following variables in Java

int age = 27;           int cafe = 0xCAFE;      int number1 =0b0001;   What is the output for the following Java statement?

System.out.println(age + cafe + number1);

Question 17 options:

	2720001
	51994
	54,false,A5194327
	None of the above

Save

Question 18 (1 point)

A non-local boolean variable is declared with the following Java code:

boolean myVar;

What is the value of myVar?

Question 18 options:

	true
	false
	null
	Unknown
	None of the above

Save

Question 19 (1 point)

Given the following sequence of Java code: int var1 = 4; int var2 = 6; int var3 = 10; int results = (var1 + var2) * var3 /(var1 + var3) – var2%var1; What is the values of results after executing the code?

Question 19 options:

	6
	5
	-2
	9
	None of the above

Save

Question 20 (1 point)

Given the following sequence of Java code: int var1 = 9; int var2 = 12; int var3 = 12; Which of the following statements evaluate to true

Question 20 options:

	(var1 == var2) || (var1 < var2)
	(var1 == var2) && (var1 < var2)
	!(var2 == var3)
	(var2 <= var3) && (var2 < var1)
	None of the above

Save

Question 21 (1 point)

What is the filename extension used for all Java source files.

Question 21 options:

	.js
	.java
	.javac
	.cs
	None of the above

Save

Question 22 (1 point)

From the list of Java variable names below, select the illegal variable name.

Question 22 options:

	K149a$
	2ForMe
	XXXXXXXXXXXXXXYYYYYYYYYYYYYYYzzzzzzzzzzzzzzzz
	Johns1290sX4k
	NoneForYou

Save

Question 23 (1 point)

What must be installed on a computer to be able to run bytecodes?

Question 23 options:

	Java Virtual Machine (VM)
	Microsoft Visual Basic
	Ubuntu Server
	Oracle Database (11g or higher)
	None of the above

Save

Question 24 (1 point)

What is the filename extension used for all Java compiled files.

 

Question 24 options:

	.cs
	.javac
	.bytes
	.class
	None of the above

Save

Question 25 (1 point)

What development tool do you use to launch Java bytecodes?

Question 25 options:

	java
	javadoc
	javac
	jconsole
	All of the above

 

Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Midwest Health Systems

Case Analysis Assignment

In this case, the context is Midwest Health Systems (Midwest) and the scenario is evaluating a enterpise information security architecture. Your analysis of this case will be framed around a number of questions that are presented at the end of this writeup. As laid out in our syllabus, your analysis should, at minimum, meet the “2-why” standard.

While you can find a number of strategies out there for conquering case analyses (many of them are very good), I recommend the approach of reading the case at least once without consideration of the questions. That opens the mind up to absorbing details that might otherwise erroneously get dismissed in a “know the questions, hunt for the answers” type of approach. After that, lay our your outline with each question framing a new major section. Then, re-read the case analysis and as you go through, build the outline of your answer with references to page numbers so you can quickly go back. Once the outline is built, you should have a clean connection between your point and some evidence from the case. At that point, it is a matter of polishing the communication without inadvertently changing the thesis.

The case can be found in your Harvard Coursepack, referenced in the Materials section of our syllabus. The case analysis must be submitted through Blackboard in Microsoft Word or .pdf format before 11:59pm Sunday, March 28th.

Case Analysis Questions:

1. Identify the IT general control risks evident from the case. For each risk identified, identifiy possible controls to mitigate those risks and explain why you believe the control would work.

2. Define residual risk and then identify at least three such risks from the case, mapping those examples conceptually to your definition of residual risk.

3. Do you agree with the audit team’s conclusion that the only significant areas of concern in IT general controls are access security and change management? Please explain your answer at a “2-why” minimum standard.

4. What course(s) of action do you recommend that Nelson take based on your analysis of identified risks and suggested controls?

 

Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!