8S – Period 4: Friday 3rd July July 2, 2009
Posted by ictatshr in 8S.add a comment
Task 1 – Understanding macros
When you have been shown how to create a macro, open a new Powerpoint presentation and create your own macro.
Task 2 – Creating a flowchart
Please get into the same groups as before when you were completing your powerpoint quiz.
You have to change your quiz so that it adds up the score and displays a total at the end. Using a whiteboard in your group, try and create a flowchart which explains what happens to the score as you progress through the presentation. You will eventually use macros to change the way your presentation works.
Task 3 – Attaching macros to buttons
Once you have been shown how to attach macros to action buttons, you need to alter your presentation so it adds up the score and displays the score at the end.
Extension
Can you add a macro so that one point is taken off the score if a question is wrong. You might want to award 2 points for each correct answer.
8R – Period 3: Friday 3rd July July 2, 2009
Posted by ictatshr in 8R.add a comment
Task 1 – Understanding macros
When you have been shown how to create a macro, open a new Powerpoint presentation and create your own macro.
Task 2 – Creating a flowchart
Please get into the same groups as before when you were completing your powerpoint quiz.
You have to change your quiz so that it adds up the score and displays a total at the end. Using a whiteboard in your group, try and create a flowchart which explains what happens to the score as you progress through the presentation. You will eventually use macros to change the way your presentation works.
Task 3 – Attaching macros to buttons
Once you have been shown how to attach macros to action buttons, you need to alter your presentation so it adds up the score and displays the score at the end.
Extension
Can you add a macro so that one point is taken off the score if a question is wrong. You might want to award 2 points for each correct answer.
9Y – Period 1: Friday 3rd July July 2, 2009
Posted by ictatshr in 9Y.add a comment
Starter: BBA
Task 1 – Parameter Queries
After you have been shown how to create a parameter query, complete the Building Forms and Parameter Queries worksheet. When this is done, create the queries in your Time Machine database.
Task 2 – Reports
After you have been shown how to create a report, create reports for each of the parameter queries in your database.
9Z – Period 3: Thursday 2nd July July 2, 2009
Posted by ictatshr in 9Z.add a comment
Starter: Open any of the powerpoint quizzes in the folder Shared:\General\ICT\Year 8\Quiz Powerpoints view them as a slide show and see how you get on. (the ice age one is good)
Your task
In the groups that you are put in, you are going to create a 5 question multiple choice quiz using powerpoint. The quiz can be about a subject of your choice – a tv programme, a band, a film, a school subject, a famous person – anything that you want. Think creatively! You could have a picture question, a video clip question, a music question as well as a normal text question.
You will need to work as a team – set up a folder in general (under Shared:\General\ICT\Year 7\Quiz Powerpoints) to share files you might need. One person might need to do some research, one might need to collect images, one might working on the presentation itself.
- There must be two choices for each question
- The two choices must be buttons which the user can click on – for help on buttons grab your headphones and watch this video, now watch this one
- There needs to be a way of indicating whether an answer is right or wrong
- There needs to be a way of moving through the quiz
- There needs to be an introduction / instruction slide
- There needs to be a concluding / thank you for taking part slide
Hints and tips
As we go through the lesson I will pass on hints and tips to members of each team which they will need to feed back to the group.
7Y – Period 5: Wednesday 1st July July 1, 2009
Posted by ictatshr in 7Y.add a comment
Starter: Open any of the powerpoint quizzes in the folder Shared:\General\ICT\Year 8\Quiz Powerpoints view them as a slide show and see how you get on.
Your task
In the groups that you are put in, you are going to create a 5 question multiple choice quiz using powerpoint. The quiz can be about a subject of your choice – a tv programme, a band, a film, a school subject, a famous person – anything that you want. Think creatively! You could have a picture question, a video clip question, a music question as well as a normal text question.
You will need to work as a team – set up a folder in general (under Shared:\General\ICT\Year 7\Quiz Powerpoints) to share files you might need. One person might need to do some research, one might need to collect images, one might working on the presentation itself.
- There must be two choices for each question
- The two choices must be buttons which the user can click on – for help on buttons grab your headphones and watch this video, now watch this one
- There needs to be a way of indicating whether an answer is right or wrong
- There needs to be a way of moving through the quiz
- There needs to be an introduction / instruction slide
- There needs to be a concluding / thank you for taking part slide
Hints and tips
As we go through the lesson I will pass on hints and tips to members of each team which they will need to feed back to the group.
7W – Period 1: Thursday 2nd July June 30, 2009
Posted by ictatshr in 7W.add a comment
Starter: Who did it?
New Unit – Please create a folder called Unit 7.5 – Murder Most Horrid in your ICT folder. Now have a listen to your task below.
Task 1
So far, the police have interviewed the deputy head and headteacher. They have collected descriptions of all the teachers, and where they were at the time of the murder.
Police have had a tip off that someone with brown or black hair was seen leaving the dining hall at the time of the murder. Using the Witness Details Sheet;
- highlight all the people who have black hair
- highlight all the people who have brown hair
- Now answer the questions on the bottom of the sheet
Using the DS – see who can be first to answer the questions.
Task 2 – Creating queries in MS Access
-
Go to My Computer and then COPY the SHR Pupils 08-09 database from P:\Senior Pupils\ICT\Y07\Unit 7.5 Murder Most Horrid\Lesson_1 by right clicking and choosing copy.
-
Go to My Documents and PASTE SHR Pupils 08-09 into your Unit 7.5 – Murder Most Horrid by right clicking and choosing paste. Then open the database by double clicking and see if you can find your name…(you might have to explore and experiment)
Try to produce the following queries. Save each query as its number;
- Find all the girls in your form and sort the list by Surname (a) also show firstname
- Find all the girls in your house and sort the list by Year (a) also show firstname and surname
- Find all the girls in the school called Eleanor and sort the list by Form Group (a) and then Age (a) show all fields
- Find all the girls in your science group and sort the list by Form Group (a) and then House (a) also show surname and firstname
- Find all the girls in the school who were born before 01/01/1992 also show surname and firstname
- Find all the girls who have a surname which begins with D also show firstname and form (follow this link for help on this query – scroll down and find the Using Wildcards link)
- Further queries – can you find all the girls in your form who have a “T” in their surname, can you find all the girls in your house whose firstname ends in an “R”?
- Make up some queries of your own – what do you want to find out?
10GCSE – Period 4: Monday 29th June June 29, 2009
Posted by ictatshr in 10GCSE.add a comment
Implementation, Testing and Evaluation
3 lessons 1 homework to get as much of the above completed as possible. I will see you individually to work out where you are with your progress.
10D1 – Period 5: Friday 26th June June 25, 2009
Posted by ictatshr in 10D1.add a comment
Starter: formula lines
Task 1 – Using Word
Please open the file called Lettings Letter.doc which can be found in Pupils:\Senior Pupils\ICT\Key Skills\Key Skills Level 2
- indents
- hanging indent
- first line indent
- right, left, centre, justified
- tabs
-
columns
Task 2 – Portfolio Work
Please continue with your portfolio work – use your checklist and previous blog posts to help.
Task 3 – Databases
- search operators – >, <, =, <>, and, or, not
- sorting
- primary key
- wildcards
10GCSE – Period 4: Friday 26th June June 25, 2009
Posted by ictatshr in 10GCSE.add a comment
Starter:
Implementation
Please continue with this if you are yet to finish.
Testing
If you have finished your implementation then please concentrate on your testing. You should include in this section;
- A copy of your plan with the results of testing filled in
- Evidence of your testing in the form of screenshots which should include;
- data being input if appropriate
- query results if appropriate
- final report if appropriate
Homework
Please spend 30 minutes over the weekend tidying up or amending your design work as necessary.
9Z – Period 1: Thursday 26th June June 25, 2009
Posted by ictatshr in 9Z.add a comment
Starter: BBA
Task 1 – Parameter Queries
After you have been shown how to create a parameter query, complete the Building Forms and Parameter Queries worksheet. When this is done, create the queries in your Time Machine database.
Task 2 – Reports
After you have been shown how to create a report, create reports for each of the parameter queries in your database.
