The following assessments and rubrics are valuable to assess knowledge in an introductory Microsoft Office course (Word, Excel, PowerPoint, and Access).
Created by Laura Schoenike, Menomonee Falls High School
This assignment is designed for a personal finance class. Students will be split up into groups and are to plan weddings for their assigned couple. There are four different customers that will need to be assigned. Students are to create a professional presentation using a spreadsheet application outlining their plans for their assigned customers. The purpose of the assignment is to visually see the different costs that are involved while planning for a wedding.
Suggested columns: Item description, photo of item, cost involved, and a running balance to visually show the grand total.
Create a basic spreadsheet adding in formulas to calculate shopping expenses. Given a set budget, students must "shop" for items, with some restrictions. Bonus points are given for spending down to less than five cents.