Paper

need help with paper

Fundamentals of database sytems

Answer the questions in the screenshot with the references pdfs and Internet (do not add extra pages for reference) The Student name id and course name can be written in the fist page itself don’t do it in extra pages)

Exp19_Excel_Ch01_HOEAssessment_OKOS

Exp19 Excel Ch01 HOEAssessment OKOS

Excel Chapter 1 Hands-On Exercise Assessment – OKOS

Project Description:

As manager of OK Office Systems (OKOS), you want to calculate the retail price, sale price, and profit analysis for selected items on sale this month. You will calculate sale prices based on discount rates. Finally, you will calculate the profit margin to determine the percentage of the final sale price over the cost. You will adjust column and row settings, move and copy data, format the worksheet, and apply Page Setup options.

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

Find all occurrences of Amount and replace them with Price.

You want to use Auto Fill to enter a series of codes representing the year (2021), the month (09), and a number.

Enter 2021-09-100 in cell B6 and use Auto Fill to complete the sequence for the range B7:B11.
Hint: Use the fill handle and the Auto Fill Options to fill the series.

The OKOS workbook contains spelling errors that need to be corrected.

Use Excel to check and correct the spelling errors in the worksheet.
Hint: The Review tab contains the Spelling tool.

The worksheet contains the cost and retail prices. You want to calculate the amount of markup.

In cell D6, enter a formula to calculate the markup amount, which is the difference between the retail price and cost. Copy the formula to the range D7:D11.
Hint: The formula is =Retail Price – Cost.

Each item is on sale this week. The sale price is X percent off the retail price. You need to calculate the sale price.

In cell G6, calculate the sale price. Copy the formula down the range G7:G11.
Hint: The formula is either =Retail Price – (Percent Off * Retail Price) or =Retail Price * (1- Percent Off).

The profit margin is the ratio of the net profit as a percentage of revenue. The formula first calculates the net profit between the sale price and the cost and divides that by the sale price.

In cell H6, enter a formula to calculate the profit margin. Copy the formula to the range H7:H11.
Hint: The formula is =(Sale Price – Cost) / Sale Price

The filing cabinets are out of stock; therefore, you should remove that product from the list of products on sale.

Delete row 8 that contains the filing cabinet data.
Hint: Delete is on the Home tab.

You want to insert a row to display the heading Furniture above the furniture products.

Insert a new row 8 and type Furniture in cell A8. Bold the word Furniture in cell A8.
Hint: Insert is on the Home tab or on the shortcut menu.

Column A is too narrow for the product names. You want to increase the width.

Increase the width of column A to 28.00.
Hint: Format is on the Home tab or you can drag the column border.

The 32″ Curved Monitor product is below the Furniture heading. This product belongs in the Electronics area. You will move the monitor product row to be above the Furniture heading.

Insert a row above the Furniture heading, cut the 32″ Curved Monitor row, and paste it in the range A8:H8.
Hint: Insert, Cut, and Paste are on the Home tab.

The worksheet title should stand out prominently on the worksheet.

Merge and center the title over the range A1:H1, apply the Accent 1 cell style, and change the font size to 14.
Hint: Merge, Cell Style, and Font Size are on the Home tab.

The column headings on row 4 should be formatted to improve the appearance of the worksheet.

Wrap text and horizontally center the headings in the range A4:H4. Apply Blue, Accent 5, Lighter 80% fill color to the range A4:H4.
Hint: Wrap Text, alignment, and fill color options are on the Home tab.

To distinguish the product names from the category headings Electronics and Furniture, you will indent the product names.

Indent twice the product names in the ranges A6:A8 and A10:A11.
Hint: Indent is on the Home tab.

You want to display the dollar signs for the monetary amounts and then decrease decimals if all amounts are whole dollars.

Apply Accounting Number Format to the ranges C6:E11 and G6:G11. Select the range C6:C11 and decrease the decimal places to show only whole amounts.
Hint: Accounting Number Format and the option to decrease decimals are on the Home tab.

The Percent Off and Profit Margin values should be formatted with percent signs.

Select the ranges F6:F11 and H6:H11. Apply Percent Style and increase the decimal points to show one digit to the right of the decimal point.
Hint: Number formatting is on the Home tab.

You want to apply a border around the worksheet data to look professional when printed.

Select the range A1:H11 and apply Outside Borders.

Because the worksheet contains more columns than rows, it would look better in landscape orientation.

Change the orientation to landscape.
Hint: Orientation is on the Page Layout tab.

You continue to apply Page Setup options to prepare the worksheet to be printed, if needed.

Set a 1-inch top margin and select the option to horizontally center the data on the page. Apply the option to fit the worksheet data to one page.
Hint: Use the Page Layout tab.

It is important to provide identification information in a footer of the worksheets. In particular, the textbook series name, the worksheet name, and the file name to help identify the worksheet.

Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side.
Hint: The Header & Footer option is on the Insert tab or through the Page Setup dialog box.

To preserve the original data, you make a copy of a worksheet so that you can manipulate the data or if you want to review the formulas.

Rename Sheet 1 as September. Copy the September sheet to the right and rename the copied sheet as Formulas.

You want to display the formulas and set print options so that it will be easier to read and interpret the rental formulas on a printout, if needed.

Display formulas on the Formulas sheet. Select the options to print gridlines and headings.
Hint: Use the Formulas tab and the Page Layout tab to set options.

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

assembly programming

project 2 is introduced at page 201

must be in assembly language!!!!!

threat modeling

By the end of this week, you should be able to:

Describe threat modeling
Identify several security models
Explain public key infrastructure

Threat Modeling

A new medium-sized health care facility just opened and you are hired as the CIO. The CEO is somewhat technical and has tasked you with creating a threat model. The CEO needs to decide from 3 selected models but needs your recommendation. Review this week’s readings, conduct your own research, then choose a model to recommend with proper justifications. Items to include (at a minimum) are:

User authentication and credentials with third-party applications
3 common security risks with ratings: low, medium or high
Justification of your threat model (why it was chosen over the other two: compare and contrast)

You will research several threat models as it applies to the health care industry, summarize three models and choose one as a recommendation to the CEO in a summary with a model using UML Diagrams (Do not copy and paste images from the Internet). In your research paper, be sure to discuss the security risks and assign a label of low, medium or high risks and the CEO will make the determination to accept the risks or mitigate them.

Your paper should meet the following requirements:

Be approximately four to six pages in length, not including the required cover page and reference page.
Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Discussion 12- Legal

Assigned Readings:Chapter 15. Business and Intellectual Property Law.Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

What are the requirements to obtain a trademark? What federal acts regulate obtaining trademarks?
Explain the differences in patents, copyrights, and trademarks, including the length of each and examples of each.

[Your post must be substantive and demonstrate insight gained from the course material. Postings must be in the student’s own words – do not provide quotes!]

Text-

Title: Business

ISBN: 9780357447642

Authors: Marianne M. Jennings

Publication Date: 2021-01-01

Edition: 12th Edition

Week 6 Assignment

Please share (2 to 4 paragraphs) on what you learned when you read chapter 11 along with Overview of Mobile Forensics (.PDF file) and identify what makes this different form acquiring computers in the traditional sense.THENPlease share (2 to 4 paragraphs) on what you learned when you read Developing Processes for Mobile Forensics (.PDF file)THENPlease share (2 to 4 paragraphs) on what you learned when you read Future of Mobile Foresics (.PDF) file and identify if you thought the author may have missed anything as well as your own thoughts – what did you learn!?THEN Please share answer the following questions (2 to 4 paragraphs):

What is the difference between Tor, VPN, and proxy servers?
How might you perform digital forensics against each one of these three areas if you are asked to identify data of interest?
For each of these areas, what do you feel is important for an investigator to know?

Why did I assign this?As an investigator you need to be familiar with how mobile devices are hugely different from preservation and collection of computers!

Course_Related_Online

Correlate your job responsibilities with the course outcomes listed below. 300 Words. APA format

Job Responsibilities

• As an Oracle ERP Test Lead was responsible for managing 6 resources who were part of the Oracle testing team

• Able to extract back-end data using SQL/Toad queries

• Tested sales cycles by implementing Oracle Configure Price Quote (CPQ) solutions effectively.

• Involved in Integration testing using various SFTP/SOA Middleware.

• Validated SOAP UI and Restfull API services

• Involved in developing Test Plans and Test cases for the entire functionality.

• Worked closely with Developers and Cross-Functional teams for different issues.

• Flow Testing for Oracle SCM Modules (AR, AP, OM, CM, INV, PO, GL) to make sure flow is working without any issues.

• Tested B2B, B2C and B2E order flow.

• Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from oracle database.

• Written Standard test scripts for Oracle Order to Cash O2C Modules and Procure to Pay P2P Modules

• Tested EDI Batches from OTM to Oracle

• Tested database objects like tables, views, sequences using SQL/PLSQL.

• Done Field by Filed comparison of OTM and Oracle Data

• Responsible for Test Plan Preparation, Test Strategy Preparation, Team Meetings Facilitation, Defect Tracking Facilitation, Report bugs, etc.

• Analyze, design, prototype, configure, test, document, and implement new or modify existing software to support various business processes.

• Assist key users in testing new functionality, documenting and retaining ERP knowledge.

• Documented testing results and updated the same for verification to the management.

• Test a new enhancement for a Business Process.

• Involved End to end testing for business process using all application tiers.

Course Outcome

1. Explain the foundations of mathematical study.

2. Construct mathematical proofs.

3. Demonstrate a deeper understanding of numbers and number structures.

4. Communicate mathematically in written form.

5. Think critically and logically about mathematics and with mathematics.

6. Demonstrate quantitative literacy by interpreting, planning, and solving real world problems.

7. Identify and explain problems relating to discrete data packets with application to Computer Science.

8. Identify and explain problems relating to rates of change (derivatives), accumulation (integrals), error analysis, and convergence with application to Computer Science.

Solved Carpenter Family Camp

Shelly Cashman Access 2016 | Modules 1–3: SAM Capstone Project 1a

Carpenter Family Camp

CREATING TABLES, QUERIES, FORMS, AND REPORTS IN A DATABASE

GETTING STARTED

• Open the file SC_AC16_CS1-3a_FirstLastName_1.accdb, available for download from the SAM website.

• Save the file as SC_AC16_CS1-3a_FirstLastName_2.accdb by changing the

“1” to a “2”.

o If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

• To complete this Project, you will also need to download and save the following support file from the SAM website:

o Support_SC_AC16_CS1-3a_Activity.xlsx

PROJECT STEPS

1. Carpenter Family Camp operates summer camps for youth as well as families on a lake in Maine situated near the coast. The camp includes activities for families as well as separate activities for adults and children. Optional adventures to nearby attractions are also available.

Create a new table in Datasheet View with the following options:

a. Rename the default primary key ID field to AdventureID, and then change its data type to Short Text. (Hint: The AdventureID field should remain the primary key.)

b. Change the field size of the AdventureID field to 4.

c. Add a new field with the name AdventureName and the Short Text data type.

d. Add another field to the table with the name AdultPrice and the Currency data type.

e. Add a fourth field to the table with the name ChildPrice and the Currency data type.

f. Save the table using Adventure as the name.

2. With the Adventure table still open in Datasheet View, change the font in the table to Arial Narrow and the font size to 12 pt.

3. With the Adventure table still open in Datasheet View, add the records shown in Table 1 below. If necessary, resize the AdventureName field so that all field values are completely visible. Save and close the Adventure table.

Table 1: Adventure Table Records

AdventureID

AdventureName

AdultPrice

ChildPrice

BB01

Bike & Beach

$28.00

$20.00

HR01

Horseback Ride

$30.00

$25.00

WJ01

Windjammer Cruise

$45.00

$35.00

WW01

Whale Watching

$32.00

$26.00

4. Open the Reservation table in Design View and make the following changes:

a. Change the data type for the LodgingFee field to Currency.

b. Specify that the SessionID field is a Required field.

c. Save the changes to the Reservation table, and then close it. (Hint: Because you made changes to data types and field sizes, the “Some data may be lost” warning message appears. The data fits within the valid ranges, so ignore this message and continue saving the table.)

5. Open the Relationships window, and then add the Camper table to it. Create a one-to-many relationship between the ParentID field in the Parent table and the ParentID field in the Camper table. Make the relationship enforce referential integrity and cascade update related fields. Do not make the relationship cascade delete related records. Save the relationships, and then close the window.

6. Open the Counselor table in Design View and make the following changes:

a. Add a new field following the Specialty field. Assign the name CPR Certification to the field.

b. Set the data type for the field to Yes/No.

c. Set the Caption property, using CPR as the value.

d. Enter CPR certification current? as the description for the field.

e. Save the changes to the Counselor table, and then close it.

7. Open the Reservation table in Datasheet View, and then find or navigate to the record with the ReservationID field value 1700012. Change the LodgingFee field value to $140.00.

8. With the Reservation table still open in Datasheet View, apply a filter by selection to locate all records where the SessionID field value equals 1. Change the AdultPrice field value for ParentID 101 to $245.00. Change the ChildPrice field value for the same record to $215.00. Clear all filters. Save and close the Reservation table.

9. Open the Counselor table in Design View. Use the Lookup Wizard to change the Specialty field to a Lookup field. Type in the following four values (in the order shown) as the list of possible values for the field: Arts & Crafts, Land Sports, Nature Studies, and Water Sports. Limit the field values to only the items in the list, and do not allow multiple values for the field.

10. With the Counselor table still open in Design View, delete the HomePhone field. (Hint: If a message appears concerning deleting an index, continue with the deletion.) Save the Counselor table.

11. Switch to viewing the Counselor table in Datasheet View, and then change the SpecialCertification field value for Susan Kiley (who has a CounselorID field value of KS01) to Wilderness First Aid. Close the table.

12. Import the data from the file Support_SC_AC16_CS1-3a_Activity.xlsx, available for download from the SAM website. Append the records to the Activity table. Do not create a new table, and do not save the import steps.

13. Carpenter Family Camp requires all campers to submit a signed liability waiver from their parents. Create an update query to change the Waiver field value to No for all records currently in the Parent table. Run the query, and then save it using Waiver Update Query as the name. (Hint: 21 records will be updated by this query.) Close the query.

14. Use the Simple Query Wizard to create a query based on the Counselor table with the following options:

a. Include the CounselorID, FirstName, LastName, and CellPhone fields (in that order).

b. Save the query with the name Counselor Contact Query, and then close the query.

15. Create a new query in Design View based on the Counselor and Counselor_Session tables with the following options:

a. Include the SessionID field from the Counselor_Session table.

b. Include the LastName, FirstName, and CellPhone fields (in that order) from the Counselor table.

c. Sort the records in ascending order based on the SessionID field and then by the LastName field.

d. Save the query using Session Contact Query as the name.

e. Run the query, and then close it.

16. Use the Crosstab Query Wizard to create a crosstab based on the Reservation table with the following options:

a. Use only data from the Reservation table in the query.

b. Use SessionID as the row heading.

c. Use Children as the column heading.

d. Use a sum of the ChildPrice field as the calculated value for each row and column intersection in the crosstab query.

e. Save the crosstab query using Session-Child Crosstab as the name.

f. View the query, and then close it.

17. Create a new query in Design View based on the Reservation table and the Session 1 Payments table with the following options:

a. Select the ParentID field from the Reservation table.

b. Select the ReservationID, SessionID, AdultTotal, ChildTotal, and Lodging fields (in that order) from the Session 1 Payments table.

c. Move the ParentID field to the right of the SessionID field.

d. Add a calculated field after the Lodging field with the alias TotalFees that calculates the sum of the AdultTotal, ChildTotal, and Lodging fields.

e. Save the query using Session 1 TotalFees Query as the name.

f. View the query, confirm that it matches Figure 1 below, and then close it.

Figure 1: Session 1 TotalFees Query

Open the States Query in Design View, and then add the criteria to select only those records with a State field value of NY or NJ. Save and run the query, and then close it. (Hint: This query should return records that meet one or more of the query conditions.)

19. Open the Younger Males Query in Design View, and then add the criteria to select only those records with a Gender field value of M and an Age field value of less than 10. Hide the Gender field. Save and run the query, and then close it. (Hint: This query should only return records that meet both of the query conditions.)

20. Open the Sessions Total Query in Design View, and then modify it by adding Totals to the query. For the SessionID field, set the Total row to Group By. For the ReservationID field, set the Total row to Count. Save and run the query, and then close it.

21. Create a Split Form based on the Parent table. Save the form as Parent Update Form, and then close the form.

22. Open the Parent Update Form, and then add a new record to the Parent table, using the values shown in Figure 2 below. Close the form.

Figure 2: New Record for the Parent Update Form Figure 3: Adventure Report

24. Use the Report Wizard to create a new report based on the Parent table with the following options:

a. Include the ParentID, FirstName, LastName, HomePhone, and CellPhone fields (in that order) from the Parent table.

b. Use no additional grouping in the report.

c. Sort the report in ascending order by the ParentID field.

d. Use the Tabular layout and Portrait orientation for the report.

e. Assign the name Parent Contact Report to the report.

f. Preview the report to ensure that it matches Figure 4 below, and then save and close the report.

Figure 4: Parent Contact Report

a. Remove the City and State columns from the report.

b. Add a Totals row that calculates the sum of the values in the Adults column and the sum of the values in the Children column. If necessary, expand the size of the total control so that it appears completely.

c. Change the title of the report using Session 1 Camper Report as the name.

d. View the Session 1 Report in Report View, confirm that it matches Figure 5 below, and then save and close the report.

Figure 5: Session 1 Report