1. Information Technology Concepts
2. The functions of a Personal Computer
3. The Internet and Networks
4. Searching the Internet Effectively
5. Word Processing
6. Spreadsheets
7. Presentations and Drawings Graphics
8. Databases/Filing Systems
1. Information Technology Concepts (14 tutorials)
Information Technology Concepts The first basic requirement of competence in computing is to understand the context for the computer-based applications in society and the essential concepts of computers.Basic Terminology Basic Computer Components The Keyboard The Mouse Computer Ports Computer Software Operating Systems Types of Operating Systems Using a Graphical User Interface Application Software Application Software Using Application Software Networks Computer Networks The Internet What is The Internet? Using a Browser E-mail What is E-mail? Using E-mail Day-to-Day use of Computers Occupational Health Security Copyright and the Law
2. The functions of a Personal Computer (30 tutorials)
The functions of a Personal Computer Understanding the basic housekeeping functions required for the efficient use of the computer.Introduction Introducing Windows 98 Getting Started Shutting Down Windows Getting Help The Start Menu Using the Start Menu Customizing the Start Menu The Taskbar Using the Taskbar Exploring the Taskbar The Desktop Window Operations Folder Options Creating Desktop Shortcuts Exploring My Computer The Recycle Bin System Tools Standard Utilities Notepad WordPad Paint System Utilities Disk Defragmenter Using Scandisk Disk Cleanup Tasks Scheduling a Task Editing a Task File Tools Windows Explorer Finding Files The Screen Customizing Display Properties Advanced Operations Networking Sharing Resources Sharing Folders Network Neighbourhood Operations Adding Devices The Active Desktop Adding New Hardware Adding a Printer Using Multiple Monitors
3. The Internet and Networks (53 tutorials)
The use of networks has grown from a desire to share resources and to communicate with others. Today, millions of computers are connected to huge networks across the world. The ICT Skills Benchmark ensures its holders can make effective use of the 'Information Super Highway'.The World Wide Web Browsing the Web Connecting and Disconnecting Introduction to the World Wide Web Microsoft Internet Explorer Internet Explorer Address Bar Internet Explorer Standard Button Bar Internet Explorer Radio Button Bar Working With Favorites Customizing Internet Explorer Netscape Navigator Netscape Navigator Navigation Bar Netscape Location Bar and Bookmarks Netscape Navigator Personal Toolbar Netscape Navigator History Window Customizing Netscape Navigator E-mail Outlook Express Inbox Checking for Messages Opening Attachments Forwarding Messages Replying to Messages Outlook Express Outbox Creating New Messages Adding Attachments Sending Mail Deleting Messages Netscape Messenger Inbox Checking for Messages Opening Attachments Forwarding Messages Replying to Messages Netscape Messenger Outbox Creating New Messages Adding Attachments Sending Mail Deleting Messages Address Books Adding a Contact - Outlook Addressing a Message - Outlook Adding a Contact - Netscape Addressing a Message - Netscape Newsgroups and Publishing on the Web Newsgroups Viewing and Subscribing - Outlook Replying to and Posting - Outlook Viewing and Subscribing - Netscape Replying to and Posting - Netscape FrontPage Express FrontPage - Personal Home Page Wizard Changing the Color Scheme Using FrontPage Adding Images Using FrontPage Creating Links Using FrontPage Publishing a Web Page Using FrontPage Netscape Composer Composer - Personal Home Page Wizard Changing the Color Scheme Using Composer Inserting Images Using Composer Creating Links Using Composer Publishing a Web Page Using Composer Uploading Files With FTP Chatting on the Net Setting up and Using mIRC ICQ Using ICQ Chatting With ICQ Essential Internet Utilities WinZip ACDsee Graphic Viewer CYBERsitter
4. Searching the Internet Effectively (18 tutorials)
Searching the Internet Effectively This competency gives an understanding of the best ways of finding information on the internet.Major Internet Search Tools Search Engines Search Engines Search Engine search Subject Directories Subject Directories Subject Directory search Meta Search Engines Meta Search Engines Meta Search Engines search Search Strategy Search Types Keyword search Natural Language search Simple Menu Driven search Advanced Menu Driven search Boolean Searches Boolean phrase search Boolean OR operator Boolean truncation operator Mailing Lists Finding Mailing Lists Exploring Mailing Lists Newsgroups Finding Newsgroups Exploring Newsgroups Web Forums Finding Web Forums
5. Word Processing (79 tutorials)
Word Processing Using the computer for the creation, editing, formatting, storing and printing of documents. Most documents used today are produced by using word-processing applications.Introducing Word Opening Word and Help Features Opening Word Finding Help Using the Office Assistant Options Using What's This? and ScreenTips Word Window Elements Maximizing and Minimizing Using Menus Using Toolbars Word's Pointers Using Scroll Bars Starting a Document Entering and Editing Text Using the Insert and Overtype Modes Selecting Text Entering Non-Keyboard Characters Managing Files Saving a Document Closing a Document and Exiting from Word Opening an Existing Document Finding and Managing Files Working with Multiple Files Editing Moving and Replacing Text Using Cut, Copy, and Paste Using Drag and Drop Using Undo, Redo and Repeat Using Find, Replace and Go To Checking Spelling and Grammar Choosing a Dictionary Checking Spelling and Grammar Spelling and Grammar Options Using the Thesaurus Auto Features Using AutoCorrect Using AutoComplete Using Word Count Using the Hyphenation command Formatting Formatting Text Formatting Text Using the Toolbar Formatting Text Using the Menu Case Changes and Dropped Capitals Using the Highlighter Tool Displaying Non-Printing Symbols Formatting Paragraphs Aligning and Spacing Paragraphs Using the Format Painter Viewing a Paragraph's Formatting Using Borders Using Shading Tabs Indents Bullets and Numbers Using the Ruler for Indents and Tabs Using the Menu for Indents and Tabs Using Click and Type Using Bullets and Numbering Formatting Pages Viewing a Document Creating Headers and Footers Using Page Breaks The Widow/Orphan Control Adding Page Numbers Document Formatting Tools Sections and Columns Creating Sections Creating Columns Using the Menu Creating Columns Using the Toolbar Changing Column Widths Using the Ruler Breaking Columns Using Styles Applying Styles Modifying Styles Creating New Styles Deleting, Renaming, and Displaying Styles Using the Style Organizer Using Outlines Setting Up an Outline Using the Outline Toolbar Moving a Heading and Text Simple Table Functions Creating Tables Using the Tables and Borders Toolbar Selecting and Modifying Tables Changing Row Height and Column Width Formatting Tables Advanced Table Functions Converting Text to Tables Splitting Tables and Merging Cells Side-by-Side and Embedded Tables Sorting Table Data and Using AutoSum Adding Formulas to Tables Printing Documents Using the Page Setup Dialog Box Setting Margins Setting Paper Size and Source Setting Layout Options Previewing and Printing a Document Using the Print Preview Toolbar Moving Margins in Print Preview Editing Text in Print Preview Using the Print Command
6. Spreadsheets (41 tutorials)
Spreadsheets Similar to manual spreadsheets, with the ability to perform calculations rapidly. They are used for preparing budgets, producing forecasts, business graphs and financial reports.Introducing Excel Quick Tour Windows Basics Opening and Closing Excel Moving Around in Excel Menus and Toolbars Using Adaptive Menus Office Assistant Managing Workbooks Opening Workbooks Using Worksheets Saving Workbooks Managing Files and Folders Finding a File Using Worksheets Entering Data Entering Text and Numbers Revising and Deleting Entries Entering Dates and Times Using AutoFill Various Ways of Selecting Cells Using Formulas Entering Formulas Reference Operators AutoSum Using Functions Using Simple Functions Using Worksheet Functions Moving and Copying Data Moving and Copying Data Using AutoFill to Copy Formulas Inserting, Deleting, and Hiding Rows and Columns Cell References Named Ranges Relative and Absolute References Cell Reference Styles Formatting Worksheets Fonts Alignment Formatting Numbers Formatting Rows and Columns Patterns and Borders Patterns Applying Borders Using Charts Creating Charts Modifying Charts Formatting Chart Items Printing Page Setup Basic Page Setup Decisions Setting Margins Adding Headers and Footers Sheet Options Previewing Page Breaks Printing Worksheets
7. Presentations and Drawings Graphics (55 tutorials)
Presentations and Drawings Graphics have always been an important tool for architects, engineers, illustrators and designers. The use of computer based presentation and drawing tools has grown in many application areas to support effective communication. These tools are now used extensively in business and in teaching.Introducing PowerPoint Getting Started Starting and Exiting PowerPoint The PowerPoint Screen Presentation Views Getting Help Creating Presentations Creating a New Presentation The AutoContent Wizard Opening an Existing Presentation Working with PowerPoint Moving Around a Presentation Moving Between Slides Adding and Deleting Slides Changing Slide Sequence Collapsing and Expanding Slides Entering Text Entering Text Text Boxes Modifying Slides Formatting Text Adding Bullets Formatting Paragraphs Undoing Mistakes Changing the Slide Color Scheme Drawing Objects Adding an Object Adding Clipart Working with Objects Moving and Resizing Objects Grouping and Ungrouping Objects PowerPoint Presentations Preparing the Presentation Performing a Spell Check Adding Slide Number, Date and Time Adding Slide Transitions Animating Bullet Points Adding Slide Timings Running a Presentation Setting Up and Starting the Slide Show Moving to Another Slide Pausing a Slide Show Looping a Slide Show Ending a Slide Show Printing Presentations Black and White View Printing the Presentation Advanced PowerPoint Features Working with Master Slides The Slide Master The Title Master The Handout Master The Notes Master Header and Footer Information Charts Inserting a Chart Datasheet Elements Chart Elements Organizational Charts Inserting an Organization Chart Opening and Closing a Chart Building a Chart Formatting a Chart Tables Inserting a Table Working with Tables Adding Borders to Tables Adding and Printing Speaker Notes Presentations for the Internet The Web Toolbar Opening an Internet Address Creating and Saving Presentations for the Internet Adding and Customizing Hyperlinks Playing the Presentation on the Internet
8. Databases/Filing Systems (80 tutorials)
Databases/Filing Systems Assist in the organization of large volumes of data to allow fast and flexible access to the data.Introducing Access Getting Started What is a Database? Types of Databases Planning a Database Opening and Closing Access Startup Options The Database Window Opening a New Database Opening an Existing Database Introducing Database Objects Database Objects Views Grouping Database Objects Using Help The Office Assistant Using the What's This Command Using Menus and Toolbars Menus and Toolbars Adaptive Menus Working With Tables Creating a New Table Entering Fields in Design View Saving a Table The Primary Key Datasheet View Closing and Deleting a Table Working in Datasheet View Opening an Existing Table Finding Records in Datasheet View Wildcards Replacing Records in Datasheet View Modifying Tables in Datasheet View Adjusting Column Width and Row Height Adding and Saving Records in Tables Adding, Renaming, and Deleting Columns Defining Relationships Creating Field Indexes Using Spelling and AutoCorrect in Datasheet View Working with Simple Queries and Macros Working with Select Queries Opening a Select Query Creating a Select Query Switching Views in the Query Window Query Sorting and Criteria Saving, Closing and Deleting Queries Other Queries Creating a Parameter Query Append Query Delete Query Make-Table Query Update Query Modifying a Query Opening an Existing Query Hiding and Ordering Query Fields Creating Macros Working With Forms and Reports Creating and Using Forms Creating a Form Using the Form Wizard Switching Form Views Viewing, Editing and Refreshing a Form Adding and Saving a Record Closing and Deleting a Form More on Forms Creating a Form for a Subform Creating a Switchboard Creating a Data Access Page Creating a Hyperlink Creating and Using Reports Creating a Report Using the Report Wizard Moving Around a Report Creating a Subreport Formatting a Report Printing a Report More on Reports Printing Records Creating a Calculated Control Creating a Chart Managing Reports Closing and Deleting a Report Opening an Existing Form or Report Switching Between Views Modifying Report Properties Importing, Exporting and Database Management Importing and Exporting Exporting to Excel Importing from Non-Access Sources Synchronizing and Replicating Databases Splitting a Database Replicating a Database Synchronizing Databases Linked Table Manager Security Creating a Database Password Deleting a Database Password Encrypting a Database Validation Table Level Validation Defining an Input Mask Lookup Fields Database Management Analysis Documenter Performance Analyzer Table Analyzer Converting a Database Compact and Repair a Database
Introducing LearningFast@jcu | Registering
and Password Information | Instructions
for Use | Go direct to LearningFast
If this information is inadequate, incorrect, or can be improved in any way, please let us know