Monthly Archives: June 2023

Exp22_Excel_Ch07_ML2_Employees

Project Description:

You work for a clothing distributor that has locations in Iowa, Minnesota, and Wisconsin. You will use date and logical functions to complete the main employee data set, use database functions to calculate key summary statistics and create a map, and use financial functions to complete a loan amortization table.

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

Column D contains the city each   employee works in. You want to display the state.
 

  Make sure the Data worksheet is active. In cell G7, insert the SWITCH   function to evaluate the city stored in cell D7. In this sequence, switch Des Moines for Iowa, St. Paul for Minnesota, and Milwaukee for Wisconsin. Use mixed   references for the state names in the range A2:A4. Copy the function from   cell G7 to the range G8:G31.

Column C contains the actual   hire dates for the employees. You want to extract only the year in column H.
 

  In cell H7, insert the YEAR function to extract the year from the Hire Date   in cell C7. Copy the function from cell H7 to the range H8:H31.

Next, you want to determine how   many years each employee has worked for the company.
 

  In cell I7, insert the YEARFRAC function to calculate the years between the   first employee’s Hire Date and the last day of the year contained in cell C2.   Use a mixed reference appropriately. Copy the function from cell I7 to the   range I8:I31.

You want to determine what day   of the week each employee was hired.
 

  In cell J7, insert the WEEKDAY function to display the day of the week for   the first employee’s Hire Date. Copy the function from cell J7 to the range   J8:J31.

The values returned in the range J7:J31 are whole numbers. You want   to display the result as the actual weekday names.
 

  Format the range J7:J31 as a custom number format dddd.

Employees are scheduled for a   six-month review based on their hiring month.
 

  In cell K7, insert the EDATE function to identify the month that is six   months from the first employee’s Hire Date. Copy the function to the range   K8:K31.

Your next task is to calculate the bonus for the first employee. If   the employee’s Performance Score is greater than or equal to 4.5, the bonus   is $3,000. If the Performance Score is 4.0-4.9, the bonus is $2,000. If the   Performance Score is 3.0-3.9, the bonus is $1,000. No bonus is given if the   Performance Score is below 3.0.
 

  In cell L7, insert the IFS function to enter the bonus based on the   Performance Score for the first employee. Use the respective scores stored in   cells E2, E3, and E4 for the individual logical tests. Use the respective   bonuses in cells F2, F3, and F4 to return the correct bonus. If none of the   logical tests are true, the result should be 0. Use mixed references appropriately. Copy the function to the range   L8:L31.

Management decided to give an   equity salary adjustment for Representatives who earn less than $80,000. The   salary adjustment is 2% of the current salary if the conditions are met.
 

  In cell M7, nest an AND function within an IF function. If the job title is Representative   and the salary   is less than the minimum representative salary (cell C3), multiply the Salary   by 2% (cell C4). If both conditions are not met, return zero. Use a mixed   reference to cells C3 and C4. Copy the function from cell M7 to the range   M8:M31.

The last column of the Data   worksheet is to to calculate the future value of a retirement investment   based on the first employee’s salary, 5% APR, four years, at 3%.
 

  In cell N7, insert the FV function. Use the variables in the range N2:N4 in   the FV arguments. The rate is the APR divided by 12 months in a year, and the   number of payment periods is the number of years multiplied by 12 months in a   year. Use mixed cell references appropriately. Make sure the functions   returns a positive result. Copy the function to the range N8:N31.

You want to display the number   of employees who earned each bonus level in the range G2:G4.
 

  In cell G2, insert the COUNTIF function that counts the number of $3,000   bonuses in the range L7:L31 using mixed references. Use the bonus in cell F2   as the criteria. Copy the function to the range G3:G4 and preserve the border   in cell G4.

Next, you want to calculate the   total bonuses.
 

  In cell H2, insert the SUMIF function that calculates the total of the $3,000   bonuses in the range L7:L31 using mixed references. Use the bonus in cell F2   as the criteria. Copy the function to the range H3:H4 and preserve the border   in cell H4.

Next, you want to calculate the   average salary for representatives by city.
 

  In cell J2, insert the AVERAGEIFS function to calculate the average salary   (range E7:E31) for employees with the job title Representative who work in St. Paul. Use cell   I2 as the criteria for the City. Copy the function to the range J3:J4 and   preserve the border in cell J4.

Now you want to calculate the highest salary for representatives in   each city.
 

  In cell K2, insert the MAXIFS function to display the highest salary for   employees with the job title Representative who work in St. Paul. Use cell I2 as the criteria for the City. Copy   the function to the range K3:K4 and preserve the border in cell K4.

Now you want to calculate the   lowest salary for representatives in each city.
 

  In cell L2, insert the MINIFS function to display the highest salary for   employees with the job title Representative who work in St. Paul. Use cell I2 as the criteria   for the City. Copy the function to the range L3:L4 and preserve the border in   cell L4.

The Map worksheet contains the   average representative salary by state. You will create a map from this data.
 

  Select the range B1:C4 and insert a filled map. Cut the map chart and paste   it in cell D1. Set a 2.75″ height and 4″ width.

Now you will complete the map by   adding a title and formatting the data series.
 

  Change the map title to Average Rep Salary. Display the Format Data Series task pane, select   the option to display only regions with data, and show all labels. Close the   task pane.

The Days Hours worksheet   contains a list of starting and stopping days that employees took vacations.   You want to count the number of actual work days on vacation.
 

  In cell D4, insert the NETWORKDAYS function to calculate the number of   working days between the vacation start and end dates. Use 7/4/2024 (cell C1)   as a holiday. Copy the function to the range D5:D12.

The next section of the Days   Hours worksheet contains the start and stop times that employees worked on a   special project. You want to calculate the number of hours worked.
 

  In cell H4, insert the HOUR function to calculate hours difference between   the end and start times. Copy the function to the range H5:H12.

To complete the worksheet, you   will calculate the difference in minutes between the start and stop times on   the special project.
 

  In cell I4, insert the MINUTE function to calculate minutes difference   between the end and start times. Copy the function to the range I5:I12.

Save and close Exp22_Excel_Ch07_ML2_Employees.xlsx.   Exit Excel. Submit the file as directed.

Write a C program that reads a numbers from the keyboard and calculates its square if the number is *****: use an infinite loop for reading and calculating, break out of the loop if the number is *****

1- Assume that you have been hired by a small to medium organization to help them prepare a contingency planning document. You may choose any organization (or practice). Some examples are: clinic, veterinary practice, credit union, tax preparation office, event management company, accounting firm, real state agency, etc… (Please DO NOT use an ISP as your organization)

2- To help with the preparation of the business contingency document, you conduct a Business Impact Analysis (BIA), following the BIA three stages:

1. Stage 1: Assessing mission critical /business processes and recovery criticality (limit the number of business processes to 5 only).

2. Out of the list in the previous step, choose 2 business missions that are related to information technology and information security.

3. Stage 2: Identifying resource requirements per mission process.

4. Stage 3: Identifying recovery priorities per mission process.

3- Use NIST SP800-34-Rev1-BIA-Template to prepare the BIA . The template file is provided with this assignment, and available at https://csrc.nist.gov/CSRC/media/Publications/sp/800-34/rev-1/final/documents/sp800-34-rev1_bia_template.docx ).

4- Your completed BIA should not exceed 6 pages.

Xcode app that is due in 40 hrs from now!!

 EX16_AC_CH07_GRADER_CAP_HW – Human Resources

Project Description:

The Human Resources Department asked you to assist them in updating the database they are using. The department requires a form that can be used to find information but not change information. In addition, you will enhance an existing form and generate a report showing which employees report to each supervisor 

Start   Access. Open the file named exploring_a07_grader_h1_Prices.accdb.

Select   the Employees table and use the Form tool to create a new form. Change the   title to View Employees.   Delete the Orders subform.

Change   the Allow Edits, Allow Additions, and Allow Deletions settings to No. View   the form and data in Form view. Save the form as View Employees.

Create a new table in table design   view. Name the first field Country   and ensure the field is set as the primary key. Switch to Datasheet view,   saving the table as Countries.   Enter two records, UK   and USA (in that order). Close the table.

Open   the Update Employees form in Design view. Change the Country field to a Combo   Box. Set the Row Source to Countries and the Limit To List property to Yes.

Fix   the tab order so the Postal Code field comes immediately before the Country   field. Save and close the form.

Open   the View Employees form in Design view. Add a new label control in the   left-side of the form footer that displays the text Personnel information is considered private and printouts   should be shredded after use (do not include a period). Change the   font color to Black, Text 1 and bold the text. Save and close the form.

Create   a new report using the Report Wizard based on the Employees table. Select the   FirstName, LastName, HireDate, and HomePhone fields, in that order. Accept   all other default options.

Switch   to Layout view. Add grouping by the ReportsTo field. Switch to Design view.   Switch the option to with a footer section in the Group, Sort, and Total   pane. Use the pane to also display the count of the First Name field in the   Group Footer section.

Add   an Insert Page Break control at the bottom of the ReportsTo footer. Decrease   the size of the Home Phone field label, by dragging the right border of the   control so it lines up with the 6-inch mark on the horizontal ruler. Ensure   that the label width is set to as close to 1.08 inches as possible. 

Add   a new Text Box control to the right of the HomePhone text box. Use the   Tabular button in the Table group of the Arrange tab to place it correctly.   Change the label for the field to Years Employed.

Add   a formula in the text box to calculate the number of years (not days) since   the employee’s hire date, assuming the current date   is #12/31/2017#. Format the field as Standard with 1   decimal place. Save and close the report.

Close   the database, and submit the file as instructed.

 List and briefly describe the nine-step process in con-ducting a neural network project 

 Your response should be 250-300 words.(Chapter 6) 

 There must be at least one APA formatted reference (and APA in-text citation) to support the thoughts in the post.  Do not use direct quotes, rather rephrase the author’s words and continue to use in-text citations 

Text book :  

Title:  Business Intelligence and Analytics Authors:  Ramesh Sharda, Dursun Delen, Efraim Turban Edition:  11th ED

why process synchronization is critical in network process management

What is a network? Describe how the home network would be used by your family members. Name at least five components that would be connected to the network. What types of hardware, software, connectivity components, etc., would be required to fully implement the home network? Security issues will need to be considered. What are the risks to your network? What will you need to fully protect your home network?

 Exp19_PowerPoint_Ch01_ML2_Outdoor_Adventures 

 Exp19 PowerPoint Ch01 ML2 Outdoor Adventures 

 PowerPoint Chapter 1 Mid-Level 2 – Outdoor Adventures 

Project Description:

You have been asked to put together a promotional presentation on the company you work for, Peddle and Paddle. The company has a presentation it has used in the past that you have been asked to modify.

Start PowerPoint. Download and   open the file named Exp19_PPT_Ch01_ML2_OutdoorAdventures.pptx.   Grader has automatically added your last name to the beginning of the   filename. Save the file to the location you are saving your files.

Apply the Wood Type theme.

Type Peddle and Paddle in the title placeholder. Type The Ultimate   Outdoor Adventure   in the subtitle placeholder.

Use the Reuse Slides feature to   add all slides from the downloaded Adventure.pptx   presentation. Deselect the Use Source Formatting option when importing the   slides.

Delete Slide 2. Move Slide 6 so   that it becomes Slide 4.

On Slide 5 insert the Peddle.jpg image. Change the height of   the image to 5.8″. 

On Slide 5 set the horizontal   position of the image to 3.4″ and the vertical position to 1.25″. 

Apply the Reflected   Perspective Right picture style to the image on Slide 5.

On Slide 6 insert the Paddle.jpg image. Change the height of   the image to 5.8″. 

On Slide 6, set the horizontal   position of the image to 3.4″ and the vertical position to 1.25″.

Apply the Reflected Perspective   Right picture style to the image on Slide 6.

On Slide 4, convert the list to   a Basic Block List SmartArt graphic. Apply the Intense Effect SmartArt style.

Select the text Book Your Adventure Soon! on the last   slide. Format the text as WordArt Fill:
  Black, Text color 1; Shadow.

On Slide 2 change the font size   of the text in the placeholder to 80 pt.

Add slide numbers to all slides   with the exception of the title slide.

Check the presentation for   spelling errors. Make corrections as needed on the slides. Hint: Ignore the   spelling error for Funyak in the notes.

Save and close Exp19_PPT_Ch01_ML2_OutdoorAdventures.pptx.   Submit the file as directed.

Attached Files:

•  Personal data breaches and securing IoT devices.docx Personal data breaches and securing IoT devices.docx – Alternative Formats (55.866 KB)
•  What are the Challenges of IoT Security.docx What are the Challenges of IoT Security.docx – Alternative Formats (17.965 KB)
•  IoT References.docx IoT References.docx – Alternative Formats (13.394 KB)
•  Final Research Project – IoT.docx Final Research Project – IoT.docx – Alternative Formats (51.028 KB)

Securing IoT Devices: What are the Challenges?Security practitioners suggest that key IoT security steps include:1) Make people aware that there is a threat to security;2) Design a technical solution to reduce security vulnerabilities;3) Align the legal and regulatory frameworks; and4) Develop a workforce with the skills to handle IoT security.Final Assignment – Project Plan (Deliverables):Address each of the FOUR IoT security steps listed above in terms of IoT devices.Explain in detail, in a step-by-step guide, how to make people more aware of the problems associated with the use of IoT devices.