Lesson Aim:
- Create queries in MS Access
Main Task
Your task is to download the database and worksheet below and create queries to answer the questions on the worksheet.
Extension
Create reports to improve the presentation of your query
Category: Year 8
Year 8 – World Record Database
Lesson Aim
- Create a form in a Microsoft Access Database
- Use a Form to add Data to a Microsoft Database
Your Task
Download the file below to your folder and save it in Year 8 and then ICT Folder.
You will then need to create a form (Return to the middle to view demonstration)
Now create a form and add records to your database
Year 8 – Creating a Database
Lesson Aim
-
Identify suitable data types and field lengths for Fields
-
Understand the need for a primary key
-
Create a Database in MS Access
Main Task
Create a database table for recording details of world athletics records.
Then add the details you collected in to the database
Use the sheet below to help you create you database
Year 8 Website
Lesson Aim
- Create a web plan for a website
- Understand what details need to be included in a web plan
Main task
Use the website design sheet below to help you create a website proposal for your chosen scenario. You may create a website for one of the following scenarios:
- Holiday destination (eg. Spain, Florida)
- Sports team (eg Man Utd, Fulham)
- Pop Group ( eg. One Direction)
Year 8 – Spreadsheet task
Lesson Aim
- Reinforce spreadsheet skills
- Create formulas using functions (sum, count)
You will need to work on the worksheets in Spreadsheet below to revise all the spreadsheet techniques you learnt last year.
Extension
Complete the spreadsheet below
Global Warming Presentation
You will need to create a presentation in powerpoint with the following slides:
- Title and Picture
- What is global warming
- Arguments for Global warming
- Arguments against Global warming
- Your conclusions
- sources
Ensure you have recorded your sources.
If you have completed your presentation, create a poster advising Newsome High School pupils how they can reduce their carbon footprint.
Global Warming Presentation
You will need to create a presentation in powerpoint with the following slides:
- Title and Picture
- What is global warming
- Arguments for Global warming
- Arguments against Global warming
- Your conclusions
- sources
Ensure you have recorded your sources.
If you have completed your presentation, create a poster advising Newsome High School pupils how they can reduce their carbon footprint.