Student-Centred+Resources

The purpose of this information is to summarise a collection of student-centred teaching resources. In an annotated bibliography format that covers the outcomes of Database Design option topic of the Information and Software Technology Year 7-10 syllabus of NSW Australia. The resource list consists of videos clips, projects tasks, Webquests, online worksheets, power-point presentations, and textbooks.

= **Annotated Bibliography** =

[]  Ben Beitler has over 17 years experience with Database Design, he is also a member of The Institute of IT Training. He put together this website to share his knowledge of database design with students. This website is a free service, acts as an online Microsoft Access database user guide contains screenshots step by step training examples for students to follow. This website will support outcome 5.2.2 Designs, produces and evaluates appropriate solutions to a range of challenging problems in the Information Software Technology year 7-10 syllabus. The two key competencies this website addresses are: 1) design, develop and present solutions to specific information technologies, developing competence in solving problems; 2) engage with a variety of software when developing competence in using technology. []  Graham Betts is an ex NSW school teacher at Kogarah High, he created this website for ICT teaching curriculum in support of public education. It has a comprehensive student-centre learning for the Database Design topic. The website covers all the key contents of Database Design topic well. Some of the outcomes it addresses are: 4.3.1 - uses ethical practices when dealing with data; 5.3.1 - justifies responsible practices and ethical use of information and software technology; 4.3.2 - describes ethical practices used when dealing with data. []  This Webquest was designed by a Graduate Dip Education (Secondary) student in Western Australia. The aim of the webquest is to teach year 9-10 students about database design using problem base learning approach of a Zoo database project to carry out by a group of students together with a 12 scaffolded lessons. The webquest covers all the key outcomes of database design topics. []  This is an online intereactive problem based learning program from NSW DET Centre of Learning Innovation which shows the planning and usage of database management system in Real Estate industry. Students are scaffolded the design process and the usage of the database including online multiple choice questions at the end of the lesson. This can be use to teach year 9 or 10 to see the relavant of database in real life. It can be use to cover outcome 5.2.3 - critically analyses decision-making processes in a range of information and software solutions. This resource can be use to cover in one or two lessons. []  ICT Goodies is a site designed by Andrew Clark a secondary high school teacher in Manchester UK. This website contains a number of starters, plenaries, and free teaching resources. Free registration is required before downloading resources. There is project to create a database solution for Mobile Phone Shop, this project is a problem based learning and student-centre learning project complet with scaffolding of how to use Microsoft Access 2007 to solve the problem. This can be use to teach year 9 or 10 as a comprehensive package, as it covers the three main outcome of the database design option topic 5.2.1, 5.2.2 and 5.2.3. []  ICT Goodies is a site designed by Andrew Clark a secondary high school teacher in Manchester UK. This website contains a number of starters, plenaries, and free teaching resources. It required free registration before downloading resources. There is lesson related to database queries search to solve a crime. This can be use for year 8 or 9 lesson on how database can be use to solve crime. Resource package included lesson, powerpoint presentation, and Microsoft Access database file. It would cover outcome 4.1.1 recognises and uses software programs that are suitable for specific task, and 5.1.1 selects and justifies the application of appropriate software programs to a range of tasks. []  The aim of this site is to offer freely available games and quizzes to help secondary school students revise their ICT work. There is section on MS Access 2007 database with a design task called "Data Trip database" that takes students from planning, developing and creating of a database. There also an assessment of understanding for each stage of the database development. This student-centre learning activities can be completed in two lessons. This can be use to teach year 9 students before assign students with the indenpendent project to cover outcomes: 5.2.1- describes and applies problem-solving processes when creating solutions; 5.2.2 - designs, produces and evaluates appropriate solutions to a range of challenging problems; 5.2.3 - critically analyses decision-making processes in a range of information and software solutions. []  This website is developed by Richard Holoczak for Baruch College City University of New York. The intended audience are students with no experience of database to learn basics of Microsoft Access using a business example, by creating tables, adding data, creating queries, creating forms, and running reports to display. This resourse will cover outcomes 5.2.1 - describes and applies problem-solving process when creating solution, and 5.2.2 - design, produce and evaluate appropriate solutions to a range of challenging problems.

<span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; text-indent: -36.0pt;">[] <span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; text-indent: -36.0pt;"> This 17 minutes video clip is produced by the data protection commisioner of Ireland. It shows how a company uses data in the way that compromises the breach of data privacy act. This video can be use to teach students about core topics issues and people related database privacy and security management. This video can be used to provoke discussions on data security and information privacy law. Students can critically discuss how to use data responsibly. This video may used to cover outcome 5.3.1 - Student justifies reponsible practice and ethical use of information and software technology, and 5.5.3 - Student describes and compares key roles and responsibilities of people in the field of information and software technology. <span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-indent: -36.0pt;"> <span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; text-indent: -36.0pt;"> Zoho challenge is an online program that allows teachers to create quizzes for students. This can be used to create Database design questions in an form of assessment of understanding. Teachers can monitor students answers. A resource was created specifically for database design option topic for year 7-10 to ensure students understand the contents of the topic. <span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; text-indent: -36.0pt;">[] <span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; text-indent: -36.0pt;"> Lesson Plans for many computer applications, in particular databases. This is a worksheet related to data collection to create video database project. This can be use in a lesson to teach year 7-8 in relation to core topic data handling. <span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-indent: -36.0pt;">Thavaratnam, I. (2004). //Information & Communication Technology Year 7-10 Computing skills assessment competencies - Lesson & Activities//. Sydney: Sorubi Educational Resources. <span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-indent: -36.0pt;"> This book is a cross curriculua collections of computer lessons and activities targeted specifically at students 7-10 NSW schools. This book covers the core competencies for computer skills assessments. Specifically, Lesson 11 - Creating a database, it can be use as a activity to cover core competency of demonstrating basic database skills to create, work with and modify files. <span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; text-indent: -36.0pt;"> <span style="line-height: normal; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; text-indent: -36.0pt;">This textbook can be used as a way to deliver contents on database topics for IST year 7-10. Outcomes covers are 5.2.1 - describe and apply problem-solving processes when creating solutions; 5.2.2 - design, produce and evaluate appropriate solutions to a range of challenging problems; 5.2.3 - critically analyse decision-making processes in a range of information and software solutions; 5.3.2 - acquire and manipulate data and information in an ethical manner; 5.5.1 - apply collaborative work practices to complete tasks.