Submit a word document with a screenshot showing successful installation of Visual Logic.

/in /by

Week 1 Lab Assignment 1: Install Visual Logic

Click the link above to submit your assignment.

Complete lab 1 using Visual Logic in which you:

  1. Submit a word document with a screenshot showing successful installation of Visual Logic.
  2. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:
    • A summary of the technical experiences that you used in completing this lab.
    • The commands that were of greatest benefit to you.
    • Your general comments on the overall lab experience.

 

 

Week 2 Lab Assignment 2 Submission

Click the link above to submit your assignment.

Complete labs 2-5 using Visual Logic in which you:

  1. Submit the .vls file you create in Visual Logic as well as a screenshot of the output. For full credit, the program must function correctly, produce the correct answer, and be logically succinct.
  2. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:
    1. A summary of the technical experiences that you used in completing this lab.
    2. The commands that were of greatest benefit to you.
    3. Your general comments on the overall lab experience.

 

 

Week 4 Lab Assignment 3 Submission

Click the link above to submit your assignment.

Complete labs 2-5 using Visual Logic in which you:

  1. Submit the .vls file you create in Visual Logic as well as a screenshot of the output. For full credit, the program must function correctly, produce the correct answer, and be logically succinct.
  2. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:
    1. A summary of the technical experiences that you used in completing this lab.
    2. The commands that were of greatest benefit to you.
    3. Your general comments on the overall lab experience.

 

Week 7 Lab Assignment 4 Submission

Click the link above to submit your assignment.

Complete labs 2-5 using Visual Logic in which you:

  1. Submit the .vls file you create in Visual Logic as well as a screenshot of the output. For full credit, the program must function correctly, produce the correct answer, and be logically succinct.
  2. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:
    1. A summary of the technical experiences that you used in completing this lab.
    2. The commands that were of greatest benefit to you.
    3. Your general comments on the overall lab experience.

 

 

 

Week 8 Lab Assignment 5 Submission

Click the link above to submit your assignment.

 

Complete labs 2-5 using Visual Logic in which you:

  1. Submit the .vls file you create in Visual Logic as well as a screenshot of the output. For full credit, the program must function correctly, produce the correct answer, and be logically succinct.
  2. Write a short answer (four to five [4-5] sentences) in the comment text box located with the assignment submission link to the following:
    1. A summary of the technical experiences that you used in completing this lab.
    2. The commands that were of greatest benefit to you.
    3. Your general comments on the overall lab experience.

 

 

 

Lab Assignment Breakdown

Week Due

Graded Lab Exercises

Points

1

Lab 1: Visual Logic Installation

10

2

Lab 2: Exercise 6 on page 35

10

4

Lab 3: Exercise 5 (Part A) on page 172

20

7

Lab 4: Chapter 9 Exercise 4 on page 421

 

Lab 5: Exercise 4 on page 468

 

 

A coworker developed a spreadsheet listing houses listed and sold during the past several months. She included addresses, location, list price, selling price, listing date, and date sold. You need to convert the data to a table.

/in /by

 

Project Description:

A coworker developed a spreadsheet listing houses listed and sold during the past several months. She included addresses, location, list price, selling price, listing date, and date sold. You need to convert the data to a table. You will manage the large worksheet, prepare the worksheet for printing, sort and filter the table, include calculations, and format the table.

 

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

StepInstructionsPoints Possible
1Start Excel. Open the downloaded file named exploring_e04_grader_h1.xlsx.0
2In the Sales Data worksheet, freeze the top row.

Hint: On the VIEW tab, in the Window group, click Freeze Panes and then click Freeze Top Row.

5
3In the Sales Data worksheet, convert the data to a table and apply Table Style Medium 17.

Hint: To convert the data, on the INSERT tab, in the Tables group, click Table. To apply the style, on the DESIGN tab, in the Table Styles group, click the More button.

6
4In the Sales Data worksheet, remove duplicate records in the table.

Hint: On the DESIGN tab, in the Tools group, click Remove Duplicates.

5
5In the Sales Data worksheet, insert a new field to the right of the Selling Price field. Name the new field Percent of List Price.

Hint: Right-click the Column E header and click Insert.

6
6In the Sales Data worksheet, create a formula in cell E2  with structured references to calculate what percent the selling price is of the list price. Format the field with Percent Style with one decimal place in the range E2:E43.

Hint: In cell E2, enter the formula =[Selling Price]/[List Price]. To format the range, on the HOME tab, in the Number group, click the Number Format Dialog Box Launcher.

6
7In the Sales Data worksheet, insert a new field to the right of the Sale Date field. Name the new field Days on Market. Create a formula with structured references to calculate the number of days on the market.

Hint: In cell H1, type Days on Market and press ENTER. To insert the formula, in cell H2, type =[Sale Date]-[Listing Date].

6
8In the Sales Data worksheet, add a total row to display the average percent of list price and average number of days on market. Apply the General number format to the average number of days on market. Type Averages in cell A44.

Hint: To display the Total row, on the DESIGN tab, in the Table Style Options group, click Total Row. To select the function, click the cell, click the arrow, and then click the function.

10
9In the Sales Data worksheet, sort the table by City in alphabetical order and add a second level to sort by Days on Market with the houses on the market the longest at the top within each city.

Hint: On the HOME tab, in the Editing group, click Sort & Filter.

8
10In the Sales Data worksheet, select the Listing Date and Sale Date fields and set a column width of 11.00. Wrap the column labels in the range E1:H1.

Hint: To set the column width, on the HOME tab, in the Cells group, click Format. To wrap the labels, in the Alignment group, click Wrap Text.

6
11Set up the Sales Data worksheet so that when printed, the first row containing the field names will print as titles on each page.

Hint: On the PAGE LAYOUT tab, in the Page Setup group, click Print Titles.

5
12Display the Sales Data worksheet in Page Break Preview and move the page break to occur between rows 26 and 27, and then change back to Normal view.

Hint: To display Page Break Preview, on the VIEW tab, in the Workbook Views group, click Page Break Preview. To insert the page break, click cell A27 and on the PAGE LAYOUT tab, in the Page Setup group, click Breaks.

5
13Display the Filtered Data worksheet. Convert the table to a range of data.

Hint: On the DESIGN tab, in the Tools group, click Convert to Range.

5
14Filter the data to display the cities of Alpine, Cedar Hills, and Eagle Mountain.

Hint: On the HOME tab, in the Editing group, click Sort & Filter.

6
15Use a custom AutoFilter to display records for houses that were on the market 30 days or more.5
16Apply the 3 Arrows (Colored) icon set to the days on market field values. Do not include the field name in the range.

Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then point to Icon Sets.

5
17Apply the Light Blue Data Bar conditional formatting in the Gradient Fill section to the selling prices.

Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then point to Data Bars.

5
18Create a new conditional format that applies Yellow fill (fourth color in the bottom row) and bold font to values that are higher than 98% for the Percent of List Price column.

Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then click New Rule.

6
19Ensure that the worksheets are correctly named and placed in the following order in the workbook: Sales Data, Filtered Data.  Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.0
 Total Points100

 

Define networking, tell how it works, and explain how it can help Pentium, Inc.  (Chapter 1) (b)  Identify what type of network would be best for this organization (especially to connect the different locations to each other)

/in /by

Use information from chapters 1 – 4 for this paper.

 

Suppose that the CEO of Pentium Inc. approaches you seeking advice on improving their computer network at their company.  At the moment, their organization has numerous computers (all networked) which are shared by a staff of 100.  The staff are based out of the Pittsburgh headquarter location along with a facility located in Los Angeles and New York City.  Unfortunately the organization is having problems with the network since it was not installed properly and due to its old age (it was installed in 1995).

 

The current network environments consists of the following:

·      Various Stand Alone systems along with numerous Peer to Peer networks

·      Modem connections to remote offices

·      Network equipment that doesn’t meet generally accepted networking standards (i.e. OSI / TCP/IP or DoD)

·      Few systems connected to the Internet

 

The employees of Pentium Inc. are requesting that the new network be fast, flexible and able to meet the needs of their fast growing company.  Write a paper to the CEO on the following elements:

(a)   Define networking, tell how it works, and explain how it can help Pentium, Inc.  (Chapter 1)

(b)  Identify what type of network would be best for this organization (especially to connect the different locations to each other) (Chapter 1)

(c)   Explain why networking standards are important and why equipment that uses these standards should be purchased (Chapter 2)

(d)  Compare the use of Ethernet and Token Ring and the devices (i.e. hubs, bridges, etc) needed to implement each type of network (Chapter 3)

(e)   Compare and contrast TCP/IP and AppleTalk features and benefits (Chapter 3)

(f)   Compare and contrast peer-to-peer, client/server, and directory services networks (Chapter 4)

 

(g)   Write a summary describing which technology you recommend installing and why.

Write a JAVA program to solve the following problem. Your program should properly compile and run.

/in /by

Write a JAVA program to solve the following problem. Your program should properly

compile and run. Your code MUST follow the documentation style used in your textbook.

You need to upload into Moodle the following:

The electronic version of your SINGLE source code file after you successfully

compiled and ran it. Please label your file appropriately.

i do the first steps you will find in the file name lab1

code MUST follow the documentation style used in your textbook you find it in lab1Code

due tomorrow 9\21 at 11am 

explore how to use fundamental analytical tools to understand how distributions of data work in statistics.

/in /by

TAMS #3 Assignment:

Distributions of Data and the Normal Distribution

 

Purpose: In this assignment you will explore how to use fundamental analytical tools to understand how distributions of data work in statistics. This includes how to compute basic probability and how the normal distribution lets us compare two sets of data that may not use the same scale.

The mastery standards covered by this assignment are

S6 –   Distributions of Data: Students will be able to describe distributions of data.

S7 –   Normal Distributions of Data: Students will be able to use the properties of normal distributions of data and explain the results of that use in context. 

MP2 – Communicate a Viable Argument – Entire assignment: Students will be able to justify a statistical analysis in words and communicate that justification.

 

 

Instructions:

Note that this is an INDIVIDUAL assignment, and you are responsible to do your own write-up. You may have started to work on this TAMS in class as a pair or group, but you are to work on this on your own at home. Although you are allowed to discuss this assignment with other class members, you may NOT work together on an electronic document. “Working together” in this context is ONLY by talking, not by typing. You MUST do your own work in the software, save your own copies of the graphics, and produce your OWN written document. Documents that begin as a shared document and are modified will NOT be accepted and will result in a mastery grade of 0 for everybody involved.

You are to submit your answers using the template posted with the assignment. Your template needs to be submitted online through Canvas.

 

 

 

Problem 1

As of March 22, 2020, Slovenia reported a total of 414 cases of COVID-19, of which 412 have been classified by both gender and age range. The data is summarized in the table below (Source: https://www.statista.com/statistics/1104413/slovenia-confirmed-coronavirus-cases-covid-19-by-age-and-gender/).

 

 0 – 1415 – 3435 – 5455 – 7474+total
Women20184253165222 
Men26157215197109 
Total      

 

Use this table to answer the questions below. Before doing so, fill in the missing totals in this table, then answer the questions below.

 

  1. What is the percentage of female COVID-19 cases?
  2. What is the percentage of COVID-19 cases in the age range from 35 to 74?
  3. What percentage of female COVID-19 cases are younger than 60 years?
  4. What percentage of the 15 to 34-year-old COVID-19 cases are men?
  5. According to this data, which age group has the lowest risk? Which gender has the highest risk? Is there a particular age and gender combination that is the riskiest group? Give reasons for your answers and show any computations you may have performed.

 

Problem 2

One of the key purposes of statistical analysis is to make inferences. According to the dictionary, inference is a conclusion reached on the basis of evidence and reasoning. Specifically, for statistics, what we want to do is to be able to choose a sample, obtain some data about that sample, and then come to a conclusion about the bigger population, based on just the information from the sample.

 

How can it be possible to take a small sample (say 100 people) and conclude something about millions of people? The answer lies in a combination of probability and the normal distribution. In this problem, we are going to explore the normal distribution in a simplified fashion. The normal distribution rarely shows up in real life. But as you will discover when we learn about sampling distributions (coming up), the normal distribution shows up a LOT when we look at groups of subjects in a statistical study.

 

One place that the normal distribution does show up in the “real world” is in standardized testing, particular the SAT test.

 

SAT Data

Based on the data from the most recent test scores of 2019 high school graduates, the mean score and standard deviation for the overall test (composite) score and the scores for the English and Math portions are shown below.

 MeanStandard Deviation
Composite1059210
EBRW (English Portion)531104
Math538117

 

 

You have been hired as an admissions evaluator for a large national university. Their guidelines state that students who scored in the top 10.2% of test takers based on their composite score, should be automatically passed to the next step for being considered for admission. Additionally, any student scoring in the top 4.09% in Math also gets automatically passed to the next step. Because you have taken statistics, your supervisor has asked you to write up a set of guidelines that other evaluators will use to quickly look at hundreds of applications to determine if they automatically get moved along in the process.

  1. Create a table of cut-off scores for evaluators to use that would allow them to quickly determine if an application qualifies for automatically moving along. In particular, a table with the various cutoff scores for each type of section or composite score would be very helpful. Remember, in order to convert percentages to scores you will need to use a z-score table to get z-scores and then use the z-score formula to find the necessary cutoff scores. Show all your work and computations. Explain how the scores you calculated meet the guidelines.
  2. Write a short memo to your supervisor which has a short introductory paragraph, then shows your table of cut-off scores.

 

  1. Your supervisor was told by her boss that not enough students are automatically passed on to the next step and wants your supervisor to come up with new cut-off scores. However, your supervisor just wants to change ONE cut-off score so that the admission officers who have used your table do not have to learn a whole new set of cutoff scores. The choices are to lower the math SAT cut-off score by 50 or composite score by 75.

Your supervisor asks you which change would give “the biggest bang for the buck”. Specifically, your supervisor asks you to compute the percentage of students who would automatically be passed to the next stage under these new cut-off scores, and then to identify which of the two cut-off changes increases the percentage of students passed on to the next step by the most.

 

Fill in the table below and show (below it) how you computed one of the percentages, as well as how you computed the increased percentage of students who are being passed along automatically. State your conclusion as to which cut-off score should be changed and why.

 

 

EXAMOld cut-off% passed under old cut-offNew cut-off% passed under new cut-offIncrease in %
SAT Math     
SAT Composite     

 

Accompanying this memorandum is Frigaliment Importing Co. v. B.N.S. International Sales Corp., an important case in contract law. This case illustrates both of the foregoing points. One way to understand a case is to write a case brief. For this writing assignment, each student should write a case brief of Frigaliment,

/in /by

CRAIG SCHOOL OF BUSINESS
Department of Finance and Business Law
BA 18 – Business and the Legal Environment
Professor Michael T. Yonker
SECOND WRITING ASSIGNMENT (CASE BRIEF)
We have been discussing contract interpretation, and what happens when there are problems with
the performance of contractual obligations. Accompanying this memorandum is Frigaliment
Importing Co. v. B.N.S. International Sales Corp., an important case in contract law. This case
illustrates both of the foregoing points.
One way to understand a case is to write a case brief. For this writing assignment, each student
should write a case brief of Frigaliment, following the model below.
The brief is due on November 6, by 11:59 pm. It must be turned in via TurnItIn on Canvas. It is
worth 25 points depending quality and analysis. There is no page recommendation for this
assignment. However, I expect that all sections in the model below will be answered completely
but succinctly. It must be double spaced, with twelve-point Times New Roman font.
MODEL
Facts
Explain the circumstances which brought the parties to court. Include only the facts relevant to
this issue. State the significant facts necessary to present an adequate explanation without
introducing information that is not pertinent or that might confuse the reader.
Issue
State the issue presented to the court in one sentence. If possible, state the question in a form
that could be answered “yes” or “no.”
Holding
State how the court decided the issue by answering the question “yes” or “no”, or with some
other appropriate response to the question. You may add explanation if you wish, but it is not
necessary.
Reasoning
In your own words, explain how the court came to the conclusion that it did. You may quote
from the decision, but the analysis should be your own. If you quote from the decision, indicate
the page from which the quote is taken. Note that no new facts should be introduced in this
section. All facts used by the court to reach its decision should be stated in the “Facts” section.

1. After analyzing the polling data explain why experts believed that Hillary Clinton was favored to win the 2016 Presidential Election.

/in /by

Exam 3 Essay Questions

NOTE:  Both Attachments referenced below can be found in Canvas under the “FILES” tab, inside the “Exam 3 Essay Question Attachments” folder (Each Question is worth 8 points) 

ONLY USE THE ATTACHED LINKS TO ANSWER THE QUESTIONS 

Using Data from  Attachment 1Preview the document : Pew Research Center Polling (Election 2016) in Canvas answers the following questions.

1. After analyzing the polling data explain why experts believed that Hillary Clinton was favored to win the 2016 Presidential Election.

2. What factors within these data indicates that Donald Trump would perform better than expected in the 2016 Presidential Election?

3. Based on what you have learned about Sampling, Sample Bias, Proper Questioning, etc., what concerns do you have with these data, if any?

Using Data from Attachment 2Preview the document, : 2016 Presidential Election Voter Demographics in Canvas answer the following question.

1. Based on the knowledge of typical voter demographics on who votes and who doesn’t, explain why Donald Trump won the 2016 Presidential Election

Assume that 10,000 BDs are produced in the next year. What do you predict will be the total cost of plastic for the BDs and the per unit cost of the plastic for the BDs? Explain.

/in /by

Use the Management Accounting Costs and Concepts Template linked in the resources to complete the following in your Financial and Managerial Accounting textbook:

Problem 14-1B, page 664.

Problem 14-5B, page 666.

Problem 14-1B Cost computation, classification, and analysis C2 C3

Listed here are the total costs associated with the 2017 production of 15,000 Blu-ray Discs (BDs) manufactured by Maxwell. The BDs sell for $18 each.

Classify each cost and its amount as (a) either variable or fixed and (b) either product or period. (The first cost is completed as an example.)

Compute the manufacturing cost per BD.

Check  (2) Total variable production cost, $35,250

Analysis Component

Assume that 10,000 BDs are produced in the next year. What do you predict will be the total cost of plastic for the BDs and the per unit cost of the plastic for the BDs? Explain.

Assume that 10,000 BDs are produced in the next year. What do you predict will be the total cost of factory rent and the per unit cost of the factory rent? Explain.

Problem 14-5B Inventory computation and reporting C4 P1

Shown here are annual financial data at December 31, 2017, taken from two different companies.

Required

Compute the cost of goods sold section of the income statement at December 31, 2017, for each company. Include the proper title and format in the solution.

Check  (1) TeeMart cost of goods sold, $200,000

Write a half-page memorandum to your instructor (a) identifying the inventory accounts and (b) identifying where each is reported on the income statement and balance sheet for both companies.

Use the   information in Table 1-3. If the federal tax system was   changed to a proportional tax rate structure with a tax rate of 17%,   calculate the amount of tax liability for 2017 for all taxpayers. How does   this amount differ from the actual liability?

/in /by

Using your text, complete the following. In these problems, apply your knowledge of tax rate structures, tax liability, and tax return preparation.

● Problem 37, on page 1-32.

● Problem 41, on page 1-32.

● Problem 43, on page 1-33.

● Problem 45, on page 1-33.

● Problem 50, on page 1-33.

 

37. Use the   information in Table 1-3. If the federal tax system was   changed to a proportional tax rate structure with a tax rate of 17%,   calculate the amount of tax liability for 2017 for all taxpayers. How does   this amount differ from the actual liability?

ABLE 1-3 Individual Income Tax Returns from 2017, Number of Tax Returns, Taxable Income (in thousands), Total Tax Liability (in thousands), and Average Tax Rate by Ranges of Adjusted Gross Income

Source: IRS Statistics of Income Bulletin, Winter 2019, Table 1.

*The average tax rate is total tax liability divided by taxable income.

 

41.Cameron is single and has taxable   income of $88,806. Determine his tax liability using the tax tables and using   the tax rate schedule. Why is there a difference between the two amounts?
43.Determine the tax liability, marginal tax rate, and average tax rate (rounded to two decimal places) in each of the following cases. Use the tax tables to determine tax liability.

a. Single taxpayer, taxable income of $38,862:
Liability = __________ Marginal = __________ Average = __________

b. Single taxpayer, taxable income of $89,889:
Liability = __________ Marginal = __________ Average = __________

45. Determine the tax liability, marginal tax rate, and average tax rate (rounded to two decimal places) in each of the following cases. Use the tax tables to determine tax liability.

a. Married taxpayers, taxable income of $38,862:
Liability = _________ Marginal = _________ Average = _________

b. Single taxpayer, taxable income of $61,229:
Liability = _________ Marginal = _________ Average = _________

50. Xavier and his wife Maria have total W-2 income of $93,102. They will file their tax return as married filing jointly. They had a total of $7,910 withheld from their paychecks for federal income tax. Using the tax tables, determine the amount of refund or additional tax due upon filing their tax return. Indicate whether the amount is a refund or additional tax.

Using this weeks readings and your own research, discuss digital forensics and how it could be used in a risk management program.

/in /by

Organizations, especially those in the public, health and educational areas are bound by legal and statutory requirements to protect data and private information, therefore digital forensics analysis will be very beneficial when security breaches do occur. Using this weeks readings and your own research, discuss digital forensics and how it could be used in a risk management program.

Read the link before assignment:

https://resources.infosecinstitute.com/domain-risk-management/