Scribd
Upload
25 views2 pages

Excel Gradebook Assignment Guide

This document provides instructions for a group assignment in Ms Excel for the Computing Skills lab work 2. Students are asked to create a gradebook with names of 30 students, grades for 5 assignments (quiz, project, midterm, lab, final exam), assignment weights, final scores calculated based on weights, and a chart showing number of students per grade on a separate sheet. The completed assignment must be emailed to the provided email address before the deadline.

Uploaded by

Syed Afiq
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
25 views2 pages

Excel Gradebook Assignment Guide

This document provides instructions for a group assignment in Ms Excel for the Computing Skills lab work 2. Students are asked to create a gradebook with names of 30 students, grades for 5 assignments (quiz, project, midterm, lab, final exam), assignment weights, final scores calculated based on weights, and a chart showing number of students per grade on a separate sheet. The completed assignment must be emailed to the provided email address before the deadline.

Uploaded by

Syed Afiq
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Submit your Ms Words assignment to: CMPF 112: Computing Skills [Lab Work 2] ------------------------------------------------------------------------------------------------------------------------------------------

liyanazakaria87@[Link]

Lab Work 2 : Ms Excel (20 marks) Follow the instruction given. 1. This is a group assignment. 2. You need to email the assignment to liyanazakaria87@[Link] 3. Please save your assignment with your group leaders Student ID. (Example : [Link]) 4. Remember to include your name and the name of your group members in the mail 5. Your assignment should reach my Gmail mailbox by 2.00 pm on 8th August 2011.

Question 1

This assignment will allow you to think about the capabilities of computers when used as a grade book and it will give you a better understanding of how Excel can assist you in record keeping.

Open a new file in Excel Type in 30 "Student" names. Make sure they are arranged alphabetically. Feel free to choose your own names! Row 1 should contain at least the following categories:
o o

Name Five assignments with each assignment being worth 100 points.

(Quiz, Project, Midterm, Lab and Final exam)


o

Final score

Assign grades for each assignment to each student. Average the overall class grade for each assignment. Find out the highest and lowest mark for each assignment. Weight the assignments so that:

Prepared by NLZ

Submit your Ms Words assignment to: CMPF 112: Computing Skills [Lab Work 2] -----------------------------------------------------------------------------------------------------------------------------------------o o o o o

liyanazakaria87@[Link] Quiz = 10% Project = 15% Midterm = 15% Lab = 20%

Final exam = 40% of final score

Fill in the Final score column based on the above information. Highlight fonts or change line thicknesses of the top and bottom rows. Orient your gradebook to "landscape" so that the entire assignment fits on one page. Be sure to do a "Print Preview" to ensure that your gradebook appears on one page. Create chart for number of students per grade and move your chart to different sheet. Rename your sheet as Class Result.

Good Luck!

Prepared by NLZ

You might also like