Name: Wendy
MS Office Application: Excel
Level: Middle School
Content Area: Math
Type of Application: Teacher
Time: 10 minutes or less!
Many times teachers will have created a quiz or test that does not easily translate to a grades based on 100 points (or a factor thereof). Because grades are typically based on a 100% total, it is important to be able to translate a 7point quiz to coincide with a 100 point grade. Excel is a wonderful tool for translating grades! Here is an example of a 7point quiz translated into a 100 point grading system:
Number of Points Correct 
Total Points Available 
Percentage (Out of 100%) 



0.5 
7 
7.14% 
1 
7 
14.29% 
1.5 
7 
21.43% 
2 
7 
28.57% 
2.5 
7 
35.71% 
3 
7 
42.86% 
3.5 
7 
50.00% 
4 
7 
57.14% 
4.5 
7 
64.29% 
5 
7 
71.43% 
5.5 
7 
78.57% 
6 
7 
85.71% 
6.5 
7 
92.86% 
7 
7 
100.00% 
In order to have Excel automatically calculate the correct percentage, simply use the formula as shown below. All you really have to do is prepare the formula in the first cell only. Then highlight the cell and drag the "handle" all the way down the column. The cells below it will automatically be configured with the formula. Then you simply format those cells as "Percentage."
Grading for a SevenPoint Quiz 








Number of Points Correct 
Total Points Available 
Percentage (Out of 100%) 



0.5 
7 
=SUM(A6/B6) 
1 
7 
=SUM(A7/B7) 
1.5 
7 
=SUM(A8/B8) 
2 
7 
=SUM(A9/B9) 
2.5 
7 
=SUM(A10/B10) 
3 
7 
=SUM(A11/B11) 
3.5 
7 
=SUM(A12/B12) 
4 
7 
=SUM(A13/B13) 
4.5 
7 
=SUM(A14/B14) 
5 
7 
=SUM(A15/B15) 
5.5 
7 
=SUM(A16/B16) 
6 
7 
=SUM(A17/B17) 
6.5 
7 
=SUM(A18/B18) 
7 
7 
=SUM(A19/B19) 
By doing this you can easily translate an oddnumbered number of possible quiz questions into grading on a 100% basis. I have attached the actual document for your review and/or use. Note that I added worksheets for 15Point and 60Point Quizzes and Tests as well. You can add to it or create your own.
Test Grading Scale.xls
Name: Lori
MS Office Application: Excel
Level: Middle School
Content Area: Social Studies
Type of Application: Student
Time: 2045 minutes
Display fractions in an Excel spreadsheet
1.

Open Excel.

2.

Preformat the cells that you want to display as fractions. Select the cells and then click Cells on the Format menu.

3.

In the Category list, click Fraction and then, from the list on the right, select the type of fraction that you would like to display. Click OK.

4.

To type fractions in these preformatted cells, type the numerator, then a slash "/", then the denominator. Do not type spaces.
• 
For example, type "1/2" to represent onehalf. If you type "4/8" to represent onehalf, Office Excel will reduce it to 1/2. Excel reduces all fractions to their lowest terms.

• 
If you need to type a whole number and a fraction in the same cell, type the whole number followed by a space, and then type the fraction (numerator, slash, denominator), for example, "3 1/2".


Name: Lori
MS Office Application: Excel
Level: Middle School
Content Area: Social Studies
Type of Application: Student
Time: 2045 minutes
Summary: Using a Microsoft Office Excel spreadsheet makes creating an accurate and attractive timeline easy and fun. You can designate periods of time by using fill colors for cell groups. Students can even enter text sideways to mark events. If they want to be more creative, they can also add pictures to the timeline.
Comments (0)
You don't have permission to comment on this page.