BIS 155 Academic professor/tutorialrank.com

1
BIS 155 Academic professor/tutorialrank.com
For more course Tutorials
www.tutorialrank.com
2
BIS 155 Academic professor/tutorialrank.com
BIS 155 Entire Courses
BIS 155 Course Project Excel Project
Objective The general instructions for this
project can be found in the Week 6 Lecture
material. The Week 6 Lecture describes the
assignment and provides an overview of the
project as a whole. There are no step-by-steps
for the course project. The following are grading
criteria for this project. Guidelines Organize
the Data Data imported from SalesData.csv text
file located in Course Project Materials in
DocSharing. Professional formatting follows the
formatting guidelines we studied during the first
week of class. Documentation sheet added to
provide author, purpose, and date and provide
information about each of the sheets
BIS 155 Course Project Excel Project BIS 155 Lab
1 of 7 Saddle River Marching Band BIS 155 Lab 2
of 7 Excel's Advanced Formulas Functions BIS
155 Lab 3 of 7 Alice Barr Realty Analysis BIS
155 Lab 4 of 7 Create Address Labels BIS 155 Lab
5 of 7 Bruno's Pizza Analysis BIS 155 Lab 6 of
7 Day Care Center BIS 155 Lab 7 of 7 Access
Database
3
BIS 155 Academic professor/tutorialrank.com
BIS 155 Lab 4 of 7 Create Address Labels
BIS 155 Lab 2 of 7 Excel Advanced Formulas and
Functions
You are an intern at First National Bank working
in the loan department, and your boss has asked
you to prepare the monthly "New Loan Report" for
the Board of Directors. This analysis report will
clearly list and summarize all new loans for
residential housing in the past month. The
summary area includes the loan statistics as
labeled data in the data file. The format of the
report is appropriate for the Board of Directors
for the First National Bank. 
Create labels for the letters. The XYZ
Corporation wishes to use mailing labels to
address the envelopes. They own 8 1/2 x 11"
sheets of label paper with 1" by 4" labels, which
they purchased from Office Depot. Download the
Lab 4, Step 3 Instructions. A. Create a new file
for printing labels. B. Merge data from your
Excel spreadsheet into the new label document. Sub
mit your completed workbook and the two
Word documents (merged letters and merged labels)
to the Dropbox. Make sure you posta comment
about what you learned
4
BIS 155 Academic professor/tutorialrank.com
BIS 155 Labs 3 of 7 Alice Barr Realty Analysis
BIS 155 Labs 1 of 7 Saddle River Marching Band
Submit your assignment to the Drop box located on
the silver tab at the top of this page. L A B O
V E R V I E W Scenario/Summary You are the
assistant to the band director for the Upper
Saddle River Marching Band, and you must prepare
a report showing the status of the marching band
fundraising event for presentation to the board
of trustees. The report will summarize all sales
of all items and include the total profit-to-date
with the amount remaining to reach the profit
goal. You will open the partially completed
workbook, create formulas, format for
presentation to the board, and add charts to
graphically depict the sales over time and by
product. 
You are an intern with the Regional Realty
Association and are analyzing the claim made by
Alice Barr Realty that "we get your price." You
have prepared a spreadsheet that shows data
relating to 3 months' sales by Alice Barr Realty.
You are going to determine the percent of asking
price for each home sold and analyze the sales
data to determine the true track record of
the company in selling homes for the asking
price. STEP 1 Open, Save, and Document
the Workbook (5 points) You must open a workbook
that lists home sales for 3 months.
5
BIS 155 Academic professor/tutorialrank.com
BIS 155 Labs 6 of 7 Day Care Center
BIS 155 Labs 5 of 7 Bruno's Pizza Analysis
The owner of Bruno's Pizza, Joe Bruno, wants to
evaluate the profitability of his three
restaurants before he expands further. He is
particularly interested in the comparative
results of three dining categories, dine-in,
pickup, and delivery. Joe has asked for your help
in doing this analysis in return for a small
stipend and all the pizza you can eat. You have
already prepared a template and distributed it to
each restaurant manager, who has entered the
sales data for last year. Your next task is to
consolidate the data into a single workbook that
shows the total sales for each quarter and each
dining category. The information should be shown
in tabular, as well as graphical formats. You
will also create a documentation
Your friend, Jane Morales, is considering opening
a Day Care Center. She has started compiling her
assumptions and putting together an Income
Statement. She has determined that she must make
at least 75,000 profit per year in order to
start the business. She has asked you to analyze
her Income Statement and help her determine
whether it is viable for her to start this
business. You have agreed to help her complete
her Income Statement and to perform What-If
analysis to help her look at her potential
profitability.
6
BIS 155 Academic professor/tutorialrank.com
BIS 155 Labs 7 of 7 Access Database
Hopefully you will find this week's lab activity
fun and useful. If you have never created a
database, you will be able to tell all of your
friends and family that you are now a database
designer. You will walk through the steps of
creating and populating an Access database to
keep a record of items in your home. The database
will have a table, a form, a query, and a
report. Turn in one database named
Lab7_yourlastname.accdb to the DropBox. When
submitting the database, provide a comment in the
Dropbox comments area explaining what you learned
from completing this lab activity. 
7
BIS 155 Academic professor/tutorialrank.com
For more course Tutorials
www.tutorialrank.com