- This is Phase 6 of your final capstone project.
- The outline for your presentation should have been submitted in Workshop Four and your preliminary presentation in Workshop Five for instructor feedback.
- Make any edits based on the feedback you received, and use the instructions from the Capstone Project Guide that provides specifics on what the presentation needs to contain.
Global Marketing
What do you see as some of the challenges that we will face in global marketing in the years to come?
After reviewing this week’s resources and your research, in your own words identify and explain two challenges facing global marketing leaders. Explain the impact and provide at least one strategy to address and tackle each challenge identified. Discuss the impact of the pandemic on global marketing.
Your initial response to the discussion question should be 250-300 words. You must have at least one course (our text) and one non-course scholarly/peer reviewed source in your initial posting. Sources require in-text citations and must be incorporated into the body of the post in addition to a full APA citation at the end of the post.
References:
6 Post-Pandemic Marketing Strategies With Long-Term Benefits
Urgent 2
Need Urgent
ItemStack
nmkl;’
Find data, explore data, make some pretty pictures
1. For this project you must find some published or existing data. Possible sources include: almanacs, magazines and journal articles, textbooks, web resources, athletic teams, newspapers, professors with experimental data, campus organizations, electronic data repositories, etc. Your dataset must have at least 250 cases, two categorical variables and two quantitative variables. It is also recommended that you are interested in the material included in the dataset. 2. Utilizing technology preform exploratory data analysis, EDA. (a) For at least one of the quantitative variables, include summary statistics (mean, standard deviation, five number summary) and graphical displays (histogram, box plot and qq plot). Are there any outliers? Is the distribution normal, symmetric, skewed, or some other shape? (b) Create a graphical display looking at multiple variables and their correlation. (c) For at least one of the categorical variables, include a frequency and relative frequency table. (d) Include a two-way table for two of the categorical variables and discuss any relevant proportions. Describe any possible relationship between the two variables. (e) Include a side-by-side plot for at least one categorical and at least one quantitative variable. Describe any association between the two variables. Use summary statistics to compare groups. (f) Create a visualization or preform a statistical computation that is appropriate to your data but not already included. 3. Write your report! (a) Introduce your data set including a reference to where it can be found. Describe all relevant variables that you will use in your analysis. (b) Describe all ways that were neseccary to clean and organize the data. (c) Include all items requested above. Include graphs and text about each. (d) Write a brief conclusion highlighting the most interesting features of your data. The report will be graded by the following criteria: Statistical analysis – 30 points. The statistical tests are all provided. Graphical Representations – 30 points. The requested graphical displays are made and included in report. Data collection – 15 points. The data is gathered in a responsible way. The method of collection is clearly stated and variables are all explained. If a sample of the data is used it is done in a proper way. Interpretations – 15 points. The results of the statistical analysis are clearly explained and interpreted in the context of the problem. The conclusions accurately reflect the analysis and are well supported. Writing quality – 10 points. The paper is readable and clearly written. There are few, if any, grammatical or spelling errors and they do not interfere with the clarity of the paper. Numbering on this document is not used in the report in anyway.
Exercises
Exercise P1.1. Write a program that prints the message, “Hello, my name is Hal!”
Then, on a new line, the program should print the message “What would you like
me to do?” Then it’s the user’s turn to type in an input. You haven’t yet learned how
to do it—just use the following lines of code:
string user_input;
getline(cin, user_input);
Finally, the program should ignore the user input and print the message “I am sorry,
I cannot do that.”
This program uses the string data type. To access this feature, you must place the
line
#include
before the main function.
Here is a typical program run. The user input is printed in boldface.
Hello, my name is Hal!
What would you like me to do?
Clean up my room
I am sorry, I cannot do that.
When running the program, remember to hit the Enter key after typing the last
word of the input line.
P1.3. Write a program that computes the sum of the first ten positive integers,
1 + 2 + … + 10. Hint: Write a program of the form
int main()
{
cout <<
return 0;
}
Exercise P2.3. Write a program that prompts the user for two integers and then
prints
• The sum
• The difference
• The product
• The average
• The distance (absolute value of the difference)
• The maximum (the larger of the two)
• The minimum (the smaller of the two)
Hint: The max and min functions are defined in the algorithm header.
Exercise P2.30. Your boss, Juliet Jones, is getting married and decides to change her
name. Complete the following program so that you can type in the new name for
the boss:
int main()
{
Employee boss(“Jones, Juliet”, 45000.00);
// Your code goes here; leave the code above and below unchanged
cout << "Name: " << boss.get_name() << "n";
cout << "Salary: " << boss.get_salary() << "n";
return 0;
}
The problem is that there is no set_name member function for the Employee class.
Hint: Make a new object of type Employee with the new name and the same salary.
Then assign the new object to boss.
Exercise P3.3. Write a program that reads in three floating-point numbers and prints
the largest of the three inputs. For example:
Please enter three numbers: 4 9 2.5
The largest number is 9.
Exercise P3.16. Write a program that first asks the user to type in today’s exchange
rate between U.S. dollars and Japanese yen, then reads U.S. dollar values and converts
each to Japanese yen. Use 0 as the sentinel value to denote the end of dollar
inputs. Then the program reads a sequence of yen amounts and converts them to
dollars. The second sequence is terminated by the end of the input file.
Exercise P4.2. Write a procedure void sort2(int& a, int& b) that swaps the values
of a and b if a is greater than b and otherwise leaves a and b unchanged. For example,
int u = 2;
int v = 3;
int w = 4;
int x = 1;
sort2(u, v); // u is still 2, v is still 3
sort2(w, x); // w is now 1, x is now 4
Exercise P4.8. Write a function
double get_double(string prompt)
that displays the prompt string, followed by a space, reads a floating-point number
in, and returns it. (In other words, write a console version of cwin.get_double.)
Here is a typical usage:
salary = get_double(“Please enter your salary:”);
perc_raise =
get_double(“What percentage raise would you like?”);
If there is an input error, abort the program by calling exit(1). (You will see in
Chapter 5 how to improve this behavior.)
Exercise P4.15. Consider the following buggy function:
Employee read_employee()
{
cout << "Please enter the name: ";
string name;
getline(cin, name);
cout <> salary;
Employee r(name, salary);
return r;
}
When you call this function once, it works fine. When you call it again in the same
program, it won’t return the second employee record correctly. Write a test harness
that verifies the problem. Then step through the function. Inspect the contents of
the string name and the Employee object r after the second call. What values do you
get?
Exercise P5.1. Implement all member functions of the following class:
class Person
{
public:
Person();
Person(string pname, int page);
void get_name() const;
void get_age() const;
private:
string name;
int age; // 0 if unknown
};
visualiation
This week we focus on establishing your editorial thinking. What does the author mean by editorial thinking? Also, this week there was a video of Andy Kirk (2015) noting the key concepts of data visualization thinking. Please pick one major concept from the video and note what was said and your thoughts about the topic.
When thinking about data visualization, it is important to understand regular expressions in data analytics. Therefore, note the importance of data visualizations and choose two types of expressions (* – wildcards for example) and discuss the difference between the two types of expressions.
PowerPoint presentation
PowerPoint presentation on Microsoft Power BI
ITSD427U1U2U3IP
Assignment Description
For this assignment, complete the following steps:
- Write a research paper of 4-5 pages (cover and references pages not included in page count) that details the design and layout characteristics of Android phone applications.
- Specifically describe the design process for an Android phone application.
- Include a discussion of the role of Extensible Markup Language (XML) in the design process and how XML is used in the Android application files.
- Discuss the best practices and also the problems and solutions regarding design, layout, performance, compatibility, and security.
- Explain the difference between a light and a heavy layout and how they both relate to overall performance
UNIT2
Assignment Description
Note: Prior to developing your project, please make sure you have downloaded and installed the Android Studio IDE and the Android Development Tools (ADT) according to the instructions found by clicking here.
Assignment Details
You have been hired to create a mobile application for Healthy Life, a local organic bakery and grocery store. The owners want to offer a mobile application to customers that features recipes that contain ingredients that they sell in their store. Over the next few weeks, you will be developing, testing, and deploying the mobile application based on the specifications provided for each assignment. Once completed, you will be demonstrating the mobile application to the client.
The following specification is what the client has requested:
- Create a new Android Application Project.
- The main screen should state the name of the person who owns the phone.
- The recipe application should have a tile or visual shortcut placed in the application list.
- The application should have a splash screen that serves as an appropriate graphical advertisement for the application.
- The application should use an appropriate template design and application icon image.
- Once opened, the main page of the application should use the page name of Healthy Life and a normal full-screen layout using a 2-column grid control in the Content Panel with 4 buttons in the right column and 4 corresponding images in the left column of the grid control. The text of the four buttons should read: Bread, Fruits, Vegetables, and Soup, respectively. Note: In Phase 5, the buttons will be linked to the corresponding recipe category in a local database.
- Test your application by running the Android Phone Emulator.
- Create screenshots of all of the relevant screens of your running application, and save them in a Word document named “yourname_ITSD427_IP2.docx.” You should also use this document to describe the work you performed for this assignment, with specific details regarding the locations and changes of the code you created and modified.
- Save and close the project. Zip the entire project, including your screenshots and work description, to a file named “yourname_ITSD427_IP2.zip,” and submit the ZIP file to the dropbox.
UNIT3
Assignment Details
Assignment Description
In the prior phase, you started work on some of the application’s graphical user interface (GUI). In this assignment, you will add a data entry form to the GUI and create a local database that will synchronize data to the isolated storage container of the mobile device.
The following are the steps that you need to accomplish:
- Create a second page with a data entry form and the following fields: recipename, category, ingredients, and instructions.
- Make the Category field a dropdown box that contains the recipe categories listed in the Individual Project for Unit 2.
- Create Add and Delete buttons.
- Create the database necessary to store the information associated with the data entry form.
- Modify the application code to support addition and deletion of data in the database.
- Test the application in the Android Phone Emulator.
- Create screenshots of all of the relevant screens of your running application, and save them in a Word document named “yourname_ITSD427_IP3.docx.” You should also use this document to describe the work you performed for this assignment, with specific details regarding the locations and changes of the code you created and modified.
- Save and close the project. Zip the entire project, including your screenshots and work description, to a file named “yourname_ITSD427_IP3.zip,” and submit the zip file to the dropbox.
Exp22_Excel_Ch05_HOE – Sociology 1.1
Exp22_Excel_Ch05_HOE – Sociology 1.1
Exp22 Excel Ch05 HOE Sociology 1.1
Excel Chapter 5 Hands-On Exercise – Sociology
Project Description:
You are the vice president of the Sociology Division at Ivory Halls Publishing Company. Textbooks are classified by an overall discipline. Books are further classified by area. You will use these classifications to see which areas and disciplines have the highest and lowest sales. The worksheet contains wholesale and retail data. You want to analyze sales for books published in the Sociology Division. To do this, you will organize data by discipline and insert subtotal rows. You will also create PivotTables to gain a variety of perspectives of aggregated data. Finally, you will create a PivotChart to depict the aggregated data.
Start Excel. Download and open the file named Exp22_Excel_Ch05_HOE_Sociology.xlsx. Grader has automatically added your last name to the beginning of the filename.
Your first task is to sort the dataset on the Books Subtotal worksheet.
Ensure the Books Subtotal worksheet is active. Sort the data by Discipline in alphabetical order and further sort it by Area in alphabetical order.
You want to subtotal the dataset by Discipline and then add a second set of subtotals by Area.
Use the Subtotal feature to insert subtotal rows by Discipline to calculate the totals for the Sales Wholesale, Sales Retail, and Total Book Sales columns. Without removing the first subtotals, insert subtotals by Area to calculate totals for the same columns.
Next, you want to apply an outline to the columns so that you can collapse or expand the Units Sold and Unit Price columns.
Create an automatic outline. Collapse the outline above columns H and K.
Next, you want to create a recommended PivotTable and then name it.
Display the Books Data worksheet and create a recommended PivotTable using the Sum of Units Sold thumbnail. Change the name of the worksheet to PivotTable. Name the PivotTable Total Book Sales.
You want to compare total book sales by discipline and copyright year.
Make sure these fields are in the respective areas. Remove extra fields. Place the Discipline field in rows, Total Book Sales field as values, and Copyright field in columns.
You will format the values in the PivotTable to look more professional and change the custom names that display as column headings.
Click or select cell B5, display the Value Field Settings dialog box, and type Sales by Discipline as the custom name. Apply Accounting Number Format with zero decimal places.
You want to replace the generic Row Labels and Column Labels headings with meaningful headings.
Type Discipline in cell A4 and Copyright Year in cell B3. Select the range B4:E4 and center the labels horizontally.
On the Books Data sheet, you want to insert functions that will display the total sales and the total Introductory discipline sales data from the PivotTable. You will change the retail unit price rate from 30% to 25% and then refresh the PivotTable.
Display the Books Data worksheet. In cell B1, enter the GETPIVOTDATA function to get the value from cell F10 in the PivotTable worksheet. In cell B2, enter the GETPIVOTDATA function to get the value from cell F7 in the PivotTable. Change the value in cell J1 to 125 in the Books Data worksheet, and then refresh the PivotTable.
You will add a field to the Filters area so that you can filter the list by Edition.
Add the Edition field to the Filters area.
Because you plan to distribute the workbook to colleagues, you will insert a slicer to help them set filters.
Insert a slicer for Discipline. Move the slicer so that the top-left corner is just inside the corner of cell A13.
After inserting the slicer, you want to change the dimensions and appearance of it.
Change the slicer to display 2 columns. Change the button width to 1.5 inches. Change the slicer height to 2 inches. Apply Light Blue, Slicer Style Dark 1.
You want to calculate the amount of the sales returned to the authors as royalties.
Create a calculated field with the name Author Royalties. Multiply Total Book Sales by *.1. In cell C5, use the Field Settings to type the custom name Authors’ Royalties.
Format cells C5, E5, G5, and I5 with Center horizontal alignment and wrap text. Change the height of row 5 to 30. Change the width of columns C, E, G, and I to 12.
You want to display the Total Book Sales as a percentage of the grand total.
Select the Total Book Sales and show the values as a percentage of the grand total.
To enhance the readability of the sociology textbook PivotTable, you will change the PivotTable style.
Apply Light Blue, Pivot Style Medium 2 to the PivotTable. Display banded columns.
The Books, Disciplines, and Editors worksheets contain tables You will create relationships between the Books table and the other two tables.
Display the Books worksheet. Create a relationship between the BOOKS table using the Discipline Code field and the DISCIPLINE table using the Disc Code. Create a relationship between the BOOKS table using the Editor ID field and the EDITOR table using the Editor ID field.
Now that you built a relationship between the tables, you can create a PivotTable using fields from all three tables.
Create a blank PivotTable from within the Books worksheet and add the data to the data model. Name the worksheet as Relationships.
You are ready to add fields from the three tables to the PivotTable.
Display all tables within the PivotTable Fields pane. Place the Total Book Sales field from the BOOKS table in the Values area. Place the Discipline field from the DISCIPLINE table in the Rows area. Place the Editor Last field from the EDITOR table below the Discipline field in the Rows area.
Format the Total Book Sales field with Accounting Number Format with zero decimal places.
You want to create a PivotChart to display percentages in a pie chart.
Create a PivotChart from the PivotTable you just created. Change the chart type to a pie chart. Cut the chart and paste it just inside the top-left corner of cell C1.
The PivotChart has too much detail. You will filter the chart to display only one discipline.
Filter the PivotChart by displaying only the Family discipline. Sort the PivotTable by the Total Book Sales from largest to smallest.
The chart needs a meaningful title.
Change the chart title to Family Discipline Book Sales.
You want to add data labels to provide more details to the chart.
Display data labels in the best fit position with only the Percentage labels. Deselect the Values data labels.
Save and close Exp22_Excel_Ch03_ HOE_Sociology.xlsx. Exit Excel. Submit the file as directed.
