Unit 7 Assignment: Creating Select Queries Outcomes addressed in this activity:

Unit 7 Assignment: Creating Select Queries
Outcomes addressed in this activity:
Unit Outcomes:
Describe simple SELECT statements with one table.
Use SELECT statements to retrieve data from one table.
Course Outcome:
IT163-4: Use Structured Query Language (SQL) to manage data.
Purpose
You will practice using SQL in the Access environment. You will examine data from a sample database using simple, single table select queries.
Assignment Instructions
Using the model car sample database provided, create queries to demonstrate a variety of simple, single table select query functionality to include selecting more than one field, using the where clause, using alias’, working with dates, sorting and using relational and logical operators.
Open the sample database.
For this assignment you will use this sample database: IT163_ModelCarSampleDatabase.accdb
Create the five queries as detailed below. You may create these queries using the query design view or you may manually write the SQL code in the SQL view.
a. Select the Company field from the Customers table.
Save as QueryA. Run the query to see the subset of data produced. Verify that the results are correct.
Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 8: “Selecting Data with Queries / Creating a Query / Working with Query Fields / Adding Criteria to Your Queries / Saving a Query”
b. Modify QueryA to sort the output in alphabetical order.
Save as QueryB. Run the query to see the subset of data produced. Verify that the results are correct.
Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
c. Select the Description, Cost and QtyInStock fields from the Products table for all records with category “Trucks.” Sort by cost from lowest to highest cost.
Save as QueryC. Run the query to see the subset of data produced. Verify that the results are correct.
Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 8: “Selecting Data with Queries / Creating a Query / Working with Query Fields / Adding Criteria to Your Queries / Saving a Query”
d. Select the OrigCustDate, FirstName, and LastName from the Contacts table for all records with the state of Texas (“TX”) and OrigCustDate of January 1, 2013 or later. Display first and last name together as Customer Name.
Save as QueryD. Run the query to see the subset of data produced. Verify that the results are correct.
Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 9: “Using Operators and Expressions in Access / Introducing Operators / Using Operators and Expressions in Queries / Using Multiple Criteria in a Query / Entering Criteria in Multiple Fields”
e. Select the Company, CurrentBalance and State from the Customers table for all records with a current balance greater than zero and a state of New York or Connecticut. Sort by CurrentBalance from highest to smallest value.
Save as QueryE. Run the query to see the subset of data produced. Verify that the results are correct.
Document your results for submission.
In a Word document, copy each of the questions from above in BOLD. After each question, place the SQL code. After the SQL code, place a screenshot of the successful execution from Access showing the correct results were garnered when you ran each query. Start a new page for each question.
Hint: you can copy your SQL code as plain text from the SQL view. Right-click your query and choose SQL View or use the View option from the ribbon.
Example Query Output:
IT163_Example_Output_1.docx
Assignment Requirements
Submit a single Word document with all of the documentation for each query as described in the assignment instructions.
Directions for Submitting Your Assignment
Submit the completed document to the Unit 7 Assignment Dropbox by the deadline. Save the file as: IT163_Unit7_Lastname.docx.
Review the rubric before beginning this activity.

The expected output for this take-home is as follows: ● A report (powerpoint) th

The expected output for this take-home is as follows:
● A report (powerpoint) that describes your findings. It should take the reader about 10 minutes to read through your report
● The Python or R code you used to complete your analysis. Please show your work and include all steps that you performed along the way (eg EDA). Please share the .ipynb or .R file in your submission.
What we are looking for:
● Good code quality.
● Good communication skills. A clear narrative around the results you are finding. An explanation of the methodology choices that you made and why.
● Strong sense of ownership in how you approach the problems. Pretend this was your real job. How would you approach the problems in that case?

This econometrics assignment consists of creating a multiple linear regression m

This econometrics assignment consists of creating a multiple linear regression model with commentary on the findings and results of each step of the model. The variables as well as the data can be freely chosen: it is important that all the data comes from a reputable source.
Attached you can find two Powerpoint presentation of project that were made beforehand, with the relative model inside of them. If it is possible, I would prefer a document where there are screenshots of the relative graphs and calculations in R, as it is shown in the two examples.
I hope I’ve been clear enough, if not do not hesitate to contact me and I cannot thank you enough for this 🙂

Unit 6 Assignment: Data Validation and Security Outcomes addressed in this Assig

Unit 6 Assignment: Data Validation and Security
Outcomes addressed in this Assignment:
Examine data validation concepts.
Use data validation in a form in Microsoft Access.
Apply Encryption to an Access database.
Course Outcome:
IT163-3: Create forms to input data.
Purpose
The form is the mechanism for transferring data from the user into the program and back again. Understanding how the form is used and how data is validated is essential to building an interactive database application. In this assignment, you will extend your knowledge of forms to include working with a form with subform, the use of controls in a form and data validation.
Assignment Instructions
You will create a form for the Customer table with a subform for the Customer Contacts table so that data can be entered into both tables at the same time. You will also add controls and apply data validation to several fields in the Customer form. You will also apply encryption to password protect your database.
Open the sample database.
For this assignment you will use this sample database:
IT163_ModelCarSampleDatabase.accdb
You will apply encryption to your database and use the password “PurdueGlobal.”
For extra help see Optional Resources for Assignment under the Academic Tools, Library link:
Reference:
Encrypt a database by using a password
https://support.microsoft.com/en-us/office/encrypt-a-database-by-using-a-database-password-12aa0e5c-34c6-4957-af3b-b5f5cfa9a766
Create a form with subform for the Customer (main form) and Customer Contacts tables (subform).
Reference:
Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 19: “Working with Form Controls / Working with Subforms”
Name the new form with subform CustomerContactSubForm and save it as a new form object in your database.
You will add validation and controls for the Customer data as follows. Use the validation rule with validation text to ensure a custom error message is displayed when a rule is violated where appropriate:
Company – Validate that field is not left blank
Address – Validate that field is not left blank
City – Validate that field is not left blank
State – Create a dropdown box control (include at least three states in the list)
ZipCode – Validate that field is at leave five numeric digits
Phone – Validate that field is not left blank and add an appropriate input mask
Fax -Validate that field is not left blank and add an appropriate input mask
Email – Validate that field is not left blank
WebSite -Validate that field is not left blank
Note: No validation required for the remaining fields.
Reference:
Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 19: “Working with Form Controls / The Combo Box and List Box controls”
Ulrich, L. A. & Cook, K. (2019). Access 2019 for dummies. Wiley.
Chapter 7: “Types, Masks, and Triggers”
For extra help see Optional Resources for Assignment under the Academic Tools, Library link:
Restrict Data Input by Using Validation Rules
https://support.microsoft.com/en-us/office/restrict-data-input-by-using-validation-rules-b91c6b15-bcd3-42c1-90bf-e3a0272e988d
Add one new record to the Customer table and one new record to the CustomerContacts table using the form with subform. Use your own last name in the Company field in the Customer table entry and in the Last Name field in the CustomerContacts table entry. The other data can be of your own choosing.
Save your Microsoft Access database file for submission.
Assignment Requirements
For this assignment, you will submit your entire Microsoft Access database.
Directions for Submitting Your Assignment
Name your file according to this convention: IT163_Unit6_Lastname.accdb (use your own last name of course). Submit your completed assignment to the Unit 6 Dropbox by the deadline.
Review the rubric before beginning this

Purpose The purpose of the final project is to: give you a chance to research a

Purpose
The purpose of the final project is to:
give you a chance to research a topic that is of personal interest to you
allow you to process the data for this project using the Python skills you have developed during the course
Final Project Demo
Video includes review of where to find data for your project. Also shows an example project for you to review. ( I will put all the screenshots for video in additional materials)
Telling a Story With Data
Your final project should be a portfolio piece that you can use to demonstrate the skills you’ve learned in this class. As such you should make sure that you are researching a topic that interests you and that you can accomplish in the time allotted.
Final Project Package (150 pts)
The final project package is the complete bundle of all your scripts, presentation materials, data and even notes that you have brought together to finish this project. Because each project is very individual it is expected that each project package will contain different artifacts; however, at a minimum your project package should include:
(50 pts) a python script (data_parsing.py) in which you parse two different data sources (if you parsed your data in Jupyter Notebooks you don’t need a separate script, just make sure you label a section in your notebook and provide additional details about why you chose the data sources that you chose)
(30 pts) scripts (data_cleaning.py) that you used for cleaning your data (if you cleaned your data in Jupyter Notebooks you don’t need a separate script, just make sure you label a section in your notebook and provide any additional textual clarification for why you chose the approach you took)
(50 pts) a data analysis script (data_analysis.py) that’s shows how you calculated three different analytical techniques such as correlation coefficients, averages, and/or counts of data (if you did your data analysis in Jupyter Notebooks you don’t need a separate script, just make sure you label it clearly in your notebook and provide textual clarification for why you used the analytical techniques that you did)
(10 pts) presentation materials – if you are using a jupyter notebook then you should include an export of the ipynb file. If you are using an external website such as Django or Adobe Spark then include a simple text file with the url in it.
(10 pts) a copy of the datasets – if the datasets are too large to include in the package then some sample data will be fine (named data.csv, data.json or data.xml, if multiple files are included then just append a number to the end such as data2.json).
Presentation Requirements (50 pts)
Your presentation should have five major sections, each section is telling a piece of the overall story you are telling with your data. You will be posting your presentations as a video in the FINAL PRESENTATIONS discussion. Use the provided directions for uploading your video using the Kaltura tools.
You should plan for the presentation to take 3-5 minutes and cover the following:
Background of your question(10pts)
State clearly why you chose the question you did and what the question is
The data sources that you found that helped you answer your question
Why these data sources (as compared to others) helped you to answer the question
Difficulties in taming data(10pts)
Identify the biggest hurdles that you had to overcome as you processed your data. Difficulties could include programming challenges, messy or non-standardized data, or problems with finding useful data.
Overcoming the hurdles(10pts)
Demonstrate how you overcame each of the hurdles that you encountered in #2.
Please show some code examples and describe how they helped you tame the data.
Results and Major Findings(10pts)
Describe the major findings that you discovered in your data. In this section you should present the statistics that you calculated for your data. Use 2-3 graphs to highlight your major points. Each graph should have introductory text that describes what it is showing and text that follows that describes why the finding is significant.
Next Steps(10pts)
In this section you will describe what you would have done if you had more time or resources available to you. If you were unable to answer all of your question then you can mention that here.
Assessment Criteria
For the presentation portion you will be graded on how well you follow the major sections of telling a story with data. Presentation materials should contain text to describe each of the sections that is appropriate to the medium (e.g., powerpoint may be less wordy than something like Jupyter Notebooks but both should adequately cover the major points).
By the way:
1. I will appreciate if you write a small summary for answering the presentation questions.
2. Before this assignment, there has a proposal for this assignment, I will also put that proposal assignment instructions and answers in additional materials as reference for you to choice the topic.