Modified 22 November 2007
| PAT 20 July |
Phases 1 and 2 | ||
| Finding
information in a database Queries and reports Chapter 4.2 Pages 223-251 Complete by 26 July |
1-CD queries | Explore existing queries on a given table | Explore |
| 2-CD table of queries | See if you can do the different queries | Print and put in portfolio | |
| 3-AnimalHospital table of queries | See if you can do the different queries | Print and put in portfolio | |
| 4-CD | Explore the different screens that must be used to create a query | Explore | |
| 5-CD Information that will be extracted | Answer questions about existing queries to determine whether you fully understand queries | Print and put in portfolio | |
| 6-CD | Explore the different steps that must be followed to create a report | Explore | |
| 7-1-CD not Hip Hop | See if you can create a few queries yourself | Explore | |
| 7-2-a-AnimalHospital Animal - sorted as Type | See if you can create a few queries yourself | Print and put in portfolio | |
| 7-2-b-AnimalHospital Snakes | See if you can create a few queries yourself | Print and put in portfolio | |
| 7-2-c-AnimalHospital Pets_Not_Vaccinated | See if you can create a few queries yourself | Print and put in portfolio | |
| 8-AnimalHospital | Answer questions about given queries that consist out of more than one criteria - in Word | Print and put in portfolio | |
| 9-SportsTeams (all 5) | See if you can create a few queries that consist of more than one criteria - all 5 | Print and put in portfolio | |
| 10-CD | Explore an existing report | Explore | |
| 11-CD | Explore the difference between Print Preview mode and Design view mode | Explore | |
| 12-CD Report | Explore all the different steps and screens that must be used to create a report | Print and put in portfolio. Just print ONE page | |
| 13-CD Report but different | Create a report yourself | Print and put in portfolio. Just print ONE page | |
| 14-AnimalHospital | Create a report yourself | Print and put in portfolio. Just print ONE page. | |
| 15-CD RockCD report | Change the appearance of a given report | Print and put in portfolio | |
| 16-CD Alphabetical list of CDs report | Change the appearance of a given report | Print and put in portfolio. Just print ONE page | |
| 17-SportsTeam | Create a report that must be grouped according to certain fields | Explore | |
| 18-AnimalHospital grouped by Type | Create a report that must be grouped according to certain fields | Print and put in portfolio. Just print ONE page. | |
| 19-CD grouped by Owner | Create a report that must be grouped according to certain fields | Print and put in portfolio. Just print ONE page. | |
| 20-CD | Explore and do an example where calculations are done on fields. | Explore | |
| 21-CD Replacement value of CDs | Explore and do an example where calculations are done on fields. | Print and put in portfolio. Just print ONE page. | |
| 22-AnimalHospital Report of query | Create a report yourself where a calculation must be done | Print and put in portfolio. Just print ONE page. | |
| 24-1-Housesitting Client List | Additional exercises | Print and put in portfolio | |
| 24-2-Housesitting HouseSittingEnquiries | Additional exercises | Print and put in portfolio | |
| 24-3-Housesitting December | Additional exercises | Print and put in portfolio | |
| 24-4-Housesitting Client List according to Security Company | Additional exercises | Print and put in portfolio | |
| 24-5-Housesitting Request from Peter and John | Additional exercises | Print and put in portfolio | |
| 24-6-Housesitting Other | Additional exercises | Print and put in portfolio | |
| Linking computers
to make business more effective Computers in the workplace Chapter 1.5 Pages 77-91 Complete by 2 August |
1-Advantages of a network | Reasons for networking | Print and put in portfolio |
| 2-Advantages of a network for a school | Rationale for installing a network | Print and put in portfolio | |
| 3-Terminology | Identifying situations | Print and put in portfolio | |
| 4-Setting up small LAN | Practically installing network | Print and put in portfolio | |
| 5-Setting up small LAN | Practically installing network | Print and put in portfolio | |
| 6-Issues | Morality issues | Print and put in portfolio | |
| Analysing data
using Excel Analysing spreadsheet data Chapter 3.3 Pages 185-199 Complete by 9 August |
1-Count | Use COUNT, COUNTA and COUNTBLANK | Explore |
| 2-Achievements | Use COUNT, COUNTA and COUNTBLANK | Print and put in portfolio | |
| 3-DataClients | Use COUNT, COUNTA and COUNTBLANK | Print and put in portfolio | |
| 4-ComputerGame | Use COUNTIF | Print and put in portfolio | |
| 5-SportsShirts | Use COUNTIF | Print and put in portfolio | |
| 6-Large/Small | Use LARGE and SMALL | Print and put in portfolio | |
| 7-ComputerGames | Use LARGE and SMALL | Print and put in portfolio | |
| 8-OfficeExpenses | Use SUMIF | Print and put in portfolio | |
| 9-SalesFirstQuarter | Use SUMIF | Print and put in portfolio | |
| 10-IF | Use IF-function | Print and put in portfolio | |
| 11-Discount IF | Use IF-function | Print and put in portfolio | |
| 12-PricesBooks | Use IF-function | Print and put in portfolio | |
| 13-Payments IF | Use IF-function | Print and put in portfolio | |
| 15-1-LongJump | Revision using LongJump | Print and put in portfolio | |
| 15-2-SalesForce | Revision using SalesForce | Print and put in portfolio | |
| PAT 21 August |
Phase 3 | ||
| Working with and
making sense of surveys Using a survey Chapter 6.1 Pages 312-322 Complete by 23 August |
3-Many opinions | Interpret votes | Print and put in portfolio |
| 4-ThemeForFunDay | Graphically present data | Print and put in portfolio | |
| 5-DresscodeQuest | Interpreting data - based on Activity 12 on page 107 in Theme 1 | Print and put in portfolio | |
| 6-Data collection methods | Evaluate data collection methods | Print and put in portfolio | |
| 8-Create form | Create survey form | Print and put in portfolio | |
| Using forms to make Access more
accessible Forms Chapter 4.3 Page 252-263 Complete by 6 September |
1-CD form | Explore an existing form based on a given table. | Explore |
| 2-AnimalHospital form | Create a new form making use of the Form Wizard. | Explore | |
| 3-SportsTeams and HouseSitting forms | Try to create two new forms for two given tables in two given databases. | Explore | |
| 4-AnimalHospital form | Change the characteristics of given forms | Explore Save it | |
| 5-SportsTeams and HouseSitting forms | Change the characteristics of given forms | Print ONE record using SportsTeams AND HouseSitting forms showing headings | |
| 6-SportsTeams form | Explore how to improve an existing form | Print ONE record using SportsTeams form showing combo boxes of SportsTeams | |
| 7-SportsTeams form | Improve a given form yourself. | Print ONE record using SportsTeams form showing combo boxes of Grade and Class | |
| 8-Herbs form | Explore an existing form where one of the fields contain a photograph. | Print ONE record using Herbs form showing image | |
| 10-1-LearnerLifeSciences | Practical applications of the concepts done in this chapter | Print LearnerLifeSciences report with information grouped by class, showing Name, Surname and Class | |
| 10-2-LearnerLifeSciences | Practical applications of the concepts done in this chapter | Print LearnerLifeSciences report with each class on a separate page, with names and surnames | |
| 10-3-LearnerLifeSciences | Practical applications of the concepts done in this chapter | Print LearnerLifeSciences report of learners who have not paid, with Names, Surname, Grade and Class | |
| 10-4-LearnerLifeSciences | Practical applications of the concepts done in this chapter | Print form of Rina Clay from LearnerLifeSciences | |
| 10-5-LearnerLifeSciences | Practical applications of the concepts done in this chapter | Report of all who paid from from LearnerLifeSciences, plus total in footer | |
| 10-6-LearnerLifeSciences | Practical applications of the concepts done in this chapter | Report with just email address, display Name, Surname and Email address from from LearnerLifeSciences | |
| Making a
PowerPoint interactive Interactive presentations Chapter 5.3 Pages 291-301 Complete by 13 September |
1-Elephants - based on work done in Theme 1 | Navigate with Go to Slide | Explore |
| 2-Elephants | Navigate with Action buttons | Explore | |
| 3-BasicComputerDevices | Navigate with Hyperlinks | Explore | |
| 4-BasicComputerDevices | Navigate with Action buttons and Hyperlinks | Explore | |
| 5-MyPhotos | Create own PPT | Diagram and PPT in electronic format | |
| 6-Computers in Education | Create own PPT with links | Diagram and PPT as handout | |
| 3 September | Database and Excel test | ||
| Choosing the
right type of presentation Working with information Chapter 6.1 Pages 322-325 Complete by 13 September |
10-Correct type of presentation | Appropriate presentation | Print and put in portfolio |
| Collaboration and
integration
Chapter 6.2 Pages 327-344 Complete by 20 September |
1-HoaxesEditedColours | Follow the editing instructions typed in the document. | |
| 2-Ergonomics | Practice the inserting and deleting of comments in a document. | Explore | |
| 3-WriteLetter | Create a document and communicate with a co-worker with the help of instructions typed in the document. | Explore | |
| 4-HoaxesEditedTrackChanges | Look at the different ways we can display changes in a document. | Explore | |
| 5-HoaxesEditedTrackChanges | Accept or reject track changes | Explore | |
| 6-No verbal communication | Create a document and communicate with the help of electronic commentary | Explore | |
| 7-Sportwear | Copy data (objects) between Word, Excel and Access | Print and put in portfolio | |
| 8-Convert | Experiment with different file formats | Explore | |
| 9-AmountsOutstanding | Convert Excel files to other formats. Import a text file to Excel | Print graphs and put in portfolio | |
| 10-CD database | Convert Access tables to other file formats. | Print rtf table and put in portfolio | |
| 11-HerbsInfo | Import a table from Excel to Access | Print table and put in portfolio | |
| 12-Music | Import data from Word to Access | Print music details and put in portfolio | |
| 13-Sport.txt | Checklist | Print database table and put in portfolio |
Return to Computer Applications Technology index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.