Year 8 – World Records Over time
Lesson Aim:
- To search an online resource effectively
- To create a graph in MS Excel
Your Task
You need to download the blank world records table below and use the internet to fill in the world records for each time period. Once you have collected the information you need to create a graph for each event so that the results can be visually analysed.
Year 8 – World Record Database
Lesson Aim:
- Create Reports using Microsoft Access
Main Task
Your task today is to ensure that you have completed the queries for the task week and then create reports for each of your queries.
Year 8 – World Record Database
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
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
10 photos
Mr P’s room
Year 8 ICT – Create a Business Card
Your Task
You need to create a business card for the manager of your band and also a different card for the stars of the band. This must include the following:
Logo,Company name, Photo and name of person, their email and mobile contact details, the company address.
The ringtone companies website
Use the examples below to help you design your card: