CIS

Project

1

Instructions

Design a spreadsheet to calculate the class’s grades. Consider the following requirements:

1.

Each project will be graded from 0 to 10

points

.

2.

Each q

uiz will have a grade from 0 to 10 points.

3.

See your course syllabus to identify the contribution of each grade to the final

grade.

4.

The

tests (midterm and final)

will be graded from 0 to 100

points

, but your solution

should allow

to set

different

values

to

grades (i.e 80 points, 90, or 95

,

)

Thi

s design will

give

me

flexibility when

preparing

the tests

. This flexibility is very important.

5.

Program your so

lution to set a numeric final grade

for the course

.

6.

Use a

LOOKUP

(or VLOOKUP

) table t

o translate the numeric grade to the letter grade

using the corresponding

scale

in the course syllabus.

Functionality, usability, and proper design will be considered

for grading th

e assignment.

Read the questions and answers (Q &A) document

for

Project

and the rub

ric

before start working

on your solution.

Use the link

(red link)

in Project 1

folder

to submit

your

solution

to BB

.

Project 1

Instructions

Design a spreadsheet to calculate the class’s grades. Consider the following requirements:

1. Each project will be graded from 0 to 10 points.

2. Each quiz will have a grade from 0 to 10 points.

3. See your course syllabus to identify the contribution of each grade to the final grade.

4. The tests (midterm and final) will be graded from 0 to 100 points, but your solution

should allow to set different values to grades (i.e 80 points, 90, or 95,) This design will

give me flexibility when preparing the tests. This flexibility is very important.

5. Program your solution to set a numeric final grade for the course.

6. Use a LOOKUP (or VLOOKUP) table to translate the numeric grade to the letter grade

using the corresponding scale in the course syllabus.

Functionality, usability, and proper design will be considered for grading the assignment.

Read the questions and answers (Q &A) document for Project and the rubric before start working

on your solution.

Use the link (red link) in Project 1folder to submit your solution to BB.