USING ONLINE SURVEYS AND QUESTIONNAIRES FOR ASSESSMENT – GOOGLE FORMS AND SURVEYMONKEY

These are great for:
• Baseline assessment – prior knowledge
• End of section assessment – summative assessment of what they know
• Mid-project assessment to see if learners know enough to start their product

Google Forms
1. You find these in Google Drive/Google Docs. You might have to join Google Drive but it is free. 2. Create a FORM
3. Make the first Question – What is your name? – so you can track each participant’s answers
4. Keep adding questions – a good variety of question-types is best – multiple choice, comment, check boxes, etc.
5. Save and SHARE – you can e-mail it to as many people as you like.
6. At the bottom of the page you will see the link to your survey – copy that and paste it into your project plan in Section D. Don’t lose that URL!!
7. When people answer, their answers are automatically collected on a spreadsheet – click on the name of the survey in your Google drive docs and you will go to the spreadsheet.

Surveymonkey
1. Go to www.surveymonkey.com and sign in. Again, it is free.
2. Create a survey – they will give you suggested questions, but ignore those.
3. Select a type of question – this is more flexible than Google Forms – eg you can rank from most favourite to least favourite, or put things in order.
4. After each question, add another one until you have enough and then Finish.
5. When you SHARE it will give you a URL. Don’t lose it!! Paste it into your project plan in Section D.
6. When people do the survey, they can go to Analyse results to mark their own work.
7. You can collect the results and see how they are doing by clicking the Collect results tab.

Here are two URLs for surveys you can try

https://docs.google.com/spreadsheet/viewformformkey=dEsyYXVUbFowNHFkNTdGYjdnUTRBd0E6MQ

http://www.surveymonkey.com/s/ZRYQ5ZK

You will not be able to see the results as a participant, just do the quiz.

The Project Plan - Section A and B

The project plan is at the heart of your project - without a good plan you will just get lost.

You need to start filling in your project plans now, but you do not need to try and finish it all at once.  The project plan is your guideline for each stage of the project.

Section A: Don't forget to give your project a good title. 

Section B:  This section should underpin the rest of the project. 

 This section is critical

How to use box.net

You should have received an invitation to collaborate on a folder called UKZN PGCE.

Please click to accept the invitation.  You will then be able to create your folder in the box.

Click on NEW to make your folder and subfolders.

UPLOADING A FILE

When you have completed an activity and you are ready to upload it to the box, follow these steps.

1.  Open your folder on the Box and select the folder you want to save into

2. Click on UPLOAD to start uploading your file

3.  When prompted, browse to the file on your computer

4.  Once the file is uploaded you can edit, update  or delete it

Something for the Foundation Phase

I found a fantastic site with ways to help teach sight words.

Here is the link - I hope you enjoy it.

https://www.box.com/signup/collablink/d_137822832/769c305364ff1

Some notes on using the Microsoft Learning Suite

 

SONGSMITH

If you are a musician this programme will drive you mad!  The chords are random and don’t fit what is in your head.  If you are not a musician you will enjoy the fun of it!  Kids love it!

Load the programme

Write some words you want to sing – could be about anything – don’t get carried away with anything too lyrical or fancy.

Open the programme and select NEW SONG

You will see a screen where you can choose the style you want

Scroll to listen. Select the style you think fits your song and click next.

Choose the tempo and click finish:

Press the record button and when it says SING, start singing.

When you have finished, press STOP and it will play back to you.

If you like the song, SAVE,

If you don’t, UNDO and try again.

For a new song, press “SONG STARTER”

Other options:

·        Change the number of chords in the bar

·        Add an intro or ending off bar.

PHOTOSTORY

Select the pictures you want to use and put them into a folder. (This step is optional but it really makes life much easier)

Open Photostory and create a new story.

Step 1:   IMPORT pictures – you can do this one at a time or import all the pictures you are using at once.  Get the order right by pressing the left and right arrows on the screen.  You can also edit your pictures on this screen.

Step 2:  ADD A TITLE – Write what title you want to add and edit it  - font, colour and where you want it on the page.  Do this for each of your slides (or you can do it one slide at a time)

Step 3: CUSTOMISE MOTION – the programme will do this automatically but you can make your own changes – change the speed, change the starting and ending points, etc.

  

Step 4: COMPOSE AND RECORD NARRATION – write what it is you want to record and then record it (or you can get all the narration in first and record screen by screen later)

Step 5: ADD MUSIC – you can use music you have already on your computer or you can ask the programme to synthesise some for you.

Step 6: SAVE your Photostory.

Save it as a PROJECT if you want to come back and work on it later.  Save it for playback if you are happy with it.  This will save it as a .wmv file (Windows Media Video) which you can play on a computer (not an a DVD player).  You can resave it as a .flv file if you want to upload it to Youtube.

 

Project Ideas

Today we chatted about project ideas - there were a few of you who were looking at a project on Weather.

I found these resources on WEATHER while i was looking for something else - they are resources from the British Council.  Have a look at them

http://learnenglishkids.britishcouncil.org/en/fun-games/whats-the-weather

Digital Natives vs Digital Immigrants

We talked in our lecture about how all of you, and the children you will teach are digital natives, while my generation are immigrants to living with technology.

This picture shows it in clear detail.  I learnt a-apple, b-ball, c-cat, etc.

Intel Essentials - a project to remember

Intel Essentials

Today we started the Intel Essentials course - how to develop and integrate a project into your teaching.

You can find the CD online at http://schoolnet.org.za/teach10/
or find it by going to www.schoolnet.org.za
and in the TEACHER DEVELOPMENT tab, go to INTEL TEACH
Scroll down and click on INTEL ESSENTIALS

Just a few points about projects

• Projects take more than one lesson to complete - they can take a week, two weeks, a month, a term - it depends on your topic and your learners
• Projects should have a real-life link in some way.
• Your project must incorporate ICT - but a good project idea can be done in any classroom and context
• As a teacher, you need to set up the project well, or it will be just a "cut and paste" exercise

This is what it says on the Intel CD about projects:

—Learners are at the centre of the learning process

—The project focuses on important learning outcomes

—It is driven by challenging questions

—It is a series of connected activities over a period of time

—It has real world connections

—There is a product at the end
 

—ICT supports and enhances learning

—Thinking skills are vital

    It supports multiple learning and assessment standards

 

YOUR TASKS FOR THIS WEEK

 

1. Create the folders you need in your workspace - it can be on your computer, on the UKZn drive or on box.net

        To use box.net you must accept my invitation to collaborate on the box.  I will e-mail this to you.

 

 

2.  Make a brochure or poster on why we use projects.  Use the information in the blog or on the CD.  Save it in your FACILITATION folder.

 

3.  Download the Project Plan template and save it in the Project Plan folder.  Find it on the CD on

MODULE 1 – Getting Started      Step 5

4.  Look at other people's projects to get some ideas

 

           Resources (at the bottom of the menu)  - Project portfolios - the phase  

           you want to look at

 

The whole portfolio will only be assessed at the end of October, but try and keep upi with the tasks week by week so that you don't have to scramble at the end.

 

Look at these recorded webinars for some prize - winning projects from South Africa

 

Digigirls Puzzle IT out - http://www.youtube.com/watch?v=vC5GxyBBoRA

 

R and J in R and B - http://www.youtube.com/watch?v=MT-proeEmt0&feature=relmfu

 

 

 

 

 

 

 

 

So what must I do now?

The last assignment for this semester is to create 2 Administration documents using Office.

1.  Create a RUBRIC similar to the ones you saw in class.
it needs to contain a table
there need to be clear borders
Foundation Phase students can use a "smily face" type rubric if you wish

2.  Follow the instructions you were given and create a Mark book.  there are two stages for this assignment - the intial setup of the markbook and the sunsequent altering of data.  i only need to see the final product but will check that formulae have been correctly applied

DUE DATE:

Please submit this assignment by the 20 June (after exams) to deb@averys.co.za

If your Powerpoint Assignment is still not in, please submit it BEFORE exams start.

Using Excel for Administration

MS EXCEL

Excel is a spreadsheet programme which allows CALCULATIONS to be made.  It is hugely useful for a variety of different applications in teaching, including the dreaded Mark Sheets which most teachers need to do at some stage or another.

However, that is not all Excel can be used for - here are a few other ideas for using them in the classroom:
Use the cells to design a SEATING PLAN of the kids in your class - and you can even use the REVIEW menu to add comments about what to look out for - "He talks too much" "She will burst into tears if you raise your Voice" etc.

Create a CLASS LIST.  You can sort Alphabetically using the SORT tool - but don't forget to EXPAND THE SELECTION if you select only one column at the beginning



Draw Graphs or Charts to show data graphically.  The Chart Icon allows you to turn your data into a chart.  You can choose a variety of different types of graphs.  You can even make PICTOGRAPHS

Make a MARK BOOK

You have detailed instructions on how to create a Mark Book.  Some of the skills you will need to master are:

• Renaming the Spreadsheet
• Sorting class lists alphabetically
• Orientating Headings
• Calculating the SUM of a range of numbers
• Calculating the AVERAGE of a range of numbers
• Changing data
• Saving and retrieving the markbook

Remember when you perform a calculation that there are some rules that you need to follow

eg

Using MS Office for Administration - WORD

The Microsoft Office - and other shareware Office packages - are "lifesavers" for teachers to use.  They give you an opportunity not only to make your Admin work neat, but also to re-use them in other terms and years.  The best part, is that you can make changes on a regular basis.

Here is a list of some of the things you can use WORD for

¨Creating worksheets

¨Setting test and exam papers

¨Developing assessment rubrics

¨Writing good news or disciplinary notes

¨Weekly lesson plan

¨Creating certificates

¨Designing concert programme

¨Publishing sport team lists

¨Writing letters to parents or sponsors

¨Drawing diagrams using lines and shapes

¨Creating newsletters

¨Writing and editing essays / reports

¨Completing learner support templates

¨Writing CVs

We will look at a few of these applications in this course.

WORKSHEETS

¨Use text boxes, tables and call outs to make the worksheet interesting.

¨Make sure that the text is large enough to read.

¨A clear, clean font makes the worksheet easier to read – even for senior grades

Tests and Exams

¨Tick boxes - FORMS

¨Spacing – 1.5 to double

¨Font size – at least 12 – can be bigger

Assessment Rubrics

¨Tables -these make it really easy to see what is going on.  You can insert a table from the INSERT menu - select how many columns and rows you need.

¤Merge Cells

This allows you to make clear headings for sections of the rubric, or it allows you to make a clear line between sections

Highlight the cells you want to merge and MERGE CELLS

¤Borders and Shading

This makes assessment sheets clear and easy to follow.

Use the Borders and Shading tool to make clear dicisions between types of information in the rubric

¨Smiley Faces or other graphics

In the Foundation Phase you may want to use "smiley faces" to help the learners understand what you are looking for.

One place you can find a smily face icon is in the BASIC SHAPES menu in the INSERT toolbar.

You can even change the shape of the mouth by "pulling" on the diamond on the mouth

Certificates

¨Templates are useful here

¨Office on line - the best ones are definitely on line

¨Make your own and save it as a template so you can use it again

Newsletters

¨Columns make newsletters easier to read - find these in the PAGE LAYOUT menu

¨Use text boxes to emphasise points

¨Insert graphics - remember to use the TEXT WRAP - THROUGH tool so your pictures don't move your text around

CVs

¨Use the Templates Menu or make your own

¤It is called RESUME in the American programmes

¤Choose the type and style you need

¤Don’t put pictures, fancy fonts, etc onto them

¤A cover page is not essential but can make it look tidy

Notes and letters

¨A useful tool is a MAIL MERGE

¨Put people’s names on the top of each letter

¤Find this in MAILINGS

nStart Mail Merge

nSelect Recipients

nMake your own data base of names

                   Merge and Finish to print individualised letters