Learning Goal And Performance Orientation Management Discussion Writing Assignment Help

Gould, Inc. is preparing for its initial public offering. Approximately one month before Gould plans to file its registration statement with the SEC, it sent a short letter to all of its existing customers (over 5,000 companies and individuals). The letter included:

A description of a revolutionary product Gould is developing that will perform much better than Gould’s current products. The notice indicates that Gould expects the new product to be highly successful and profitable to the company.

Information about Gould’s upcoming public offering, including the planned offering date, the number of shares to be sold, the amount of money to be raised and the basic terms of the common stock to be sold. The letter stated that the funds raised in the offering will allow Gould to have the new product available for sale within six months after completion of the offering.

Explain whether Gould violated the Securities Act of 1933 by sending this letter

Question

Of the following factors, which one, considered by itself, is most likely to be determinative in deciding whether or not a particular investment is a security. Explain.

1. The investment is in an industry that is very risky, so there is no certainty whether investors will profit.
2. The investment is being sold to over 1,000 purchasers.
3. Investors will receive shares of common stock in return for their investment.
4. The return to investors will depend on how well the business performs over time.

Of the factors listed above, which factor, considered by itself, would be the least important in deciding whether the investment is a security? Explain.

For this media analysis, you will analyze how one part affects
the whole media production. Note that you should select only a single piece of
media; you should not be discussing more than one film, for example. You should
choose one1 of the following parts to explore:

· Genre: Explain how the production you
chose fits into its genre.

· Camera: Analyze how the camera’s use
(camera angles, for instance) affects the overall production.

· Lighting: Describe how lighting is used to enhance or
detract from the production.

· Actors/Characters: Analyze how the
actors OR the characters themselves enhance or detract from the
production.

· Symbols: Explain what the symbols are
and how their usage affects the overall production.

· Music: Describe how the music enhances
or detracts from the media production.

· Sound Effects: Analyze how the sound
effects enhance or detract from the production.

· Special Effects: Explain what special
effects are used and how they affect the viewing experience.

· Comparison to a Literary Work: (Note:
This option may only be chosen if the film you chose is also in print form.)
How are the book and film similar? How are they different? Which is better, and
why?

Your purpose in this assignment is to explain how or why
something works; therefore, you should not include a full summary of the media
production. Instead, you can provide context where needed so the
reader understands what is happening. The body of the essay must focus on
your analysis.

As with all college writing, your essay should have a strong
thesis statement in addition to an introduction, body, and conclusion.

Other than your chosen film, television show, and/or book, you
are required to cite at least one other
credible2 source for this essay. This resource from the course will help
you understand more about evaluating sources. Moreover, if you use specific
information from the media production and/or print source, such as a
quotations, you should include your chosen media source on your Works Cited
page, too. Use proper parenthetical citations or signal phrases, and be sure to
include MLA documentation and a Works Cited page for this assignment.

Thesis hints: You might use these guidelines in crafting your
thesis:

If you are analyzing elements in a production: In (add your one
chosen production), (add character 1), (add character 2), and (add character 3)
were used to (add how they enhanced the production or explained the
production’s message).

OR

If you are comparing/contrasting a book and film: (Add book)
contained (add one aspect that made the book better than the film), but (add
film) used (add one aspect that made the film better than the book) and (add a
second aspect that made the film better than the book) to better capture the
reader’s imagination.

Here are more specific thesis guidelines:

If you are analyzing elements in a production: In the movie The
Lorax, the characters Lorax, Once-ler, and Alocius O’Hare were used to show how
environmentalists are fighting against profit-driven industries that are
harming the environment and depleting natural resources.

OR

If you
are comparing/contrasting a book and film: Even though the characters were
portrayed mostly the same across the book and the movie in Stephanie Meyer’s
Twilight, the setting in the movie was much more detailed, which made the movie
a much better overall experience compared to the book.

The guidelines for this assignment are as
follows:

Length: This assignment should
be at least 500 words.

Header: Include a header in the upper left-hand corner of your writing
assignment with the following information:

· Your first and last name

· Course Title (Composition II)

· Assignment name (Media Analysis)

· Current Date Format:

· MLA-style source
documentation and Works Cited3

· Your last name and page number
in the upper-right corner of each page

· Double-spacing throughout · Standard font (TimesNewRoman,
Calibri)

· Title, centered after heading

· 1” margins on all sides

· Save the file using one of the
following extensions: .docx, .doc, .rtf, or .txt Underline your thesis
statement in the introductory paragraph.

Underline your thesis statement in the introductory paragraph.

The objective is to create a
Microsoft Access file as mentioned in the attachment. The instructions
are attached below and pasted below too.

Part 1 – Getting Started / Database

• Create a blank database and name it LASTNAMEINITIAL_2AC.accdb.

• tblItems
  • Import
    the Item information from the Items tab within the Excel file
    Access2_Data_F18.xlsx into an Access table.Name the table tblItems.
  • The primary key should be the Item Code.
  • Use
    data validation to ensure no one can enter a Selling Price greater than
    $100 or less than 0.Display an error message if either situation
    occurs.Test this by trying to enter an invalid Selling Price into table.
  • Use
    data validation to make Item Name a required field.This means the Item
    Name cannot be left blank when a new item is entered into the table.
• tblSales
  • Import
    the sales info from the Sales tab within the Excel file
    Access2_Data_F18.xlsxinto an Access table.Name the table tblSales.
  • The primary key should be a combination of Month, Store ID, and Item Code (a multiple field primary key).
• All tables
  • Be
    sure the field sizes are appropriate (don’t use the default sizes), the
    data types are appropriate, and there is a data description for each
    field.
  • No additional fields/tables should be added to the project.

• Make
  the Item Code field (in tblSales) a lookup field.This will join your
  two tables, so don’t join them before creating the lookup field.
• When
  you set up the lookup field, start in the tblSales table and use the
  lookup wizard and let the users see both the Item Code and Item Name
  (sort by Item Code) in the drop down menu (do not ‘hide the key
  column’).
• When a new record is entered into tblSales, the Item
  Code should reference the tblItems table and give users a drop down menu
  showing the Item Code and Item Name (full or partial display is ok)
  & let them click on the one they want.
• The Item Code should be the field that is stored and the label for the lookup column should also be Item Code.
• Test
  your lookup field by adding 2 new records to the tblSales table.Use a
  valid Item Code & Store ID and make up the rest of the data.

• View
  your database relationships; be sure both tables are displayed.The
  tblSales and tblItems table should have been joined for you when you
  created the lookup field.
• qry1-DepartSearch– Create a query that accepts a user input for a department name and displays relevant data
  • Use the parameter feature – 1 prompts only for the department name.
  • Display only the following fields (any order that works): Department, Store ID, Month, Item Name, Units Sold
  • In the design view, sort by Month (ascending) and by Units Sold (descending)
• qry2-PriceSearch – Create a query that accepts a user input for both a minimum Selling Price and a maximum Selling Price and displays all Items within that range (including maximum and minimum prices).
  • Use the parameter feature – 2 prompts only.
  • Display only the following fields (any order that works): Item Name, Item Code, Selling Price
  • In the design view, sort by Selling Price (ascending)
  • You can use >, <, = operators or the BETWEEN operator
• qry3-HairSelect– Create a query that selects Items based on Department and Selling Price.
  • Displays all Items in the Hair Care department or have a Selling Price less than $10.00.Don’t use a parameter.
  • Display only the following fields (any order that works): Item Name, Item Code, Department, Selling Price
  • Sort first by Selling Price in descending order and then by Department (ascending order).
• qry4-Top10– Create a query that shows the top 10 Items based on Profit per unit(calculated field)
  • Use the top values function in Access.
  • Include fields (any order that works): Item Name, Item Code, Selling Price, Cost, Profit (create this calculated field)
  • Sort in the design view by Item Code and Profit, both in descending order
  • Your fields can be displayed in any order, as long as the sorting works correctly and the results are correct.
  • In the design view, format Profit as currency with 2 decimal places.
• qry5-TotalSales – Create a query that displays the total units sold for each Department
  • Display only the following fields (any order that works): Departmentand the sum of the Units Sold
  • In the design view, sort by the Units Sold (descending order).
• qry6-UnitsCheck
  – Create a query that lists each record in the tblSales table and notes
  all those with units sold quantity less than or equal to 50 units .
  • Display only the following fields (any order that works): Store ID, Month, Department, Item Name, Units Sold
  • In
    the design view, sort by Department (ascending order), then by Item
    Name (ascending) and within that by Units Sold (descending order).
  • Create
    a new field called UnitsCheck.For each record, if the Units Sold is
    less than or equal to 50, this field should display a message “**Small
    Sale”.If the Units Sold is greater than 50, don’t display anything.Use
    the IIF operator to display the appropriate message.
• qry7-Wildcards:Your manager found a ripped report and can only see part of the printed information.
  • Create a query that displays all Item Names with an Item Code containing a 0 (zero) as the 4^th character and the Department Code has an ‘i’ as the 3^rd character.
  • Display only the following fields (any order that works): Item Code, Item Name, Department
  • In the design view, sort by Item Codein ascending order
  • Use
    at least 2 different types of wildcards – see the Access 1 project,
    tips or class on different types of wildcards.Note: You may have to add
    the required quotes yourself instead of letting Access add them for you.
• qry8-SearchTerm:Create a query that lets you enter a search term and find all item names that contain that term.
  • Use a parameter and wildcards
  • Display only the following fields (any order that works): Item Code, Item Name, Department, Selling Price and Cost
  • In the design view, sort by Item Name in ascending order
• Check all queries for reasonable/accurate results.
• Only
  use the tables you need in each query.If you aren’t displaying/using
  any fields from a particular table, don’t include it in a
  query.Including unnecessary tables can lead to unexpected results
  (missing records, duplicated records displayed).

Part 2 Tables

Part 3Lookup Field /Relationships between tables

Part 4 – Create the following queries:
You
are going to create a few queries.Remember – queries take some time to
play with and figure out how they work.You may not get the right results
for each one the first time you try it – keep at it!
Note:
Your fields can be displayed in any order, as long as the sorting works
correctly and the results are correct.Name the queries as listed below.

Part 5 – Navigation Form

• Create a report for each query.Give them a name similar to the query, just replace the ‘qry’ with ‘rpt’.
• **When you run the reports, the sorting may be different than when you run the query.For our purposes, this is ok.
• Create a navigation form that runs all of the reports.
• Adjust the report Title Names (within the report) to be more descriptive.
• Feel free to add different background colors.
• Modify your navigation tabs to make them a different shape and color than the default tabs.
• If
  your first tab is to a report with prompts (parameters), that will
  prompt you whenever you open the database / navigation form.If this
  isn’t what you want, you can put a non-prompting report first or even
  create a form that is just a Item Name and put that first.See the
  overview for more on this.
• The navigation form should open automatically when your database opens.

Project Submission Instructions / Notes:

• The
  only way we can fairly grade the projects is if we check for each
  requirement.Please go through the instructions before you submit &
  be sure you have done each one correctly, so you don’t miss out on
  points.Compare your solution to the project overview.
• Submitting:
  • Remember
    to leave all of the internal file properties intact for the project, if
    they are modified or deleted, the project won’t be accepted.