Identified curriculum Constructed using the identified curriculum from the Constructed using the Technology Essential Learnings by the end of identified curriculum Year 9 from the Year 10 Guidelines: Technology Problem The school needs to The school production The school production identification send personalised involves a complex and requires a quick and invitations to a school varied number of tasks efficient ticketing production to a number and people. The school system. of guests. Students needs a database of need to identify a quick tasks and allocated and efficient way of roles. achieving this outcome. Design Solution Students are to develop Students are to work Students are to design specification a simple database for with existing information and develop an personalised invitations to form a basic database information system for to a school function. of the school drama ticketing sales for production tasks and the each performance of person/s responsible for the school production. each task. Implementation Brainstorm and order Use SQL to input the different the main areas of data and build the and testing types of work involved in the database. information administration of a Import and export systems. school drama information into production. the database. how Analyse the Manipulate data different information, by adding, deleting information processes and and modifying systems can outcomes involved in information. be used to solving this problem. Format and print organise Use appropriate reports of the information. flowcharting software information for to represent this relevant process. the stakeholders. information for Create a basic Create and run the database. database of the basic and simple school drama queries on the production tasks and on elements database. the person/s Develop of information, Develop a form to responsible for each. e.g. fields and display relevant data type. Add, modify and information. delete information in that database. a table to organise the Format and print an gathered existing report on the information. database. and create a mail Merge data with a form letter to be sent to invited participants.
Identified curriculum Constructed using the identified curriculum from the Technology Essential Learnings by the end of Year 9 Constructed using the identified curriculum from the Year 10 Guidelines: Technology Design Problem identification The school needs to send personalised invitations to a school production to a number of guests. Students need to identify a quick and efficient way of achieving this outcome. The school production involves a complex and varied number of tasks and people. The school needs a database of tasks and allocated roles. The school production requires a quick and efficient ticketing system. Solution specification Students are to develop a simple database for personalised invitations to a school function. Students are to work with existing information to form a basic database of the school drama production tasks and the person/s responsible for each task. Students are to design and develop an information system for ticketing sales for each performance of the school production. Develop Implementation and testing the different types of information systems. how different information systems can be used to organise information. the information for the database. on elements of information, e.g. fields and data type. a table to organise the gathered information. and create a mail Merge data with a form letter to be sent to invited participants. Brainstorm and order the main areas of work involved in the administration of a school drama production. Analyse the information, processes and outcomes involved in solving this problem. Use appropriate flowcharting software to represent this process. Create a basic database of the school drama production tasks and the person/s responsible for each. Add, modify and delete information in that database. Format and print an existing report on the database. Use SQL to input data and build the database. Import and export information into the database. Manipulate data by adding, deleting and modifying information. Format and print reports of the information for relevant stakeholders. Create and run basic and simple queries on the database. Develop a form to display relevant information.