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 C++ Rating: 4 out of 5 stars4/5C Language Programming Codes Rating: 0 out of 5 stars0 ratingsLearn All about Evolution of Computers Rating: 0 out of 5 stars0 ratingsLearn Typing Rating: 0 out of 5 stars0 ratingsYoga (Pawanmuktasana) Rating: 3 out of 5 stars3/5Basic Language Rating: 0 out of 5 stars0 ratingsLearn All About Cyber Safety Rating: 0 out of 5 stars0 ratingsLearning Open Office: Writer, Impress, Draw Rating: 0 out of 5 stars0 ratingsEnjoy with Computers Rating: 0 out of 5 stars0 ratingsOpen Source: Introduction & Outline of Office Suite Rating: 0 out of 5 stars0 ratingsAmigurumi Patterns of 2 Bunnies Rating: 0 out of 5 stars0 ratingsHappiness with Meditation & Yoga Rating: 0 out of 5 stars0 ratings
Related to Learning Open Office
Related ebooks
Intermediate Access: Access Essentials, #2 Rating: 0 out of 5 stars0 ratingsOpen Source: Introduction & Outline of Office Suite Rating: 0 out of 5 stars0 ratingsPython. Easy Steps to Learning. Rating: 0 out of 5 stars0 ratingsExcel VBA Programming: Task Optimization and Daily Work Automation Rating: 0 out of 5 stars0 ratingsExercises of Logarithms and Exponentials Rating: 0 out of 5 stars0 ratingsNumbers Rating: 0 out of 5 stars0 ratingsBeginning C++17: From Novice to Professional Rating: 0 out of 5 stars0 ratingsMicrosoft Azure IoT A Complete Guide - 2019 Edition Rating: 1 out of 5 stars1/5Professional ASP.NET MVC 4 Rating: 4 out of 5 stars4/5Microsoft Office Productivity Pack: Microsoft Excel, Microsoft Word, and Microsoft PowerPoint Rating: 0 out of 5 stars0 ratingsBasic Language Rating: 0 out of 5 stars0 ratingsSets, Numbers and Flowcharts Rating: 0 out of 5 stars0 ratingsLearning Open Office: Writer, Impress, Draw Rating: 0 out of 5 stars0 ratingsC Programs To Become Expert In Programming Rating: 0 out of 5 stars0 ratingsBasic Guide to Programming Languages Python, JavaScript, and Ruby Rating: 0 out of 5 stars0 ratingsLearning Excel Made Easier Rating: 0 out of 5 stars0 ratingsExcel 101: A Beginner's Guide for Mastering the Quintessence of Excel 2010-2019 in no time! Rating: 0 out of 5 stars0 ratingsLearn Excel in 24 Hours Rating: 4 out of 5 stars4/5Microsoft Excel: Microsoft Excel User Interface, Excel Basics, Function, Database, Financial Analysis, Matrix, Statistical Analysis Rating: 0 out of 5 stars0 ratingsHow To Develop A Performance Reporting Tool with MS Excel and MS SharePoint Rating: 0 out of 5 stars0 ratingsMicrosoft Excel for Beginners and Intermediates Rating: 0 out of 5 stars0 ratingsExcel Pivot Tables & Charts Rating: 0 out of 5 stars0 ratingsMicrosoft Office Excel 2013 New Features and Power Tips Rating: 0 out of 5 stars0 ratingsMicrosoft Office Productivity Pack: Microsoft Excel, Microsoft Word, and Microsoft PowerPoint Rating: 0 out of 5 stars0 ratingsPivot Tables for everyone. From simple tables to Power-Pivot: Useful guide for creating Pivot Tables in Excel Rating: 0 out of 5 stars0 ratingsImprove your skills with Google Sheets: Professional training Rating: 0 out of 5 stars0 ratingsEXCEL: Microsoft: Boost Your Productivity Quickly! Learn Excel, Spreadsheets, Formulas, Shortcuts, & Macros Rating: 0 out of 5 stars0 ratings
Computers For You
The Invisible Rainbow: A History of Electricity and Life Rating: 5 out of 5 stars5/5Procreate for Beginners: Introduction to Procreate for Drawing and Illustrating on the iPad Rating: 0 out of 5 stars0 ratingsSlenderman: Online Obsession, Mental Illness, and the Violent Crime of Two Midwestern Girls Rating: 4 out of 5 stars4/5The Innovators: How a Group of Hackers, Geniuses, and Geeks Created the Digital Revolution Rating: 4 out of 5 stars4/5Elon Musk 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/5CompTIA IT Fundamentals (ITF+) Study Guide: Exam FC0-U61 Rating: 0 out of 5 stars0 ratingsMastering ChatGPT: 21 Prompts Templates for Effortless Writing Rating: 5 out of 5 stars5/5101 Awesome Builds: Minecraft® Secrets from the World's Greatest Crafters Rating: 4 out of 5 stars4/5The Professional Voiceover Handbook: Voiceover training, #1 Rating: 5 out of 5 stars5/5The Complete Powershell Training for Beginners Rating: 0 out of 5 stars0 ratingsEverybody Lies: Big Data, New Data, and What the Internet Can Tell Us About Who We Really Are Rating: 4 out of 5 stars4/5The ChatGPT Millionaire Handbook: Make Money Online With the Power of AI Technology Rating: 4 out of 5 stars4/5The Hacker Crackdown: Law and Disorder on the Electronic Frontier Rating: 4 out of 5 stars4/5Alan Turing: The Enigma: The Book That Inspired the Film The Imitation Game - Updated Edition Rating: 4 out of 5 stars4/5CompTIA Security+ Get Certified Get Ahead: SY0-701 Study Guide Rating: 5 out of 5 stars5/5Uncanny Valley: A Memoir Rating: 4 out of 5 stars4/5How to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5Ultimate Guide to Mastering Command Blocks!: Minecraft Keys to Unlocking Secret Commands Rating: 5 out of 5 stars5/5CompTIA Security+ Practice Questions Rating: 2 out of 5 stars2/5Deep Search: How to Explore the Internet More Effectively Rating: 5 out of 5 stars5/5The Huffington Post Complete Guide to Blogging Rating: 3 out of 5 stars3/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