Scribd
Upload
2K views1 page

08 Task Performance 1

The document provides the objective, procedure, and grading rubric for a task performance report card on using arithmetic operators and aggregate functions in SQL. The objective is for students to use arithmetic operators and aggregate functions. The procedure involves creating a table with course data and writing queries to display the number of courses, total units, courses above/below a grade of 2.00, and weighted average. The grading rubric evaluates task completion, demonstration of concepts, and provides point values.

Uploaded by

DARA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2K views1 page

08 Task Performance 1

The document provides the objective, procedure, and grading rubric for a task performance report card on using arithmetic operators and aggregate functions in SQL. The objective is for students to use arithmetic operators and aggregate functions. The procedure involves creating a table with course data and writing queries to display the number of courses, total units, courses above/below a grade of 2.00, and weighted average. The grading rubric evaluates task completion, demonstration of concepts, and provides point values.

Uploaded by

DARA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

IT1924

Task Performance
Report Card
Objective:

At the end of the exercise, the students should be able to:

▪ Use arithmetic operators and aggregate functions.

Procedure:

1. Create a table named StudentGrade with the following columns and values. Set the appropriate data
type for each column.
CourseCode CourseTitle Units Grade
COSC1003 Data Structures and Algorithms 3 1.50
GEDC1006 Readings in Philippine History 3 2.25
PHED1003 Physical Education 3 2 1.25
GEDC1014 Rizal’s Life and Works 3 1.50
COSC1007 Human-Computer Interaction 3 1.25
INTE1044 Object-Oriented Programming 3 1.75
COSC1001 Principles of Communication 3 2.25
COSC1008 Platform Technology 3 1.50
2. Using queries, display the following:
a. The number of courses/subjects
b. The total units
c. The number of courses with grades higher than 2.00 (lower than 2.00 in the column)
d. The number of courses with grades lower than 2.00 (higher than 2.00 in the column)
e. The general weighted average (Get the sum of all the products of units and grades, then divide
by the total units.)
Expected output: a. 8 b. 23 c. 6 d. 2 e. 1.67

GRADING RUBRIC (100 points):


Criteria Exemplary (4) Acceptable (3) Developing (2) Beginning (1) No Output (0)
The student The student The student The student The student started
Task Completion completed the completed 75% of completed 50% of completed less than the laboratory activity
(x 15) laboratory the laboratory the laboratory 50% of the but did not make
activity. activity. activity. laboratory activity. significant progress.
The student The student The student The student did not The student did not
demonstrated demonstrated demonstrated some demonstrate an demonstrate an
Demonstration of mastery of the strong knowledge understanding of the understanding of the understanding of the
Concepts topic covered by of the topic topic covered by the topic covered by the topic covered by the
(x 10) the laboratory covered by the laboratory activity. laboratory activity laboratory activity.
activity. laboratory activity. beyond a surface
level.

08 Task Performance 1 *Property of STI


Page 1 of 1

You might also like