Assignment - Creating a Spreadsheet
- Due Feb 12, 2022 by 11:59pm
- Points 15
- Submitting a file upload
- Available until Feb 23, 2022 at 11:59pm
Directions
In this assignment, you will be asked to practice some of the skills you learned in the Spreadsheet Basics reading. Once you have read the assigned reading, please complete the following steps:
- Open Microsoft Excel, and create a new workbook
- Save the workbook as YOUR NAME.xlsx
- In column A, enter the assignments for this class (from the syllabus) -- Assignments include assignments, quizzes, discussion boards, and any other assignment you are / would be graded on.
- In column B, enter the corresponding possible points from the class (also from the syllabus)
- Give these columns the appropriate headings
- Convert this data into a table (watch the video tutorial for this)
- Save the file again.
- Submit it below.
- You're done!
How it is Graded
You will earn the full 15 points if you turn the assignment in by 11:59 PM on the due date and if your submission contains all of the required components of the assignment. I will take off 5 points for each missing piece of the assignment:
- information is in the correct columns
- data is accurate in comparison to the syllabus
- data is in a table format
Additionally, I will take off 10% (1.5 points) for each day the assignment is late.
Rubric
Keep in mind that 31 students have already been assessed using this rubric. Changing it will affect their evaluations.
Criteria | Ratings | Pts | ||
---|---|---|---|---|
Information in the correct columns
Did you enter the correct information in the correct columns?
threshold:
pts
|
|
pts
--
|
||
Accurate Data Entry
Did you enter the data accurately when compared to the syllabus?
threshold:
pts
|
|
pts
--
|
||
Data is in a table format
Did you convert the data to a table format?
HINT: Remember there is a tutorial video on how to do this. :-)
threshold:
pts
|
|
pts
--
|
||
Total Points:
15
out of 15
|