Current Tutorials
Microsoft
  Access 2007
  Access 2003
  Access 97
  Excel 2007
  Excel 2008
  Excel 2003/2004
  PowerPoint 2007
  PowerPoint 2008
  PowerPoint 2003
  PowerPoint 2004
  Word 2007
  Word 2003
Word 2004
  Photoshop CS3
  Photoshop CS3 Applications
  Photoshop Elements 6
  Photoshop Elements 3
  Flash CS3
  Flash 8
  Flash MX 2004
  Flash MX
  DreamWeaver CS3
DreamWeaver 8
  DreamWeaver MX 2004
  DreamWeaver MX
  DreamWeaver 4.0
  InDesign CS3
  InDesign CS
PageMaker 7.0
  PIT 1 Teacher Support Files
  Sample IT Projects
  Kahootz 3
  Kahootz 2
  FileMaker Pro 8
  FileMaker Pro 7
  FileMaker Pro 6.0
  iMovie HD 5.0
  iPhoto 5.0
  VectorWorks 9.0


 

Sample IT Projects


Prices

Within Australia
Outside Australia
$77 inc. GST
US$65/£35/Ca$70

 

Summary of the Projects

All the data required to complete the projects is provided, The same organisation type has been used in several projects. This allows students to do several projects on that organisation type. For example, a student could create a web site for real estate agency, followed by publishing materials to advertise their properties and a database to manage the properties.

Chapter 1: Word Processing

Instructions to plan and complete word-processed documents are provided.

Project 1: Film or TV Show Review. Year 7 or 8 task. Students select a movie or TV show, brain-storm the topic, plan their solution and use Microsoft Word to produce the solution which should include sub-headings, bullets and/or tables.

Project 2: Family Tree. Year 7 or 8 task. Students use Microsoft Word's Drawing Tools to create their family tree for the last three generations. Photos of family members can be included.

Project 3: Safety in the Science Room. Year 7 or 8 task. Students use Microsoft Word's Drawing Tools to create a poster highlighting the school rules for working in a Science lab.

Project 4: HomeHelpers. Year 8 or 9 task. Students are provided with information about a home help company and they are required to produce a 2-page document displaying that information so that it can be used to advertise the company.

Project 5: Survey. Year 8 or 9 task. Students are required to design and create a survey form, use the form to collect some data and display the results in a table and chart.

Project 6: Resume and Job Application. Year 9 or 10 task. Students produce a personal resume followed by a job application letter for a part-time job at a supermarket.

Project 7: Jenson Real Estate. Year 9 or 10 task. Students produce an advertising flyer displaying available properties for a real estate company and an explanatory letter which is mail-merged to customers. Mailing labels of customer addresses are also required.

 

Back to IT Projects | Top | Next


Chapter 2: Spreadsheets

Instructions to plan and complete spreadsheets are provided.

Project 1: Calculations. Year 7 or 8 task. Calculations on the cost of holidays offered by a travel agent are completed and charts created to display the results.

Project 2: Payroll. Year 8 or 9 task. A simple payroll is created using calculations for Gross Pay, Tax, Superannuation and Net Pay.

Project 3: Charts. Year 8 or 9 task. A series of charts need to be created to show how successful a motor show has been.

Project 4: Sales Invoice System. Year 10 or 11 task. Students create a sales invoice for an electronics company and link the invoice to a stock list using lookup commands and IF statements.

Project 5: Payroll/Payslip task. Year 10, 11 or 12 task. A detailed payroll is required which is then linked to create individual pay slips for employees of a car service company.

Project 6: Budget Management System. Year 11 or 12 task. Students set up budget worksheets for 3 faculties of a school and link them to a worksheet that monitors the spending of each faculty so that monthly reports can be produced for the School Council.

Project 7: Ordering System. Year 11 or 12 task. Students set up an ordering system for a company that sells computer software. It involves creating a sales invoice and linking it to a stock list.

 


Chapter 3: Database Projects

Instructions to plan and complete databases are provided.

Project 1: Student Survey. Year 7 or 8 task. Students collect data from other students on selected topics, enter that data into a database and produce reports to show the results of the survey.

Project 2: Software Library. Year 8 or 9 task. A database is required to record some of the software that a school has purchased and to arrange the database so that the whole school community can access the information.

Project 3: Andersons Real Estate. Year 9 or 10 task. A database is required to manage the rental properties for a real estate agency.

Project 4: Job Search Personnel Management Group. Year 10, 11 or 12 task. A database is required to record the client details for a company that finds employment for clients. The data is then used to match clients to available jobs.

Project 5: Silicon Hi-Fi. Year 10, 11 or 12 task. A database is required to produce a sales invoicing system that imports data from related customer and product tables (or files).

 


Chapter 4: Web Page Authoring Projects

Instructions to plan and complete web pages are provided.

Project 1: Harrison Autos. Year 10, 11 or 12 task. A web site for a used car sales company is required. This includes pages for different car types (small, family and sports) and an order form to arrange a test drive of a car.

Project 2: The Australian Society of Architects. Year 10, 11 or 12 task. A web site to inform practicing architects of developments in their field is required. This includes pages advertising up coming events, new developments and an online membership form.

Project 3: Quantum Electronics. Year 10, 11 or 12 task. A web site for a stereo product manufacturer is required. This includes pages displaying a product list, new releases and an order form for dealers to order products online.

Project 4: Horizon Publishing. Year 10, 11 or 12 task. A web site for a publishing company that publishes school texts is required. This includes pages displaying new releases, current titles and an order form so that schools can order books online.

Project 5: Stewarts Real Estate. Year 10, 11 or 12 task. A web site for a real estate agency is required. This includes pages displaying new releases, current properties and an order form so that customers can book property inspections online.

 


Chapter 5: Publishing Projects

Instructions to plan and complete publications are provided.

Project 1: Home Bodies. Year 9 or 10 task. A publication that can be letter-box dropped is required for a company that provides handyman services.

Project 2: The Society of Architects. Year 10, 11 or 12 task. A group of practicing architects require their monthly newsletter designed and produced.

Project 3: Sunset Publishing. Year 10, 11 or 12 task. A publishing company that publishes school texts requires a more professional way if informing schools about the books it publishes.

Project 4: Antonio's Ristorante. Year 11 or 12 task. An Italian restaurant requires a publication that can more effectively advertise itself to the local community.

 

Back to IT Projects | Top | Previous | Next


Chapter 6: Flash Projects

Instructions to plan and complete animations are provided.

Project 1: Animations. Year 9 or 10 task. Students choice a topic from a provided list and produce animation scenes on that topic.

Project 2: iTravel. Year 9, 10 or 11 task. A travel agency requires the opening page of their web site designed. It needs to include buttons and at least 2 animations.

Project 3: MusicWyse. Year 10, 11 or 12 task. A music store needs to improve the appearance of its web site. Buttons and at least 2 animations are required.

Project 4: Simmo's Used Cars. Year 11 or 12 task. A used car dealer needs a web site developed that will attract customers to his business. 4 pages are required showing company details and the different types of cars that are sold (small, family and sports).

 

Back to IT Projects | Top | Previous | Next


Chapter 7: Photoshop Projects

Instructions to plan and complete designs are provided.

Project 1: Poster. Year 7, 8 or 9 task. Students choice a topic from a provided list and produce a poster to advertise that topic. Possible topics are provided.

Project 2: VicSports. Year 9, 10 or 11 task. Three documents are required for VicSports, a government body set up to encourage students to participate in sport. They need an opening page for their web site, a photo collage poster that highlights the sports that could be played and a figure or mannequin that can model different sports apparel.

Project 3: CD Cover. Year 10, 11 or 12 task. A folk group Fairport Convention needs a cover got their latest CD, The Streets of London, designed and produced.

Project 4: Magazine Cover. Year 11 or 12 task. The cover for the school's magazine or yearbook (or magazine of the student's choice) needs to be designed and produced.

 

Back to IT Projects | Top | Previous | Next


Chapter 8: Kahootz Projects

Instructions to plan and complete Xpressions are provided.

Project 1: Where Animals Live. Year 6 or 7 task. A series of scenes based on the different places that animals are found needs to be created. The animals should be animated.

Project 2: My Diet. Year 7 or 8 task. Students split the foods they eat into different groups and create scenes on each group. The foods should be animated and the scenes linked.

Project 3: Scary Stories. Year 7 or 8 task. Student create linked scenes to tell a scary story with animations. Possible story themes are provided.

Project 4: Book Review - Holes. Year 8 or 9 task. A series of scenes to review the book, Holes, are needed during or after that book has been studied in English. A different book can be substituted if Holes is not part of the English curriculum.

 

Back to IT Projects | Top | Previous | Next



Chapter 9: Movie Production Project

Instructions to plan and complete the movie are provided.

Year 8, 9 or 10 task. Students choice a topic from a provided list and produce a movie on that topic. A variety of functions need to be applied to the movie, for example, transitions between movie clips, titles, slow or fast motion effects, etc.

 


Chapter 10: Computer Aided Design Projects

Instructions to plan and complete designs are provided.

Project 1: LaZer Design. Year 10, 11 or 12 task. A house plan is needed that can be used by both the builder and a client.

Project 2: Technology High School. Year 10, 11 or 12 task. A school needs a new computer lab designed.

 

Back to IT Projects | Top | Previous

 

Home | Products | Prices | Ordering | Podcasts | Downloads | Contact