Over time I have found that the following five formulas are some of the most useful for teachers when working with data and spreadsheets. Each of these formulas can automate something teachers use often or provide them with a more detailed analysis of data.
1) Averageif – allows teachers to create a condition to a range of data that is going to be averaged. Example: Average on the scores that fall between 60-69.9
2) Countif – allows teachers to count a range of data based on a condition. Example: count only those students who made basic.
3) Concatenate – combines data from cells into one cell. Example: you could add @student.rcschools.net to end of student usernames to quickly generate their email addresses.
4) Proper – allows teachers to change the text to first initial uppercase and the rest of the name lowercase. Example: Export from iNow makes all names capital and you want them to be proper. JASON SLOAN becomes Jason Sloan.
5) If/Then Statements – allows teachers to make conditional statements based on data in a cell. Example: If you wanted to have all scores between 80-85 be proficient you could use an if then statement to automate this process.