Quick Links

Computer Tech 7 & 8 Scope and Sequence

Key:	I - Introduce
	R-Reinforce
	M- Master
VOCABULARY AND IDENTIFICATION
Use and understand basic computer related terms	CT 7	CT 8
cursor	M	M
scroll/drag/click	M	M
special keyboard keys	M	M
word processing	M	M
hardware	M	M
software	M	M
menu	M	M
web page	M	M
edit	M	M
internet	M	M
URL/web address	M	M
print	M	M
electronic mail	M	M
copyright	M	M
software piracy	M	M
text	M	M
graphic	M	M
file	M	M
cyberspace	M	M
login	M	M
multimedia	R	M
desktop publishing	I	R
copy	M	M
paste	M	M
cut	M	M
insert	M	M
save and save as	M	M
document	M	M
justification	M	M
open	M	M
user name	M	M
local area network vs wide are network	I	I
password	M	M

Identify basic computer hardware components	7	8
keyboard and mouse	M	M
monitor or screen	M	M
printer	M	M
file server	M	M
hard drive	M	M
storage devices	M	M
network cables	R	R
computer memory	R	R
peripheral devices	R	R


Demonstrate care and appropriate use of hardware	7	8
demonstrate appropriate care and use of hardware/peripherals	M	M
demonstrate appropriate care and use of storage devices and media	M	M
demonstrate appropriate care and use of CD ROM	M	M
demonstrate ability to turn computer off/on independently	M	M
understand safety and ergonomic issues	M	M


DEMONSTRATE BASIC COMPUTER MANAGEMENT SKILLS	7	8
Basic Usage	M	M
demonstrate ability to access and exit software	M	M
save files to appropriate location	M	M
demonstrate ability to manage files	M	M
use multiple storage locations	R	M
locate files in a directory	M	M
log in using username/password	M	M
demonstrate ability to organize file	R	M
use web browser	M	M
use navigational tools	M	M
use pull down menus	M	M
copy and paste a url/web address	R	M
use hyperlinks	R	M
transfer information/graphics from internet to local computer	M	M
search	M	M
search online reference resources	I	R
conduct categorical search	R	M
conduct keyword search	R	M
understand and identify file extensions	I	I

Evaluation/Assessment	7	8
select information appropriate to problem/user	R	R
assess validity of website	R	R


Keyboarding	7	8
touch type	R	R
7th grade 30 WPM	R	R
8th grade 40 WPM		R


Demonstrate appropriate legal/ethical conduct	7	8
demonstrate responsible use of computers	R	R
demonstrate appropriate computer etiquette	R	R
respect the privacy of all users per rules in OHS Acceptable User Policy	R	R
obey copyright laws	R	R


SOFTWARE SPECIFIC SKILLS
Word Processing	7	8
Create and save a new document	M	M
identify intended use	M	M
use save and save as	M	M
Open, view, and print documents	M	M
use print preview	M	M
print entire file or selected parts	M	M
different views	M	M
select text	M	M
show/hide formatting marks	I	I
understand toggle commands	I	I
undo/redo/repeat	M	M
Format documents	M	M
justify text	M	M
select font style and size	M	M
Change font color and style	M	M
Use different underline styles and font effects	R	R
highlight text	M	M
line spacing/before & after spacing	R	M
use format painter	I	R
understand styles and apply Quick Styles	I	R
Create a new quick style	I	R
change theme	I	R
clear formatting	R	R
set paragraph indents	R	M
utilize the ruler	I	R
change vertical alignment	I	R
select page orientation	M	M
set margins	M	M
set and clear tabs & different tab alignments	R	R
use headers, footers & pagination	R	R
hanging indent	R	R
Edit text	M	M
change font style & size	M	M
cut,copy,paste & delete text	M	M
use office clipboard	I	R
create and modify bulleted and numbered lists	R	R
create an outline numbered list	R	R
organize a document in outline view	I	R
using spell check	M	M
use the thesaurus	R	M
insert symbols	I	R
use find & replace	R	M
use the Go To command	I	R
use document statistics	I	R
use autocorrect, autoformat, quick parts, autocomplete	I	R
insert automatic date/time	I	R
Use desktop publishing techniques	R	R
insert and format graphics	M	M
create columns	R	M
Add borders and shading	R	M
understand objects and how to use them in documents	R	M
insert, resize, and move inline objects	R	M
change inline object to a floating object	I	R
recolor graphics	I	R
draw and modify shapes	I	R
set transparent color to a graphic	I	R
add text to drawings	I	R
create callouts	I	R
create and modify SmartArt	I	R
tables	R	M
use text boxes	R	M
insert clipart and pictures	M	M
type reports	R	M
generate letters	R	M
add entries to a bibliography/works cited	R	R
layer graphics	I	R
group graphics	I	R
type memos		I
type various business documents in correct format		I
create a letterhead		I
type table of contents		I
type title page		I

Use spreadsheet programs	7	8
Create and save spreadsheets		I
identify intended use		I
open and existing workbook		I
save a workbook		I
specify data organization		I
determine columns and rows		I
identify and use active cell		I
select cells and enter data		I
find and replace data		I
set cell attributes		I
create simple calculation formulas		I
enter and edit data		I
Retrieve data		I
sort data		I
create various types of charts		I
preview & print spreadsheet		I
print formulas		I
Edit data		I
insert column or row		I
delete column or row		I
change column width and row height		I
position data within a cell by aligning, wrapping, rotating, and indenting		I
change the appearance of cells using fonts, font sizes, font styles, colors, and borders		I
designate the number format used for data stored in a cell		I
Use the format painter to copy formatting from one cell to another		I
apply and clear cell styles		I
Find and replace cell formats		I
copy and move date to other cells		I
use the drag and drop method and auto fill options to add data to cells		I
insert/delete rows, columns, and cells		I
freeze panes in a worksheet		I
split a worksheet window		I
check spelling in a worksheet		I
prepare a worksheet for printing		I
insert headers and footers		I
enter and edit formulas		I
distinguish between relative, absolute, and mixed cell references		I
use the point and click method to enter formulas		I
use the sum button to perform calculations		I
Use statistics bar to preview data		I
display formulas instead of results		I
preview calculations		I
identify parts of a function		I
enter formulas with functions		I
use functions to solve mathematical problems		I
use functions to solve statistical problems		I
use functions to solve financial problems		I
use logical functions to make decisions with worksheet data		I
use functions to insert times and dates in a worksheet		I
use text functions to format and work with cell contents		I
use fill down/across		I
use autofilter to display only specified data in a worksheet		I
apply conditional formatting to highlight data		I
hide worksheet columns and rows		I
insert a shape in a worksheet		I
insert a smartart graphic in a worksheet		I
use a template to create a new workbook		I
insert a hyperlink in a worksheet		I
save a workbook in a different file format		I
insert, edit, and delete comments		I
use the research task pane		I
move between worksheets in a workbook		I
rename worksheets		I
change the color of sheet tabs		I
reposition worksheets		I
high and unhide worksheets		I
insert and delete worksheets		I
create cell references to other worksheets		I
create 3-d reference formulas		I
print all or part of a workbook		I
arrange multiple workbooks in the program window		I
move and copy worksheets between workbooks		I
save updated spreadsheet		I
identify the purpose of charting worksheet data		I
identify the types of charts you can create in Excel		I
Create a chart embedded in a worksheet		I
move a chart to a chart sheet		I
update a data source		I
select chart elements		I
choose a chart layout and style		I
create a 3-d chart		I
display or hide chart elements		I
format and modify a chart		I
edit and format chart text		I
change the chart type		I

Use multimedia software	7	8
use graphic tools	R
edit graphics	R
evaluate appropriate use of multimedia	R
incorporate clip art, digital pictures, and graphics	R
reorder slides, sort slides and create transitions	R
create a slide show	R
create animation	I
use slides and outline tabs	I
use notes pane	I
change layout	I
delete a slide	I
print a presentation	I
insert headers and footers in a slideshow and notes	I
apply themes	I
use the slide master	I
use the notes and handout master	I
edit pictures	I
add slides	I
find and replace text	I
add text to slides	I
add notes to slides	I
change alignment, spacing, case, and tabs	I
work with bullets	I
change font attributes	I
check spelling, style and usage	I
format slides	I
add clip art and sounds to slides	I
insert hyperlinks	I
apply custom animations	I
apply slide transitions	I
insert SmartArt graphic	I
convert text to a SmartArt graphic	I
change the style of a SmartArt Graphic	I
Add and format an organization chart	I
Enter text into a SmartArt graphic	I
Create and format WordArt	I
build and format charts	I
create a table	I
modify a table's style and layout	I
draw, select, manipulate, and format an object	I
scale and size an object	I
copy, move, and group objects	I
create a text box on a shape	I
animate shapes	I
order visual elements on a slide	I
insert objects on a slide	I
add a header or footer	I
record narration	I
record audio	I
insert audio and play through slideshow	I
record video	I
transfer video files from device	I
insert video into slideshow	I
format slideshow as a video	I
present slideshow to audience	I

Adobe Photoshop
open picture	I
crop picture	I
resize picture	I
remove color (chroma key)	I
set a transparent background	I
save a picture as a psd, jpeg, gif	I

Google	7	8
access and utilize Gmail	I	R
access and utilize Google Drive	I	R
share a file	I	R
collaborate	I	R
create a document	I	R
create a spreadsheet	I	R
create a presentation	I	R
create a drawing	I	R

Schoology	7	8
Login and join course(s)	I	R
access assignments	I	R
access data files	I	R
access course content	I	R
navigate around the interface	I	R
submit assignments	I	R
create comments/discussion	I	R

Computer Coding	7	8
What is computer science?	I	R
What is a computer scientist?	I	R
Being a responsible computer scientist	I	R
Applications of computer science	I	R
Basic understanding of binary	I	R
How to debug	I	R
How the Internet works	I	R
Programming concepts	I	R
Sequencing	I	R
Loops	I	R
Conditionals	I	R
Functions	I	R
Functions with parameters	I	R
Variables	I	R
Computational Thinking	I	R
Decomposition	I	R
Patterns	I	R
Abstraction	I	R
Algorithms	I	R

OneNote	7	8
Creating a new notebook		I
working with pages and subpages		I
deleting pages		I
moving pages		I
typing into pages		I
inserting pictures		I
working with pictures		I
inserting symbols		I
using mathematical formulas		I
creating linked notes		I
using ribbon tools		I
working with text boxes		I
saving as a pdf		I
writing in pen and converting to type		I

Video	7	8
Create a project in Premiere Elements		I
Choose project settings		I
import source clips		I
place clips on timeline		I
edit clips on timeline		I
chroma key out color		I
layer video tracks		I
insert a title		I
export to mp4		I
create menu markers for scenes		I
create menu		I
create dvd		I

Internet/Online Safety	7	8
Review personal media habits	R
respecting others works	R
creative rights and responsibilities	R
copyright, piracy, plagiarism	R
safe online talk	R
inappropriate and risky behavior	R
aspects of online talking and messaging	R
benefits and risks of presenting identities online	R
possible outcomes associated with online profiles	R
judge whether certain ways people present themselves online are harmless or harmful	R
analyze opportunities and limitations for expression in virtual worlds	R
learn they have a digital footprint		R
their online information can be searched, copied, and passed on and seen by large, audience and it can persist		R
people's online information can be helpful or harmful to their reputation and image		R
what do they want their digital footprint to look like in the future		R
understand how the ease of publishing on the Internet affects how much you can trust the content of some sites		R
learn criteria to help evaluate websites		R
apply the criteria to a site to determine how trustworthy and useful it is		R
reflect and identify digital drama and consequences		R
analyze online bullying behaviors that cross the line		R
learn about various ways cyber bullying occurs		R
adopt a point of view of teens who have been cyber bullied and offer solutions		R
identify points required for a creative work to fall under fair use		R
understand the value of fair use by reworking, remixing copyrighted material		R

Desktop Publishing	7	8
publication terminology	I
choose a template	I
understand window and task panes	I
save a publication	I
modify a publication	I
create a publication	I
insert design gallery objects	I
print a publication	I
use guides	I
enter text	I
insert pictures/clip art/word art	I
work with objects	I
create columns	I
create double sided print document	I

Animation	7	8
what is animation		I
how is animation create		I
create a object and animate the object		I

Career Exploration	7	8
Create Log in for Career Information System		I
Create a portfolio		I
Learn about self		I
Research career options & clusters		I
Interest profile to match careers		I
Identify skills enjoyed		I
Identify work related needs and view matching occupation		I
Complete Assessment		I
Goal Setting		I
Make plans for future		I