This week’s discussion is about Status of Software Engineering. Read the two attached articles Legal Status of SE.pdf Download Legal Status of SE.pdf(published in 1995) and Push to Make SE respectable.pdf Download Push to Make SE respectable.pdf(published in 2000) and post a message of at least 100 words in M7 Discussion.

1. Tell us your understandings on software engineer’s working condition and social status in the last three decades. You can also include link(s) to article that is related to this discussion.
2. Provide constructive comment on at least one other student’s posting. “Agree with you”, “good thoughts” etc. are not counted as constructive commenting and do not count.

 #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 

Communities do not exist in a bubble. Often changes made in the larger society, driven by technology, have an unexpected effect on local communities. Consider the effects of the advancements in transportation technologies on communities. Routes of transportation have evolved from water to train to road and then to air. Each of these advancements led to job displacement and changes in travel routes. In the United States, prior to the mid-1800s, the communities that thrived had water access and ports where the exchange of goods and services occurred. With the building of the transcontinental railway and the growth of transportation by rail, the communities that thrived had train depots. With the building of major highways in the 1900s, access to those roads became critical to survival. With each advancement, local communities were impacted, such that many communities that grew around train depots became ghost towns full of poverty, homelessness, and despair once train travel was no longer the primary means of human transportation. 

In this assignment, you are asked to create a presentation on one of the following topics:

• Green Energy
• Globalization
• Communication Technology
• Remote Elementary Education
• Remote High School Education
• Remote Work

You can create your presentation in your choice of presentation media. For example, you could choose to create a PowerPoint presentation, a video, or use Prezi. (refer to the Unit 1 assignment) If you choose to use video, you are required to supply a script as well as the URL of the video.

In your presentation, you must address the following:

• Describe the specific technological development and its association with your chosen topic.
• Explain why you chose that topic and the technological advancement associated with it.
• Discuss which demographic (income, age, sexual preference, ethnicity) and/or geographic feature (urban, suburban, rural) might be most affected by the changes. Support your opinion with three (3) external references.
• Explore the societal impacts (good and bad) associated with the technology. include a discussion for each of the following:
  • Economic impacts (unemployment, loss of revenue, poverty), include one (1) external reference
  • Health impacts (including mental health), include one (1) external reference
  • Privacy concerns, include one (1) external reference
  • Community life, include one (1) external reference

Be sure to use appropriate sources for the external references required for this assignment.

there is a trade-off between memory use and CPU overhead, give an example where increasing the size of virtual memory will improve job throughput. Give an example in which doing so will cause throughput to suffer and explain why this is so.

Week 7 Discussion

2727 unread replies.2727 replies.

Welcome to Week 7

This week we will cover how to evaluate information and control technology. This is a popular topic because some will say that most information on the internet is fake. Others will say that it is biased or manipulated. Ultimately, you need to have a reasonable amount of judgement to ensure the information you are reading is legitimate.

Moreover, as technology evolves and expands, users and businesses are faced with constant decisions about what is right for them or their business. What drives adoption? What makes products successful? Does the business need the new technology or does the new technology create the need?

Pick a topic below and post your reply by Wednesday at midnight. Your response should be at least 400 words and appropriately cites your resources.

Respond to two of your classmates by Sunday at midnight. Your responses should be at least 200 words and should be substantive. You should offer additional resources, insight, or other helpful feedback. A simple “I like your post” will result in a 0.

You will not be able to see your classmates’ posts until you make your first post.

Topics:

• How well can we predict the consequences of a new technology or application?
• Who should make the decision for a business on what technology the adopt?
• What does the term “need for reasonable judgement” mean?
• Do sites like Wikipedia hold any credibility?

Search entries or author

Open the two attached packet tracer files. Your job is to try to get them to 100%. 

At any time if you’re stuck you can click the Check Results button then Assessment Items.

Don’t forget there is also a Reset Activity button if you need to undo everything and start over.

Save and submit your completed files for grading. Each activity will count for half of the grade.

I did link share file for both 

 Do some research on Threat Response software. Find one particular software package to investigate.

• What does the software do?
• What are it’s major features?
• What kind of training is required?
• How much does the software cost?

Do not do the same software as everyone else.  200 – 300 Words

Hi, I attached the instructions. Thank you

refer to the attached document

 Let ????????????????????????DFA = {〈????〉 | ???? is a DFA and for every ???? ∈ ????(????), ???? = ???????? where ???? = ????}. Show that ????????????????????????
DFA is decidable.