​Teacher Professional Development

Here are links to different professional development sessions that I have been fortunate enough to present.

Excel Tips and Tricks

Contained in this PD session

Efficient data entry
Resizing column widths
Merging cells
Setting background and text colour
Setting cell alignment
​Percentages and decimal place formats
Inserting rows/columns
Calculating total / % / average
​Concatenation (&)
Functions: SUM / AVERAGE / MAX / MIN / LEFT/ RIGHT /
​ROUND / RANK / 
IF / COUNTIF / COUNT
Conditional formatting
Sparkline
Status bar usage
Create column chart
(show trend or point in time)
Create line chart (trend)
Create pie chart (percentage)
excel_tips_and_tricks.xlsm
File Size: 346 kb
File Type: xlsm
Download File

Informatics Session Handout

dltv_informatics_-_learning_tasks_handout.docx
File Size: 466 kb
File Type: docx
Download File

Adobe Spark