|
|
Introduction to Computer Applications
This semester-long course is designed to develop a student's
understanding of the major uses of the computer in our society.
Students will build upon the skills they learned in Middle School in
Microsoft Word, Excel, and PowerPoint. They will also learn how to
develop a simple database in Microsoft Access and how to develop and
maintain a simple web site using Microsoft FrontPage.
Upon successful completion of this course, students should be able to:
- Use advanced features in Microsoft Word, PowerPoint and Excel
- Create a simple database using Microsoft Access
- Create a simple web site using Microsoft FrontPage
- Conduct effective Internet research
Topics To Be Covered
- Microsoft Excel
Topics To Be Covered - Microsoft Access
Topics To Be Covered - Microsoft FrontPage
Semester Schedule
The schedule that we will be following over
the course of this semester is noted below. This may change slightly
as the year progresses.
Class Intro & Microsoft Word
Rotation Cycle 1 - 2
Microsoft Excel
Rotation Cycle 3 - 5
Microsoft Access
Rotation Cycle 6 - 8
Microsoft FrontPage (Web Design) Rotation Cycle 9 - 10
Integrated Project
Rotation Cycle 11 - 12
Microsoft PowerPoint
If we run ahead of schedule
|
|
| |
Topics To Be Covered -
Microsoft Excel
- Students will be able to identify the features of
a spreadsheet such as: cell, row, column, sheet, workbook, address
- Students will be able to identify the uses of
Excel: A graphic organizer, address list, tracking information,
performing multiple calculations
- Students will be able to use Excel to perform
basic calculations either by entering their own functions or using the
preprogrammed functions and will learn how to use relative and absolute
reference to create spreadsheets that calculate many cells.
- Students will be able to identify and use the
basic formatting functions: borders, cell sizing, auto-sizing cells,
centering across cells, formatting cell contents, inserting and removing
cells, rows and columns
- Students will be familiar with the concepts of
data collection and sampling and will be able to take a simple
collection of raw data, tabulate it and create a simple chart from that
information.
- Students will be able to plan a large spreadsheet.
- Students will be able to add headers and footers
to a spreadsheet
- Students will be able to enter functions using the
function command
- Students will be able to change the margins, print
orientation, and page break of a spreadsheet
- Students will be able to Use the IF function and
use text in the IF function
- Students will be able to use and print multiple
sheets
- Students will be able to copy and move data
between sheets
- Students will be able to refer to data in
different sheets
- Students will be able to create pie, bar, and line
charts of spreadsheet data.
- Students will be able to modify, format, and print
charts.
- Students will be able to answer What If? Questions
using a spreadsheet
- Students will be able to sort the data in a
spreadsheet
- Students will be able to use the CHOOSE and
VLOOKUP functions
- Students will be able to freeze selected rows and
columns
- Students will be able to create an amortization
table using the PMT function
- Students will be able to print a selected
spreadsheet area
- Students will be able to create hyperlinks to the
Internet
- Students will be able to copy data between
spreadsheets
- Students will be able to create embedded and
linked objects in spreadsheets
TOP
|
Topics To Be Covered -
Microsoft Access
- Students will be able to
describe a relational database and its structure
- Students will be able to
define fields
- Students will be able to
design and create a relational database
- Students will be able to
view objects in both the design and datasheet views
- Students will be able to
create a form for a table
- Students will be able to
enter records using a form
- Students will be able to
format datasheet view
- Students will be able to
print records
- Students will be able to
create and use filters to query a database
- Students will be able to
create and use a complex query
- Students will be able to
add, rename, and delete a field
- Students will be able to
sort records
- Students will be able to
add, update, and delete a record
- Students will be able to
define relationships
- Students will be able to
view a table’s sub datasheets
- Students will be able to
create and use select queries
- Students will be able to
modify a select query
- Students will be able to
create range queries
- Students will be able to
create and use complex select queries
- Students will be able to
create a report
- Students will be able to
create a report with a summary
- Students will be able to
use fields in select query criteria
- Students will be able to
create a calculation field
TOP |
Topics To Be Covered -
Microsoft FrontPage
- Students will be able to
use a graphic organizer to plan a web site
- Students will be able to
identify the basic elements of a Web site (e.g. URL, hyperlinks, site
map, navigation bars etc.)
- Students will be able to
create and save a new empty web
- Students will be able to
use a web template
- Students will be able to
use a Wizard
- Students will be able to
format characters, change text size, and format paragraphs
- Students will be able to
work with bulleted and numbered lists
- Students will be able to
add horizontal lines
- Students will be able to
find images on the Internet and insert them on a web page
- Students will be able to
crop and resize an image
- Students will be able to
add hot spots to an image
- Students will be able to
create a photo gallery using a page template
- Students will be able to
work with tables
- Students will be able to
change the appearance of tables and cells
- Students will be able to
identify and use the four basic principles of design (alignment,
proximity, repetition, and contrast).
- Students will be able to
add interesting page backgrounds using colors, images and watermarks
- Students will be able to
post their websites to the District's Intranet server
- Students will be able to
add hyperlinks (local, email, and outside)
|
|
Integrating Technology Project
Students will be able to integrate the
skills learned throughout the semester into a final course project.
TOP
|
|
Last Updated:
03/29/2007
This site was developed by Lori Alighieri |
|
