Category Archives: 5. Tech Apps (T3 15-16)

Beginning Mail Merge

Today we started Mail merge.  One of the key lessons of working with Mail Merge is that it is important how you name , create sheet names and file names that are meaningful to what the content is about.

In Word, write up a letter.  Then you go to Tools -> Mail Merge Manager.  That will create a window with six (?) steps. The first is to choose the document type–I almost always select Form Letters.  Then you choose the data source.  open Data source, and then find the Excel Workbook that contains the information you want.  It will ask you which sheet to use, and then, after you’ve chosen it, will bring up a list in step 3 of all the columns for that sheet.  The next step is to drag placeholders into the right places in your document. We will do more with that tomorrow.

 

Word Basics

Today we got started wtih Microsoft Word.

The first thing we talked about was using Word to effectively apply the four elements of style (Contrast, Repetition, Alignment, and Proximity). Most importantly, instead of selecting formats for each thing individually, use the Styles feature.  By applying a kind of style (Like Title, Heading 1, Normal) when it is appropriate, you can then modify that style and have it applied throughout your document consistently.  The sooner you get in the habit of using styles, the more likely you will use it when it is important (like on a Senior Ex Paper or a Doctoral Dissertation).

To Modify a  style, you can either make some text look the way you want and then right click on the style button that want to change, then select “Change to Match Selection” (or something like that, or you can right click on the style and choose “modify” to select the format from there.

 

Then we played with pictures. The most importnat thing about working with pictures in Word is…Text Wrap selection. Once you’ve selected a picture, you will find this in the Format Picture Ribbon.

 

 

Forecasting Assignment

Use Google Sheets to create a form that allows a user to enter information important to Cheryl in forecasting:

 

First Name, Last Name, Grade, Foreign Language, PE(2 credits done?), Health(2 credits done?), Seniors: Geology for college credit?, Comments.

Course selections: 5 different choices in order (1st, 2nd…) for each trimester. — This one is a challenge, what will be the best question type to get this information as reliably as possible?  Try some out, look at the data you get as a result, and decide if it’s the best choice for this job.

Course possibilities from last year’s forecasting can be found here.

Then you need two results sheets based on the data retrieved from people submitting the form.  In one, you need a count of students that are interested in each course as:

— somewhere in their top 3 choices

— each of:  top choice, second choice, third choice, fourth choice, fifth choice.

Finally, you need a page that will allow Cheryl to select a student name (dropdown menu — data validation), and bring up all that individuals forecasting detail in a nice easy-to-read format.

 

Course List

Here is the list of available courses from 2015-16 forecasting:

 

Adv. Exp. Science
Adv. Java
Adv. Web Design
American Poetry
Art Portfolio
Art/Science
Band Projects
Beg. Programming
Beg. Web Design
Bella Voci
Choir
Comedy & Lit.
Comedy and Lit.
Consumer Science
Dance
Drama
Draw/Print Making
Econ.
Film Noir
Game Theory
H2O
Human Anatomy
Int. to Game Design
Int. to Java
Intr. Game Design
Intro to CAD
Intro: Robotics
Issues in Biology
Jane Austen
Media Literacy
Mock Trial
Naturalism & Ethnic Conflict
Org. Leadership
Organizational Leadership
Paint Studio
Photography
Pop Art
Portland History
Prog. Apps For iPhone
Pub./Yearbook
Shakespeare & Politics
Short Stories
Tech Apps
War & Lit.
War and Lit.
Web. Server Apps
Weight Training
Western Civ. A
Western Civ. B
Writing 121
XV
Yoga

Fake Tracking Numbers

1Z6706220114014011
1Z8719570269073382
1Z5248690363566253
1Z9462891A58133734
1Z8577491S29744775
1Z288837EA41713296
1Z9457053S22186337
1Z2434220177637138
1Z8114560231967509
1Z5138850379575400
1Z1640691A36289781
1Z4763651S28998302
1Z519076EA74392223
1Z3676673S37365154
1Z4891060143994325
1Z9419090280661036
1Z8329680367857667
1Z1523121A57961838
1Z3380501S97547019
1Z191306EA78300570
1Z9245643S41749801
1Z6936860199352092
1Z1715490260601933
1Z7682700386347254
1Z8715251A50372705
1Z6525371S25197446
1Z435906EA63062897
1Z1305363S95162978
1Z6665310196394139
1Z4834730241493540
1Z9685660355642241
1Z8673181A92381302
1Z1168831S61613713
1Z680690EA28863114
1Z8553703S53203225
1Z4121390192734836
1Z2223150247008137
1Z9327820333224188
1Z1001531A64833749
1Z9501201S77781830
1Z911762EA25042961
1Z3217343S41049662
1Z1932350155603463
1Z2656940210997084
1Z6819590398042685
1Z3583061A98214316
1Z6877831S63713517
1Z485697EA94043278
1Z2152483S60183969
1Z9199060110530380
1Z5816040219174991
1Z7961330399950772
1Z3962071A66263143
1Z6885421S32015264
1Z473744EA46316605
1Z1098733S99206836
1Z4793330184730387
1Z6296940211871688
1Z4642790380924329
1Z5170911A46429830
1Z9719391S25420541
1Z979627EA98016852
1Z8900253S65723703
1Z5352190135217574
1Z9879680262309175
1Z4230300332984366
1Z7006211A35875197
1Z3979241S85458518
1Z934122EA62266529
1Z4079743S76546430
1Z9876820159672161
1Z5086670235107492
1Z7985920384968623
1Z9270121A68481104
1Z1170111S68774235
1Z580315EA25459256
1Z9546453S31179797
1Z4495280159347098
1Z8140430284486609
1Z8862130353392970
1Z6917221A86171811
1Z1104831S25277832
1Z424923EA52409483
1Z5663873S15168034
1Z3994390182791505
1Z5174490211042326
1Z7058500335950297
1Z4830281A52730578
1Z4222211S83232449
1Z625002EA34542760
1Z4911293S21523211
1Z8599190142639892
1Z6645640229597813
1Z5501770389963914
1Z3925041A50354045
1Z9438481S67567446
1Z2010673S16874788
1Z6539740194727159
1Z8036830268445900

The magic of Vlookup!

Today we learned the magic of Vlookup.  With Vlookup, you can take a value from one sheet, look it on another sheet, and return some information on the same row. For instance, you can use the student ID on a test-results report, look it up on a class list report, and return an advisory teacher..

The Vlookup lookup formula looks like this:

=vlookup(–the value you’re trying to match–, –where you’ll find it {this is a rectangle of information with the matching column on the left, and the value to return somewhere to the right of it}–, –the number of the row to return–, –true for range lookup or false for exact match–)

e.g.

=vlookup(C2, studentInfo!A:B,2,false)

a range lookup could be used to return a letter grade from a grading scale. The lookup table has to be sorted smallest-to-largest by the lookup column, and the last option in the formula needs to be true.

We also started our menu assignment. Find a restaurant menu, and create a sheet with the details for three categories of food

Columns should be:

  • Main dish
  • price
  • Side
  • price
  • Beverage
  • price