Skip to main content

Home/ academic technology/ Group items tagged formula

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Judy Brophy

A Simple Blogging Formula - 0 views

www.chrisbrogan.com/a-simple-blogging-formula

blogging rules

shared by Judy Brophy on 23 Jun 10 - Cached
  • Judy Brophy on 23 Jun 10
     
    In all my years of blogging, I've put together what serves as a very simple formula for what I think about when I sit down to the keyboard to type. This might not serve everyone, but it might be a great start for you to consider when thinking about blogging.
  • Judy Brophy on 23 Jun 10
     
    useful for new bloggers like students, perhaps
Jenny Darrow

10 Useful Google Spreadsheet Formulas You Must Know - woorkup.com | Diigo - 1 views

www.diigo.com/...adsheet-formulas-you-must-know

google-apps data

shared by Jenny Darrow on 23 Feb 10 - Cached
  • Jenny Darrow on 23 Feb 10
     
    Google Spreadsheet is a powerful and free tool to manage complex spreadsheets. This tutorial illustrates ten useful formulas you must know to help you simplify the way you work in Google Spreadsheet.
Matthew Ragan

Function list : Functions - Google Docs Help - 1 views

docs.google.com/...answer.py

google functions formula spreadsheets data

shared by Matthew Ragan on 15 Mar 11 - No Cached
  • Frequency distribution
  • FREQUENCY(data, classes)
  • FILTER(sourceArray, arrayCondition_1, arrayCondition_2, ..., arrayCondition_30)
  • ...21 more annotations...
  • SORT(data, keyColumn_1, ascOrDesc_1, keyColumn_2, ascOrDesc_2, ..., keyColumn_30, ascOrDesc_30)
  • Cross-workbook referenceImportRange(spreadsheet_key, [sheet!]range)
  • Elements based on criteriaCOUNTIF(range, criteria)
  • RANDBETWEEN (bottom, top)Returns an integer random number between bottom and top (inclusive).
  • ROUND(number, count)Rounds the given number to a certain number of decimal places according to valid mathematical criteria. Count (optional) is the number of the places to which the value is to be rounded. If the count parameter is negative, only the whole number portion is rounded. It is rounded to the place indicated by the count.
  • RAND()Returns a random number between 0 and 1.
  • AVERAGE(number_1, number_2, ... number_30)Returns the average of the arguments. Number_1, number_2, ... number_30 are numerical values or ranges. Text is ignored.
  • CONFIDENCE(alpha, STDEV, size)Returns the (1-alpha) confidence interval for a normal distribution. Alpha is the level of the confidence interval. STDEV is the standard deviation for the total population. Size is the size of the total population.
  • CORREL(data_1, data_2)Returns the correlation coefficient between two data sets. Data_1 is the first data set. Data_2 is the second data set.
  • COUNT(value_1, value_2, ... value_30)Counts how many numbers are in the list of arguments. Text entries are ignored. Value_1, value_2, ... value_30 are values or ranges which are to be counted.
  • COUNTA(value_1, value_2, ... value_30)Counts how many values are in the list of arguments. Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored. value_1, value_2, ... value_30 are up to 30 arguments representing the values to be counted.
  • MAX(number_1, number_2, ... number_30)Returns the maximum value in a list of arguments. Number_1, number_2, ... number_30 are numerical values or ranges.
  • MEDIAN(number_1, number_2, ... number_30)Returns the median of a set of numbers. Number_1, number_2, ... number_30 are values or ranges, which represent a sample. Each number can also be replaced by a reference.
  • MIN(number_1, number_2, ... number_30)Returns the minimum value in a list of arguments. Number_1, number_2, ... number_30 are numerical values or ranges.
  • MODE(number_1, number_2, ... number_30)Returns the most common value in a data set. Number_1, number_2, ... number_30 are numerical values or ranges. If several values have the same frequency, it returns the smallest value. An error occurs when a value does not appear twice.
  • PERCENTILE(data, alpha)Returns the alpha-percentile of data values in an array. Data is the array of data. Alpha is the percentage of the scale between 0 and 1.
  • QUARTILE(data, type)Returns the quartile of a data set. Data is the array of data in the sample. Type is the type of quartile. (0 = Min, 1 = 25%, 2 = 50% (Median), 3 = 75% and 4 = Max.)
  • RANK(value, data, type)Returns the rank of the given Value in a sample. Data is the array or range of data in the sample. Type (optional) is the sequence order, either ascending (0) or descending (1).
  • STDEV(number_1, number_2, ... number_30)Estimates the standard deviation based on a sample. Number_1, number_2, ... number_30 are numerical values or ranges representing a sample based on an entire population.
  • STDEVP(number_1, number_2, ... number_30) Calculates the standard deviation based on the entire population. Number_1, number_2, ... number_30 are numerical values or ranges representing a sample based on an entire population.
  • Combines text stringsCONCATENATE(text_1, text_2, ..., text_30)Combines several text strings into one string. Text_1, text_2, ... text_30 are text passages that are to be combined into one string.
  • Matthew Ragan on 15 Mar 11
     
    Google Spreadsheets Formula Help
Judy Brophy

Brainstorm in Progress: Instructional Design: Beyond the Formulas - 0 views

cain.blogspot.com/...al-design-beyond-formulas.html

instructional_design course_design OER

shared by Judy Brophy on 20 Dec 10 - No Cached
  • We have an opportunity in course design, to bring all of the stake-holders to the table. Course design should not just be up to a dept. or a single teacher. Course development can be an opportunity to bring in a librarian, someone from student advising, disabled student services and programs, and developmental education. A course design process can show an instructor how to connect their classroom with other students, instructors, and experts in the field. It can be an opportunity to connect students with professional networks as well as other colleges and schools.  What I have been finding is that when you bring everyone to the table to talk about a course, you can discover many different ways to connect your cour
  • Judy Brophy on 20 Dec 10
     
    We have an opportunity in course design, to bring all of the stake-holders to the table. Course design should not just be up to a dept. or a single teacher. Course development can be an opportunity to bring in a librarian, someone from student advising, disabled student services and programs, and developmental education. A course design process can show an instructor how to connect their classroom with other students, instructors, and experts in the field. It can be an opportunity to connect students with professional networks as well as other colleges and schools.  What I have been finding is that when you bring everyone to the table to talk about a course, you can discover many different ways to connect your course to the community than you would have ever thought of yourself.
Jenny Darrow

Function list : Functions - Google Docs Help - 0 views

docs.google.com/...answer.py

google-apps google-spreadsheets data excel functions

shared by Jenny Darrow on 22 Jan 11 - No Cached
  • Jenny Darrow on 22 Jan 11
     
    Like any good spreadsheet program, Google Spreadsheets supports a wide array of built-in functions.There are old standbys like SUM and AVERAGE. Mathematical, financial or statistical functions to help you crunch numbers. Even functions that manipulate dates and text. Enter them manually, or use the formulas tab to find the functions you need.
Matthew Ragan

Equivelent of "COUNTIFS" function in excel - Google Docs Help - 0 views

www.google.com.tw/...thread

excel equivelent countifs google spreadsheets google spreadsheets web2.0

shared by Matthew Ragan on 27 May 11 - No Cached
  • Matthew Ragan on 27 May 11
     
    I am trying to count cells based on multiple criteria from multiple cell ranges using google docs.  In Excel the formula is simply: =COUNTIFS(S2:S26, "IN", E2:E26, "A") This would select all of the cells with the word "IN" and the Letter "A" in the same corresponding row.  Can anyone help me figure out a workaround for not being able to use the "countifs" function in google spreadsheet?
1 - 6 of 6
Showing 20▼ items per page