Coats - Erwin Middle

Responsible and safe use of online resources
Using Copyright and Fair Use Guidelines
Refining application skills
Using formulas in a spreadsheet
Using search strategy with two or more criteria in a database
Increasing productivity and accuracy in keyboarding
Using word processing, spreadsheet, database, and multimedia for assignments in all subject areas
Locating and retrieving information using telecommunications
Evaluating resources and information for accuracy and usefulness
Selecting and using a variety of technology tools

Wanna Play 20 Questions?

Question 1
Your Language Arts teacher assigns a different research topic for each student. You get busy talking with a friend about her problems and forget to write your two-page report for homework. To save time, you decide to copy and paste some information from the Internet on your topic, and turn in a completed paper the next day. What is this act called? (Hint: starts with a "p" and ends with an “m”).

Question 2
If you are going to create a newsletter for your school, which software function allows you automatic formatting of columns? (Hint: it's not word processing, but the other one - the fancier, more advanced program).

Question 3
Spreadsheets have columns and rows that consist of repeated cells. Which are the vertical and which are the horizontal cells? (Hint: rows are kinda lazy, but columns stand nice and tall).

Question 4
You have typed a 25-page science report and realize that you misspelled the word "hornet" with "hornett". What is the simplest way to fix this mistake? (Hint: let the computer locate the places you used “hornett”, then tell the computer to r _ _ _ _ _ _ with the correct spelling).

Question 5
What do you use as a place to cite all the resources you used in your report? (No, it's not a biography, but you're getting close!)

Question 6
True or False: When you use Spell-Check after typing a report, you can expect that all misspelled words will be found. (Hint: Spell-Check is your computer's dictionary. Does your computer's dictionary have ALL words in it?)

Question 7
What is the ONLY software that is totally FREE to anyone? (Hint: It's John Q's last name).

Question 8
Do you have a habit of forgetting your password? If so, what can you do to put it in writing and keep it in a safe place? (Hint: Write a sentence that has your password secretly written into the words. Your secret code! Try it now.)

Question 9
Multimedia can be written multi and media, which means "more than one type of media". Suppose you use music and a video clip in your PowerPoint presentation. Did you use multimedia? Suppose you used animation and music. Did you use multimedia? (Hint: the answer is positive in nature).

Question 10
Type 32 . Type H20.
The first one above reads 3-squared and is a Superscript. The second one goes down and reads H20. What is the formatting in H20 called? (Here's a hint to remember this: Superman flies up, so Superscript flies up. Submarines go down, so subscript goes down.)

Question 11
When you're surfin' the Internet and come across blue text that is usually underlined, what do you do? (Hint: Stay where you are, or click and move to another site, so what is the blue text called?).

Question 12
When you are in a Spreadsheet or Database, which of the following is in "descending order": 5, 4, 3, 2, 1 or 1, 2, 3, 4, 5 (Hint: Descending the stairs means you are going down the stairs. Ascending the stairs means you are going up the stairs).

Question 13
When you are searching the Internet, what is the first page of a website called? (Hint: Where do you go at night when you are tired and want to sleep in your own bed?) ________ page

Question 14
You used a spreadsheet to keep up with the statistics for each member of your baseball team. At the end of the season you want to create a visual of your statistics, what would you use? (Hint: there are several kinds of these).

Question 15
In continuation of the question above, what would be the best chart to use to show a "comparison" of the statistics for the 10 boys on the team? (Hint: could be vertical or horizontal).

Question 16
In continuation of the question above, what would be the best chart to use to show the percentages of the runs-batted in? (Hint: round shape).

Question 17
In continuation of the question above, what would be the best chart to use to display a 5-year period of statistics? (Hint: dot.dot.dot.dot...)

Question 18
Can you say the alphabet backwards? Good for you! If you can, in what order are you saying the alphabet? (Hint: are you going forward or backwards - are you going up or down - are you ascending or descending?)

Question 19
The most common example of a database is a phonebook. It contains an enormous amount of information in an orderly manner. In a computerized database, information can be filtered in a number of ways. For instance, if you are looking in a database for foods that contain less than 500 calories, what criteria would you use? Would foods with 500 calories be included in your search? What "connector" would be used for this search? (Hint: you want less than 500 calories). Choose: <500 or >500

Question 20
Let’s look at the database question above. If you are looking for foods that have a nutritional value of Vitamin A with at least 15 grams per serving, how would you search the database? (Hint: at least does NOT mean less than).

Answers:
1. Plagiarism
2. Desktop Publishing
3. Vertical columns and horizontal rows
4. Replace
5. Bibliography
6. False
7. Public domain
8. Write a sentence that has your password in it.
9. Yes
10.Superscript goes up and subscript goes down.
11.Link or hyperlink
12.Descending goes down 5,4,3,2,1
13.Homepage
14.Chart (sometimes called a graph)
15.Comparisons are always bar charts
16.Percentages are always pie charts (sometimes called circle graphs).
17.Line charts are across extended periods of time
18.Descending is going backwards and ascending is going forward
19.You are looking for less than 500 calories which would be using the connector < and 500.
Answer <500
20.At least 15 grams would be to search for foods that contain 15 grams or more.

Click here to practice your telecommunications skills:

http://www.catawba.k12.nc.us/pages/sites/edwebsites/computerskills/quizzes/telecommqz.htm

Click here to practice spreadsheets and databases:

http://www.catawba.k12.nc.us/pages/sites/edwebsites/computerskills/newtest.htm

NC 8th Grade Technology Proficiency Standards

The following Technology Proficiency Standards are to be used to determine technology literacy. Eighth grade students must meet seven or more of these standards to be identified as proficient.
Note: The bulleted list beneath each standard are suggestions only; the bulleted lists are not all inclusive.

PROFICIENCY 1:
Apply strategies for identifying and solving routine hardware and software problems that occur during everyday use.
The student demonstrates proficiency in recognizing and describing strategies for identifying, solving, and preventing minor hardware and software problems.
The student demonstrates proficiency in investigating, discussing, and explaining why computers, networks, and information must be protected from viruses, vandalism and intrusion, both malicious and mischievous.
The student demonstrates proficiency in modeling ethical behavior relating to security, privacy, passwords, and personal information, and recognizing possible consequences of misuse.
PROFICIENCY 2:
Demonstrate knowledge of current changes in information technologies and the effect those changes have on the workplace and society.
The student demonstrates knowledge of new technologies as they continue to evolve.
The student demonstrates knowledge of information technologies and their effects in society.
The student demonstrates knowledge of the use of information technologies and their effects in the workplace.
PROFICIENCY 3:
Exhibit legal and ethical behaviors when using information and technology, and discuss consequences of misuse.
The student demonstrates proficiency in respecting the work of others in the online community (copyright, Fair Use, attributions).
The student demonstrates proficiency in using technology safely in the online networking community.
The student demonstrates knowledge of the consequences of the misuse of information technologies.
PROFICIENCY 4:
Use content-specific tools, software, and simulations (e.g., environmental probes, graphing calculators, exploratory environments, Web tools) to support learning and research
The student demonstrates proficiency in using databases and why they are used in North Carolina(e.g., schools, government, business, and science) to collect and organize information.
The student demonstrates proficiency in using spreadsheets to organize, report, and display data and why they are useful mathematical tools.
The student demonstrates proficiency in the selection, organization, and presentation of contetnd area information from the Internet for a specific purpose.
The student demonstrates proficiency in selecting and using responsibly a variety of computing devices Ie.g., probewar, handhelds, digital cameras, scanners) to collect, analyze and present content area information.
The student demonstrates proficiency in using evaluation tools to select Internet resources and information for contend and usefulness in content area assignment.
PROFICIENCY 5:
Student creates multimedia curriculum projects.
The student demonstrates proficiency in using external computer devices and tools.
The student demonstrates proficiency in recalling multimedia tools and peripherals throughout the technology curriculum.
The student demonstrates proficiency when working with external computer devices and tools when working alone and when collaborating in groups.
PROFICIENCY 6:
Student presents multimedia curriculum projects.
The student demonstrates proficiency in using multimedia presentation resources to communicate to internal and external audiences.
The student demonstrates proficiency in determining the appropriate communication resources to use with each product and audience.
The student demonstrates proficiency in communicating curriculum concepts.
PROFICIENCY 7:
Collaborate with peers, experts, and others using telecommunications and collaborative tools to investigate curriculum-related problems, issues, and information, and to develop solutions or products for audiences inside and outside the classroom.
Student demonstrates proficiency in the appropiate use of various Web 2.0 collaborative tools (wikis, blogs, etc).
Student demostrates proficiency in applying appropriate technology tools create products or sulutions.
Student demonstrates proficiency using technology in the collection and analysis of data as they solve problems and complete investigations.
Student demonstrates proficiency in the appropriate use of online communication tools as they collaborate with others.
PROFICIENCY 8:
Student selects technology tools that enhance the efficiency and output of curriculum projects.
The student demonstrates proficiency in determining the appropriate tools and technology resources to solve problems.
The student demonstrates proficiency in accomplishing multiple tasks and problems with the appropriate tools and technology resources.
The student demonstrates proficiency in problem solving and multi-tasking by using the correct technology tools and resources.
PROFICIENCY 9:
Demonstrate an understanding of concepts underlying hardware, software, and connectivity and of practical applications to learning and problem solving.
The student demonstrates proficiency in selecting and using a variety of technology tools to collect, analyze, and present information.
The student demonstrates proficiency in identifying and discussing terms/concepts associated with safe, effective and efficient use of the Internet (e.g., password, firewalls, Spam, security, Fair Use, AUP/IUPS).
The student demonstrates proficiency in the use of technology terms/concepts to explain the strategies used to collect, organize and present findings for assignment/projects.
The student demonstrates proficiency in choosing appropriate techology resources to solve problems and complete assignments.
The student demonstrates proficiency in identifying, discussing and using online collaborative tools (e.g., email, surveys, videoconferencing) to collect data for content area assignments/projects.
PROFICIENCY 10:
Research and evaluate the accuracy, relevance, appropriateness, comprehensiveness, and bias of electronic information sources concerning real-world problems.
Student demonstrates proficiency in identifying appropriate online resources for assignments or project-based activities.
Student demonstrates proficiency in evaluating online information resources (accuracy, points of view, bias, etc.).
Student demonstrates proficiency in identifying information in online resources that is relevant to research questions or problems to be solved.