Paper Grading Guide

Business Budget Grading Guide
BIS/221 Version 4 / 2

Business Budget Grading Guide

BIS/221 Version 4

Introduction to Computer Systems and Applications

University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries.

Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation.

Edited in accordance with University of Phoenix® editorial standards and practices.

Individual Assignment: Business Budget

Purpose of Assignment

Electronic spreadsheets are useful tools, especially when creating a business budget. Once a spreadsheet is set up correctly in Excel®, values can be modified at any time, and the electronic spreadsheet will automatically update itself. Students will create a spreadsheet of computer equipment for a small fictional business where they are the owner. They will include the cost of all hardware and software needed for their employees, and calculate a monthly budget for the equipment.

Resources Required

· Research Hardware and Software to satisfy operational requirements described above

· Microsoft Office 365, Office 2016: Introductory: Creating a Worksheet and a Chart, Module 1

· Microsoft Office 365, Office 2016: Introductory: Formulas, Function and Formatting, Module 2

Grading Guide

Content / Met / Partially Met / Not Met / Comments: /
Created Microsoft® Excel® workbook saved under the following format: Lastname_Course#_W3.xls.
Chose the hardware and software that will provide your employees with the ability to stay connected to internal company data, communicate and collaborate with coworkers, and process data and sales information using wording, processing, and spreadsheet software applications.
Created a business budget sheet using Microsoft® Excel®. In the budget sheet, did the following:
· List the make and model of desired hardware devices and their cost.
· List software operating systems and applications for each device and their costs.
· Sum up the cost for both hardware and software for each employee, and then calculate the average monthly costs to maintain these systems.
· Insert a graph or chart displaying total costs graphically.
· Label columns/rows with titles reflecting data they contain.
· Use no more than two sheets in one workbook to display required data.
· Format data to highlight important totals.
The Budget sheet was 1,400 words in length.
Note: this assignment only requires that you submit an Excel® Workbook file. There are no written or APA guideline requirements.
Save this document as Lastname_BusinessBudget_W3.xls
Total Available / Total Earned
10 / #/10