BTEC Grade Calculator Level 3 Extended Diploma, converts UCAS points - Computing

I made this little grade calculator to help students to navigate progression opportunities through UCAS points. Make a copy of it, it is easily adjusted to fit any course.

🔗Grade calculator

Create a currency converter in Google Sheets

 There's no need to create fancy python programs for converting currencies when you can connect to google finance through a simple formula.  In the below example we are using the British Pound (GBP) as  the user input to covert to US Dollars, Japanese Yen (JPY), Euro (EUR), India Ruppees (IND) and the Canadian Dollar (CAD).  The currency converts roughly every 15 minutes as it syncs with Google finance data.

In column A the user inputs the currency value, so in colums B through F we need to enter the currency converter formula. A sample of this can be shown here =Googlefinance("Currency:GBPUSD")*A2

To break this down in column B we have entered the fomula to convert the user input of the British Pound which converts the cell data into US Dollars. So A2 is where the data is coming from and calculating it automatically into B2. In C2 for the Japanese conversion use formula

=Googlefinance("Currency:GBPJPY")*A2

A list of the currecies are below

GBP - British Pound

USD - US Dollars

Japanese Yen - JPY

Euro - EUR

Indian Rupees - INR

Canadian Dollar - CAD

If you wish to change the format of your currencies simply replace the formula with what currency you want to convert from to for example =Googlefinance("Currency:USDJPY")*A2 would convert the user input of USD to Japanese Yen. You could lay out your spreadsheet vertically rather than horizontally just remember where the user input is to be placed and ammend your formula with the cells accordindly.

Happy spreadsheeting!

Sparklines in Google Sheets

 Sparklines are smalls charts that help visualise data within spreadsheets. Sparklines can used in Google Sheets or Microsoft Excel. In the below example we will show 4 ways of using sparklines in Google sheets.

Column Charts

Below we have a simple spreadsheet with some data on minutes played for a range of players per game. Once you have some data, to create a column chart in sparklines simply type the formula in the location you want it ; =sparkline(B3:F3,{"charttype","column";"color","red"}). For this example its in B14 and the column chart will form from the data in cell range B3:F3, then specify the charty type and the color that you want it displayed in.

Spakline - Line Graph

In the below example for a line graph the data is the same as the above. As line graphs are sparkline defaults we do not need to specify the chart type. In cell B14 I have used the following formula to create the green line graph, just ammend yours accordingly; =SPARKLINE(B3:F3,{"color","green"})

Bar Chart

Bar charts can be used to show progress towards completion. In the below example we have a representation of the total number of minutes played against the highest in the group. To create such a bar chart type the following forrmula in the cell you want it the visual to go; 

=sparkline(B9,{"charttype","bar";"max",MAX(B9:F9)})

Winloss

Finally we have the winloss chart. In this example we are assessing player performace as either a positive or a negative. This could be a monetary value in an alternate story. The formula for the below result is simply assessing the data on row 10

;  

=sparkline(B10:F10,{"charttype","winloss";"negcolor","red";"color","green"})

Summary

The above examples of bringing yoru data to life. Have a play around with colours and also your data to best represent what you are trying to achieve. Happy spreadsheeting ⌣