Tips

Modified 12 November 2011

Tip sheets

• Work highlighted in yellow need earphones.  Download the files.  To open off line, right-click, open with the Internet Explorer or Mozilla.  Make sure the security enables viewing the video.
• Work highlighted in blue are quizzes.  Your settings should allow you to view them all.
  

Applications

Access

1. Introduction - What is
2. Forms - Creating a combo box, Insert images
3. Queries - Creating a simple query, Criteria, Calculations on records in a query, Examples of expressions that use text values as criteria, Update queries
4. Reports - Calculations in a report, More calculations in a report, Getting it right AccessCalculations
5. Tables - Data type properties, Format properties, Validating data, Creating a combo box, Data types quiz, Primary key quiz, Boolean features
6. Personalised - Startup
7. Data access pages - Introduction, Pages used for data entry, Create a page using a wizard, Formatting pages, Customising navigation control
8. Save - Saving to other place
9. Big quiz
10. Switchboard
11. Access 2007 manual and PPT
    

Adobe Acrobat

1. Working with Adobe Acrobat

Delicious

1. How to use delicious and mp3 and ppt

Excel

1. Formulaes and Functions - Concatenate, Countif, Left, MRound, Round, SumIf, Sumif, Functions quiz, Vlookup
2. PivotTable, Pivot table
3. Microsoft Map
4. Graph - Frequency distribution graph
5. Self-marking quizzes
6. Financial functions, two-variable data tables and spinners
7. Conditional formatting and conditional formatting
8. Assigning a macro to a button
9. Creating a custom menu
10. Creating a macro
11. Advanced filters
12. Error indicators quiz
13. Data validation
14. Collection of Excel quizzes
15. Excel 2007 manual, PPT and crossword

FrontPage

1. Creating a web using FrontPage
2. Webscripting
3. Webinteractivity

Odeo (Podcasts)

1. Creating sound files as mp3s to download or link to online
2. Creating a podcast in Odeo and promoting it in Blogger and iTunes

Outlook

1. Using Outlook

PowerPoint

1. Creating a presentation using PowerPoint
2. Create a hyperlink or bookmark in PowerPoint
3. Saving a PowerPoint file as Read-Only
4. Create a MultiPage feature in PowerPoint using Visual Basic for Applications
5. Create a Text Tip feature in PowerPoint using Visual Basic for Applications
6. Create a simple quiz feature in PowerPoint using Visual Basic for Applications

WinZip

1. Zipping and unzipping files or in another way, Compressing or uncompressing files

Word

1. Saving a Word file as Read-Only
2. Create forms that users can view and complete in Word
3. Creating a graph in Word
4. Creating a multimedia Word document
5. Creating individual labels with mail merge
6. Working with long documents - Section breaks, Column breaks, Using styles, Modifying styles, Modifying styles of Captions, Table of Contents, Table of Figures, Cross references, Track changes
   
7. Mail merge from Access PPT and zipped
8. 2011 exam and mail merge
9. Word form fields and Fields MOV and SWF

Google

• Creating a Group and Importing email adddress

Twitter

• Web PPT, PPT in 2007, Adobe PDF, NewideaswithTwitter

Videos

• Abalami and Harvest of Hope

Useful information

OAO

1. 2010

Blogging

1. Quiz on Blogging and on RSS feeds
2. Blogging for beginners slide show and pdf
3. RSS feeds

Desk top publishing

1. General guidelines

Read-Only

1. Saving a Word file as Read-Only
2. Saving a PowerPoint file as Read-Only

Assessment

1. Marking an exam paper
2. Processing marks

PAT

1. Quiz (stupid, awful)

Online safety

• Video on Online safety

Effectiveness of online learning

• Video on the Effectiveness of online learning

Marking

• How to mark a computer examination

Keeping in contact

• Calendar

Digital camera

• Video of the Garden
• Video - Introduction to the course
• Photograph of how I spent the summer of 2007

UCT

• December 2011 UCT short courses

Report writing  Zipped

Return to Computer Applications Technology index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.