PHS CyberSchool

Computer Studies SG Grade 11 - 2004

Modified 20 June 2004

Outdoor Club

                              Name:    ...............................................

Copy the folder called 0411Out from the CSSG / Exam folder to your own login. Unzip the folder. (The Access file available from the web has had the images removed to make it smaller.  It is on the CD in the 0411out folder in the examold folder.)  Rename the folder YourSurnameFirstnameOutdoor. All the files necessary for the exam will be in this folder. Save all your work in this folder. Only do what is required and nothing more. Save your work on a regular basis.  

An Outdoor Club has been established at Pinelands High School. The whole paper will focus on different aspects of the club. Most of the information is factually correct. 

Question 1 - Access - 49 marks

1. Rename the database 04outdoor YourSurnameFirstnameAccess.   Look at the Appendix for graphic examples of what is required.  
2. Open YourSurnameFirstnameAccess and perform the following tasks.

Tables - 9 marks 

Personal details table 

1. Change the format for Date in Date of birth to Short date. [1] 
2. Change the properties of Date of birth to create a validation rule so that no one born after 1 January 1994 may join the club. Apply this rule to new data only. Add a suitable validation text message. [3] 
3. Change the format of the Home Telephone number so that the numbers are grouped in 3s or 4s. [1] 
4. Add a feature in the Gender field so that you do not have to repetitively type M or F and can just click.  [1]
5. Make the Emergency phone a required field.  [1]

Walks table 

1. In the field Picture for the record Kalk Bay caves insert and link the image caveskalk.jpg. [2] 

Queries based on Personal details table - 21 marks 

1. List the members who live in Thornton. Save the query as a-Thornton. [1] 
2. Create a query to delete Joe Blogs from the table. Run the query. Save the query as b-Blogs. [1] 
3. Show those members whose Grading is 3 or higher. Save the query as c-Grading. [1] 
4. Calculate the average Grading of all members. Save the query as d-Average Grading. [1] 
5. Find the female members who live in Pinelands. Only show their First names, Surnames and Gender. Save the query as e-Pinelands Females. [2] 
6. List all members who were born on or after 9 June 1987. Save the query as f-Born After. [2] 
7. Calculate the number of members per suburb. Save the query as g-Number Suburbs. [2] 
8. Find the number of males and females who have a Grading of 3 by doing a crosstab query.  (Hint - Row is Grade and Column is Gender.)  Save the query as h-Grading of 3.  [2]
9. In the Personal details table insert a new field called Age after Date of birth. Decide on the field type. Create an update query to calculate the ages of all members.  Run the query. Save the query as i-Ages. [3] 
10. Make a table called Full names of the members' First names joined to their Surnames with a space between, e.g. Jodi Hartogh.  Name the field Full names.  Save the query as j-Full Names Query.  [3]
11. Create a query so that members can be found based on their Grading, ranging between two numbers.  The grading may be different every time you open the database.  Save the query as k-Different Gradings Every Time.  [3]

Reports based on various tables and queries - 8 marks 

1. Create a report of the query a-Thornton. Save the report as a-Thornton. [1] 
2. Create a report of all First names, Surnames and Suburbs grouped by Suburb. Save as b-Lifts. See picture in the Appendix. [2] 
3. Create a report of First names, Surnames, Gender and Suburbs. Group it so that the learners are grouped by Gender and within gender into their suburbs. Save it as c-Gender within Suburbs. See picture in the Appendix. [2] 
4. Create a report that will list all the members' names with First name joined to Surname in one field and Grading. Be sure there is a space between the First name and the Surname. Sort the records by Grading. Save the report as d-Names and Grading. See picture in the Appendix. [3] 

Forms - 6 marks 

1. Create a form for the Personal details table. Group the details at the top of the form. See picture in the Appendix. (The looks are not important.) [2] 
2. Create a form in columnar view for the Walks table with just the fields Info about the walk and Picture. Make sure that Record Selectors and Navigation Buttons are removed.  Make sure the pictures are viewed by zoom. See picture in the Appendix. (The looks are not important.) [2] 
3. Create a form where a person can select a favourite walk of a member and an image and description of that walk will appear. See picture in the Appendix. (The looks are not important.) [2] 

Switchboard - 5 marks

1. Add the name Pinelands High School Outdoor Club YourSurname to the application title and give it a new icon. [2] 
2. Create a switchboard with a command button to open in Print preview the Personal details table. [2] 
3. When the database is executed it must open with the switchboard. [1] 

Question 2 - FrontPage - 6 marks

1. Open the web RC.  Rename the web YourSurnameFirstName.  Most of the pictures have been removed for this examination so do not worry about the blank places.  
2. Index page 
   1. Change the colour of both the Good morning - Molo - Goeie more to the colour red.  [2]
   2. Make an image map from the picture of the building to Activities (left hand side of the picture) and Community ties (right hand side of the picture). [2]
3. Activities page
   1. Add an interactive mouse-clock to this page (as they are always busy).  [2]

Question 3 - FrontPage - 31 marks

Create a web called YourSurnameFirstNameOutdoor Club.  

1. Save all images in the images folder. [1]
2. Web must have frames with banner and contents pages, plus information pages.  [1]  (If you cannot manage frames leave it)
3. Index page 
   1. Words Welcome to Pinelands High Outdoor Club with a hyperlink to the web frame. [1]
   2. Pop up box saying Suitable for all ages, levels of fitness and abilities [1] with a clipart picture of someone climbing a mountain. [1]  The box must be small but big enough for the picture and text. [1]
   3. Status bar message Join the hikers. [1]
   4. Mailto to yourself as the author with your correct school address. [1]
   5. Feature where the date on which the page is edited is given and changes automatically when updated. Use words Last modified ...  [1]
   6. Page title PHS Outdoor Club [1]
   7. Background image a textured background and not a picture. [1]
   8. phslogo.gif as image in the centre of the page. [1]
4. Banner page
   1. Words Pinelands High School Outdoor Club bright green, bold and point size 18. [1]
5. Frames page
   1. No visible borders.  [1]
   2. Scroll bars only seen if needed. [1]
6. Contents page
   1. Links to 5 pages in the web called Cecilia Forest, Devils Peak, Kalk Bay Caves,  Lions Head and Table Mountain. [1]
   2. Bulleted list of pages mentioned above. [1]
   3. Bulleted list with green graphic icons [1]
   4. Something done to the hyperlinks so that when mouse is moved over the links they change to a different colour. [1]
7. Lions Head 
   1. Tile puzzle of the picture lionshead.jpg  [3]   Normal picture the same size as the puzzle so the user can check their skill at making the puzzle. [1]  Pictures next to each other. [1]
8. Kalk Bay Caves
   1. All the text from the text file caves.txt [1] and the image caveskalk.jpg inserted.  Text wrapped around the image. [1]
9. Devils Peak
   1. Words We saw the beautiful tahrs on Devils Peak.  Below the words the image tahr.jpg hyperlink it to a real site concerned with tahrs on Table Mountain.  Find a suitable site.  (The permission to use the picture tahr.jpg was obtained from the photographer Geoff Spiby) [3]
10. Table Mountain
    1. Insert quiz outdoorquiz.htm to the page.  [1]  Adjust something in the quiz / do something to the quiz so that the quiz works when marked and the correct answers are correct.  [2]
11. Save the web.