Excel_1F_Dispenser_Sales

Open the file Student_Excel_1F_Dispenser_Sales.xlsx   downloaded with this project.

Merge and center the title and   then the subtitle across columns A:F and apply the Title and Heading 1 cell   styles respectively.

Make cell A1 the active cell,   and then check spelling in your worksheet. Correct Npkin to Napkin. If any   columns are too narrow to display all the data, apply AutoFit to the column.

In cell E4, construct a formula   to calculate the Total Sales of the Condiment Rack by multiplying the   Quantity Sold times the Retail Price. Copy the formula down for the remaining   products.

Select the range E4:E10, and   then use the Quick Analysis tool to sum the Total Sales for All Products,   which will be formatted in bold. To the total in cell E11, apply the Total   cell style.
  Mac users: Instead of the Quick Analysis tool, use the AutoSum button.   Complete the step as specified. Apply bold.

Using absolute cell references   as necessary so that you can copy the formula, in cell F4, construct a   formula to calculate the Percent of Total Sales for the first product. Copy   the formula down for the remaining products.

To the computed percentages, apply   Percent Style with two decimal places, and then center the percentages.

Apply the Comma Style with no   decimal places to the Quantity Sold figures. To cells D4, E4, and E11 apply   the Accounting Number Format. Increase the column widths as needed.

To the range D5:E10, apply the   Comma Style. Increase the column widths as needed.

Change the Retail Price of the   Artisan Rack to 29.95 and the Quantity Sold of the Cheese Shaker to 425

Delete column B. 

Insert a new row 3. In cell A3,   type Month   Ending March 31 and   then merge and center the text across the range A3:E3. Apply the Heading 2   cell style.

To cell A12, apply the 20% –   Accent1 cell style.

Select the four column titles.   Apply Wrap Text, Middle Align, and Center formatting, and then apply the   Heading 3 cell style.

Center the worksheet   Horizontally on the page, and then insert a Footer with the File Name in the   left section.

Display the document properties,   and then as the Tags, type tabletop dispensers, sales
  In the Subject box, add your course name and section number. Be sure your   name displays as the Author.

Save and close the workbook.   Exit Excel. Submit the file as directed.

The Cruisin’ Fusion taco trucks are gaining popularity, fueling a demand for an order-ahead option on the website. After careful consideration, the team has decided to add shopping cart software to the Cruisin’ Fusion website to meet this demand. 

Research various shopping cart software to determine the best choice for website.

Write a 1- to 2-page blog post to launch this new feature and to reassure your customers that placing online orders is safe. Your blog post should do the following:

• Introduce the order-ahead option.
• Explain the differences between ethics, organizational policies, and laws.
• Analyze how the new shopping cart software upholds ethical trends in consumer privacy.
• Describe organizational policies that will be implemented to help protect consumer data.
• Examine ethical considerations for maintaining confidentiality and consumer data.
• Describe the various privacy laws and regulations upheld with the shopping cart software.

Please add any references used.

refer to the attached document.

Modern cryptography uses public algorithms with secret material (keys). These public algorithms are arrived at through large scale “competitions” in which people compete to produce the most secure but efficient algorithm while also inspecting each other’s algorithms (see the NIST AES selection process). In this model of a publicly known encryption algorithm, the most protected element will be the key. Do you think it would enhance security to also have a secret algorithm agreed upon with your communication partners? Defend your answer.

Parameters 

• Posts should be 250 to 300 words in length
• Must include at least one source outside of your textbook, and it should be included in the reference list at the end of the post
• All sources should be used in the content of the post using APA format

Select an organization of your choosing. This can be real or hypothetical, but it has to be realistic.  Please ensure to review the basics from chapters 1-3 and relate these basic concepts to the predictive analytics components from part two (Chapters 4-7) in your text. 

Then, select a key area of predictive analytics (from chapters 4-7) to implement in the organization. You must indicate why the predictive analytic component will be implemented by noting the problem that you are trying to solve, noting how your team will solve the problem with the selected method (this must be a thorough, in-depth analysis), and presenting your findings using a PowerPoint presentation.

For example, let us say your organization is going to implement a new Security Operations Center to address cybersecurity concerns. Explain how predictive analytics will play a significant role in this project. 

Note any Big Data Challenges or other technology or cultural challenges you may face and how you will mitigate these challenges in your presentation.

The requirements for this project are 10 to 13 pages properly APA formatted. 

Attaching Text book

EXP19_ACCESS_CH02_CAPSTONE – INTERNATIONAL FOODIES 1.0

#EXP19_ACCESS_CH02_CAPSTONE – INTERNATIONAL FOODIES 1.0 

#Exp19_Access_Ch2_Cap_Foodies 

 EXP19 ACCESS CH02 CAPSTONE – INTERNATIONAL FOODIES 1.0 

International Foodies is an importer of exotic foods from all over  the world. You landed a summer internship with the company and  discovered that their product lists and the suppliers they buy from are  stored in Excel workbooks. You offer to help by using your newly gained  knowledge of Access to create a relational database for them. You will  begin by importing the workbooks from Excel into a new Access database.  Your manager mentions that she would also like a table that specifies  food categories so that you can relate the products you sell to specific  categories in the database. You will create a table from scratch to  track categories, create relationships between the tables, and create  some baseline queries.

Start Access. Open the downloaded   Access file named Exp19_Access_Ch2_Cap_Foodies.  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.

You   will examine the data in the downloaded Excel worksheets to  determine which   fields will become the primary keys in each table and  which fields will   become the foreign keys so that you can join them in  the database.
 

  Open the Suppliers.xlsx Excel   workbook, examine the data, and close the workbook. Open the Products.xlsx Excel workbook, examine   the data, and close the workbook.
 

  You will import two Excel workbooks that contain supplier and product   information into the database.
 

  Click the External Data tab, click   New Data Source, point to From File in the Import & Link   group, and then select Excel.   Navigate to and select the Suppliers.xlsx   workbook to be imported as a new table in the current database. Select First Row Contains Column Headings.   Set the SupplierID field Indexed option to Yes (No Duplicates). Select SupplierID   as the primary key when prompted and accept the table name Suppliers. Do not save the import   steps.

Import   the Products.xlsx workbook, set the   ProductID Indexed option to Yes (No   Duplicates), and select ProductID   as the primary key. Accept the table name Products.

Change   the Field Size of the QuantityPerUnit field to 25   in Design view of the Products table. Set the Field Size of ProductID and   CategoryID to Long Integer.  Save   the changes and open the table in Datasheet view. Open the  Suppliers table in   Datasheet view to examine the data. Close the  tables.

You   will create a new table that will enable International Foodies  to associate   each product with a food category in the database.
 

  Create a new table in Design view. Add the following fields in Design view   and set the properties as specified:
 

  Add the primary key field as CategoryID   with the Number Data Type and Number assigned to a new category.   (type the period) as the Description. Set the Caption property to Category ID.
 

  Save the table as Categories.
 

   Add CategoryName with the Short Text Data Type and Name of food   category.   (type the period) as the Description. Change the field size to 15. Set the Caption property to Category Name and the Required property to Yes.

Add   CategoryDescription with the Long Text Data Type. Set the Caption property to Category Description. Switch to Datasheet view and save the   table when prompted. You will enter Category data into the table in the next step.

   You will add 8 records to the Categories table so that you have some sample   data to test in the database.
 

  Add the following records to the Categories table:

Category   ID Category Name   Category Description 

1 BEVERAGES SOFT DRINKS, COFFEES, TEAS 

2 CONDIMENTS SAUCES, RELISHES, SEASONINGS

3 CONFECTIONS DESSERTS,   CANDIES, SWEET BREADS

4 DAIRY   PRODUCTS CHEESES

5 GRAINS/CEREALS BREADS, PASTA, CEREAL

6 MEAT/POULTRY PREPARED   MEATS

7 PRODUCE DRIED FRUIT, BEAN CURD

8 SEAFOOD SEAWEED AND FISH
 

   Close the table.
 

You will create   the relationships between the tables using the Relationships window.
 

  Add all three tables to the Relationships window. Identify the  primary key   fields in the Categories table and the Suppliers table and  join them with   their foreign key counterparts in the related Products  table. Select the Enforce Referential Integrity and Cascade Update Related Fields check boxes.   Save and close the Relationships window.

You   will use the Simple Query Wizard to create a query of all products that you   import in the seafood category.
 

  Add the ProductName, SupplierID, and CategoryID fields from Products (in that order). Save the query   as Seafood Products.

Add   a criterion in Design view, to include only products with 8 as the CategoryID.

Sort   the query results in ascending order by ProductName. Run, save, and close the   query.

You   want to create a query that displays actual category names  rather than the   CategoryIDs. You are interested to know which meat and  poultry products are   imported. You will copy the Seafood Products  query and modify it to delete a   field, then add an additional table  and field.
 

  Copy the Seafood Products query   and paste it using Seafood Or Meat/Poultry   as the query name.

Open   the Seafood Or Meat/Poultry query   in Design view and delete the CategoryID   column.

Add   the Categories table to the top   pane of the query design window. Add the CategoryName   field to the last column of the design grid and set the criterion as “Seafood” Or “Meat/Poultry”.   Run, save, and close the query.

You   will create a query that identifies suppliers and their  associated products.   Because there is a relationship between the two  tables, you can now pull data   from each of them together as usable  information.
 

  Create a query in Design view that includes the Suppliers and Products    tables. The query should list the company name, contact name, phone  (in that   order), then the product name and the product cost (in that  order).

Sort   the query by company name in ascending order, then by product  cost in   descending order. Run, close, and save the query as Company by Product List.

You   determine that the data in the Company by Product List query  could be   summarized with a Total row. You will group the records by  company name, and   then count the number of products you buy from each  of them.
 

  Copy the Company by Product List query   and paste it using Summary of Company by   Product   as the query name.

Open   the Summary of Company by Product   query in Design view and delete the ContactName, Phone, and ProductCost columns.

Click   Totals in the Show/Hide group on   the Query Tools Design tab. Click in the Total   row of the ProductName field, click the arrow, and then select Count.   The records will be grouped by the company’s name and the products for each   company will be summarized.

Modify   the field name of the ProductName column as Product Count:   ProductName to make the field name more   identifiable. Click Run  in the   Results group (20 records display in the Datasheet). The  results display the   product count for each company that supplies your  organization. Save and   close the query.

Please follow the project Action Item and Provide 

summarized and answered anonymously in the next class. 

topic – cloud computing in software development

you need to write 5 pages in total on 5 research papers which i will be providing and also make a powerpoint on it(15-20 slides)

need detailed work

research paper: The paper should have the following information. 

· Title

· Introduction/Motivation

· Related work with brief overview of design, evaluation, and significant results for each paper.

· Conclusions and future work

· Reference 

Presentation:

The presentation should include the following information related to your selected topic. Each paper has about 3 slides.(total 15-20 slides)

· Introduction/Motivation

· Related work with brief overview of design, evaluation, and significant results for each paper.

· Conclusions and future work

· Reference 

Setting up a forensic lab can create many issues, some which involve the determination of lab processes and procedures, as well as determining if the analyst is capable of completing the work needed for the mission of the lab. In this assignment, conduct some research to learn some of the things needed for a forensic lab and learn why they are so important. In a report, in a single document of about 2 pages, answer the following questions:

• What are the differences between accreditation and certification?
• How are they similar and different?
• Why are both important?

Be sure you pay attention to the instructions for the deliverables. Provide a written, formal report to answer the questions. Support your report with the sources used. Use the following for citing sources and document it uses APA (American Psychological Association) style for the sourcing information (References) in the body.

Please find the attached.