Read the attachment files.
CIS105 At-Home Final Exam Part 1: Project – 70 points
1
MICROSOFT WORD (15 points)
You will create a business portfolio using the tools in MS Word to go with your Final
Exam for CIS105. You will demonstrate your ability to work with the features of MS
Word by creating a document, inserting a table of contents, and describing your
final exam.
a) Create a new document.
b) Create a Title Page with the following information centered on the page:
a. Your First and Last Name
b. Course and Section Number
c. Date
c) Add your MEID as a footer.
d) Insert a Table of Contents.
e) Create a section for each of the components of the Final Exam.
a. PowerPoint Presentation
b. Excel Spreadsheet
c. Access Database
f) For each section, write at least one paragraph describing the outcome of each
assignment on the Final Project.
a. What worked well?
b. What did you struggle with?
c. How long did it take you to complete the assignment?
g) Make sure that each of the three topics above are referenced in the Table of
Contents and set to automatically update.
h) Apply bold formatting to one item.
i) Apply italics to at least one item.
j) Apply Arial 12 point font to the entire document.
k) Save the file as Portfolio_YourName x.
CIS105 At-Home Final Exam Part 1: Project – 70 points
2
MICROSOFT POWERPOINT (15 points)
You will be creating a presentation for Buena Vista Apartments. You are presenting
an overview of the financial outlook for the company. The presentation will include
specific points you want to remember to cover during the meeting.
a) Create a new presentation.
b) Select the Aspect or Trek Theme.
c) Add a new slide with the title text “Buena Vista Apartments – Business
Outlook” as right aligned.
d) Type the subtitle text as “by – Your Full Name & MEID” as right aligned.
e) Modify title text and subtitle placeholders to accommodate the text on the right
side
of the slide.
f) Add a Slide with the title text as “Assessment” and the following items:
a. Look at our current strengths
b. Isolate our current weaknesses
c. Define new opportunities
d. Discuss potential threats to business
g) Insert a business picture from the Clip Art Gallery and resize to fit the left side
of the slide.
h) Add a slide for each of the following and include the bullet list on each slide:
a. Growth Potential
i. Are sales going up or down?
ii. Are profits rising or declining?
iii. Is market share sustained or contracting?
iv. Is the turnover rate high or low?
b. Financial Options
i. Are there any potential investors?
ii. How much will be required for this year?
iii. How much will be needed for expansion?
CIS105 At-Home Final Exam Part 1: Project – 70 points
3
iv. Have we checked commercial banks?
c. Future Outlook
i. Is the business expanding or contracting?
ii. Are we at full capacity or less than capacity?
iii. Are there sufficient resources to match new clients?
iv. Has outsourcing been considered?
i) Add animation to the presentation
j) Save the file with the name Final Exam Presentation.pptx.
CIS105 At-Home Final Exam Part 1: Project – 70 points
4
MICROSOFT EXCEL (20 points)
Williams Auto Sales
You are a car salesperson for Williams Auto Sales. Your manager requires you to
prepare a monthly sales report for him. This report will list all car sales for the
month of January. You will create a summary area which will include highest price,
lowest price, total count, and percentage of cars financed.
a) Open the Microsoft Excel data file from the lesson and save it as
exp07_e02_cpt_02_auto_sol.xlsx.
b) Enter the appropriate formula to calculate total sales and highlight the cell.
c) Compute the total amount paid.
d) Compute the total amount financed.
e) Using the IF Function, compute your commission only on cars that received a
loan. Calculate the commission on those loans at a rate of 1% of the selling
price in column G. Tip: Your IF Function should use the greater than “>”
symbol to be successful.
f) Compute the Total Commission.
g) Highlight the row of the most expensive car.
h) Enter the comment in A11 “My favorite car.”
i) Compute the statistics using Functions as labeled in the data file for the Total
Number of Cars Sold, Highest Priced Car, Lowest Priced Car, and the
Percentage of Cars Financed.
j) Format the completed worksheet using currency and percentage and insert an
appropriate image.
k) Insert today’s date at the bottom of the worksheet.
l) In cell A 25, insert your First Name, Last Name, and MEID.
m) Save your changes and close the workbook.
CIS105 At-Home Final Exam Part 1: Project – 70 points
5
MICROSOFT ACCESS (20 points)
The Cooking Show
The local television station has decided to produce a new cooking show. You have
been hired to manage the database of recipes they will use. You have already
created a database in Access that stores the recipes they will use in their first three
shows.
The producer would like for you to generate a report based on this table. He has
specific requirements for the report. They are as follows:
1. The report should be grouped by category.
2. It should be sorted by recipe name and then by cooking time in ascending
order.
3. He would like to see the average number of servings per category group.
4. He has made a special request that you provide a printout in the same
format as the overall report that shows only recipes that produce 10
servings.
5. He would like the total number of recipes displayed at the end of the report.
Based on these requirements, create the report for your employer. Open the
Microsoft Access data file from the lesson and save it as
exp07_a04_case_sol.accdb.
Create the report based on the Recipes table. Use any report creation method you
like and make sure to include all fields in the table. Select a layout and style of
your own choice. Follow these additional specifications as you create and edit the
report:
Add or change the report logo to an image of your own selection.
Center all data and headings except for Recipe ID and Category
Change the title on the report to Recipe Database
Add your name and MEID to the top right corner of the report header
Using the view of your choice, make sure that the report is laid out attractively on
the page. Manipulate field sizes and placement as needed.
1
CIS105 Survey of Computer Information Systems
Final Project Rubric
Grading will be based upon the accuracy of your work, the appearance of your work, and how well
you apply the features you learned throughout the course. You are to complete and submit all
assessments for this project. Points will be granted in each of the categories listed below.
NOTE: You are only allowed to submit the Final Project once, so do your best work!
Category Description Possible
Points
MS Word
The document will be reviewed based on the successful completion of the
following:
• Use of Header and Footer
• Table of Contents
• Description of your experience completing the Final Project
• Formatting of text
• Correct file name
0-15
MS PowerPoint
The presentation will be reviewed based on the successful completion of the
following:
• Application of a theme
• Using of clipart
• Applying animation
• Adding slides
• Correct file name
0-15
MS Excel
The spreadsheet will be reviewed based on the successful completion of the
following:
• Calculating totals
• Applying formatting
• Computing data using formulas
• Computing data using functions
0-20
MS Access
The database will be reviewed based on the successful completion of the
following:
• Creating a report
• Querying data
• Customizing the look of a report
0-20
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Achiever Papers is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Dissertation Writing Service Works
First, you will need to complete an order form. It's not difficult but, if anything is unclear, you may always chat with us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download