Sunday, March 24, 2013

8 Apps, 4 for school, 4 not

Grade Cam
Numbler
NearPod
Overdrive - Borrow free books
Card Star - scan card with barcode
Evernote
Tripit
Face Swapper

Research Notes - Spring Into Technology Conference

Research

Do not let students hand in typed drafts

Ruhl English speakers website

Help by dividing the work into segments, what information has to be found out

Create essential questions first.
Color code  each segment

Highlight information that you need.

Put all the colors together

Open new pages, one page for each color

Then, one document as collective highlights

Next, work on their outline with each section

Easy bib.com

Saturday, March 23, 2013

Excel - Spring into Technology Conference

Site with all the resources:  http://moodle.esasd.net/moodle/course/view.php?id=45
Excel 2011 is for the Mac
Excel 2010 is for the PC

In view, normal is default, page view is neat
Window Freeze pane

All functions start with = (the cells that work) in the parentheses are the cells that you want to work on.  Use the : to anchor, after you put in the =MAX

Double click between bars to auto-click

Highlight columns and drag, all will be the same size

Put mouse on column One, under format, then cell, then alignment, adjust to angle top line.

To highlight two different columns, for a graph,  hold down command or shift key.

To copy or paste, go to edge of chart for commands.

To label graph, right click on "piece of pie"

Format = fluff or fun, be sure to check out

look for Bingo program to make in Excel Jen

For a checkbook, =f2 -d3+d4

Always use Please Excuse My Dear Aunt Sally