Username
Password

New? Register here

[Forgotten your password?]

Browse

- Key Stage
- Year
- Subject
- Type of resource
- Timescale
- Tier
- Date
- Author
- Title

Self-Marking Multiple Choice Quiz Templates

[ View as PDF ] [ View as Text ]

Author: Neil Williams, ICT Support Teacher/On-line maths and ICT lesson content author (29 Sep 03)

At a Glance

Age Range		Secondary
		Primary
		Key Stage 4
		Key Stage 3
		Key Stage 2
		Year 10
		Year 9
		Year 8
		Year 7
		Year 6
		Year 5
		Year 4
		Year 3

Timescale		Task
		Lesson

Scope		Individual teacher
		Individual student

Resource Type		Class Teaching
		Assessment Recording and Reporting

Development Stage		Developing Idea

Description	This resource comprises a series of Excel spreadsheets that have been created to give students multiple choice tests. Each template tells the teacher where to put the correct answer so that the computer can mark it. All you need to do is type your questions and the possible answers in.

Objective	Assessment

Assessment	Look at pupil scores

Prior Knowledge	Knowledge related to the topic you have been teaching

Expectations	A quick, fun assessment that requires little work to mark. All the teacher needs to do is change the font colour on the score box to reveal the pupil results

Hints	Each template type has six variations so that students don't learn the order of the correct answers. More templates will be appearing over the coming weeks and if teachers want to send me any tests they create using the templates I will put them up on the site as well.

Materials	Quiz Templates - A series of Excel (2000 version) spreadsheets that can be used for simple assessments

Comments


Neil Adam, ICT Consultant (12 Nov 03)	Limited experience required - Adapting these quiz templates requires limited skill in Excel - all a teacher needs to do is to replace the words "correct" and "wrong" with the answer he/she requires and save the sheet in a shared area using an appropriate name


Neil Adam, ICT Consultant (12 Nov 03)	Locking finished quizzes - You can lock the finished quiz (once you have amended the questions to suit your topic) as follows: 1) Select all the white cells (for the pupil's name and answers) 2) Click Cells on the Format menu 3) Click the Protection tab 4) Take the tick out of Locked and click OK 5) Click Protection on the Tools menu 6) Select Protect Sheet 7) (Enter a password if required) Click OK Puipils should now only be able to enter their name and the answers. You may also wish to un-protect the final score cell so that you can readily change the shading to reveal the mark.


Neil Adam, ICT Consultant (12 Nov 03)	Further resources - Neil's site contains other resources, some for specific subjects like Maths - it is worth clicking the link to "Home" and browsing around. Some of this content must be purchased


Neil Williams, ICT Support Teacher/On-line maths and ICT lesson content author (17 Nov 03)	Author Comment - The templates have been revised for January 2004 with additional sheets to help with marking and assessment. You need to use the Sheet1, Sheet2 and Sheet3 tabs to move between sheets. Sheet1 is the original quiz template. Sheet2 is a duplicate without the colour to make printing easier. All inputs on Sheet1 will be copied over to Sheet2. Sheet3 is an assessment summary. It will give you the student name, each of the questions, the correct choice and the pupil answer along with their final score. These changes were made following feedback from TRE users. If you don't want to have these additional sheets simply right-click on the relevant tab(s) and select Delete from the pop-up menu.


Carl Sherlock, TRE Moderator (25 Oct 05)	Excel - Some useful resources here, not just the self marking sheets, but schemes of work for Office applications.


David Sweeney, TRE Moderator, PE Primary and Secondary (30 May 07)	Teachers TV Videos - In addition to the primary and secondary PE programmes on Teachers TV, here is the link to dozens of PE videos - searchable across key stages and types of activities. There is also an RSS feed for PE.

Materials

By Author

	Quiz Templates

Self-Marking Multiple Choice Quiz Templates

Comments