Learning Open Office: Calc & Base
By Durgesh
()
About this ebook
In my previous book on Open Office, we learnt about Writer, Impress and Draw. This book will deal with spreadsheets and database applications and their usage which are also a part of Open Office Suite namely Calc and Base. These two applications allow us to work with spreadsheet and database applications respectively. The book has explanation with examples. Helps in preparing students with objective type questions.
Durgesh
Major part of my career has been in the field of Education and Administration. I have a good command over my subject (computer science) and effective communication in English. I have written books in my subject and have represented Science Olympiad Foundation. I have been very adaptable to any kind of new environment and technologies. I have written a few computer science books for my students based on their syllabus. With lots of health issues cropping up with time, I recreated myself with the help of Yoga and Meditation. Which gave me a direction towards a happy mind and body. Thus, decided to share my experience in penning down the Good Health Technique with all. I am ever grateful to Guruji, Sri Sri Ravi Shankarji and to Swami Satyananda Saraswatiji for guidance towards ultimate physical and mental good health. Lately I have picked up a new hobby - the art of crocheting. While making some crochet related products, I have written a few amigurumi patterns. Sharing my new skill through this platform.
Read more from Durgesh
Learn Typing Rating: 0 out of 5 stars0 ratingsLearn C++ Rating: 4 out of 5 stars4/5Learn All about Evolution of Computers Rating: 0 out of 5 stars0 ratingsYoga (Pawanmuktasana) Rating: 3 out of 5 stars3/5C Language Programming Codes Rating: 0 out of 5 stars0 ratingsBasic Language Rating: 0 out of 5 stars0 ratingsLearn All About Cyber Safety Rating: 0 out of 5 stars0 ratingsEnjoy with Computers Rating: 0 out of 5 stars0 ratingsLearning Open Office: Writer, Impress, Draw Rating: 0 out of 5 stars0 ratingsOpen Source: Introduction & Outline of Office Suite Rating: 0 out of 5 stars0 ratingsHappiness with Meditation & Yoga Rating: 0 out of 5 stars0 ratingsAmigurumi Patterns of 2 Bunnies Rating: 0 out of 5 stars0 ratings
Related to Learning Open Office
Related ebooks
Microsoft Excel: Microsoft Excel User Interface, Excel Basics, Function, Database, Financial Analysis, Matrix, Statistical Analysis Rating: 0 out of 5 stars0 ratingsIntermediate Access: Access Essentials, #2 Rating: 0 out of 5 stars0 ratingsExcel 365 Charts: Easy Excel 365 Essentials, #3 Rating: 0 out of 5 stars0 ratingsOpen Source: Introduction & Outline of Office Suite Rating: 0 out of 5 stars0 ratingsBeginning C++17: From Novice to Professional Rating: 0 out of 5 stars0 ratingsData Structures II Essentials Rating: 0 out of 5 stars0 ratingsBeginning Programming with C For Dummies Rating: 0 out of 5 stars0 ratingsLearning Open Office: Writer, Impress, Draw Rating: 0 out of 5 stars0 ratingsReverberation Chambers: Theory and Applications to EMC and Antenna Measurements Rating: 0 out of 5 stars0 ratingsBasics of Programming: A Comprehensive Guide for Beginners: Essential Coputer Skills, #1 Rating: 0 out of 5 stars0 ratingsProfessional ASP.NET MVC 4 Rating: 4 out of 5 stars4/5C Programming Wizardry: From Zero to Hero in 10 Days: Programming Prodigy: From Novice to Virtuoso in 10 Days Rating: 0 out of 5 stars0 ratingsC Programs To Become Expert In Programming Rating: 0 out of 5 stars0 ratingsXML Programming: The Ultimate Guide to Fast, Easy, and Efficient Learning of XML Programming Rating: 3 out of 5 stars3/5Windows 10 – Complete guide book to use your PC more efficiently Rating: 0 out of 5 stars0 ratingsProfessional Assembly Language Rating: 4 out of 5 stars4/5Basic Language Rating: 0 out of 5 stars0 ratingsWebsite Scraping with Python: Using BeautifulSoup and Scrapy Rating: 0 out of 5 stars0 ratingsExcel VBA Programming: Task Optimization and Daily Work Automation Rating: 0 out of 5 stars0 ratingsPython. Easy Steps to Learning. Rating: 0 out of 5 stars0 ratingsSimultaneous multithreading A Complete Guide Rating: 0 out of 5 stars0 ratingsMastering C: A Comprehensive Guide to Programming Excellence Rating: 0 out of 5 stars0 ratingsKEYBOARD LESSONS: Comprehensive Beginner's Guide to Learn the Realms of Keyboard Chords and Scales to Perfection Rating: 0 out of 5 stars0 ratingsIvor Horton's Beginning Visual C++ 2013 Rating: 0 out of 5 stars0 ratingsKeyboard Lessons: Tips and Tricks on Playing Keyboard Chords and Scales to Perfection Rating: 0 out of 5 stars0 ratingsEXCEL COURSE Rating: 0 out of 5 stars0 ratingsCoding In C Decoded: Decoded, #1 Rating: 0 out of 5 stars0 ratingsAppleScript Rating: 5 out of 5 stars5/5Apple Automator with AppleScript Bible Rating: 0 out of 5 stars0 ratingsMicrosoft Office Productivity Pack: Microsoft Excel, Microsoft Word, and Microsoft PowerPoint Rating: 0 out of 5 stars0 ratings
Computers For You
The Innovators: How a Group of Hackers, Geniuses, and Geeks Created the Digital Revolution Rating: 4 out of 5 stars4/5The Invisible Rainbow: A History of Electricity and Life Rating: 5 out of 5 stars5/5Alan Turing: The Enigma: The Book That Inspired the Film The Imitation Game - Updated Edition Rating: 4 out of 5 stars4/5CompTIA IT Fundamentals (ITF+) Study Guide: Exam FC0-U61 Rating: 0 out of 5 stars0 ratingsThe Hacker Crackdown: Law and Disorder on the Electronic Frontier Rating: 4 out of 5 stars4/5Standard Deviations: Flawed Assumptions, Tortured Data, and Other Ways to Lie with Statistics Rating: 4 out of 5 stars4/5Elon Musk Rating: 4 out of 5 stars4/5Mastering ChatGPT: 21 Prompts Templates for Effortless Writing Rating: 5 out of 5 stars5/5Slenderman: Online Obsession, Mental Illness, and the Violent Crime of Two Midwestern Girls Rating: 4 out of 5 stars4/5Master Builder Roblox: The Essential Guide Rating: 4 out of 5 stars4/5Uncanny Valley: A Memoir Rating: 4 out of 5 stars4/5CompTIA Security+ Get Certified Get Ahead: SY0-701 Study Guide Rating: 5 out of 5 stars5/5Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us About Who We Really Are Rating: 4 out of 5 stars4/5The Professional Voiceover Handbook: Voiceover training, #1 Rating: 5 out of 5 stars5/5101 Awesome Builds: Minecraft® Secrets from the World's Greatest Crafters Rating: 4 out of 5 stars4/5Creating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5People Skills for Analytical Thinkers Rating: 5 out of 5 stars5/5The ChatGPT Millionaire Handbook: Make Money Online With the Power of AI Technology Rating: 4 out of 5 stars4/5Deep Search: How to Explore the Internet More Effectively Rating: 5 out of 5 stars5/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5
Reviews for Learning Open Office
0 ratings0 reviews
Book preview
Learning Open Office - Durgesh
Learning Open Office
Calc & Base
For My Computer Sc. Students
By Durgesh
Contents
1. Working with OpenOffice Spreadsheet
2. Calc
3. Working with Functions
4. Working with Charts
5. Working with Database
6. Creating Table
7. Creating Forms
8. Creating Queries
9. Creating Reports
To understand the concepts of Excel and MS Access, MS Office package is used. Excel is used for spreadsheet applications and MS Access is used for database applications.
In my previous book on Open Office, we learnt about Writer, Impress and Draw. This book will deal with spreadsheets and database applications and their usage which are also a part of Open Office Suite namely Calc and Base. These two applications allow us to work with spreadsheet and database applications respectively.
Working with OpenOffice Spreadsheet
Students are well aware that a spreadsheet is a simple sheet consisting of rows and columns.
With the help of spreadsheet the user can store, view and analyze the data in an organized method.
The basic element of a spreadsheet is a workbook which is again a collection of worksheet.
A worksheet is a collection of rows and columns.
A column represents an entity.
A row represents a record.
A cell is an intersection of columns and row used for storing data like text, numbers, formulas etc.
Calc
CALC is the spreadsheet component of OpenOffice that helps us to enter data in a spreadsheet and then manipulates this data to produce certain required result.
It is similar to MS Excel.
Each spreadsheet can have many sheets and each sheet can have many individual cells.
Each sheet in Calc can have a maximum of 65536 rows and a maximum of 256 columns (A to IV). This gives 16,777,216 individual cells per sheet.
Figure below shows the interface of a Calc worksheet.
Calc Interface
The figure displays the Calc interface which looks similar to MS Excel worksheet and also works in the same manner as MS Excel.
Try to create a simple worksheet using Calc.
To open Calc, select Applications Office OpenOffice.org 2.4 Calc;
This will open Calc window.
Enter the data as shown below