Miss Witkowski's Computer Science Discoveries Class: May 2014

Monday, May 26, 2014

Tuesday, June 3rd- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/05/monday-may-27th-8th-grade-review-day-1.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/05/monday-may-27th-7th-grade-review-day-1.html

Spreadsheet Review

Spreadsheet Review: Review the following @@ PowerPoints @@ in the Spreadsheet folder and fill in the blanks or answer the questions.

Look at the Review for Test Spreadsheet Vocabulary PowerPoint to fill in the blanks.

Descending order- is ____________ to __________ sort order or 100 to 1 order.

Relative cell referencing- _____________ formulas and automatically ____________ to correct cell range.

In contrast, an __________________ cell reference does not change when its formula is copied and pasted to other cells.

Which symbol is used for absolute cell references? ______________

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

___Go to Types of Charts PowerPoint and look on slide 3 to fill in the blanks.

_____________________Chart- comparisons

Stacked Bar Chart - charts each group’s ________________________________to the whole.

Line Charts show ________________________ or changes in data over time.

XY Scatter Charts are used to indicate the __________________________ of two or more sets of data.

Pie Charts answers the question “What is the ________________________of each part to the whole?”

Exploded Pie Chart is an ___________________________ pie chart.

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

___Look at the 4.01 Advanced Functions document to answer the questions and fill in blanks.

Which function allows the computer to insert dates according to your instructions? ___________

VLOOKUP- Looks for a value in the ___________________________ column of a table, and then gives you a value in the ________________________row from the column specified.

Which function counts the number of cells within a range when given specific conditions?

To create a list: Type and highlight the __________________ you want to use. Next you will ________________________ the list in the name box (beside the ____________________Bar) then ___________________________ the cell that you want the drop-down list to appear in. Then do to _____________, Validation, Allow: List, and then source: ____(the name of your list)

Which function helps you control the kind of info that is entered into a worksheet? A drop-down list would be an example because you could only choose information that was entered into the list. ___________________________________

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

___Look at the Excel if statements explained PowerPoint

Write the IF statement for IF A2 is equal to “Feline”, write “Cat” in B2, otherwise, write “Amphibian”
___________________________________________________________________________

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Play the SCATTER GAMES on the quizlet sites
____SCATTER http://quizlet.com/4256873/spreadsheet-vocabulary-flash-cards/
____SCATTER http://quizlet.com/5002039/spreadsheet-terms-flash-cards/
____SCATTER http://quizlet.com/834955/cai-401-ss-components-flash-cards/
____Get 100% _http://www.teach-ict.com/gcse_new/spreadsheets/spreadsheets/miniweb/pg3.htm
____SCATTER http://quizlet.com/3972846/ms-wrights-bct-obj-5-flash-cards/
_____ Hangman game get 22 out of 25 correct http://www.quia.com/hm/174125.html
____SCATTER http://quizlet.com/10716938/cai-obj-401-business-spreadsheets-flash-cards/
___ match words to definitions http://www.quia.com/mc/1799176.html?AP_rand=23603320

___ match words to definitions for the link below
_http://www.quia.com/mc/2016566.html?AP_rand=1926551694

___ You can use notes. You must get 100% for the link below. http://www.quia.com/quiz/2055803.html?AP_rand=1395669365

___WIN a million dollars http://www.quia.com/rr/363962.html

PowerPoint Review

PowerPoint Review:
Review the following files in the Review folder to answer the questions or fill in the blanks:

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

_____1Presentation Purpose Powerpoint- fill in the blanks

Characteristics of Appropriate Content

Educational (informative)- To train or _______________________, present information, emphasize _______________________________________, or explain procedures.

Persuasive - To ____________________________________ so people will purchase an item or to provoke ___________________________________ for a cause.

Narrative- To ________________________________messages, tell a ______________________________, or entertain; sometimes uses pictures or illustrations.

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

___ 10 steps for Developing a PowerPoint Presentation file- fill in the blanks.

"Procedure for Developing a _____________________________________ Presentation"

1. Determine ______________________________ or ________________ of the presentation•

2. Identify the ___________________________ audience •

3. _________________________________ or sketch the content•

4. Select a _____________________________________•

5. Edit the ______________________________ slide (Creating a ___________________design)•

6. Enter the ____________________________________•

7. Add and format graphics, _______________________ and ______________________•

8. Add _________________________________ and _________________________•

9. ___________________________________________ •

10. __________________________________as needed

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

_____ Slide Master Definitions- fill in the blanks. What is a slide master?

Every presentation contains at least __________________slide master. The key benefit to using slide masters is that you can make universal style __________________________ to every slide in your presentation, including ones added later to the presentation. When you use a slide master, you save _____________________ because you don't have to type the ______________________ information on more than one slide. The slide master especially comes in handy when you have extremely long presentations with lots of slides.

Because slide masters affect the look of your entire presentation, when you create and edit a slide master or corresponding layouts, you work in Slide Master ______________________.

******************************************************************
____4 Presentation Procedures revised- fill in blanks.

Step 3 – Storyboard or sketch the content

A storyboard is a collection of ______________________ on a piece of paper.

Used to determine the ___________________________ of slides needed.

Used to ________________________ the content of the presentation.

Make a list of _____________________ points

Step 7 – Add and format graphics, audio, and video

Determine how the video or audio will play.

Looped (__________________________________ play)

On mouse __________________________________

Automatically (_________________________________)

LINKED- A linked object means that the ________________________________ (presentation file) merely saves the actual _________________________________, as opposed to the whole file.

Does NOT save linked file. It is _______________________to a linked document or file somewhere else.

If linked, make sure the presentation, including all supporting files are ______________________________ before saving to another computer.

EMBEDDED- An embedded object is actually __________________________ in the __________________(presentation file) rather than pointing to a linked document or file somewhere else.

Play the following review games:

_______PowerPoint Ribbon http://quizlet.com/3089570/scatter

_______Win a million dollars http://www.quia.com/rr/958075.html?AP_rand=96023525

_______Until picture shows completely http://www.quia.com/pp/280807.html?AP_rand=1363527069

_______Play until you get all 10 steps correct. http://www.quia.com/rd/198881.html?AP_rand=183590182
_
______Until you get all 10 steps correct. http://quizlet.com/37174499/scatter

______ Until you get 100% http://www.quia.com/rd/199681.html?AP_rand=226864100

______ Until you get 100% http://www.quia.com/pp/248542.html?AP_rand=885673312

Tuesday, June 3rd- 7th Grade- Review Day 4

Bellringer:

1. Pull out your REVIEW papers from the crate.

2. Get out a pen or pencil.

3. On page 76, type sentences 11 and 12.

What are we learning?

First of three topics (Keyboarding, PowerPoint, Spreadsheets) based on your
study guide analysis. (See edmodo- if you do not remember your 1st item)

Guided Lesson:
@ Miss W will show you how to open a new page for a link by
     holding the CTRL button and left clicking on the mouse
     at the SAME time.
@ You can choose to start with any activity on the Review page.
@ Once you are finished, do NOT wait for Miss W to check it,
     but move on to the next item by opening a new tab.
@ Miss W will check multiple items at a time.

Independent Practice:

If Keyboarding is your 1st topic click here.

If PowerPoint is your 1st topic click here.

If Spreadsheets are your 1st topic click here.

Database Review

Database Review:
Review the following PowerPoints in the Review folder
and write one word and its definition for a term you are not sure about
unless there are other instructions.

Database Fundamentals
____________________

Data Types and Field Properties
____________________

Field Property- Input Mask
___________________

Database Test Review
____________________

Worksheet steps to create a database (Write the steps)
1._______________________
1.a. _____________________
1.b. _____________________
1.c. _____________________
2. ______________________
3. ______________________
4. ______________________
4.a. ____________________
4.b. ____________________
5. _____________________

Steps to Create a Database with lookup type and zip code
__________________________________________

Queries prework
_________________________________________

What are 2 connectors? ________________&_______________

Guided Practice Filtering and Sorting a Database
_______________________________________

Independent Practice Filtering and Sorting a Database
____________________________________

Importing Text Files
_________________________________

Miss W will need to check off your work.
Do NOT wait for Miss W but open a different tab
and work on another exercise.

____parts of a database Scatter http://quizlet.com/920767/cai-501-database-fundamentals-flash-cards/

____math operators Scatter http://quizlet.com/920857/cai-502-database-objects-flash-cards/

____db basics Scatter http://quizlet.com/8214113/ca-i-obj-501-database-terms-part-1-flash-cards/


____mix of database terms  Scatter http://quizlet.com/3976216/ms-wrights-bct-obj-6-flash-cards/

____Get a million dollars http://www.quia.com/rr/956502.html

_____ http://www.quia.com/jg/1412062.html

____ http://www.quia.com/mc/483616.html

_____ Scatter http://quizlet.com/18461807/database-terms-flash-cards/

____ Scatter http://quizlet.com/18461807/database-terms-flash-cards/

____Draw pictures of 2 different types of databases (See the Database Fundamentals PowerPoint)

Publisher Review

Publisher Review:
Review the following PowerPoints in the Publisher folder and fill in the blanks.

____Design Principles

Balance is an even _________________________of weight or when other elements are equal.

Graphics don’t _____________________________ text.

The page is not too _______________ on one side or the other.

Proximity/unity is the __________________ between elements (pictures or words) on a page.

Used to demonstrate a _______________________or a lack of relationship between elements.

Alignment is the_________________________of elements (left, centered, _______________)

Related items should be justified the ___________________to emphasize their relationship to each other such as, the text giving the location, date, time, and cost of an event are all ________________________on a flyer.

Repetition/consistency is the _________________________ (or same) pattern of font and color schemes and graphic types; ______________________fonts, color schemes, or graphics.

Contrast is the use of color and size to _________________________ the most __________________________important elements on a page.

White space has ______________________________________wide margins.

____3.02 Publications

The type of publication depends upon the ______________________ of the communication and the characteristics of the target audience.

Business cards are used to help its recipient remember you or your business and have quick access to your _______________________________________.

Letterhead Stationary is used to send a professionally prepared communication to potential clients to _________________________________the business.

Flyers are used to communicate information about a _______________________upcoming event.

Brochures are used to inform or advertise about a ________________ topic or describe the purpose of a ____________________ or group.

Brochures are used by an organization or individual to advertise or provide information of a more _________________________________nature than that of a flyer.

Newsletters are used to provide informational _____________________________ to a specific club, group, or organization on a regular basis – ____________________, monthly, quarterly.

____Target Audience

The identifying characteristics of the Target Audience provide the __________________ for grabbing their attention by appealing to their…

Age, Education/Ability, Special ________________, and ____________________ Membership

What is the general AGE group?

Elementary, Preteen, Teen, _____________ adult, Mature _________________, and
Senior _______________________.

____SCATTER http://quizlet.com/10493861/cai-obj-302-business-publications-flash-cards/
____SCATTER http://quizlet.com/11124058/scatter
___ Need 8 of 9 correct http://www.quia.com/hm/819282.html
___ Match the words to definitions http://www.quia.com/mc/2333348.html

____ Match the words to definitions http://www.quia.com/mc/2301851.html

____Win a million dollars_http://www.quia.com/rr/531753.html
____ Match the words to Ribbon pictures http://www.quia.com/mc/320506.html

Keyboarding Review

Keyboarding Review:
Review the Typing Posture and Technique file in the Review folder.
Fill in the blanks or answer the questions.

Proper Keyboarding Posture and Techniques

_ Sit up __________________________________________

_ Feet ________________________ on the floor

_ Body __________________________ in front of the computer

_ Elbows naturally _____________________________

_ Fingers ___________________

_ Wrists ________________, but not __________________ the keyboard

_ Quick, ____________________ strokes

_ Quick, down-and-in motion of the _________________________

_ Right __________________ finger used for the enter key; other

fingers remain on the _________________________________

_ Use the appropriate ________________________e finger for the shift keys

Work Area Arrangement

• Keyboard directly in ______________________ of chair

• Keyboard __________________________ with edge of desk

• Monitor placed for ________________________ viewing

• Disk drives placed for easy ____________________

• Copy to the ______________________ of the keyboard

Copy the DEFINITIONS

Technique- The form and keying style that a typist uses while operating the keyboard.

__________________________________________________________________________________________________________________________________________________________________________________________________________________

Touch-method To key by touch rather than by the hunt-and-peck method

Posture The way the typist sits; the way the typist’s arms, wrists, fingers,

legs and feet are placed

Look at page 22 in the Typing book for the answers to fill in the blanks.

Speed is measured in _____________________ per ________________(wpm). To determine your speed:
Key for ________________minute.

_________You must get a million dollars. http://www.quia.com/rr/145732.html

________ You must get 7 out of 10 correct http://www.quia.com/hm/295455.html

_________ Match the words http://www.quia.com/mc/1040966.html

________Fill in the blanks http://www.quia.com/jw/148702.html?AP_rand=647375338
You need to get 7 out of 10 correct.

Miss Witkowski's Computer Science Discoveries Class