Computing

The record above is from a Ferry Company database. Look at the database and answer the questions below:

1. How would the ferry company arrange the records in order of name and, where two customers have the same name, in order of departure port?
(3 marks)

2. The ferry company manager wants to print out a list of all sailings to Stornoway during the month of July. Describe how he would do this.
(4 marks)

3. The ferry company database contains customer data. Which act of Parliament must they follow to ensure customer data is kept safe?
(1 Mark)

4. List 3 things the ferry company must do to comply with this act of parliament.
(3 Marks)

The record above is from a Ferry Company database. Look at the database and answer the questions below:

1. How would the ferry company arrange the records in order of name and, where two customers have the same name, in order of departure port?
(3 marks)

2. The ferry company manager wants to print out a list of all sailings to Stornoway during the month of July. Describe how he would do this.
(4 marks)

3. The ferry company database contains customer data. Which act of Parliament must they follow to ensure customer data is kept safe?
(1 Mark)

4. List 3 things the ferry company must do to comply with this act of parliament.
(3 Marks)

Look at the database above and answer the following questions

1. State the number of fields shown above.
2. State the number of records shown above.
3. List suitable field types for all fields in the database.
4. A new patient called Elaine Johnstone joins the dental practice. What must the dentist do with the personal information Elaine Johnstone gives her?
5. Describe how the dentist can find out which patients live in the town of Lomond.

Look at the database above and answer the following questions

1. State the number of fields shown above.
2. State the number of records shown above.
3. List suitable field types for all fields in the database.
4. A new patient called Elaine Johnstone joins the dental practice. What must the dentist do with the personal information Elaine Johnstone gives her?
5. Describe how the dentist can find out which patients live in the town of Lomond.

Today during period 5 I will conduct an experiment using “Exit Cards”. All you need to do is answer, truthfully, the questions on the card that I give you. The card will then be returned to me at the end of the period. You can choose to enter your name on the card or leave it blank.

Next week I plan to go over the most popular areas that pupils find difficult. It also allows me to see what parts of the course are going well.

The questions you will be asked are as follows:

1. Name the process of sending data from a database to a standard letter.
2. Write one thing you learned today.
3. What area gave you the most difficulty today?
4. Write a question you’d like to ask or something you’d like to know more about.

Basic Mail Merge steps as shown today. Remember, a more detailed set of instructions can be found on the school network….My Computer/Pupil Files/Computing and Info Sys/SG Comp/GPP/Databases

• Carry out Database search
• Select file and then export records
• Create a save file. Make sure .mer is file type.
• Select the fields that you need and then click on export.
• In your letter ensure the Mail Merge toolbar is visible.
• Select “Open Data Source”
• Navigate to find your .mer file you saved earlier.
• Select “insert fields” and place merge fields in place of placeholders.
• Once complete select “View Merged Data” and print the letters.

A quick recap on the database search techniques we discussed last week….

< less than
> greater than
<= less than OR equal to
>= greater than OR equal to
<> not equal to

To carry out a range search for dates etc you could enter something like 01/07/2011..31/07/2011. This would search for appointments in the month of July.

“simple search” = Searching on one field

“complex search” = searching on two or more fields

Content Grids

Copy and paste the questions into your own blog. Answer the questions in the same post. Make sure you put the post into your Spreadsheet category.

Able Art Printing company use spreadsheets as part of its business.
A sample is shown below.

1. The name of the company, Able Art Printing, does not fit in the column.
   State what must be done to the column to make the name fit.
2. What cell formatting has been used in cell B3 so that both words appear?
3. A formula is used in cell D8. What is it?
4. A formula is also used in cell D10. What is it?
5. The formula for cells D4 to D7 was entered in D4. It was then replicated
   down the column.
   State what is meant by replicated.
6. State how the format of cell C7 should be changed so that it looks the same as cell C6.

Classy Computers have asked their sales team to sell as many printers as possible this week. 

To encourage the sales team, they have offered a bonus in their wages if they sell 90 or more.

The spreadsheet shown below contains the result of the promotion.

1. Write down the formula that would be used in cell F5.
   
2. The formula in cell F5 was replicated down into cells F6 to F9. Both absolute and relative referencing were used.
   Explain carefully why this was necessary.
3. Write down the formula that would be contained in the cell E5. 
4. Describe 2 types of formatting that has been applied to this spreadsheet.