PHS badge

PHS CyberSchool

Computer Studies SG Grade 11 taught the Internet 1999

Last modified 30 October 1999

Database and Spreadsheets Practical examination - 40 marks


Complete on foolscap or as an email, and submit to your teacher. It should not take more than 30 minutes. During the test you may ask for help but it costs 5 marks for each request.

Database - Access

Open the program Access. Open the file lib.mdb. Answer the following questions based on that database.
  1. How many books/titles/records are in the database?
  2. How many fields are in the database?
  3. What is the author and title of the first book if the database is arranged according to Author in ascending alphabetical order?
  4. What is the author and title of the first book if the database is arranged according to Author in descending alphabetical order?
  5. What is the author and title of the first book if the database is arranged according to Title in ascending alphabetical order?
  6. What is the author and title of the first book if the database is arranged according to Title in descending alphabetical order?
  7. What is the author and title of the first book if the database is arranged according to Dewey1 in descending alphabetical order?
  8. The book Mailships of the Union Castle Line was written by CJ Harris and BD Ingpen (ex Pinelands High School principal). Is this book in the database?
  9. The book Book education lessons / Boekopvoedinglesse was written by Pamela Miller (Pinelands High School Computer Studies SG teacher). Is this book in the database?
  10. How many books by T. Noakes are in the database?

[10]

Spreadsheets - Excel

Open the program Excel. Open the file 9911sepw.xls. Answer the following questions based on that spreadsheet.

Answer the following questions based on Sheet November:

  1. What is the lowest Learner number?

    Which learner(s) or learner number(s) ...

  2. obtained the highest marks for Pr9 or Practical task 9?
  3. was/were absent for Pr2 or Practical task 2?
  4. obtained the highest marks for Pr3 or the Practical task 3?
  5. was/were absent for Pr3 or Practical task 3?
  6. was/were absent for Pr4 or Practical task 4?
  7. obtained the highest marks for Practical tasks?
  8. obtained the highest marks for Ex72 or the Theory test 7?
  9. obtained the highest marks for Th4,5,6 or the Theory tests 4,5,6?
  10. obtained the highest marks for Theory tests?

  11. How many learners obtained the lowest marks for Pr9 or Practical task 9?
  12. How many learners achieved full marks for Th8 or Theory test 8?
  13. What was the class average % for the Practical tasks?
  14. What was the class average % for the Theory tests?
  15. What was the class average % for this November sheet?
  16. What is the formula in the cell H4?
  17. What is the formula in the cell H5?
  18. What is the formula in the cell I4?
  19. What is the formula in the cell I5?
  20. What is the formula in the cell N4?
  21. What is the formula in the cell N5?
  22. What is the formula in the cell O4?
  23. What is the formula in the cell O5?
  24. For no marks - What comment is found next to your name?
  25. For no mark - Go to the web page for Grade 11 in 1999, and Make up of final year mark. Do the marks on this sheet count towards the final year mark?

    Answer the following questions based on Sheet December:

    Which learner(s) or learner number(s) ...

  26. has obtained the highest marks for May?
  27. has obtained the highest marks for September?
  28. has/have obtained the highest marks for the Project?
  29. has/have obtained the highest marks for May, September and Project and go into the final exams with the highest marks?
  30. was/were not doing the subject in May and was/were 'absent'?

  31. What is the formula in cell J3?
  32. How many learners have already passed Computer Studies SG even though they have not written the exams yet?

[30]

/40/

Return to Grade 11 lessons in 1999 or Computer Studies lesson plan index of Pinelands High School. The views expressed do not necessarily express those of Pinelands High School. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.