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.
Instructions for Teachers
The pages are set so that, when printed double sided, they have a back and front,
enabling for easy sorting.
Before you print the whole deck, test your settings by printing the first two pages of
cards, to check alignment. If it doesn’t match, then its likely to do with how the
printer flips the page (either long end or short end), so make sure it is on the
flipped on the long end. If you don’t want backs, then print every second page. There
are two sizes of cards, mini and large, so have a look at both before you print.
Contents: 8x Hydrogen Cards, 8x Hydrogen Carbonate Cards, 19x Calcium Cards, 19x
Carbonate Cards, 1x Information Card
This card game works in 4 rounds. This works best in groups of 4, but can work with
less or if necessary, up to 5 players per deck. Each player is role playing as a crab.
Round one: The game starts by placing all of the Calcium and Carbonate Ion Cards face
down on the table, as well as two hydrogen and two hydrogen carbonate cards. Each
person picks up 4 positive ion cards and 4 negative ion cards. The goal is to match
Calcium with Carbonate. If you have 4 pairs, your shell grows. 3 pairs means enough
minerals have been gathered to repair their shell. 2 pairs means damage cannot be
repaired, but doesn’t worsen and 1 pair means the shell gets further damage and
cannot be repaired. Record the scores on a tally card.
Round two-four: At the end of the first round and each round after, all the cards are
returned to the table, face down and an additional two hydrogen and two hydrogen
carbonate cards are added, symbolising the acidification of the ocean through the
dissolving of more CO2. Same rules for shell repair apply.
Person with the most points at the end wins (pairs). Enjoy.
The Efficient Science Teacher
If you liked this game, don’t forget to check out my other games:
The Biology Bandit - A Biology Escape Room Revision Activity
- Human Impact - A Biological Card Game - Ecology, Climate Change + Sustainability
or if you need some practicals, check out my Bundle of practicals focusing on the History of STEM:
Bundle - History of STEM Practicals - Science, Mathematics and History