Create an HTML form that accepts the user’s input to enter his/her first name, last name and sex.

E-portal development

Question One

  1. Create an HTML form that accepts the user’s input to enter his/her first name, last name and sex.
  2. Create a php file that displays the following sentence:

Hello first name laste name, welcome to IT405.

The sentence should be colored in blue or pink according to the sex..

Your program output should look as shown below

  1. Include the screenshot of the program output as a part of your answer.

 

Question Two

  1. Given the following HTML form code, write a php file that displays all the input of the user as a list.

<!DOCTYPE html>

<html>

<head>

<title>Registration</title>

</head>

<body>

<form method=“get” action=“file.php”>

First Name:<input type=“text” name=“first”><br />

Last Name:<input type=“text” name=“last”><br />

Email:<input type=“text” name=“email”><br />

Level:<input type=“text” name=“level”><br />

<input type=“submit” value=“submit” name=“submit”>

</form>

</body>

</html>

Include the screenshot of the program output as a part of your answer.

 

Question Three

  1. Write a PHP program to create a new string where IT’ is added to the front of a given string. If the string already begins with ‘IT’, the program returns the string unchanged.
    Sample InputèOutput
    “405” è IT405
    “403”è IT403
    “IT401” èIT401
  2. Include the screenshot of the program output as a part of your answer.

Evaluate the techniques used to support the process of workforce planning. Evaluate approaches that an organization can take to build and support different talent pools.

Humanities question

Q1- Evaluate the techniques used to support the process of workforce planning.

Q2- Evaluate approaches that an organization can take to build and support different talent pools.

Using spreadsheets or typical computer-based filing systems looks a reasonable choice for organizing personal data. Define five mini-world Entities and five Relationships for a hospital database system.

Fundamentals of database 

4 questions need to be solved.

1- Using spreadsheets or typical computer-based filing systems looks a reasonable choice for organizing personal data. However, it is not sufficient to use such systems when the amount of data becomes huge. In such case, it may be time to implement a database.

2- Define five mini-world Entities and five Relationships for a hospital database system.

3-Draw an ER diagram for the following car sharing system:

In the car sharing system, a CarMatch application has record of anyone who would like – further details in the attachment.

4- Consider the following ER Diagram and fill the table by identifying the ER constructs in the diagram – further details in the attachment.

In The Adventures of Kavalier & Clay, Michael Chabon questions whether superhero comics are a tool of social change, a cheap escape from reality or, worse yet, an indulgence of people’s worst revenge and power fantasies. Given that superhero comics reflect problems and anxieties present in our culture, what, if anything, do they have to contribute to our responses to those problems and anxieties?

Midterm

Instructions: Choose two of the three questions listed below and, for each question, write a ballpark 750 to 1000 word essay that answers it. You should treat your responses as essays, which means you are expected to provide an argumentative thesis, support your claims with evidence and detail drawn from our texts including specific references to the text (you should use multiple sources for each text), organize your writing into focused paragraphs, observe grammar and mechanics standards, and cite your sources appropriately in MLA Style (please refer to the Purdue OWL MLA site for advice and a refresher on how to do so). Each essay response is worth 150 points, with 100 points assigned to the argument and its quality and 50 points assigned to structure (please see the assignment rubric for more detail) making this exam worth 300 points overall.

Each essay response should be labeled with the question you are responding to and its number on this list.

You may choose between these questions:

1. A common criticism of superheroes is that they too often support the values and ideologies of dominant groups (i.e. the state, the ethnic majority, capitalist values) through their promotion of blind patriotism, adherence to law and promotion of The American Way, but others argue that superheroes are an equally powerful tool for the criticism of social injustices and serve as a useful figure through which to question our assumptions about what constitutes a just society. Write an essay arguing your point of view on this issue, and make sure your response addresses this question directly.

2. In The Adventures of Kavalier & Clay, Michael Chabon questions whether superhero comics are a tool of social change, a cheap escape from reality or, worse yet, an indulgence of people’s worst revenge and power fantasies. Given that superhero comics reflect problems and anxieties present in our culture, what, if anything, do they have to contribute to our responses to those problems and anxieties?

3. The archetype of the superhero, like all cultural figurations, tends to change and adapt across different time periods, dependent on the needs, interests and views of society. In what ways do you believe superheroes have changed over time, and how are superheroes now different from their original Gold Age roots? How have they remained consistent? Be sure to address the social events that have caused such changes/consistency.

Write an essay explaining the negative effect on Roe V wade on Woman.

Roe V Wade Overturn

Write an essay explaining the negative effect on Roe V wade on Woman.

Explain the basic principles of programming, concept of language, and universal constructs of programming languages. Demonstrate Integrated Development Environment (IDE) for the editing, building, debugging, and testing of programs.

Java programs

  • Explain the basic principles of programming, concept of language, and universal constructs of programming languages.
  • Demonstrate Integrated Development Environment (IDE) for the editing, building, debugging, and testing of programs.

If Simon makes only the minimum monthly payment and makes no other charges, how many months will it be before he pays off half the balance on the card?

Unit 4 Individual Assignment

Name your fileLastname, Firstname Unit 4”.

For this unit, the assignment focuses on working with the formulas that are used to measure risk and return.

 

PROBLEM #1

Twin sisters, Joanna and Liz, received today $44,000 each from their parents for their 24th birthday. They will use this money to start their retirement plans.

They both hope to retire with $1.5 million dollars. Each plans to make a $1,000 monthly contribution to her retirement fund, beginning one month from today.

Joanna opened an account with the Conservative Bond Fund, a mutual fund that invests in high-quality bonds whose investors have earned 4.7% per year in the past.

Liz invested in the Aggressive Growth Fund, which invests in small, bio-tech stocks and whose investors have earned an average of 7.9% per year in the fund’s short history.

  1. a) If the two women’s funds earn the same returns in the future as in the past, how old will each be when she reaches her retirement goal? Round your answer to the nearest whole year.
  2. b) How much would Liz’s retirement fund grow to, if she invests for the exact same time as Joanna needs to reach her initial goal?
  3. c) How large would Joanna’s monthly contributions have to be for her to reach her retirement goal at the exact same time as Liz needs to reach her initial goal?
  4. d) Is it rational or irrational for Joanna to invest in the bond fund rather than in stocks?

 

 

PROBLEM #2

Simon recently received a credit card with an 18% nominal annual interest rate. With the card, he purchased a new Apple iPhone 14 for $900. The minimum payment on the card is $35 per month.

  1. a) If Simon makes only the minimum monthly payment and makes no other charges, how many months will it be before he pays off half the balance on the card? Round your answer to the nearest whole month.
  2. b) If Simon adds just $5 more to his minimum monthly payment, how much less would he owe at that time? Round your answer to the nearest whole month.
  3. c) Simon’s wants to finish paying off in just two years. He found an internet offer from a company willing to pay off his credit card balance, if he pays them $40 per month for 24 months. Is this a good deal for Simon? Why?

 

 

PROBLEM #3

Assume that the real risk-free rate is 1.5%, and that the credit risk, liquidity risk and maturity risk premiums are all zero. A 1-year U.S. Treasury bill yield is 4.66% and a 2-year Treasury note yields 4.31%.

  1. a).What is the 1-year interest rate that is expected for Year 2? Do not round intermediate calculations. Round your final answer to two decimal places.
  2. b) Inflation is currently 4%. Based on the above Treasury yields, what does the market expect inflation to be next year?

Show the networks (rows) in descending order based on average viewership (values) and also include the average ratings (values). Prepare a Pivot Chart that displays this information.

Homework #6 – TV Ratings

You are an analyst at a company that advertises on network TV.   You want to explore the trends in network programming on the 5 major broadcast networks over the past few years and prepare an advertising budget for the current year.  You have created a dataset that contains the shows that were on the air, their ratings and their viewership and a few other categories of information.

As you prepare your analysis, remember that you will be presenting this information to your boss, so make an effort to present the information clearly and concisely.  You will be graded on ease of interpretation.

Use what you’ve learned and think about things like:

  • fonts and color coding,
  • formatting of numerical values,
  • column sizing,
  • arrangement of information in your sheet,
  • which totals / subtotals are appropriate to show or not
  • hiding / displaying field headers and +/- buttons in pivot tables
  • sizing and labeling charts clearly, etc.

 

 

  • Using Pivot Tables, sort and summarize this information in order to identify trends and get a perspective on each of the following – do each part (a-c) on a separate sheet / pivot table:

 

  1. You first want to understand how the networks have performed as compared to each other in terms of both average ratings and average viewership across all of their shows and across all years in the dataset. (HINT: do not include the titles of the shows or individual years in the pivot table).

 

  1. Show the networks (rows) in descending order based on average viewership (values) and also include the average ratings (values).
  2. Prepare a Pivot Chart that displays this information. (HINT: a dual vertical axis chart will probably work best due to the difference in the range of values for each metric).

 

  1. Now you are interested to see what sort of track record each network has in terms of developing new shows by looking at how many shows they’ve developed in the last 3 seasons that have been “cancelled in the first season” (status). (HINT: only include information for shows that have this status).

 

  1. Include the network and show titles (rows – in this order), and count of the shows (values) for each year individually (columns).

 

  1. Now let’s look at some specific shows and see how they are performing in terms of overall viewership.

 

  1. We are only interested in shows that are active and are scripted (filters).
  2. Display the viewership for each season (columns) for each network and show (rows) that meet the above criteria.
  • We want to create calculations that show the percentage change in viewership for each year for each show. (HINT: Add a second viewership selection in the Values section of the Field Settings,  then in Value Field Setting select Show Values as “% difference from” . . .  Season . . . previous.)
  1. Because this isn’t a complete list of all shows or all years, we do not want to show sub-totals or grand totals on the table.
  2. Place the % change columns together in the right hand columns by moving the ∑ Values item first in the column field. Center the % change information in their columns.
  3. Change the column labels for the second viewership field to “% change vs. prior year”.
  • You have likely gotten some errors in the % change calculation where there are no values for the prior year. Clean these up – use PT Options (under PT Analyze) and indicate for it to show NA instead of the error message.

[PT Analyze – PT Options (far left on ribbon) – Layout and Format – check “for error values show”, then fill NA in the box behind it].

  • Now let’s highlight those years where the viewership is increasing (green) vs. decreasing (red). Think conditional formatting of the percentage change columns here. “NA” indicators should not be highlighted at all.  You will have 3 conditional format options applied (red for decreasing, green for increasing, white background formatting when the cell value is equal to NA).
  1. What sorts of trends do you see in the viewership of active shows? Are people watching fewer shows?  Are more options available?

 

  • Let’s now turn our attention to developing an advertising rate card and budget. You have learned that the advertising costs are based on the ratings according to the schedule below.  These costs reflect the price of one 30 second commercial.
Over 0.9  $ 400,000
0.8 – .89 350,000
0.7 – .79 300,000
0.6 – .69 250,000
0.5 – .59 200,000
0.4 – .49 175,000
0.3 – .39 150,000
0.2 – .29 125,000
0.1 – .19 100,000
Below .1 80,000

 

On a new sheet – prepare a rate schedule that displays the advertising cost for each show that is on the schedule for next year (status = active & new shows) based on its most recent rating.  (Some current season ratings aren’t available).

  1. If the show has a rating in the current season, use that rating
  2. If the show doesn’t have a current season rating, use the prior season rating.

HINT:  For this step prepare a Pivot Table to isolate the ratings for each show for 2021/2022 and 2020/2021 (you don’t need to include the network information).  You can then copy this information into another sheet [Copy – Paste Values]. Embed VLOOKUPs in an IF Statement to identify the cost to advertise on each show.   This is your rate schedule.

  • Your market research department has compared the demographics of the 2021/2022 shows and has determined that the following shows are optimal selections for reaching your target audience. This step can be done on the same sheet as #2.
A Million Little Things
Blue Bloods
Dancing with the Stars
Grey’s Anatomy
Chicago Med
Shark Tank
Station 19
The Good Doctor
FBI
60 Minutes

 

List each of these shows, then using the rate schedule that you prepared in Step #2 as your lookup range, lookup the show title and return its advertising cost.   Determine what the total cost will be for the current year if you advertise on each of these shows for 13 weeks.  Assume each show will air once per week.  Don’t forget to calculate the total cost.

Briefly address how you recommend that the client evaluate the efficacy of your recommended approach.

Research & Summaries Question

Section 1

Step 1 in action research model is client identifies a problem. Therefore, provide background to problem(s). Provide detail including major players, symptoms of the problem(s) (i.e. turnover is increased, many customer complaints, shooting incident etc.). In this section, you want to briefly review and convince the client that you understand and can describe their pain. What is dysfunctional? Not working? Changing? Why does this organization need an OD consultant?

Section 2

Step 2 in action research model is to consult an OD consultant. In this section, provide a brief biography of each team member (i.e. 1 paragraph description for each member). Discuss your assumptions and philosophical approach to OD (hint- this would be a good time to discuss reframing and how it can be helpful).

Section 3

Step 3 in action research model is for OD consultant to gather data and make a preliminary diagnosis. Here’s where the real work begins! You will need to actually collect data from an organization. Remember, there a number of ways to do this including interviews, surveys, observations, and archival data (i.e. annual reports, published information from media, books written about the organization etc.). Be sure to include information as to why you chose the data collection technique that you did and discuss pros and cons of your choice. Remember, multiple methods are best! You will need to collect as much data as you feel you need to make a good

Section 4

Step 4 in the action research model is to provide feedback to the key client or group. This section of the proposal should include a synopsis of the data that you collected. You may use the feedback forms provided in class as samples or create your own format.

Section 5

Step 5 in the action research model is to jointly diagnose problems with the client and step 6 is to jointly action plan for solutions. Assume that you are working jointly with your client (of course, if you can actually do so, than so much the better but I certainly do not expect this!). This is the longest and most challenging part of your proposal. Here is where you need to take the data that you collected, interpret it using the 4-frame approach, and come up with recommendations (i.e. OD interventions) for solving problems. This section will probably be approximately 6-10 pages. I highly recommend that you use sub-headings within this section. For example, you may want to begin by analyzing the organization using each of the 4 frames as a reference. Next, you should discuss what OD interventions or recommendations you would suggest for resolving each of the issues or problems surfaced from your 4-frame analysis (i.e. teambuilding, reengineering, mentoring, job enrichment). Be sure to clarify how and why you think each intervention would be useful. Assume that your client is relatively naive about the various interventions so provide enough explanation that a layperson would understand.

Section 6

Step 7 in the action research model is action and implementation. Therefore, in this section provide a preliminary action plan which includes information such as time frame, pros and cons of various interventions, and who would be involved in each intervention.

Section 7

Briefly address how you recommend that the client evaluate the efficacy of your recommended approach.

Identify terms and/or phrases that were “acceptable” when you were younger, but are now considered insensitive or offensive. Are these changes for the better?

DISCUSSION POST

Identify terms and/or phrases that were “acceptable” when you were younger, but are now considered insensitive or offensive. Are these changes for the better?