Fundamental informatic
Gwadys
Purpose.docxPurpose
This assignment is one of four that appear in this course to check your skills in word processing, spreadsheets, presentation software, and file management. These four assignments together represent 20% of your overall course grade.
Students can use any spreadsheet software they have available. The most common software used is Microsoft Excel and the assignment makes reference to this software. Students are not precluded from using Google Sheets. Just be sure to save the file format as an .xls or.xlsx file.
Download the instructions for the exercise:
Basic Monthly Budget for a Veterinary Office Download Basic Monthly Budget for a Veterinary Office
Download this spreadsheet as your template and save it to your drive:
Spreadsheet Budget Data Download Spreadsheet Budget Data
Use this file to help you if you are unfamiliar with the tasks required in this assignment: Chapter 16: Microsoft Excel Techniques Chapter
As a reminder, you can also use the built-in Help function within the presentation software or use a Google search to learn a particular skill.
This activity will have you demonstrate these proficiencies
· Create a Blank Workbook
· Save a Workbook
· Modify an Excel Spreadsheet
· Enter Text Values in Excel Cells
· Merge and Center Text
· Apply Styles
· Create Basic Formulas
· Format an Excel Spreadsheet
· Merge and Center Cells
· Use Basic Functions--AutoSum – Max – Min – Average
· Use Fill Handle
· Copy and Move Cell Entries
· Apply Styles
· Insert a Pie Chart
See the grading rubric below for point details.
If you have trouble understanding what needs to be done, contact your instructor and ask for help.
Submitting your Assignment
1. Click the Submit Assignment button.
2. Click the Choose File button and upload your file.
3. Click the Submit Assignment button to submit.
Rubric
INFM 109 - Spreadsheet Assignment Rubric
|
INFM 109 - Spreadsheet Assignment Rubric |
||||
|
Criteria |
Ratings |
Pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #2 Activate Cells |
|
5 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #3 Font change |
|
5 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #4 Formatting |
|
5 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #5-7 Formatting and Fill |
|
5 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #8-11 Text entry and formatting |
|
5 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #12 Merge & Center |
|
7 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #13 Fill Color, etc. |
|
5 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #14-16 Fill, wrap text |
|
5 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #17-18 Copy ranges |
|
5 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #19 AutoSum |
|
7 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #20-22 Copy range, cell formatting, borders |
|
7 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #23-25 Name sheet, orientation, print fit |
|
5 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #26-27 Header/Footer |
|
12 pts |
||
|
This criterion is linked to a Learning OutcomeInstructions List #28 Pie Chart |
|
12 pts |
||
|
Total Points: 90 |
