Free and Open Source Software

Free and Open Source Software is an incredible thing! Communities of developers work together to produce programs that anyone can use. Without them, there would be no competition against software giants like Microsoft and Adobe. Further, using library budgets to support companies which provide Free and Open Source software can pay off in the long run by keeping competition up.


LibreOffice

LibreOffice is an open source suit of programs for office use. Writer (word processor), Calc (spreadsheets), and Impress (presentations) are very similar to Microsoft Office, Excel and PowerPoint respectively. Their other offerings; Draw, Base, and Math are also interesting tools.
Draw is for creating diagrams and flowcharts.
Base is a database front end aimed at being easy to understand, even for those new to databases.
Math is designed to be used within other programs in the LibreOffice suit to format scientific mathematical formulas, however it can be used on its own.


Images

Gimp
GNU Image Manipulation Program

Gimp is a free and open source image editing program which handles tasks from photo editing, drawing and creating graphics. It is raster based which means it uses pixels as the structure. It handles tablet input with controls based on pen pressure. There are numerous plugins available for various tasks, developed by the community. For programming users, there is the ability to automate some processes using Python.

InkScape
Open source vector creation

InkScape allows for creating vectors – infinitely scalable images – used for logos and other branding in both print and web. Vectors are different from pixel dependent rasters, as they store their shape as mathematical formulas. This means there are obvious borders to sections, they don’t blend in the same way. However, the benefit is they don’t become pixelated at any size.


Video

Blender
3d animation

Blender is a free and open source 3d animation tool. Models created in this program can be used for many applications including video games, video, and simulation. Blender can handle the process from start to final product, and can also function as an editor for captured video. As there is a lot that you can do with it, Blender has a very steep learning curve and is difficult for new users.

The following three programs are covered in more detail in my post about video.

OpenShot
Video Editing

A user-friendly drag and drop, multi-channel, video editing program. Allows you to gear your output to various formats, including those aimed at web platforms like YouTube.

OBS Studio
Screen capture and live streaming

A powerful tool for adding together multiple recording sources in-screen. Allows you to format the placement of a webcam insert while capturing your screen.

Aegisub
Captioning

A tool for timing captions to video. Allows you to see exactly where the audio starts and finishes. It also provides helpful warnings if the number of words in a time period is too great.


Library Tools

MarcEdit

MarcEdit is a data-manipulation tool which can manipulate MARC records. It was developed by Terry Reese as part of a database cleanup project he was working on at the Oregon State University. It handles MARC8 and UTF-8, and can be used to translate records between encoding formats.

OpenRefine

This is another data cleaning tool. Publicly accessible data can be messy, particularly when the data is entered without authority control. You can navigate through data by bringing up cells which contain particular text using the text facet. It also allows you to edit particular cells so that the data will be combined. This feature can also be used to make data more readable, by replacing acronyms or abbreviations with their full version.
Data matching is another feature of OpenRefine. You can add content via a URL based on the content in a column.


Web

These web based tools are the ones I understand the least. However, I’m in the process of figuring them out so I’ve included my current understandings of them here.

WordPress

While this website has been built using WordPress.com the company, I have also messed around with WordPress the application. WordPress requires another program to run (I used WAMPserver outlined below) but once you have that, all you need is a URL and hosting to have complete control over your website. The interface is very similar to WordPress.com, however you get more control over CSS and the addition of plugins for particular features. (For example, it would be possible to add a lightbox feature where images enlarge within the website when clicked instead of redirecting to another page.

WAMPserver

WAMPserver is a Windows specific software stack – a single application which uses multiple program inputs to provide a service. WAMP made up of an operating system, web server, database and programming language; Windows, Apache, MySQL or MariaDB, and PHP, Perl or Python respectively.

phpMyAdmin

This is one of the primary administration tools used with MySQL, particularly for Web applications. It was written in the programming language PHP.

MySQL

MySQL is an opensource database. It works with other programs which provide GUIs (graphic user interfaces) for ease of use. It has an opensource option and an enterprise option for businesses. MySQL is used by many big names on the web including Twitter, Facebook and YouTube.

Video

Video is a useful tool for communicating information. It can be more engaging than text, and allows for demonstrating how things work in action. This page looks at how to use screen capture, phone captured video, editing, and captioning tools.

I believe however, video shouldn’t be the only means for communicating information. It uses a lot of data and it’s temporal – making it harder for people to skim. I personally, avoid resources which involve watching videos.

Capture

There are multiple methods of capture available, depending on your device. Mobile phones are convenient and of ever-increasing quality. Web cams are also useful as they make it easy to have a stable position. Video specific cameras will give the best video quality, but are also expensive and often bulky.

OBS Studio

This is an open source screen capture program, which allows both recording and livestreaming using multiple inputs. So I can place a capture from my webcam over the screen. I can also crop and resize the capture, or make certain colours invisible. This would work better if I had a green screen but you can get the idea with this silly video I made here.

Editing in OpenShot

The result!

Captioning

Editing captions within YouTube

For short videos in particular, it’s easier to just work within YouTube.

On the Advanced page within YouTube’s editor, you must first select the language of the video.

A screenshot of YouTube Video Editor
Screenshot of subtitle location

Where captions are available, there is a link in a grey box, as here.

If there are no links here, click the UPLOAD SUBTITLES link to upload your own. The process for making new subtitles is in the next section.

Once you have a subtitle file, editing them in YouTube is fairly easy.

When playing through, hitting the enter key can break a subtitle into two screens at the point where the time slider is placed in the video.

When an incorrect subtitle is noticed, as it is in the image below, it’s a simple matter to fix.

A screenshot of an incorrect subtitle within YouTube

Simply select the text in the subtitle box, in this case it’s the word ‘Tricky”. Then type the correct word, in this case “checking”. Clicking out of the box commits the change to the video.

A screenshot of the corrected subtitle.

Once all the subtitles are edited, click ‘Save changes’ in the top right hand corner and confirm by clicking ‘Publish’.

Screenshot of the YouTube confirm to overwrite screen.

When YouTube Won’t Auto Generate

Sometimes, if your audio is distorted, YouTube won’t auto generate the captions. In those cases, I go straight to Aegisub. Firstly I import the video.

A screenshot of Aegisub after importing a video.

Then I switch the view to Audio and Subtitles only.

Screenshot showing where to select changed viewport in Aegisub

Once that is complete the interface is a lot cleaner.

Screenshot of Aegisub Audio and Subs only view.

In here, sections of audio can be selected by dragging or specifying a number in the box beside the subtitle. New subtitles are added by right clicking and selecting ‘Insert (after)’.

Screenshot of the location of Export Subtitles within Aegisub.

Once the subtitles are complete, they can be exported into various file types through the File tab.

To use the subtitles on YouTube, select the .srt (SubRip) file extension.

Accessibility

Accessibility is overlooked everywhere, regardless if spaces are physical or online. It is important to consider user needs to ensure as many people can access the content as possible. This post explores accessible web, the WAVE Web Accessibility Tool, image alt text, and video captioning.

To be truly accessible, the myriad effects disabilities can have on individuals need to be taken into account.  This does not mean a list of all the possible disabilities that might exist, this means clarifying the accessibility issues that might cause problems to people with myriad forms of disability.

tinapj, 2019, ‘”Accessibility” Means What, Exactly?’

Accessibility is overlooked everywhere, regardless if spaces are physical or online. When planning events or tools, abled people like myself are likely to assume that the users of our plans will be similar to us. As tinapj writes in their article linked above; if an abled person thinks of someone with a disability, they are probably only going to think of a wheel chair user. Further, disabilities which aren’t visible are often ignored. Just as there are huge varieties in disabilities, each person will experience their disability differently.

The only way to really address this is to listen to disabled people and act on their advice. Every day they see the ways the world is built that exclude them. The web makes it easier to listen and, at this point, not considering accessibility is inexcusable.


Accessible Web

Within a web context, there are many guides about accessibility. The World Wide Web Consortium (W3C ) has a Web Accessibility Initiative which is a good place to start. They outline some of the disabilities relevant to web access as; auditory, cognitive, neurological, physical, speech, and visual. They also make the point that it’s not just people with disabilities who need these modifications, people with low bandwidth, or using devices with different controls also need these considerations.

There were a couple of areas of focus within this topic. Firstly, I had to make sure the website itself was optimized for accessibility. Secondly, I learned images need alt text so they are ‘visible’ to screen readers. Thirdly, I investigated captioning video.

A lot of WordPress themes are designed for accessibility as standard. You can search for them in the search bar using; feature:accessibility-ready. WordPress also provide guidelines about accessibility. However, for the website to meet the standards of accessible web, the content must also be modified to include things like alt text for images.

There are a lot of tools online for checking the accessibility of your website.

Useful links;
Web Accessibility Initiative
WordPress’s accessibility guidelines
Wave Web Accessibility Tool.

WAVE Web Accessibility Tool

Screenshot of WAVE Summary panel which has detected 1 Error and 2 Alerts.

WAVE gives you quick feedback.

I simply pasted the URL for my website into the bar on the home page and it generated a list. These include errors, alertss, features, structural elements, HTML5 elements and contrast errors.

Headings

Through this tool I discovered I was using headings incorrectly. Headings allow users with screen readers to quickly navigate around a page.

If they are used stylistically as they were on my About page, they will make the website confusing and messy. I fixed this issue by using text style controls on a paragraph block.

This knowledge also influenced how I designed other pages. For example, I split my 23 Things page into 4 groupings; access, library tools, communication/education, and digital privacy. These have heading level 2. Then, each of the 6 numbered things within a group had a heading level 3. This was designed so that users wouldn’t have to sit through a list of 23 headings on the page if they wanted to return to a particular one.

A screenshot of the WAVE tool alert 'Skipped heading level' on a line of text within my About page.

Errors

A screenshot of the WAVE tool showing that an unlabelled comment box is causing an error.

At first I struggled to find what was triggering the Error alert. To find it, I had to view the HTML by selecting the ‘No Styles’ tab.

This showed that a comment box embedded by WordPress was unlabelled.

Unfortunately I don’t think there’s any way for me to resolve this within the WordPress.com platform.

Alt Text

Images which are part of understanding the website content require alt text. These are fed through to screen readers, so they need to be useful in their description. Images which are purely decorative should not have alt text.

Captioning video

It’s important to read about the best practice for captioning, as there are guidelines to make the text easier to read.

Seelan Palay of EngageMedia’s
Best Practice for Captions

Media Access Australia’s
Captioning guidelines

Captioning video is central to making content accessible. Not only is it important for deaf people, but it also makes the content available to people who cannot use sound on their devices. This section is about the options for captioning. There’s more of a rundown of the details of adding subtitles in my post about Video.

Free Software Option

Aegisub

A screenshot of the program Aegisub showing a visible sound file and list of subtitles.

This program makes it easy to time the subtitles just right.

It gives you an idea when your subtitles are not displayed long enough for the number of words. It does require a separate program to add them to the video, but you can use YouTube. It won’t sense any of the text, you have to write it all yourself.

YouTube

YouTube has the ability to add subtitles to your videos. It can even automatically generate them with reasonable accuracy. This makes the process a lot easier, you’re essentially editing instead of starting from scratch. However, it can be easy to overlook the words that YouTube has recorded incorrectly.

You don’t get fine detail control. If you need to you can download the subtitles from YouTube and perfect them in another program like Aegisub.

Captions as default

I wanted captions to be the default on my videos. To do this, I used Cindy Hernandez’s guide on How to force Closed Captions.
Firstly I added this tag to the video;

yt:cc=on

Then I added the following piece of code to the end of the embed link;

?cc_load_policy=1

Transcription

In some cases where you can’t add captions because the video is being hosted by someone else, providing a transcription of the audio can assist. You can see an example of a transcription I’ve completed on my Transcriptions page.

LibreOffice Calc

Tools such as Excel and its open source competitor Calc are useful for managing all kinds of data. Because of their flexibility it is possible to hone in on a particular task and construct useful tools for data management. This post explores a particular spreadsheet I made in LibreOffice Calc, which uses array functions and dynamic named ranges to keep track of garden beds and plant germination.

As part of this project, I wanted to become more confident with Excel. However – I wanted to try out the open source version Calc, published as part of LibreOffice. The interface and expressions are very similar. Because embedding the sheets into the page was problematic I’ve included screenshots, walkthrough videos and code.

Selecting these images will open a new window.

Videos

The following three videos will walk you through the spreadsheet, the germination page, and the array functions used.

Code!

In hindsight, I could probably now write the code a lot cleaner, however these are some of the significant codes in the cells.

This is the code which returns the most recent date that a plant family was planted in a particular location;

=IF((SUMPRODUCT(--($Plantings.$D2:$D100=D4),--($Plantings.$B2:$B100=B4),$Plantings.$A2:$A100))=0,"Never",(MAX(IF(test=1,$Plantings.$A2:$A100))))

The code for returning how many plants to be planted;

=SUMPRODUCT(--(Glist="Y"),(Gcount))-SUMPRODUCT(--(Pcount="Y"),(Gcount))

To return the number of germinated plants;

=COUNTIF(Gdate,">1")

To return the next fertilizer date;

=INDEX(fert,MATCH(B4,name,0))
Design a site like this with WordPress.com
Get started