|
Milestone
|
Deliverables
|
Module Due
|
Grading
|
|
1
|
Database
Optimization Recommendations, Part I
|
Two
|
Graded separately; Milestone One Rubric
|
|
2
|
Database Optimization, Part II
|
Three
|
Graded separately; Milestone Two Rubric
|
|
3
|
Job Aid, Part I
|
Four
|
Graded separately; Milestone Three Rubric
|
|
4
|
Job Aid, Part II
|
Five
|
Graded separately; Milestone Four Rubric
|
|
5
|
Job Aid, Part III
|
Six
|
Graded separately; Milestone Five Rubric
|
|
|
Final Submission: Configuration and
Optimization
Recommendations and Job Aid
|
Seven
|
Graded separately; Final Project Part I and
II Rubric
|
|
Critical
Elements
|
Exemplary
(100%)
|
Proficient
(85%)
|
Needs
Improvement (55%)
|
Not
Evident (0%)
|
Value
|
|
Introduction: Business
Environment
|
Meets
“Proficient” criteria and provides exceptional detail regarding the
organization, industry information, and the current state of the business
environment
|
Discusses
the organization, the current state of the business environment, and
industryspecific information and gives examples that are relevant
|
Discusses
the organization, the current state of the business environment, and
industryspecific information that is relevant, but misses necessary or key
details, or discussion is not always relevant
|
Does not discuss the organization, the current state of the
business environment, and industry-specific
information
|
11.25
|
|
Introduction:
Assumptions
|
Meets
“Proficient” criteria, and assumptions and defense reflect keen insight into
the nuances of constructing recommendations for optimization and
configuration
|
Clearly
identifies and logically defends assumptions and conclusions made regarding
the business environment, scenario, and database environment with specific
supporting detail
|
Identifies
and defends assumptions and conclusions that were made regarding the business
environment, scenario, and database environment, but assumptions are not
always clear, or defense of assumptions is not logical or not supported with
detail
|
Does not identify and defend assumptions and conclusions
that were made regarding the business environment, scenario, and database
environment
|
11.25
|
|
Business
Requirements
and
Needs
|
Meets “Proficient” criteria, and
established business needs evidence reflects keen insight into the
organization and business environment in the
future
|
Establishes
appropriate business needs in relation to the defined business requirements
and with consideration of the business environment, with detailed explanation
|
Establishes
business needs, but they either lack relation to the defined business requirements,
consideration of the business environment, or detail
|
Does not establish business needs in relation to the
defined business requirements and consideration of the business environment
|
15
|
|
Existing
Database
|
Meets
“Proficient” criteria, and analysis is exceptionally detailed and supported
|
Analyzes
the existing database environment, providing specific areas of shortcomings
or areas in need of improvement regarding the business requirements, and
provides detailed explanations for support
|
Analyzes
the existing database environment, but identified areas are not specific to
the business requirements or explanations lack necessary detail
|
Does not analyze the existing database for areas of
shortcomings or areas in need of improvement
|
15
|
|
Configuration
|
Meets
“Proficient” criteria, and supporting resources and examples are of a
professional, scholarly, reputable nature
|
Recommends
methods for configuring the database environment that align with the defined
business requirements and needs, and supports with resources and examples
|
Recommends
methods for configuring the database environment, but recommendations do not
align with the defined business requirements and needs, or resources and
examples provided do not fully support the recommendations
|
Does not
recommend methods for configuring the database environment
|
15
|
|
Performance
|
Meets
“Proficient” criteria, and recommendations are particularly insightful
regarding ensuring performance quality over time, or supporting evidence is
particularly strong
|
Outlines
recommendations for ensuring the continued performance quality, and supports
with evidence
|
Outlines
recommendations, but recommendations would not lend to ensuring the continued
performance quality, or evidence provided does not constitute support
|
Does not outline recommendations for performance quality
|
11.25
|
|
Scalability
|
Meets
“Proficient” criteria, and recommendations are particularly insightful
regarding ensuring scalability over time, or supporting evidence is
particularly strong
|
Recommends
methods for ensuring scalability of the database in accordance with the
business needs, and supports with evidence
|
Recommends
methods, but methods would not lend to scalability, or evidence provided does
not constitute support
|
Does not recommend methods
for scalability
|
11.25
|
|
Articulation of Response
|
Submission
is free of errors related to citations, grammar, spelling, syntax, and
organization and is presented in a professional and easy-to-read format
|
Submission
has no major errors related to citations, grammar, spelling, syntax, or
organization
|
Submission
has major errors related to citations, grammar, spelling, syntax, or
organization that negatively impact readability and articulation of main
ideas
|
Submission has critical errors related to citations,
grammar,
spelling, syntax, or
organization that prevent understanding of ideas
|
10
|
|
|
|
|
Earned
Total
|
100%
|
|
|
Term
|
Context/Definition
|
|
Relevant
|
To the scenario, business context, industry/organizational
environment, and scope of this particular assignment (the recommendation for
optimization and configuration)
|
|
Exceptional detail
|
As is appropriate for the situation, relevant to the
scenario, and showing keen insight or exceptional knowledge of the nuances of
analyzing business environments for the purpose of optimization and
configuration recommendations
|
|
Keen insight into the nuances of
|
For context, it is necessary for student to make some assumptions
in order to successfully tackle this project, or any project in the real,
professional world. A key aspect is making assumptions that are relevant,
logical, and can help lead students to a successful solution. If
|
|
constructing recommendations for optimization and
configuration
|
students can identify the areas they made assumptions and
explain, logically, why it was appropriate to make such assumptions with
exceptional detail and accuracy, they probably have a deep understanding of
the nuances of making assumptions within the context of constructing
recommendations.
|
|
Keen insight into the organization and business environment
in the future
|
The student’s explanation will evidence keen insight if
they form educated and logical conclusions about the future needs of the
business that will allow them to better prepare and configure a database
environment. This is the idea that going above and beyond the business
requirements that currently exist may be a requirement for organizational
success.
|
|
Exceptionally detailed and supported
|
While
still completely relevant to the scenario and provided business context, the
identified areas of improvement are sufficiently detailed, and accurate in
that detail, to provide the baseline for a path to addressing the areas.
Further, exemplary analysis is supported with strong explanations that are in
line with scholarly, professional, and/or reputable established concepts and
practices.
|
|
Insightful
|
Showing a graduate-level conceptual understanding of the
needs and qualities of database environment that successfully maintain
quality performance in the long run
|
|
Particularly strong evidence
|
Professional, scholarly, and reputable within the industry
|
|
Critical
Elements
|
Proficient
(100%)
|
Needs
Improvement (55%)
|
Not
Evident (0%)
|
Value
|
|
Introduction:
Properties
|
Accurately communicates and visualizes the properties of
the database
|
Communicates and visualizes the properties of the database,
but with gaps in accuracy
|
Does not communicate and visualize the properties of the
database
|
6.25
|
|
Introduction: Peak Hours
|
Accurately communicates the peak hours, how they were
determined, why it matters, and what to do if peak hours change
|
Communicates
the peak hours, how they were determined, why it matters, and what to do if
peak hours change, but with gaps in accuracy or detail
|
Does not communicate the peak hours, how they were
determined, why it matters, and what to do if peak hours change
|
6.25
|
|
Introduction:
Backup
Software
|
Accurately identifies the software used for backup and
communicates the relevance and reasoning
|
Identifies the software used for backup and communicates
the relevance and reasoning, but with gaps in accuracy or detail
|
Does not identify the software used for backup and
communicate the relevance and reasoning
|
6.25
|
|
Administration,
Optimization,
and
Configuration:
Creating
Tables/Views/Stored
Procedures
|
Correctly
creates a new table, view, and stored procedure while accurately explaining
the steps, relevance, and existing standards
|
Creates a new table, view, and stored procedure while
explaining the steps, relevance, and existing standards, but tasks are
performed incorrectly or explanations are not accurate
|
Does not create a new table, view, and stored procedure
while explaining the steps, relevance, and existing standards
|
6.25
|
|
Administration,
Optimization,
and
Configuration:
Copying
|
Correctly
copies the database while accurately explaining the steps, relevance, and
when to perform
|
Incorrectly copies the database or inaccurately explains
the steps, relevance, and when to perform
|
Does not copy the database while explaining the steps,
relevance, and when to perform
|
6.25
|
|
Administration,
Optimization,
and Configuration:
Attaching/Detaching
|
Correctly attaches and detaches a database while accurately
explaining the steps, relevance, and when to perform
|
Unsuccessfully attaches or detaches a database or
inaccurately explains the steps, relevance, and when to perform
|
Does not attach or detach a database correctly while
explaining the steps, relevance, and when to perform
|
6.25
|
|
Administration,
Optimization,
and
Configuration:
Importing
Data
|
Correctly imports data from external sources while
accurately explaining the steps, relevance, and when to perform
|
Imports data incorrectly from external sources or
inaccurately explains the steps, relevance, and when to perform
|
Does not import data from external sources while explaining
the steps, relevance, and when to perform
|
6.25
|
|
Administration,
Optimization,
and
Configuration:
Baseline
|
Uses the SQL Profiler to correctly baseline the database
while accurately explaining the steps, relevance, and when to perform
|
Uses the SQL Profiler incorrectly to baseline the database
or provides an inaccurate explanation of the steps, relevance, and when to
perform
|
Does not
use the SQL Profiler to baseline the database while providing an explanation
of the steps, relevance, and when to perform
|
6.25
|
|
Administration,
Optimization,
and
Configuration: Automatic
Growth
|
Correctly sets the database to grow automatically by a
certain percentage while accurately explaining the steps, relevance, and when
to perform
|
Incorrectly sets the database to grow automatically by a
certain percentage or inaccurately explains the steps, relevance, and when to
perform
|
Does not set the database to grow automatically while
explaining the steps, relevance, and when to perform
|
6.25
|
|
Maintenance,
Backup, and Recovery:
Committing
and
Truncating
the Database
Log
|
Correctly commits and truncates the database log files
while accurately determining the correct timeframe and explaining the steps
and relevance
|
Incorrectly commits and truncates the database log files,
determines an inaccurate timeframe, or provides an inaccurate explanation of
steps and relevance
|
Does not commit and truncate the database log files while
explaining timeframe, steps, and relevance
|
6.25
|
|
Maintenance,
Backup, and Recovery: Backup
|
Successfully
performs backup of the database while accurately explaining the steps and
relevance and determining an appropriate frequency for backups
|
Performs an unsuccessful backup, or explanation and
determination of frequency are inaccurate
|
Does not perform a backup while explaining steps,
relevance, and frequency
|
6.25
|
|
Maintenance,
Backup, and Recovery: Disk
Utilization
|
Accurately explains how to monitor disk utilization and why
it is important, while providing a correct visualization
|
Explains how to monitor disk utilization and why it is
important, while providing a visualization, but explanation is inaccurate or
visualization is incorrect
|
Does not explain how to monitor disk utilization and why it
is important, while providing a visualization
|
6.25
|
|
Security:
Groups and
Access
|
Accurately identifies present user groups and explains who
has access while visually showing how to locate the information
|
Identifies present user groups and explains who has access
while visually showing how to locate the information, but explanations or
identifications are inaccurate
|
Does not identify present user groups, explain who has
access, and show where to get the information
|
6.25
|
|
Security:
Add/Remove
Users and
Groups
|
Successfully
adds and removes users and groups while accurately explaining the steps,
relevance, and when to perform
|
Unsuccessfully
adds or unsuccessfully removes users and groups, inaccurately explains the
steps, relevance, and when to perform
|
Does not add and remove users and groups while explaining
the steps, relevance, and when to perform
|
6.25
|
|
Security:
Assigning
Database
Permissions
|
Correctly
assigns database permissions to users in groups while accurately explaining
the steps, relevance, and when to perform
|
Assigns database permissions to users in groups while
explaining the steps, relevance, and when to perform, but performance is
incorrect or explanations are inaccurate
|
Does not assign database permissions to users in groups
while explaining the steps, relevance, and when to perform
|
6.25
|
|
Articulation
of Response
|
Submission has no major errors related to citations,
grammar, spelling, syntax, or organization
|
Submission has major errors related to citations, grammar,
spelling, syntax, or organization that negatively impact readability and
articulation of main ideas
|
Submission has critical errors related to citations,
grammar,
spelling, syntax, or
organization that prevent understanding of ideas
|
6.25
|
|
|
|
|
Earned
Total
|
100%
|
