iRubric: Access: Lab Test B--Chapter 2, a Database rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...

Access: Lab Test B--Chapter 2, a Database

Rubric for evaluating student lab test for MS Office Access 2010. BCS-CA1-5. Students will use database software to create, edit, and publish industry appropriate files. a. Define and apply basic terminology associated with database design, creation, and use. g. Organize and analyze data, e.g. sorting, identifying, finding, filtering, and viewing. i. Create and use queries.

Rubric Code: MX5AWX2

By asameh

Ready to use

Public Rubric

Subject: Computers

Type: Assessment

Grade Levels: 9-12

Access Database Rubric Rubric for evaluating In-Class Access Assessment Parts I - IV
	Exemplary (4) 6 pts	Developing (3) 4 pts	Beginning (2) 2 pts	Does not meet Expectations(1) 0 pts
Question 2 Creating a list showing averages.	Exemplary (4) Create a list, understand the process to generate averages. All breeds with average age for each were displayed.	Developing (3) Create a list, understand the process to generate averages. Most of the breeds with average age were displayed.	Beginning (2) Create a list, understand the process to generate averages. Few of the breeds with average age were displayed.	Does not meet Expectations(1) No evidence was submitted of creating lists with averages.
Question 3 Creating a list showing the lowest.	Exemplary (4) Create a list, understand the process to display the lowest. All breeds were represented with the lowest age for each were displayed.	Developing (3) Create a list, understand the process to display the lowest. Most of the breeds with lowest age were displayed.	Beginning (2) Create a list, understand the process to display the lowest. Few of the breeds with lowest age were displayed.	Does not meet Expectations(1) No evidence was submitted of creating lists with lowest ages.
Question 4 Creating a list using wildcards for desired outcomes.	Exemplary (4) Create list of required fields with required trainers using wildcards 4 and 6.	Developing (3) Create list with most of the required fields and/or with most of the required trainers using wildcards 4 and 6.	Beginning (2) Create list with only a few of the required fields and/or with only one or none of the required trainers using wildcards 4 and 6.	Does not meet Expectations(1) No evidence was submitted of creating lists with specific fields using wildcards 4 and 6.
Question 5 Ascending order by Dog Name within Station.	Exemplary (4) Create list of required fields. All dogs were listed in ascending order within Station.	Developing (3) Create list with most of the required fields and/or with most of the dogs listed in ascending order within Station.	Beginning (2) Create list with most of the required fields and/or with most of the dogs listed in ascending but not within Station.	Does not meet Expectations(1) No evidence was submitted of creating lists with dogs in ascending order and/or within Station.
Question 6 Relationship between tables using specific fields, greater than, and a wildcard.	Exemplary (4) Both tables were used with correct fields, greater than, and wildcard.	Developing (3) Both tables were used with correct fields, and/or no greater than, and and/or no wildcard.	Beginning (2) Both tables were used with some fields missing, and/or no greater than, and and/or no wildcard.	Does not meet Expectations(1) No evidence was submitted of query.
Question 7 Relationship between tables using greater than, mathematical computation and wildcard.	Exemplary (4) Both tables were used with correct fields, mathematical computation, and wildcard.	Developing (3) Both tables were used with correct fields, no evidence of mathematical computation, and wildcard was used.	Beginning (2) Both tables were used with correct fields, no evidence of mathematical computation, and no wildcard was used.	Does not meet Expectations(1) No evidence was submitted of query.
Question 8 Count Query	Exemplary (4) Correct number of pets grouped by breeds.	Developing (3) Incorrect number of pets grouped by breeds.	Beginning (2) Correct number of pets only.	Does not meet Expectations(1) No evidence was submitted of query.
Question 9 Relationship between tables displaying count of pets, grouped by groomer's full name with only top two groomers displayed.	Exemplary (4) Both tables were used with correct number of pets grouped by groomers with groomers' full names with only top two groomers displayed.	Developing (3) Both tables were used with correct number of pets and/or were not grouped by groomers with groomers' full names, and/or only top two groomers were not displayed.	Beginning (2) Both tables were used but incorrect number of pets and/or were not grouped by groomers with groomers' full names, and/or only top two groomers were not displayed.	Does not meet Expectations(1) No evidence was submitted of query.
Question 10 Crosstab Query	Exemplary (4) Correct list of groomers per breed and correct count of the number of pets.	Developing (3) Correct list of groomers per breed, but incorrect count of the number of pets.	Beginning (2) Incorrect list of groomers per breed and incorrect count of the number of pets.	Does not meet Expectations(1) No evidence was submitted of query.
Question 11 Using a parameter	Exemplary (4) Correct use of parameter to display pets for each station.	Developing (3) Parameter was not used correctly to display correct list of pets for each station.	Beginning (2) Parameter was not used correctly to display all stations.	Does not meet Expectations(1) No evidence was submitted of query.

Subjects:

Computers

Types:

Discuss this rubric