Draft Final Assignment
Final Project Instructions/Project Overview
The final project is designed for you to apply the software application skills you acquired during the term. For this project, you will use all three of the Microsoft Office applications (Word, Excel, and PowerPoint) covered in this term and the Internet to create a unified project on a single topic. The instructions below are not step-by-step instructions you have already learned how to carry out various functions in Word, Excel, PowerPoint, and Access. Instead, the information below details the requirements for the final project. If you need assistance with “how to do something in one of the Office applications” return to the previous reference materials for a review.
There will be four items to submit when you have finished your project.
Excel Workbook
PowerPoint Presentation
MS Word Brochure
MS Word Bibliography
Software Requirements
- You must use the following software applications to create the final project:
- Microsoft Word 2010 or newer
- Microsoft Excel 2010 or newer
- Microsoft PowerPoint 2010 or newer
No other versions of Office may be used.
Using the online version will cause you to not have every feature that I am asking for. You will need to download Microsoft Office from the website. If the online version is your only option please contact me as soon as possible.
Project Topic
You may select any topic that is of interest to you. You may choose one of the examples or contact me for permission to do something different. Remember that your project will cover ONE topic. You will use ALL the Office applications to create content related to your chosen topic.
- Some examples of project topics include:
- develop a business,
- highlight attending UMPI,
- your favorite sports team,
your favorite sport,
dream car,
moving out on your own,
researching your planned career,
planning a vacation,
planning a wedding,
- highlight your native country or culture,
- your passion in life, etc.
- Project Minimum Requirements
- The minimum requirements for each of the applications are detailed in the checklists below.
- Professionalism is assessed in the evaluation of proper use of the required skills (e.g. competent in tables), grammar, spelling, and overall appearance.
- Effort is assessed in whether or not the presentation exceeded the minimum requirements.
- Creativity is demonstrated by applying the software skills acquired during the term. Creativity is measured in various ways, including:
- applying additional skills covered in the course but not listed as a minimum requirement,
- adding additional graphics or pictures,
- applying varying color schemes,
- creative formatting of the Excel chart,
using various design backgrounds with presentation slides,
creating your own slide background instead of using a design template,
adding a border to the Microsoft Word document component,
- graphically editing pictures and other graphics,
- adding external sounds or movie clips in the PowerPoint component etc.
- This project must be an original creation, not a copy and paste. All rules concerning Academic Dishonesty and Plagiarism will be strictly enforced.
- Make sure you cite your sources on your PowerPoint and your Word Document.
Microsoft Excel Minimum Requirements
- Create an Excel sheet on your subject matter.
- Create 2 Graphs (Bar/Column, Pie Chart, or Combo)
- Use a worksheet with a minimum of six columns and six rows
- Use a minimum of 6 column titles, Arial 10 pt, Bold, Fill color of your choice
- Use a minimum of 6-row titles. Arial 10pt
- Create a Table
- Use the min, max, and average functions
- Create formulas in at least four cells (formulas are DIFFERENT from the functions in the step above) (+, -, x, ÷)
- Create a title for the worksheet merging and centering the text of a minimum of six cells
- Format title with Arial, 14 pt, bold, italics, the font color of your choice
- Apply borders to merged cells
Rename the Sheet Tab
Create a chart on a separate worksheet using the data on the main sheet; name the sheet tab Chart
You must include a picture
- Save your Excel workbook as your last name_final Excel (Example: Dobbs_final Excel)
- (Examples to receive more than a 3. Use of Pivot Tables, Pivot Chart, Slicer, Formulas, or Functions that pull data from multiple sheets, etc.)