E-Note Sign-Up
Camille Curtis Navigation
Camille Curtis
Upcoming Events
Contact Camille Curtis

INFORMATION & COMMUNICATION TECHNOLOGY

It isn’t as boring as it sounds!!  I make this class fun.  Students will learn everything listed below, but I promise they will enjoy it!

 

1st 9 Weeks Students will be able to touch type 30 words per minute with 90% accuracy.  The keyboards are blacked out so guess what?  They will be forced to learn it!  It’s a challenge, but they can do it!

2nd 9 Weeks Students will be able to:

  1. Review hardware components of a computer system: system units and peripherals.
  2. Review the care and handling of storage devices.
  3. Explain the proper procedures for starting and shutting down the system unit.
  4. Create a folder.
  5. Rename or delete folder.
  6. Move and copy a folder.
  7. Key block style personal or business letter.
  8. Review the parts of a spreadsheet: active cell, cell, cell reference, column, label, range, row, value, workbook, worksheet.
  9. Review, edit and format a spreadsheet: alignment, fill, freeze, sort.
  10. Create a merged document: letter and envelope/label.
  11. Examine desktop publishing documents: Newsletter, Flyer, and Brochure.
  12. Create a document using desktop publishing features: Clip Art, Graphics, Columns, and Word/Text Art.
  13. Create mathematical functions: SUM, AVERAGE, COUNT, MIN, and MAX.
  14. Create mathematical formulas using cell references, operators, operands, and order of operations.
  15. Use absolute cell reference, relative cell reference, and mixed cell reference.
  16. Use spreadsheet data to create a line graph, pie chart, and column chart
  17. Edit and print a chart/graph.
  18. Open a database.
  19. Identify database parts: field, record, primary key, and table.
  20. Name and save a database file.
  21. Design a database table: field name, data type.
  22. Enter and edit data in a table.
  23. Generate and run a query using the query wizard and/or function.
  24. Enter and display data in a form using the form wizard and/or function.
  25. Produce a report using the report wizard and/or function.
  26. Plan and format a presentation using transitions, graphics, animations, design template, theme, timings, narrations, audio and slide layout.
  27. Utilize various view and print options. View options should be equivalent to PowerPoint’s slide show view, slide sorter view, and normal view. Print options should be equivalent to PowerPoint’s full page, notes, outline, and handouts.
  28. Utilize presentation software to present a presentation
  29. Develop an end-of-course project using at least 3 performance indicators.

 

Vocabulary

Desktop Publishing – the production of printed matter by means of a computer having a layout program that integrates text and graphics

Clip Art – a feature that includes pre-made illustrations, drawings, pictures, and other graphic that can be inserted into a document

Graphic – illustrations, drawings, pictures

Word/Text Art – decorative text that you can add to a document

Column – one of two or more vertical sections of printed material on a page; usually separated by margins

Citation – a reference to a published or unpublished source

Spreadsheet – a grid of rows and columns containing numbers, text, and formulas used to perform calculations

Mathematical Function – a built-in command which can be used to perform common mathematical operations such as addition, multiplication, and rounding numbers

SUM – adds all the numbers in a range of cells

AVERAGE – returns the average (arithmetic means) of its arguments

COUNT – returns the number of cells in a range that contains numbers

MIN – returns the smallest value in a set of values

MAX – returns the largest value in a set of values

Mathematical Formula – a general relationship, principle, or rule stated, often as an equation, in the form of symbols

Cell Reference – a unique identifier for a cell which is formed by combining the cell's column letter and row number

Operator – a symbol that indicates what mathematical operation to perform on the operands:  plus (+), minus (-), multiply (*), divide (/)

Operand – a number or cell reference used in a formula

Order of Operations – the mathematical rules used for calculating the value of a formula

Absolute Cell Reference – cell reference that does not adjust to the new cell location when copied or moved

Relative Cell Reference – cell reference that adjusts to a new location when copied or moved

Mixed Cell Reference – a cell reference that contains both relative and absolute references

Line Graph - a chart that uses points connected by a line to illustrate values in a worksheet

Pie Chart – a chart that shows the relationship of a part to a whole

Column Chart – a chart that uses bars of varying height to illustrate values in a worksheet

Database – a collection of organized data that allows access, retrieval, and use of data

Field – a single characteristic of data that appears in a table as a column

Record – a collection of fields that appear as a row in a database or table

Primary Key – a field that uniquely identifies a record in a table

Table – a database view of information arranged in a grid of rows and columns

Data Type – indicates the type of data that can be stored in a field

Query – a question presented in a way that allows the database to process and generate specific data from one or more tables

Form – a database view that allows the user to see all fields for one record and enter them one at a time

Form Wizard – an automated way of quickly creating a basic form for you data, rather than doing it manually

Report – a document that uses data from tables and/or queries; the user controls which items in the database will appear in the report and how it is filtered or sorted

Report Wizard – a tool within Report Designer that guides you through the process of creating a repor

Presentation – an application that allows the user to create and save slides to use as a slide show

Transition – a feature that can be applied in presentations to control the way slides move on and off the screen

Template – something that serves as a model for others to copy

Theme – a palette of colors, fonts, and special effects used on a slide

            Slide layout – a template which includes placeholders for text, videos, pictures, charts, shapes, and clip art