Practical connection

Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. Requirements:Provide a 500 word (or 2 pages double spaced) minimum reflection.Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.Share a personal connection that identifies specific knowledge and theories from this course.Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. You should not, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.Be sure to not self-plagiarize as this assignment is similar in multiple courses.

Story Telling

 Review  Discussion: Storytelling and Success Stories then focus on Moritz’s work on the  OECD Better life index download the executive summary and the index data.

In a one-page summary, note a few particular places around the world and compare and contrast the statistics.  Also, note briefly how this graphic tells the story.

https://www.visualisingdata.com/2013/04/discussion-storytelling-and-success-stories/
https://www.oecdbetterlifeindex.org/#/11111111111

Change compute stats2

Change compute_stats2.py so that it takes a single command line argument that is an integer

specifying which whitespace separated column it should process. For the user, column numbers

start at 1.

Since the program is going to be processing the whole file rather than just a single column of

numbers, we will use the csv module to parse it. Read the csv.reader documentation to figure

out how to specify spaces as the delimiter in the file and how to skip over multiple delimiters in

a row (if you don’t do this, each individual space will be considered a delimiter, which is not

going to work well).

Finally, change your program so that it does not require the input values to be sorted already

(i.e., it should sort the values itself before passing to the compute_stats function).

Database Project

You will be designing and creating a DBMS for the field of Healthcare. You will be creating SQL queries based on common queries that a common end-user would make to a healthcare system. In addition, identify when to use No-SQL. Not only are you building multi-table databases for different components of a healthcare system, but you will also incorporate and create image databases that store real and publicly available health data like cancer images and how databases play a role in building machine learning models.

Project on survelliance state

Your Research Project on the surveillance state consists of two parts:

1 a Powerpoint presentation consisting of at least 12 slides not including title and references.

2. 750 word research  paper with at least 3 sources. There should be no lists. Write in format not outline format. Include a meaningful title.

Do not double space.

You must include at least 3 quotes from your sources enclosing the copied words in quotation marks and cited in-line. 

There should be no lists – bulleted, numbered or otherwise. 

Write in research format with coherent paragraphs not in outline format. Distribute your quotes among the paragraphs.

Do your own work. Zero points will be awarded if you copy other’s work and do not cite your source or you use word replacement software. 

The topic must be appropriate for graduate level. Find a topic that we covered in the course and dig deeper or find something that will help you in your work or in a subject area of interest related to the course topic. Use academically appropriate resources which you can find in the Danforth Library Research Databases.

Submit all documents at on time. Do not zip or otherwise compress them. Do not use .rar. Use .doc and .ppt extensions  Do a five source annotated bibliography/reference list on the subject. There should be two annotations for each source. In the first write a paragraph of at least five sentences summarizing the thesis of the article. In the second write a paragraph of at least five sentences summarizing your reflections on the thesis of the article. You should do a deep dive into a topic. Do not do a survey. Make use of academic references such as you can find in the Danforth LIbrary research databases 

Use at least five sources.

Copying without attribution or the use of spinbot or other word substitution software will result in a grade of 0. 

3rd Excel Exam SU1 2021

 

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

  

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