Enterprise Data Management and Administration

 

  1. How information systems are transforming business and their relationship to globalization – 1 page
  2. How systems serve the different management groups in a business – 1 page
  3. Features of organizations managers need to know about to build and use information systems successfully. The impact of information systems on organizations – 1 Page 
  4. How information systems can support different global business strategies – 1 Page

MS Access

 

  1. Describe Microsoft Access and its components (tables, relationships, forms, queries, reports).
  2. Distinguish key differences between ACCESS and EXCEL.
  3. Give a brief overview of the case study.
  4. Evaluate the ACCESS features that enabled Ken Steward to develop the daily product inspection database without programming experience or expertise.
  5. Explain the responsibilities of a database administrator as they relate to assuring data security and integrity.

 

Writing Requirements

  •  4-5 pages long. Double Space.
  • Must have an introduction with a clear thesis statement, three to four main points, and a conclusion
  • Conduct research to find relevant information using reliable sources to support your views.
  • Use at least 2 academic books and 3 scholarly articles from a library database or software manufacturer’s website.
  • Use APA style for in-text citations, and references
  • Use the Databases and APA template located in the Student Resource Center to complete the assignment.

Excel_BU02_PS1_Advertise

YO19_Excel_BU02_PS1_Advertise

     

Start Excel. Download and open   the file named Excel_BU02_PS1_Advertise.xlsx.   Grader will automatically add your last name to the start of the filename.   Save the file to the location where you are storing your files.

 

 

On the GuestData worksheet, in   cell H2, add a COUNTA function to determine the number of months listed in cell   range A6:A17.

 

 

In cell J2, add a DATEDIF function to calculate the survey duration   in years using the 2020 Fiscal Start date and 2021 Fiscal Start date.

 

Assign the named range Season to cell range L6:M17.

 

 

In cell range C6:C17, add a   VLOOKUP that will look up the value in column B and then return the exact   season match of Low, Mid, or High based on the value in column B. Use the   named range Season in the formula.

 

 

To count the number of seasons   in cell B22, enter a COUNTIF function that counts the Seasons in cell range   C6:C17 that meet the criteria in cell A22. Copy the formula through cell B24.   

 

To total the number of guests   surveyed by season in cell E22, enter a SUMIF function that sums the total   surveyed in J6:J17 if it meets the criteria in cell D22. Use appropriate   absolute referencing to copy the formula through cell E24. 

 

In cell range D19:J19, calculate   the averages for each column with a rounded (not formatted) value to zero   decimal places.

 

Intro To Networking: Assignment 2

  

Must be one full page. At least (2) APA reference. 100% original work. no plagiarism. Attached is the assignment instructions for better viewing.

· Congratulations, you have been chosen to build out a network for a new facility for your company, ACME, Inc.

· Office Schematic, (ATTACHED) each office is approximately a 10’x10′ space with 10′ ceilings. Building is roughly 125’x150′.

· Each office should contain two network ports minimum, one for Voice and one for Data. Room B will serve as your network closet.

· You will need to provide the following items in your submission:

o Estimated Purchases list (some examples below)

§ Switches

§ Cable

§ Port plates

§ Punch Boards

§ UPS and Power

§ Etc.

o A timeline of installation (*estimated)

o Chosen Typology (*estimated)

o Basic Network configuration (*estimated)

o Remember to justify your choices

o Your proposal should answer the questions above. If you have experience in networking, there are additional things you would “want”, but hold on those till later assignments, as the assignments build upon one another. *NOTE* This means you may reuse information from this assignment in future assignments as well, and I am granting you a waiver of not citing yourself in those assignments.

· Assignment must be in a Word document. The numbers are going to be rough estimates, that is understood. Pricing for purchases and labor can be based off of pricing from online resources.

· Required Format

· A timeline of installation (*estimated) ANSWER

· Chosen Typology (*estimated) ANSWER

· Basic Network configuration (*estimated) ANSWER

· Remember to justify your choices

Discussion Question Response – operating system

 Please respond in with at least 100 words.

The  Operating System at work has to be secure and kept updated the most. In  my case at work, I use a version of Windows 10 that has been tweaked a  lot and, unfortunately, is not as safe as it should have to be. Several  issues and problems in the way we use computers and the way the  work-related websites create a major headache for all of us. I happen to  be the Information Manager Officer for my workplace, and I’m what a  Network Manager and Help Desk person would be if combined into one  person. Another issue we have with our operating system is that it would  not update straight from the Software developer, and that causes a  delay on security patches, the only time I’ve seen this as an advantage  or a “plus” was in October 2017 when an MS patch ruined most of the  Windows machines, and we were able to avoid the issue since it was  identified before the central servers at work pushed them to our  network. 

Blockchain – Journal

You installed and set up a Bitcoin Wallet last week. Do you plan to use your wallet to buy or sell merchandise or services? If so, what do you plan to do with your Bitcoin? If not, describe why you don’t want to use Bitcoin. Will your plans change in the future?

Networking and IPv4 Addressing

 

You got that coveted work-from-home IT position you’ve always wanted.  There’s only one hitch- you have to move to a new city that is within a  specific radius of the corporate office. Before you make that big move  to the city, you realize it’s a good idea to research the area. Since  you will be working from home, it’s going to be important to look into  the different ISPs (Internet Service Providers) your new city has to  offer. 

You’ve never worked from home; what kind of equipment do  you need for a home office? You’re used to going to work and having your  computer hard-wired into the network- is that necessary now that you  are working from home? Will a wireless network be reliable and  sufficient? You have a lot to consider for your first work-from-home  job. Time to “get your ducks in a row” before your first big day!

  • Where are you moving to for your new work-from-home position?  Which ISPs are available at this location? Which do you pick and why? 
  • What  equipment do you need for your work-from-home position? What does your  ISP provide? What does your employer provide? What do you need to  provide?
  • What types of network cabling will you be using and with which devices?
  • How do you determine the IP addresses on your devices?
  • How  will you set up equipment in your office in your new home? Will you be  using wireless or hard wire for your network connection? What else  should be considered?