Transcript Computer Applications Skills Assessment

Computer Applications
Skills Assessment
Review
Created by Doug Schneider
JCPS Acceptable Use
Agreement
• Jefferson County’s web page is
www.jefferson.k12.ky.us
To use the computer is a privilege; not a right.
• Students agree to use the school network
appropriately as outlined in the use agreement.
• Students may use the internet for research use,
not playing games, sharing work, talking to oneanother on the internet, checking out my-space
pages.
Operating System
• The operating system (OS) is the system
software responsible for the direct
control and management of hardware and
basic system operations, as well as running
application software such as word
processing programs and web browsers.
• This program operates the computer!
Very important!
Rich Text Format
• Rich text format is a standard formalized
by the Microsoft Corporation for
specifying formatting of documents.
• We use RTF format when we save word
processing documents and then it can be
used/opened on a variety of computers and
applications.
• For example, if you have an Apple
computer at home and want to forward
your portfolio piece from home to a
computer at school, you can save it as an
RTF.
Database
• A database is a collection of related
information organized for rapid
search and retrieval.
• This program allows you to store and
manipulate data.
• The Microsoft software for
databases is called: ACCESS
Kentucky House Bill 91
• House Bill 91, often referred to as the “Bullying Bill,” (now
codified as KRS 158.156) was passed during the 2008
legislative session. The legislation requires the Kentucky
Department of Education to provide guidance to local school
districts to assist with the implementation at the local
level. Additionally, the legislation requires that “model
policies” (bullying, code of conduct, and supervision of
students) be provided to school districts. The Dropout
Prevention Branch in KDE has prepared a guidance document
for HB 91, including a set of model policies to assist schools
with the implementation of the new legislation.
Cyberbullying
• "Cyberbullying" is when a child, preteen or teen is
tormented, threatened, harassed, humiliated,
embarrassed or otherwise targeted by another
child, preteen or teen using the Internet,
interactive and digital technologies or mobile
phones. It has to have a minor on both sides, or at
least have been instigated by a minor against
another minor. Once adults become involved, it is
plain and simple cyber-harassment or
cyberstalking.
Sex-ting
• Sexting is sending sexually explicit
messages via cell phone or instant
messenger. As technology has
advanced and cell phones have the
capability to record and send photos
and video, the practice of sending
suggestive and explicit pictures has
increased, especially among teens.
Sex-ting
• 20% of teens (ages 13-19) and 33% of
young adults (ages 20-26) have shared
nude or semi-nude pictures of themselves
either via text or by posting online. Teen
girls are slightly more likely to do this
than boys and 11% of the young teen girls
(ages 13-16) admitted to sending
suggestive photos of themselves.
Example of Table
Fern Creek Traditional High School Tone Schedule
7:40 – 8:35
1st Period
8:40 – 9:29
2nd Period
9:34 – 10:23
3rd Period
10:28 – 11:17
4th Period
11:22 – 12:32
5th Period
11:22 – 11:42
1st Lunch
11:47 – 12:07
2nd Lunch
12:12 – 12:32
3rd Lunch
12:37 – 1:25
6th Period
1:30 – 2:20
7th Period
Example of a Record
Name:
Ace Student
Address:
123 Student St.
Date of Birth:
Middle School:
High School:
Grade:
4/1/90
Thomas Jefferson
Fern Creek H.S.
9
High School GPA: 3.63
Specific Alignment (W)
•
•
•
•
•
Found on your formatting toolbar
Left Align
Center
Right Align
Justify
Headers/Footers
(W/E/P)
• Adds text that will either print at
the top or the bottom of every page
of your document.
Formatting Characters
• The purpose of these are to show the user how
many times they spaced, inserted breaks, pushed
enter, etc.
• You don’t see this on the page because they are
invisible even though we know we did them.
• If you click on the character button on your
toolbar, it will show you with a mark how many
times you pushed enter, a dot for how many times
you spaced, and will say page break if you inserted
one.
Wizard/ Assistant
• Allows the user to get help whenever
needed.
• Often found under the help menu.
Shareware
• Copyright software that can be
freely copied for a limited period of
time; however if you decide to keep
it, you must pay a fee to the author.
• Shareware is generally inexpensive as
compared to commercial software.
What is a Hacker?
• A person who gains access to another
person’s computer or a computer
system WITHOUT permission.
• Usually a hacker intents to destroy
or delete data/files or modify
computer codes.
Copyright
• The sole right to reproduce, publish, and
sell a literary or artistic work.
• You cannot copy someone else’s work
without the permission of the owner.
• You can cite the source and give the owner
credit.
• When a teacher makes copies from an
internet source for his or her class to use
as a reference it is called Fair Use.
Forms of Telecommunication
Collaborations
• Wiki-A wiki is a website that allows the easy[1]
creation and editing of any number of interlinked
Web pages, using a simplified markup language or
a WYSIWYG text editor, within the
browser.[2][3] Wikis are typically powered by wiki
software. Wikis are often used to create
collaborative websites, to power community
websites, for personal note taking, in corporate
intranets, and in knowledge management systems.
Cont.
• Google Docs - Google Docs is a free,
Web-based word processor,
spreadsheet, presentation, and form
application offered by Google. It
allows users to create and edit
documents online while collaborating
in real-time with other users.
Cont.
• Blogs - Many blogs provide commentary or
news on a particular subject; others
function as more personal online diaries. A
typical blog combines text, images, and
links to other blogs, Web pages, and other
media related to its topic.
• JCPS Online is what we use to
communicate!!!
Citing Electronic Pieces
• Must have:
– Author or originator.
– Title of item.
– [Online] Date of document or download
or accessed (day, month, year).
– URL <http://address/filename>.
WAN/LAN
• A WAN is a wide area network that
links computers and networks in
different geographic areas.
• A LAN is a local area network that
links computers or networks in a
smaller geographic area such as a
room or building.
Flaming
• When using your email or instant
messaging and you are angry, you
• TYPE IN ALL CAPITAL LETTERS and
may add some **&^()^%$#!!!
Excel Screen (E)
• Rows are numbered and go across the
screen.
• Columns are letters and go up/down
on the screen.
• If you need to format an entire row,
you select the specific row number.
• If you need to format an entire
column, you select the column label or
letter.
Correct Formulas (E)
• Formulas in Excel ALWAYS begin with an equal (=)
sign!
=A1+B1
=A2*H7
ARGUMENT
=B7/B3
=H7-I7
=SUM(A2:A19)
The range that is inside the parentheses is
called the argument!
Functions (E)
• Excel has several built-in functions
that save you time in calculating data.
• Select your function from the list.
Large Ranges of Data (E)
• If you have a large range of data, the
easiest way to select it would be to:
– Position your active cell to the starting
point of the range.
– Next using your scroll bars, scroll so you
can see the end of the range.
– Hold your shift key down and then click
on the last cell of the range.
Sorting Data (E)
• Remember to select all of the information in a row
so you keep the information that belongs
together, TOGETHER!
• Use the DATA drop-down menu, then SORT.
Header Row
Fill Feature (E)
• In Excel you can copy the contents of one
cell to one or more cells. You can do this
by using the Fill Handle in the active cell.
• Make the white plus go to black when you
move the mouse to the bottom right-hand
corner.
• Drag over the range (group of cells) you
want to fill.
• Can also be found on the EDIT menu.
Fill Feature (E)
• If you need to fill text or a formula in a column,
you can use your fill handle on the active cell or
you can use the EDIT drop-down menu and the
fill command to fill down.
Excel Terminology
• Examples of Logical Operators are And, =,
Greater than and less than <> symbols
• Examples of Functions are Sum, Average,
Maximum, Minimum
• Absolute Value does not change when it is
being copied down a row or column.
• Relative cells will change as they are being
copied.
Format Column Width (E)
• To format column width, you can position your
pointer between the column labels until you get
arrows pointing in two directions and then drag
bigger or smaller.
• You can also use the FORMAT drop down menu
and selection COLUMN and then WIDTH.
Charts (E)
•
•
•
•
Bar Charts
Column Charts
Pie Charts
Line Charts
Maximum
Minimum
90
80
70
60
50
40
30
20
10
0
East
We s t
N o rt h
1s t
Qtr
2 nd
Qtr
3 rd
Qtr
4th
Qtr
Chart Options (E)
• A legend is a part of a chart or graph
that identifies the patterns or colors
that are assigned to the data series
or categories in a chart.
Chart Options (E)
• Once a graph or chart is created and you need to
go back to edit or add features, you can go to the
CHART menu drop-down and make changes.
–
–
–
–
Change location of the chart
Change the type of chart
Add the X-axis or Y-Axis data
The Unit and Step size effects the size of the graph
Presentations (P)
• Presentations can contain:
–
–
–
–
Multiple slides
Information about any topic
Pictures or graphics
Music and/or sound
Insert Pictures in
Presentations (P)
• When inserting a picture found on
the internet, you must cite the
picture on the page in which it
occurs.
Hyperlink
• When you want a picture, word, or symbol
to connect you to internet when you click
it, you must hyperlink it.
• Highlight the item you want to hyperlink,
right click, click on hyperlink, type in the
address you want to hyperlink it to.
• This will allow you to use resources within
your document on the internet.
Adding Music to a
Presentation (P)
• How much music can you legally use
in a Presentation or Multimedia
product?
– 10 percent or no more than 30 seconds.
Master Slides (P)
• The slide master controls certain text
characteristics — such as font type, size, and
color — called "master text," as well as background
color and certain special effects, such as shadowing
and bullet style.
• The slide master contains text placeholders and
placeholders for footers, such as the date, time,
and slide number.
• When you want to make a global change to the
look of your slides, you don't have to change
each slide individually. It will change all the slides!
Adding a Text Box
• When adding a textbox, use the icon
on your drawing toolbar or use the
INSERT menu and select a textbox
A—----------------------------
Breaks
• If you want your information to go to
another page you Insert a Page Break.
• If you want only a specific part of your
information or data changed, it is called a
Section Break.
• Highlight only the section and change it,
not the entire document!
Inserting Date/Time (W)
• You can insert several date formats into a
WORD document by choosing the INSERT
drop-down menu and selecting DATE AND
TIME.
Updates
Automatically
Indentation
•
Hanging Indent – First line is over to the left, and the rest
of the lines are moved over to the right a half inch.
Example
Schneider, Doug. “Weightlifting is Wonderful when you use it properly.” McGraw-Hill.
July 14, 2006.
•
First line Indent – the First line is moved over the right a half
inch, and the rest of the lines are moved over to the left.
Example
The river is a beautiful thing to see when people don’t pollute it. I’m so glad we are
working so hard on making the world a better place for our future generations. Throwing
away trash and recycling paper, plastic, and cans is a huge positive for the planet!
Page Setup (W)
• In order to change the page orientation and
margins, you can go to the FILE drop-down menu
and select PAGE SETUP.
Page Orientation
Alignment Example
Name
Quiz Grade
Doug
92.14
James
42.19634
Class
English
Survey of Social Science
• Name – left Aligned
• Quiz Grade – decimal aligned
• Class – right aligned
Columns (W)
• To put a document into columns, use:
– Icon on the Standard Toolbar
– FORMAT drop-down menu
• Columns
Create a Header/Footer
(W)
• Select VIEW from the drop-down
menu
• Headers are at the top of the
document
• Footers are at the bottom of the
document
Switch between header and footer
Wrapping Text (W)
• In order for text to
wrap or flow around a
picture you must
format the picture.
• Select the graphic you
want to wrap text
around and then either
using the FORMAT
drop-down menu or
right mouse click.
Wrapping Text (W)
• Select the type of wrapping.
Scripts
• Subscripts – The number goes below the
text. (Remember- The subway goes
underground, submarines are underwater.
MgSO4)
• Superscripts – the number goes above the
text. (Remember- Superman flies up in
the air. A2+B2=C2.)
Phishing
• The act of sending an e-mail to a user falsely
claiming to be an established legitimate
enterprise in an attempt to scam the user into
surrendering private information that will be used
for identity theft. The e-mail directs the user to
visit a Web site where they are asked to update
personal information, such as passwords and
credit card, social security, and bank account
numbers, that the legitimate organization already
has. The Web site , however, is bogus and set up
only to steal the user’s information.
E-mail
• Don’t forward chain letters
• Use standard font and size
• Feel in the Subject for the reader to
identify what they are looking at.
• Don’t open e-mails from mysterious
sources. They could have viruses attached
to them.
• Don’t use e-mail as a way of bullying
people.
Mail Merge
• This allows the user to
send out information,
documents, memos, to
numerous people with
a few easy steps!
Print Queue
• This shows the user that his or her
document is not printing.
• It shows where it is printing and which
document is printing.
• It is located on the Taskbar at the bottom
near the clock. The icon looks like a little
printer.
Removable Storage
Devices
•
•
•
•
Thumb Drive
Flash Drive
Memory Stick
USB Drive
Internet
• Web Browser - A web browser is a software application
which enables a user to display and interact with text,
images, videos, music and other information typically
located on a Web page at a website on the World Wide Web
or a local area network.
• Proxy - A proxy server forwards requests between a web
browser and the requested website.
• Domain - strings of letters used to name organizations and
computers and addresses on the internet
• URL – Universal Resource Locator (Address Bar)
Template
• If you frequently create documents that contain
a lot of specialized formatting but don't always
contain the same text, you can save yourself a
considerable amount of time if you create Word
templates to use as the basis of future
documents. By using Word’s template feature, you
can focus your concentration on the content of
the document and leave the formatting up to the
template.