Tip Sheets | Home   

ICT Skills for Teachers (Office 2016 / Office 365)

Create a marksheet (Beginner level)

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.

By the end of this task you could achieve the following outcomes:

Download an example - Type and change the text
- Change the appearance of the text
- Type and change marks
- Place borders around the information
- Sort the information
- Change column widths
- Total the marks
- Calculate the average of marks
- Calculate percentages
- Save the worksheet

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:

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

Related scenarios

» Create an interactive markbook
» Create a chart
» Import charts into a word processor

Self Assessment  Back to Activities