Students will be introduced to and practice:
WORD PROCESSING
|
|
Resources and Activities
|
Insert a table.
|
|
|
Create:
|
Brochure and a Newsletter
|
|
Students will be introduced to and practice:
SPREADSHEET
|
|
|
Given specific directions, students will enter data into a spreadsheet.
|
Formulas
|
|
|
Using a blank spreadsheet.
|
|
Students will move cell data.
|
Insert Row(s), Insert Column(s), Insert a Chart, Delete Row(s)
|
|
|
Delete Column(s), Move Data in Columns and/or Rows
|
|
Students will format data in a cell.
|
Numbers, Currency, Decimal Places/Precision, Percentages
|
|
Students will select data in a spreadsheet.
|
Select cells, entire row, entire column, and cells for graph.
|
|
|
Alignment, Row height, column width, wrap text, borders, fill colors
|
|
|
Rename Worksheet
|
|
Students will freeze row and column headings.
|
With and without gridlines or column and row headings
|
|
Students will display and print spreadsheet.
|
|
|
Explain the concept of formulas
|
Identify the symbols used in formulas (e.g., ( ) * + - = ).
|
|
Use Basic Formulas:
|
Use AutoSum.
|
|
|
Use relative cell reference
|
|
Functions:
|
Explain the concept of functions.
|
|
Identify parts of a function formula.
|
Equal sign, function name, argument in parentheses
|
|
Create formulas using + - * /.
|
|
|
Use existing functions or create formulas to solve mathematical problems.
|
Sum
|
|
Use Fill Commands:
|
Fill Down, fill right, fill special
|
|
Print specific and/or non-consecutive pages.
|
|
|
Charts / Graphs:
|
As a class, introduce electronic graphic organizers
|
|
|
Use charts/graphs.
|
|
|
Identify the purpose of charting data.
|
|
|
Identify column, bar, pie, line and scatter charts.
|
|
Create a basic chart/graph.
|
Column and bar
|
|
Format a basic chart/graph.
|
Resize Charts and move charts
|
|
Use a prepared spreadsheet to create a graph.
|
|
|
As a class, use a graph to produce results and make informed decisions to answer real-life questions.
|
|
|
Format various parts of chart.
|
Title the Chart and Label the X and Y axes.
|
|
Format the text appearance in a chart.
|
Font, Size, Style, and Color
|
|
Students will be introduced to and practice:
PRESENTATION
|
|
|
Insert:
|
Diagram, Movie, Sound, Table, Slide Numbers, Date and Time, Hyperlink
|
|
Format:
|
Text (appropriate font, size, and color), Bullets and Numbering
|
|
|
Alignment
|
|
Use sizing handles.
|
Picture (size and shape)
|
|
Setup Presentation/Show
|
Slide Transitions and Set Timings
|
|
Choose appropriate layout:
|
Title , Title and Text
|
|
Identify and use task pane.
|
Title and Text
|
|
Use slide view(s).
|
Slide order
|
|
Use rules of good presentations.
|
Content is clearly stated and design is pleasing to the eyes.
|
|
Students will be introduced to and practice:
DATABASE
|
|
|