prentice hall technology applications, level 1 © 2004

Prentice Hall Technology Applications, Level 1 © 2004 Correlated to:

South Carolina Information Technology Foundations Standards

SWT = Student Work Text TECH = Technology TMG = Teacher Management Guide 1

SOUTH CAROLINA INFORMATION TECHNOLOGY FOUNDATIONS STANDARDS

PAGE(S) WHERE TAUGHT (If submission is not a text, cite appropriate resource(s))

INFORMATION TECHNOLOGY FOUNDATIONS COURSE DESCRIPTION: This course is designed to introduce the student to basic concepts in computer and information technology. The areas of instruction covered include computer hardware, software, Internet, and network systems. Upon successful completion of this course, a student should be able to successfully enter any one of the Information Technology Cluster majors. This course will also prepare the student to take the IC3 Certification test. OBJECTIVE: Given the necessary equipment, supplies, and facilities, the student will be able to successfully complete all of the following core standards. COMPUTER ACCESS REQUIRED. INTERNET ACCESS IS REQUIRED. AT LEAST ONE TAKE-APART COMPUTER IS REQUIRED FOR IDENTIFYING COMPUTER COMPONENTS. Note: The standards are written for a ½ -unit course. If the course is to be taught for 1 unit of credit, the local advisory committee should determine what should be added to the course.

A. SAFETY The student will be able to: 1. Identify good work attitudes that affect safety on

the job.

SWT: K3-K7, 22 TECH: iText Tutorials: Ergonomics and Computers,

What is Ergonomics?, Ergonomics and Your Workstation

2. Identify major causes of work-related accidents in

offices.

3. Demonstrate knowledge of an emergency plan.

B. STUDENT ORGANIZATIONS The student will be able to: 1. Explain how related student organizations are

integral parts of career and technology courses.

2. Explain the goals and objectives of related student organizations (include both FBLA and Skills USA).

3. List opportunities available to students through participation in related student organization conferences and other activities.






4. Explain how participation in career and technology education student organizations can promote lifelong responsibility for community service and professional development.

C. COMPUTER HISTORY The student will be able to: 1. Discuss how each of the following influenced the

development of computers as we know them to day: Jacquard, Babbage, Hollerith, vacuum tubes, ENIAC, transistors, semiconductors (microchips), and programming languages

2. Identify differences among Mainframes, Minicomputers, and Microcomputers and give examples of uses of each.

3. Discuss the different microcomputer platforms.

SWT: 13

4. Identify different computer types.

TECH: iText Tutorials: How Computers Work

5. Identify the most common measurement of storage in a digital computer.

SWT: 4-5, 266

D. PERSONAL COMPUTER HARDWARE The student will be able to: 1. Define the functions of the following components

of personal computers: Motherboard, RAM, ROM/BIOS, CMOS, BUS cards, power supply, CPU, hard drive, floppy drive, DVD/CD-ROM drive (CD-RW drive), memory cards, and expansion card slots.

SWT: 5, 8-9, 33-42 TECH: iText Tutorials: Types of Storage Devices,

Parts of a Computer, Difference Between Memory and Storage

2. Locate each of the components listed in Item 1 above inside a computer.

SWT: 10, 34

3. Discuss the uses, advantages, and disadvantages of the following input technologies: Floppy diskette, DVD/CD-Rom, mouse, keyboard, voice recognition software.

SWT: 21-23, 40-42 TECH: iText Tutorials: How Input Works, Types of

Storage Devices

4. Discuss common measurements of storage in a digital computer (bits, bytes, kilobytes, megabytes, gigabytes, terabytes).

SWT: 4, 9, 38, 40-42, 266 TECH: iText Tutorials: Types of Storage Devices

5. Define the function of the Complementary Metal Oxide Semiconductor (CMOS).






6. List types of output.

SWT: 5-6, 24-27

E. EXTERNAL COMPUTER HARDWARE COMPONENTS (PERIPHERALS) The student will be able to: 1. Explain the difference between CRT and LCD

monitors.

SWT: 25-26 TECH: iText Tutorials: Parts of a Computer

2. Explain the difference between PS/2 port, USB port, and serial port connections for mice and keyboards.

SWT: 10

3. Explain how wireless mice and keyboards work.

4. Explain the purpose of external and internal storage drives or devices.

SWT: 36-39, 40-42 TECH: iText Tutorials: Types of Storage Devices

5. Discuss the difference between modems that use telephone lines and those that use cable.

SWT: 177-178, 180-182

6. Explain the advantages and disadvantages of using laser, ink jet, bubble jet, dot matrix, impact, and plotter printers.

SWT: 26-27

7. Explain the difference between LPT1: and COM1: printer ports.

8. Define the functions of the following hardware and their relationship to the computer: Scanners, Speakers, Microphones, and Joysticks.

SWT: 22-25 TECH: iText Tutorials: Multimedia Input Devices

F. COMPUTER PERFORMANCE The student will be able to: 1. Define these two terms related to computer

performance: MIPS and throughput.

2. Define the following terms related to computer speed: MHz, GHZ, Hertz, and clock speed.

3. Explain the role of RAM in the speed and efficiency of a computer.

TECH: iText Tutorials: Difference Between Memory and Storage

4. Explain the role the capacity of the hard drive

plays in the speed and efficiency of a computer.

5. Explain the function of the BUS card.






6. Explain the role of video memory in the speed and efficiency of a computer.

7. Explain the function of a Network Interface Card (NIC).

SWT: 188, 269 TECH: iText Tutorials: Setting Up a Network

8. Explain how Ethernet connection speed is measured.

9. Define baud rate.

10. Explain how T1 and T3 lines affect Internet connections and speed.

G. PURCHASING A COMPUTER The student will be able to: 1. List factors to consider when deciding the type of

computer you should purchase: mainframe, minicomputer, or microcomputer.

2. List factors to consider when deciding the type of microcomputer you should purchase: laptop, desktop, or workstation.

3. List factors to consider when choosing hardware for your computer.

SWT: 64

4. List factors related to software that should be considered when purchasing a computer.

SWT: 62

5. Explain the importance of a warranty, service options, and support from the manufacturer.

H. TYPES OF SOFTWARE

The student will be able to:

1. Identify current operating systems.

SWT: 13, 52, 71 TECH: iText Tutorials: The Operating System and Its

Functions

2. Explain the difference between operating system software and application software.

SWT: 13-14, 59, 266, 271 TECH: iText Tutorials: How Software and Hardware

Work Together

3. Explain the purpose of each of the following types of application software: word processing, database management, spreadsheet, presentation, graphic, multimedia, software suites, browser, and electronic mail.

SWT: 60-62, 73, 75, 91-92, 107-110, 123-126, 139-140, 155-157






4. Discuss the use of utility programs.

SWT: 53-54

5. Explain the use of custom application software.

SWT: 14, 61

I. OPERATING A COMPUTER The student will be able to: 1. Identify the two basic kinds of operating systems.

SWT: 52

2. Define Graphical User Interface (GUI).

SWT: 50, 268 TECH: iText Tutorials: Exploring the Operating

System

3. List several Disk Operating System (DOS)-based Windows operating systems.

4. List the most recent New Technology (NT)-based Windows operating systems.

SWT: 64, 68

5. List several non-windows operating systems.

SWT: 52

6. Demonstrate ability to navigate the computer desktop.

SWT: 50-51 TECH: iText Tutorials: Create a New Document,

Exploring the Operating System; iText Practice Activities: South Africa, Energy Efficiency, Solar System, What’s the Angle?, The Growth of the World Wide Web, LANS and WANS, Culture Similarities, An African Climate; Freedom of Speech

7. Demonstrate ability to perform the following

tasks: maximize, minimize, restore, move, resize, and close a window.

SWT: 69 TECH: iText Practice Activities: World War I,

Energy Efficiency, Adjectives, Adverbs, and Prepositional Phrases

TMG: 156

8. Demonstrate ability to shut down and restart a computer properly.

TECH: iText Tutorials: Exploring the Operating System

9. Demonstrate ability to perform the following tasks:

a. Start a program using the start menu.

SWT: 68, 73 TECH: iText Tutorials: Exploring the Operating

System; iText Practice Activities: Weather

b. Switch to the desktop.

TECH: iText Practice Activities: World War I






c. Switch between open windows.

TECH: iText Tutorials: Moving Between Two Open Documents; Practice Activities: Adjectives, Adverbs, and Prepositional Phrases, South Africa, Energy Efficiency; iText Application Activities: Using Two Software Applications at Once

d. Create a desktop folder.

e. Move an object into a folder.

f. Change the name of a desktop object.

g. Delete a desktop object.

10. Demonstrate ability to use Online Help and application Help.

SWT: 57, 89, 249 TECH: iText Tutorials: Get Help; iText Projects:

World Reporting

11. Demonstrate ability to use Windows Explorer.

SWT: 53

12. Demonstrate ability to add a program to the Start Menu.

13. Demonstrate ability to change the way a window is viewed (list, details, sorted, etc...).

14. Demonstrate ability to select multiple files, rename files, create a new folder, delete a file, move a file/folder, view file properties, and search for a file.

SWT: 53, 55; T48 TECH: iText Practice Activities: Conveying

Information on a Web Page, World War I, Creating Multimedia on Computers

TMG: T40, T50

15. Demonstrate ability to change the following system settings:

a. Change the date and time settings.

b. Change display settings (background, screen saver, appearance, effects, etc...).

16. Demonstrate ability to begin and exit a Windows application.

SWT: 70; 77, 140-141 TECH: iText Practice Activities: The growth of the

World Wide Web, LANS and WANS, Storage Devices, Comparing Analog to Digital, Culture Similarities, An African Climate, South Africa, World War I, Caffeine, Water Usage, Weather, Solar System, Calculating Percentages, What’s the Angle?






(Continued) 16. Demonstrate ability to begin and exit a Windows

application.

(Continued) TECH: iText Application Activities: Using Software

to Illustrate Information, Spreadsheet Features, Using Two Software Applications at Once, Databases as an Organizing Tool, Career Information, Environmental Effects, Learning About Copyrights, Parts of Speech, Vocabulary Lists, Book Report, Online Research, Charting Time, Competing Equations, Analyzing Information in a Spreadsheet, Using Databases, Prime Factor Tree, Taking Chances, The Cell Cycle, Concept Map, Luis Pasteur, Animal Cells, Long-Distance Weather, Selective Breeding, Human Organ Systems, Planetary Presentation, Exchange Rates, Historical Timelines, Latin American Independence,(Cultural Observations, Wartime Conditions, Regional Stats, Pacific Islands, The United States and Canada; iText Projects: School News, Folk Tales from Around the World, Game Design, Packaging Design, Culture Chorale, Consumer Comparisons, Science Fair, World Reporting, Truly “Worldwide Web

17. Demonstrate ability to show and hide toolbars, move a toolbar, change views, and change magnification level within an application.

SWT: 141-143 TECH: iText Practice Activities: What’s the Angle?,

Comparing Analog to Digital; iText Application Activities: Historical Timelines

J. COMPUTER MEMORY


1. Define the types of ROM (Read Only Memory): PROM, EPROM, EEPROM, and Flash ROM.

2. Explain the difference between dynamic RAM (Random Access Memory) and static RAM.

TECH: iText Tutorials: Difference Between Memory and Storage

3. Define the types of RAM (DRAM, EDO DRAM,

BEDO DRAM, SDRAM, DDR-SDRAM, VRAM, WRAM, SGRAM, RDRAM, SO-DIMM, DRAM, SLDRAM, and FPM RAM).

4. Explain the role of Cache.

5. Define the most common physical memory packages: SIP, DIP, SIMM, and DIMM.






6. Explain the difference between the ATA (IDE and EIDE) hard disk interface and the SCSI interface.

K. CAREERS IN INFORMATION TECHNOLOGY (Use CD to show various pathways)

The student will be able to: 1. Discuss career pathways for the following Information Technology positions:

a. Computer Programmer including Software Developer

SWT: 146

b. Administrative Specialist

c. Simulation Analyst

d. System Analyst

e. Web Designer/Web Master/Web Developer

SWT: 237

f. Network Administrator

g. Computer Repair Specialist

SWT: 9

h. Computer Engineer

i. Help Desk Specialist

j. Telecommunications Director

2. Discuss academic coursework required for entering each of the pathways listed in Item 1.

SWT: 70

L. PROGRAMMING FUNDAMENTALS (Use CD for a demonstration a Visual Basic program and to view the VB Code.)

The student will be able to: 1. Explain the general purpose of a program.

SWT: 20, 53, 59 TECH: iText Tutorials: How Computers Work

2. Discuss the purpose and uses of each of the following programming languages:

a. HTML, XML

SWT: 237, 229 TECH: iText Tutorials: What is HTML?

b. QBasic






c. C, C#, C+, C++

d. Pascal

e. Visual Basic

f. Java, JavaScript

M. NETWORKING FUNDAMENTALS The student will be able to: 1. Identify and describe network topologies.

TECH: iText Tutorials: Setting Up a Network

2. Describe the communication theory of a network system.

TECH: iText Tutorials: Computer Communication

3. Describe the communication principles of Ethernet and token right systems.

TECH: iText Tutorials: Computer Communications

4. List and describe the layers of the Open Systems Interconnection (OSI) model.

5. Describe installation of a typical network adapter.

TECH: iText Tutorials: Setting Up a Network

6. List and describe common network protocols.

SWT: 190, 220-221, 225-226, 230, 238 TECH: iText Tutorials: Setting Up a Network,

Computer Communication, E-Mail Protocols, How is the Internet Different From the World Wide Web?

7. List and describe common network systems.

SWT: 192-194; iText Tutorials: What is a Network?

8. Identify common network cabling materials.

SWT: 188, 201; iText Tutorials: Setting Up a Network

9. Identify a network’s basic hardware devices.

SWT: 188-189, 194, 196-197 TECH: iText Tutorials: Setting Up a Network, What

is a Network?

N. NETWORK ADMINISTRATION The student will be able to: 1. Describe the basic security procedures used on

most networks.

SWT: 194






2. Explain the difference between user-level and share-level security.

3. Explain the role of the network administrator. SWT: 197

4. Describe a typical network administrative organizational structure.

5. Explain the administration of a small peer-to-peer network.

6. Explain the administration of a typical centralized-administration network.

O. INTERNET STRUCTURE The student will be able to: 1. Explain the difference between a LAN and WAN.

SWT: 192-194, 196-198, 268, 271; iText Tutorials: What is a Network?

TMG: 178

2. Explain how IP addresses are used.

SWT: 226 TMG: 180

3. Describe the physical structure and evolution of the Internet.

SWT: 219-222 TECH: iText Tutorials: How is the Internet Different

From the World Wide Web?, How E-Mail Travels Through Networks

4. Explain the difference between domain names and

Uniform Resource Locators (URLs).

SWT: 226, 229, 238 TMG: 180

5. Explain how to set up an e-mail account.

SWT: 224-225

6. Describe the common features associated with e-mail.

SWT: 203-206 TECH: iText Tutorials: Creating, Sending and

Receiving E-Mail Messages, Advanced E-Mail Features

7. Demonstrate the ability to use and manage e-mail

SWT: 204-206 TECH: iText Tutorials: Creating, Sending and

Receiving E-Mail Messages, Advanced E-Mail Features; iText Practice Activities: Water Resources; iText Application Activities: Long Distance Weather, Cultural Observations; iText Projects: Science Fair, Game Design, School News, Culture Chorale, Consumer Comparisons, Truly “Worldwide” Web






P. WEB FUNDAMENTALS The student will be able to: 1. Identify the elements of a Web Page.

TECH: iText Tutorials: Elements of a Web Page

2. Explain the term URL.

SWT: 229, 238, 271

3. Demonstrate the ability to save a website address in the browser being used.

TECH: iText Practice Activities: South Africa, Space Travel; iText Application Activities: Pacific Islands, Career Information; Planetary Presentation, Exchange Rates, Historical Timelines, The United States and Canada; iText Projects: Folk Tales From Around the World, Game Design, Science Fair, Truly “Worldwide” Web

4. Print a Web Page.

SWT: 215 TECH: iText Application Activities: Learning About

Copyrights, Online Research; iText Projects: Game Design, Consumer Comparisons, Science Fair

5. Demonstrate the ability to use several Search

Engines to perform a search.

SWT: 243

6. Explain what is meant by the term Keyword Search.

SWT: 241, 243, 163, 233 TECH: iText Practice Activities: Comparing Analog

to Digital, Walt Whitman; iText Application Activities: Career Information, Environmental Effects, Learning About Copyrights, Online Research, Databases as an Organizing Tool, Using Two Software Applications at Once, Using Software to Illustrate Information, Selective Breeding, Cultural Observations; iText Projects: Game Design

TMG: 182

7. Identify Boolean search strings.

SWT: 241 TECH: iText Tutorials: Boolean Searches; iText

Practice Activities: South Africa; iText Application Activities: Planetary Presentation, Creating a Slide Show Using Internet Searches, Formatting Documents on a Computer, Using Two Software Applications at Once, Databases as an Organizing Tool, Learning About Copyrights, Selective Breeding, Planetary Presentation, Exchange Rates, Historical Timelines, Latin American Independence, Regional Stats, Pacific Islands






(Continued) 7. Identify Boolean search strings.

(Continued) TECH: iText Projects: Game Design, Science Fair,

World Reporting, Truly “Worldwide” Web TMG: 182

8. Discuss the role computers have played in changing the workplace/industry and education delivery.

SWT: 244-245, 6, 25, 38, 50, 54, 62, 81, 97, 98, 109, 117, 156-157, 210, 214, 229; iText Tutorials: What is Virtual Reality?

9. Discuss the benefits of computers for the

physically and learning challenged.

SWT: 21, 61, 141

10. Using available software (Word, FrontPage, Dreamweaver, etc.) or web location providing free web page space such as www. geocities. com, demonstrate the ability to create a web page that includes at least the following information in resumé format:

a. Name and address

b. Career Objective

c. Education

d. Work Experience

e. Employable Skills

f. Professional Affiliations

11. Demonstrate the ability to view and print source code.

Q. TELECOMMUNICATIONS The student will be able to: 1. Identify terms used in telecommunications such as

modem, cable modem, router, DSL, ISDN, wireless, satellite, ISP, networking protocols, POP (Point of Presence), etc.

SWT: 172-174, 176-178, 180-182, 196-199, 213, 224-226; iText Tutorials: How is the Internet Different from the World Wide Web?, Setting Up a Network

2. Explain how electronic signals are transferred

from one location to another.

SWT: 173-174, 176-178 TECH: iText Tutorials: How Do Telephone

Communications Work?, How Cell Phone Networks Work, Computer Communication

3. Describe how technologies are merging into a

common distribution medium.

SWT: 182 TECH: iText Tutorials: The Future of

Telecommunications, The Growth of the World Wide Web






4. Discuss the role of government in telecommunications.

SWT: 222

R. COMPUTER HARDWARE The student will be able to: 1. Discuss ways to protect your computer from

thieves.

SWT: 260-262

2. Discuss ways to protect your computer from power spikes.

SWT: 262

3. Discuss the role ergonomics plays in ensuring safety in the computer environment.

SWT: K2, K3 TECH: iText Tutorials: What is Ergonomics?,

Ergonomics and Computers, Ergonomics and Your Workstation

4. Explain the importance of backing up work/data

on a personal computer and on corporate computers.

SWT: 54, 262 TECH: iTech Tutorials: Protecting Yourself Online

5. Describe the threat of viruses to a computer network.

SWT: 210, 257-258 TECH: iText Tutorials: What is a Computer Virus?

6. Explain the damage that can occur from computer viruses on a network and on a personal computer.

SWT: 210, 256-258, 265 TECH: iText Tutorials: What is a Computer Virus?

7. Explain what can be done to protect a network or a computer from viruses and options available in dealing with a virus attack.

SWT: 210 TECH: iText Tutorials: Protecting Yourself Online;

What is a Computer Virus?; iText Projects: Culture Chorale, Consumer Comparisons, World Reporting

8. Discuss the effects of different variations of

viruses such as a worm, time bomb, logic bomb, and Trojan horse.

SWT: 256-258 TECH: iText Tutorials: What is a Computer Virus?

9. Discuss how e-mail attachments should be handled.

SWT: 210 TECH: iText Tutorials: What is a Computer Virus?

S. LEGAL AND ETHICAL USE OF COMPUTERS


1. Explain what plagiarism online means.

SWT: 253

2. Discuss the various threats to privacy online.

SWT: 246; 252-253 TECH: iText Tutorials: Cybercrime and Categories of

Computer Attach






3. Discuss copyright regulations relating to online activities.

SWT: 253 TECH: iText Practice Activities: Copyrighted

Material; iText: Application Activities: Learning About Copyrights, Latin American Independence

4. Discuss legal and ethical uses of e-mail at work.

SWT: 254

5. Discuss legal and ethical uses of the Internet at work.

SWT: 254

T. WORD PROCESSING APPLICATIONS The student will be able to: 1. Start and exit a Windows application.

SWT: 89 TECH: iText Practice Activities: Storage Devices,

Culture Similarities, Weather, Energy Efficiency, Space Travel; iText Application Activities: Using a Word Processing Program, Using Two Software Applications at Once, Formatting Documents on a Computer, Using Software to Illustrate Information; Learning About Copyrights, Online Research, Comparing Data, Taking Chances, Louis Pasteur, Historical Timelines, The United States and Canada; iText Projects: School News, Folk Tales From Around the World, Consumer Comparisons, Science Fair, World Reporting, Truly “Worldwide” Web

2. Demonstrate the ability to get Help online while

using an application.

SWT: 249 TECH: iText Projects: World Reporting

3. Demonstrate the ability to customize an application window.

4. Demonstrate the ability to create new files and save files.

SWT: 89 TECH: iText Tutorials: Create a New Document,

Opening, Closing, and Saving Files; iText Practice Activities: Copyrighted Material, Writing to Convince, Conveying Information on a Web Page, Cultural Similarities, Storage Devices, Freedom of Speech, Model Equations; iText Application Activities: Using a Word-Processing Program, Formatting Documents on a Computer, Using Software to Illustrate Information, Using Two Software Applications at Once, Learning About Copyrights, Online Research, Comparing Data






(Continued) 4. Demonstrate the ability to create new files and

save files.

(Continued) TECH: Taking Chances, Louis Pasteur, Historical

Timelines; iText Projects: School News, Folk Tales From Around the World, Game Design, Packaging Design, Culture Chorale, Consumer Comparisons, Science Fair, World Reporting, Truly “Worldwide” Web

TMG: T50

5. Demonstrate the ability to format and edit files (change fonts, text effects, color, check spelling, etc.).

SWT: 89 TECH: iText Tutorials: Formatting and Aligning

Text, Spell Check; iText Practice Activities: Proportional Fonts, Storage Basics, Selling Computer Systems, Space Travel, Appliance Evaluation, Editing a Newsletter, Water Resources, Freedom of Speech, Cultural Similarities, Writing to Convince, Copyrighted Material, Reviewing a Survey; iText Application Activities: Using a Word-Processing Program, Formatting Documents on a Computer, Comparing Data, Historical Timelines, The United States and Canada, Using Two Software Applications at Once, Learning About Copyrights, Online Research, Comparing Data; iText Projects: School News, Game Design, Packaging Design, World Reporting

TMG: T51-T52

6. Demonstrate the ability to set margins, change page orientation and paper size, set print options, preview the document, and print.

SWT: 89 TECH: iText Tutorials: Setting Margins, Page Setup

Options, and Section Breaks, Print; iText Practice Activities: Freedom of Speech, Appliance Evaluation, Energy Efficiency, Model Equations, Selling Computer Systems, Storage Devices, Storage Devices, Writing to Convince; iText Application Activities: Using a Word-Processing Program, Online Research, Taking Chances, Formatting Documents on a Computer, Learning About Copyrights, Using Software to Illustrate Information, Formatting Documents on a Computer; iText Projects: School News

TMG: T50, T53

7. Demonstrate the ability to change line spacing and paragraph spacing.

TMG: T52






8. Demonstrate the ability to:

a. Change paragraph indention

SWT: 85 TECH: iText Practice Activities: Freedom of Speech TMG: T52

b. Create bulleted and numbered lists

TECH: iText Practice Activities: Selling Computer Systems

TMG: T52

c. Insert symbols

TECH: iText Practice Activities: Appliance Evaluation, Culture Similarities, Editing a Newsletter

d. Use, modify, and delete tabs

SWT: 85 TECH: iText Tutorials: Using Columns and Tab

Options; iText Practice Activities: Freedom of Speech; iText Application Activities: Formatting Documents on a Computer, Using Two Software Applications at Once

e. Insert breaks and page numbers

TECH: iText Tutorials: Insert Headers, Footers, and

Page Numbers, Setting Margins, Page Setup Options, and Section Breaks; iText Application Activities: Online Research

TMG: 53

f. Create, modify, and format headers and footers

SWT: 89 TECH: iText Tutorials: Insert Headers, Footers, and

Page Numbers TMG: T52

g. Apply borders and shading

TECH: iText Practice Activities: Conveying Information on a Web Page; iText Application Activities: Historical Timelines

h. Create and apply styles

SWT: 85 TECH: iText Practice Activities: Conveying

Information on a Web Page

i. Apply Autoformats and use the Format Painter

j. Create, modify, and format tables

TECH: iText Tutorials: Inserting Tables; iText Practice Activities: Proportional Fonts, Copyrighted Material, Reviewing a Survey, Weather; iText Application Activities: Using a Word-Processing Program, Comparing Data

TMG: T53






k. Insert images and graphics; and

TECH: iText Tutorials: Insert Clip Art. Copying a Spreadsheet into a Word Document; iText; Practice Activities: Freedom of Speech, Comparing Analog to Digital, Adjectives, Adverbs, and Prepositional Phrases, Energy Efficiency, Space Travel, Model Equations; iText Application Activities: Using Software to Illustrate Information, Using Two Software Applications at Once, Online Research, The United States and Canada; iText Projects: School News, Folktales from Around the World

TMG: 53

9. Create, modify, and position drawn graphics.

TECH: iText Tutorials: Using the Drawing Toolbar; iText Practice Exercises: Prime Factors, Comparing Analog to Digital; iText Application Activities: Using a Word-Processing Program, Historical Timelines, The United States and Canada; iText Projects: Game Design, Packaging Design, School News, World Reporting, Comparing Two Types of Probability, Prime Factor Tree

U. SPREADSHEET SOFTWARE APPLICATIONS The student will be able to: 1. Start spreadsheet application software.

SWT: 99, 103, 105 TECH: iText Practice Activities: An African Climate,

Caffeine, Water Usage, Calculating Percentages, Energy Efficiency; iText Application Activities: Organizing Information in a Spreadsheet, Spreadsheet Features, The Cell Cycle, Charting Time, Exchange Rates, Parts of Speech, Using Two Software Applications at Once, Online Research, Using Software to Illustrate Information; iText Projects: Culture Chorale, School News, Consumer Comparisons, Science Fair, Truly a “Worldwide” Web

2. Insert data (text and numbers) in cells.

SWT: 96-97, 99, 103, 105 TECH: iText Tutorials: Creating and Entering Data in

a Table; iText Practice Activities: An African Climate, Travel in Europe and Asia, Population Statistics, Water Usage, Caffeine, Time Charts, Calculating Percentages, Measurements; iText Application Activities: Organizing Information in a Spreadsheet, Spreadsheet Features, The Cell Cycle






(Continued) 2. Insert data (text and numbers) in cells.

(Continued) TECH: Charting Time, Exchange Rates, Parts of

Speech, Using Two Software Applications at Once, Online Research, Using Software to Illustrate Information; iText Projects: Culture Chorale, School News, Consumer Comparisons, Science Fair, Truly a “Worldwide” Web

TMG: T40


a. Find and replace data

TMG: T41

b. Use AutoFill

SWT: 97, 99, 103 TECH: iText Practice Activities: Energy Efficiency,

Calculating Percentages, Measurements; Application Activities: Spreadsheet Features

c. Copy and move data

SWT: 97 TECH: iText Practice Activities: Travel in Europe and

Asia, Population Statistics, Calculating Percentages

TMG: T40-T41

d. Insert and remove rows; and

TECH: iText Tutorials: Inserting and Deleting Columns and Rows; Practice Activities: Population Statistics; iText Application Activities: Spreadsheet Features

TMG: T40-T41

e. Merge and split cells

TECH: iText Application Activities: Spreadsheet Features


a. Group worksheets

b. Add and delete worksheets

TECH: iText Practice Activities: An African Climate, Energy Efficiency, Population Statistics; Application Activities: Spreadsheet Features

TMG: T43

c. Move between worksheets

SWT: 93 TECH: iText Practice Activities: An African Climate,

Travel in Europe and Asia

d. Rearrange worksheets; and

TMG: 43






e. Name a worksheet.

TECH: iText Practice Activities: An African Climate, Travel in Europe and Asia, Energy Efficiency; iText Application Activities: Parts of Speech, Using Two Software Applications at Once, Organizing Information in a Spreadsheet, Online Research, The Cell Cycle, Charting Time, Exchange Rates, Spreadsheet Features, Using Software to Illustrate Information; iText Projects: Truly “Worldwide” Web, Science Fair, Consumer Comparisons, Culture Chorale

TMG: T40


a. Adjust column width and row height

TECH: iText Practice Activities: Measurements, Energy Efficiency; iText Application Activities: Parts of Speech

TMG: T41

b. Hide and unhide rows and columns

c. Sort worksheet data

TECH: iText Practice Activities: Population Statistics; iText Application Activities: Using Software to Illustrate Information

d. Use formulas

SWT: 100-103, 105 TECH: iText Tutorials: Formulas, iText Practice

Activities: Travel in Europe and Asia, Population Statistics, Measurements, Energy Efficiency, Calculating Percentages, Time Charts; iText Application Activities: Spreadsheet Features, The Cell Cycle, Exchange Rates; iText Projects: Truly “Worldwide” Web, Consumer Comparisons

TMG: T42

e. Insert functions; and

SWT: 102 TECH: iText Tutorials: Automatic Spreadsheet

Functions; iText Practice Activities: Travel in Europe and Asia, Adjectives, Adverbs, and Propositional Phrases, Calculating Percentages, Measurements; iText Application Activities: Parts of Speech; iText Projects: Truly “Worldwide” Web

TMG: T42

f. Troubleshoot formula and function errors.

SWT: 102 TECH: iText Practice Activities: Calculating

Percentages, Measurements







a. Format data

SWT: 94, 97 TECH: iText Tutorials: Automatic Spreadsheet

Functions; iText Practice Activities: Calculating Percentages, Energy Efficiency, Travel in Europe and Asia; An African Climate, Population Statistics; iText Application Activities: Spreadsheet Features, Using Two Software Applications at Once, Parts of Speech, Charting Time, Exchange Rates; iText Projects: Truly “Worldwide” Web, Consumer Comparisons; Culture Chorale

TMG: T40, T42

b. Change data alignment

TECH: iText Application Activities: Spreadsheet Features

c. Create and apply styles

d. Add headers and footers

TECH: iText Tutorial: Insert Headers, Footers, and Page Numbers

e. Set the print area

SWT: 98 TMG: T42

f. Adjust Page Setup

TMG: T42

g. Use the drawing toolbar; and

TECH: iText Tutorial: Using the Drawing Toolbar

h. Create and modify a chart.

SWT: 98-99, 105 TECH: iText Tutorials: Charts; iText Practice

Activities: Adjectives, Adverbs, and Prepositional Phrases, An African Climate, Population Statistics, Putting It All on the Line, Measurements; iText Application Activities: Charting Time, Software Features, Using Software to Illustrate Information, Online Research, Using Two Software Applications at Once, Organizing Information in a Spreadsheet; iText Projects: Truly “Worldwide” Web, Science Fair, Consumer Comparisons, Culture Chorale

V. DATABASE SOFTWARE


1. Discuss common uses for database software.

SWT: 107, 110-113, 119, 121 TECH: iText Tutorials: Creating a Query and

Applying Filters, Creating a Report






(Continued) 1. Discuss common uses for database software.

(Continued) TECH: iText Practice Activities: What’s an Angle?,

Calculating Percentages; iText Application Activities: Databases as an Organizing Tool

2. Explain the differences between database software

and spreadsheet software.

SWT: 107, 109, 91 TECH: iText Practice Activities: What’s the Angle?

3. Explain the factors that would determine whether to use database software or spreadsheet software.

SWT: 92, 109

W. PRESENTATION SOFTWARE The student will be able to:


a. Begin a new presentation.

SWT: 140-141, 143, 147, 151, 153 TECH: iText Tutorials: Using AutoContent Wizard;

iText Practice Activities: The Growth of the World Wide Web, LANS and WANS, Creating Multimedia on Computers, World War I, Solar System, Prime Factors, Biography; iText Application Activities: Creating a Slide Show Using Internet Searches, Career Information, Environmental Effects, Latin American Independence, Cultural Observations, Selective Breeding, Wartime Conditions, Book Report, Planetary Presentation; iText Projects: Folk Tales From Around the World, Game Design, Culture Chorale, Consumer Comparisons, Science Fair, World Reporting, Truly “Worldwide” Web

TMG: T46-T47

b. Apply a slide layout.

SWT: 145 TECH: iText Tutorials: Adding a New Slide; iText

Practice Activities: The Growth of the World Wide Web, Creating Multimedia on Computers, LANS and WANS, Biography, South Africa, What’s the Angle?, Solar System; iText Application Activities: Creating a Slide Show Using Internet Searches, Selective Breeding, Career Information, Environmental Effects, Book Report, Wartime Conditions; iText Projects: Folk Tales From Around the World, Game Design, Culture Chorale, Consumer Comparisons, Science Fair, World Reporting, Truly “Worldwide” Web

TMG: T47






c. Apply a design template.

TECH: iText Tutorials: Applying a Design Template; iText Practice Activities: Creating Multimedia on Computers, South Africa, What’s the Angle?; iText Application Activities: Creating a Slide Show Using Internet Searches, Environmental Effects, Book Report

TMG: T46

d. Format text.

TECH: iText Practice Activities: Creating Multimedia on Computers, The Growth of the World Wide Web, LANS and WANS, Solar System, World War I, South Africa, Biography; iText Application Activities: Latin American Independence, Cultural Observations, Wartime Conditions, Creating a Slide Show Using Internet Searches, Career Information, Environmental Effects, Book Report; iText Projects: Folk Tales From Around the World, Game Design, Culture Chorale, Consumer Comparisons, Science Fair, World Reporting, Truly “Worldwide” Web

TMG: T48

e. Add a graphic and manipulate its size and location.

SWT: 144 TECH: iText Practice Activities: What the Angle?,

Solar System, South Africa, World War I, Biography; iText Application Activities: Wartime Conditions, Creating a Slide Show Using Internet Searches, Environmental Effects, Career Information, Latin American Independence, Cultural Observations, Selective Breeding; iText Projects: Folk Tales From Around the World, Game Design, Culture Chorale, Consumer Comparisons, Science Fair, World Reporting, Truly “Worldwide” Web

f. Add bulleted items.

TECH: iText Practice Activities: Solar System, World War I, South Africa, The Growth of the World Wide Web, Creating Multimedia on Computers; iText Application Activities: Career Information, Book Report, Selective Breeding

g. Add slides to the presentation.

TECH: iText Tutorials: Adding a New Slide; iText Practice Activities: Biography, Solar System, Creating Multimedia on Computers, South Africa, World War I; iText Application Activities: Cultural Observations, Creating a Slide Show Using Internet Searches, Career Information, Environmental Effects, Book Report, Selective Breeding






(Continued) g. Add slides to the presentation.

(Continued) TECH: iText Projects: Folk Tales From Around the

World, Game Design, Culture Chorale, Consumer Comparisons, Science Fair, World Reporting, Truly “Worldwide” Web

TMG: T49

h. Delete, copy, and rearrange slides.

SWT: 142 TECH: iText Practice Activities: World War I; iText

Application Activities: Environmental Effects; iText Projects: Culture Chorale, World Reporting

TMG: T49

i. Prepare a notes page for each slide.

SWT: 142

j. Navigate through a presentation.

SWT: 142 TECH: iText Tutorials: Views in PowerPoint; iText

Practice Activities: World War I; iText Application Activities: Creating a Slide Show Using Internet Searches; TMG T48

k. Apply custom settings.

TECH: iText Tutorials: Adding Transitions, Sounds,

and Animations; iText Practice Activities: What’s the Angle?, LANS and WANS, Creating Multimedia on Computers, Biography, South Africa, World War I, Solar System; iText Application Activities: Creating a Slide Show Using Internet Searches, Latin American Independence, Cultural Observations, Wartime Conditions; iText Projects: Folk Tales From Around the World, Game Design, Culture Chorale, Consumer Comparisons, Truly “Worldwide” Web

TMG: T46-T47

l. Add sound to a presentation.

SWT: 144, 147, 151 TECH: iText Tutorials: Adding Transitions, Sounds,

and Animations; iText Practice Activities: Solar System, South Africa, World War I, Biography, Creating Multimedia on Computers; iText Application Activities: Latin American Independence, Cultural Observations; iText Projects: Folk Tales From Around the World, Game Design, Culture Chorale, World Reporting, Truly “Worldwide” Web






m. View a presentation

SWT: 142, 146-147, 151 TECH: iText Tutorials: View a Slide Show; iText

Practice Activities: The Growth of the World Wide Web, LANS and WANS, Creating Multimedia on Computers, Biography, South Africa, What’s the Angle?, Solar System, World War I; iText Application Activities: Creating a Slide Show Using Internet Searches, Wartime Conditions, Cultural Observations, Latin American Independence, Career Information, Environmental Effects, Book Report; iText Projects: Folk Tales From Around the World, Game Design, Culture Chorale, Consumer Comparisons, Science Fair, World Reporting, Truly “Worldwide” Web

TMG: T48

2. Demonstrate the ability to check spelling and grammar and use AutoCorrect.

TECH: iText Application Activities: Creating a Slide Show Using Internet Searches, Career Information, Environmental Effects, Book Report, Cultural Observations, Wartime Conditions; iText Projects: Game Design; Consumer Comparisons