Create a simple marksheet

Activity Progress:

Create a simple mark sheet (Beginner level)

As an educator, you will prepare simple mark sheets as part of continuous assessment. You will want to type the mark sheet 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.

By the end of this task you could achieve the following outcomes:- Type and change the text

Change the appearance of the text
Enter and edit data
Place borders around a paragraph
Sort the information
Change column widths
Total the marks
Calculate the average of mark
Calculate percentages
Save the worksheet

Create your own mark sheet – 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
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 mark sheet with grid lines, 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.

If the tip sheets do not help you, seek support in the forum:

Related scenarios (will be linked)

Create an advanced markbook
Create a chart
Import charts into a word processor

Quiz – Create a simple marksheet

Time limit: 0

Quiz Summary

0 of 5 questions completed

Questions:

1

2

3

4

5

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 5 questions answered correctly

Time has elapsed

Average score

Your score

Categories

Not categorized 0%

You have completed the quiz: Design an assessment tool.
However, you have not achieved the required 80%. Please try again.

Congratulations! You have passed the quiz: Design an assessment tool

Would you like to submit your quiz result to the leaderboard?

Loading

Name: E-Mail:
Captcha:

maximum of 5 points

Pos. Name Entered on Points Result

Table is loading

No data available

1

2

3

4

5

Answered

Review

Question 1 of 5

1. Question

How do you create the thick border around these cells?

Select the cells and click on the border icon and then on Thick Box Border.

Select the cells and click once on the border icon.

Select the cells and click on this icon.

Select the cells and click on the border icon.

Correct

Incorrect

Question 2 of 5

2. Question

How would you sort the averages in descending order of merit (highest to lowest)?

Select ALL the cells of data, click Data | Sort then sort as in this image.

Select ALL the cells of data, click Data | Sort then sort as in this image.

Select ALL the cells of data, click Data | Sort then sort as in this image.

Select ALL the cells of data, click Data | Sort then sort as in this image.

Correct

Incorrect

Question 3 of 5

3. Question

What formula would you use to calculate the average (86%) for Mohammad?

=E12/E4

=(E12*E4)/100

=(E4/E12)*100

=E4/E12

Correct

Incorrect

Question 4 of 5

4. Question

How do you make the average mark appear as a percentage?

Once you have calculated the attained score in column E out of the maximum score (E4) click on this icon:

Once you have calculated the attained score in column E out of the maximum score (E4) click on this icon:

Once you have calculated the attained score in column E out of the maximum score (E4) click on this icon:

Once you have calculated the attained score in column E out of the maximum score (E4) click on this icon:

Correct

Incorrect

Question 5 of 5

5. Question

How do you shade the cells in yellow as shown?

Select the cells and click on this icon:

Select the cells and click on this icon:

Select the cells and click on this icon:

Select the cells and click on this icon:

Correct

Incorrect