Tip sheets | Glossary | Home | Contents

 

Create a marksheet

 

Level of difficulty: Basic

As an educator, you will prepare simple marksheets as part of continuous assessment.  You will want to type the marksheet and save it electronically so that you can insert marks and calculate totals and averages as the term progresses.  You will be able to sort the data and print the record of marks.

Click here for example

 

Create your own marksheet - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps:

 
Description
Resources
1 Start Microsoft Excel How to start Microsoft Excel
2 Type in the headings and learners' names  
3 Sort the names alphabetically: You can enter names in any order, and Excel can sort them for you. How to sort a list
4 Resize the column widths: This will allow cells to accommodate long names How to resize column widths
5 Save the mark sheet: Remember to save your marksheet regularly How to save a file
6 Type the learners' marks: Each mark should be in its own cell.  
7 Calculate the total for each learner How to use the SUM function
8 Calculate the test average How to use the AVERAGE function
9 Calculate each learners' percentage How to use a formula
10 Insert borders around the information: You can print the marksheet with gridlines, making it easy to read. How to insert borders
11 Format the text: Change the appearance of cells containing formulas to highlight them.  You can also colour cells. How to format cells
12 Save the mark sheet How to save the marksheet
13 Preview the print version How to use print preview
14 Close Microsoft Excel How to close Microsoft Excel
 

Related scenarios

Create an advanced markbook

Create a chart

Import charts into a word processor

Home | Contents