Select project topic from digital forensics tools and research. Include a short paragraph describing project and how you intend to research it.
1.project topic
2. a brief abstract describing project.
3. 600-800 word paper
4. Power point presentation 12 slides
Solution File and Step-by-Step Video is Also Available in the Answer
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 downloaded file named Student_17J_Student_Scholarships.accdb, and then enable the content.
In the 17J Students table, change the data type for the Student ID field to Short Text. Change the data type for the Postal Code field to Short Text. Change the field size for the State field to 2. Save and close the table.
Using Student ID as the common field, create a one-to-many relationship between the 17J Students table and the 17J Scholarships Awarded table. Enforce referential integrity and enable both cascade options.
Create a relationship report with normal margins, saving it as 17J Student Scholarships Relationship. Close all open objects.
In the last record of the 17J Students table, change the Student ID from 9999999 to 2839403, and then close the table. (The related records in the 17J Scholarships Awarded table will automatically update.)
Copy the 17J Amount $500 or More Query to create a new query with the name 17J Awards 4th Qtr Query. Redesign the query so that the following fields display in the order given: Scholarship Name, Award Date, Amount, and Student ID. Sort the records in ascending order only by the Award Date field. Do not restrict the results by Amount. Set the criteria so that when you run the query only those records display for an award date between 10/1/22 and 12/31/22. Run the query (five records display). Save the query, and then close the query.
Create a query in Query Design view based on the 17J Scholarships Awarded table. Add the following fields to the design grid in the order given: Scholarship Name, Major, and Amount. Sort the records in descending order by the Amount field. Set the criteria so that when you run the query only those records display that have a major of Math or Business and an amount that is greater than 200. Run the query (four records display). Save the query as 17J Math OR Business Over $200 Query, and then close the query.
Create a query in Query Design view based on the 17J Students table. Add the following fields to the design grid in the order given: City, Student ID, Last Name, and First Name. Sort the records in ascending order by the City, Last Name, and First Name fields. Set the criteria so that when you run the query only those records display that have a city name that begins with the letter L. Run the query (five records display). Save the query as 17J L Cities Query, and then close the query.
Create a query in Query Design view based on the 17J Students table. Add the following fields to the design grid in the order given: Student ID, First Name, Last Name, Address, City, State, and Postal Code. Set the criteria so that when you run the query only those records display that are missing the postal code. Run the query (three records display). Save the query as 17J Missing Postal Code Query, and then close the query.
Create a query in Query Design view based on both tables. Add the following fields to the design grid in the order given: Scholarship Name, First Name, Last Name, and Amount. Sort the records in ascending order by the Scholarship Name field. In the fifth column of the design grid, create a new field named Board Donation that will calculate and display the donation amount when the Board of Trustees donates an amount equal to 50 percent (0.5) of each scholarship amount. Run the query (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 (the first record—Scholarship Name that begins with Amanda—has a Total Donation of $375.00).
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, apply Best Fit to the fields, save the query as 17J Board Donation Query, and then close the query.
Create a query in Query Design view based on the 17J Scholarships Awarded table. Add the following fields to the design grid in the order given: Major and Amount. Sort the records in descending order by the Amount field. Sum 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 17J Amount by Major Query, and then close the query.
Use the Query Wizard to create a crosstab query based on the 17J 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 17J 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 17J Scholarships Awarded table. Add the following fields to the design grid in the order given: Scholarship Name, Amount, and Major. Sort the records in ascending order by the Scholarship Name field. Set the criteria so that when you run the query you are prompted to Enter the Major. 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 17J Major Parameter Query, and then close the query.
Be sure that all database objects are closed, open the Navigation Pane, and then close Access. Submit the database as directed.
Review the reading by Naouma and answer the following
Naouma, P. (2019). A comparison of random-field-theory and false-discovery-rate inference results in the analysis of registered one-dimensional biomechanical datasets. PeerJ (San Francisco, CA), 7, e8189–e8189.
What is Logistic
very easy homeworks. due saturday
How ledger capabilities of blockchain help to resolve issues in the banking sector.?
Post a Python program that contains a while loop. The number of times the loop iterates should depend upon input supplied by the user. Your program should display some output each time the loop executes. Include comments in your program that describe what the program does. Also post a screen shot of executing your program on at least one test case.
Assignment #2
Explain the rationale of the Ohio Supreme Court in allowing disciplinary records to be released, focusing on the majority opinion. Then explain the rationale of the US Circuit Court (“US Court of Appeals” in the text) in disallowing the release of disciplinary records. You may also reference the dissent in the Ohio Supreme Court case.
Choose a side and argue your case. Before you conclude your , give your opinion on how you think the US Supreme Court might rule if it ever took up the case.
Background
Understudies in the Journalism II class at Hazelwood East High School in St. Louis, Missouri composed the tales about their friends’ encounters with youngster pregnancy and the effect of the separation. Whenever they distributed the articles in the school-supported and financed paper The Spectrum, the chief erased the pages that contained the tales preceding distribution without telling of the understudies.
Asserting that school disregarded their First Amendment privileges, the understudies took their case to the U.S. Locale Court for the Eastern District of Missouri in St. Louis. The preliminary court decided that the school had the position to eliminate articles that were composed as a component of a class.
The understudies spoke to the U.S. Court of Appeals for the Eighth Circuit, which turned around the lower court, observing that the paper was a “public discussion” that stretched out past the dividers of the school. It concluded that school authorities could control the substance just under outrageous conditions. The school engaged the Supreme Court of the United States.
Decision and Reasoning
In a 5-3 decision, the U.S. High Court held that the chief’s activities didn’t abuse the understudies’ free discourse privileges. The Court noticed that the paper was supported by the school and, all the things are considered, the school had a genuine interest in the forestalling the distribution of articles that it considered unseemly and that could seem to have the imprimatur of the school.
In a particular, the Court has noticed that the paper was not expected as a public gathering wherein everybody could share sees; rather, it was a restricted discussion for reporting understudies to compose articles, liable to school altering, that met the necessities of their Journalism II class.
For this assignment: You will use ONE of you research articles from p. 13a to write your first objective summary.
Requirements:
Write, compile and run a program that works some of the functionality provided by the C++map container. Read data from a file into your map and produce various outcomes listed below via various user-defined methods. Use a menu for user friendliness.
The file spec includes for each record a last name followed by a first name for each names.
Each row value will thus serve as a key value pair for our map where the map key will be unique being the person last name and the first name will be the value for the map (wMap).
Take your names.txt file accompanying this lab and place it into your root folder along with the source provided in word document.
Include a menu to allow for the following
1. Search Person for first name (i.e., by key)
2. Remove Person (i.e., by key)
3. Update Person (i.e., to change value by key)
4. Get Person count
5. Print all People(First name first, Last name second)
6. Exit application (display message such as “Good bye/stay safe”)
Include appropriate methods that will be triggered by each menu selection by the user. Example follows for a Search routine.
