Use the version of Excel that you downloaded and installed to your personal device. Do not attempt to complete the project with the Web-based version of Office. Both versions are often referred to as Microsoft Office 365, but your downloaded version is supplied by Barry and you will have installed it on your personal device. Once installed, that version does not require an Internet connection. See your How to Navigate MBA-617 video to be sure you have followed the directions to download and install the applications for free from Barry.
Do not submit this project even a minute late.
Submit once and only once. A second submission is only allowed with my (Dr. Cahill’s) permission and only under rare circumstances.
Upload the correct file. Uploading the wrong file or an inaccessible file is subject to the instructions in your How to Navigate MBA-617 video.
Use the Filtering and Modeling Data Download Filtering and Modeling Dataworkbook. Notice that the workbook has two worksheets: DataModel and Filter. Complete your DataModel first.
Save the file to your OneDrive as MyLastName-FilterModel with no extra spaces or characters. (Substitute your last name for MyLastName.)
1 of 3. Analyze the Charitable Activity of 6 Businesses
NoSQL databases
Follow your “Data Modeling” help videoLinks to an external site.
On the DataModel worksheet, develop a pivot table from the tables in your data model to support the decision you make regarding which of 6 businesses is most likely to donate money for a scholarship program.
2 of 3. Select a Student for a Scholarship
Follow your “Functions for Filtering Data” help videoLinks to an external site.
On the Filter worksheet, develop two formulas in addition to those demonstrated in the help video and then add one pivot table with four criteria to support a decision regarding which student should be awarded a new or renewed scholarship.
Part 2 Project Filtering and Modeling
Part 2 Project Filtering and Modeling
| Criteria |
Ratings |
Pts |
| This criterion is linked to a Learning OutcomeFile NameThis is the name under which you saved your file to OneDrive. |
| 1 to >0.0 ptsFull Marks
File name is MyLastName-FilterModel. Replace the “MyLastName” portion of the file name with your actual last names (like Cahill-FilterModel). Do not add extra characters or spaces. File name accuracy is imperative so that colleagues and classmates are able to locate your files in shared environments. |
0 ptsNo Marks |
|
1 pts |
| This criterion is linked to a Learning OutcomeDataModel Worksheet–Tables5 tables appear in a data model. |
| 2 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
2 pts |
| This criterion is linked to a Learning OutcomeDataModel Worksheet–Relationship DiagramDiagram view shows relationships between each of 4 tables related to a central table. No dotted (inactive) relationship lines. |
| 3 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
3 pts |
| This criterion is linked to a Learning OutcomeDataModel Worksheet–Pivot TableOne pivot table is created from the tables in the data model. Pivot table is used to inform the decision regarding which business to approach for a donation to the scholarship program. Information derived from the pivot table must clearly contribute to an informed decision. |
| 10 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
10 pts |
| This criterion is linked to a Learning OutcomeDataModel Worksheet–Sufficient InformationAt least two fields in addition to the business name field exist in the pivot table. |
| 6 ptsFull Marks |
0 ptsNo Marks |
|
6 pts |
| This criterion is linked to a Learning OutcomeDataModel Worksheet–Meaningful Pivot Table DataPivot Table does not contain ID’s or meaningless numbers if meaningful words or phrases exist. |
| 12 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
12 pts |
| This criterion is linked to a Learning OutcomeDataModel Worksheet–Business NameDecision regarding which business to approach for a donation is typed out in a cell below the pivot table. |
| 1 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
1 pts |
| This criterion is linked to a Learning OutcomeDataModel Worksheet–Selection ExplanationA one-sentence (or less) explanation of the information is typed after the name of the business selection. The explanation is clearly displayed and interpretable from the pivot table. |
| 3 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
3 pts |
| This criterion is linked to a Learning OutcomeDataModel–PositioningPosition of pivot table matches more or less what is shown in the help video. |
| 1 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
1 pts |
| This criterion is linked to a Learning OutcomeFilter Worksheet–PositioningPosition of headings, dropdown, formulas match more or less what is shown in the help video. |
| 1 to >0.0 ptsFull Marks
For example, the dropdown is approximately A14. |
0 ptsNo Marks |
|
1 pts |
| This criterion is linked to a Learning OutcomeFilter Worksheet–data validationDropdown list displays “Student LastName” values. |
| 10 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
10 pts |
| This criterion is linked to a Learning OutcomeFilter Worksheet–vLookup Function and FormulaThe vLookup function is used with a correct formula that returns the “Athletic Scholarship” data. Note: four formulas (total) must appear on the worksheet with at least one vLookup, but not more than 3 vLookups (plus one pivot table). |
| 10 ptsFull Marks |
0 ptsNo Marks |
|
10 pts |
| This criterion is linked to a Learning OutcomeFilter Worksheet–pivot tableOne pivot table with at least 4 criteria is created from the table on the Filter worksheet. Pivot table is used to inform or confirm the decision regarding which student should receive a new or renewed scholarship. Information derived from the pivot table must clearly contribute to an informed decision. |
| 10 ptsFull Marks |
0 ptsNo Marks |
|
10 pts |
| This criterion is linked to a Learning OutcomeFilter Worksheet–Filter Function and FormulaThe Filter function is used with a correct formula that returns the Socioeconomic Status. Note: four formulas (total) must appear on the worksheet with at least one Filter, but not more than 3 Filters (plus one pivot table) |
| 10 to >0.0 ptsFull Marks
The filter brings up the last names of students that match the socioeconomic level selected. |
0 ptsNo Marks |
|
10 pts |
| This criterion is linked to a Learning OutcomeFilter Worksheet–Two Additional FormulasTwo additional formulas in addition to the instructor’s examples are created, either as filters or vlookups or one of each. |
| 10 ptsFull Marks |
0 ptsNo Marks |
|
10 pts |
| This criterion is linked to a Learning OutcomeFilter Worksheet–Selection ExplanationA one-sentence (or less) explanation of the information is typed after the name of the student selection. The explanation is clearly displayed and interpretable from the results of formulas. |
| 4 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
4 pts |
| This criterion is linked to a Learning OutcomeFilter Worksheet–DesignWorksheet has proper headings and highlighting to maximize readability similar to the look of the worksheet in the help video. |
| 4 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
4 pts |
| This criterion is linked to a Learning OutcomeFile StorageFile resides in student’s Barry OneDrive cloud space with “Edit” permission for lcahill@barry.edu. |
| 1 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
1 pts |
| This criterion is linked to a Learning OutcomeProject SubmissionOnly the URL from the OneDrive upload is submitted. |
| 1 to >0.0 ptsFull Marks |
0 ptsNo Marks |
|
1 pts |
| Total Points: 100 |
