Modified 09 October 2009
Theme 3 :
Mainly Data dynamics| Pages covered and dates | Activity | What learner must do | Focus of exercise | Check / Signature |
| Finding
information in a database Queries and reports Chapter 4.2 Pages 223-251 Complete by 21 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 | Sortted by Surname | ||
| 24-2-Housesitting HouseSittingEnquiries | Put in Word document and print and put in portfolio a). Security query b). Allergic to cats query c). No large dogs query |
None, Not, Or | ||
| 24-3-Housesitting December | Print and put in portfolio a). December query b). December report with total |
Or Count | ||
| 24-4-Housesitting Client List according to Security Company | Print and put in portfolio Group according to security company View all details |
Grouping, Grow | ||
| 24-5-Housesitting Request from Peter and John | Print and put in portfolio | OR. | ||
| 24-6-Housesitting Other | Print and put in portfolio | Additional exercises | ||
| Analysing data
using Excel Analysing spreadsheet data Chapter 3.3 Pages 185-199 (PPT) Complete by 28 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 11 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 11 Sept |
Phase 1 | Counts for end of year | ||
| Using forms to make Access more
accessible Forms Chapter 4.3 Page 252-263 Complete by 9 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. | ||
| 9-Checklist | Complete Checklist and put in portfolio | Answer checklist truthfully | ||
| 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 16 October |
Phase 2 | Counts for end of year | ||
| 19 October | Database test | Counts for end of year | ||
| Collaboration and
integration
Chapter 6.2 Pages 327-343 Complete by 23 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. | Import data to Access | ||
| 14-Checklist | Complete Checklist and put in portfolio | Checklist | ||
| PAT 6 Nov |
Phase 3 | Counts for end of year | ||
| 9-13 Nov | Go over an old exam paper |
Return to Computer Applications Technology index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.