MS Office Suite, Introduction 20755 Integrated Capstone Project
Revised BMS 12/29/19
INTEGRATED CAPSTONE PROJECT Mr. Carlyle would like you to complete the report, workbook and presentation for his
upcoming yearly meeting. Review your Capstone Projects from each software to review
your key concepts. The goal is to have a business professional report, workbook and
presentation. You are to integrate your skills using Microsoft Word, Excel, PowerPoint and
Outlook.
WORKBOOK
The Apple Valley Paper Year-End workbook needs to be completed. Apply a theme, use
styles, number formats, and complete the workbook with consistent formatting and use of
formulas and functions. Use a minimum 12-point font. At a minimum include the following:
Complete the Safety Worksheet by calculating our total safety incidents.
Create a chart using the Safety Worksheet.
Update all monthly worksheets with consistent formatting and formulas.
Complete the Year-End Net Income worksheet by calculating the total Net Income for
the year. (The Year-End Net Income worksheet is a Summary Worksheet.)
Apply conditional formatting on the Year-End Net Income worksheet to indicate the
top three divisions Net Income.
Create a chart on the Year-End Net Income worksheet using the Percent of Total.
On the Employees Worksheet, use a function to determine what bonus amount each
employee will receive. If they have been employed five years or more, they will
receive a $500 bonus and if they were employed less than 5 years, they will receive a
$100 bonus.
Apply consistent formatting to all worksheets.
Safety and Year-End Net Income worksheets: Change orientation to Landscape and
Scale to Fit one page width and height.
Employees worksheet: Change orientation to Landscape and Scale to Fit one page
width.
Arrange monthly worksheets in order.
BUSINESS REPORT
Based on the data created in your workbook, Mr. Carlyle would like you to create a Business
Report using Word. Start a new document, apply a consistent theme and formatting to
match your workbook. Use the Apple Valley Paper website to complete the report along
with your Year-End workbook. At a minimum include the following:
Apply a theme and styles of your choice.
Your report needs to be a minimum of four pages of content and a cover page.
o About: Include general information about Apple Valley Paper from their
website.
Revised BMS 12/29/19
o People: Include all members of Apple Valley Paper from their website.
o Financial: Include year-end information from your Excel Workbook.
o Products: Include information about Apple Valley Paper Products from their
website.
Use the Apple Valley Paper logo provided in AVP Information button in Blackboard.
Business Professional Images, some are provided in AVP Information button in
Blackboard. You need to determine where and how many images should be included.
Include additional professional images as you need.
Include Charts from the AVP Year-End Excel Workbook.
Must include a table, tabbed list and a SmartArt of your choice with appropriate
formatting and enhancements.
Feel free to use information from your other capstone projects to add content.
Review your document to ensure your information fully fills the pages. (Minimal
white/blank space) Insert other pictures, shapes, or icons if necessary.
BUSINESS PRESENTATION
Mr. Carlyle would like to take the contents of the Business Report and Year-End workbook
and use it at an upcoming investor meeting for future expansion. Create a minimum of 8
slides. At a minimum include the following:
Apply a theme and styles of your choice.
Create a minimum of 8 slides but include the following:
o Title Slide
o Agenda Slide
o About Slide
o People Slide
o Financial Slide
o Products Slide
o Thank You Slide
Include charts, SmartArt, Business Professional Images, video, and Icons of your choice.
Minimum of 60-point font size on titles and 24-point font size on text.
EMAIL TO MR. CARLYLE
Mr. Carlyle would like your project to be emailed to him for review. (Your email will be sent to
your instructor at [email protected].)
At a minimum include the following:
Professionally formatted email includes salutation, body and complimentary closing.
Include signature
Include the Business Report, Workbook, and Presentation as attachments.
mailto:[email protected]
Revised BMS 12/29/19
INTEGRATED CAPSTONE GRADING RUBRIC
Rating Value Rating Description
2 Proficient: Performs effectively, efficiently, and independently.
1 Competent: Performs adequately, meets basic standards.
0 Work does not meet standards
SCORING GUIDE CRITERIA RATINGS
Integrated Capstone Project Contains a completed workbook with the following
enhancements and formats.
? Theme applied. 1 0
Safety Worksheet
? Consistent formatting using styles. 1 0
? Number formatted. 1 0
? Use of Formulas and Functions appropriately. 1 0
? Created Chart 1 0
? Formatted Chart 1 0
? Applied Enhancements 1 0
Year-End Net Income Worksheet
? Consistent formatting using styles. 1 0
? Number formatted. 1 0
? Use of Formulas and Functions appropriately. 1 0
? Applied Conditional Formatting 1 0
? Created Chart 1 0
? Formatted Chart 1 0
? Applied Enhancements 1 0
Employees Worksheet
? Consistent formatting using styles. 1 0
? Number formatted. 1 0
? Use of Formulas and Functions appropriately. 1 0
Monthly Worksheets
? Consistent formatting using styles. 1 0
? Number formatted. 2 1 0
? Use of Formulas and Functions appropriately. 2 1 0
? Updated January Worksheet 1 0
? Updated February Worksheet 1 0
? Updated March Worksheet 1 0
? Updated April Worksheet 1 0
? Updated May Worksheet 1 0
? Updated June Worksheet 1 0
? Updated July Worksheet 1 0
? Updated August Worksheet 1 0
? Updated September Worksheet 1 0
? Updated October Worksheet 1 0
Revised BMS 12/29/19
? Updated November Worksheet 1 0
? Updated December Worksheet 1 0
Integrated Capstone Project Contains a Business Report with the following
enhancements and formats.
? Cover page 1 0
? A minimum of four content pages 1 0
? Use of Apple Valley Paper logo 1 0
? Apply a theme 1 0
? Use of Business Professional images 1 0
? Use of Charts from AVP Year-End Workbook 1 0
? Table applied 1 0
? Table Style applied and enhancements 1 0
? Tabbed list created 1 0
? SmartArt applied 1 0
? Style applied and enhancements 1 0
About Page
? Contains information from Apple Valley Website 1 0
? Use of styles 1 0
? Formatting enhancements 1 0
People
? Contains all members of the Apple Valle Paper 1 0
? Contains Images of each member 1 0
? Contains Name and Job Title of each member 1 0
? Use of styles 1 0
? Formatting enhancements 1 0
Financial
? Contains financial information from Excel Workbook 1 0
? Use of styles 1 0
? Formatting enhancements 1 0
Products
? Contains information from Apple Valley Website 1 0
? Contains images of products from Apple Valley Website 1 0
? Use of styles 1 0
? Formatting enhancements 1 0
Integrated Capstone Project Contains a Business Presentation with the following
enhancements and formats.
? Applied a theme 1 0
? Use of Styles on each slide. 1 0
? SmartArt applied 1 0
? Style applied and enhancements 1 0
? Use of Business Professional images 1 0
? Use of Charts from AVP Year-End Workbook 1 0
? Format Enhancements to charts. 1 0
? Use of video provided 1 0
? Format enhancements to video 1 0
Revised BMS 12/29/19
? Use of icons 1 0
Title Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Agenda Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
About Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
People Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Financial Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Products Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Thank You Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Integrated Capstone Project Contains Email to Mr. Carlyle with the following
enhancements and formats.
? Contains salutation 1 0
? Contains body with content 1 0
? Contains complementary closing 1 0
? Contains signature 1 0
? Includes attachments, Business Reports, Workbooks, and Presentation 1 0
? Email sent to your instructor 1 0
Integrated Capstone Project includes the following enhancements and formats.
? Appropriate pictures selected by the student (NO CLIPART) 1 0
? Consistent formatting and enhancements applied. 1 0
? Contains proper spelling, grammar, and punctuation. 1 0
Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Home
Homework Answers
Blog
Archive
Tags
Reviews
Contact
twitterfacebook
Copyright © 2021 SweetStudy.comSWEETSTUDY.COM YOUR HOMEWORK ANSWERS
chat0
Home.Literature.
Help.
Log in / Sign up
MS Office Suite, Introduction 20755 Integrated Capstone Project
profile
Kathry02
IntegratedCapstoneProject.pdf
Home>Applied Sciences homework help>MS Office Suite, Introduction 20755 Integrated Capstone Project
Revised BMS 12/29/19
INTEGRATED CAPSTONE PROJECT Mr. Carlyle would like you to complete the report, workbook and presentation for his
upcoming yearly meeting. Review your Capstone Projects from each software to review
your key concepts. The goal is to have a business professional report, workbook and
presentation. You are to integrate your skills using Microsoft Word, Excel, PowerPoint and
Outlook.
WORKBOOK
The Apple Valley Paper Year-End workbook needs to be completed. Apply a theme, use
styles, number formats, and complete the workbook with consistent formatting and use of
formulas and functions. Use a minimum 12-point font. At a minimum include the following:
Complete the Safety Worksheet by calculating our total safety incidents.
Create a chart using the Safety Worksheet.
Update all monthly worksheets with consistent formatting and formulas.
Complete the Year-End Net Income worksheet by calculating the total Net Income for
the year. (The Year-End Net Income worksheet is a Summary Worksheet.)
Apply conditional formatting on the Year-End Net Income worksheet to indicate the
top three divisions Net Income.
Create a chart on the Year-End Net Income worksheet using the Percent of Total.
On the Employees Worksheet, use a function to determine what bonus amount each
employee will receive. If they have been employed five years or more, they will
receive a $500 bonus and if they were employed less than 5 years, they will receive a
$100 bonus.
Apply consistent formatting to all worksheets.
Safety and Year-End Net Income worksheets: Change orientation to Landscape and
Scale to Fit one page width and height.
Employees worksheet: Change orientation to Landscape and Scale to Fit one page
width.
Arrange monthly worksheets in order.
BUSINESS REPORT
Based on the data created in your workbook, Mr. Carlyle would like you to create a Business
Report using Word. Start a new document, apply a consistent theme and formatting to
match your workbook. Use the Apple Valley Paper website to complete the report along
with your Year-End workbook. At a minimum include the following:
Apply a theme and styles of your choice.
Your report needs to be a minimum of four pages of content and a cover page.
o About: Include general information about Apple Valley Paper from their
website.
Revised BMS 12/29/19
o People: Include all members of Apple Valley Paper from their website.
o Financial: Include year-end information from your Excel Workbook.
o Products: Include information about Apple Valley Paper Products from their
website.
Use the Apple Valley Paper logo provided in AVP Information button in Blackboard.
Business Professional Images, some are provided in AVP Information button in
Blackboard. You need to determine where and how many images should be included.
Include additional professional images as you need.
Include Charts from the AVP Year-End Excel Workbook.
Must include a table, tabbed list and a SmartArt of your choice with appropriate
formatting and enhancements.
Feel free to use information from your other capstone projects to add content.
Review your document to ensure your information fully fills the pages. (Minimal
white/blank space) Insert other pictures, shapes, or icons if necessary.
BUSINESS PRESENTATION
Mr. Carlyle would like to take the contents of the Business Report and Year-End workbook
and use it at an upcoming investor meeting for future expansion. Create a minimum of 8
slides. At a minimum include the following:
Apply a theme and styles of your choice.
Create a minimum of 8 slides but include the following:
o Title Slide
o Agenda Slide
o About Slide
o People Slide
o Financial Slide
o Products Slide
o Thank You Slide
Include charts, SmartArt, Business Professional Images, video, and Icons of your choice.
Minimum of 60-point font size on titles and 24-point font size on text.
EMAIL TO MR. CARLYLE
Mr. Carlyle would like your project to be emailed to him for review. (Your email will be sent to
your instructor at [email protected].)
At a minimum include the following:
Professionally formatted email includes salutation, body and complimentary closing.
Include signature
Include the Business Report, Workbook, and Presentation as attachments.
mailto:[email protected]
Revised BMS 12/29/19
INTEGRATED CAPSTONE GRADING RUBRIC
Rating Value Rating Description
2 Proficient: Performs effectively, efficiently, and independently.
1 Competent: Performs adequately, meets basic standards.
0 Work does not meet standards
SCORING GUIDE CRITERIA RATINGS
Integrated Capstone Project Contains a completed workbook with the following
enhancements and formats.
? Theme applied. 1 0
Safety Worksheet
? Consistent formatting using styles. 1 0
? Number formatted. 1 0
? Use of Formulas and Functions appropriately. 1 0
? Created Chart 1 0
? Formatted Chart 1 0
? Applied Enhancements 1 0
Year-End Net Income Worksheet
? Consistent formatting using styles. 1 0
? Number formatted. 1 0
? Use of Formulas and Functions appropriately. 1 0
? Applied Conditional Formatting 1 0
? Created Chart 1 0
? Formatted Chart 1 0
? Applied Enhancements 1 0
Employees Worksheet
? Consistent formatting using styles. 1 0
? Number formatted. 1 0
? Use of Formulas and Functions appropriately. 1 0
Monthly Worksheets
? Consistent formatting using styles. 1 0
? Number formatted. 2 1 0
? Use of Formulas and Functions appropriately. 2 1 0
? Updated January Worksheet 1 0
? Updated February Worksheet 1 0
? Updated March Worksheet 1 0
? Updated April Worksheet 1 0
? Updated May Worksheet 1 0
? Updated June Worksheet 1 0
? Updated July Worksheet 1 0
? Updated August Worksheet 1 0
? Updated September Worksheet 1 0
? Updated October Worksheet 1 0
Revised BMS 12/29/19
? Updated November Worksheet 1 0
? Updated December Worksheet 1 0
Integrated Capstone Project Contains a Business Report with the following
enhancements and formats.
? Cover page 1 0
? A minimum of four content pages 1 0
? Use of Apple Valley Paper logo 1 0
? Apply a theme 1 0
? Use of Business Professional images 1 0
? Use of Charts from AVP Year-End Workbook 1 0
? Table applied 1 0
? Table Style applied and enhancements 1 0
? Tabbed list created 1 0
? SmartArt applied 1 0
? Style applied and enhancements 1 0
About Page
? Contains information from Apple Valley Website 1 0
? Use of styles 1 0
? Formatting enhancements 1 0
People
? Contains all members of the Apple Valle Paper 1 0
? Contains Images of each member 1 0
? Contains Name and Job Title of each member 1 0
? Use of styles 1 0
? Formatting enhancements 1 0
Financial
? Contains financial information from Excel Workbook 1 0
? Use of styles 1 0
? Formatting enhancements 1 0
Products
? Contains information from Apple Valley Website 1 0
? Contains images of products from Apple Valley Website 1 0
? Use of styles 1 0
? Formatting enhancements 1 0
Integrated Capstone Project Contains a Business Presentation with the following
enhancements and formats.
? Applied a theme 1 0
? Use of Styles on each slide. 1 0
? SmartArt applied 1 0
? Style applied and enhancements 1 0
? Use of Business Professional images 1 0
? Use of Charts from AVP Year-End Workbook 1 0
? Format Enhancements to charts. 1 0
? Use of video provided 1 0
? Format enhancements to video 1 0
Revised BMS 12/29/19
? Use of icons 1 0
Title Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Agenda Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
About Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
People Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Financial Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Products Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Thank You Slide
? Contains content 1 0
? Contains enhancements 1 0
? Minimum of 60-point font size on titles and 24-point font size on text 1 0
Integrated Capstone Project Contains Email to Mr. Carlyle with the following
enhancements and formats.
? Contains salutation 1 0
? Contains body with content 1 0
? Contains complementary closing 1 0
? Contains signature 1 0
? Includes attachments, Business Reports, Workbooks, and Presentation 1 0
? Email sent to your instructor 1 0
Integrated Capstone Project includes the following enhancements and formats.
? Appropriate pictures selected by the student (NO CLIPART) 1 0
? Consistent formatting and enhancements applied. 1 0
? Contains proper spelling, grammar, and punctuation. 1 0
Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Home
Homework Answers
Blog
Archive
Tags
Reviews
Contact
twitterfacebook
Copyright © 2021 SweetStudy.com
Recent Comments