All posts by : chebby

GO16_AC_CH02_GRADER_2E_AS – Grants and Organizations

Project Description:

In this project, you will use a database to answer questions about grants awarded to a college. You will open and save an existing database, create a relationship between two tables, sort records in a table, create queries in Design view, create queries from existing queries, sort query results, and specify criteria in a query.

Start   Access. Open the downloaded file named go_a02_grader_a1_Grants_Organizations.accdb,   and then enable the content.

Using   Organization ID as the common field, create a one-to-many relationship   between the Organizations table and the Grants Awarded table. Enforce   referential integrity and enable both cascade options.

Create   a relationship report with normal margins, saving it with the default name.   Close all open objects.

In   the last record of the Organizations table, change the data in the   Organization ID field from ORG-1527   to ORG-1001, and then close the table. (The   related records in the Grants Awarded table will automatically update.)

In   the Sorted Grants table, sort the records first in descending order by the   Award Amount field and then in ascending order by the Department field. Close   the table, saving the changes to the table.

Create   a query in Query Design view based on the Grants Awarded table. Add the following   fields to the design grid in the order given: Grant ID, Grant Name, Award   Amount, Type, and Award Date. Run the query, save it as All Grants Query, and then close the query.

Copy   the All Grants Query to create a new query with the name Grant Types Query. Redesign the query so that the   following fields display in the order given: Grant ID, Department, Type,   Grant Name, and Award Amount. Sort the records in ascending order by the Type   field and in ascending order by the Grant Name field. Run the query, and then   close the query, saving the changes to the query.

Copy   the All Grants Query to create a new query with the name Grants Sort Query. Redesign the query so that the   following fields display in the order given: Grant Name, Department, Award   Amount, and Award Date. Sort the records in ascending order by the Department   field and in descending order by the Award Amount field. Run the query, and   then close the query, saving the changes to the query.

Copy the Grants Sort Query to create   a new query with the name All Private Grants Query. Redesign the query so that the   following fields display in the order given: Grant Name, Department, Award   Amount, Award Date, and Type. Sort the records in ascending order only by the   Grant Name field. Set the criteria so that when you run the query only those   records display that have private   as the Type. Do not display the Type field in the query results. Run the   query (11 records display). Close the query, saving the changes to the query.

Create   a query in Query Design view based on the Organizations table. Add the   following fields to the design grid in the order given: Organization Name,   Contact Name, and Contact Phone. Sort the records in ascending order by the   Organization Name field. Set the criteria so that when you run the query only   those records display that are missing the contact phone number. Run the   query (two records display). Save the query as Missing Phone   Query,   and then close the query.

Be   sure that all database objects are closed, open the Navigation Pane, and then   close Access. Submit the go_a02_grader_a1_Grants_Organizations.accdb   database as directed.

 You have recently been hired as a Chief Information Governance Officer (CIGO) at a large company (You may choose your industry). This is a newly created position and department within the organization that was founded on the need to coordinate all areas of the business and to provide governance of the information. You will need to hire for all positions within your new department.

The company has been in business for more than 50 years and in this time has collected vast amounts of data. Much of this data has been stored in hard copy format in filing cabinets at an offsite location but in recent times, collected business data is in electronic format stored in file shares. Customer data is being stored in a relational database, but the lack of administration has caused data integrity issues such as duplication. There are currently no policies in place to address the handling of data, business or customer. The company also desires to leverage the marketing power of social media, but has no knowledge of the types of policies or legal issues they would need to consider. You will also need to propose relevant metrics that should be collected to ensure that the information governance program is effective.

The CEO and Board of Directors have tasked you to develop a proposal (paper) that will give them the knowledge needed to make informed decisions on an enterprise-wide Information Governance program, addressing (at a minimum) all of these issues, for the company.  

Requirements:

The paper should include at a minimum of the following sections:

1. Title page
2. Executive Summary (Abstract)
3. Body
   1. Introduction (including industry discussion – 1-2 pages)
   2. Annotated Bibliography (2-3 pages)
   3. Literature review (2-3 pages)
   4. Program and technology recommendations, including:
      1. Metrics
      2. Data that matters to the executives in that industry, the roles for those executives, and some methods for getting this data into their hands.
      3. Regulatory, security, and privacy compliance expectations for your company
      4. Email and social media strategy
      5. Cloud Computing strategy
4. Conclusion
5. References

After completing the reading this week, please review table 1.2 (Page 91) in the text and review the distinction between leadership and management.  Then think about this in regard to how senior leaders versus senior managers lead change in an organization (especially when it comes to technical change in an organization).

This week please reflect on these concepts and answer the following questions:

1. When implementing change in an organization, there are always culture issues that are faced, such as not accepting change, determine how differently this would be handled thinking about the management versus leadership constructs?

2. When dealing with performing work, how is this implemented differently within the management versus leadership constructs?

Please be sure to answer all of the questions above in the initial post.

Please ensure the initial post and two response posts are substantive. 

· Ask an interesting, thoughtful question pertaining to the topic

· Expand on the topic, by adding additional thoughtful information

At least one scholarly (peer-reviewed) resource should be used in the initial discussion thread. Use APA references and in-text citations.

1. Your paper should use the Capstone Project Template. As the project paper was started in earlier workshops, you should have already been using the template.
2. You should have submitted a draft of your paper in Workshop Five for instructor feedback. Make any edits based on the feedback you received.
3. The paper should be about 20 pages in length (double-spaced), and transitions between sections should be addressed. Any graphics or tables do not count toward page count.
4. Make sure to use 7th edition APA where required. The paper should include credible references that are cited according to the 7th edition of APA. You may and should use research to develop your plans, but make sure to cite your sources. All written work should be your own.
   1. For questions on APA style, go to the OCLS APA Style Page.
5. Please refer to the Capstone Project Guide for specifics on what the paper needs to contain.

Write a one page answer to this question that includes an example from your personal experience or internet research to support your opinion.

Of the five primary components of an information system (hardware, software, data, people, process), which do you think is the most important to the success of a business organization? 

In this assignment you are to modify the algorithm presented in figure 11.9 (TEA) to use Cypher Block Chaining .  Your algorithm will use the encryption and decryption algorithms within a chain of blocks according the specifications of CBC (64 bit block size). Your output is supposed to be able to show the entire message or even portions of the message both encrypted and then later decrypted. 

Basically, read a string from input, simulate CBC encryption on it. Output the encrypted results and then decrypt it and produce the decrypted result. 

How you build that user interface to show how the algorithm works is entirely up to you as long as you show the required results.

8 Exercises

1. Create a list of your favourite superheros and another list of their secret identities.
   1. Convert your two lists into a dictionary. (Can you do it in one line?)
   2. Remove one of your heroes and add a villain to your dictionary.
   3. Add a character that has multiple identities to your dictionary. (What kind of object should this be?)
   4. Demonstrate that you can look up one of your character’s identities.

SuperheroIdentityIron ManTony StarkThe ThingBen GrimmStormOroro MunroeSpider-ManPeter Parker, Miles MoralesIn [61]:

# Add your solution here

1. Use Hubble’s law (????=????0????v=H0D) to calculate the distance (in Mpc) of the galaxies in the following table.

GalaxyVelocity (km/s)NGC 1231320NGC 23425690NGC 44428200

Remember that ????0≈70H0≈70 km/s/Mpc.

In [ ]:

# Add your solution here

1. Flatten the following list using list comprehension.

mylist = [[[1, 2], [3, 4, 5]], [[6], [7, 8]]]

In [ ]:

# Add your solution here

1. Write a generator function that can be used to calculate the Fibonacci sequence.

In [ ]:

# Add your solution here

LAST 4 QUESTIONS ON THE ATTACHED FILE!

Question 1

Describe the difference between a guest operating system and a host operating system, with respect to virtual machines.

Question 2

How does the operating system use paging to enhance the use of memory?

Question 3

What is multithreading and why is it advantageous?

Question 4

Describe the role of the new InPrivate browsing feature in Microsoft’s Edge browser.

 The impact of Information Systems in the globalization of business

This should follow the format below

a.) Introductory Paragraph

b.) Body Paragraph

c.) Concluding Paragraph

d.) References

 Discussion:
Some partitional clustering algorithms that automatically determine the number of clusters claim that this is an advantage.  Using your required textbook, Chapters 6 & 7 as a guide, discuss two (2) situations in which this is not the case 

Assignment: PFA and answer accordingly.