Study Opportunities Computer Applications Technology

Piracy for the Kindle

2012-01-21T18:45:00.003+02:00

Piracy is not only for young people looking for music. It is now found among the book club set looking for books for their Kindles and e-book readers.

I was given a flash drive with many folders. I have been buying books to read from Amazon. I was not sure what I was looking at. The nice lady who lent me the flash suggested I copy some books onto my Kindle. On examining the flash drive, only when I found my favourite author and found titles I have bought for Xmas last year did I realise – this is piracy! I thought they were old books out of copyright!

I could not / cannot take any of these and put them on my Kindle. It is wrong. I would like to but … no!

Blind learners studying computers - help please!

2012-01-20T16:45:00.004+02:00

I recently had the pleasure of visiting a wonderful school Pioneer School for the Blind where every cent collected is used to good effect. Learners come to this school in Worcester in the Western Cape from as far away as the Free State because of what this government school has to offer. It offers a way of life for those who need special care. It is a school for the blind and partially sighted. I went to see how they learn to use the computer and study the subject Computer Applications Technology (CAT). One of the learners from this school was the top learner in the country in Matric 2011 from a special needs school and she also studied CAT.
I was shown how a partially sighted learner used the screen enlargement software Magic. That worked well. I was most disturbed when I saw a totally blind youngster use the computer! He was working with Office 2003 – with Jaws, software that reads information on the screen using synthesized speech. I asked why he was using such an old version of Office. The answer – they have licenses for an old version of Jaws which only reads 2003. They need to get a newer version of Jaws in order to read Office 2010. The CAT curriculum will require 2010 soon. They have to get up to date! They need the latest version of Jaws but it costs about R120 000 for 30 licences. And they do not have the money at the moment. They are able to get the Microsoft Office Suite at a reduced cost, the same as all government schools, and then they have this additional cost!
Computers are the way these youngsters are going to earn a living when they leave school! It would be wonderful if every computer class in South Africa had a cake sale or other fund raiser and helped these CAT learners. It would be wonderful if every person who views this blog contributed in some way. The URL of the school is http://www.blind-institute.org.za/. There is a link to do an electronic donation. Let us all donate to the school, requesting that the money be used for computer needs. Please.
It would be wonderful if you dropped me an e-mail at docpam@gmail.com to tell me if you donated and if this blog posting made any difference. This posting is from me in my personal capacity.
I believe in the idiom ‘What goes around comes around’.

Computer Code of Conduct

2012-01-07T23:41:00.002+02:00

We have provided a Sample Computer Code of Conduct on the DVD that comes with the Teacher’s Guide of our new Grade 10 CAT textbook. The one on the DVD has been improved and translated.
It is not possible to write any one single Code of Conduct that will serve the needs of all schools. Study Opportunities has provided this sample code of conduct as a generic example, so the document will have to be adapted to fit in with your local conditions and circumstances in your school, district and province, and to comply with any other existing regulations. You are welcome to adapt this one as you see fit and use it.

Sample Computer Code of Conduct - Voorbeeld Rekenaar Gedragskode

Gr 11 CV

2012-01-01T15:49:00.001+02:00

Grade 11s usually have to make a CV in English or Life Orientation. May I make the suggestion that CAT teachers help the learners make a good Google timeline for their digital resume. These links may help - http://mashable.com/2011/12/31/facebook-timeline-resume/ and http://mashable.com/2011/09/28/facebook-timeline-cover-photo/

Facebook is becoming essential in today's world and in addition to the timeline, what is posted in the status bar is an important part of the digital resume. What is on the About page must also be correct and correctly spelled as well.

Wise words

2011-12-22T07:28:00.004+02:00

Wise words from a computer man for the world of life.

Jobs

2011-12-09T14:07:00.001+02:00

I keep hearing about people who have lost their jobs. I heard about three more people high up in the business world recently who just lost their positions. What has this got to do with CAT - we teach ICT skills and problem solving, which may help those with entrepreneurial skills. Every functioning work station in a computer lab must have a learner and those principals who do not push CAT (because it is not a designated subject) should be ... The subject CAT can do so much to enhance job creation and business.

Walking past people begging and those living in cars is really getting to me.

Letter from Sandra

2011-12-02T10:43:00.002+02:00

This letter is for certain schools. It contains information about invoices and payments and only applies to some schools. They know who they are.

Grade 11 Paper 2 Theory Memo

2011-11-18T07:47:00.001+02:00

Grade 11 Paper 2 Theory Memo

Grade 11 Paper 1 Practical Solutions

2011-11-15T07:45:00.002+02:00

Grade 11 Paper 1 Practical Solutions

Grade 11 Paper 2 Theory

2011-11-15T07:43:00.001+02:00

Grade 11 Paper 2 Theory

Efficiency

2011-11-14T12:45:00.001+02:00

I am amazed at how technology and the World Wide Web have changed our lives. We are now celebrating 20 years of Internet in South Africa.

I needed some particular files. I looked online, unsuccessfully. I asked for help on my Facebook page. A friend in New Zealand responded. I searched further. I contacted a firm in the US via email who recommended a software application. I went to that URL, ordered the application, paid via VISA, all on Friday 11 November. FedEx phoned me yesterday (Sunday) re paying VAT. I paid for it with Internet banking. The box was delivered this morning. Whole process took 3 days.

I am becoming used to this speed and efficiency!

Gr 11 Practical Paper 1 Errrata

2011-11-14T10:14:00.001+02:00

Errata - Use the same password you used for the practical paper

Gr 10 Theory paper 2 Memo

2011-11-13T21:46:00.003+02:00

Gr 10 Theory paper 2 Memo

Gr 10 Practical

2011-11-13T12:20:00.001+02:00

Errata - have a look Use your password for the CAT Gr10 Prac MEMO to open

Word form fields and Fields

2011-11-12T17:56:00.002+02:00

A question was posed on the Comp-Studies mailing list about - a Word query where a person wants sections of text that are duplicated in a document, say in an appendix to be automatically updated if the same 'original' text is changed elsewhere.

Here is my solution in a school scenario, one is a MOV file and the other a SWF. The SWF file has a quiz attached. Comments are welcome about the videos.

ICT and teachers

2011-11-11T13:53:00.002+02:00

I have just seen the UNESCO ICT Competency Framework for Teachers. Take a look - http://unesdoc.unesco.org/images/0021/002134/213475E.pdf Amongst the contributors are Sarietjie Musgrave (ex CAT teacher from Bloemfontein), Trudi van Wyk (ex Department of National Education), Fiona Beal (primary school teacher in Fish Hoek), Neil Butcher (consultant), Gerald Roos (consultant) and Kevin Sherman (Schools Unit at University of Cape Town) – all from South Africa. There may be more but I did not recognise their names.

My wish is that CAT teachers help the teachers at their schools upgrade their ICT skills. Give courses at your schools for teachers. My experience is that my colleagues did not come to my courses but the neighbouring school's teachers came.

Gr 10 Nov Exam Paper 1

2011-11-10T23:14:00.001+02:00

Gr 10 Nov Exam Practical Paper 1

Gr 11 Practical Paper 1

2011-11-10T07:13:00.001+02:00

Gr 11 Practical Paper 1

Gr 10 Theory paper 2

2011-11-10T07:11:00.001+02:00

Gr 10 Theory paper 2

Gr 10 Nov Exam Paper 1

2011-11-07T23:09:00.003+02:00

Gr 10 November Practical examination

Exam time

2011-11-06T21:16:00.001+02:00

Exam time in the CAT laboratory is a good time for checking the system – replace or refresh the image, check that the required features of the programs are functioning, empty the recycle bin, check that all programs are still installed, check LAN connections, etc., etc.

Exam invigilation in the CAT laboratory is a good time to look at the room and plan improvements, e.g. the layout and wall notices. Being in the room for the long invigilation sessions is a wonderful opportunity for contemplation and planning. Also walking around with a duster collecting dust (without disturbing those doing the exam) is a useful task if one needs something to do (use Wet Ones if there is not too much dirt ).

The change of tempo is actually refreshing!

Hope preparation and exams go well.

Courses offered

2011-10-26T10:46:00.002+02:00

These grand courses are offered by UCT School Development Unit in December - Internet Basics, Google Earth for Educators and Interactive Whiteboard for Maths Teaching. Have a look.

2011 Final matric exam Question 7 Access

2011-10-25T17:43:00.003+02:00

In a previous posting I indicated that one should go over old examination papers before the big exams. I will now add go over old examinations papers in the venue which will be used for the examinations. Exams have to have questions on a specific set of skills so exam papers ask those skills. So those skills should be practised in the venue where the exam will be written to check if the computers ‘can’ answer the questions (as well as checking learners’ skills). Most computers centres have some or other feature which is unique to them and although they may be re imaged before an examination, I always suggest ‘use’ the centre, test it. And after this question, I suggest practicing mail merge with different versions of Access and your version of Word.
Have a look at how to solve the question.

Laptops and mobility

2011-10-21T10:35:00.005+02:00

Laptops are mobile and allow one to work where ever. Family men have to work but also want waves so this man has the laptop with him while waiting for the right waves. Such a good illustration.

Examination papers

2011-10-20T16:58:00.001+02:00

I have noticed on a number of social networking services that people are busy setting their November exam papers. The CAT teachers could use the papers available from Study Opportunities, link http://www.studyopportunities.co.za/downloads/2011/07/EntryFormStudyOppCATPapers2011.pdf with extra information extra information at http://www.studyopportunities.co.za/downloads/2011/07/InfoPapersStudyOpp.pdf

Comments on 2011 CAT Matric paper

2011-10-20T11:46:00.001+02:00

One of the benefits of this blog is that you can comment Anonymously or by using your name.
How did the examinations go? How did the September paper set by Study Opportunities help prepare learners for the final examination?
Looking forward to seeing responses.

Blackberry

2011-10-14T08:19:00.001+02:00

Latest information for CAT learners

http://www.youtube.com/watch?v=kAG39jKi0lI

Have a smiling day

Guide to using Email

2011-10-13T18:29:00.006+02:00

We teach such a useful subject! This week the local librarian was telling everybody about her fear of an assessment which she will be doing this week on Email. Mmmm – about not using capital letters for the whole email, how to reply, etc. I listened and tried not to brag about what a valuable subject we were teaching at school. Have a look at the file which I used at an adult course about email.

Here is part of the file

When to use

When it is necessary to send information to many people
When copy of instructions is needed by the receiver and the sender
When sent to a distance and it is cheaper to communicate via e-mail than voice
When unable to get the person in voice contact for time or distance reasons
When sending a file attachment for perusal

When not to use

When emotionally responding to a message
When sending confidential information

Was the file/information useful?

Computer Applications Olympiad

2011-10-06T00:06:00.001+02:00

I had the pleasure of attending the awards evening of the Computer Applications Olympiad at Kelvin Grove Newlands tonight. The finalists were a lovely bunch of young people from across the country. Well done to the Computer Society of South Africa for arranging the Olympiad. Congratulations to the finalists!

Computer Applications Olympiad

2011-10-04T07:49:00.001+02:00

Today are the finals of the Computer Applications Olympiad! Good luck to all contestants!

AUP for Social media

2011-10-02T18:32:00.001+02:00

Our learners will probably be going into a world where social media is available from their office computer. Their office/employer may not have an AUP policy however the learners should be made aware of do's and don'ts. Have a look at this site for an acceptable use policy for social media. Some very good comprehensive ideas. http://www.websense.com/content/social-media-acceptable-use-policy.aspx?reg=duodenom

2011 Census and the PAT

2011-09-25T21:29:00.005+02:00

I have just started working for StatsSA on the 2011 census. It is a month of hard work doing training and then making contact with the respondents in the area in which I will be working. We all have to get information from the 150 households in our designated areas. After today's training I thought of databases and the PAT.

In the PAT you need to find information. In the Census the government wants to get information.
In the PAT data collected has to be in a format which can be analysed. In the Census data is in a number format which can be analysed.
In the PAT data collected is meant to be confidential. In the Census all information collected is confidential.
In the PAT you often give a questionnaire a number to help with sorting and checking. In the Census questionnaires are also given a code for checking purposes.

Between 10 and 31 October households will have enumerators visiting them with questionnaires that need to be completed for the Census. Make sure you see them. As you look at them, think PAT.

Grade 10 textbook

2011-09-22T20:12:00.003+02:00

Hoping that everybody is buying the best textbook for their needs. - Here is an advert.

Searching in Windows 7

2011-09-19T11:10:00.005+02:00

Here is a screencast (video) in MOV (8 MG) and WMV (6 MG) file format on doing a search in Windows 7.

Here is a different screencast in the form of a PowerPoint presentation in doing a search in Windows 7 in MOV (3 MG), WMV (3 MG) and Flash with a quiz (2 MG) format. Download or look at online.

Please let me know which of these 5 files presents the information the best. Which is these is best to use for teaching? Thanks

Gr 12 September Theory memo

2011-09-14T21:16:00.002+02:00

Grade 12 - 2011 September Theory memo

English and Afrikaans

Gr 12 September Theory

2011-09-12T00:03:00.001+02:00

Gr 12 September Theory

Question paper English and Afrikaans

Samples from new CAT Gr 10 textbook

2011-09-11T11:31:00.002+02:00

Samples from new CAT Gr 10 textbook: Computers, part of your life

Contents per term (Eng / Afr)
Table of contents (Eng / Afr)
Module 1.1 (Eng / Afr): Introduction to computers
PowerPoint for Module 1.1 (Eng / Afr)
Module 3.1 (Eng / Afr): Start working with text
PowerPoint for Module 3.1 (Eng / Afr)
Sample video for Module 3.1: Symbols as mov or wmv format (more than 50 videos included with teacher’s guide)

Gr 12 September Memo

2011-09-04T23:27:00.001+02:00

Paper 1 Memo
CAT marksheet, RTT marksheet Solutions

Do not judge a book by its cover

2011-09-03T22:32:00.002+02:00

I had a bad day. I went decided on retail therapy to improve matters – I wanted an e-reader.

The bad day continued. I went to computer shop at a small mall nearby. I was told it 'was expensive, about R1500' and they did not have any. I could not think why the man told me they were expensive, as for me that amount was not unreasonable.

I went to the V&A Waterfront. I went to the largest computer shop, part of a chain. I saw three salesmen playing a computer game and asked if I could interrupt them, and could I see an e-reader. They showed me the three models they had on offer. The one I liked had no price but the salesman went and found the price – R2500. I told him I would like to see others at the Waterfront, probably at the large bookshop and may come back. (He neglected to encourage me to return or tell me the bookshop had none, and there were none to be bought anywhere at the Waterfront.) I walked around not able to find any other e-readers and finding a total lack of interest in selling me anything. Eventually I went back to my home town without an e-reader and puzzled about my lack of success.

I went to a large mall in my area, to a computer shop, part of the same chain as found at the Waterfront, but no salesperson even bothered to attend to me when I was peering in the locked display window of e-readers. I left the shop without an e-reader and fuming.

I HAD to have an e-reader but the bricks and mortar shops could not be bothered to sell me one. So I bought it online.

I have spent the last few days puzzling on the lack of service and have reached a solution. I looked too poor to afford one or I looked too old to know how to use computer equipment or I looked wrong, whatever that is.

Well, to all those shop assistants, do not judge a book by its cover! I have enough to pay cash for an e-reader and also bigger things.

Errata

2011-09-02T09:26:00.002+02:00

Rekordeksamen: Errata by AFR data: Maak Vraag 4 se datalêer OpeDag reg.
Data-werkblad, Sel C11 moet Mnr Wilson wees en nie Mev Wilson nie..

Procedural memory

2011-08-31T09:00:00.004+02:00

For a CAT practical examination the skills examined should have been converted into procedural memory in the minds of the learners.

Procedural memory is a type of long-term memory of how to perform different actions, procedures and skills, e.g. riding a bicycle. This is "know how" memory. When needed, procedural memories are automatically retrieved and utilized for the execution of the integrated procedures involved in both cognitive and motorskills (Wikipedia).

Procedural memory is created through "procedural learning" or, repeating a complex activity over and over again until one figures out how to make all of the relevant neural systems work together to automatically produce the activity.

So learners should go over old practical examination papers before writing the final paper, as well as thoroughly repeat those complex procedures during the year.

2011 September Matric exams

2011-08-31T08:14:00.002+02:00

2011

Paper 1 English question paper, Afrikaans question paper, Data files, To the teacher

Computational thinking

2011-08-26T22:17:00.001+02:00

Some time ago on the CompStudies mailing list CAT and IT teachers were encouraged to join the Computer Science Teachers Association (CSTA) at http://csta.acm.org/. Since I joined I have been receiving printed copies of their journal.

The article on Computational thinking as the Fourth "R" in the July 2011 edition caught my eye. The definition of computational thinking found at http://csta.acm.org/Curriculum/sub/CurrFiles/CompThinkingFlyer.pdf and the article at http://csta.acm.org/Curriculum/sub/CurrFiles/LLCTArticle.pdf describe so many activities encouraged and promoted in CAT and IT. One realises how CAT and IT are helping to bridge the digital divide not just in access but in way of thinking.

Gr 10

2011-08-24T22:20:00.002+02:00

Full ordering details of the new Gr 10 CAPS edition of Computers, part of your life textbook.

Power of social networking sites

2011-08-24T21:24:00.002+02:00

Social networking sites can keep one up to date on what is happening. I have watched events in Egypt, England and Libya this year and know that social networking sites have kept people informed.

The terrible events on Aquila Game Reserve in the Western Cape on 20 August and the desperate battle to keep their rhinos alive are being followed by thousands on Facebook and Twitter. I only hope that the details of the poachers and the reward of R100 000 will be spread and the culprits soon caught.

New books

2011-08-24T11:01:00.002+02:00

New Grade 10 book cover! The CAPS edition!

Google Translate

2011-08-13T19:15:00.001+02:00

I love Google Translate! When I was overseas walking the Camino I met many people from Sweden, Germany, Spain, France, Korea and Holland. I am now friends with them on Facebook. We have all uploaded pictures on which many people post comments in their own languages. I can copy/paste their comments into Google Translate and set their language, for the translation.Great!

Social media

2011-08-10T09:48:00.001+02:00

I wish that all CAT teachers discussed this with their learners – good article called 'To Teens, Tweens and the People Who Love Them: It's Time to Get "Social Smarts" ' found at http://socialmediatoday.com/brandsprout/330622/open-letter-teens-re-social-media

Internet access on Camino

2011-08-04T16:55:00.002+02:00

Maybe you wondered why I have been so quiet recently. I have been busy walking from St Jean Pied de Port in Southern France to Santiago de Compostela near the Atlantic coast in Spain, 800 kms. I walked the Camino. I did the first 220 kms then my foot gave trouble, then I bussed a few hundred kms, then walked the last 100 km with two sticks and one leg.

Along the way I stayed in hostels, in tiny towns, which had Internet access machines. I was able to watch and reply to all emails but paid! When I reached the large city of Santiago I treated myself to a hotel. The hotels (not hostels) did not seem to have Internet access machines, only wi-fi. I came to the conclusion that in places where 'poor' people stay, i.e. hostels, they provide Internet access machines, but where rich people stay, i.e. hotels, they have their own iphones, ipads, laptops, etc. so access is not required. I had to walk right across town to find an internet café.

The pictures of my trip are on Facebook https://www.facebook.com/docpam - start from June 27. Hope you have joined the Study Opportunities Facebook page, link at side.

CAPS documents

2011-06-25T19:15:00.001+02:00

The CAPS documents are being uploaded and the CAT CAPS is there.

Go to http://www.education.gov.za/Curriculum/CurriculumAssessmentPolicyStatements/CAPSFETPhase/tabid/420/Default.aspx

How to teach in a CAT lab – how not to tire yourself

2011-06-21T21:32:00.001+02:00

I have had the pleasure of observing a number of CAT lessons and reading what CAT teachers think of CAT. These comments are based on this.

In the CAT lab, whatever you do, when you give instructions you must see the ‘face’ of every learner. You must be able to eye ball them, and they must see your eyes and if necessary be able to read your lips. This is absolutely crucial if you do not want to tire yourself having to repeat instructions.

In the CAT lab the air conditioner needs to be set so that all learners can hear the teacher comfortably, without the teacher shouting.

In the CAT lab all learners must be on time for a lesson. You should only have to give an instruction once, all learners should be in the room when you give the instruction, and all must be able to hear/see you giving the instruction the first time.

Swamped by trivia

2011-06-16T18:17:00.001+02:00

I have realised that my email life is becoming too busy. I realise that I have subscribed to too many mailing lists. In the last few days I must have unsubscribed from at least 20 lists. Instead of a stream of emails during the day I only have mail from 'important' people. It is amazing how easily one is pulled into the flood of unimportant bits of information from book shops, cinemas, special offers, technical news, teacher news, etc. I was being swamped by trivia. Do others feel the same?

Online world

2011-06-10T11:42:00.004+02:00

Being on ADSL or permanently linked to the Internet you can watch amazing things. Many people have signed the online petition South Africa: Stop the Secrecy Bill at http://www.avaaz.org/en/south_africa_stop_the_secrecy_bill/ Watching the numbers change is fascinating. Have a look!

Self marking quiz

2011-06-08T22:24:00.002+02:00

Here are two self marking quizzes - maybe you could copy the idea and let your learners make one, learning IF, sum and percentage - Adams and Maqungo. They are in Office 2010.

Grouping WordArt and a picture

2011-06-08T12:29:00.001+02:00

To group WordArt and a picture

In Shapes, in the Illustrations group on the Insert tab, select a New Drawing Canvas.

Paste the required WordArt and picture into the drawing canvas.

Select the objects you want to group by holding the "Ctrl" key. Right-click in the canvas and select Group. When you resize the canvas all the grouped objects will be resized proportionally.

News from the Department of Basic Education

2011-06-04T22:54:00.006+02:00

Have a look at the May 2011 Curriculum News from the Department of Basic Education and join the Department on Facebook - go to DBE SA on Facebook.

Thinking and computer screens

2011-06-04T12:58:00.002+02:00

I belong to a number of mailing lists and on one recently there was a discussion of digitising textbooks. In the light of that I wish to make a few comments.
I work with computers all the time, 3/4s of my waking hours are spent in front of a screen, so I am used to computers. However when I need to read important documents that I have to cognitively engage with, I need it in printed format in my hand. I have had to review journal articles, and edit book and thesis chapters – small formatting functions can be seen on screen but not faults of conceptual design.
I think the rush to computer screen needs to be done with great care.

2011 Municipal Elections

2011-05-22T15:45:00.003+02:00

I am so impressed with the web site of the IEC which covered the local government elections www.elections.org.za I followed the results by looking at the Results map and the Reports. I was able to find the results per ward, percentage Voter Turnout, Spoilt Votes, etc. I was able to download Excel and pdf files with up-to-date results as they came in. Well done to their web design team!

Successful schools

2011-05-16T18:52:00.001+02:00

Teachers please read this article - http://www.mckinsey.com/App_Media/Reports/SSO/Worlds_School_Systems_Final.pdf - How the world's best performing school systems come out on top - see what makes successful schools.

Best practices

2011-05-08T12:00:00.002+02:00

What are best practices for a CAT teacher? I identified a few areas that I think are important such as Classroom management, Time management, Network management, Teaching and Principal management. Are there other areas of importance and what should one focus on in these different areas?
Feel free to contribute on this blog as yourself or anonymously. Thank you. I need this information for a group I am working with.

Time management

2011-05-08T11:57:00.002+02:00

Time management is essential to a CAT teacher so a calendar is needed. Letting certain people know your appointments is useful, as well as synchronising two or three different people's calendars. Alerts to remind one of appointments is useful. And then getting many people to agree on a suitable date for a meeting is useful. This pdf file may help.
And today being Mother's Day these ideas may be useful to her.

Planning

2011-04-16T22:22:00.001+02:00

I have the pleasure of coaching some CAT teachers. One of the tasks I gave them was to create an assessment calendar for themselves. Key concepts that were part of the task were using templates and adding all the relevant assessment dates in the subjects they taught. I wanted this calendar to help them plan their lives and their marking, reports and meetings. Have a look at the task. http://studyopp.blogspot.com/2011/02/teacher-activity-no-5-assessment.html

I was very pleased that they indicated what a useful task it was, and that in doing my task they forced the management at their schools, to actually set the big assessment dates and report dates for the year! School management should have those dates ready in December for the whole of the following year!

PATs in 2011

2011-04-09T12:08:00.002+02:00

I have just seen that the Gr 10 and 11 PATs have been uploaded. Look at http://www.thutong.doe.gov.za/computerapplicationtechnology/Home/Blogs/tabid/2236/EntryId/446/Practical-Assessment-Tasks-PATs-Grade-10-12.aspx

Setting tests and exam papers

2011-04-04T12:19:00.001+02:00

Many teachers are busy setting tests/exams during this break. Many people cannot express themselves in words/text on a page.

May I make a suggestion re the language. If you cannot answer a question without using YOUR hands the learners will not be able to answer the question, and it should be rephrased into a writeable format.

Mailmerge with Access

2011-04-01T15:05:00.001+02:00

Here is the PPT in 2003 and zipped for this work. This is a continuation of a previous posting on Gr 12 PAT and Access.

Database

Create a database with the fields: Name, Surname, Grade, Student ID

Requirements

You may enter a learners' details once only
The surname must display as capital letters
Most of the learners are in Grade 10
The ID must be 6 characters and display as 2 letters, a number, then 3 letters, all lower case

Add

Add 10 records where the learners are in grades 8-12

Note

Create a short basic note

Just add a picture of the school badge to a word document

Basic note

To create a note with learner's name, from a database
To create a note with learner's name, from a database, in a particular order
To create a note with learner's name, in a particular grade, from a database
To create a note with learner's name, from a database, with many notes on one page
To create a note with learner's name, from a database, with a specific note for learners in Grade 10 or higher

Labels

To create a set of labels of a particular size
To create a set of labels with learner's name, from a database
To create a set of labels with learner's name, in a particular order, from a database
To create a set of labels with learner's name, in a particular grade, from a database
To create a set of labels with school name and learner's name, from a database

Merge from a spreadsheet or a word table

The top row in the spreadsheet or the word table should be headings (in bold)
If using a word table the table should be at the top of the document, i.e. no spaces at the top
Every cell should have a heading. Word art should not be used in the heading row
No cell should be merged
Can use any sheet from a spreadsheet but not from many sheets

Office 2010

2011-03-27T17:33:00.001+02:00

I have to upgrade from Office 2007. I have been online and phoning around looking at prices for Microsoft Office Professional 2010 and have found prices ranging from R4459 up to R5999. The local little computer shop have the best price! Such a huge range is unbelievable.

Gr 12 PAT and Access

2011-03-17T10:40:00.003+02:00

For the Gr 12 PAT in 2011 learners have to collect some information via a survey. It is suggested that all survey information be designed to fit into a cell in a database. Information can easily be analysed using a database. Using a database it is very easy

to add data
to add valid data
to add data which looks as required
to extract what is needed with a query
to do calculations with records in a report
to make report look as we want it.

A group of teachers and I designed this PPT in 2003 and zipped to show learners how Access has features which can help with their PAT and data input, based on pages 165-169 of their textbook.

Teacher activity no 4 - Creating a self marking quiz

2011-02-27T12:01:00.002+02:00

The awards for Teacher activity no 4 - Creating a self marking quiz - go to the teachers Melanie Mare of Hoerskool Pietersburg and Carmenn Schutte of Midrand High School. Congratulations!

Teacher activity no 5 – Assessment calendar

2011-02-25T23:17:00.002+02:00

A teacher needs to manage their time very well. Excel and Word have a variety of calendar templates available installed or online. In this activity we will create a personalised calendar with assessment dates for the grades and subjects taught.

Open Excel or Word. Click on New and select templates, calendars. Explore the various options and forms of calendars either installed or online. Select a calendar for the whole year, either as separate sheets for every month or with a single sheet for the year. You need to add many details so it must be large enough!
Download the selection. Save the file. Check that you are able to type on/in the date area.
Insert South African public and school holidays. Show these dates with images or colour.
Insert assessment dates and details into the cells. Distinguish the different grades / subjects / types of assessment with images or colour in the different cells.
Insert dates when marks for reports must be submitted.
Add the school badge so that it will display, as a footer/header or in some other way.

Submit your personalised assessment calendar zipped as an attachment with teacher name and school to docpam@gmail.com by Monday 7 March. Creators of submitted calendars will be commended.

2003, 2007 and 2010

2011-02-23T20:06:00.001+02:00

Schools and teachers are going to have to change to Office 2007 or 2010. One will have to upgrade. Those using 2003 – well … books are not going to be written using that software anymore. Youngsters born in 2003 are now at school!

Living and the PAT process

2011-02-23T19:48:00.003+02:00

I have had a most entertaining time the last few days with my niece visiting from New Zealand. She is doing her PhD on Amnesty (of the TRC) and looking to see if it is justice or political expediency, that is it in simple terms. She is doing her research in South Africa, Brazil and Chile and comparing them based on that topic.

She must have spend months researching her topic as when she arrived here she knew everything about the TRC and who got amnesty for what, why, etc. She knew who she wanted to talk to and had made appointments with them. My job was to be taxi and get her around in Cape Town and Stellenbosch to Parliament, NGOs and universities, and take her to bookshops which she could not browse through in her home town. She had her questions ready for each separate interview. She left for Brazil yesterday where she will do similar interviews and then go onto Chile. When she gets back to her home town she will collate all the interviews and based on what she has found she will formulate a survey form with more question and send to people she met and others, so that she can have a deeper understanding to be shown with statistics and meaningful graphs. When she gets it all back she will then analyse all that data and write a meaningful report on what she found out. Is amnesty given for real justice or just for political peace (expediency).

She read up all about the topic. She planned who she had to see and where and what to ask them to help solve the amnesty problem. She has and will collect information in the next few weeks. She will refine her questions and send out surveys after these initial interviews and information collection. She knows that she will be pulling all her completed survey numbers into a statistical program. She knows that it has to be written up into a long document, with different chapters indicating her literature research, how she did the investigation, the data she found and then her interpretation of the data. If she wants to get a job as a lecturer or work for the UN she will have to create some good PPTs and write good articles to show what she found. She has to be ready with some interpretation as she has a job for a short time later this year in Kazakstan. She will have to keep all her evidence in bibliographies and the survey forms in case someone argues with her. I guess that she will be in the South African/Brazilian and Chilean media in a year or two when the job is finished, and she will have to be able to prove her ideas.

Computers and the Internet were used by her in New Zealand and here.

In her home town she used the Internet and electronic journals to access information on the TRC and the amnesty process in SA, Brazil and Chile.

She set up appointments via email.

She bought a USB modem with a large data bundle for all the Internet work in South Africa. (In Brazil she will keep the same modem but with a new data bundle.) From my lounge in Cape Town she Skyped her boyfriend and talked with him via computer, she Skyped computer-to cell phone to her mother and she kept contact with all her friends via Facebook. She was able to send URLs of the tourist places we went to such as Robben Island, Club Mykonos, shark diving, the fossil farm at Langebaan, quad biking, ballet at Oude Libertas, wine estates, etc. so that overseas people knew what we were doing on quiet days.

On her appointment days we found the locations via Google Map and Street view and printed them. Thank goodness for Google Map as many streets do not have visible names and the Google Map/StreetView with images showed pictures of the route. One day I will buy a Garmin.

When she left she was brushing up her Portuguese via a language program on CD transferred to her IPod. Her Spanish is already good, ready for Chile.

A PAT is all about planning, collecting information, refining the idea and questions, collecting information, processing all the data into meaningful knowledge and presenting it. Niece did a great deal of planning, however I saw a few small errors – she forgot her earphones so I was able to hear every word she and the people she was talking to, and she left her cell phone in the car back in New Zealand but used a spare one of mine. Otherwise her planning has been marvellous. The next part has to be good if she wants to get a meaningful job and not repay her bursaries.

Internet access in rural America

2011-02-21T08:07:00.001+02:00

An interesting link discussing Internet access in rural America. I thought that the world's largest economy would have good access everywhere. Now we can see access in South Africa in perspective.

http://www.heraldtribune.com/article/20110218/ZNYT05/102183004/2055/NEWS?Title=Digital-Age-Is-Slow-to-Arrive-in-Rural-America

Input device

2011-02-20T22:01:00.004+02:00

We saw a fingerprint identification login system at Ocean Basket today. Next time you are there watch the till / point of sale (POS) area and see how the staff login to the computer and enter details of what you ordered, and then again to print the bill. If they have dirty fingers they just wipe them on their pants, and with their clean fingers login. I believe the touch screen may get dirty but clean fingers are necessary for identification. We may be moving to the controls mentioned in the book and movie '1984' but I think it such a clever idea.

Teacher activity no 4 - Creating a self marking quiz

2011-02-16T22:27:00.003+02:00

Learners love doing quizzes and testing themselves. Such quizzes are useful in that learners can redo them until they know the material. In this activity we will adapt a ready made quiz.

Use the file found on the Study Opportunities Gr 11 CD, in the data folder of Chapter 1.2, called Internet Quiz or Internet TrueFalse. You can use either. They are perfect to use and adapt for your own quiz.
Copy and save the quiz as 'testing' keeping the original in good order.
Open the file with a browser and do the quiz until you are familiar with the questions and the detractors and keys. Close the file.
Right-click on the file and open it with Notepad. It displays coding and the important text which you can change to make it your own. Look for the text which are the questions. Look for the coding which could be the answers (detractors and key) to the questions. Look at the questions and check the answers. The A or B or C or D, refer to the 1^st or 2^nd or 3^rd or 4^th answer (key). In this activity we will only change the wording of a question. We will NOT touch a punctuation mark, backslash or pointed bracket.
In Notepad look at the first question. Replace the words of the question and the detractors and key. Check that the correct answer corresponds with the letter for the answer in the answer coding. Save the file with the file extension htm. Close it. Open the file with a browser. Try the question. If it works, good. If it does not work, close the file, think where you did not follow the instructions and start again.
Change all the questions one at a time, checking after each.
See if you can change the title.
Let your learners try the quiz – let them make their own quizzes following these instructions.

Submit your quiz zipped as an attachment with teacher name and school to docpam@gmail.com by Friday 25 February. Creators of submitted quizzes will be commended.

Teacher activity no 3 - Labels with a graphic and text

2011-02-06T20:39:00.003+02:00

Being able to quickly create labels to affix to property is very useful in a school where rooms are regularly checked for the contents. This activity will help you to create labels with a graphic and text.

Decide on the size of labels necessary for the amount of information to be added. Check and see what size labels are available at school or at a shop such as CNA or Makro. Tower and Avery are common designs.
Open Word. Insert a picture such as the school badge onto the blank page.
Click on the picture to select it. Change the width and height of the graphic as required. Set the picture with the Text Wrapping feature to Tight.
Select the picture again. Go to the Mailings tab and click on Labels in the Create group (not Mail merge).
Click the Options button and select the Product Number that matches the labels you have. Click the New Document button. A page of labels, with the picture you chose, will open.
Delete the graphic in all the label cells except the second. (You may wonder about the second – further down in the instructions you have to copy/paste. I find it easier to copy/paste from the second than from the first cell.)
Insert a text box in the second label cell. Add text to the box and format the text. Right click the text box and click Format Text Box. Make sure it has no border line. Move and position the text box as you want it in the cell.
Select the contents of the cell and copy/paste the graphic and text box into the remaining label cells. (Copy from the bottom left hand corner of the cell.) Print onto label paper.
Most label software has the printer setting set to manual so if it does not want to print, check this setting.
Submit as a word or pdf document with the labels as an attachment with teacher name and school to docpam@gmail.comby Friday 11 February.

Creator of the first completed set of labels submitted will be commended. OR send me an email indicating what you are unable to do and I will create a learning object to help you and others to do it.

E-tags

2011-02-05T09:41:00.003+02:00

This story in The Times of 5 February 2011 tells how e-tags will be used on cars to generate funds and pay off road improvements. I have never seen e-tags being used and this article nicely explains how it is used in a local situation.

The roads included in the GFIP are the N1 from Pretoria East to Golden Highway south west of Johannesburg, the R21 from the N1 to the N12 near Rondebuilt Road, the N3 from Buccleuch in the north to a little beyond Barry Marais Road south east of Johannesburg, and the N12 from near Putfontein east of Johannesburg to where the N12 joins the N1 near the Golden Highway. http://www.timeslive.co.za/local/article894546.ece/Motorists-to-pay-66-cents-per-km

I would guess that this is the type of exam question showing new trends of ICT. Last year the exam paper had questions on the e-reader, Facebook and GPS as examples of new trends. I think this may be important!

Grade 12 Updated data file and solutions

2011-02-04T06:58:00.003+02:00

Updated data file and solutions for CAT 3, 1st Edition, Chapter 1.2 (Buying a computer)
ComputerAdverts 2011
1_2 SolutionsNotes 2011

Girls shine in Olympiad

2011-02-03T16:06:00.003+02:00

Half of the medal winners at the South African Computer Applications Olympiad were girls – beating more than 6 000 participants countrywide. However, the winner overall was Taariq Asmal of the Tshwane Muslim School.
The Computer Olympiad attracts 38 000 participants in the First Round, but only 3 500 go on to the Second Round which requires programming skills. In 2010, for the first time, there was a Second Round for Computer Applications – such as spreadsheets, databases, word processors and presentation tools. It was a pilot project, and the organisers expected around 500 participants – instead there were more than 6 000.
The 2010 teachers strike delayed the Final Round till January 2011.
The top eleven of the 6 000 were invited to a Final Round over the weekend to find the best Computer application user in South Africa.
Four of the eleven finalist's were girls – most unusual for a technology based Olympiad. More surprising, three of the six medal winners were girls and one was only in grade 11 when she beat 6 000 others to reach the finals.
Guest speaker, Prof Louis Fourie, Head of Information Systems at the University of the Western Cape, stressed the shortage of Computer skills in South Africa and the opportunities awaiting the participants. The awards were handed out by Carina Labuscagne, CAT & IT Co-ordinator at the Department of Basic Education and Bersan Lesch, Deputy Director, Talent for Science, Engineering and Technology (SET) Careers, at the Department of Science and Technology.
Gold Medal winner was Taariq Asmal, the 2010 Deputy Head Boy of the Tshwane Muslim School. Taariq was the school's top student in Computer Applications Technology, History and Mathematics, and he is also interested in soccer and cricket. He has registered at the University of Pretoria to qualify as a Computer Engineer.
Silver Medals were won by two girls Helen Denny and Melodé Rozenkrantz thereby beating all but one of the more than 6 000 entries.
Helen is a regular Olympiad participant; having participated in the Maths Olympiad, the English Olympiad, the Bible Olympiad, the Debating Competition and a number of Eisteddfods. The academic interest is balanced by her interest in netball, tennis and swimming. Not surprisingly she is Chairperson of the Debating Society and her schools grade 11 Dux. She plans to study Law and Accounting at Stellenbosch University in 2012. Helen was only in grade 11 at La Rochelle Girls' High when she won her place in the finals.
Melodé Rozenkrantz is from Linkside High in Port Elizabeth and was the only Eastern Cape participant in the finals. Apart from doing Olympiads, she loves ballroom dancing and cricket. She is registered for a BSc Mathematics and Computer Science at Stellenbosch University.
Bronze Medals were won by Conrad Mönnig, Steven Ontong and Adriëtte le Roux.
Conrad is from Penryn College in Nelspruit and was the only finalist from Mpumalanga. Steven Ontong is from Hottentots-Holland High in Somerset West. Conrad is registered for Mechanical Engineering at Tukkies while Steven will do Electrical Engineering at Stellenbosch University.Adriëtte le Roux, who won a bronze medal, has also achieved in many other fields. She was a prefect in 2010, came 5^th in the Bilingual Olympiad and was first in the Backsberg Art Competition. Her writing has been published in "English Alive" and her artwork has been used for a calendar and an anti-drug poster. Commented judge, Doctor Pam Miller: "One could see the artistic talent. She designed by far the most original letterhead." Adriëtte started her studies for a BA degree at Stellenbosch University this month. She intends to become a teacher.
Olympiad administrator, Peter Waker, explained: "The Olympiad required much more from participants that the school subject. It gives learners an opportunity to demonstrate what they know in ways they were never taught."
To enter for the 2011 Olympiad, go to http://www.olympiad.org.za/

What school reform can learn from the rhythm method in sex

2011-02-03T15:27:00.003+02:00

Report on Jonathan Jansen on 'What school reform can learn from the rhythm method in sex' – lecture at UCT 2 February 2011

These are the main points of the lecture:

High expectations – set high expectations – not a 30% pass level!
Lucid analysis – know why the school is underperforming – have data at hand – need data to do planning – must be able to analyse it so CAT teachers can show principals how to create simple graphs and pivot tables / graphs
Clear goals – must be measurable – communicate goals – measure them regularly
Critical mass – use those teachers who want to change – get help from them for turn around strategy
Sharp strategy – know how to alter the behaviour of people in order to achieve your goals
Inspiring example – be an inspiring example – live life as a teacher
Ask – are we there yet

Recommended book 'How to change 5000 schools' by Ben Levin

Bottom line – to connect with title – do all 6 points – keep regular – Rhythm cycles of school. Teachers can take many of these points and apply them in the classroom for improvement.

Used these key concepts and spoke / told stories to enforce ideas of each point. I could not get any decent pictures of him as he never stood still long enough for me to focus and click. Brilliant speaker!

He has a wonderful memory – after the talk I went up to him to say … and he greeted me by name. I showed surprise that he knew me and he indicated that I was friends with him on Facebook. Yes I am, but he has 784 friends but he still remembered my name! I had wanted to remind the man that he hit me on the head / capped me with my PhD at the University of Pretoria years ago. He is a man to be reckoned with!

Teacher activity no 2 - Posters for managed environment

2011-01-30T16:07:00.005+02:00

Clear posters/instructions are an essential part of any managed environment. This activity will help create those posters for cleaning duties, different recycling bins, window duty, printer management, classroom rules, goals, expectations, etc.

Create a long word file in which to create all the posters
In a footer or header insert the school badge OR classroom name/teacher name in a corner, as a form of identity, to appear on all poster pages
Have one idea per poster page
Space the text so that all posters present a uniform layout with clear writing
Use a clear font such as Arial for clear readable text
Use WordArt with a clear design and no shadow, for readable text
Use text, borders, tables, SmartArt, WordArt and images to help express / present the instructions
If you use borders be sure to adjust the footer with the school badge so that it remains visible
Submit a the long file of posters as an attachment with teacher name and school to docpam@gmail.com by Friday 4 February.

Creator of first completed poster file submitted will be commended. OR send me an email indicating what of the above you are not technically able to do, and I will create a learning object to help you and others do that.

Awards for Teacher activity no 1 - Identifying Learners

2011-01-30T15:47:00.007+02:00

The awards for Activity Identifying Learners go to the teachers Barbara Anyster of Worcester Secondary School and Johan Barkhuizen of Goodwood College. Congratulations!

Bad PowerPoint

2011-01-25T23:55:00.002+02:00

I attended what should have been a riveting lecture this evening. The speaker gave a Powerpoint presentation.

He looked at the screen and not the audience.
He read all the text on the screen.
He described pictures/diagrams but they only appeared on the screen after he had finished reading the description/text.
He had a great deal of text, and not key words so the audience read all the text and listened to the speaker at the same time so nothing went into the audience's heads.

At interval a number of people indicated that they were disappointed with the speaker and wanted to leave. Others said they kept dropping off to sleep. Since the advent of TV and video we expect quality presentations and 'contact'. Lecturers must eyeball and connect with their audience.

Teacher activity no 1 - Identifying learners

2011-01-17T23:05:00.006+02:00

Knowing learners’ names is an essential tool for an effective teacher. There are many ways to learn names - this activity will help you put names to faces and to seating positions in a classroom.

Take photos of learners with a digital camera or mobile phone.
Transfer the photos to the computer using USB cable or Bluetooth.
Arrange images in suitable folders with meaningful names.
Create a seating plan of the classroom and insert the images into the places where the learners usually sit and their names, aligning the images and the text meaningfully OR insert the learner's name on each image and arrange the pictures on a page where the learners usually sit.
Submit a class seating plan as an attachment, of a grade 11 CAT class with teacher name and school to docpam@gmail.com by Friday 21 January - date extended to 28 January.

All plans will remain confidential. Creator of first completed seating plan submitted will be commended. OR send me an email indicating what of the above you are not technically able to do, and I will create a learning object to help you and others do that.

NSC exam timetable 2011

2011-01-17T08:12:00.002+02:00

Here is a copy of the exam timetable for NSC for 2011 http://www.education.gov.za/Curriculum/Exams/NSC%20Nov%202011%20Exam%20Timetable.pdf Hope this can help with planning. The CAT papers are together, nice!

Unemployment and CAT

2011-01-15T11:37:00.002+02:00

After the matric results were released this year there was much talk of how the young people will not be able to get jobs, and that matric does not prepare people for the job market. Journalists did not do their homework and they neglected to mention the value of CAT!

More than any other subject CAT prepares a candidate for life in the business world. With keyboarding skills, knowing how to use the Office package, knowing how to use hardware/software, and problem solving skills any employer would find a CAT candidate an asset to their business. We teachers must make sure that our learners really do well in CAT and help the young people to get a job. CAT may not be a 'designated' subject but it is such an important subject!

Facebook page

2011-01-13T23:22:00.001+02:00

A page has been created on Facebook for Study Opportunities. Go to the page and then click 'Like'. It is so nice to see the Profile pictures of all the people who follow the page. Look at the message for 2011.

Marking of matric exams

2010-12-26T17:28:00.003+02:00

I was involved with marking the WCED matric exam papers where many of the markers came from places as far away as Knysna, Mossel Bay and Heidelberg. The day following the marking I set off driving to Mossel Bay and as I drove the long road I wondered at people going from so far away all the way to a marking centre to mark. I salute all the markers, those from near and far!
Picture of me walking along the cliffs at Mossel Bay

Digital story of the Nativity

2010-12-22T21:19:00.001+02:00

This digital version of the Xmas story may be of interest - http://www.youtube.com/watch?v=bvM-I0j5emA
I think it is lovely! Merry Xmas!

Multiple choice questions - Solution to marking?

2010-12-12T22:52:00.007+02:00

During the course of 2010 I became very tired of marking the never ending amount to work in CAT. During the year I completed the Get Smarter Internet SuperUser course where we had multiple choice questions (MCQ) at the end of many of the modules. I wondered if those MCQ questions were an answer to the pen and paper marking!

At school during the year we did self marking MCQ questions with software from Virtual Assessor (VA) every Monday on the previous week’s work, theory and practical. Have a look at a PPT on VA presented at a conference in September. I think Evalunet and Moodle have similar self marking features to Virtual Assessor.

We learned the theory, mainly in Grades 10 and 11, and the practical in Grade 12 with regular tests.

At the end of the year I thought of using just a big MCQ test for the theory exams, and not doing the normal written paper. At the end we did both papers, a big MCQ exam using VA and the normal written exam. One exam paper marked in 1 second and the other took ages to mark. For both grades 10 and 11 the VA paper had a mark of 65% and the written 35%. I added the two percentages together and used the average for the final written exam mark. Now such a difference shows that there is a huge gap in knowing the work and applying it, and has again made me rethink the role of MCQ. Maybe I also needed to improve my questions. However doing these tests kept me focused on my teaching and the learners on learning. Here are my exams copied from VA, Grade 10 and Grade 11. (Obviously they cannot work as self marking questions as they are not in VA but have a look.) I think they are quite demanding and difficult, but both grades achieved 65%. Why the huge difference? What should be used at schools for revision tests? What should be used for high stakes exams

Browsers and the web

2010-11-20T19:22:00.001+02:00

A must-read link for all CAT teachers and their learners - "All about browsers and the web" - a Google e-book publication. http://www.20thingsilearned.com/#/home

Submitted by Charles Smith to Comp-studies list - thanks Charles

Grade 11 Theory Memo

2010-11-18T22:54:00.001+02:00

Grade 11 Theory Memo

English, Afrikaans

Great excitement

2010-11-17T22:20:00.001+02:00

I took part in my first online auction and my bid of R110 was the highest! They are tickets to attend a symphony concert valued at R330. Will be collecting goods tomorrow and off to the concert. Have a look at St Luke's Hospice Online Auctions. For a good cause. http://auction.stlukes.co.za/auction/default.asp

Gr 10 Theory Memo

2010-11-17T21:20:00.003+02:00

Grade 10 Theory Memo

English Memo, Afrikaans Memo
Errata - 6.2.4 Cell reference should be B4, not B5

Errata: Gr 11 Theory paper

2010-11-16T15:43:00.002+02:00

There are 11 pages not 12

3.10.2 Change to 'Why'.
4.5 unwanted software
5.5 Add the word 'to' before 'locate'.

Gr 11 November Theory 2010

2010-11-16T06:06:00.002+02:00

Gr 11 November Theory 2010

Questions papers - English, Afrikaans

Gr 10 November Theory Exam paper

2010-11-14T21:56:00.002+02:00

Gr 10 Paper 2 Theory November 2010

Question paper - English, Afrikaans

Emotional consequences of communication technology

2010-11-13T10:53:00.001+02:00

Technological communication has such a impact on our lives. Being on email/Facebook/chat,cell phone, etc. makes one so much more available to people, with its joys and disappointments.

I was so upset to find out this week that a friend I had made on Facebook and met in Egypt in December had died two months ago. I had not realised that he had departed as people had been tagging his photos and I thought it had been him doing the tagging. I sent him a message but he had not responded. I went to his page to check his last activity only to find condolence messages. He was gone.

This morning on chat a friend tells me her mother has just gone.

Partner has gone overseas, but obviously did not organise RoamOn with his cell phone before he went. I never thought to check. I knew he was going to use his Australian cell phone while he was there. There were no SMSs and I thought … until I realised that the silly guy had not fixed his South African cell phone.

We teach about email/Facebook/chat/cell phone technology, etc. not thinking of the emotional consequences.

Gr 11 November Practical Exam Solutions

2010-11-08T21:59:00.003+02:00

Paper 1

Gr 10 November Practical Exam Solutions

2010-11-07T19:52:00.006+02:00

Problem solving

2010-11-04T15:24:00.002+02:00

There has been a lot of talk on the Comp-Studies mailing list about including problem solving questions in the Computer Applications Technology Gr 12 national exam papers.
I believe a problem solving question is one which has features which the learners have been taught, but presented in a different way which requires thinking ‘out of the box’.
With that in mind I have been looking at the Study Opportunities papers as I have been using old papers for revision. Currently I am going over the Excel sections of old papers with my Gr 10s and 11s.
In the 2006 Gr 10 Pug paper, question 1, the learners had to sort the names in order according to surname. They needed to do a copy and paste of surnames into a new column for surnames. They could have copied and sorted each record individually but that would have taken ages. None of my Gr 10s or 11s managed to do on their own quickly.
In the 2008 Gr 10 Snakes/Crocodile paper , question 4, there was such a lovely problem solving question which none of my Gr 11s managed to do on their own. They did not realise that the value was text.
In the 2009 Gr 10 Computer Assistance paper, question 3.1, you have to find and copy the details of those doing the Web2 tools course to a word document. The learners should have done a sort, to find those people and then copied the block of records. None of my Gr 10s managed without my help.
I am doing revision now to get the learners’ minds thinking flexibly and ready for the exams. I am most distressed at how they cannot think ‘out of the box’ and solve problems. The learners know the skills but have difficulty applying them. I am not sure how common this problem is.

I am glad that the Study Opportunity papers have those problem solving features. Maybe they need more however I have only checked a small portion of the papers.