Course Description:
This course will focus on developing student skills in word processing, spreadsheet, presentation, and database software applications. Students will develop email etiquette along with gain insight to online safety and security. Students will create flyers, research reports and business letters. Students will create worksheets with formulas and functions, and graphical charts. Students will learn to develop presentations with charts, graphics and special effects.
Essential Learner Targets:
Create and save new documents with appropriate names in locations for later retrieval.
Perform document formatting functions in new or existing word processing documents:
Find and replace text, cut, copy and paste text, insert hyperlinks
Set line and paragraph spacing and indention, apply text highlight color to text selections, format text in multiple columns, insert page, section and column breaks
Create tables to represent data sets of information.
Create and save workbooks with appropriate names in locations for later retrieval.
Create formatting functions in new or existing spreadsheets worksheets.
Copy and move worksheets, insert and remove hyperlinks, modify page setup, insert and delete columns or rows and adjust row height and column width.
Cut, copy, page or replace data, fill cells by using auto fill, insert and delete cells, merge cells, modify cell alignment.
Perform calculations using basic mathematical functions
Create charts and additional data series to existing charts.
Resize charts, add and modify chart elements
Create a new presentation, and a presentation based on a template
Perform document formatting functions in new or existing presentations:
Insert and apply slide layouts, duplicate existing slides, modify individual slide backgrounds
Create and modify a slide layout, modify slide order, delete slides, produce print documentation of presentations in a variety of formats.
Insert text on a slide, apply formatting, styles, WordArt styles to text, create bulleted and numbered lists, insert hyperlinks, insert images and resize and crop as needed.
Insert slide transitions and set transition effect options. Apply animations to objects and text.
Create and manage a new access database
Create database tables, queries, forms and records
Import data into an existing database
Create and modify reports
Create queries and use criteria to restrict query results