DLCS

Digital Literacy & Computer Science

Feb
25

By

Learning Logs

Category: Class Discussion

Objective: Learning Log summaries help students to explain in writing their understandings, points of confusion or experiences.

What have I learned?

  • I’ve been learning how to….
  • The most important part is…
  • The part I can do the best is…
  • Sometimes I forget……
  • I’d like to be able to….< ! [if gte mso 9]> Normal 0 MicrosoftInternetExplorer4 What did we do in class today?
  • What did we learn during these activities?
  • Was this new information or something I’ve seen before?
  • Was the material difficult or easy to understand?
  • Is there something that I still don’t understand and could ask my classmates to explain?

Your learning log will be done in MS Word. This file will be saved in your folder on the server as Log_FirstLastName. Add the most resent post at the top of the page along with a date and log #. Post will be entered during the last five minutes of class.

Example ====================

Feb. 27 – Log 2

I had to work on my brochure AGAIN! I knew how to do most of the steps because I have been working in this program….forever. I think I will be done next class. I learned how to make a citation in Bibme.org, I even help John make his citation. I found this way easier than CitationMachine.net. I think I will use this Web site again when I have to write my science report.

Feb. 25 – Log 1

Today I worked on my brochure in Publisher. I didn’t know how to insert a picture off the Olympic.org Web site. Mrs. Reuther said that you can not copy and paste Flash files so she told me how to get the picture onto my file….I did the following…”Alt + Prt Sc”, open Paint.net, Ctrl + N, Enter, Ctrl + V and then use the selection to select the part of the picture I want and then copy and paste into my brochure file.

=========================

Feb
26

By

Spreadsheet Software

Category: Class Discussion, Spreadsheet / Database

Spreadsheet

“The Essential Question” for this unit:
Explain how spreadsheets simplify the organization of data. Answers to this question will be developed as we move through class discussions and lessons in MS Excel.

A term to describe software used for math calculations.

A spreadsheet program allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

What is a Spreadsheet?

  • A tool for organizing data
  • A mathematical tools to crunch numbers
  • A graphing application
  • A charting application

Spreadsheets are made up of

  • columns
  • rows
  • and their intersections are called cells

In a spreadsheet there are three basic types of data that can be entered.

  • labels – (text with no numerical value)
  • constants – (just a number — constant value)
  • formulas* – (a mathematical equation used to calculate)
data types examples descriptions
LABEL Name or Wage or Days anything that is just text
CONSTANT 6 or 4.25 or -4.8 any number
FORMULA =4+6 or = 2*5+4 math equation

*ALL formulas MUST begin with an equal sign (=).

Labels are text entries. They do not have a value associated with them. We typically use labels to identify what we are talking about.

Basic Math Functions

Operation
Symbol
Constant
Data
Referenced
Data
Answer
Multiplication
*
 = 5 * 6 = A1 * B3
30
Division
/
 = 8 / 4 = A3 / B2
2
Addition
+
 = 4 + 7 = B2 + A2
11
Subtraction
–
 = 8 – 3 = A3 – B1
5

 Video:

Beginner Tutorial

http://www.usd.edu/trio/tut/excel/index.html

http://www.fgcu.edu/support/office2000/excel/

M&M Lesson

http://www.microsoft.com/education/candy.mspx

Fast Food Lesson

http://www.wmburgweb.com/Resources/Lesson/index.htm

Skip to toolbar