Perform a search for scholarly peered reviewed articles or other publications from reputable sources (as discussed in class)
For each publication you must use the Word template provided. You can type in your responses into the template for submission
Please be brief, concise, but thorough with your responses
Ensure that when you include the citation for source at the end of template, that it is in the proper APA format
If there is question in the template that does not apply to your publication, please put N/A and the rationale as to why
The information from this template is what you will present to the class for the Summary Article Presentations
Your final grade for this Summary Article will be based on turning in the Summary Article and performing the accompanying presentation. Your grade will be given after your in-class presentation. Your grade will be based on the content of your Summary Article and quality of your presentation. Please see rubric below.
You are to import an existing database, i.e. northwinds, droneportation, of other db not used for other assignments.
You are to determine the business that this database will serve. Build a story that supports your development of the database. Keep in mind reuse an industry standards for data needed for this business.
Deliverables:
Database – 15 points
Database Relationship Diagram
5 Reports from the database, 1 each in Report Builder and Crystal Reports. 3 from Power BI with a dashboard. You must share the dashboard with me through powerBI.
Database management plan including backup and maintenance schedule
Contract Scenario: Calvin had been an avid coin collector for many years, and the most valuable coin in his collection was an uncirculated, mint condition, 1943 Lincoln penny made of copper (most pennies made during World War II were made of zinc because copper was needed in the war effort). That penny had a value of between $60,000 and $95,000.In August of 2017, Calvin had a serious stroke that left him unable to speak or walk, but his doctor assured his family that Calvin would recover over time with intensive therapy. Calvin was a widower and did not have any children, but he had several nephews who visited him from time to time as he recovered. None of the nephews had any real interest in Calvin’s coin collection. One of Calvin’s nephews, Billy, who visited Calvin more often than the other nephews, sometimes listened to Calvin talk (talking was a part of Calvin’s therapy) about his mounting medical bills and his coin collection, but Billy never showed much interest in the medical bills or the coin collection. In October, as Calvin’s recovery progressed slowly, Billy visited Calvin and told Calvin that he had been reading about coin collecting, and he realized that Calvin’s collection, especially the 1943 Lincoln copper penny, was valuable, and Billy suggested that Calvin should consider selling the 1943 Lincoln copper penny and use the proceeds to pay his medical bills. Calvin resisted the idea at first, but Billy continued to urge Calvin to sell the penny so that he would not have to worry about the medical bills. Finally, when Billy told Calvin that he would arrange the sale of the penny for a commission of just 5% of the sale price of the penny, Calvin began to think that selling the coin might be a good idea. He was still a little confused about how the sale would work and what Billy would do to make sure that the penny would be sold for the best price. Calvin told Billy that he thought that the penny was worth almost $100,000, but Billy assured Calvin that the market had changed recently, and that the penny was now worth $40,000 to $45,000. Eventually, Calvin allowed Billy to sell the penny for the best price he could get and to take a 5% commission for arranging the sale of the penny. Billy then sold the penny to a friend for $40,000, took his 5% commission, and paid the remainder of the sale price to Calvin. A few months later, as Calvin continued to recover, he read a story in a coin collecting magazine about how an uncirculated, mint condition, 1943 Lincoln penny made of copper had just sold at auction for more than $100,000, and Calvin began to wonder if Billy had taken advantage of him. Calvin consulted a lawyer and asked the two questions below.
Did he (Calvin) have the mental capacity to enter into the contract when he agreed to let Billy sell the penny? What would he (Calvin) have to prove to show a court that he did not have the necessary mental capacity when he authorized Billy to sell the penny?
Did Billy exert undue influence over Calvin to cause Calvin to enter into the contract that allowed Billy to sell the penny?
What do you think? Does Calvin have a case to set aside the contract with Billy on either of these theories?Your case study should be at least two pages in length and include at least two outside sources. Be sure to use APA formatting for all citations and references
Write a 2- to 3-page memo to the CEO of the company you’ve been assessing throughout the course, outlining your plan to create economic, social, and environmental value. In your memo, include the following items:
An executive summary of the memo
A summary of the organization’s strengths and weaknesses, and recommendations for converting weaknesses into strengths
A summary of your Week 3 findings on Porter’s Five Forces
A summary of your Week 4 findings on the Diamond of National Advantage
A summary of your Week 5 analysis of the firm as a learning organization
Strategic recommendations based on your previous work in this course. Include the opportunity identified in Week 2, the move into the country identified in Week 4, and any recommended moves toward being a learning organization. Provide rationale for each recommendation.
Support your Statements: Include citations
Format your citations and references according to APA guidelines.
CLICK HERE TO MAKE YOUR ORDER on A small business that is using social media, such as Facebook, Twitter, or LinkedIn, to promote their products or services
You will write a short reflection report describing the key learning from the course and future trends in IT. This report will be organized as follows:
1. Description – Describe up to 3 key learning points (1.Information security, 2.people in information system, 3. social, ethical, and legal issues from the course).
2. Analysis – Connect the learnings described in the previous section with the real-world. Analyze how these learnings are applicable in the real business world. Highlight 2 takeaways from your learnings.
3. Future trends – Discuss what you envision in the future. You can discuss the role of new IT systems that will revolutionize business.
You must submit your excel document including all of your calculations and analysis as a separate document along with your final report.
Final report must be typed in a word processing document (like Microsoft office word), and follows the managerial report format. No redundancy, no word limits.
Late Submission Policy
This assignment is subject to the Late Submission penalty policy, namely 5% per day for three days.
This page will close and will not allow further submissions after this Late Submission period has expired.
In the event of an emergency preventing you from submitting within this time frame, special permission must be obtained from your instructor. Documentation substantiating emergency is required. In such a circumstance, if the extension is granted, the professor will reopen the submission function for you on an individual basis.
Please do not email your submissions to your professor, either before or after the due date; all coursework should be submitted through the online course (Moodle).
Description
Case studies are used to enable you to apply new concepts, use the tools you have mastered, and improve your technical skills you have attained. Through the individual case studies you will discover for yourself the usefulness of quantitative problem solving methods, how to apply them in practice, and their benefit to organizational decision-makers.
In this case study, you will act as a consultant for a company that crushes sunflower seeds to produce high quality refined sunflower oil for sale in the wholesale market. The company is looking for you to make a recommendation on the optimal blend of raw materials required for its next production cycle. You will use a number of decision analysis tools including time series forecasting, linear programming, and cost-profit-volume analysis to make the recommendation and provide analysis on the profitability of the company.
You will be required to submit a written report to management, and to include the spreadsheet models you used to generate price forecasts, optimize the raw material, and a perform the break-even analysis. All analysis should be done using Excel and the various models should be implemented on separate worksheets or in separate workbooks.
Scenario
TourneSol Canada, Ltd. is a producer of high quality sunflower oil. The company buys raw sunflower seeds directly from large agricultural companies and refines the seeds into sunflower oil that it sells in the wholesale market.
The company has a maximum input capacity of 180 short tons of raw sunflower seeds every day (or 65700 short tons per year). Of course the company cannot run at full capacity every day as it is required to shut down or reduce capacity for maintenance periods every year, and it experiences the occasional mechanical problem. The facility is expected to run at 90% capacity over the year (or on average 180 x 90% = 162 short tons per day).
TourneSol is planning to purchase its supply of raw sunflower seeds from three primary growers, Supplier A, Supplier B, and Supplier C. Purchase prices will not set until the orders are actually placed so TourneSol will have to forecast purchase prices for the raw material and sales prices for the refined sunflower oil. The contract is written such that TourneSol is only required to commit to 75% of total capacity up front. Any amounts over that can be purchased only as required for the same price. Historical prices for the last 15 years are in the table below (note that year 15 is the most current year).
Marketing Year
SeedAverage Price Index$/short ton
OilAverage Price Index$/short ton
147.7
352.8
216.4
510
276
697.2
284
719.2
328
826.3
286
767
324
866
371.2
928
460
1102.3
10
476.8
1217
11
485
1411
12
526
1689
13
542
1702.4
14
472
1797.4
15
476
1839.4
Sunflower oil contains a number of fatty acids, some which are desirable in food products and others that are not. One desirable fatty acid is oleic acid. TourneSol produces high oleic oil for the wholesale market, and requires that the oleic acid content be a minimum of 77%. Sunflower oil also contains trace amounts of iodine. The market requires that that iodine content be a minimum of 0.78% and maximum of 0.88%
The oleic acid and iodine content for the sunflower seeds from the three suppliers is given in the table below.
Supplier
Oleic Acid
Iodine
65%
0.85%
70%
0.73%
80%
0.92%
Because the oleic acid and iodine content varies across the three suppliers, so does the price. It is expected that the cost of supply from the suppliers will be a percentage of the market average price of seeds.
Supplier
Cost as % of Average Market Price of Seed
78%
80%
88%
The company faces an additional variable production cost of $8.5/short ton and an estimated fixed cost of $1,050,000 over the upcoming production period.
The company is asking you to provide a recommendation on the amount of raw material it should purchase from each supplier to minimize its cost of feedstock.
Management is also looking for an analysis on the profitability of the company in the next production cycle.
Suggested Approach
This is a fairly complex problem. The following approach is suggested:
Use the historical price data set as input to a time series forecast model in order to generate forecasted prices for the average price of sunflower seeds and oil in the next production period. Use standard measures of error to decide between a three-period moving average model or an exponential smoothing model (with α = 0.25). Use the type of model for all three time series forecasts. That is, if you decide to use the moving average model, use a three-period moving average model to fit the relevant data for all three series. Don’t use the moving average for one time series and the exponential smoothing model for another time series.
Formulate a linear program to minimize the cost of raw sunflower seeds. Use the average price of seeds forecasted from the previous step in order to determine supplier prices.
Perform a cost-volume-price analysis (review the handout entitled Cost-Volume-Profit Analysis for details) using the average cost per short ton average selling price per short ton.
You can generate an effective cost per short ton by dividing the total cost of supply (from the linear program) by the total volume (that you assumed in the linear program).
You can generate an effective selling price per short ton from the expected percentage yields and the forecasted average price of sunflower oil.
Because of the way that the contract is written, you can assume that the purchase of raw sunflower seeds is a variable cost (you only purchase what you require).
Recall that the cost-volume-price analysis requires you to provide
an algebraic statement of the revenue function and the cost function,
a detailed break-even chart that includes lines for the revenue and for the total cost, fixed cost, and variable cost (a total of four lines), and
a calculation break-even point expressed in number of short tons and percent of capacity.
Management Report
Prepare a written management report that includes, at a minimum, the following sections:
Purpose of the Report
Description of the Problem
Methodology (which would include the model formulation)
Findings or Results
Recommendations or Conclusions
Be sure to address all relevant points, discuss any assumptions you are making, justify any modeling choices you have made (for example, the choice of time series forecast model), and highlight the following items in your report:
a forecast of the next production period’s average price index for raw sunflower seeds and sunflower oil.
a recommendation for the optimal purchasing strategy from the various suppliers,
a cost-volume-profit analysis using for the recommended purchase strategy and the forecasted sunflower oil sales price,
a discussion of the risks and uncertainties that are faced by the company, and
an analysis and opinion on the profitability of the company in the next production period (accounting for the expected profit or loss and the inherent risks/uncertainties.
Remember that you are writing the report from the point of view of a consultant with senior management of TourneSol Canada, Ltd. as the intended audience.
Evaluation
Final Case Study will be marked in its entirety out of 100. The following rubric indicates the criteria students are to adhere to, and their relative weights to the assignment overall.
There are many alternatives to “traditional” education, such as home schooling, private schools, magnets, etc. Are there any magnet schools in your school district? If so, what focus do these schools have? In this short paper, reflect on what it might be like to be involved in a magnet program. (If you do not have magnet schools in your district, you can do a web search to find a school and review their program online.) Provide at least one example.
For this Assignment, you will:
Discuss whether there are magnets in your school district or state. (1 paragraph) You can use the following link to help determine national and local growth as it relates to this Assignment (https://nces.ed.gov/fastfacts/display.asp?id=30). Choose one magnet school, describe the program, and provide the link to the website. (1-2 paragraphs) Reflect on what it might be like to be involved in a magnet program. (1 paragraph) Create your assignment in Microsoft® Word® and use APA style for formatting (including a cover page and running header), citations, and references.
Please note: This is a short, focused assignment that should contain a maximum of 4 paragraphs. It should be no longer than 1½ pages (double spaced), excluding cover page and references.
There are many alternatives to “traditional” education, such as home schooling, private schools, magnets, etc. Are there any magnet schools in your school district? If so, what focus do these schools have? In this short paper, reflect on what it might be like to be involved in a magnet program. (If you do not have magnet schools in your district, you can do a web search to find a school and review their program online.) Provide at least one example.
For this Assignment, you will:
Discuss whether there are magnets in your school district or state. (1 paragraph) You can use the following link to help determine national and local growth as it relates to this Assignment (https://nces.ed.gov/fastfacts/display.asp?id=30). Choose one magnet school, describe the program, and provide the link to the website. (1-2 paragraphs) Reflect on what it might be like to be involved in a magnet program. (1 paragraph) Create your assignment in Microsoft® Word® and use APA style for formatting (including a cover page and running header), citations, and references.
Please note: This is a short, focused assignment that should contain a maximum of 4 paragraphs. It should be no longer than 1½ pages (double spaced), excluding cover page and references.
Whether you are a teacher, administrator, or in a position, that supports teaching and learning, all educators need to understand the teaching and learning process as it relates to lesson planning. The purpose of this assignment is to produce a model lesson plan that demonstrates your knowledge of the constructivist approach to lesson design. In this Assignment, you will construct a model lesson plan that includes rubrics and appropriately integrates technology.
Your lesson plan must include each of these elements:
1.APA Cover 2.Topic 3.Select an academic concept – just one concept, not a related set of concepts – that you hope to teach to students. For example, you might select the mathematical concept of measuring perimeter, but not the whole set of concepts related to polygons in geometry. Or, you might select the concept of identifying the main idea in a reading passage, but not the whole set of concepts related to reading comprehension.
4.Grade Level (K-12, adults) 5.Introduction that includes the central focus of the lesson 6.Rationale 7.Objectives with specific thinking skills and content as it relates to student learning. 8.Essential Questions 9.Procedures/Activity: a.Use multiple strategies to differentiate for diverse students: English Learners (ELs), Gifted Students, Students with Special Needs. b.Incorporate instructional strategies based on constructivist views of learning. c.Incorporate instructional strategies that appropriately integrate instructional media in the teaching and learning process. 10.Materials 11.Evaluation/Assessment (Use multiple strategies to modify for diverse students: English Learners (ELs), Gifted Students, Students with Special Needs. Include necessary rubrics. Include necessary rubrics for assessment along with your lesson plan. 12.APA Bibliography (include in-text citations throughout the lesson plan)
Respond to these questions, drawing upon the Woolfolk text. Each response should be in essay format and contain one to two paragraphs. If other sources are used, please cite them in your references.
Why are the instructional activities that you have planned appropriate for students at your grade level? Explain how you compared instructional activities to choose the ones you found most appropriate. How do your instructional strategies, assessment activities, and classroom management strategies support student motivation?