Easily keep track of faculty spending with this easy to use, straight forward budget tracker. Produces graphs, reports and tables giving a clear view of where your budget is going and how much is left.
Step 1 Go to the “Overall” sheet and in the total budget cell, input your allocated budget.
Step 2 As orders come in, click on the appropriate subject tab, and list the resource, where it is from, who ordered it, the cost, how many are required and if there are any shipping costs. The results will update on the “Overall” both in the table, and graphically, giving you a visual of exactly where the money is being spent. Furthermore a short report is generated, that can be copied and pasted into an email, should you need to notify someone of the progress with the budget.
Step 3 It should be noted, that although this excel sheet has been set up for a Head of Science Position, it could be easily adapted to suit other Faculties by changing the name of the sheets and the labels on the graph. To alter the report, simply click on the cell, and in the formula, wherever a faculty is listed, rewrite it with the appropriate replacement.
pw to unlock cells is “schoolsoutforsummer”
Easily generate unique comments for each of your students with this straight forward, easy to use excel sheet. Use the comments already loaded or input your own to quick and easily generate report comments that are individualised. See steps below for how to use.
Go to Grades Tab and Insert student names and gender (use capital F or M to indicate which pronouns will be used in the comment)
Go to Sentences. I have provided you with some examples of what you can use. You can alter what is there, and there is space for your to add more. If you need more sentence ideas, there is plenty available online which you can use as a template. Just google, “Report Comment examples” and you should come up with thousand of options. When inputting the sentences, you should see the key to the right for inputting pronouns or other data. For example, “%name% has shown that while heshe is capable, heshe has work to do to meet expectations.” will replace %name% with the name of the student and “heshe” will change to he or she based on the gender input.
Before you begin creating your individualised comments, you should print off the “Sentences” sheet. It will make it easier to see all the options you have available.
Now you are ready to create your comments. Go to the input tab and for each section insert a number between 1 and 25. This will insert the corresponding sentence that you created in the Sentences sheet. If you want to mention an assignment, then place the name of the assignment in the assignment column and it will insert it into the comment for you.
When you are done, go back to the Grades tab and you should be able to see an overview of the comments for your students. If you prefer a cleaner view, you can go to the “Individual Student View Report Card” and type the number of each student in individually to have a closer look and check that you are happy.
The final step is to copy the cells over to a Word document or wherever else you want the writing to go and you are done.
If you don’t want to use my comments, there is a little time to be taken in the initial set up, but once you have the sentences in place, comment writing takes a matter of minutes rather than hours. I would even recommend having a separate list of sentence for each year level, however, that is something that you can work on with time.
I have also attached an Email generator as a bonus. It has space for up to 15 preset emails that you can set. I have again left some examples, but you can alter them and create your own. When making your own emails, don’t forget to use the key to the right for anything you want replaced.