Modified 23 December 2008
Theme 3 :
Mainly Data dynamicsData for the Theme - zipped file minus the photo folders
| Pages covered and dates | Activity | What learner must do | Focus of exercise |
| Finding
information in a database Queries and reports Chapter 4.2 Pages 223-251 Complete by 15 Aug |
1-CD queries | Explore | Explore existing queries on a given table |
| 2-CD table of queries | Print and put in portfolio | See if you can do the different queries | |
| 3-AnimalHospital table of queries | Print and put in portfolio | See if you can do the different queries | |
| 4-CD | Explore | Explore the different screens that must be used to create a query | |
| 5-CD Information that will be extracted | Print and put in portfolio | Answer questions about existing queries to determine whether you fully understand queries | |
| 6-CD | Explore | Explore the different steps that must be followed to create a report | |
| 7-1-CD not Hip Hop | Explore | See if you can create a few queries yourself | |
| 7-2-a-AnimalHospital Animal - sorted as Type | Print and put in portfolio | See if you can create a few queries yourself | |
| 7-2-b-AnimalHospital Snakes | Print and put in portfolio | See if you can create a few queries yourself | |
| 7-2-c-AnimalHospital Pets_Not_Vaccinated | Print and put in portfolio | See if you can create a few queries yourself | |
| 8-AnimalHospital | Print and put in portfolio | Answer questions about given queries that consist out of more than one criteria - in Word | |
| 9-SportsTeams (all 5) | Print and put in portfolio | See if you can create a few queries that consist of more than one criteria - all 5 | |
| 10-CD | Explore | Explore an existing report | |
| 11-CD | Explore | Explore the difference between Print Preview mode and Design view mode | |
| 12-CD Report | Print and put in portfolio. Just print ONE page | Explore all the different steps and screens that must be used to create a report | |
| 13-CD Report but different | Print and put in portfolio. Just print ONE page | Create a report yourself | |
| 14-AnimalHospital | Print and put in portfolio. Just print ONE page. | Create a report yourself | |
| 15-CD RockCD report | Print and put in portfolio | Change the appearance of a given report | |
| 16-CD Alphabetical list of CDs report | Print and put in portfolio. Just print ONE page | Change the appearance of a given report | |
| 17-SportsTeam | Explore | Create a report that must be grouped according to certain fields | |
| 18-AnimalHospital grouped by Type | Print and put in portfolio. Just print ONE page. | Create a report that must be grouped according to certain fields | |
| 19-CD grouped by Owner | Print and put in portfolio. Just print ONE page. | Create a report that must be grouped according to certain fields | |
| 20-CD | Explore | Explore and do an example where calculations are done on fields. | |
| 21-CD Replacement value of CDs | Print and put in portfolio. Just print ONE page. | Explore and do an example where calculations are done on fields. | |
| 22-AnimalHospital Report of query | Print and put in portfolio. Just print ONE page. | Create a report yourself where a calculation must be done | |
| 24-1-Housesitting Client List | Print and put in portfolio | Additional exercises | |
| 24-2-Housesitting HouseSittingEnquiries | Print and put in portfolio | Additional exercises | |
| 24-3-Housesitting December | Print and put in portfolio | Additional exercises | |
| 24-4-Housesitting Client List according to Security Company | Print and put in portfolio | Additional exercises | |
| 24-5-Housesitting Request from Peter and John | Print and put in portfolio | Additional exercises | |
| 24-6-Housesitting Other | Print and put in portfolio | Additional exercises | |
| Analysing data
using Excel Analysing spreadsheet data Chapter 3.3 Pages 185-199 Complete by 22 Aug |
1-Count | Explore | Use COUNT, COUNTA and COUNTBLANK |
| 2-Achievements | Print and put in portfolio | Use COUNT, COUNTA and COUNTBLANK | |
| 3-DataClients | Print and put in portfolio | Use COUNT, COUNTA and COUNTBLANK | |
| 4-ComputerGame | Print and put in portfolio | Use COUNTIF | |
| 5-SportsShirts | Print and put in portfolio | Use COUNTIF | |
| 6-Large/Small | Print and put in portfolio | Use LARGE and SMALL | |
| 7-ComputerGames | Print and put in portfolio | Use LARGE and SMALL | |
| 8-OfficeExpenses | Print and put in portfolio | Use SUMIF | |
| 9-SalesFirstQuarter | Print and put in portfolio | Use SUMIF | |
| 10-IF | Print and put in portfolio | Use IF-function | |
| 11-Discount IF | Print and put in portfolio | Use IF-function | |
| 12-PricesBooks | Print and put in portfolio | Use IF-function | |
| 13-Payments IF | Print and put in portfolio | Use IF-function | |
| 15-1-LongJump | Print and put in portfolio | Revision using LongJump | |
| 15-2-SalesForce | Print and put in portfolio. Revise Formulas with a quiz | Revision using SalesForce | |
| Working with and
making sense of surveys Using a survey Chapter 6.1 Pages 312-322 Complete by 5 Sept |
3-Many opinions | Print and put in portfolio | Interpret votes |
| 4-ThemeForFunDay | Print and put in portfolio | Graphically present data | |
| 5-DresscodeQuest | Print and put in portfolio- based on Activity 12 on page 107 in Theme 1 | Interpreting data - | |
| 6-Data collection methods | Print and put in portfolio | Evaluate data collection methods | |
| 7-Sample groups | Print and put in portfolio | Analysing sample group | |
| 8-Create form | Print and put in portfolio | Create survey form | |
| 9-Survey of Grade 11 | Print and put in portfolio | Create and do a survey | |
| PAT 12 Sept, then had to redo for 17 Sept |
Steps 1 and 2 | Counts for end of year | |
| Using forms to make Access more
accessible Forms Chapter 4.3 Page 252-263 Complete by 10 Oct |
1-CD form | Explore | Explore an existing form based on a given table. |
| 2-AnimalHospital form | Explore | Create a new form making use of the Form Wizard. | |
| 3-SportsTeams and HouseSitting forms | Explore | Try to create two new forms for two given tables in two given databases. | |
| 4-AnimalHospital form | Explore Save it | Change the characteristics of given forms | |
| 5-SportsTeams and HouseSitting forms | Print ONE record using SportsTeams AND HouseSitting forms showing headings | Change the characteristics of given forms | |
| 6-SportsTeams form | Print ONE record using SportsTeams form showing combo boxes of SportsTeams | Explore how to improve an existing form | |
| 7-SportsTeams form | Print ONE record using SportsTeams form showing combo boxes of Grade and Class | Improve a given form yourself. | |
| 8-Herbs form | Print ONE record using Herbs form showing image | Explore an existing form where one of the fields contain a photograph. | |
| 10-1-LearnerLifeSciences | Print LearnerLifeSciences report with information grouped by class, showing Name, Surname and Class | Practical applications of the concepts done in this chapter | |
| 10-2-LearnerLifeSciences | Print LearnerLifeSciences report with each class on a separate page, with names and surnames | Practical applications of the concepts done in this chapter | |
| 10-3-LearnerLifeSciences | Print LearnerLifeSciences report of learners who have not paid, with Names, Surname, Grade and Class | Practical applications of the concepts done in this chapter | |
| 10-4-LearnerLifeSciences | Print form of Rina Clay from LearnerLifeSciences | Practical applications of the concepts done in this chapter | |
| 10-5-LearnerLifeSciences | Report of all who paid from from LearnerLifeSciences, plus total in footer | Practical applications of the concepts done in this chapter | |
| 10-6-LearnerLifeSciences | Report with just email address, display Name, Surname and Email address from from LearnerLifeSciences | Practical applications of the concepts done in this chapter | |
| PAT 17 October |
Steps 3 and 4 | Counts for end of year | |
| Collaboration and
integration
Chapter 6.2 Pages 327-344 Complete by 24 October |
1-HoaxesEditedColours | Follow the editing instructions typed in the document. | |
| 2-Ergonomics | Explore | Practice the inserting and deleting of comments in a document. | |
| 3-WriteLetter | Explore | Create a document and communicate with a co-worker with the help of instructions typed in the document. | |
| 4-HoaxesEditedTrackChanges | Explore | Look at the different ways we can display changes in a document. | |
| 5-HoaxesEditedTrackChanges | Explore | Accept or reject track changes | |
| 6-No verbal communication | Explore | Create a document and communicate with the help of electronic commentary | |
| 7-Sportwear | Print and put in portfolio | Copy data (objects) between Word, Excel and Access | |
| 8-Convert | Explore | Experiment with different file formats | |
| 9-AmountsOutstanding | Print graphs and put in portfolio | Convert Excel files to other formats. Import a text file to Excel | |
| 10-CD database | Print rtf table and put in portfolio | Convert Access tables to other file formats. | |
| 11-HerbsInfo | Print table and put in portfolio | Import a table from Excel to Access | |
| 12-Music | Print music details and put in portfolio | Import data from Word to Access | |
| 13-Sport.txt | Print database table and put in portfolio | Checklist | |
| 27 Oct | Database test | Counts for end of year | |
| PAT 31 October |
Phases 5 and 6 | Counts for end of year |
Return to Computer Applications Technology index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.