SkillBuilder Workbook Tips
Make sure to refer to the separate instructions document for additional context and hints for the questions in the workbook.
All of your answers should be typed or pasted into the gray or yellow boxes.
Questions with gray answer boxes expect a specific answer. When the correct answer is input, the question number box highlighting will change from pink to green.
Questions with yellow answer boxes are free response questions. There will be no change in the question number boxes (in blue), regardless of answer.
SkillBuilder Questions
This SkillBuilder uses data describing orders from an e-commerce business based in Europe, for the month of April 2018. During this month, the company ran a promotional campaign where existing users could provide a referral code to new users. When the new user makes their first purchase using the referral code, the original user receives €10 in credit.
The data is split across two tables. Orders contains information about sampled orders from the recording period. Users contains information about the users that made purchases during the recording period.
An additional Countries table with country information is provided on the Data Dictionary sheet.
In order to analyze the data, we should join information about the Users and Countries into the Orders table.
1 In the country_code column, fill in the country code for the user that made each purchase.
2 In the country column, fill in the full country name that matches each country code.
3 In the is_referral column, fill in whether or not the user came in from a referral.
4 To the right, create a PivotTable from the combined Orders table that shows the average money spent per order by country and referral status.
5a What is the average spent per order among all non-referral users?
5b What is the average spent per order among all referral-using users?
6 In how many countries do non-referral users spend more per order than referral users?
7 To the right, create a PivotTable from the Orders table that shows the total number of orders and total revenue made by orders from non-referral and referral users.
8a How much revenue was made from non-referral user orders?
8b How much revenue was made from referral user orders?
9 To the right, create a second PivotTable from the Users table that shows how many non-referral and referral users there are.
10 How much did the company pay out for new referral users?
11a What is the average number of purchases made by non-referral users during the promotional period?
11b What is the average number of purchases made by referral users during the promotional period?
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
