Category Archives: Past Classes

Citation Managers Initial List — P. 1

Link to the spreadsheet:

https://docs.google.com/a/riverdale.k12.or.us/spreadsheets/d/1CvAe2J9x_Wd0mMJQunSR5GDLYFaiXKckzXc8gfeGl2E/edit?usp=sharing

  • Works Cited 4 U
  • EZ Bib
  • iMiser
  • Ultimate Research Assistant
  • Refworks
  • Mendeley
  • Noodle Tools
  • Bibme
  • Citation Machine
  • Owl Purdue
  • Refme
  • Citation Generator by Mick Schruder
  • Citefast
  • Citation Maker
  • Cool Tools For Schools
  • Zitavi
  • Essay Writing Web.com
  • Ottobib
  • Cite This 4 Me
  • Noodle
  • DiRT
  • Citavia
  • Citeliter
  • Docear
  • Recipes4success
  • Refdot
  • Neil’s toolbox
  • Eturabian

 

The Dream Tool

Here are the features we decided would make up the perfect Research Assistant Tool

Wouldn’t it be great if…:

It would find related sources

  • Universal, cross-platform access
  • Easy add/modify/remove citations from paper
  • Organize sources more clearly
  • List citations alphabetically
  • Proper indents/formatting  — up to date
  • Automatically add the inline citation
  • Automatically grab citation information — web –books too?
  • Multiple platform
  • Integrated with Word and Integrated with other platforms
  • Recognize that there are two authors with same last name and make appropriate adjustments
  • Ties research notes to sources
  • Makes research notes searchable

 

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.

 

Finalizing Excel Work

Today, in the absence of so many people because of the blood drive and Track, we did a little more work in Excel.

First off, we built a sales force spreadsheet.  One sheet had three divisions of sales with a quota and a commission.

Divisions were Small, Key and Major

Quotas were $10,000, $100,000, and $1,000,000 respectively

Commissions were 5%, 7%, and 8% respectively.

Then we built a sheet of data with the following columns

Name, division, sales this month (made up numbers), quota, commission rate, sales abovequota, and commission earned.  We used an if statement to make sure that last one did not come out below zero (for those that did not meet their quota yet this month).

Then we started looking at print in Excel.

First thing to do is highlight the area you want to print, then go to File Menu, Print Area, and select ‘set print area’.

That gets you started.  In page setup, you can select what rows and columns to repeat, what orientation to have the page, and you can manage margins, headers, and footers.

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

Text Manipulation and combining formulas

We have learned four important text manipulation tools.

& lets us concatenate two strings:  1 & 2 = ’12’

left(…) returns the left characters of a string.  if A2 = ‘Bob Newhart’, then left(a2, 3) = ‘Bob’

right(…) returns the right characters of a string. right(a2,4) = ‘hart’

Combining formulas is sometimes made easier by writing them separately and then joining them together.

N2 = left(a2, 7) = ‘Bob New’

O2 = right(n2,3) = ‘New’

Combine them and you get:

right(left(a2,7),3) = ‘New’

 

Excel Status Check

Today we start by looking at the different things we know how to do in Excel.  We created four categories:

Environment:

  • Structure Data
  • Resize Rows and columns
  • Deleting individual Cells
  • Insert/Delete rows and columns
  • format — colors/fonts…
  • Change data types (currency)
  • Copy formatting
  • Copy information
  • Clear information
  • Add/Delete Sheets
  • Rename sheets
  • Auto filters
  • Pivot Table

Formulas

  • + – * / ()
  • Absolute vs relative referencing [$]
  • Sum, count, average
  • Autosum
  • Sumif/Countif/Averageif
  • iferror

+ macros a little bit

Needs Review

  • Conditional Formatting
  • Vlookup

Still Missing

  • sumifs function