GO19_AC_CH02_GRADER_2G_HW – Student Scholarships 1.0

GO19ACCH02GRADER2GHWStudent Scholarships1.0

Project Description:

In this project, you will use a database to answer questions about scholarships awarded to students at a college. You will create a relationship between two tables, create a query from an existing query, and create queries using text, numeric, compound, and wildcard criteria based using the fields in one or both tables. You will create calculated fields, group data when calculating statistics, create a crosstab query, and create a parameter query.

Start Access. Open the file ‘Student_Access_2G_Student_Scholarships.accdb‘ downloaded with this project.

Using   Student ID as the common field, create a one-to-many relationship between the   2G Students table and the 2G Scholarships Awarded table. Enforce referential   integrity and enable both cascade options.

Create   a relationship report with normal margins, and save it as 2G Relationships. Close all open objects.

In   the last record of the 2G Students table, change the Student ID from 9999999 to 2839403, and then close the table. (The   related records in the Scholarships Awarded table will automatically update.)

Create   a query in Query Design view based on the 2G Scholarships Awarded table to   answer the question: What is the   scholarship name, amount, and major for scholarships greater than or equal to   $500, sorted in ascending order by the Scholarship Name field? Display   the fields in the order listed in the question. Run the query. Eight records   match the criteria. Save the query as 2G Amount $500 or   More Query.   Close the query.

Copy   the 2G Amount $500 or More Query to create a new query with the name 2G Awards 4th Qtr Query and then redesign the query to answer   the question: Which scholarships   (Scholarship Name) were awarded between 10/1/22 and 12/31/22, for what amount, and for which   student (Student ID), sorted in ascending order by the Award Date field? Display only the fields necessary to answer   the question and in the order listed in the question. Run the query (five   records display). Save the query, and then close the query.

Create a query in Query Design view   based on the 2G Scholarships Awarded table to answer the question: Which scholarships (Scholarship Name) were   awarded for either Math or Business majors for amounts of more than $200,   sorted in descending order by the Amount field? Display the fields in the order   listed in the question. Run the query. Four records match the criteria.   (Hint: If six records display, switch to Design view and combine the majors   on one criteria line using OR.) Save the query as 2G Math OR Business Over $200 Query, and then close the query.

Create   a query in Query Design view based on the 2G Students table to answer the   question: What is the city, student ID,   first name, and last name of students from cities that begin with the letter   L, sorted in ascending order by the City field and by the Last Name field? Run the query (five records display). Save   the query as 2G L Cities Query,   and then close the query.

Create   a query in Query Design view based on the 2G Students table and all of the   fields to answer the question: For   which students is the Postal Code missing? Three records match the   criteria. Run the query (three records display). Save the query as 2G Missing Postal Code Query, and then close the query.

Create a query in Query Design view   based on both tables to answer the question: In ascending order by the Scholarship Name field, and including the   first name and last name of the scholarship recipient, what will be the total   value of each scholarship if the Board of Trustees donates an additional 50   percent of each award paid to students? (Hint: First calculate the amount   of the donation, naming the new field Board Donation,   and then run the query to be sure the correct results display (the first   record—Scholarship Name that begins with   Amanda—has a Board Donation of 125).

Display   the query in Design view. In the sixth column of the design grid, create a   new field named Total Donation   that will calculate and display the total donation when the amount is added   to the Board’s donation amount. Run the query.

Display   the query in Design view. Use the Property Sheet to format the Board Donation   field as Currency with 0 decimal places and the Total Donation field with 0   decimal places, and then close the Property Sheet. Run the query (the first   record—Scholarship Name that begins with   Amanda—has a Total Donation of $375.00), apply Best Fit to the   fields, save the query as 2G Board Donation Query,   and then close the query.

Create a query in Query Design view   based on the 2G Scholarships Awarded table and the Sum aggregate function to   answer the question: For each major,   what is the total scholarship amount, sorted in descending order by the   Amount field? Use the Property Sheet to format the Amount field with 0   decimal places, and then close the Property Sheet. Run the query (for the   Major of History, the total scholarship amount is $1,850). Apply Best Fit to the fields, save the query as 2G Amount by Major   Query, and then close the query.

Use the Query Wizard to create a crosstab   query based on the 2G Scholarships Awarded table with the Student ID field as   row headings and the Major field as column headings. Sum the Amount field,   and name the query 2G Student ID and Major Crosstab Query. Display the query in Design view. Use   the Property Sheet to format the last two columns with 0 decimal places, and   then close the Property Sheet. Run the query, apply Best Fit to the fields,   save the query, and then close the query.

Create a query in Query Design view   based on the 2G Scholarships Awarded table that prompts you to Enter the Major of the student, and then answers the   question: What is the scholarship name   and amount for a major, sorted in ascending order by the Scholarship Name   field? Run the query, and when   prompted, enter history   as the criteria (four records display). Display the query in Design view and   hide the Major field from the results. Run the query again, entering history when prompted. Save the query as 2G Major Parameter   Query, and then close the query.

All posts must be a minimum of 250 words. APA reference. 100% original work. no plagiarism.

What is a Security Risk Assessment? 

What elements does it entail? 

Does it include or exclude Penetration Testing? 

What types of Security Risk Assessments exists? Identify at least 3.

1. Introduction 

a. What is snort? 

i. Creation & history 

1. Created in 1998 

2.Martin Roesch 

3.Pcap origin 

4.Cisco Acquisition 

ii. Value to network admins 

1. Open-source nature 

2.Consistent rule updates 

1. Overview of important features 

a. Traffic monitoring 

a. Packet Logging 

a. OS fingerprinting 

Write a C++ program that implements the Naïve Gaussian Elimination and Gaussian Elimination with Partial

Pivoting (See class notes.) for linear systems.

1. Name your source file YourLastName5.cpp.

2. All floating point arithmetic will be double precision.

3. Input to the main program

• data file name

• sequence of augmented matrices each of which represents a linear system

4. Program output:

For each linear system

• Original augmented matrix

• Upper triangular matrix obtained by the Naïve Gaussian Elimination

• Solution from the Naïve Gaussian Elimination

• Upper triangular matrix obtained by the Gaussian Elimination with Partial Pivoting

• Solution from the Gaussian Elimination with Partial Pivoting

I need to write a term paper on the topic Siemens Simatic- PCS7/WINCC (SCADA) 

Exp19_Excel_Ch06_ML1_Housing_Cost

Exp19_Excel_Ch06_ML1_Housing_Cost

Project Description:

Your friends, Elijah and Valerie Foglesong, want to build their dream house. They identified tentative costs, but they cannot afford the $414,717 estimated cost. You will use Goal Seek to determine an estimate of the total finished square footage they can afford. To help provide more flexibility in their decision-making, you will create a data table listing various finished square footages and their effects on the base house cost and total cost. Finally, you will create another data table showing combinations of square footages and lot prices to identify total costs.

Start   Excel. Download and open the file named Exp19_Excel_Ch06_ML1_HW-Housing   Cost.xlsx.   Grader has automatically added your last name to the beginning of the   filename. 

Assign the range names B9 (Base), B15 (Interior), B21 (Exterior), B23 (Lot).

Enter a formula in cell B25 to   calculate the total estimated cost. The total estimated cost is the sum of   the base house price (B9), total interior upgrades (B15), total exterior   upgrades (B21), and lot fee (B23). Be sure to use range names in the formula.

Use Goal Seek to determine the   total finished square footage(B7) to meet the total cost goal of $350,000.

Enter a series of total square   footage ranging from 1,800 to 3,600 in increments of 200 in the range D6:D15. Apply Blue font and Comma Style with   zero decimal places to the series.

Enter a reference to the base   house price in cell E5 and a reference to the total estimated cost in cell   F5.

Complete the single variable   data table in the range D5:F15. Be sure to use total square footage as the   column input. Apply Custom number formats to give appropriate descriptions to   the second and third columns. Apply these formats to the headings: bold,   center, and Blue font color.

Identify the square footage,   base price, and total cost in the data table that comes closest to their   goal. Apply Yellow fill color to those cells.

Copy the square footage   substitution values, range D6:D15 to the range H6:H15 and remove the fill   color. Enter these lot price substitution values in the range I5:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero   decimal places and Blue font color.

Enter the reference to the total   estimated cost in the appropriate location for the second data table. Apply a   custom number format to display Total Sq Ft in that cell. Apply Blue font and bold to that   cell.

Complete the two-variable data   table using total square footage as the Column Input and lot price as the Row   Input. Apply a Custom number format to the reference to the formula cell.   Apply Yellow fill color to the total price in each column that comes closest   to their goal.

Format results in both tables   with Accounting Number Format with zero decimal places.

Create a scenario named Ideal Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 80, 102,675.

Create a scenario named Increased   Costs, using   Base price per square foot and Lot fee (use cell references). Enter these   values for the scenario: 100, 110,000.

Create a scenario named Low Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 60, 80,000.

Generate a scenario summary   report using the cell references for Price per square foot and Lot Fee. Add   the appropriate formatting to the newly created report

Save and close Exp19_Excel_Ch06_ML1_HW-Housing Cost.xlsx.   Exit Excel. Submit the file as directed.

Exp19_Access_Ch4_Cap – Farm Conference 1.0

Note : Just Imports the Table, Form, Reports and Queries from this Data in your Access File  Or If You can not do this Send me message 

 You are helping a small non-profit group organize their national farm and agriculture conference. You will create a form to organize input, a report to display the finalized schedule, and mailing labels.

  Access Chapter 4  Farm Conference  

Start Access. Open the downloaded   Access file named Exp19_Access_Ch4_Cap_Farm.accdb. Grader has automatically added your last name to the   beginning of the filename. Save the file to the location where you are   storing your files.

Create   a form using the Form tool based on the Presenters table. Change the title in   the Form Header to Enter/Edit Presenters.

Reduce   the field value control widths to approximately half their original size (to   approximately 3.6″). Delete   the subform.

Sort   the records by LastName in   ascending order. Save the form as Edit Presenters.   Close the form.

Open   the Location Information form in Layout view. Apply the Stacked Layout   control to the form. Save and close the form.

Create   a new report based on the Exhibits   with Presenters query using the Report Wizard. Select all available   fields, choose to view the data by Presenters, ensure that FirstName,   LastName is the only grouping level, use Date as the primary sort field in   ascending order, accept the default Stepped option, and change the layout to Landscape. Save the report as Presenter Schedule.

Apply   the Integral theme to this report only. Save the report.

Modify   the Presenter Schedule report so that the StartingTime field from the Exhibits table is added as the last   field (appearing to the right of LocationID). In Design view, ensure that the   left edge of the field is at the 8.5-inch mark on the ruler, and then return   to Layout view.

Change   the title of the Presenter Schedule report to Schedule by   Presenter.

Change   the sort so the StartingTime is a   secondary sort field (that is, so that the first sort is Date, and the second   sort is StartingTime). Save and close the report.

Create   a new labels report based on the Presenters table. Use the Avery USA 8660   label template. Accept the default font options, and set the labels up so the   first and last name appear on the top line, the Address on the second line,   and the City, State, and ZipCode appear on the final line. Your first label   should look like:
 

Shannon Beck
368 Graham Avenue
Graham, KY 42344
 

  Do not add any sorting. Name the report Presenter Mailing   Labels.   Close the labels.

 Information related with the Survey paper and Presentations is given here. Survey This is an individual research. Each student will prepare a survey on the topic of their interest by reading at least 3 – 5 scientific papers and writing a short report (maximum of 5 pages including citations). Survey details In your report, give the problem/topic definition, discuss the motivation behind the studies working on this problem/topic (just try to answer the question of “why have all these studies worked on this problem? is it really important?”), and then explain the studies. While explaining the studies, do NOT list the studies and do NOT explain them one by one. Instead, understand the contribution and methodology of each study, try to group the studies according to their contributions and methodologies, and then explain/discuss the studies as groups.
In your discussion, do not forget to give the give the advantages and disadvantages of each group’s approach, and discuss the similarities and differences in between the approaches followed by different groups. The format, plagiarism, structure, and writing style of your report (including writing the citations properly) will be a part of your grade.

  Sample Output

Original Polyhedra







------------------------------------------------------







[Sphere] (2, 2, 2)->Radius: 1 Diameter: 2







[Cylinder] (2, 2, 2)->Radius: 1 Height: 2







[Sphere] (8, 8, 8)->Radius: 4 Diameter: 8







[Cylinder] (6, 6, 2)->Radius: 3 Height: 2







[Composite] (14, 14, 14)->3 polyhedra







  [Sphere] (6, 6, 6)->Radius: 3 Diameter: 6







  [Sphere] (10, 10, 10)->Radius: 5 Diameter: 10







  [Sphere] (14, 14, 14)->Radius: 7 Diameter: 14















[Composite] (10, 10, 10)->2 polyhedra







  [Cylinder] (4, 4, 1)->Radius: 2 Height: 1







  [Sphere] (10, 10, 10)->Radius: 5 Diameter: 10















[Sphere] (6, 6, 6)->Radius: 3 Diameter: 6























Scaled Polyhedra (Clones)







------------------------------------------------------







[Sphere] (4, 4, 4)->Radius: 2 Diameter: 4







[Cylinder] (4, 4, 4)->Radius: 2 Height: 4







[Sphere] (16, 16, 16)->Radius: 8 Diameter: 16







[Cylinder] (12, 12, 4)->Radius: 6 Height: 4







[Composite] (28, 28, 28)->3 polyhedra







  [Sphere] (12, 12, 12)->Radius: 6 Diameter: 12







  [Sphere] (20, 20, 20)->Radius: 10 Diameter: 20







  [Sphere] (28, 28, 28)->Radius: 14 Diameter: 28















[Composite] (20, 20, 20)->2 polyhedra







  [Cylinder] (8, 8, 2)->Radius: 4 Height: 2







  [Sphere] (20, 20, 20)->Radius: 10 Diameter: 20















[Sphere] (12, 12, 12)->Radius: 6 Diameter: 12

 your task is 

1. Acquire complete versions of Cylinder.h and Cylinder.cpp from Part 1. You may use my Part 1 solution, or your own solution.

1. Complete add, display, and scale functions for Composite.
2. Complete the Big-3 for Composite
   • Note that the Composite::allPolyhedra attribute, is a vector of pointers (std::vector).
   • I was feeling generous and provided you the Composite::operator= method (I used the copy-and-swap idiom). This leaves you with the Copy Constructor and Destructor (2 of the Big-3).

If you implemented everything in Composite correctly you will see:

PASSED->testDefaultConstructor



PASSED->testAdd



PASSED->testClone



PASSED->testRead



PASSED->testScale



PASSED->testDisplay

 If you see FAILED you must revisit revisit the corresponding function(s).  

Many students forget to scale the bounding boxes. This can be done using the BoundingBox::scale or Polyhedron::scale functions.

refer to the attached document in the uploads.