Final Assessment Outline
Competency Name: Intermediate Business Computing
Final Assessment Outline
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
Program Learning Outcomes: PLOs Assessed in this course include:
PLO #4 Our graduates will be able to utilize emerging technologies in order to improve business performance.
Competency Learning Outcomes (CLOs)
CLO #1: Create/edit a document that uses WordArt, page numbering, columns, page borders, graphics, breaks, and basic editing functions.
CLO#2: Create and edit basic financial spreadsheet by formatting data, cells, charts, etc.
CLO#3: Create presentations with different views, animations, and other visual effects.Create a APA 7th edition bibliography (no cover page etc. required. Bibliography only).
Must have at least 3 sources.
3 sources must be formatted with the hanging indent.
Must have a page border with 3 point width.
Insert a header with page number.
Insert a footer with your last name.
Save your bibliography as your last name_final bibliography.
Item needs to be submitted as a word document.
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 all three of the Microsoft Office 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 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.
You will need to download Microsoft Office 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.
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 directions for each portion of the project are followed (Bibliography, Excel, PowerPoint and Word)
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 Integrity and Plagiarism will be strictly enforced.
Make sure you cite your sources.
All submissions are visually appealing and a common theme (colors etc. are similar across submissions)
All submissions must be checked for accuracy, spelling and grammar.
Microsoft Excel Minimum Requirements:
Create an Excel workbook on your subject matter.
Use a worksheet with a minimum of ten columns and ten rows.
Use a minimum of ten column titles, Arial 10 pt, Bold, Fill color of your choice.
Use a minimum of ten row titles. Arial 10pt.
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.
You must include a picture on your first tab relevant to your topic.
Create 2 Graphs (Bar/Column, Pie Chart, or Combo) with the data. After created – move those to a new tab.
Make sure your submission is visually appealing and has a similar theme (colors etc. as your other submissions)
Save your Excel workbook as your last name_final Excel.
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:
Must be a minimum of 10 slides.
The first slide is the Title slide (Include your name(s), class and time, and date.
The Text slides must follow 7×7 Rule (Interesting Bullets & Indentations).
Make sure you have ClipArt Images or Photos on some slides.
Create Transition to new slides.
Include at least one slide with a SmartArt in it.
Include at least one slide with WordArt in it.
Include at least one slide with a Shape in it.
Include at least one Animation (More if you like).
Include Audio (Could be Music) on the First and Last Slide. Audio symbol must be hidden via “playback” / ”hide during show”.
Include a Video on one of the slides. Have the Video autoplay once the slide is shown.
Make sure to include the CHARTS created in your Excel here.
In the Notes section of each slide let me know what you did to that slide.
Make sure your presentation is accessible to all users.
Make sure your submission is visually appealing and has a similar theme (colors etc. as your other submissions)
Insert Footer on Print on the Handout Page (Not on the slides): Include your name
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:
Create a brochure on your subject matter using a template
Three columns per side, two-sided brochure.
One column must have your name, topic, class information. These must all be done using text effects.
Create a bulleted list, or numbered list, of a minimum of 5 items in the list.
Each side of your brochure must have at least two pictures.
Include a hyperlink in your Brochure relevant to your topic.
Make sure your brochure is accessible to all users.
Make sure your submission is visually appealing and has a similar theme (colors etc. as your other submissions).
Save your brochure as your last name_final Word Brochure
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:
Submitting the Project
Make sure all your work has been completed.
Attach your files.
Be sure all 4 files are attached before clicking submit.
Drafts are recommended, but not required within the appropriate deadlines.
Do not submit a PDF. Must be submitted as Word/Excel/PowerPoint files. If any item is submitted as a PDF you will received a not-proficient grade on that portion and will not receive a passing grade.
Remember, your overall grade for this class is solely based upon this final assessment.
Submit your Work
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
General Criteria
4: ExceedsProficiency
3: Proficient
2: Developing
1: Emerging
Achievement Levels
Exceeding
Achieving
Approaching
Emerging
Mechanics
No spelling errors. No grammar errors. Text is in authors’ own words.
Few spelling errors. Few grammar errors. Text is in authors’ own words.
Somespelling errors. Somegrammar errors. Most of text is in authors’ own words.
Many spelling and or grammar errors. Text is copied.
Theme/Visual Appeal
All document canbe connected to the same theme and are visually appealing. Documents also have color schemes.
All document canbe connected to the same theme and are visually apealing.
One document is not connected to the same theme
Noneof the Documents are connected to each other by theme.
Excel Criteria
4: ExceedsProficiency
3: Proficient
2: Developing
1: Emerging
Achievement Levels
Exceeding
Achieving
Approaching
Emerging
Excel Criteria
4: ExceedsProficiency
3: Proficient
2: Developing
1: Emerging
Requirements
All requirements met and included elements that were notrequired that enhanced the Excel workbook.
All requirements met.
Missing 1-2 requirements.
Missing3 or more requirements.
Formulasand Functions
Cell formulas or Functions were used wherever appropriate. There were no numbers typed in to do any calculations
Addition cell formulas and functions used.
Most of thenumbers that needed to be calculated were done by formulas or functions.
Functions used: MIN/MAX/Average
Some of thenumbers that needed to be calculated were done by formulas functions.
None of the numbers that needed to be calculated were done by formulasor functions.
Graphs
The graph required for the project is correct. All labels on axes and the key for the graph is labeledappropriately and in thecorrect location.
The graph required is not the correct size, correct shape, or located in the correct place. OR The labels for the axes are incorrect. OR The key for the graph is incorrect.
There is a graphpresent but more than one item is incorrect on it.
There is no graph.
Excel Criteria
4: ExceedsProficiency
3: Proficient
2: Developing
1: Emerging
Formatting
The workbook has all the headings, column labels, number labels, and is formatted correctly.
Content is accessible to all users
The worksheet is missing one or two of the requirements
The worksheet is missing someof the formatting requirements.
The worksheet is missing all of the formatting requirements.
Powerpoint
4: ExceedsProficiency
3: Proficient
2: Developing
1: Emerging
Achievement Levels
Exceeding
Achieving
Approaching
Emerging
Requirements
All requirements met and included elements that were not required.
All requirements met.
Missing 1-2 requirements.
Missing3 or more requirements.
Powerpoint
4: ExceedsProficiency
3: Proficient
2: Developing
1: Emerging
Presentation Layout
/ Accessibility
Creates own slide layout, using text boxes and insertion of images through menus.Color contrast is excellent and utilizing complementary colors andis in consideration of the needs of screen reading.
Content is accessible to all users
Uses the varying preset slide layout for each slide. Color contrast is good and in consideration of the needs of screen reading.
1-2 Accessibility errors
Usesthe same preset slide layout for each slide. Color contrast is consistent.
3-4 Accessibility errors
No organization on any slide.
5 or moreAccessibility errors
Presentation of Content
Content is accurate and went beyond required information. Used advanced tools that add to the overall presentation.
Content is accurate all required information presented in a logical order. Is still generally easy to follow.
Content is accurate but some required information is missing and/or not presented in a logical order, making it difficult to follow.
Content is inaccurate. Information is not presented in a logical order, making it difficult to follow.
Slide design
Utilizes the presetsof slide design. Creates own color sets to change the colors of the original slide. Changes fonts to suitnew color sets.
Utilizes the presetsof slide design. Uses preset color sets to change the colors of the original slide. Changes fonts to suitnew color sets.
Utilizes the presets of slide design. Uses original slide design colors and fontsets.
No slide design used.
Word Criteria
4: ExceedsProficiency
3: Proficient
2: Developing
1: Emerging
Achievement Levels
Exceeding
Achieving
Approaching
Emerging
Requirements
All requirements met and included elements that were not required.
All the requirements were met.
Some of the requirements were met. (Missing 1-2)
Most of the requirements were missing. (3or more)
MS Word
The project contains excellent formatting, page layout, and all words are clear with formatting that is clear and very easy to read, with an overall aesthetically pleasing and attractive look.
Content is accessible to all users
One of the following could be improved upon formatting, page layout, readability, or aesthetics
Two of thefollowing could be improved upon formatting, page layout, readability, or aesthetics
The project is not formatted; the page layout is incomplete, the contents are difficult to read, and not visually appealing.
Word Criteria
4: ExceedsProficiency
3: Proficient
2: Developing
1: Emerging
Brochure
Used a template to create the brochure. Utilizes the presets of the template. The layout is easily followed. Creates own color sets to change the colors of the original template. Changes fonts to suit newcolor set
Content is accessible to all users
Uses a template. The layout is can be followed. Color contrast is good.
Usesatemplate. There is no layoutfor the information and it is not easily followed. Color contrast is not considered
No template used. No layout. Can not follow the information.
Bibliography
4: ExceedsProficiency
3: Proficient
2: Developing
1: Emerging
Requirements
All requirements met and included elements that were not required.
All Requirements met.
Missing 1-2 Requirements.
Missing 3-4 Requirements.