Description
OVERALL EVALUATOR COMMENTS
EVALUATOR COMMENTS
Professional Communication (Articulation) — The Professional Communication aspect can be fully assessed when required content aspects are in place.
Content — To support you in demonstrating proficiency, you’ll be unable to resubmit your task until you’ve consulted with a course instructor. You defined a logical research question for your analysis. Please see the comments in the rubric for information about aspects that need further development.
A. QUESTION
COMPETENT
CompetentThe question is logical and requires using SQL to acquire data from the original database and the add-on CSV file data.
EVALUATOR COMMENTS: ATTEMPT 1
The submission logically asks whether higher-speed internet package use is more common among customers with children.
A1. IDENTIFYING DATA
APPROACHING COMPETENCE
Approaching CompetenceThe submission identifies which data from both the original data set and the created table from the CSV file are needed, but the identified data do not provide all the tables, columns, and data types needed to answer the question.
EVALUATOR COMMENTS: ATTEMPT 1
The submission identifies data needed to answer the research question from the customer table and services add-on CSV file. The SQL data types of the fields cannot be found.
B. ENTITY RELATIONSHIP DIAGRAM
APPROACHING COMPETENCE
Approaching CompetenceThe ERD for the database does not identify m:n relationships and relational constraints.
EVALUATOR COMMENTS: ATTEMPT 1
The submission includes a partial screenshot of the ERD. The services table is not visible in the ERD, and the relationship of the customer and services tables is not identified.
B1. CODE FOR THE ERD
COMPETENT
B2. LOADING CSV DATA
APPROACHING COMPETENCE
Approaching CompetenceThe SQL code does not correctly load the data from one of the add-on CSV files into the table created in part B1 or it does not include the actual code in text format.
EVALUATOR COMMENTS: ATTEMPT 1
The submission includes code to load the CSV file. The code does not correctly load the data.
C. SQL QUERY
NOT EVIDENT
Not EvidentA SQL statement or statements for a query or queries that answer the question from part A is not provided.
EVALUATOR COMMENTS: ATTEMPT 1
This aspect will be assessed once revisions to task prompt B2 are in place.
C1. CSV FILES
NOT EVIDENT
Not EvidentThe data file or files are not provided.
EVALUATOR COMMENTS: ATTEMPT 1
The submission includes a screenshot of query results. A CSV file capturing the results of the query cannot be found.
D. ADD-ON FILE
COMPETENT
CompetentThe submission accurately and logically identifies the specific time period for how often the add-on file should be acquired and refreshed in the database for the data to remain relevant to the business and the question from part A.
EVALUATOR COMMENTS: ATTEMPT 1
The submission logically recommends refreshing the add-on file monthly.
D1. EXPLANATION OF TIME PERIOD
COMPETENT
E. PANOPTO VIDEO OF CODE
APPROACHING COMPETENCE
Approaching CompetenceThe Panopto video recording is provided, but a full demonstration of the code used, the code being executed, or the results of the code used in the task is not provided, or the video does not capture both the presenter and the vocalized demonstration.
EVALUATOR COMMENTS: ATTEMPT 1
The submission includes link to a Panopto video. Attempting to play the video results in an error message.
E1. PANOPTO VIDEO OF PROGRAMS
NOT EVIDENT
Not EvidentA Panopto video recording of the programs used is not provided.
EVALUATOR COMMENTS: ATTEMPT 1
This aspect will be assessed once revisions to task prompt E are in place.
F. WEB SOURCES
NOT EVIDENT
Not EvidentA record of the web sources used to acquire data or segments of third-party code to support the application is not provided.
EVALUATOR COMMENTS: ATTEMPT 1
This aspect will be assessed once revisions to other task prompts are in place.
G. SOURCES
NOT EVIDENT
Not EvidentThe submission does not include both in-text citations and a reference list for sources that are quoted, paraphrased, or summarized.
EVALUATOR COMMENTS: ATTEMPT 1
This aspect will be assessed once revisions to other task prompts are in place.
H. PROFESSIONAL COMMUNICATION
NOT EVIDENT
Not EvidentContent is unstructured, is disjointed, or contains pervasive errors in mechanics, usage, or grammar. Vocabulary or tone is unprofessional or distracts from the topic.
EVALUATOR COMMENTS: ATTEMPT 1
The Professional Communication aspect can be fully assessed when required content aspects are in place.