Group 1

• ICTICT401 Determine and confirm client business requirements
• ICTNWK403 Manage network and data integrity
• ICTICT408 Create technical documentation
• ICTPRG405 Automate processes
• ICTICT424 Address cyber security requirements

I NEED TUTOR FOR PYTHON EXAM

Need question answer for my my part of a paper. Please review the paper for better understand how to answer these question.

I. Requirements Checklist

A.  Technical Requirements –

– Five requirement statements setting out the system performance specifications.

B.  Security Requirements – 

– Five requirement statements covering various aspects of system, data, and transactional security.

GO16_WD_CH02_GRADER_2G_HW – Letter And Resume 1.5

Please read the the files I have attached this work is for 60$ but œil pay you on friday , but I need the work tomorrow 

Part 2: Vendor Database (MS Access)
 

As you recall, data is a collection of facts (numbers, text, even audio and video files) that is processed into usable information. Much like a spreadsheet, a database is a collection of such facts that you can then slice and dice in various ways to extract information or make decisions. However, the advantage and primary use of a database over a spreadsheet is its ability to handle a large volume of data and yet allow for quick access to the information that is desired.
 

Databases are everywhere now and impact our lives in a multitude of ways. It can accurately be said that “your life is in a database” or, more accurately, in multiple databases, and information about you (a retrieval of facts about you) is easily accessible. Your shopping history, credit history, medical history, even your driving history, is stored in one or more databases.
 

This exercise will introduce you to the basic building blocks of any database – fields, records, and files (also called tables). Although you will create a database with a single table containing a small amount of data about computer vendors, the more applicable use of databases involves the creation of many tables linked together with a common field or “key.” Regardless of the size of the database, the data is stored in the same way – in fields which are combined to create a record. And those records are stored in a file or table. The data is entered into the field via a data entry form, and the information is extracted (to answer a particular question or need) via reports and/or queries.
 

Create a vendor database and related reports and queries to capture contact information for potential PC vendors. This information will be used to populate an MS Access database.
 

This MS Access database assignment has the following parts:
 

1. a simple database table to hold vendor contact information;
2. a simple database form that can be used to enter data into the database table;
3. a simple database report that can used to present the data as information; and
4. a separate MS Word document answering questions about the database.
 

All aspects of the assignment will be evaluated according to the following criteria and overall professional, business-like appearance. This would include clear readability and formatting for both screen and print-based output.
Requirement
Points Allocated Comments
• Launch MS Access and open a Blank Access database.
• Save the new database with the following name:
“Student’s First Initial Last Name Vendor”
Example: JSmith Vendor 0.25
Create a table with all the following fields and settings:
A. Vendor ID (autonumber)
B. Company Name (text)
C. Contact’s First Name (text)
D. Contact’s Last Name (text)
E. Billing Address (text) (this is the street address)
F. City (text)
G. State (text—limited to 2 characters)
H. Zip Code (text—limited to 5 characters)
I. Phone number
J. YTD Orders (currency)
K. Preferred Vendor (Yes/No) 1.0 The Vendor ID field must be set as the primary key (*). If the Vendor ID is not the primary key, 0.5 points will be deducted. If you have properly set the Vendor ID field as the primary key, it will be numbered automatically (Auto Number).
• Name the table as follows:
Vendor Table 0.25
• Use the Form Wizard to create a form that uses all the fields from the Vendor table.
• Use a Columnar layout
• Select a theme 1.0 Let the Form Wizard guide you through the completion of the form.
• Name the form as follows:
Vendor Contact Entry Form 0.25 You should be finished with the form at this point. It is best if you allow the Form Wizard to open the form to view and enter information.
You can either use the form or enter data directly into the table.
• Enter all the appropriate data for five vendors (such as Best Buy, CDW, and CompUSA.)
• Mark at least one Vendor as a preferred Vendor.
It is important to complete all data entry prior to moving on to create the report. You should also use the table to manually review and audit all entries to ensure accuracy and consistency prior to report setup. If find any data entry errors or inconsistencies, simply go back the item in the form and make the appropriate corrections. Missing data or including data that should be ignored will result in a deduction. 1.5 When you are finished, the Vendor Table should contain all the contact information for five vendors. You may need to create fictitious information for contact names –other field information should be available from the company website.
The form will automatically populate the Vendor ID for you because this is your primary key. Vendor Names will be your five vendors.
Use the Report Wizard to create a report for the database that uses the following fields:
 

• Vendor Name
• Contact First and Last Name
• Complete Address (Street, City, State, Zip)
• Phone Number 1.0 Let the Report Wizard guide you through the completion of the report.
 

Make sure that you do not select the Product ID field.

 In 250 words or more, answer the following.

FOR loops have some of the same components as a WHILE loop but are extremely useful when you know exactly how many times you need to do something.  What do you see as the primary reason to use a for loop? Does it have any limitations?  How do you write one? 

Write a C++ program that asks the user for the number girl scouts in their troop and the number of weeks they sold boxes of cookies.The program should collect the following information using nested for loops:•The first name of each girl scout.•The number of boxes of cookies sold each week by each girl scout.The program should calculate and display the following information:•The total boxes of cookies sold by each girl scout.•The total boxes of cookies sold by the entire troop.•The average boxes sold per week by the troop.•The name of the girl scout who sold the most cookies.Cookie Counter ProgramLab 7 –More LoopingSample Program Output on the next page.Make sure to include the following input validation:•Validate that the number of girl scouts is greater than zero.•Validate that the number of weeks sold is greater than zero.•Display an error message if either condition above occurs.f

1. Design and implement a stringed musical instrument class using the following guidelines:
a. Data fields for your instrument should include number of strings, an array of string names representing string names (e.g. E,A,D,G), and boolean fields to determine if the instrument is tuned, and if the instrument is currently playing. You are welcome to add additional data fields if you like.
b. A constructor method that set the tuned and currently playing fields to false.
c. Other methods 1) to tune the instrument, 2) to start the instrument playing, and 3) to stop the instrument from playing.
d. Other methods as you see fit (Add at least one unique method).
2. Create a UML class diagram using a diagram tool (e.g. PPT, Visio) of your choice. Prepare the diagrams and place them in a word document along with a brief description of each of your classes.
3. Create Java classes for your instruments. Be sure that your code matches your design specifications and some minimal functionality is included. For example, if you called the violin.play() method, you should at least print that the violin is playing. Similar functionality should be supplied when you stop playing, tune or call any of your methods. For example:
public void playviolin() {
System.out.println(“The violin is now playing.”);
}
4. Write the output from your Instrument class methods to a text file that a user entered from the command line arguments (e.g. java Mynamep3tst myfilename.txt). This allows your program to accept filenames from the user via a command line argument.
5. Finally, create a Java test class that simulates using your instrument class. In your test class be you should at a minimum: a) Construct 10 instances of your instrument, b) tune your instruments, c) Start playing your instrument, d) Call your unique method, and e) Stop playing your instruments. (Hint: Arrays and Loops will make your job easier and result in more efficient code!)
6. Your programs should compile and run without errors.
7. Be sure to test your program carefully. Provide a list of comprehensive test cases used to validate your application and include these test cases in your word document containing your UML diagrams and descriptions. Similar to Project 1, your test data can be shown in a table that includes input data, expected output, actual output and pass/fail results from the test.
Submission requirements:
Your deliverables include a Java instrument file, Java test file and a Word document. The Java instrument file should be named Yournamep3.java. The Java test file should be named Yournamep3test.java. Your word document should include your test table, and UML diagrams and descriptions and be named Yournamep3.doc.

Exp22_Excel_Ch06_Cumulative_AutoSales

Project Description:

You are the finance manager for Grossman Auto Sales. Your company offers in-house financing and as part of your duties you create reports detailing purchase options. You want to create a report to determine the optimal purchase price of a vehicle based on your customer’s budget. You also want to create one- and two-variable data tables to provide detailed payment options based on varying interest rates and down payments.

Download and open the file named   Exp22_Excel_Ch06_Cumulative_AutoSales.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

Create appropriate range names   for Purchase Price (cell C5), Sales Tax (cell C6), Down Payment (cell C7),   Months Financed (C8), APR (cell C9), Down Payment Amount (cell C12), Amount   Financed (cell C13), and Tax Owed   (cell C14). Create the range names using the Create from Selection method,   using the values in the left column.

Edit the existing name range Tax_Owed to display as Tax. Note, Mac users, in the Define   Name dialog box, add the new named range, and delete the original one.

Apply the range names to the   existing formulas and functions in the worksheet.

Create a new worksheet labeled Range Names, paste the newly created range   name information in cell A1, and then resize the columns as needed for proper   display.

Use Goal Seek to determine the   optimal purchase price to reach a $500 monthly payment with all other variables remaining   unchanged.

Start in cell E5. Complete the   series of substitution values ranging from $20,000 to $75,000 at increments   of $5,000 vertically down column E. Apply Comma Style format to the range   E5:E16 with two decimal points and preserve the thick bottom border on row   16.

Enter references to the Down   Payment Amount, Tax Owed, and Monthly Payment (Cells F4, G4, and H4) in the   correct location for a one-variable data table. Use range names where   indicated.

Complete the one-variable data   table and format the results with Comma Style with no decimal places.

Apply Custom number formats to   cell F4:H4 that displays the text Down Payment in cell F4, Tax in G4, and Monthly Pmt in cell H4. Bold and center the   headings and substitution values.

Copy the purchase price   substitution values from the one-variable data table and paste the values   starting in cell J5. Adjust the width of column J as needed.

Type 5000 in cell K4. Complete the series of substitution   values from $5,000 to $15,000 at $5,000 increments. Apply Accounting Number   Format to the range K4:M4.

Enter the reference to the   Monthly Payment function in the correct location for a two-variable data   table.

Complete the two-variable data   table and apply Comma Style to the range K5:M16 with no decimal places.

Apply a Custom number format to   make the formula reference display as the descriptive column heading Purchase   Price. Bold the   headings in cells J4:M4.

Create a scenario named Best Case, using Purchase Price and   Months Financed. Enter these values for the scenario: 40000, and 36.

Create a second scenario named Worst Case, using the same changing cells.   Enter these values for the scenario: 50000, and 72.

Create a third scenario named Most Likely, using the same changing cells.   Enter these values for the ­scenario: 45000, and 60.

Generate a Scenario Summary report   based on Monthly Payment. Be sure to use best practice in formatting the   report by deleting Column A:B, Row 1, and the Current Values column.

Load the Solver add-in if it is   not already loaded. Set the objective to calculate a Monthly Payment of $500.

Use Purchase Price and Months   Financed as changing variable cells.

Set constraints to ensure the   Purchase Price is less than or equal to $50,000, greater than or equal to $30,000, and a whole number. 

Set constraints to ensure months   financed are less than or equal to 72, greater than or equal to 24, and a whole number.

Solve the problem and save the   results. Generate the Answer Report. If you get an internal memory error   message, remove Solver as an add-in, close the workbook, open the workbook,   add Solver in again, and finish using Solver.

Save and close   Exp22_Excel_Ch06_Cumulative_AutoSales.xlsx. Exit Excel. Submit the file   as directed.