Spreadsheets
Grades and formulas
Spreadsheets allow the teacher to neatly organize data and results from their students homework, assignments and quizzes. It is especially useful in helping automatically calculate the sum total of points, percentage and over grade. To calculate the total points of each of category, highlight the desired row from a student then click the sigma icon. This will automatically calculate the total sum of your points for that student. Then click and drag down in the points column to calculate each of the students points automatically. To calculate the Percentage of a student is a bit different. Lets take Simon Carlton for example. The formula to use would be L2/$L$8(or type L8 and press F4).
To get the Grade result for each of your students you must use the above formula on your document. Before typing in Grade#, the setting has to be "normal"- After typing in, you have to get rid of decimals then drag all the way down to fill all the blanks.
Charts
Graphs are an easy to understand indication of progress made between each of your students. You're able to see which areas your students are weaker or stronger in both individually and in comparison to other students. In the above graph we are able to see that students overall were able to do much better in the homework assignment #9 as opposed to homework #8. To make a chart like this you highlight the data on your spreadsheet and go to insert-Chart which will give you options of different types of graphs or charts you want to use.
Sorting or organizing information
In this program we are able to learn how to organize information and data effectively.
The above picture points out the sort menu which allows us to sort our data by various things like time, date, colour and number, alphabetical order and so as shown below.
Teachers can use this tool to order the lists of their students by first and last name or by tests results. They can also determine their class schedules and the time and day of each.
Above is an example of information organized into alphabetical order of class subjects.
Mail Merge with ms word
To create a mail merged document you must first create the address file by using excel and then saving it (see above picture). After which, write your letter or email by using Microsoft word. Then select which type of document you would like to make and then click on the "start mail merge" icon. This will automatically enter information from your Excel document to your letter.
|