Teacher Guidance
Contents
1. What is a database What are tables records and fields Creating a Database ow dol create a new database file ow dol create a table ow do l insert a record 3 Creating Queries ow dol do simple queries ow do do multiple queries ow do use the wildcard h ow dol use the form wizard h ow do use the report wizard Select the correct data type Activity 3 Designing queries Pai nt Tutorial Paint e What is Paint 3 U 5 C 4 Object Manipulation ow dol save a file ow dol make a new file ow do open an existing file 2 Using the Drawing Tools ow do draw with a pencil ow do draw with a brush ow do use the spray tool ow do draw shapes ow do draw lines ow do change colours sing Colours ow do use the fill tool ow do use the colour picker ow do use the eraser ow do create a custom colour ow do flip and rotate objects ow do stretch and skew objects ut Copy Paste and Zoom How do use the cutting tool 3es multimedia 2003 3E s Enterprises Trading Limited e How do use the zoom tool How do copy and paste objects 6 Paint Activities Activity 1 Identify the tools Activity 2 Insert the missing words e Activity 3 Icon match up Presentation Tutorial Presentation What is Presentation Different uses of Presentation How do save my slideshow How do open an2. it is possible to gain a considerable amount of evidence for these qualifications A further two projects have been written and are included in this document in order to offer a total solution for Main Key Skills level 2 The Key Skills Units Communication This key skill is about speaking listening reading and writing Q 1a Contribute to a discussion about a straightforward subject Make dear and relevant contribution in a way that suits your purpose and situation Listen and respond appropriately to what others say and Help to move the discussion forward Q 1b Give a short talk about a straightforward subject using an image Speak clearly in a way that suits your subject purpose and situation Keep to the subject and structure your talk to help listeners follow what you are saying and Use an image to clearly illustrate your main points 2 2 Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Read and summarise information from TWO extended documents about a straightforward subject One ofthe documents should include at least ONE image Select and read relevant material dentify accurately the lines of reasoning and main points from text and images and Summarise the information to suit your purpose Q 3 Write TWO different types of documents about straightforward subjects One piece of writing should be an extende
3. appropriate style of writing for a presentation Ensured text is legible and free of spelling and grammar mistakes d Ensured the content of their presentation is accurate thorough and interesting YES O noO C23 Comments Questions to ask Feedback Teacher Signature Flecirom teacher documentsleglobs pdf Tae ted 29 30 Key Skills Project 2 Endangered Species Awareness Scenario You work for an organisation called ESA Endangered Species Aware ness Your work involves working in the local community and local Schools to bring awareness of endangered species and to arrange fun draising in order to support organisations that attempt to monitor and control environments and animals under threat Endangered species are species that are under threat because of a variety of factors including destruction of habitat overexploitation pollution disease and the introduction of exotic species Examples of endangered species include the Fruit Bat the Monarch Butterfly Jaguars Dingoes Lemurs Asian Elephants and Lowland Gorillas Endangered species exist all over the world and although there are specific measures being carried out to help them the universal problem cannot be solved until humans learn to protect all natural environments Task 1 Using a range of information sources at least one extended document research TWO endangered species of your choice Write a report which includes details about their na
4. evaluation a brief discussion of how you have used ICT in this project and suggestions for future improvements To achieve a level 6 you must complete all criteria for level 4 AND 5 AND Ll Provide a crossword that is well presented and suited to the audience To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND D Combine text and graphics from various sources to improve the presentation Ll Discuss the quality of your work and make suggestions for future improvements in detail O Have included the entire project checklist detailed above Handed in on time YESO NOU Merit Awarded YESO NOO 40 50 60 70 K 3IC File cdrom teacher documents prdassessfb pdf 2003 3E5 Enterprises Trading Limited 3es multimedia 2003 3E s Enterprises Trading Limited Project 6 Battleships Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Battleships game Macrocode Report on gaming models and simulations User guide Evaluation and recommendations Who did what OOoOOo0oo0o00 NC Levels To achieve a level 4 you must O Have the Battleships game template L1 Have good quality Battleships layout that is suited to the audience D Provide a brief evaluation comparing the manual method of Battleships To achieve a level 5 you must complete all criteria for level 4 AND Provide brief evidence of macrocode for short cut keys Complete a well presented p
5. existing slideshow How do make a new slideshow Creating a Slideshow Selecting a slide layout e Changing the background design 3 Using Text How do l insert text e How do move text e How do format text e How do I use bullet points How do use numbering 4 Using Images How dol insert an image How do I draw images How do flip and rotate images 5 Slideshow Animations e How do I use slide transitions e How do use custom animations e How do I play my slideshow 6 Presentation Activities Activity 1 Create a slide Activity 2 Create a slideshow Activity 3 Icon match up k e D NO Internet Tutorial 1 The Internet e What is the Internet 2 Using the Internet What is the World Wide Web t is on the toolbar t is a search engine How do search the Internet e What is Email 3 Internet Activities e Activity 1 True or false e Activity 2 Internet hangman Activity 3 Icon match up co h co W W h co Help Section EE Help on Using this Package Getting started The home page he projects area The tutorials area The teacher guidance area Tips on using the package Teacher Guidance Section 1 About this Package 2 National Curriculum Levels 3 Guidance on Individual Projects 4 Mapping Grid 5 Assessment Feedback 6 Assessment Tracking Grid 7 Assessment Tracking Grid User Guideli
6. from their bedrooms and create scaled drawings in some form of CAD package Students could be made aware of the growing technological break throughs occurring in terms of blue chip technology when considering their bedroom of the future A Tomorrow s World programme may be a good discussion point for this task which was included to enable stu dents to explore what happens in real and imaginary situations Suggestions for other subject involvement Design Technology design of bedroom furniture Maths creation of scaled drawings Project 4 Planning a Party Essentially a spreadsheet exercise this project will require students to go through the entire process of organising a costing plan for a party Formulas are required within the spreadsheet to enable the amend ments to be made and provide correct and up to date answers Once the spreadsheet is created the price for the tickets will need to be put onto he invitations created in task 2 As evidence for their folders students should be encouraged to provide hard copy evidence of their formulas as well as their final spreadsheets and also to record any amendments made to the original table identi fying the effects this has made on the overall totals A classroom discussion of the advantages and disadvantages of spread sheets and their use inside and outside a school setting would be benefi Gal before task 4 is attempted Extra tasks have been prov
7. the projects in the KS3 ICT package This simple tracking grid works out accurately the levels achieved for each programme of study providing a grade for each project and mapping this level to a summary grid for each student An understanding of the method of assessment designed for this package is required before attempting to get to grips with the spread sheet template The National Curriculum for ICT is organised into four programmes of study Finding Things Out Developing Ideas and Making Things Happen Exchanging and Sharing Information Reviewing Modifying and Evaluating Work as it Progresses Setting Up the Tracking Grid When the spreadsheet is opened you will be asked whether to enable or disable the macros You will see a dialog box similar to the one on the right Select Enable Macros The templates are designed to include thirty five students to a class Ifyou are running this package for more than one class it is impor tant to make the appropriate number of copies of this template in a suitable area on your system One template is required per class The National Curriculum also provides a description of the knowledge and skills required for each level from 1 to 7 These descriptions have been sorted into the relevant programme of study For a list of the programmes of study and the levels within each see the NC Levels doc document The 15 projects within this package incorporate a range of these level
8. 3es m u Iti med la 3es multimedia Key Stage 3 Gu 5 Teacher Guidance 3es multimedia Key Stage 3 ICT Software Package d Teacher Guidance Contents 1 Aboutthis Package 2 2 National Curriculum Levels 3 3 Guidance on Individual Projects 5 4 Mapping Grid 9 5 Assessment Feedback 10 6 Assessment Tracking User Guide 23 7 AMain Key Skills Solution 27 8 Suggested Schemes of Work 32 9 Package Contents 35 i This KS3 ICT Package contains Macromedia Flash Player software by Birmingham B37 6NZ Booklet Revision 1 0 July 2003 FLASH Macromedia Inc Copyright 1995 1999 Macromedia Inc All rights 3es multimedia Copyright 2003 3E s Enterprises Trading Limited ENABLED reserved Macromedia and Flash are trademarks of Macromedia Inc Published by 3E s Multimedia Cooks Lane Kingshurst E Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited 1 About this Package About the KS3 ICT Software Package The Key Stage 3 ICT package has been designed in order to create a teachers guide to delivering ICT to the National Curriculum It is by no means a teacher replacement The teachers and students will benefit from working through projects with supporting tutorials that have been specifically designed to encourage students to aim for higher levels in the ICT National Curriculum The first stage of the design of this package wa
9. Project Information sources Task 3 Perform an Interview 35 Task 4 Perform your Presentation Print Task Sheet Project 11 Hazards of Smoking Task 1 Research Information sources Task 2 Create a Poster Poster design board Task 3 Create a Leaflet Task 4 ICT Report Print Task Sheet co v c Project 12 Planning a School Trip Task 1 Pick a Trip School trip budget plan example Task 2 Spreadsheet Changes Task 3 Information Letter Task 4 Trip Information Task 5 Trip Management System Print Task Sheet Project 13 Kingshurst Travel 2 Task 1 Create a Database Kingshurst travel holidays information Task 2 Database Changes Task 3 Create Queries Task 4 Forms and Reports Task 5 Perform your Presentation Print Task Sheet co o to oo t Project 14 Car Park Design Task 1 Design a Data Collection Form Task 2 Design a Questionnaire Task 3 Collecting Data Car park builder Task 4 ICT Report Print Task Sheet cC C5 c co Project 15 Art Gallery Task 1 Security Guides Circuit designer Task 2 Gallery Alarm Task 3 ICT Report Print Task Sheet Tutorial Breakdown Word Tutorial m Word Processing Whatis a word processor e How dol print and save a document Inserting and Editing Text How dol use bold How do use italics How dol use underline How dol change fonts sizes and colours e How do
10. Project Software Applications Additional Resources 1 Modelling 2 3 4 5 6 H 8 Half Term 9 Planning a Party 1 Excel Word Party invitations 10 Planning a Party 2 11 Planning a Party 3 12 Planning a Party 4 13 Planning a Party 5 14 Planning a Party 6 15 Planning a Party 7 16 Planning a Party 8 17 Christmas Holiday 18 Christmas Holiday 19 My Bedroom 1 Paint Word or PowerPoint CAD package if Graph paper magazines suitable TV 20 My Bedroom 2 available programmes 21 My Bedroom 3 22 My Bedroom 4 23 My Bedroom 5 24 My Bedroom 6 25 Half Term 26 Kingshurst Travel 2 Database 1 Access Word PowerPoint Internet Travel brochures 27 Kingshurst Travel 2 Database 2 28 Kingshurst Travel 2 Database 3 29 Kingshurst Travel 2 Database 4 30 Kingshurst Travel 2 Database 5 31 Kingshurst Travel 2 Database 6 32 Kingshurst Travel 2 Database 7 33 Easter Holiday 34 Easter Holiday 35 Modelling 36 37 38 39 Half Term 40 Battleships 1 Excel Word Example games Connect 4 0s and X5 41 Battleships 2 Battleships 42 Battleships 3 43 Battleships 4 44 Battleships 5 45 Battleships 6 46 Battleships 7 3es multimedia 2003 3E s Enterprises Trading Limited 9 Package Contents Overview Projects ject 1 Teen Magazine ject 2 Cartoon Competition Project 3 My Bedroom Project 4 Planning a Party Project 5 ICT Crossword P
11. Spreadsheet Changes Task 4 ICT Report Task 5 User Manual Print Task Sheet co co co vv Cc Project 5 ICT Crossword Task 1 Get your Words Information sources Task 2 Design your Crossword Pele s crossword Task 3 Relevant Graphics Task 4 The Answer Task 5 Comparing Crosswords Print Task Sheet co co co co Project 6 Battleships Task 1 Create a Battleships Game Battleships tutorial Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Step by step guide to setting up the battleships model Task 2 Games in Society Information sources Task 3 Evaluate your Project Task 4 Design a Game Task 5 Test the Game Print Task Sheet Project 7 Kingshurst Travel Task 1 Spreadsheet Design Resort information Task 2 Spreadsheet Changes Task 3 Spreadsheet Analysis Task 4 Create a Graph Task 5 User Manual Task 6 ICT Report Print Task Sheet Project 8 My Class Task 1 Data Collection Task 2 Create a Database Task 3 Using Queries Task 4 Create Reports Task 5 Design a Form Task 6 ICT Report Print Task Sheet Project 9 Kingshurst Estates Task 1 Create a Database Houses for sale Task 2 Customer Queries Task 3 Design a Form Task 4 Manager s Report Task 5 ICT Report Print Task Sheet Project 10 ICT in Society Task 1 Brainstorm Supermarkets Task 2 Research your
12. WN A O OCON CAUAU d WN A 6 WQ co d G Ud WN Ae G d h W AWUN d CO Project Introduction to the IT department Introduction to the KS3 ICT package Teen Magazine 1 Teen Magazine 2 Teen Magazine 3 Teen Magazine 4 Teen Magazine 5 Half Term Cartoon Competition 1 Cartoon Competition 2 Cartoon Competition 3 Cartoon Competition 4 Cartoon Competition 5 6 U 8 Ud nd Eun ES Cartoon Competition 6 Cartoon Competition 7 Cartoon Competition 8 Christmas Holiday Christmas Holiday Modelling Half Term My Class 1 My Class 2 My Class 3 My Class 4 My Class 5 My Class 6 My Class 7 Easter Holiday Easter Holiday ICT Crossword 1 ICT Crossword 2 ICT Crossword 3 ICT Crossword 4 Half Term Modelling spreadsheet SS Ss SS Software Applications Word Internet Encarta Additional Resources Additional information sources example magazines Paint PowerPoint Internet Clip Art Encarta Digital cameras scanners for photos or Word Access Internet Encarta Excel or Word pictures Example data collection forms weighing scales meter sticks for measurements Information sources example crosswords 3es multimedia 2003 3E s Enterprises Trading Limited Year 8 Suggested Scheme of Work Week No Project 1 ICT in Society 1 2 ICT in Society 2 3 ICT in Society 3 4 ICT in Society 4 5 ICT in Society 5 6 ICT in Society 6 7 ICT in Societ
13. ages of spreadsheets Who did what D D D D D D 000 NC Levels To achieve a level 4 you must D Have created an appropriate spreadsheet O Have incorporated accurate formulas Ll Have made amendments to the spreadsheet to change the results To achieve a level 5 you must complete all criteria for level 4 AND D Have created an appropriate graph from the data D Show the formulas that have been used to create the spreadsheet To achieve a level 6 you must complete all criteria for level 4 AND 5 AND D Complete a well presented project including a front cover and contents page O Discuss the wider implications of ICT in society To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND O Discuss the quality of your work and make suggestions for future improvements O Have included the entire project checklist detailed above Handed in on time YESO NO Merit Awarded YESO NOO Comment File cdrom teacher documents pr7assessfb pdf 2003 3E5 Enterprises Trading Limited O Provide instructions for other users to be able to use your spreadsheet potential level 8 Level Achieved 40 50 60 70 KS3 ICT 3es multimedia 2003 3E Enterprises Trading Limited Project 8 My Class Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Data collection Database table Evidence of 8 queries Database reports Form for new class member Report on d
14. atabases in society Who did what OOOO0o0000 NC Levels To achieve a level 4 you must Ll Have created an appropriate database table O Present work to a good quality that is suited to the audience To achieve a level 5 you must complete all criteria for level 4 AND O Have created appropriate forms for the database O Have created appropriate reports from the database O Show evidence of queries you have used in the database To achieve a level 6 you must complete all criteria for level 4 AND 5 AND D Complete a well presented project including a front cover and contents page Ll Discuss the wider implications of ICT in society To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND Ll Discuss the quality of your work and make suggestions for future improvements O Provide detailed evaluation including discussion on the benefits and limitations of using ICT in this project O Have included the entire project checklist detailed above Handed in on time YESO NOU Comment Merit Awarded YESO NOO 40 50 60 70 L LC e D d Jes multimedia File cdrom teacher documents pr8assessfb pdf KS 2003 3E5 Enterprises Trading Limited Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited 17 Project 9 Kingshurst Estates Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Database of
15. ation of reports Presentation Who did what DGT E m00 P H Lg NC Levels To achieve a level 4 you must D Have created an appropriate database table D Have made amendments to the database Ll Present work to a good quality that is suited to the audience To achieve a level 5 you must complete all criteria for level 4 AND D Have created appropriate forms for the database O Have created appropriate reports from the database O Show evidence of queries you have used in the database To achieve a level 6 you must complete all criteria for level 4 AND 5 AND O Complete a well presented project including a front cover and contents page Ll Discuss the wider implications of ICT in society To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND Ll Discuss the quality of your work and make suggestions for future improvements O Provide a high quality presentation describing the use of your database and ensure it is suitable for the audience potential level 8 O Have included the entire project checklist detailed above Handed in on time YESO NOU Merit Awarded YESO NO D Level Achieved 40 50 60 70 KS3 ICT File cdrom teacher documents pr13assessfb pdf 2003 3E Enterprises Trading Limited 3es multimedia 2003 3E Enterprises Trading Limited Project 14 Car Park Design Assessment Feedback Student Name Tutor Group Checklist Front page Content
16. d document and indude at least ONE image Present relevant information in an appropriate form Usea structure and style of writing to suit your purpose and Ensure text is legible and that spelling punctuation and grammar are accurate so your meaning is clear Application of Number This key skill is about interpreting information to do with numbers doing calculations and presenting your findings N2 1 Interpret information from TWO different sources including material containing a graph Choose how to obtain the information needed to meet the purpose of your activity Obtain the relevant information and Select appropriate methods to get the results you need N2 2 Carry out calculations to do with a amounts and sizes b scales and proportion c handling statistics d using formulae Carry out calculations dearly showing your methods and levels of accuracy and e Check your methods to identify and correct any errors and make sure your results make sense N2 3 Interpret the results of your calculations and present your findings You must use at least ONE graph ONE chart and ONE diagram 27 Select effective ways to present your findings Present your findings clearly and describe your methods and Explain how the results of your calculations meet the purpose of your activity Information Technology This key skill is about using a computer to find explore develop and present infor
17. d styles required for each There are some examples within the package To achieve higher levels students could complete task 5 which is to create a system for another user along with the user and technical documentation The setting could be for another class or even another school organising a trip The requirements would be the same but every consideration when organising a trip would need to be included on the costing template Suggestions for other subject involvement Business creating formulas and graphical representations of data History narrowing the focus of the trip to be organised e g a tour of historical places in the local town information documentation about these places that will be required for the trip etc Project 13 Kingshurst Travel 2 This project explores the use of a database in travel agents It provides data that requires a system in order to navigate and manipulate the data in order to achieve the project requirements Guidance for how to imple ment this system is given in the database tutorial For the creation of the forms and reports students need to think about what kind of informa tion would be suitable and relevant in these two different formats Students would benefit from a class discussion on how databases are used in society To achieve the higher levels for reviewing modifying and evaluating work as it progresses extra guidance would be required f
18. e as well As with the majority of the projects in this pack with teacher guidance the report can be modified to enable students to achieve higher levels in the review and modify programme of study This project attempts to get students thinking about the morals of the information superhighway in Subjects such as smoking and drug abuse This could make an interesting debate Suggestions for other subject involvement PSE encourages discussion on legal and illegal substance abuse Science medical statistics effects of smoking on the lungs etc Project 12 Planning a School Trip This project gives ownership to the students from the outset by getting them to design a system to create a costing sheet for a school trip of their choice All students may choose a different trip with different costing information and considerations All formulas required in the spreadsheet are demonstrated in the spreadsheet tutorial Encourage students to use formulas throughout their design to ensure that any amendments will be recalculated in the totals This can be evidenced with a hard copy of the formula view Students could be asked to predict the outcomes of certain changes before making the alterations to the worksheet This project also explores some of the different forms of communication via documentation letters memos and emails in particular Students would benefit from a discussion of the different layouts an
19. ed the entire project checklist detailed above Handed in on time YESO NO Merit Awarded YESO NOO Comment File cdrom teacher documents prassessfb pdf 2003 3E5 Enterprises Trading Limited Level Achieved 40 50 60 7E KS3 ICT 3es multimedia 2003 3E s Enterprises Trading Limited D T D 0 O Li DU S S M IN IN IN Handed in on time YESO NOI Project 2 Cartoon Competition Assessment Feedback Student Name Checklist Front page Contents page Character created in Paint Cartoon slideshow Own character Clipart Internet images Use of drawing tools Custom animations 15 30 slides Report on the use of ICT within project Evaluation and recommendations Who did what O O O O O O NC Levels To achieve a level 4 you must Tutor Group Have included bitmap and vector images in your cartoon Produce cartoon of good quality that is suited to the audience Provide brief evaluation on the use of ICT in this project To achieve a level 5 you must complete all criteria for level 4 AND Present your cartoon to the rest of the class Complete a well presented project including a front cover and contents page Include in your evaluation a discussion of how you have used ICT in this project and make suggestions for future improvements Comment File cdrom teacher documents pr2assessfb pdf 2003 3E5 Enterprises Trading Limited To achie
20. ety Interview questions and analysis of answers Presentation slide show O Accompanying notes O Hand out materials Who did what OOoOoaoo NC Levels To achieve a level 4 you must O Have used information from a variety of sources D Use well structured interview questions D Prepare and deliver your presentation To achieve a level 5 you must complete all criteria for level 4 AND Ll Prepare a presentation well suited to the audience To achieve a level 6 you must complete all criteria for level 4 AND 5 AND Ll Discuss the wider implications of ICT in society To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND O Combine information from different sources within your presentation O Have included the entire project checklist detailed above Handed in on time YESO NOU Merit Awarded YESO NOO 40 50 60 70 KSI File cdrom teacher documents pr1Oassessfb pdf 2003 3E5 Enterprises Trading Limited Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Project 11 Hazards of Smoking Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Evidence of different information sources used Doctors surgery poster Doctors surgery leaflet O Statistics O Medical information O Trends Smoking report Who did what NC Levels To achieve a level 4 you must O Have selected reliable in
21. for level 4 AND D Show the formulas that have been used to create the spreadsheet To achieve a level 6 you must complete all criteria for level 4 AND 5 AND O Present the project with a front page and contents O Discuss the wider implications of ICT in society To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND Ll Discuss the quality of your work and make suggestions for future improvements O Provide a detailed report for the Governors O Have included the entire project checklist detailed above Handed in on time YESO NOO Merit Awarded YESO NOO 40 S 60 70 L cu m P 3es multimedia File cdrom teacher documents pr4assessfb pdf KS 2003 3E5 Enterprises Trading Limited Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited 13 Project 5 ICT Crossword Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Crossword O Atleast 20 clues O Graphics Crossword answers Completed friend s crossword Who did what NC Levels To achieve a level 4 you must D Have an accurate crossword grid D Usea range of sources to gather relevant words O Provide a brief evaluation of your own or your friend s crossword To achieve a level 5 you must complete all criteria for level 4 AND D Complete a well presented project including a front cover and contents page D Include in your
22. formation sources for your project O Produce a poster of good quality that is suited to the audience O Produce a leaflet of good quality that is suited to the audience To achieve a level 5 you must complete all criteria for level 4 AND O Complete a well presented project including a front cover and contents page To achieve a level 6 you must complete all criteria for level 4 AND 5 AND O Complete a detailed report discussing the issues of smoking Ll Discuss the wider implications of ICT in society To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND Ll Discuss the quality of your work and make suggestions for future improvements O Have included the entire project checklist detailed above Handed in on time YESO NOO Merit Awarded YESO NOO 40 50 60 7L P Jes multimedia File cdrom teacher documents pr1 lassessfb pdf 2003 3E5 Enterprises Trading Limited 3es multimedia 2003 3E s Enterprises Trading Limited Project 12 Planning a School Trip Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Spreadsheet showing considerations and costings for the proposed trip Evidence of amendments to spreadsheet Formula view of spreadsheet Letter to parents Memo to tutors Evidence of email to rest of class optional Trip Management System optional Who did what D D D D DJ D D D D D NC Levels To achieve a level 4
23. ganise and present their work They use sequences of instructions to control devices and achieve specific outcomes They make appropriate choices when using ICT based models or simulations to help them find things out and solve problems Level 4 Pupils add to amend and combine different forms of information from a variety of sources They use ICT systems to control events in a predeter mined manner and to sense physical data They use ICT based models and simulations to explore patterns and relationships and make predic tions about the consequences of their decisions Level 5 Pupils create sequences of instructions to control events and understand the need to be precise when framing and sequencing instructions They understand how ICT devices with sensors can be used to monitor and measure external events They explore the effects of changing the vari ables in an ICT based model Level 6 Pupils develop try out and refine sequences of instructions to monitor measure and control events and show efficiency in framing these instructions They use ICT based models to make predictions and vary the rules within the models Level 7 Pupils use ICT to measure record and analyse physical variables and con trol events They design ICT based models and procedures with variables to meet particular needs They select and use information systems suited to their work in a variety of contexts translating enquiries expressed in ordinary langua
24. ge into the form required by the system Level 8 They design successful ways to collect and prepare information for processing When developing systems that respond to events they make appropriate use of feedback Exchanging and Sharing Information Level 1 Pupils use ICT to work with text images and sound to help them share their ideas Level 2 Pupils use ICT to help them generate amend and record their work and share their ideas in different forms including text tables images and sound Level 3 Pupils share and exchange their ideas with others Level 4 They use ICT to present information in different forms and show they are aware of the intended audience and the need for quality in their presen tations They exchange information and ideas with others in a variety of ways including using e mail Level 5 Pupils use ICT to structure refine and present information in different forms and styles for specific purposes and audiences They exchange information and ideas with others in a variety of ways including using e mail Level 6 Pupils present their ideas in a variety of ways and show a dear sense of audience Where necessary they use complex lines of enquiry to test hypotheses Level 7 Level 8 Pupils design and implement systems for others to use Reviewing Modifying and Evaluating Work as it Progresses Level 1 They talk about their use of ICT Level 2 They talk about their experiences of ICT bot
25. h inside and outside school Level 3 Pupils describe their use of ICT and its use outside school Level 4 Pupils compare their use of ICT with other methods and with its use outside school Level 5 Pupils discuss their knowledge and experience of using ICT and their observations of its use outside school They assess the use of ICT in their work and are able to reflect critically in order to make improvements in Subsequent work Level 6 Pupils assess the validity of these models by comparing their behaviour with information from other sources They discuss the impact of ICT on Society Level 7 Pupils identify the advantages and limitations of different information handling applications They consider the benefits and limitations of ICT tools and information sources and of the results they produce and they use these results to inform future judgements about the quality of their work They take part in informed discussions about the use of ICT and its impact on society Level 8 Pupils take part in informed discussions about the social economic ethical and moral issues raised by ICT Exceptional Performance Pupils suggest refinements to existing systems and design imple ment and document systems for others to use predicting some of the consequences that could arise from the use of such systems When discussing their own and others use of ICT they use their knowledge and experience of information systems to inform the
26. have used ICT in this project and make suggestions for future improvements To achieve a level 6 you must complete all criteria for level 4 AND 5 AND Provide a detailed evaluation discussing your use of ICT and a comparison of bitmap and vector images To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND O Include a discussion on the benefits and limitations of the graphics packages you have used O Discuss the quality of your work and suggest future improvements O Have included the entire project checklist detailed above Handed in on time YESO NOO Merit Awarded YESO NOO Level Achieved 40 Comment x 60 70 A 3es multimedia File cdrom teacher documents pr3assessfb pdf KS3 l 2003 3E5 Enterprises Trading Limited 12 3es multimedia 2003 3E s Enterprises Trading Limited Project 4 Planning a Party Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Party invites at least 4 to a page Party budget sheet Party budget sheet with formulas Amended party budget sheet Governors report Who did what LH B S E P D T a NC Levels To achieve a level 4 you must O Have created appropriate invites that are suited to the audience O Have created an appropriate spreadsheet O Have incorporated accurate formulas D Have made amendments to the spreadsheet to change the results To achieve a level 5 you must complete all criteria
27. houses on the market Database queries Database forms Database reports Advantages and disadvantages of databases Who did what P D DD D 0 C NC Levels To achieve a level 4 you must O Have a database containing house details O Provide a brief discussion on the advantages and disadvantages of using databases and their use in society To achieve a level 5 you must complete all criteria for level 4 AND O Provide well designed forms O Provide well designed reports To achieve a level 6 you must complete all criteria for level 4 AND 5 AND O Perform hypothesis testing and provide well presented query reports O Provide a detailed evaluation discussing the advantages and disadvantages To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND O Explain queries and how they have been designed O Provide detailed evaluation including a discussion on the benefits and limitations of using ICT in this project O Have included the entire project checklist detailed above Handed in on time YESO NOU Merit Awarded YESO NOO 40 50 60 7L F Jes multimedia File cdrom teacher documents pr9assessfb pdf 2003 3E5 Enterprises Trading Limited 3es multimedia 2003 3E s Enterprises Trading Limited Project 10 ICT in Society Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Brainstorm Research materials from one area in soci
28. ided with this project to enable higher levels to be achieved if this is felt appropriate The students have essentially cre ated a system that could be used by others and if documented accord ingly could enable the achievement of level 8 This may need more tailored guidance by the teacher to fit the situation accordingly Suggestions for other subject involvement Business creating costing plans and budgets for an event Maths hypothesis testing and predictions with model data Project 5 ICT Crossword This activity is the perfect opportunity to discuss common ICT terms and check knowledge and understanding of the subject Whether the emphasis is placed on the research or the practical work for this project students will hopefully be learning some new computing terms broad ening their command of the language Provide some reading material for example computer magazines and reference books to encourage researching with methods other than the Internet This may lead to interesting discussions on current affairs in the industry and enable higher levels to be considered for reviewing modifying and evaluating work as it progresses This project does not specify the software application to be used and can be completed equally as well in Word Excel or PowerPoint The focus can also be changed to map any subject area of the timetable For example terminology in mathematics characters from the plays of Shake
29. iptors have been outlined in the relevant programme of study on the third worksheet for your information Not all levels are applicable for each project For further information on the ICT National Curriculum www nationalcurriculum org uk 3es multimedia 2003 3E Enterprises Trading Limited 7 A Main Key Skills Solution A Main Key Skills Solution The Key Skills Qualification levels 1 4 recognises the achievement of all three main key skills units of communication application of number and information technology The QCA Key Skills units were revised in 2000 encouraging candidates to signpost all key skills which are now simpler easier to understand and more manageable The new speci fications are addressed to the candidates and the amount of portfolio evidence required is considerably reduced In order for a qualification to be achieved candidates must pass both an internal assessment and an external assessment which is set and marked externally for each of the units The internal assessment is based on a portfolio collected from day to day work studies and other activities The projects written for the KS3 ICT package not only encourage students to demonstrate levels of attainment matched to the National Curriculum they also develop a number of the skills required for communication IT and application of number for Key Skills level 2 Although not a complete solution with clear signposting and documentation
30. ir views on the social economic political legal ethical and moral issues raised by ICT 3es multimedia 2003 3E s Enterprises Trading Limited 3 Guidance on Individual Projects Guidance for Teachers Project 1 Teen Magazine Students will be demonstrating their research skills in this particular project There is online assistance with the different information sources they could use but they may benefit from a brief discussion on the layout of magazines and addressing their material to the appropriate audience As with any research project students would benefit from a discussion on how to assess the validity of the material The effects of information being inaccurate or out of date can be easily demonstrated with a discussion of the paparazzi and news stories that have hit the press the ntegrity of which is doubtful The remainder of the project is practical and can be completed with the assistance of the Word tutorial A class discussion would be useful for udents to get ideas for the report in task 3 ca Suggestions for other subject involvement English newsletter fact file on famous writer etc History newspaper articles of specific dates in history fact file on famous person from history Project 2 Cartoon Competition This project is very practical in nature and will require students to be able to import images from various applications They will need to know how to use the
31. l cut and paste text Inserting and Editing Images e How do l insert an image How dol copy and paste an image How do l use the draw tools Presenting Information e How dol create tables How dol insert columns in a table e How do l insert rows e How do l insert columns on a page Word Activities e Activity Cri na table Editing tex Activity 2 Inserting a picture Activity 3 Create a newspaper article Activity 4 Icon match up Spreadsheet Tutorial 1 Spreadsheets e What is a spreadsheet e What can make How do format text and cells How dol print and save my spreadsheet How to Use Simple Formula How dol add up How do l subtract e How do multiply How do l divide How to Use Functions e How dol perform averages How do count lists of numbers How do count lists of text Howdol find the highest number How do count the number of instances e How do I sort my cells How to Create Graphs How dol create graphs and use the graph wizard 5 Spreadsheet Activities ctivity 1 Insert the missing words ctivity 2 Match the function ctivity 3 Change the formulas ctivity 4 Icon match up Database Tutorial etii M2 6 Database Activities Activity Activity 2 Adding records 4 Creating Forms 5 Creating Reports Databases
32. lay area for the young gorillas to play in Your drawings must be to scale to ensure that the design will fit comfortably in the enclosure Using either graph paper or a computer aided design package produce a scaled drawing of the enclosure including a covered area which may comprise of raised platforms for the gorillas to nest in and play areas with your designs created in task 4b N2 2 a and b Rz a 3es multimedia 2003 3E s Enterprises Trading Limited Key Skills Tracking Grid KS3 ICT Projects Key Skills Level 2 Projects fe eee lt 2 5 3 3 lt PHS GC Z GC G LS LS LS LS z 2 2 2 2 2 E E 1 Teen Magazine e o 0 O 2 Cartoon Competition o o 3 My Bedroom 0 4 Planning a Party 06 00 5 ICT Crossword o O 00 6 Battleships 00 7 Kingshurst Travel 60 6090 8 MyClass o0 e o0 9 Kingshurst Estates o0 L2 o 10 KTinSodety 00 O 11 Hazards of Smoking o 0 ee 12 Planning a School Trip e o0 00 13 Kingshurst Travel 2 9 e 14 CarPark Design o e 1 15 Art Gallery KSP1 The Book Club o 00 0 eo KSP2 Endangered Species o e o O Q task number within project covering key skill Key Stage 3 ICT Software Package Teacher Guidance 31 2003 3E5 Enterprises Trading Limited 32 8 Suggested Schemes of Work Suggested Schemes of Work for Key Stage 3 Year 7 Suggested Scheme of Work Week No woe On AU PWN A A PPP PP d Ww w U U U W U U U Ww N N N N N N MN MN NN s a e aeee Aunt
33. mation including text numbers and images IT2 1 Search for and select information for TWO different purposes dentify the information you need and suitable sources Carry out effective searches and Select information that is relevant to your purpose IT2 2 Explore and develop information and derive new information for TWO different purposes Enter and bring together information using formats that help development Explore information as needed for your purpose and Develop information and derive new information as appropriate IT2 3 Present combined information for TWO different purposes Your work must include at least ONE example of text ONE example of images and 0 E example of numbers Select and use appropriate layouts for presenting combined information in a consistent way Develop the presentation to suit your purpose and the types of information and Ensure your work is accurate clear and saved appropriately Key Skills Level 2 Tracking Grid Student Name Tutor Group Key Skills Achieved insert page number where evidence can be found Date Q 1a 2 1b Q2 Q3 N21 Project Completed N2 2 Teachers N23 112 1 IT22 IT2 3 Signature Comment 3es multimedia 2003 3E Enterprises Trading Limited Key Skills Project 1 The Book Club Scenario You are a member of a local book dub
34. multimedia 2003 3E s Enterprises Trading Limited can be collected during lesson time and involves all students talking to one another in order to collect enough information for their database The project takes them through the simple processes of queries reports and forms quidance for this is given in the database tutorial As with the majority of the projects within this course the written report can be added to and amended in order that students can achieve higher levels for the evaluation programme of study This is a gentle introduction into a database application and requires some discussion as to the purpose and uses of such an application in a School environment and the wider society Discuss where the students personal details may already be kept in a database application for example a library sports club school etc If this is the first database project to be completed then it would be advisable to go through common terminology used in database management systems although this is apparent in the tutorial as well Suggestions for other subject involvement PSE a getting to know your class exercise at the beginning of year 7 Maths working with heights weights and measurements Project 9 Kingshurst Estates This project explores the use of a database in estate agents Students are required to extract the relevant data from houses for sale information in order to create the
35. nes 8 A Key Skills Solution 9 Suggested Schemes of Work 10 Package Contents 11 Complete Booklet Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited 37
36. nts analysing statistical data in tables and charts Design Technology creation of the car park model to scale Project 15 Art Gallery A challenging project the art gallery allows students to explore the finer detail of computer technology by looking at how circuits and logic gates work The project includes a thorough demonstration of the workings of circuit diagrams and explanations on the workings of different sensors encouraging students to experiment with circuit design within a suitable and interesting scenario The project looks at how devices respond to certain events and feedback from the systems Level 8 can be achieved in the developing ideas pro gramme of study as students will be developing systems that respond to events and they can make appropriate use of the feedback generated from the circuits designed and controlled by the students Suggestions for other subject involvement Design Technology creation of the alarm systems using sensors and circuits Science understanding sensors logic gates and circuit design 3es multimedia 2003 3E Enterprises Trading Limited 4 Mapping Gri Programme of Study sassaiboJq 31 se yom Burjenjen3 pue buifyipoy buimainay uoneunojuj Buueus pue Guibuey gt x uaddey suy Buey pue seap Guidojanag ano shuryy urpu N N MaIpp uy uisa eg Je Z ove Jsinysbuly duj jooups e buruueld Dupjouis Jo sprezey Kapo
37. or the presentation Students could be encouraged to discuss the effects of using databases on the wider society and discussing ethical issues including the Data Protection Act and the moral economic and legal issues involved in database management systems Suggestions for other subject involvement Geography could include geographical information in the database for the countries Project 14 Car Park Design The first of two projects based on modelling this project encourages students to go out and measure an area in order to bring the information back to the computer for processing The project includes an excellent simulation program that enables students to enter their measurements and model their new design of the car park There is even a car that can be controlled with the arrow keys to see if the design is a feasible solu tion A lot of evidence can be collected in this project for finding information as a questionnaire is required Discussion on questionnaire design and other fact finding techniques would be beneficial A look at how data is analysed once collected in this fashion and how spreadsheets can be g e used to provide useful statistics is necessary This is a fun way of lookin at simulation and modelling and could help achieve high levels in th developing ideas and making things happen programme of study Suggestions for other subject involvement Maths collecting measureme
38. picture formatting toolbox to be able to make their imported image from paint transparent Students may choose other characters or images for their cartoon from the Internet and will need to know how to copy and paste These skills are all demonstrated on the online tutorials A This project is a good basis for a discussion of vector and bitmap images the difference between the two and the benefits and limitations of working with these different forms of graphics For further evidence of exchanging and sharing information students could display their cartoons to the rest of the class This works well in a competition setting where the other students award points in terms of the comedy element the complexity of the main characters design the story line etc Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Suggestions for other subject involvement Art computer generated cartoon character English depict a modern day version of an act from Shakespeare or a novel Project 3 My Bedroom This project is to gain an understanding of the different types of graphics available and leads nicely into a discussion on vector and bitmap images and the benefits and limitations of each This could also be an assess ment in terms of modelling and computer aided design particularly if you have a design package available Students could be asked to take measurements
39. progress These simple spreadsheets record the different levels available for each programme of study for each project These levels are averaged to calculate an overall attainment level As students complete projects and levels are awarded an overall attainment level is being generated on the final summary sheet This simple method of awarding level indicators will make students aware of the assessment procedure and will encourage them to aim towards higher attainment levels The package includes full information for teachers offering sugges tions for schemes of work guidance on how other subject areas could incorporate projects into schemes of work details of how level indica tors have been sorted into programmes of study grids to show which projects include which levels the assessment tracking grid and its user guide This teacher aid will improve the attainment levels of ICT students at Key Stage 3 and will change for the better the way ICT is taught in the classroom 3es multimedia 2003 3E s Enterprises Trading Limited 2 National Curriculum Levels National Curriculum Levels Sorted into Programme of Study Areas Knowledge Skills and Understanding Finding Things Out Level 1 Pupils explore information from various sources showing they know that information exists in different forms Level 2 Pupils use ICT to organise and dassify information and to present their findings They enter save and retrieve
40. qual dis tribution of the workload They need to be aware of the many different information sources available to them and be able to validate any infor mation to ensure that it is accurate and up to date Students will require guidance on interview techniques and assistance with the questions and analysis of the data Guidance on the use of PowerPoint is given in the online tutorial It would be beneficial for the students to see a demonstration of a slideshow to see the styles acceptable in this nature Encourage students to use bullet points to highlight the main objectives of each slide and discuss the issues rather than reading from the screen or notes The group may wish to create and issue hand out material to support their presentation Suggestions for other subject involvement History could be based on a historical view point could change the focus entirely and ask for the interview to take place with a grandparent to find out about how the way they live has changed etc Project 11 Hazards of Smoking A research project encouraging students to use their research skills to collect and validate data and create documents to display this informa tion appropriate to an audience If possible contact the local surgery and ask if they are interested in any display material This project links well with PSE material and may be an opportunity to work on the research of this project in that lesson tim
41. r this is given in the Excel tutorial Students must be encouraged to incorporate formulas wherever possible so that changing variables requires little modification to the structure of the table It is important that hard copy evidence of the original table and the formulas used is provided to demonstrate these skills Also any changes made to the spreadsheet can be highlighted Students shou also provide comments as to how the amendments have altered result to demonstrate understanding of the system they have created ex A When creating graphical representations of data emphasis must be placed on what type of graph is used to give an appropriate and accurate reading of the data The Excel wizard is a tool that students must explore and use to complete a graph to a high standard of presentation Additional tasks have been included for students who could achieve higher levels Guidance on the instruction document and report should be provided in order to achieve higher levels for reviewing modifying and evaluating work as it progresses Suggestions for other subject involvement Maths spreadsheet formulas and graphical representations of data Geography could include geographical information in the model for the countries Project 8 My Class This project requires students to design a data collection form in order to collect information for a system they will go on to create The data 3es
42. roject including a front cover and contents page Include in your evaluation a discussion of how you have used ICT in this project and make suggestions for future improvements To achieve a level 6 you must complete all criteria for level 4 AND 5 AND O Provide a detailed evaluation discussing your use of more complex spreadsheet functions O Produce a well presented Battleships game suited to the audience To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND Provide detailed evidence of macrocode and describe how macros have been used in this project Discuss the quality of your work and make suggestions for future improvements Produce a gaming model for others potential level 8 Have included the entire project checklist detailed above Handed in on time YESO NOU Merit Awarded YESO NOO Comment Level Achieved 40 50 60 70 KS3ICT File cdrom teacher documents pr assessfb pdf 2003 3E5 Enterprises Trading Limited Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Project 7 Kingshurst Travel Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Hard copy of spreadsheet Changes to spreadsheet Hard copy evidence of formulas Appropriate graph O Title O Labelled axis O Legend if necessary Instruction document for the spreadsheet Report on advantages and disadvant
43. roject 6 Battleships Project 7 Kingshurst Travel Project 8 My Class Project 9 Kingshurst Estates Project 10 ICT in Society Project 11 Hazards of Smoking Project 12 Planning a School Trip Project 13 Kingshurst Travel 2 Project 14 Car Park Design Project 15 Art Gallery N Tutorials Word Tutorial Spreadsheet Tutorial Database Tutorial Paint Tutorial Presentation Tutorial Internet Tutorial Help Section Teacher Guidance Section Credits Project Breakdown Project 1 Teen Magazine Task 1 Research your Pop Star Information sources Task 2 Prepare your Fact File Pop star fact file template Pop star fact file example Task 3 ICT Report rint Task Sheet T Project 2 Cartoon Competition Task 1 Character Design Task 2 Slideshow Design Pinny the ballerina Task 3 ICT Report Task 4 Class Competition e Observation sheet Task 5 Methods and Improvements Print Task Sheet v Cc co Cc co Project 3 My Bedroom Task 1 Bird s Eye View Bird s eye view of a bedroom Task 2 Drawing with Detail tems in my bedroom Task 3 Benefits and Limitations Task 4 Future Bedroom Futuristic items in my bedroom Print Task Sheet Project 4 Planning a Party Task 1 Spreadsheet Design Party budget plan example Task 2 Make your Invitation Ticket example Task 3
44. s The Mapping Grid xls document shows which levels are achievable in each project The Tracking Grid The spreadsheet template comprises the following three worksheets Project Assessment Grids e Summary of Assessment POS Microsoft Excel teacher documents Assessment Tracking Grid xls contains macros Macros may contain viruses It is always safe to disable macros but if the macros are legitimate you might lose some functionality A Enable Macros More Info Enter the names of your class onto the Summary of Assessment These names will automatically be copied onto the Project Assess ment Grids for each project A B ce DLE LF Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited PoE olen ein en en en 9 S SUMMARY OF ASSESSMENT 26 Recording Levels on the Tracking Grid Fach project table on the Project Assessment Grid has been designed to show the levels achievable for each programme of study for each project in drop down boxes POS Level Entry Please select the appropriate level mts In the example above Amada Allen has achieved a level 4 for the Teen Magazine project This score is copied to the Summary of Assessment SUMMARY OF ASSESSMENT O 1 SUMMARY OF ASSESSMENT As students complete projects and are awarded levels the Summary of Assessment will provide an overall achievement level for each student POS The level descr
45. s page Data collection form Questionnaire Draft measurements of present car park Report O Statistical analysis O Design plans Who did what OOoOoogo NC Levels To achieve a level 4 you must Ll Provide a well designed data collection form O Provide a well designed questionnaire O Provide a design for the new car park To achieve a level 5 you must complete all criteria for level 4 AND O Provide drafts which show different car park models D Complete a well presented project including a front cover and contents page D Include in your evaluation a discussion of how you have used ICT in this project To achieve a level 6 you must complete all criteria for level 4 AND 5 AND Ll Discuss the use of ICT outside school in computer aided design To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND Ll Discuss the quality of your work and make suggestions for future improvements O Have included the entire project checklist detailed above Handed in on time YESO NOU Merit Awarded YESO NOO 40 50 60 70 LJ Jes multimedia File cdrom teacher documents pr14assessfb pdf 62003 3E5 Enterprises Trading Limited Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited 24 Project 15 Art Gallery Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Explaining circuit diagrams De
46. s to consider the pro grammes of study and identify the sentences from the level descriptors which best fit each programme Once this was decided 15 projects were written to incorporate every level for every programme of study Map ping grids provided with the package identify the levels that each project incorporates The second stage of the design was to consider how ICT is delivered in Key Stage 3 classrooms Many teachers may choose to teach the soft ware applications discretely and provide tasks or projects as a form of assessment of the students knowledge of the application Other teachers prefer to teach project based introducing applications as and when it becomes necessary within the scenario The KS3 ICT package caters for both of these approaches as teachers have a choice of 15 projects and 6 software tutorials The tutorials are stand alone and provide an interactive approach to learning the basics of each piece of software The projects indude links to the relevant parts of the tutorials to assist as work progresses Whichever the method of delivery it is hoped that students would get much enjoyment out of this hands on approach to ICT lessons and that all levels of ability are catered for h The third consideration in the design was the method of assessment The assessment grids offered in the package are fully explained and offer an accurate and timesaving way of assessing recording and tracking students
47. s ut 191 5338153 1sinusfuny ssep AW Janell ysinysbuly sdiysajneg pIOMSSOI 5 yieg e Duruueld woolpag W uonnaduJo uooye auizebey uaa R pefoig SL vl el u 0L ON 191014 Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited 10 5 Assessment Feedback Project 1 Teen Magazine Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Draft copy of article Final copy of article including Headers and footers D Bur Columns Text Graphics Charts Bullet points or numbering O Report on the use of ICT within project O Who did what G O O O O O NC Levels To achieve a level 4 you must O Have selected reliable information sources for the project O Produce a draft copy of newsletter O Produce newsletter of good quality that is suited to the audience To achieve a level 5 you must complete all criteria for level 4 AND O Complete a well presented project including a front cover and contents page D Discuss in your report the use of ICT in this project and it s use outside of school To achieve a level 6 you must complete all criteria for level 4 AND 5 AND D Discuss the wider implications of ICT in society To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND O Discuss the quality of your work and make suggestions for future improvements O Have includ
48. signing circuits Report on sensors and logic gates Evaluation and recommendations Who did what 0 EI EH 00a G NC Levels To achieve a level 4 you must D Demonstrate an understanding of sensors and logic circuits O Successfully create at least one logic circuit To achieve a level 5 you must complete all criteria for level 4 AND O Explain circuit diagrams to a high level of understanding O Complete a well presented project including a front cover and contents page D Include in your evaluation a discussion of how you have used ICT in this project To achieve a level 6 you must complete all criteria for level 4 AND 5 AND D Design your own circuits to a high level of understanding To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND Ll Discuss the quality of your work and make suggestions for future improvements O Produce your own circuits suited for the purpose potential level 8 O Have included the entire project checklist detailed above Handed in on time YESO NO D Merit Awarded YESO NOO 40 50 60 70 d j uu E K3 IcT File cdrom teacher documents pr15assessfb pdf 2003 3E s Enterprises Trading Limited 3es multimedia 2003 3E s Enterprises Trading Limited 6 Assessment Tracking Grid User Guide Assessment Tracking Grid User Guidelines Introduction The spreadsheet template for assessment has been designed to calculate and store grades achieved for
49. speare etc Suggestions for other subject involvement English crossword of spellings and meanings Music crossword of musical instruments and other terminology Project 6 Battleships One of the more challenging projects this project looks at the other use of the spreadsheet away from financial modelling and requires an under standing of automated procedures namely macros The project explores more complicated spreadsheet activities and demonstrates how these tools can be used in a simulation Depending on the circumstances it may be easier to demonstrate the setting up of the game allowing students to observe and write notes before attempting the challenge for themselves For those students who have managed this activity well there are fur ther exercises available that will enable them to achieve higher levels and exceptional levels if they choose to create a game of their own and provide thorough documentation It would be beneficial for the students to see the macrocode generated but they are not required to write their own at this stage The code while in edit mode can be copied and pasted into a Word document as hard copy evidence of their efforts Suggestions for other subject involvement Maths could incorporate complex formulas for the games Project 7 Kingshurst Travel The students are required to create a spreadsheet solution with the given information The guidance fo
50. table for the database Guidance on how to imple ment this system is given in the database tutorial Extra discussion is necessary in order that students understand the different fields required in the table design Students will be querying their database once the design is finalised For the creation of the forms and reports students need to think about what kind of information would be suitable and relevant in these two different formats Ss Students would benefit from a class discussion on how databases are used in society To achieve the higher levels for reviewing modifying and evaluating work as it progresses extra guidance would be required for the presentation Students could be encouraged to discuss the effects of using databases on the wider society and discussing ethical issues including the Data Protection Act and the moral economic and legal issues involved in database management systems Suggestions for other subject involvement Maths and Business handling data and creating a business model Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Project 10 ICT in Society This project is an opportunity for the class to discuss their understanding of the term ICT and their experiences inside and outside of a school environment The activities work well with small groups of students delegating tasks and organising themselves in order to have e
51. th his her audience Spoken clearly in a way that suits the subject purpose and situation d Kept to the structure and the subject of the talk C2 1b Comments Flecirom teacher docunentsspl bs pdf anr tete ag net Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Task 3 Using the research material gathered in task 1 create your slideshow presentation of approximately 10 slides Include relevant text graphical images and tables and charts if appropriate It is important that your Slides do not contain too much information and are used as a guide for the discussion You will need to consider slide transitions custom animations and timings for the delivery of the presentation Your presentation may include the following sub titles a About the author b Information about books novels and movies if applicable c Asummary of the book d A bibliography showing where you found your research information 112 3 Task 4 Find an appreciative audience and deliver your presentation Remember not to read from your slides this is just a guide You will be filling in the information in the delivery of your speech PowerPoint has a facility to write extra notes next to each slide This may be useful preparation Good Luck 2 1b 2 2 112 3 Presentation Content Has the student vs O noO vs O noO vs D noO a Presented relevant information in an appropriate form b Used an
52. that meets up once a month to discuss authors and novels short stories you have researched and read You have volunteered to deliver a presentation to the rest of the group on a book you have read recently and its author You may choose to base this project on a book you have recently read for your English classes Task 1 Decide which book and author you would like to discuss to present to the rest of the book club your class Using a variety of sources of informa tion make sure you have read the book short story for a start collect research material for your project 12 1 Task 2 Write a summary of the main points from the short story Include a discussion of central themes for example power struggle jealousy or revenge etc Discuss the characters are they stereotypical or are they surprising What point or message is the author trying to put across to the reader Ensure that your summary identifies the genre Q2 Key Skills Project The Book Club Observation Sheet Task 4 Student Name Tutor Group Presentation Design Has the student used ICT to create their presentation Has the student used the following in their presentation design a Adequate amount of text b Appropriate graphics images Charts or tables d Appropriate use of colour e Animation f Sound 172 3 Presentation Technique Has the student a Presented the information rather than read to the audience b Made good eye contact wi
53. tural habitat characteristics and reasons for their decline in numbers 2 2172 Task 2 Choose ONE of your endangered species and prepare an information pack that could be distributed to local schools and colleges to bring awareness to the threats these species face and what steps can be taken by the community to offer assistance You may include documents such as leaflets posters information resources i e a list of website addresses that provide further information etc IT2 1 112 2 172 3 Task 3 With the other endangered species chosen for task 1 provide a statistical analysis that highlights the rapid decline in their numbers You must provide in this document at least ONE chart ONE graph and ONE dia gram N2 1 N23 Task 4 A local zoo has requested your help in designing a new enclosure for a young gorilla family which consists of two adult gorillas and their two offspring The space available in the zoo is a rectangle of 20m by 16m A quarter of this area must be covered in foliage to offer protection and food and resemble in some way their natural habitat The enclosure must have a height of at least 7m You will need to design a playing area for the playful baby gorillas and allow enough space for exercise co Firstly you must research the types of foliage which would be most suitable for this enclosure and would be safe for the gorillas Using either graph paper or a computer aided design package design a p
54. ve a level 6 you must complete all criteria for level 4 AND 5 AND O Provide a detailed evaluation discussing the use of ICT outside school To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND O Provide a tie break report discussing the benefits and limitations of the ICT tools used O Have included the entire project checklist detailed above Merit Awarded YESO NOO Level Achieved 40 50 60 70 ROT Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited 11 LH DE P E D D D P o S S D S IN S Project 3 My Bedroom Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Draft drawings and measurements of bedroom layout Task 1 Bird s eye view vector graphics Task 2 Two items in more detail bitmap graphics Task 3 Evaluation including comparison of drawing tools Task 4 Bedroom item of the future Who did what NC Levels To achieve a level 4 you must Have bitmap AND vector drawings Provide a presentation of good quality that is suited to the audience Provide a brief comparison of drawing packages and tools To achieve a level 5 you must complete all criteria for level 4 AND Have included draft drawings of your bedroom with measurements Complete a well presented project including a front cover and contents page Include in your evaluation a discussion of how you
55. work Level 3 Pupils use ICT to save information and to find and use appropriate stored information following straightforward lines of enquiry Level 4 Pupils understand the need for care in framing questions when col lecting finding and interrogating information They interpret their find ings question plausibility and recognise that poor quality information leads to unreliable results Level 5 Pupils select the information they need for different purposes check its accuracy and organise it in a form suitable for processing Level 6 Pupils develop and refine their work to enhance its quality using infor mation from a range of sources Level 7 Pupils combine information from a variety of ICT based and other Sources for presentation to different audiences Level 8 Pupils independently select appropriate information sources and ICT tools for specific tasks taking into account ease of use and suitability Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Developing Ideas and Making Things Happen Level 1 Pupils recognise that many everyday devices respond to signals and instructions They make choices when using such devices to produce different outcomes Level 2 Pupils plan and give instructions to make things happen and describe the effects They use ICT to explore what happens in real and imaginary situations Level 3 Pupils use ICT to generate develop or
56. y 7 8 Half Term 9 Estate Agents 1 10 Estate Agents 2 11 Estate Agents 3 12 Estate Agents 4 13 Estate Agents 5 14 Estate Agents 6 15 Estate Agents 7 16 Estate Agents 8 17 Christmas Holiday 18 Christmas Holiday 19 Hazards of Smoking 1 20 Hazards of Smoking 2 21 Hazards of Smoking 3 22 Hazards of Smoking 4 23 Hazards of Smoking 5 24 Hazards of Smoking 6 25 Half Term 26 Planning a School Trip 1 27 Planning a School Trip 2 28 Planning a School Trip 3 29 Planning a School Trip 4 30 Planning a School Trip 5 31 Planning a School Trip 6 32 Planning a School Trip 7 33 Easter Holiday 34 Easter Holiday 35 Modelling 36 37 38 39 Half Term 40 Kingshurst Travel Spreadsheet 1 41 Kingshurst Travel Spreadsheet 2 42 Kingshurst Travel Spreadsheet 3 43 Kingshurst Travel Spreadsheet 4 44 Kingshurst Travel Spreadsheet 5 45 Kingshurst Travel Spreadsheet 6 46 Kingshurst Travel Spreadsheet 7 Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Software Applications Internet PowerPoint Access Word Internet Internet Word or PowerPoint Excel PowerPoint Word Excel Word Internet Additional Resources Information sources magazine newspaper articles Property guides Leaflets from Doctors Information on visits and trips Travel brochures 33 Year 9 Suggested Scheme of Work Week No
57. you must D Have created appropriate letters and memos that are suited to the audience D Have created an appropriate spreadsheet O Have incorporated accurate formulas Ll Have made amendments to the spreadsheet to change the results To achieve a level 5 you must complete all criteria for level 4 AND D Show the formulas that have been used to create the spreadsheet To achieve a level 6 you must complete all criteria for level 4 AND 5 AND D Complete a well presented project including a front cover and contents page Discuss the wider implications of ICT in society To achieve a level 7 you must complete all criteria for level 4 AND 5 AND 6 AND O Discuss the quality of your work and make suggestions for future improvements O Have included the entire project checklist detailed above complete options in check list for a potential level 8 Handed in on time YESO NOI Merit Awarded YESO NO D Level Achieved 40 Comment x 60 70 wil Jes multimedia File cdrom teacher documents pr1 2assessfb pdf KS3 I 2003 3E5 Enterprises Trading Limited Key Stage 3 ICT Software Package Teacher Guidance 2003 3E5 Enterprises Trading Limited Project 13 Kingshurst Travel 2 Assessment Feedback Student Name Tutor Group Checklist Front page Contents page Hard copy of table Changes to table structure Hard copy evidence of queries Two forms O Explanation of forms Two reports O Explan
Download Pdf Manuals
Related Search