excel project

profilerepunzel
AnimalRescueGradeSheet.xlsx
Home>Computer Science homework help>excel project

Grade Sheet

Animal Rescue Project Grade Sheet
Requirements: Final Project Mini Case Project Student Student Student Student Student Student Student Student Student Student Student
Cat Data Range: 4 4
Name
Age
Breed
Gender
Color
Spayed/Neutered
Declawed
Shelter/Rescue
PetID
Cat Data Range Formatting:
Borders 1 1
Centering 2 2
Freeze panes 2 2
Merged cells 1 1
Theme applied 1 1
Named range 2 2
Dog Data Range: 4 4
Name
Breed
Age
Gender
Size
Shelter/Rescue
PetID
Dog Data Range formatting:
Borders 1 1
Centering 2 2
Freeze panes 2 2
Merged cells 1 1
Theme applied 1 1
Named range 2 2
Data Sort by shelter then breed (dogs) 2
Data Sort by shelter then breed (cats) 2
Subtotals in data range to show dogs by breed then shelter 4 4
Subtotals in data range to show cats by breed then shelter 4 4
Filtered data range to show:
Domestic shorthair cats 2
Black cats with Another Chance for Animals 2
Dogs available through PAAWS 2
Small male dogs 2
Create VLOOKUP Table and include for cats:
Use pet ID for lookup value 1
Name 1
Breed 1
Age 1
Gender 1
Shelter information 1
Create VLOOKUP Table and include for dogs:
Use pet ID for lookup value 1
Name 1
Breed 1
Age 1
Gender 1
Shelter information 1
Hyperlinks for each rescue/shelter 4
Hyperlink to your email address 1
Grouped worksheets 1
3D reference to a cell in another worksheet (dogs) 2
3D reference to a cell in another worksheet (cats) 2
Conditional formatting:
Young dogs 2
Cats available through Another Chance for Animals 2
Key for dogs rule 1
Key for cats rule 1
AND Function (cats) 2
AND Function (dogs) 2
Today Function 1
IF Statement (cats) 2
IF Statement (dogs) 2
Absolute cell reference (cats) 2
Absolute cell reference (dogs) 2
Graphic Object (cats) 1
Graphic Object (dogs) 1
Charts: Must be one of pie chart, clustered column or bar
Breakdown of dogs by shelter: 1
Grid lines 1
Data Labels 1
Formatting 1
Chart Title 1
Axis Titles 1
Legend 1
Breakdown of cats by shelter: 1
Grid lines 1
Data Labels 1
Formatting 1
Chart Title 1
Axis Titles 1
Legend 1
Breakdown of cats by gender: 1
Grid lines 1
Data Labels 1
Formatting 1
Chart Title 1
Axis Titles 1
Legend 1
Create PivotTable and Pivot Charts for:
Number of dogs by breed then age 1
Grid lines 1
Data Labels 1
Formatting (no filter buttons) 1
Chart Title 1
Axis Titles 1
Legend 1
Number of cats by breed then color 1
Grid lines 1
Data Labels 1
Formatting (no filter buttons) 1
Chart Title 1
Axis Titles 1
Legend 1
Create Excel Table for dogs and show:
Banded rows 1 1
Defined Table name 2 2
Total rows to calculate:
Total number of dogs 2 2
Create Excel Table for cats and show:
Banded rows 1 1
Table name 2 2
Total rows to calculate:
Total number of cats 2 2
Slicers: from each of the tables to show:
Male Pitbull/Staffordshire Terrier with It Takes A Village 4
Adult beagle/beagle mix dogs 4
Grey female cats 3
Domestic longhair cats with PAAWS 3
Formatted cat slicers 2
Formatted dog slicers 2
Dashboard page for dogs 2
Dashboard page for cats 2
Page header (dogs) with your name, date and worksheet name 3 3
Page header (cats) with your name, date and worksheet name 3 3
Page footer (dogs) with page number 1 1
Page footer (cats) with page number 1 1
Print titles for cats 2
Print titles for dogs 2
PMT Function:
$350,000 9% for 15 year note 3
$350,000 7% for 30 year note 3
$200,000 9% for 15 year note 3
$200,000 7% for 30 year note 3
Total: 180
Bonus Questions:
Which animal would you choose 1
And why? 2
Favorite Disney or Marvel Trivia question/statement from lectures 2
Color Codes:
Data Range
Doesn't matter
Charts
Pivot Charts
Excel Table
Doesn't matter
52

&P