Unit A:  Getting Started w/Windows Vista Objectives

 

Start Windows Vista

·        Booting process

 

Use a pointing device

 

 

Start a program

 

 

Move and resize windows

 

 

Use menus, toolbars, and keyboard shortcuts

 

 

Use dialog boxes

 

 

Use scroll bars

 

 

Use Windows Help and Support

·        Located on the Start button

·        Also located on the “?” on the top right of the  ribbon when in a program

 

 

End a Windows Vista session

·        Click start button

·        Point to the Lock button which has a list of all the shut-down options

 

 

 

 

 

 

 

 

 

 

 

 

Unit B:  Understanding File Management Objectives

 

Manage folders and files

·        Create folders for sorting and organizing files

·        Rename, copy, and move folders and files

·        Delete and restore folders and files

·        Locate folders and files quickly using Instant Search

·        Use shortcuts to access frequently used files and folders

 

 

Unit A:  Getting Started with Microsoft Office 2007 Objectives

 

Understand the office 2007 Suite

 

 

Start and Exit an Office program

·        Click start button

·        Double click a desktop icon  or recent items menu

·        Click office button and click exit

 

 

View Office 2007 User Interface

·        A user interface is a collective term for all the ways you interact with a software program.

 

 

Create and Save a File

·        File created in Excel is call a workbook and has the default extension .xlsx

·        Save As lets you save your work on any storage device

 

 

Open a file and save it with a new name

 

 

View and print your work

 

 

Getting help and closing a file

 

 

 

 

Unit A Excel 2007 Objectives

 

Understand spreadsheet software

·        Enter data quickly and accurately

·        Recalculate data easily

·        Perform what-if analysis

·        Change the appearance of information

·        Create charts

·        Share information

·        Build on previous work

Terms:

An electronic spreadsheet is an application you use to perform numeric calculations and analyze and present numeric data

 

Worksheet is an electronic spreadsheet you work in and is contained in a file called a workbook

You can use spreadsheets to :

·        Perform calculations

·        Represent values graphically

·        Generate reports

·        Organize data

·        Analyze data

·        Create what-if data scenarios

 

 

Tour Excel 2007 Window

 

 

Understand formulas

Formulas are equations in a  worksheet

·        Know where the formulas should be

·        Know exactly what cells and arithmetic operations are needed

·        Create formulas with care

·        Use cell references rather than values

·        Determine what calculations will be needed

 

 

Enter labels and values and use AutoSum

·        Labels are entries that contain text and numerical information not used in calculations

·        Values are numbers, formulas, and functions used in calculations

 

Unit A Excel 2007 continued……

 

Edit cell entries

--Common pointers in Excel

·        Normal

·        Copy  õ

·        Fill handle É

·        I-beam

·        Move Æ

 

 

Enter and edit simple formulas

·        Formula prefix

·        Calculation operators

·        Arithmetic operators

·        Comparison operators

·        Text concatenation operators

·        Reference operators

 

 

Switch worksheet view

·        Normal view shows the worksheet without including certain details like headers and footers

·        Page layout view provides a more accurate view of how a worksheet will look when printed

·        Page break preview displays a reduced view of each page of your worksheet

 

 

Choosing print options

·        Landscape

·        Portrait

 

 

 

 

 

 

 

 

 

Unit B:  Excel 2007 Objectives

 

Create a complex formula

·        A complex formula is one that uses more than one arithmetic operator

 

 

Insert a function

·        Functions are predefined worksheet formulas that enable you to perform complex calculations easily

·        AutoSum

·        Average

·        Insert function button

 

 

Type a function

 

 

Copy and move cells

 

 

Understand relative and absolute cell references

·        Use relative references when you want to preserve the relationship to the formula location

·        Use absolute cell references when you want to preserve the exact cell address in a  formula

 

 

Copy formulas with relative cell references

 

 

Copy formulas with absolute cell references

 

 

Round a value with a function

·        RO

 

 

 

 

 

 

 

 

Unit C Excel 2007 Objectives

 

Format values

·        The format of a cell determines how the labels and values look

 

 

Change font and font size

·        Font is the name for a collection of characters with a  similar, specific design

·        Font size is the physical size of the text, measured in units call points

·        A point is equal to 1/72 of an inch

 

 

Change attributes and alignment

·        Attributes are styling formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet

·        Merge and center

·        Format painter

 

 

Adjust column width

·        The column heading is the box at the top of each column containing a letter

·        AutoFit feature automatically resizes a column

·        Hide and unhide

·        Default width

 

 

Insert and delete rows and columns

·        Insert button

 

 

Apply color, patterns, borders

 

 

Conditional formatting

·        Excel automatically applies different formats depending on conditions you specify

·        Manage rules

 

 

Name and move a sheet

 

 

 

Unit D Excel 2007 Objectives

 

Plan a chart

·        Determine purpose of chart

·        Determine the results you want to see

·        Identify the worksheet data you want the chart to illustrate

·        Understand the elements of a chart

·        X-axis—horizontal axis or category axis

·        Y-axis—vertical axis or value axis

·        Plot area is the area inside the horizontal and vertical axes

·        Tick marks

·        Gridlines

·        Data marker visually represents ea data point

·        Data series is a collection of data points

·        Legend

·        Types of charts

1.      Column

2.      Line

3.      Pie

4.      Bar

5.      Area

6.      Scatter

 

 

Creating a chart

·        You must select a range in the worksheet containing the data you want to chart

·        Embedded charts are placed directly in the current worksheet

·        A chart sheet is a sheet in a workbook that contains only the chart but is linked to the workbook data

·        Sizing handles are a series of dots at the corners and sides of the chart’s border

·        Contextual chart tools tabs appear on Ribbon

1.      Design

2.      Layout

3.      Format

Move a resize a chart

·        Object is an independent element on a worksheet

·        In the Chart Tools Deign tab, you can click the Move Chart button to help you move the embedded chart

 

 

Change the chart design

·        Change chart type button

 

 

Change chart layout

·        Gridlines are the horizontal and vertical lines in the chart that enable the eye to follow he value on an axis

·        Axis Titles button

 

 

Format a chart

·        Located in the Chart Tools Format tab

 

 

Annotating and drawing a chart

·        Located in the Chart Tools Format tab

 

 

Create a Pie Chart

·        Exploding-pulling a piece away from the pie