Section 1 Monday 5/12 at 9AM
Section 2 Wednesday 5/7 at 9AM
Essential Concepts:
Basic functions of a computer - input, output, process and store date
Where is processing done?
Where are programs and data stored temporarily? - permanently?
What is the CPU (microprocessor) and what two components comprise it?
What is a network and how does it apply to PC's?
Understand peripheral devices and their purpose
Functions of keys on the keyboard
What is magnetic storage vs. optical storage vs. flash storage?
What is the motherboard? What are expansion cards, slots, ports?
What is RAM and. ROM?
What are a byte, kilobyte, megabyte, gigabyte and terabyte?
What is ASCII and binary?
What is an operating system? What is a graphical user interface?
What is the Internet?
What is the WWW? What do the terms HTTP, HTML, and URL represent?
What is a browser and what is a search engine?
Word
What is formatting? What are the various tool buttons used for formatting
What are formatting marks and how do you display them?
What is a font? What is a point?
What are the different ways to select a word or paragraph?
How does the Speller and Grammar Checker, the Thesaurus and Find and Replace work?
What is Right Aligned, Left-Aligned, Centered and Justified in relation to text?
What is a manual and automatic page break? Why do you use [CTL] [Enter] and [CTRL] [Home]?
What is cut and paste? What is the purpose of the Paste Options button?
What are the tab and indent options on the ruler bar?
Windows XP
Know the components of the desktop:
Difference between clicking, double-clicking and dragging .
The anatomy of a window: - menu bar and the significance of an arrow or checkmark, the standard tool bar, the close, minimize and restore buttons
What are shortcut keys and when do you use them?
Components in a dialog box - radio or option button, list box, text box, command box
Difference between a file and a folder (directory)
How to copy a file or folder
How to move a file or folder
What formatting accomplishes?
What is multitasking?
What is file management? What is file hierarchy?
What is a file specification and how do you interpret it?
What is the difference between Save and Save As?
What happens when a file is deleted?
Excel
What the purpose of Excel is?
Difference between a worksheet and workbook
What is what-if analysis?
Basic components of a worksheet and their purpose
Worksheet tab and status bar
What is the formula bar?
What is a cell
How is it addressed
What can it contain
How do you enter a formula or a function and what is the order of precedence
Absolute vs. relative addressing
Formatting that can be applied
Anatomy of a chart
Legend and data marker
Tick mark and data series
Category x axis and Y value axis
Chart title
Access
Review the definition and advantages of database software
Understand the terminology associated with a database: fields, records, tables and relational database
What is a primary key? What is a foreign key? What is a one to many relationship?
Review how to plan a database project
Understand the different data types (only those covered in class) and table structure
Know the purpose of the various objects in an ACCESS database
Understand the terms and buttons associated with Sorting, Filtering and Finding
Understand the difference between Filtering by Selection and Filtering by Form
Understand what a query is, terms associated with it and how to create one.
Powerpoint
Definition of Presentation software –
List of tasks that can be accomplished by PowerPoint
PowerPoint Output Options
How to plan an effective presentation
What does slide layout mean and how is it used?
What is the Slide tab and Outline Tab …what are 1st level and 2nd level bullets?
Headers and Footers
Design Template vs. Slide layout
What is important when evaluating a presentation?
What are animations and how are they created.