Intermediate Business Computing assignment

Competency Name: Intermediate Business Computing

Competency Statement: This course provides an in-depth exploration of the advanced features of the Microsoft Office suite. Topics covered will be Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

Final Assessment Title: Intermediate Business Computing Final Assessment

• PLO #4 Our graduates will be able to utilize emerging technologies in order to improve business performance.

1. CLO #1: Create/edit a document that uses WordArt, page numbering, columns, page borders, graphics, breaks, and basic editing functions.

2. CLO#2: Create and edit basic financial spreadsheet by formatting data, cells, charts, etc.

3. CLO#3: Create presentations with different views, animations, and other visual effects.

Final Project Instructions/Project Overview

The final project is designed for you to apply the software application skills you acquired while working through the content. For this project, you will use three of the Microsoft 365 applications (Word, Excel, and PowerPoint) covered in the content and the internet to create a unified project on a single topic. Please use your previous milestone submissions as a starting point for your final project. Drafts are recommended, but not required. If you need assistance with “how to do something in one of the Microsoft applications” return to the previous reference materials for a review.

There will be four items to submit when you have finished your project.

1. Excel Workbook

2. PowerPoint Presentation

3. MS Word Brochure

4. MS Word Bibliography

Software Requirements

You must use the following software applications to create the final project:

• Microsoft Word 2016 or newer

• Microsoft Excel 2016 or newer

• Microsoft PowerPoint 2016 or newer

• No other versions of Office may be used.

You will need to download Microsoft 365 from the website. It is free and there are multiple ways to download. Reach out if you have any questions. Please DO NOT use the online version of Microsoft Office – it does not have all the necessary tools to complete what is required.

Note: If you are unable to download Microsoft Office on your device, please inform your instructor or contact IT for assistance.

Project Topic

You may select any topic that is of interest to you. Remember that your project will cover ONE topic and your topic needs to have enough information/data etc. for a Word bibliography, Word brochure, Excel workbook and PowerPoint presentation. You may choose one of the examples or contact me for permission to do something different.

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

1. The directions for each portion of the project are followed (Bibliography, Excel, PowerPoint and Word)

2. Creativity is demonstrated by applying the software skills acquired during the term. Creativity is measured in various ways, including:

   1. applying additional skills covered in the course but not listed as a minimum requirement,

   2. adding additional graphics or pictures,

   3. applying varying color schemes,

   4. creative formatting of the Excel chart,

   5. using various design backgrounds with presentation slides,

   6. creating your own slide background instead of using a design template,

   7. adding a border to the Microsoft Word document component,

   8. graphically editing pictures and other graphics,

   9. adding external sounds or movie clips in the PowerPoint component etc.

3. This project must be an original creation, not a copy and paste. All rules concerning Academic Integrity and Plagiarism will be strictly enforced.

4. Make sure you cite your sources.

5. All submissions are visually appealing and a common theme (colors etc. are similar across submissions)

6. All submissions must be checked for accuracy, spelling and grammar.

Microsoft Excel Minimum Requirements:

1. Create an Excel workbook on your subject matter.

2. Use a worksheet with a minimum of ten columns and ten rows.

3. Use a minimum of ten column titles, Arial 10 pt, Bold, Fill color of your choice.

4. Use a minimum of ten row titles. Arial 10pt.

5. Use the min, max, and average functions.

6. Create formulas in at least four cells (formulas are DIFFERENT from the functions in the step above) (+, -, x, ÷).

7. Create a title for the worksheet merging and centering the text of a minimum of six cells.

8. Format title with Arial, 14 pt, bold, italics, the font color of your choice.

9. Apply borders to merged cells.

10. Rename the Sheet Tab.

11. You must include a picture on your first tab relevant to your topic.

12. Create 2 Graphs (Bar/Column, Pie Chart, or Combo) with the data. After created – move those to a new tab.

13. Make sure your submission is visually appealing and has a similar theme (colors etc. as your other submissions)

14. Save your Excel workbook as your last name_final Excel.

15. Item needs to be submitted as an excel workbook

Examples to receive more than a 3. Use of Pivot Tables, Pivot Chart, Slicer, Formulas, or Functions that pull data from multiple sheets, etc.

Microsoft PowerPoint Minimum Requirements:

1. Must be a minimum of 10 slides.

2. The first slide is the Title slide (Include your name(s), class and time, and date.

3. The Text slides must follow 7x7 Rule (Interesting Bullets & Indentations).

4. Make sure you have ClipArt Images or Photos on some slides.

5. Create Transition to new slides.

6. Include at least one slide with a SmartArt in it.

7. Include at least one slide with WordArt in it.

8. Include at least one slide with a Shape in it.

9. Include at least one Animation (More if you like).

10. Include Audio (Could be Music) on the First and Last Slide. Audio symbol must be hidden via “playback” / ”hide during show”.

11. Include a Video on one of the slides. Have the Video autoplay once the slide is shown.

12. Make sure to include the CHARTS created in your Excel here.

13. In the Notes section of each slide let me know what you did to that slide.

14. Make sure your presentation is accessible to all users.

15. Make sure your submission is visually appealing and has a similar theme (colors etc. as your other submissions)

16. Insert Footer on Print on the Handout Page (Not on the slides): Include your name

17. Save your PowerPoint as your last name__final PowerPoint

One example of how to receive more than a 3 on your PowerPoint create a voice-over for your slide show as if you were giving a briefing.

Microsoft Word Minimum Requirements:

1. Create a brochure on your subject matter using a template

2. Three columns per side, two-sided brochure.

3. One column must have your name, topic, class information. These must all be done using text effects.

4. Create a bulleted list, or numbered list, of a minimum of 5 items in the list.

5. Each side of your brochure must have at least two pictures.

6. Include a hyperlink in your Brochure relevant to your topic.

7. Make sure your brochure is accessible to all users.

8. Make sure your submission is visually appealing and has a similar theme (colors etc. as your other submissions).

9. Save your brochure as your last name_final Word Brochure

10. Item needs to be submitted as a word document.

Examples of how to receive more than a 3 on your Brochure is to do edits to your pictures, add in SmartArt etc.

Bibliography Minimum Requirements:

1. 1. Create a APA 7th edition bibliography (no cover page etc. required. Bibliography only).

   2. Must have at least 3 sources.

   3. 3 sources must be formatted with the hanging indent.

   4. Must have a page border with 3 point width.

   5. Insert a header with page number.

   6. Insert a footer with your last name.

   7. Save your bibliography as your last name_final bibliography.

   8. Item needs to be submitted as a word document.

Submitting the Project

 Make sure all your work has been completed.

1. Attach your files.

2. Be sure all 4 files are attached before clicking submit.

3. Drafts are recommended, but not required within the appropriate deadlines.

4. Do not submit a PDF. Must be submitted as Word/Excel/PowerPoint files. If any item is submitted as a PDF you will receive a not-proficient grade on that portion and will not receive a passing grade.

5. Remember, your overall grade for this class is solely based upon this final assessment.

• Your completed final assessment documents should be submitted through the Final Assessment link of your competency.

• Please note, that you can upload multiple files to the Final Assignment link.

• Make sure the files are converted to a doc, docx, ppt, pptx, xls. xlsx file. No other file types will be accepted. (You can share MS OneDrive documents from the “Choose Existing Activities” button)

• To upload a file, click “Upload File” and choose the file(s) from your desktop:

More tutorial resources can be found at the UMPI Student eLearning Hub

Final Assessment Rubric

Course: Intermediate Business Computing