Need help on your assignment? Click here to make your Order.
EX16WDCH03GRADERCAPAS (completed solution).1.Buy here:Description:In the following project, you will modify a document prepared for publication in one or morejournals related to weather statistics in the United States. Climate change, or globalwarming, is suspected by some to be a factor in the change in injuries and fatalities relatedto natural disasters and weather trends. The document and related table will be combinedwith a data source in a mail merge operation to send to selected journal editors.Instructions:For the purpose of grading the project you are required to perform the following tasks:Step Instructions PointsPossible1 Download and open the filenamedEX16WDCH03GRADERCAPAS.docx.0.000.2 Insert a column at the right of the 10-Year Averagecolumn in the table. Add the following data in the newcolumn, beginning in row 2:6.000.3 Type 30-Year Averagein the fourth cell on row 1.
Inserta new row at the top of the table, merge cells in the newrow, and typeU.S. Natural Disaster Statistics. Formatthe first row with Align Center alignment.6.0004 Align Center all entries in the second, third, and fourthcolumns from row 2 through the last row in the table.7.0005 Delete the Winterrow. 6.0006 Add a row below the last row in the table. Type Totalinthe first cell of the new row. Insert a formula in thesecond, third, and fourth columns of the new row to totalall values above.9.0007 Apply Grid Table 5 Dark, Accent 5 table style to thetable (fifth row, sixth column under Grid Tables).
Selectthe table. Select a pen color of Blue, Accent 5, Darker50%. Apply the color to Outside Borders.9.000.8 Bold all entries in row 2.
Shade row 2 with Blue-Gray,Text 2, Lighter 40%.9.0009 Select row 2 and apply a Single solid line, 1 1/2 pt.,Accent 1 (second row, second column under ThemeBorders) border style to the outside borders of theselected row.8.00010 Change the format of the formula in the second cell ofthe last row (total for Year 2015) to #,##0.7.00011 Start a Mail Merge using the Step-by-Step Mail MergeWizard. The document type is Letters. Use the currentdocument. Use Sheet1ofEx16WDCH03GRADERCAPASDatasource.xlsxas the data source. Sort the recipients by State inascending order.12.00012 Replace the bracketed Address Blockwith the Addressblock field, using the default settings. Replace the8.000.bracketed Journal Name with data from the JournalName field.
Preview the letters.13 Adjust the address block so that it is single spaced withno spacing before or after paragraphs. Format thejournal name in the last line of the document in italics.7.00014 Complete the merge, merging all records. 6.00015 Save the merged documentasEX16WDCH03GRADERCAPASLastFirst.docxand close the document.CloseEX16WDCH03GRADERCAPAS.docxwithout saving the document. Exit Word.SubmitEX16WDCH03GRADERCAPASLastFirst.docxas directed.0.000Total Points 100.000.
Use Visio to create the appropriate diagrams.Create a script named sql (where XXX are your initials) thatCreate the tables in 3NF needed to implement your DB schema.Your tables must include primary and foreign key constraints.Populate the database.Create the report that includes all three patients.Each student will be required to add an individual query. See your instructor for the specifications of your query.Patient Doctor Room Admitted Required Medication- -1001 Fred Payne 101 MARCH 31, 2004 2 Prozac 3 grams annually6 Aspirin 1 gram daily9 Valium 2 grams weekly3. Using the traditional join method, write a query using the ORDERITEMS and BOOK tables to list the order number, book title, and retail amount of the book ordered. Format the retail amount to reflect dollars and cents using the correct function and give the retail amount column and alias of 'Cost.'
![Quill financial services has recently started working with student loans Quill financial services has recently started working with student loans](http://docshare.tips/img/4994/student-loans_58c0475fb6d87f616d8b5383.jpg)
Rewrite the query in #1, only this time, use a NATURAL JOIN operator to create the join. Your output should be the same.Write a query using the BOOKS and PUBLISHER tables that will show all of the publishers’ names and related book titles, even those publishers who do not currently have any books listed in the BOOKS table. HINT: this will require an OUTER JOINWrite a sub query using the BOOKS and PUBLISHER table to list the ISBN, book title, and the retail price for every book in the BOOKS table published by AMERICAN PUBLISHING.
Format the book price to show a dollar sign and two decimal places by using the correct conversion function.Write a sub query using the ORDERITEMS table that will return only the ISBN of the book that has been bought most often. This process will require you to obtain the maximum total number of books ordered (based on ISBN) and then compare that to total books ordered, grouped by ISBN. Remember that sub queries work from the bottom up so the process described here is starting with the second query, not the first (remember this exercise when doing #5 in the lab).Turn the following in for a grade:This lab sheet as a cover sheet with your name on itYour script file with the five queries in itThe output file showing both the query and result setAdd this assignment (all three documents) to the zip file containing all assignments for this week. ICT 704 Non-Relational Database Systems Task 2 NoSQL Movies Database Using MongoDBBackgroundMovie Maniacs is a site which lists top charts of movies and have put an emphasis in follower engagement. They are active on Facebook and Twitter and share the latest updates and news to their followers.
However, they have recently decided to create a page where viewers can rate the movies on the list and leave comments for. Others to see. They have asked you to come up with a database using MongoDB to be able to store their movie lists and allow viewers to easily rate and review the movies. Movie Details. Every movie has a unique identifier. Some movies have a series title. Every movie has at least one Director and a list of leading actors.
Some movies have won Oscars. Movies can have multiple reviews, one review or no reviews made. Reviews are made by anyone, who only need to supply a name. Reviews consist of a rating out of 10 and any commentsPart A - Database. Create a MongoDB database using the data provided to you in the MovieDataTask2.xls spreadsheet. This assignment requires several functions with return values. Instructions:For the purpose of grading the project you are required to perform the following tasks:Step Instructions Points Possible1 Start Excel.
Open exploringe08graderStats.xlsx 0.0002 In the range F2:H2, insert functions that will calculate the average for each of the groups (Control, CBT Only, Hybrid). 12.0003 In the range F3:H3, insert functions that will calculate the median for each of the groups. 12.0004 In the range F4:H4, insert functions that will calculate the most repetitive value for each of the groups.
12.0005 In the range F5:H5, insert functions that will calculate the highest value for each of the groups. 12.0006 In the range F6:H6, insert functions that will calculate the lowest value for each of the groups. 12.0007 In the range F7:H7, insert functions that will calculate the variance for each of the groups. Use the function that includes the.S descriptor. 12.0008 In the range F8:H8, insert functions that will calculate the standard deviation for each of the groups. Use the function that includes the.S descriptor.
![Ex16_ac_vol1_grader_cap_as Ex16_ac_vol1_grader_cap_as](http://libraay.com/wp-content/uploads/edd/2018/12/db_47_img.jpg)
12.0009 Format the values in the range F2:H8 with the Comma Style with three decimal places. 3.00010 Use the Data Analysis tools to perform an analysis of variance using the range A2:C25 as the input range and E11 as the output range. 10.00011 Format the averages and variances in the SUMMARY table with the Comma Style with three decimal places. 3.00012 Save the workbook. Close the workbook and exit Excel.
Submit the workbook as directed. Instructions:For the purpose of grading the project you are required to perform the following tasks:Step Instructions Points Possible1 Start Excel. Open exploringe08graderm1Stocks.xlsx. 0.0002 Type Symbol in cell B2, type Last Sale Price in cell C2, and type Rank in cell D2. 12.0003 Enter the following stock information beginning in cell B3: Click cell B3 and type CTIC.
Click cell C3 and type 1.92. Click cell B4 and type AAPL. Click cell C4 and type 130.96. Click cell B5 and type C. Click cell C5 and type 59.19.
Click cell B6 and type BAC. Click cell C6 and type 18.12.
8.0004 Use the RANK.AVG function to calculate the rank of the first stock in cell D3 and copy the formula down to complete the column. 12.0005 Click cell B8, type Average value, and in cell C8 type. SOLUTION LINK:CMIT 350 XUMUC Case StudyXUMUC has WAN links in place at their new location in the Houston Region. XUMUC currently has 2 other regional locations, in San Francisco and Denver. Originally, XUMUC was only located in one region (San Francisco). The previous consultant did a poor job with the integration, resulting in a poor IP address scheme.
As a result routing tables at the summarization points at the San. Francisco campus are very large. In addition, no VLAN structure was developed to isolate broadcast traffic and there has been some concern that the WAN tansport was not able to accommodate the network traffic. Finally, all addresses in the network are statically assigned resulting in high administrative overhead, even when minor changes are implemented. For the next expansion phase, XUMUC would like this changed to lower administrative overhead. There are 4 main departments in XUMUC: sales, finance, human resources, and research and development.
For assigning IP addresses you can pick any one from the following network addresses.172.16.0.0/16172.17.0.0/16172.18.0.0/16172.19.0.0/16172.20.0.0/1610.10.0.0/1610.5.0.0/1610.6.0.0/1610.7.0.0/1610.8.0.0/16. IP ADDRESSING TABLELocation Number of IP Addresses Required Address Block Assigned Summarized AddressSan Franciso 1290Denver RegionDenver Campus 441Remote Office 1 28Remote Office 2 35Houston RegionHouston Campus 329Remote Office 3 21Your paper should address the following XUMUC Network Issues.Create VLAN, as appropriate, to minimize and Isolate broadcast traffic.Reduce WAN Traffic.Develop a new IP scheme summarizing at points shown in the diagram.Deliverables:Provide a document that addresses all issues described above. The document comply to APA style and should contain:Cover pageIndex PageMain Body (3 to 5 Pages)Executive summaryConclusionReference PageTechnical details in Main Body (including any assumptions)Provide details that address all issues described aboveComplete IP addressing table (including summarized routes for the Denver and Houston regions),Update network diagram with summarization address at each router and link addresses. SOLUTION LINK:Designing Database Applications: Course and Student SchedulesDick Scudder, the chairperson of the information technology department at the University of Denver, needs to create a database to keep track of all the courses offered by the department. In addition, Dick would like the database to include each instructor’s basic contactinformation, such as ID number, name, office location, and phone numbe.
Currently, Dick has nine instructors (seven full-time faculty members and two adjuncts) in the department. For each course, Dick would like to keep track of the course ID, title, and number of credithours. When courses are offered, the section of the course receives an ID number, and with that number, the department keeps track of which instructor is teaching the course. Finally, Dick needs to be able to keep track of the IT students and to know which courseseach student has taken. The information he would like to know about each student includes ID number, name, and phone number. He also needs to know what grade the student receives in each course.