1. at least 2~3 pages of study report (cover page is not countable).

2. Required (if you cannot do the simulation, at least have article review)

(1) Use Microsoft Access, MySQL, SQLite, or any available one, no matter commercial/freeware/online to create database, tables, and configuration of the management system. 

(2) demonstrate the creation, processes, and configuration info in your report by using screenshot or substitute method to display your process/result.

(3) please also have a short introduction of the used tool and a short concluding in your report.

free tool reference website: https://www.w3resource.com/index.php

If you use Mac, you may install some freeware from https://business.tutsplus.com/articles/best-free-open-source-mac-database-software-2018–cms-31480.

If you can not get any available software for installing and have simulation, you can have some related article review for substitution. It is acceptable, too

Excel_2G_Inventory

Excel_2G_Inventory

Project Description:

In the following project, you will edit a worksheet that summarizes the inventory of bulbs and trees at the Pasadena facility.

Steps to Perform:

Step Instructions Points Possible

1 Open the Excel workbook Student_Excel_2G_Inventory.xlsx downloaded with this project. 0

2 Change the Theme to Slice. Rename Sheet1 as Bulbs and Sheet2 as Trees, and then make the Bulbs sheet the active sheet.

If the theme is not available, click Browse for Themes, navigate to your downloaded files, and select Slice.thmx. 3

3 To the right of column B, insert two new columns to create new  blank columns C and D. By using Flash Fill in the two new columns, split  the data in column B into a column for Item # in column C and Category  in column D.

5

4 Type Item # as the column title in column C and Category as the  column title in column D. Delete column B. By using the Cut and Paste  commands, cut column C—Category—and paste it to column G, and then  delete the empty column C. Apply AutoFit to columns A:F. 1

5 Display the Trees worksheet, and then repeat Steps 3 and 4 on this worksheet. 6

6 Make the following calculations in each of the two worksheets without grouping the sheets:

•In cell B4, enter a function to sum the Quantity in Stock data, and  then apply Comma Style with zero decimal places to the result.

•In cells B5:B8, enter formulas to calculate the Average, Median,  Lowest, and Highest retail prices, and then apply the Accounting Number  Format. 14

7 In each of the two worksheets, make the following calculation without grouping the sheets:

•In cell B10, enter a COUNTIF function to determine how many  different types of Tulips are in stock on the Bulbs sheet and how many  different types of Evergreens are in stock on the Trees worksheet. 4

8 Without grouping the worksheets, complete the following in each worksheet:

•  In cell G14, type Stock Level

•  In cell G15, construct an IF function to determine the items that  must be ordered. If the Quantity in Stock is less than 75 the  Value_if_true is Order. Otherwise the Value_if_false is OK. Fill the  formula down through all the rows. 8

9 Without grouping the worksheets, apply conditional formatting as follows to both worksheets:

•Apply Conditional Formatting to the Stock Level column so that cells  that contain the text Order are formatted with Bold Italic, font color  set to Automatic, and Fill color set to No Color.

•Apply Gradient Fill Blue Data Bars to the Quantity in Stock column. 4

10 In the Bulbs sheet, format the range A14:G42 as a table with  headers and apply Light Orange, Table Style Light 20. If the style isn’t  available, choose another style. Insert a Total Row, filter by Category  for Tulips, and then Sum the Quantity in Stock column. Record the  result in cell B11. 4

11 Select the table, clear the filter, Sort the table on the Item #  column from Smallest to Largest (Ascending) and then remove the Total  Row. On the Page Layout tab, set Print Titles so that row 14 repeats at  the top of each page. 3

12 In the Trees sheet, format the range A14:G42 as a table with  headers and apply Light Green, Table Style Light 19. If the style isn’t  available, choose another style. Insert a Total Row, filter by Category  for Evergreens, and then Sum the Quantity in Stock column. Record the  result in cell B11. 4

13 Select the table, clear the filter, Sort the table on the Item #  column from Smallest to Largest (Ascending), and then remove the Total  Row. On the Page Layout tab, set Print Titles so that row 14 repeats at  the top of each page, and then Save your workbook. 3

14 Group the two worksheets. Merge & Center the title in cell A1  across the range A1:G1 and apply the Title cell style. Merge &  Center the subtitle in cell A2 across the range A2:G2 and apply the  Heading 1 cell style. AutoFit Column A. 5

15 With the worksheets still grouped, center the worksheets  Horizontally, change the Orientation to Landscape, and insert a footer  in the left section with the file name. Display the Print Preview, and  then change the Settings to Fit All Columns on One Page. 

(NOTE: On a Mac, on the Page Layout tab, change the Width to 1 page.)

5

16 Save your workbook and then ungroup the sheets. Make the Trees  sheet the active sheet, and then insert a new worksheet. Change the new  sheet name to Summary and then widen columns A:D to 170 pixels. Move the  Summary sheet so that it is the first sheet in the workbook. 2

17 In cell A1, type Pasadena Inventory Summary. Merge & Center  the title across the range A1:D1, and then apply the Title cell style.  In cell A2, type As of December 31 and then Merge & Center the text  across the range A2:D2. Apply the Heading 1 cell style. 4

18 On the Bulbs sheet, Copy the range A4:A8. Display the Summary  sheet and Paste the selection to cell A5. Apply the Heading 4 cell style  to the selection. 2

19 In the Summary sheet, in cell B4, type Bulbs. In cell C4 type  Trees. In cell D4 type Bulbs/Trees. Center the column titles, and then  apply the Heading 3 cell style. 3

20 In cell B5, enter a formula that references cell B4 in the Bulbs  sheet so that the Bulbs Total Items in Stock displays in B5. Create  similar formulas to enter the Average Price, Median Price, Lowest Price,  and Highest Price from the Bulbs sheet into the Summary sheet in the  range B6:B9. 5

21 Enter formulas in the range C5:C9 that reference the Total Items  in stock and the Average Price, Median Price, Lowest Price, and Highest  Price cells in the Trees worksheet. 5

22 In cells D5, D6, D7, D8, and D9, insert Column sparklines using  the values in the Bulbs and Trees columns. Format each sparkline using  the first five Sparkline styles in the first row. 5

23 To the range B5:C5, apply Comma Style with zero decimal places,  and to the range B6:C9, apply Accounting Number Format. Center the  Summary worksheet Horizontally and change the Orientation to Landscape.  Insert a footer in the left section with the File Name. 5

24 Save and close the file, and then submit for grading. 0

Total Points 100

anyone can hellp me to solve this error in android stodio i will give you money if the error solved

i can connect with you using teamview

 Week 5 Assignment – Case Study: Transforming the Organization

Use the Week 5 Case Study Template [DOCX] to complete this assignment. 

Congratulations! The executives are taking your information system proposal seriously. In fact, they think it has the potential to transform the way the organization works.

The CIO asked you to read Too Much of a Good Thing to think about what resources you will need to get your new information system up and running. Please also view the video How Tech Companies Are Revamping the Remote-Work Experience so you can recommend a change management pattern for your company to follow. 

Write a memo to the CIO that describes how to implement your information system into the organization. Please focus on these topics:

1. How much of the implementation work can you handle? What additional resources (people, information, time, money, et cetera) will expedite the process so you don’t end up like Susie Jeffer?
2. What is your change management strategy? Provide an outline. Consider:
   • What new equipment and software are necessary?
   • What training and support will the staff need?
   • How will the staff complete their work during the transition period?
   • Do you anticipate other areas of resistance?

The CIO is very skeptical, so provide evidence that your assessment is accurate and complete. It can be difficult to admit to personal limitations!

Your memo should be 3–5 pages long.

If you use sources to support your writing for this assignment, choose sources that are credible, relevant, and appropriate. Cite each source listed on your source page at least one time within your assignment. For help with research, writing, and citation, access the library or review library guides.

This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course.

The specific course learning outcome associated with this assignment is:

• Develop an information systems solution to address an organizational problem

THE ATTACHEMENT IS JUST AN EXAMPLE

Week 4 Assignment

Hide Assignment InformationTurnitin™This assignment will be submitted to Turnitin™.Instructions

Week 4 Assignment:

In order to complete assignment #4 you will need to answer the below questions. Please complete the questions in a Word document and then upload the assignment for grading. When assigning a name to your document please use the following format (last name_Assignment #4). Use examples from the readings, lecture notes and outside research to support your answers. The assignment must be a minimum of one (1) full page in length with a minimum of two (2) outside sources. Please be sure to follow APA guidelines for citing and referencing source. Assignments are due by 11:59 pm Eastern time on Sunday.

                            (Topic Below)

Discuss the steps involved in modifying a response file.

I need help building a database

Hello,

i need this paper by 4/22 afternoon 12am.

Strictly No plagiarism please use your own words.

Topic: Digital Surveillance as an Aspect Surveillance of State

Your Research Project on the surveillance state consists of two parts:

1 a Powerpoint presentation consisting of at least 12 slides not including title and references.

2. 750 word research  paper with at least 3 sources. There should be no lists. Write in essay format not outline format. Include a meaningful title.

Do not double space.

You must include at least 3 quotes from your sources enclosing the copied words in quotation marks and cited in-line. 

There should be no lists – bulleted, numbered or otherwise. 

Write in essay format with coherent paragraphs not in outline format. Distribute your quotes among the paragraphs.

Do your own work. Zero points will be awarded if you copy other’s work and do not cite your source or you use word replacement software. 

The topic must be appropriate for graduate level. Find a topic that we covered in the course and dig deeper or find something that will help you in your work or in a subject area of interest related to the course topic. Use academically appropriate resources which you can find in the  Danforth Library Research Databases.

Make sure Strictly No plagiarism content should not match and even the reference should not match in plagiarism 

 Respond to the discussion about algorithms and their roles below using 150 words or more. 

At  the most basic level, an algorithm is simply a set of step-by-step  instructions that we utilize to accomplish a specific task. We use  algorithms every single day in our day-to-day activities: Brushing our  teeth, getting dressed, driving to work, making dinner. These daily  tasks which we complete are all composed of a set of instructions that  starts with a certain action and ends with a certain action.

In  the realm of computer programming, algorithms are utilized to enhance  the efficiency, effectiveness, and functionality of the programs we  create. Two such types of algorithms are searching algorithms and  sorting algorithms.

Sorting  algorithms are designed to sort an array of objects into a specific  order. Searching algorithms are designed to compare the elements of an  array to find a particular value within an array of objects. Just a few  examples are search engines, the sorting of a business’ online item  inventory, and sorting/searching a database of students who attend a  university.

There  are multiple approaches which people have taken to solve the issue of  sorting and searching an array of items. Two frequently used searching  algorithms are linear search and binary search. Three frequently used  sorting algorithms are insertion sort, selection sort, and bubble sort.

Each  of these types of algorithms have both pros and cons associated with  them. The main properties that we want to keep an eye on when choosing  an algorithm are memory usage, maintainability, and time complexity. It  is always best to assess the situation and to use discretion when  choosing which algorithm that we want to implement into our program.

The Board of Directors and CEO are concerned that Acme lacks any best practices for IT and technical ethics standards. Research how ethics differ between companies and cultures or region, then brief the CEO and Board about standards and tools that exist in industry that may help to resolve these concerns.

Since the company is geographically dispersed and the board resides around the globe, your presentation must be clear and concise. You must provide enough evidence to support your claims and your document must sell your findings to upper management.

14 Dicussion Boards (400 to 600 words each)