| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Advanced Features Using EXCEL

Page history last edited by PBworks 15 years, 10 months ago
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 7-point quiz to coincide with a 100 point grade. Excel is a wonderful tool for translating grades! Here is an example of a 7-point 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 Seven-Point 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 odd-numbered 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 15-Point and 60-Point 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: 20-45 minutes
 

Display fractions in an Excel spreadsheet

1.

Open Excel.

2.

Pre-format 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 one-half. If you type "4/8" to represent one-half, 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: 20-45 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.