Monthly Archives: June 2023

Exp19_Excel_Ch12_HOEAssessment_To_Do_List

Project Description:

You have been named the new social director of your schools student government association. As part of your position, you organize, meetings, study sessions, and social gatherings. To help manage planning, you have decided to create an Excel template that can be reused each month. To complete this task you will download and edit a template from the template gallery. Automate the portions of the worksheet using the macro recorder and VBA, as well as inspect the document for compatibility and accessibility issues.

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

Select the range B2:I7. Click   the Data tab, click Data Validation, and click the Input Message tab. Click   Clear All to remove all data validation comments added by the template   creator. Click OK.

Delete column C.

Click cell B3, click the Review   tab, and click New Comment. Type the comment Enter Task. Using the previous method, add   the following comments to the corresponding cells.
 

  C3 – Enter   Status
  D3 – Enter   Start Date
  E3 – Enter   Due Date
  F3 – Enter   % Complete

Ensure the Developer tab is   enabled. Click cell B4. Click the Developer tab and click Use Relative   References in the Code group. Use the macro recorder to record a macro named DateStamp that inserts the current date   in the active cell. (Note, Mac users, Use Relative References is not   available on Mac).
  Hint: to insert the current date, press CTRL + :

Open the VBA Editor and insert a new module. Enter the following code   to create the reset procedure. Once the code is entered, run the macro, and   exit the VBA Editor.
  Note: To exit the VBA Editor, click File and select Save and return to Excel.   Alternatively on PC, press ALT+F11 or ALT+Q.
 

Sub Reset()
‘Resets To Do List
Range(“B4:H7”) =   “”
End Sub

Insert a Form control button   with the caption Date Stamp spanning the cell C9 and assign the DateStamp   macro. Ensure that the button remains within the borders of cells C9.

Insert a Form control button   with the caption Reset spanning the Cell D9 and assign the Reset macro. Click cell B4   and press the Date Stamp button to insert the current date. Then click the   Reset button to test the functionality of the newly created form control   button. 

Use the Accessibility Checker to check and identify accessibility   issues. Use the Accessibility checker pane to unmerge the range B2:H2 and   change the Table style to White Table Style Medium 1.

Select the range B2:H2, and   remove all borders. Select the range C2:H2, and apply the cell style Heading   1.

Select cell B2 and apply the   cell style Heading 2.

Insert a new worksheet named Code.

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

Open the VBA Editor, open   Module2, and copy the code. Paste the code in the Code worksheet starting in   cell A10.

Save and close Exp19_Excel_CH12_HOEAssessment_ToDoList.xlsx   as a macro-free workbook (.xlsx).   Exit Excel. Submit the file as directed.

Reading purpose: 

https://downloads.cloudsecurityalliance.org/assets/research/security-guidance/security-guidance-v4-FINAL.pdf

Topic 1: Section 3.1.1.4 of the given link provides several examples of information privacy and security laws, as well as legal frameworks from across the world. Select one of these areas, laws, or frameworks and discuss how it would impact a US-based company storing data with a cloud service provider or doing business with an organization or individual covered under that area, law, or framework.

Topic 2: Review Domain 4 of the given link. Your organization is transitioning workload from an on-prem data center to a PaaS cloud service offering. Discuss one specific way in which your audit activities must change to address the new hosting structure. What types of impacts could this change have?

Each topic should contain 300 words in length. It should be in your own words.

Company Description (Tech Lopes)

Tech Lopes delivers expert level IT support. We handle both software and hardware issues, as well as general maintenance and IT consultation. We have IT experts ready to provide assistance and results on data recovery, hardware repair, virus removal, and general IT support. We work with all brands of computers, smartphones and tablets in relation to both hardware and software.

QUESTIONS  

Your business is growing rapidly. However, you are losing customers again, this time due to logistics. Your sales department cannot keep up with production reports, making it hard to measure sales and creating inaccuracies in your accounting and distribution. Management cannot accurately gauge sales because when they finally do receive the report, it is from the prior month. 

Use the following outline to create a business case for an ERP system. For each section use the heading provided and address each bulleted point.

Executive Summary

· Write a description of the overall business case document summarizing key points.

Overview and Introduction

· Include a brief business background, the current business situation, a clear statement of the business problem or opportunity, and a recommended solution at a high level.

Assumptions and Rationale

· Include issues driving the proposal (e.g., operational, human resources, environmental, competitive, industry or market trends, financial).

Project Summary

· Write high-level and detailed descriptions of the project covering scope, objectives, contacts, resource plan, key metrics, implementation plan, and key success factors.

Financial Discussion and Analysis

· Write an overall summary followed by projected costs/revenues/benefits, financial metrics, financial model, cash flow statement, underlying assumptions, and total cost of ownership (TCO) analysis.

Benefits and Business Impacts

· Write a summary of business impacts followed by details on nonfinancial matters such as new business, transformation, innovations, competitive responses, organizational, supply chain, and human resource impacts.

Schedule and Milestones

· Include the entire schedule for the project with milestones and expected metrics at each stage; if appropriate, you can include a marketing plan and schedule.

Risk and Contingency Analysis

· Provide an analysis of risks and ways to manage those risks, sensitivity analysis of scenarios, interdependencies, and the impact they will have on potential outcomes.

Conclusion and Recommendation

· Provide your primary recommendation and conclusions.

Appendices (Optional)

· Include an backup material not directly provided in the body of the document, such as detailed financial investment analysis, marketing materials, and competitors’ literature.

Topic Name: “Congestion Avoidance and Control”

Need 1 page of detailed review on above mentioned topic. It should have 

1) Introduction

2) Theoretical and Empirical Details

3) Merits 

4) De merits

5) Assumptions

6) Conclusion etc…

NOTE: All Headings font size should be 10( times new roman)

Review Guidelines:

1. One page, single space, margin 1 inch (top, bottom, left, right), font (times new roman, size 9)

 Fire simulation can be modelled in software and is an important area of research in fire safetyi , fire drill managementii, fire investigationiii, and with applications in many computer game scenariosiv . One way to look at the world in software is to study a process as a group of smaller pieces (or cells or sites) that are somehow related. For example the world can be viewed as a rectangular grid of cells. Rules specify how a cell changes state over time based on the states of the cells around it. Each piece corresponds to an area (or volume) in the world and each piece can be associated with one of several possible states at any given time. A computer simulation involving such a system is called a cellular automaton. This assignment requires you to design and implement a program that models the spread of fire in a 2D forest environment. 

Abstract,directiions,1to8

Professor Higgins has asked you to design the logic that will be used to calculate final class averages and grades for his students. His grading algorithm is as follows.



Exam average: 60%



Quiz average: 20%



Lab average: 20%Professor Higgins has 20 students in his class. For each student, Professor Higgins will enter the student’s name and store into a “names” array, then input the value for each of the averages (exam, quiz, and lab). Using the weighting above, the program will calculate the final student class average and store each student’s final average into an array. The program will then determine the letter grade for each student using the following criteria.



90–100: A



80–89: B



70–79 C



60–69 D



Less than 59 F



When the student’s final grade is determined, the final grade will be stored in a third “grade” array.



After all data have been input and calculations done, display the final output using the 3 arrays as a Grade Report with headings of NAME, AVERAGE, and GRADE.



· Display the name, final average, and grade for all the students.



· Calculate and display the total class average (total of all individual student averages / number in class).Write a program using C#, prompt the user for the appropriate input, and display the output as described above. You may assume all data are valid. Provide a program introduction message that tells the user how to use the program

Network Administration
(All essay answers need to be double-spaced)

1. Create a table the shows six of the common TCP/IP protocols installed on Windows Server 2012/R

2. Protocol Name OSI Layer Function2. In a short essay, describe the format of an IPv4 address, an octet, and a subnet mask. Explain how the network address for a given IP address is determined and why IPv4 communication relies heavily on broadcast packets. Convert 192.168.0.0 to binary.

3. In a short essay, explain Classless Interdomain Routing (CIDR). What subnet mask does 192.168.2.0/27 have in CIDR notation?

4. In a short essay, define the format of an IPv6 address, the use of hexadecimal numbering, the format for zero values, and interface ID. Describe the IPv6 address types.

5. In a short essay, outline the two methods of IPv6 autoconfiguration.

6. In a ½ page essay (double-spaced), explain the various transition methods used for IPv4 and IPv6 to coexist.

CS 315 Homework 

1. For each of the following operations determine the result in $t0. The answer should either be expressed in hexdecimal or binary in 4 bit groups (nibbles). Given the following:

$t1 0x3FFF 7FFC

$t2 0XFFFF 0000

$t3 0x0000 FFFF

a.  and $t0, $t1,$t2

b.or $t0, $t1, $t3

c. nor $t0, $t1, $t2

d. xor $t0, $t1, $t3

 Hi! Can everyone help me solve this java problem? 

Write code that prints: Ready! firstNumber … 2 1 Blastoff!
Your code should contain a for loop. Print a newline after each number and after each line of text.   

Ex: If the input is:  

3  

The output is:  

Ready! 

3

2

1

Blastoff!


This is my code: 

import java.util.Scanner;

public class ForLoops {

   public static void main (String [] args) {

      int firstNumber;

      int i;

      Scanner input = new Scanner(System.in);

      firstNumber = input.nextInt();

      System.out.println("Ready!n"+firstNumber);

      for (i=firstNumber;i>1; i--){

           firstNumber--;

           System.out.println(""+firstNumber);

       }

       System.out.println("Blastoff!");

   }

}

When running the program, my output only matches the two outputs as shown in the attached picture. The rest do not match. How can my code be the same as the expected output as in the attached image?

Thanks, everyone!