This is version 3.4
Recommended spreadsheet programs for this assignment include Gnumeric, Openoffice.org Calc, and Microsoft Office Excel. You may use another spreadsheet, provided that it is able to save files in an acceptable format.
Imagine you are a teacher and create a grade book spreadsheet.
Below the column headings, insert 5 rows of data for five students.
Use the exact data shown in Table 1 for last and first name, paper 1-4, and exam 1-2. Do not make up student names or scores. Do not insert any numbers in the average or total points columns, and do not enter any grades in the course grade column.
|(insert your name)|
In the column for average paper, in the row for the first student, insert a formula which adds the student's four paper scores and divides the sum by 200 (each paper is worth 50 points). Remember to begin a formula with the
= sign. You can use the
sum function or
+ to add,
/ for division, and parentheses
() for function arguments or for grouping.
Do not calculate the average manually or enter a number in this cell! You must use a formula to let the spreadsheet do the calculation for you.
If you enter a correct formula, it will evaluate to 0.975 in the row for the first student.
In the course grade column, enter a formula for the first student's grade using the
if function. The course is graded pass or fail, and the passing score is 240 points (60% of 400 points). Hint: The
if function works like this. Suppose you wanted to know if a temperature in cell B4 is or is not at least 100 degrees. The formula
=if(B4>=100,"yes","no") will display
yes if the value in B4 is at least 100, and
no otherwise. Adapt this example to the gradebook problem, to show the grade as
P for passing or
F for failure. You must use quotation marks around
F, because they are character strings.
Check your work by manually calculating the proper averages, total points, and course grade for a student who has less than 240 points and therefore fails. Also, make sure that all numbers in the two "average" columns are shown as percentages.
Save the spreadsheet. You will be turning it in electronically, and it must be saved in a file format that the instructor can open. See acceptable file types above.
Login to Oncourse (https://oncourse.iu.edu/), go to A110, and select the "Assignments" tool. Select "Lab 7." Scroll down to the "Submission" section. Click on "Add Attachments," upload your spreadsheet file, and then click on "Submit". Note: As stated in the syllabus, you will be able to turn in this assignment up to two class weeks late (not counting spring break) for partial credit.
Before turning it in, make sure that:
Just your spreadsheet file, electronically submitted through the Oncourse Assignments 2 tool. There is no paper to turn in for this assignment, not even a URL.
The file must be saved in an acceptable file format and uploaded into Oncourse Assignments, or it cannot be graded.
|Headings: course name (made up), "instructor" name (yours), and semester (made up).||2|
|Correct student names and scores entered for the five students.||10|
|Correct formulas for average paper, average exam, total points, and course grade in the first student row (4 formulas, 5 points each).||20|
|Correct formatting of the two averages in the first student row (percent, with one digit right of decimal) (2 formats, 5 points each).||10|
|Formulas and formats are correctly copied to the remaining student rows.||8|