Spring Technology Course Details

Introducing an Office Without Walls, Doors, or Windows

This is the first of four courses on a suite of applications or computer software, useful for organizing your day. No requisite skills or knowledge is required. Just an interest in experiencing a different way of looking at your finances, your lists, your clubs, your presentations, and myriad other interests in your life. Our first interactive discussions will provide an overview of the core applications of LibreOffice (we will refer to them as tools); Calc, Base, Writer, and Impress. You will learn where, and how, to download a free copy of the open-platform suite of applications. A copy of the references will be provided at each session. Feel free to bring your Windows, Mac, IOS, and/or Android device if you like.

Calc: Because You Only Have Ten Fingers and Toes

This course will focus on one of the key LibreOffice tools: Calc. Calc is a virtual worksheet; similar to the green and buff colored paper worksheets used to organize and tabulate numbers. Calc is dissimilar in that it can accommodate 1,048,576 line items (records) and 1,024 columns (months, years, or other views of the records). Calc, as its name declares, can calculate many answers from the numbers; subtotals, grand totals, averages, percentages and other useful information from the many combinations of records and columns. In this introductory session, we will look at navigating the virtual worksheet, adding formulas, sorting and filtering records, and formatting the screen and printed reports.

Calc With Attitude

This course will continue our earlier courses on the LibreOffice tool: Calc. Calc is far more than a collector of numbers. We will discuss how you can use one of the advanced features of Calc, the Pivot Table, the Sort feature, and the Filter feature, to allow the records to explain themselves. Questions will be posited, and solved, interactively. Questions such as: Am I spending more, or less, than I anticipated this month? What bank transaction is causing my reconciliation to be out of balance? How many ladies wore a red hat to the Red Hat luncheon each month for the past five years?

Do You Need a Free Office (No Construction Required)?

This last of four courses in the series will discuss how Base (database), Impress (presentation), and Writer (word processor) can be incorporated with Calc to access large numbers of records (Census data, your bank account, demographics for the town where you live). Questions will be taken on the LibreOffice tools. Also, sharing your efforts in one tool, to present the results in a different tool. We will also call for ideas and a show of hands for future workshop topics.

Mac Essentials

The first session of this two-week course will focus on understanding the key features of the Mac. You will learn how to organize and find files, how to use built-in apps to perform basic tasks, and how to configure the computer for better performance. You will learn how to protect your important files and what to do when trouble strikes. The second session will provide you with tips, tools, and techniques to help you use your Mac more effectively. Learn to use productivity apps, how to free yourself of clutter, and how to protect your important files. Learn more about what to do when trouble strikes. It does not matter if you are a beginner or a long-time Mac user, there are always new things to learn (or re-learn). Workshops are a mixture of presentations, demonstrations, and exercises. If you have a laptop bring it with you to class. Class participants will be provided with links to a variety of useful resources and tutorials.

Quantum Computing Demonstration

The IBM Q Experience is an online platform that gives users in the general public access to a set of IBM’s prototype quantum processors via the Cloud. We will explore how this system can be used to reveal the differences between conventional and quantum computing programs. Also, programs that illustrate the special capabilities of quantum computers will be demonstrated. This course will make real the concepts from the companion Introduction to Quantum Computing course.

Tech Clinic – General

Do you need help with your Mac, iPad or iPhone, Apple Watch or Windows PC? Do you want to learn new things about technology and the internet? Tech Clinics will provide useful tips, hardware and software recommendations, helpful advice, and teach you about getting more from your computers and devices. During each 2-hour session, you will have ample time to ask questions and discuss problems. Topics will change each month or so.

Tech Clinic: Android Smart Phones and Tablets

This course will describe and demonstrate the basic physical features of Android phones and tablets, as well as settings and commonly used apps. We will also go over use of the user interface and the different screens. We will also discuss security, use of the app store, and managing your apps in general for good performance without unecessarily draining your battery or going over your data limit.

Tech Clinic: Windows 10

This course will include a short review of the basic features of a Windows 10 computer, with additional discussion of more topics such as security and virus protection, and new features like virtual desktops. We will also discuss common productivity apps such as word processors and spreadsheets, and pros and cons of using free versions of those versus using Microsoft Office.

Using Google Drive/Apps

Google Drive is a free service that allows you to store files online (up to 15GB) and access them anywhere using the cloud. Google Drive includes free web-based applications for creating documents, spreadsheets, presentations, and more. These applications will be familiar to anyone that has used Microsoft Office (Word, Excel, etc.). Anyone with a Google account automatically has a Google Drive account. Google Drive is one of the most popular cloud storage services today and is used by many companies, schools, and universities. Marion County Schools will be equipping all students with Chromebook laptops which depend upon the Google suite of apps. This workshop will introduce you to Google Drive and the associated apps and help you get started using it to create, edit, and share documents. Workshops are a mixture of presentations, demonstrations, and exercises. Class participants will be provided with links to a variety of useful resources and tutorials.

Using Numbers

This workshop will introduce you to the basic features of the Apple Numbers spreadsheet app by creating several useful spreadsheets such as a to-do list, a daily schedule, and a basic budget. We will cover topics such as formatting, simple equations, importing and exporting, connecting to iCloud, and printing. Workshops are a mixture of presentations, demonstrations, and exercises. Class participants will be provided with links to a variety of useful resources and tutorials. If you don’t have a copy of the free Numbers app, go to the Mac App Store and download it. Bring your laptop if you have one.

Using Pages

This workshop introduces you to the basic features of the Apple Pages word processing app by creating several simple documents. We will cover topics such as formatting, working with images and objects, connecting to iCloud, importing and exporting, and printing. Workshops are a mixture of presentations, demonstrations, and exercises. Class participants will be provided with links to a variety of useful resources and tutorials. If you do not have the free Pages app, go to the Mac App Store and download it. Bring your laptop if you have one.

Using Voice Commands With Computers, Smartphones and Tablets

Tips and tricks for using the voice command feature effectively on various computers, smartphones and tablets. Will focus on the fab four of digital assistants; Apple – Siri, Windows 10 – Cortana, Android – Google Now, and Amazon – Alexa, but the basic concepts should apply to all simlar apps. Will include tips for phrasing commands to get the best results, what kinds of things the digital assitants are good at, and the most common uses of digital assistants.