3rd Excel Exam SU1 2021

 

#3rdExcelExamSU12021

After graduating from college, you and  three of your peers founded the software company TechStore Unlimited  (TSU). TSU provides an online market place that fosters business to  business (B2B), business to consumer (B2C), and consumer to consumer  sales (C2C). As one of the company’s principal owners, you have decided  to compile a report that details all aspects of the business, including:  employee payroll, facility management, sales data, and product  inventory. To complete the task you will duplicate existing formatting,  import data from an Access database, utilize various conditional logic  functions, complete an amortization table, visualize data with  PivotTables and Power Maps, connect and transform several external data  sources, and lastly you will inspect the workbook for issues.

Start   Excel. Open 3rd Excel Exam SU1 2021.xlsx. Grader has automatically added   your last name to the beginning of the filename.

Create a Data Validation list in   cell J7 based on the employee IDs located in the range A6:A25. Add the Input   Message Select Employee ID and use the Stop Style Error Alert.
   Hint: Data Validation is located on the Data tab in the Data Tools group.
 

In cell K7, enter an INDEX   functions with two nested MATCH  functions. The first MATCH function will look up the row number of the  employee   number in cell J7 in the range A6:A25. The second MATCH  function will look up the column number of the value   in cell K6 in the  range B5:H5. Note   K6 contains a validation list that can be used to  select various lookup   categories.
 

  Hint: The arguments of the INDEX are array (B6:H25), Row  Number,Column   Number. The purpose of the two MATCH   functions is to  look up the ROW number and COLUMN number. I suggest you do the first  MATCH function   to ensure it works and then nest it inside of the INDEX  function. Then nest the second MATCH function in the   INDEX function.  To test the INDEX   function, use the Data Validation list in cell J7 to  select Employee_ID 31461 and select Salary in cell K6. Did it   look up the correct salary for the specified employee number?
 

Click cell K11 and type FT. Click cell A28 and type Full Time   Employees.

Use the Format Painter to apply   the formatting from the cell A3 to the range A28:B28.
 

  Hint: The Format Painter is located on the
   Home tab in the Clipboard group.
 

Use Advanced Filtering to   restrict the data to only display FT  employees based on the criteria in the   range K10:K11. Place the  results in cell A29.
 

  Hint: Advanced Filtering is located on the Data tab in the Sort & Filter   group.
 

Enter a database function (DCOUNTA)   in cell K18 to determine the  total number of FT employees. To complete the   function, use the range  A5:H25 as the database argument, cell E5 for the   field, and the range  K10:K11 for the criteria.
 

  Hint: To access DATABASE functions, click insert function, and select   Database from the function category menu.
 

Enter a database function in   cell K19 (DSUM) to determine the total  value of FT employee salaries. To   complete the function, use the  range A5:H25 as the database argument, cell H5   for the field, and the  range K10:K11 for the criteria.
 

  Hint: To access DATABASE functions, click insert function, and select   Database from the function category menu.
 

Enter a database function   (DAVERAGE) in cell K20 to determine the  average FT employee salary. To   complete the function, use the range  A5:H25 as the database argument, cell H5   for the field, and the range  K10:K11 for the criteria.
 

  Hint: To access DATABASE functions, click insert function, and select   Database from the function category menu.
 

Enter a database function in   cell K21(DMAX) to determine the  highest FT salary. To complete the function,   use the range A5:H25 as  the database argument, cell H5 for the field, and the   range K10:K11  for the criteria.
 

  Hint: To access DATABASE functions, click insert function, and select   Database from the function category menu.
 

Format the range K19:K21 with   Currency Number Format.
 

  Hint: Currency Number Format is located on the
   Home tab in the Number Group.
 

Use PowerQuery to connect and   open the Orders table in the eApp_Cap_Orders.accdb   database. Use the Query editor to format column A with Date number format and   load the table. Rename the worksheet Orders.
   Hint: Data can be imported using Get & Transform data tools  located on   the Data tab in the Get & Transform data group.
 

Adapt the previous step to   connect and load the Warehouse table.
 

  Hint: Data can be imported using Get & Transform data tools  located on   the Data tab in the Get & Transform data group.
 

Connect to, but don’t load the   Inventory table from the eApp_Cap_Orders.accdb   database. 

Create the following   relationships.
 

  Relationship 1
   Table Name
   Inventory
 

  Column (Foreign)
   Warehouse
 

  Table
   Warehouse
 

  Column (Primary)
   Warehouse
 

  Relationship 2
 

  Table
   Orders
 

  Column (Foreign)
 

  Item_Number
   Table
   Inventory
 

  Column (Primary)
 

  Item_Number
 

  Hint: Relationships are located on the Data tab in the Data Tools group.
 

Use PowerPivot to create a blank   PivotTable on a new worksheet. Add the following fields to the PivotTable.
   Rows
   Warehouse: Location
   Warehouse: Warehouse
   Inventory:
   Item_Number
   Values
   Inventory:
   Current_InventoryInventory:
   Total_Value

Insert a Slicer based on   Warehouse. Place the upper left corner of the Slicer inside the borders of   cell F3.
 

  Hint: Slicers are located on the Insert tab in the Filters group.
 

Create a 3D PowerMap that   displays the location of all warehouses based on the City geographic type.   Rename the worksheet Inventory.
   Hint: 3D Maps is located on the Insert tab in the Tours group.
 

Save and close the 3rd Excel   Exam SU1 2021. Go to the Test   Presentation Window. Upload the exam   and submit it for grading 

•  

  

The accountant at Sonheim Manufacturing Company wants an application that calculates an asset’s annual depreciation. The accountant will enter the asset’s cost, useful life (in years), and salvage value (which is the value of the asset at the end of its useful life). Use a list box to display the useful life, which should range from 3 through 20 years. The application should use the double-declining balance method to calculate the annual depreciation amounts; it then should display the amounts in the interface. You can use the Financial. DDB method to calculate the depreciation. The method’s syntax is Financial.DDB(cost, salvage,life,period). In the syntax, the cost salvage, and life arguments are the asset’s cost, salvage value, and useful life, respectively. The period argument is the period for which you want the depreciation amount calculated. The method returns the depreciation amount as a Double number. Figure 6-57 shows a sample depreciation schedule for an asset with a cost of $1000, a useful life of 4 years, and a salvage value of $100. Create a Visual Basic Windows application. Use the following names for the solution, project, and form file, respectively: Sonheim Solution, Sonheim Project, and MainForm.vb. Save the application in the VB2010Chap06 folder. Create the interface shown in Figure 6-57. Set the txtSchedule control’s Multiline and ReadOnly properties to true, and set its ScrollBars property to Vertical. Code the application. Save the solution and then start and test the application. Close the Code Editor window and then close the solution

 Create a lessons learned document. 
For this assignment look back at what you have learned throughout this course. What worked well? What would you have done differently? There are a number of examples you can Google. This are the topic we did for this semester.

 Build & execute a basic IT project plan
• Apply the Project Management Life Cycle and create required project documents
• Know critical success factors for IT projects and understand how to apply and manage them
• Manage all phases of an IT project, and evaluate its level of successful execution
• Know and apply the “hard” & “soft” skills as a project manager to lead IT projects  

Network Security

 

The Physical Model was based on the idea that people did not really understand the work involved in the digital forensics world or how to treat it in court. With all the crime dramas on television, the average juror may now think that everything can be resolved in 60 minutes and is based on perfect DNA physical evidence and the digital “smoking gun” always found on the criminal’s computer.  

How would you tailor your approach and reporting to address the fact that the jury may now think that without 100% conclusive evidence, the person should not be found guilty?  Please avoid discussions about the presumption of innocence or a position that circumstantial evidence is never sufficient to find someone guilty.  This discussion is for you to consider how you would convince someone that your circumstantial evidence is sufficient and how to counter the idea that perfect evidence is always available.

Your word count should be between 250-500 words.

Please see attached Discussion word document for questions.

You should have two websites for  questions 1,2,3  and 4 

Website 1 : 

Your favorite web site  overseas and preferably NOT English Language. And its short description. The URL must have the country extension.

Example of websites with county extension

www.——–.ac.in             : Website in India

Do your web search and the find the website that you want to use.   And provide the screenshot the first page of your website.

Website 2: 

Your favorite web site in the USA preferably English Language (it can be sports team, car manufacture, fashion, music band, restaurant or your favorite person’s website or something similar).  And provide the screenshot the fist page of your website.

Have these two websites for the following questions. 

QUESTION 1: 

Using  Whois domain lookup to see the ownership and tenure of a domain name.

https://www.whois.com/whois

And provide the report of each website by providing  for each website.

• Registrant Contact Name and City:
• Registered On and Expires On:

QUESTION 2: 

Open the MS command prompt on your computer and do     ping to your two websites one by one. And, provide the screenshots. Answer the following questions for each website.

For example C:UsersmyComputer > ping  www.Your Favorite Website.com

• How many packets were sent?
• How many packets were received?
• Approximate time of round trip
• TTL ( allocated time to live for the package ) for each website

( get the screenshot of the PING report for both  and paste them on this MS word)

QUESTION 3:  

Windows-based system, use the command prompt and execute tracert and the URL of the two websites that you have declared. tracert will be displaying the route and measuring transit delays of packets across Internet.

For example C:UsersmyComputer > tracert www.Your Favorite Website.com

Compare both results by identifying all intermediate hops between the nodes for each URL.

Write the number stops (hops) achieved for each website. Which one has more hops ? Why?

QUESTION 4: 

Open the command prompt and for each web site do nslookup (name space lookup)

nslookup allows you to query the D N S database from any computer on a network.

1. a) Do nslookup form your computer command line to find the IP address of the web sever of the two websites

Example C:UsersmyComputer > nslookup  www.Your Favorite Website.com. And,

Use https://www.ipvoid.com/find-website-ip/  to Find the IP address of  the web sever of the two websites  Compare the  Ip addresses you have gathered form nslookup and ipvoid.com  for the same website.

1. b) Then use https://www.iplocation.net/ to see location  of a website.  And provide short report on; country, region and city of each websites’ server location (for each website)

QUESTION 5:  

Use the undersea fiber optic cable map (https://www.submarinecablemap.com/) and answer the following questions.

1. Find the Caucasus Cable System on the undersea fiber optic cable map. And visit the owner of the cable and see what kind of products they offer.
2. Select a fiber line between USA and Japan and provide the following

Ready for service date (RFS):

Cable Length:

Owners:

URL:

Landing Points ( the main ones )

And copy/past the screenshot of cable map here. Us can use Snipping tool.

Contact user for instructions

Assigned Readings:Chapter 6. Project Team Building, Conflict, and NegotiationInitial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

1. “Trust can actually encourage disagreement and conflict among team members.”  Explain why this could be the case.
2. Identify the five major methods for resolving conflict.  Give an example of how each might be applied in a hypothetical project team conflict episode.

[Your post must be substantive and demonstrate insight gained from the course material. Postings must be in the student’s own words – do not provide quotes!]  [Your initial post should be at least 450+ words and in APA format (including Times New Roman with font size 12 and double spaced). Post the actual body of your paper in the discussion thread then attach a Word version of the paper for APA review]

Text

Title: Project Management 

ISBN: 9780134730332 

Authors: Pinto 

Publisher: Pearson 

Edition: 5TH 19

I need 2500-2700 words or 12 -14 pages by attached requirement in PDF 

 Research Report / Individual Project (100 points) Write a scholarly research report on a topic related to Advanced Database Systems (see  Appropriate Topics). Please see Important Notes and Document Details for detailed  specifications. Appropriate Topics: The Research Report, select one of the following research areas: 1. A Complete Comparative between IBM DB2 and CA IDMS 2. A Complete Comparative between IBM DB2 and IBM DB2 3. A Complete Comparative between Oracle 12c and CA IDMS 4. A Complete Comparative between Oracle 12c and IBM DB2 5. A Comparative Analysis of Triggers used in Oracle 12c versus Triggers used IBM DB2 6. A Comparative Analysis of Stored Procedures used in Oracle 12c versus Stored Procedures used  in IBM DB2 7. A Comparative Analysis of Transaction Processing used in Oracle 12c versus Transaction  Processing used IBM DB2 8. A study of DB Transaction Processing / Coordination used in a Cloud environment 9. Common and dissimilar vulnerabilities found in both Oracle 12c and IDMS 10. Managing Transaction Processing using MongoDB 11. The Internet of Things (sensor & actuator data) used in a distributed DB cloud environment Important Student Notes: • Each student submission should be checked for plagiarism. Students should be warned that Turnitin has a very good historical memory and is capable of accessing reports from  both internal and external resources (i.e. Universities, Governments, etc.) including those  originally written in non-English written languages. Plagiarism will result in a grade of  zero (non-negotiable) for the assignment and may results in other university actions. The  department chairperson will be notified of the violation. Additional Campbellsville  University penalties may be applicable. Please see class syllabus for additional details. • Only one submission attempt is permitted – AS THE STUDENT TO BE SURE BEFORE  DEPRESSING ENTER.  • Acceptable file formats for submissions include Microsoft Word (doc, docx) or Adobe  Acrobat (PDF). No other formats are acceptable. • The research paper must be at least 2000-2500 words (approximately 10-12 Pages) supported by evidence (citations from peer-reviewed sources).  • A minimum of four (4) peer-reviewed journal citations are required.  • Formatting should be double-spaced, one-inch boarders, no extra space for headings, no CS631 Formal Research Report 2 extra white space, no more than two levels of heading, page numbers, front and back  matter). • Extra white space use to enhance page count will negatively affect student grade.  • Chapter 1 illustrates the document details of the research report and constitutes  Background/Introduction, Problem Statement(s), Goal(s), Research Question(s),  Relevance and Significance, Barriers and Issues related to topic chosen. Chapter 2 should  consist of student paraphrasing the cited research material (i.e. what happened in case  study x). Chapter 3 should be the reasoning for doing a basic compare/contrast or  advantages/disadvantage of what was stated in Chapter 2 (do not state because the  professor said so). Chapter 4 is a complete analysis, synthesis, and evaluation of what  was stated in chapter 2. In effect, chapter 3 is a statement of what will be done and  chapter 4 is what was done and what the findings were. Again, thus far the writing is  objective and must not contain student opinion. Chapter 5 states results, conclusion, and  future work recommendations. Here is where student opinion (or any researcher) can  state their respective opinion as the student has now “done the work” and are justified in  stating results. • Graduate student are expected to be proficient in the use of the English language. Errors  in grammar, spelling, or syntax will affect student grade. The Professor, will not provide  remedial help for writing problems. If the student is unable to write clearly and correctly,  the student should be urged to contact the program office for sources of remedial help. • IMPORTANT – please refer to the following url for additional help on writing skills  necessary at the graduate level (https://owl.purdue.edu/site_map.html).  • Final Submission – the final report is due no later than the due date assigned. A total of at  least 15 full pages is required (no extra whitespace, does not include appendices). (100  points). Only Microsoft Word or Adobe PDF submission is acceptable. • The research paper must only include materials derived solely from peer reviewed  journals or peer reviewed conference proceedings. Newspapers, websites (URLs),  magazines, technical journals, hearsay, personal opinions, and white papers are NOT  acceptable citations. Please access the CU Library at  http://campbellsville.libguides.com/?b=g&d=a for appropriate materials.  • APA formatted citations are required for the final submission. IMPORTANT – please  refer to the following url for help with APA:  https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_style_introduction.html.  Please reach out to our librarians for additional citation management and APA help. • All images, tables, figures are to be included in the appendices and IS NOT included in  the 10-15 page requirement. This means appendices are not included in the 10-15 page  requirement. • Long quotations (i.e. paragraphs) are NOT permitted. Only one quoted short  sentence (less than 14 words) is permitted per page. • Footnotes are NOT permitted.CS631 Formal Research Report 3 Document Details This area provides additional details about the content of each of the needed Research  Report Chapters (5). For those instructing in Hybrid format, the instructor may want to consider  having the instantiated teams work on: 1) an outline of the final research report and 2) a  preliminary research report that includes Chapters 1 and 2. For those instructing in Online or  F2F formats the instructor may want to consider using the Hybrid format (teams) or single  student submission format. The final submission should include DETAILS of each of  following:  1) Chapter 1 – Introduction 2) Chapter 2 – Literature Review 3) Chapter 3 – Methodology Specifics (comparative analysis) 4) Chapter 4 – Findings and Results 5) Chapter 5 – Conclusion and Future Recommendations 6) References – APA 7) Appendices Chapter 1 Introduction 1 Background/Introduction In this section, present enough information about the proposed work such that the reader  understands the general context or setting. It is also helpful to include a summary of how the  rest of this document is organized.  1.1 Problem Statement  In this section, present a concise statement of a research-worthy problem addressed (i.e., why  the work should be undertaken – don’t say required for the class). Follow the statement of the  problem with a well-supported discussion of its scope and nature. The discussion of the  problem should include: what the problem is, why it is a problem, how the problem evolved or  developed, and the issues and events leading to the problem.  1.2 Goal  Next, include a concise definition of the goal of the work (i.e., what the work will accomplish).  Aim to define a goal that is measurable. 1.3 Research Questions CS631 Formal Research Report 4 Research questions are developed to help guide the authors through the literature for a given  problem area. What were the open-ended questions asked and why did the student find (or not  find) them adequate.  1.4 Relevance and Significance  The student should consider the following questions as they read through an article stating how  the author(s) supported, or left unsupported the evidence, relevance, and significance of their  research literature:  Why is there a problem? What groups or individuals are affected?  How far-ranging is the problem and how great is its impact? What’s the benefit of solving the  problem?  What has been tried without success to correct the situation? Why weren’t those attempts  successful? What are the consequences of not solving the problem?  How does the goal of the study address the research problem and how will the proposed study  offer promise as a resolution to the problem?  How will the research add to the knowledge base?  What is the potential for generalization of the results?  What is the potential for original work?  1.5 Barriers and Issues  In these paragraphs, identify how the problem is inherently difficult to solve. How did the  solution the author(s) propose address the difficulties?  2 Chapter 2 Literature Review In this section, it is important to clearly identify the major areas on which the student will need  to focus the student research in order to build a solid foundation for the study in the existing  body of knowledge. The literature review is the presentation of quality literature in a particular  field that serves as the foundation and justification for the research problem, research questions  or hypothesis, and methodology. The student will develop a more comprehensive review of the  literature as part of the research. CS631 Formal Research Report 5 3 Chapter 3 Approach/Methodology This chapter includes a summary of how the student is going to proceed with the evaluation of  the problem statement and associated research question(s). Given the short time of this course, a  compare / contrast or advantage / disadvantage analysis is recommended 4 Chapter 4: Findings, Analysis, Synthesis Include an objective description and analysis of the findings, results or outcomes of the  research. Limit the use of charts, tables, figures to those that are needed to support the narrative.  Most of these illustrations should be included as part of the Appendix. The following topics are intended to serve as a guide:  4.1 Data analysis  4.2 Findings & Discussion 4.3 Analysis 4.4 Synthesis 4.5Discussion  Chapter 5: Conclusions 5.1 Conclusions – Clearly state the conclusions of the study based on the analysis performed  and results achieved. Indicate by the evidence or logical development the extent to which the  specified objectives have been accomplished. If the research has been guided by hypotheses,  make a statement as to whether the data supported or rejected these hypotheses. Discuss  alternative explanations for the findings, if appropriate. Delineate strengths, weaknesses, and  limitations of the study. 5.2 Implications – Discuss the impact of the work on the field of study and its contributions to  knowledge and professional practice. Discuss implications for future research. 5.3 Recommendations – Present recommendations for future research or for changes in  research methods or theoretical concepts. As appropriate, present recommendations for changes  in academic practice, professional practice, or organizational procedures, practices, and  behavior.CS631 Formal Research Report 6 References Follow the most current version of APA to format the references. However, each reference  should be single-spaced with a double space in between each entry.  Formatting Details Margins  The left-hand margin must be 1inches (4 cm.). Margins at the right, top, and bottom of the page  should be 1.0 inch. (See exception for chapter title pages below.) The Research Report text may  be left-aligned (leaving a ragged right edge) or may be both left- and right-aligned (justified).  Line Spacing  Double-spacing is required for most of the text in documents submitted during the Research  Report process.  Paragraph Spacing  The text of the document is double-spaced. There should be no extra spaces between paragraphs  in sections; however, indent the first line of each paragraphs five spaces.  Page Numbering  All pages should have page numbers in Arabic numerals in the upper right-hand corner.  Type Style The body text, the student should use 12-point Times New Roman. Text for the cover page may  be larger but should not exceed 14-point size. Text for the chapter title text should be 14-point  size. Be consistent in the use of typefaces throughout the document. Do not use a compressed  typeface or any settings on the word processor that would decrease the spacing between letters  or words. Sans serif typefaces such as Helvetica or Arial may be used for relatively short blocks  of text such as chapter headings and captions but should be avoided in long passages of text as  they impede readability.  Title Page CS631 Formal Research Report 7 Every document that is submitted must have a title page. The title page includes the exact title  of the research report, date of submission, the team name, and the name of each team member.  Chapter Title Heading, Subheadings, and Sub-Subheadings  It is required that submitted Research Report use no more than three levels of headings in the  body text. All headings should have only the first letter of each word capitalized except that  non-major words shorter than four letters have no capital letters.  Instructions for heading levels follow:  Level 1: Chapter Title Heading  This heading starts two inches from the top of the page, is centered on the page, and is set in 14- point type. The first line contains the chapter number (e.g., Chapter 4). The second line is blank.  The third line displays the chapter title, is centered on the page, and is set in 14-point type.  Level 2: Subheading  Start the subheading at the left margin of the page, four spaces (i.e., two returns when the  document is set for double-spacing) down from the title, set in bold 12-point type. Double-space  (one return) to the subheading body text. Indent the first line of the body text five spaces.  Level 3: Sub-Subheading  Start the sub–subheading at the left margin of the page, double-spaced (i.e., one return when the  document is set up for double-spacing) from the subheading, set in 12-point italics. Double space (one return) to the sub-subheading body text. Indent the first line of the body text five  spaces.