CS2 Project 1 2024, Excel
🎰
<<< Back to
main site
Due Date: 2024/9/26
Need help? Remember to check out Edstem and our Website for TA help
assistance.
Please read the submission guidelines at the end of this assignment
carefully!
Project Description
🎰
You're applying to the finance department at Marco Bellini's brand new chain of luxury casinos! You are
in charge of managing the revenue from games and slots for the first few days of operation. In this
project, you will make and turn in a single Excel file with:
- A sheet tracking profits for each location's revenue from games and slots called
Profits
- A sheet looking at profit statistics called Statistics
Project Goals
- Use Excel functions on multiple spreadsheets to calculate data
- Organize and format data into readable tables and charts
If you do not have Excel installed, start with the Excel lab to get set up before beginning this
assignment. It’s recommended that you complete all labs before their associated projects.
NOTE: Do not use Google Sheets. Please make a new file using Microsoft Excel and edit the file only
using Microsoft Excel.
Tasks 🎰
Task 1: Double click your "CS2" folder on your desktop, and enter
your folder for "Excel". Then, create a new folder inside called "Excel Casino Project". All your
files for this Project should live in this folder.
Create a new Excel file and rename it Excel_Casino_Project, then save it
to your newly created "Excel Casino Project" folder. (Check how to use save-as in
lab 1 for help!).
Profits
Looks like some of the revenue data was not recorded correctly for each casino location. Let's figure
out the correct values by looking at the totals of each column and row.
Task 2 Copy the table below into your first sheet. Name the sheet
Profits. (You can copy and paste this directly into your excel sheet)
| TABLE 1 |
Day 1 Profit |
Day 2 Profit |
Day 3 Profit |
Day 4 Profit |
Total Profit |
| Las Vegas |
$120,630 |
$115,580 |
|
$120,400 |
$500,960 |
| Atlantic City |
$130,530 |
$135,485 |
$125,695 |
|
$532,200 |
| Macau |
$115,420 |
$112,250 |
$119,390 |
$115,465 |
|
| Monte Carlo |
$120,245 |
|
$130,250 |
$120,180 |
|
| Singapore |
|
$130,585 |
$115,450 |
$125,195 |
$494,430 |
| Reno |
$115,220 |
$115,230 |
$120,470 |
|
$483,165 |
| Total for Each Day |
$725,245 |
$712,385 |
|
$753,975 |
$2,947,210 |
Task 3 Format the table - differently from the default - to make it
easily readable and aesthetically pleasing (to your best judgment). For large tables with many
different labels and data types, this makes it easier to catch mistakes and skim data for general
trends. If you’re lost, look back at the formatting section of lab! Make sure to change the table to
a color of your choice!
Recall from the lab, using "dynamic formulas" means using cell references or using functions like
SUM(cell:cell) to calculate values.
Task 4 Fill in the empty cells using dynamic formulas (like the ones
in the lab). Typing out numbers will get you no credit.
Tips
- Before you start, highlight cells that you
will fill with dynamic formulas a different color than the rest of the sheet, so you can
easily check them as you go by double-clicking on them to see what other cells are used in
the calculation.
- If there is only 1 cell in a given row or
column that is blank, then you can definitely find out what it is (for example, if the total
sum for Day 4 was missing but the sums for each location are all there, we can add them up
to fill in the blank). If there are two cells missing in a given row or column, try solving
for the other blank cells first, then going back to it.
NOTE: If you do not use dynamic formulas (i.e. you manually input the
number), you will not receive credit.
Task 5 Format numbers as dollar amounts. (Look at toolbar
options)
Drinks
Task 6 Copy the table below on the same sheet and format it the same
as the last table.
| TABLE 2 |
Drinks Sold |
Revenue per Drink Sold |
Cost to Make Drink |
Profit |
| Las Vegas |
817 |
3 |
2 |
|
| Atlantic City |
651 |
3.50 |
2 |
|
| Macau |
497 |
6 |
2 |
|
| Monte Carlo |
536 |
5 |
2 |
|
| Singapore |
482 |
5.50 |
2 |
|
| Reno |
577 |
4 |
2 |
|
Task 7 Fill in the empty cells by only typing in 1 dynamic formula
and auto-populating the rest. Write how you did this in a cell right below this table. A couple of
sentences will do.
Task 8 Format the numbers that represent dollars as dollar
amounts.
Statistics
Now it's time to gain some insights into our profit margins!
Task 9 Create a new sheet called "Statistics". In that sheet create
three tables with a row for each location from before, and one column for each statistic below.
There should be 3 separate tables. (each having one
column with rows for all locations, and one additional column for the appropriate statistic.)
- Average Profit Over 4 Days
- Highest Profit Received in 1 Day
- Your choice - pick a statistic (using a dynamic formula) to calculate
Task 10 Fill in each cell with dynamic formulas using cells from the
Casino table in the Profits sheet. (You must use a function that calculates these values, not by
manually calculating the value, e.g. by summing then dividing manually for average.) Dynamic
equations you can use, in this case, are the SUM/MAX/MIN/AVERAGE
etc.
Tip
How were you able to refer to Financials in Summary from the lab?
Graphs and Charts
Task 11 Using the table you just created, create a graph for the
Average Revenue Over 4 Days (using the excel
AVERAGE formula) and a graph for Highest Revenue Received
in 1 Day. They must be two distinct types of graphs (e.g. bar and line)
and have titles. The type of graph must be logical for the data it is representing.
Task 12 Format all number amounts that represent dollar amounts as
dollar amounts.
Task 13 Name each chart appropriately to describe the data it
represents.
Double-check your work
🧏♀️
The Profits sheet should have a total of
two tables.
The Statistics sheet should have a total of
three tables and
two graphs.
Fill out our feedback form for 2 points
of extra credit on this project! :)
Hand-In 🎰
To Hand-In Project 1:
Zipping files is a way to compress one or more files into a single file that is often smaller than
the source files; you’ll submit all homework assignments through Canvas by uploading one zipped file
containing all of your work.
To do this
-
Rename your source files so they do not contain your
name. This is especially important in order to maintain the
course’s anonymous grading policy that ensures your assignments are graded fairly. We will
deduct points if your files contain identification data.
-
Make sure you have the correct, most up-to-date
files before zipping. We’ve had students in the past send in older
versions that didn’t contain all their finished work! You will receive a 10% deduction if
TAs must regrade your work due to incorrect files.
-
Create a .zip file
Windows:
In Windows Explorer, go to the folder containing the files you want to zip. Select the
files, then right-click on any of the selected files and select Send To… ->
Compressed (zipped) Folder.
Mac:
In Mac Finder, go to the folder containing the files you want to zip. (This would be
your “Excel Project” folder) Select the files, then right-click on any of the selected
files and select Compress Items.
-
Right click on the newly created zip file to rename it. The name of your file should be
BannerID_ExcelProject.zip (replace "BannerID" with your own banner id,
starting with B0...)
-
Submit on Canvas under the Excel Project assignment!
Congrats! You just finished the Excel Project! 
CS2 Project 1 2024, Excel 🎰
<<< Back to main site
Project Description 🎰
You're applying to the finance department at Marco Bellini's brand new chain of luxury casinos! You are in charge of managing the revenue from games and slots for the first few days of operation. In this project, you will make and turn in a single Excel file with:
Project Goals
If you do not have Excel installed, start with the Excel lab to get set up before beginning this assignment. It’s recommended that you complete all labs before their associated projects.
NOTE: Do not use Google Sheets. Please make a new file using Microsoft Excel and edit the file only using Microsoft Excel.
Tasks 🎰
Task 1: Double click your "CS2" folder on your desktop, and enter your folder for "Excel". Then, create a new folder inside called "Excel Casino Project". All your files for this Project should live in this folder.
Create a new Excel file and rename it
Excel_Casino_Project, then save it to your newly created "Excel Casino Project" folder. (Check how to use save-as in lab 1 for help!).Profits
Looks like some of the revenue data was not recorded correctly for each casino location. Let's figure out the correct values by looking at the totals of each column and row.
Task 2 Copy the table below into your first sheet. Name the sheet Profits. (You can copy and paste this directly into your excel sheet)
Task 3 Format the table - differently from the default - to make it easily readable and aesthetically pleasing (to your best judgment). For large tables with many different labels and data types, this makes it easier to catch mistakes and skim data for general trends. If you’re lost, look back at the formatting section of lab! Make sure to change the table to a color of your choice!
Recall from the lab, using "dynamic formulas" means using cell references or using functions like
SUM(cell:cell)to calculate values.Task 4 Fill in the empty cells using dynamic formulas (like the ones in the lab). Typing out numbers will get you no credit.
Tips
NOTE: If you do not use dynamic formulas (i.e. you manually input the number), you will not receive credit.
Task 5 Format numbers as dollar amounts. (Look at toolbar options)
Drinks
Task 6 Copy the table below on the same sheet and format it the same as the last table.
Task 7 Fill in the empty cells by only typing in 1 dynamic formula and auto-populating the rest. Write how you did this in a cell right below this table. A couple of sentences will do.
Task 8 Format the numbers that represent dollars as dollar amounts.
Statistics
Now it's time to gain some insights into our profit margins!
Task 9 Create a new sheet called "Statistics". In that sheet create three tables with a row for each location from before, and one column for each statistic below. There should be 3 separate tables. (each having one column with rows for all locations, and one additional column for the appropriate statistic.)
Dynamic Formulas
Task 10 Fill in each cell with dynamic formulas using cells from the Casino table in the Profits sheet. (You must use a function that calculates these values, not by manually calculating the value, e.g. by summing then dividing manually for average.) Dynamic equations you can use, in this case, are the
SUM/MAX/MIN/AVERAGEetc.Tip
How were you able to refer to Financials in Summary from the lab?
Graphs and Charts
Task 11 Using the table you just created, create a graph for the Average Revenue Over 4 Days (using the excel
AVERAGEformula) and a graph for Highest Revenue Received in 1 Day. They must be two distinct types of graphs (e.g. bar and line) and have titles. The type of graph must be logical for the data it is representing.Formatting
Task 12 Format all number amounts that represent dollar amounts as dollar amounts.
Task 13 Name each chart appropriately to describe the data it represents.
Double-check your work 🧏♀️
The Profits sheet should have a total of two tables.
The Statistics sheet should have a total of three tables and two graphs.
Extra Credit 🎰
Fill out our feedback form for 2 points of extra credit on this project! :)
Hand-In 🎰
To Hand-In Project 1:
Zipping files is a way to compress one or more files into a single file that is often smaller than the source files; you’ll submit all homework assignments through Canvas by uploading one zipped file containing all of your work.
To do this
Rename your source files so they do not contain your name. This is especially important in order to maintain the course’s anonymous grading policy that ensures your assignments are graded fairly. We will deduct points if your files contain identification data.
Make sure you have the correct, most up-to-date files before zipping. We’ve had students in the past send in older versions that didn’t contain all their finished work! You will receive a 10% deduction if TAs must regrade your work due to incorrect files.
Create a .zip file
Windows:
In Windows Explorer, go to the folder containing the files you want to zip. Select the files, then right-click on any of the selected files and select Send To… -> Compressed (zipped) Folder.
Mac:
In Mac Finder, go to the folder containing the files you want to zip. (This would be your “Excel Project” folder) Select the files, then right-click on any of the selected files and select Compress Items.
Right click on the newly created zip file to rename it. The name of your file should be
BannerID_ExcelProject.zip(replace "BannerID" with your own banner id, starting withB0...)Submit on Canvas under the Excel Project assignment!
Congrats! You just finished the Excel Project!
If you have any issues with completing this assignment, please reach out the course HTAs: cs0020headtas@lists.brown.edu
If you need to request an extension, contact Professor Stanford directly: don.stanford@gmail.com