Category:
Office
Title:
Step by step Libre Calc

Spreadsheet programs are programs that are used frequently in office life or in daily life, facilitating our calculation and tabulation process.

The main spreadsheet programs can be listed as LibreOffice Calc, Microsoft Excel, Google Spreadsheets. LibreOffice is a suite of free and powerful office programs that can be installed on computers. Therefore, we will also explain our activities through Libre Calc.

With these activities, you will be able to comprehend the basic operations you can do in spreadsheet programs and be a user of a basic spreadsheet program.

It is recommended that you do the activities in order. You can download and install LibreOffice from the link below before performing the activities.

https://tr.libreoffice.org/

1. Making School ID Card

With this activity,

  • Merging celss in spreadsheet,
  • Coloring cells,
  • Adding picture,
  • Switching to new line in a cell,

will be learned. You can also design a school ID as follows:


Helpful informations:

  • To merge cells, select cells and press  button. Or select cells and right click>merge cells option.
  • To color cells press  button.
  • To switch new line in cell press Ctrl+Enter together. For Excel  this shortcut is Alt+ Enter.
  • To add image path is  Add>Image.


2.Syllabus

With this activity,

  • Putting lines in spreadsheet,
  • Filling the days and numbers consecutively into cells with auto-fill
  • Using textbox,

will be learned. You can also design a syllabus as follows:



Helpful informations:

  • To create a line inside the cell, select the cell, right click> format cells> borders.
  • To add the "hours" text , follow Insert> Textbox.
  • To write the days consecutively, write the upper cell on Monday and pull it down from the lower right corner. Do the same for numbers and pull to the right.

3.School Sketch

With this activity,

  • Creating borders as desired in the spreadsheet,
  • Simple plan, creating sketch-like drawings in spreadsheet

Will be learned. Design a building sketch as follows.



Helpful information:

  • First draw the lines of the outline.
  • You can add borders to the desired region by selecting the cells and clicking  buttons right or use right click>format cells>borders menu

4.Calendar

With this activity,

  • Adjusting row and column dimensions in the spreadsheet,
  • Filling the numbers from the specified number with the auto-fill feature,
  • Adding comments to cells,

will be learned. Design a calendar as follows.



Helpful informations:

  • To give the desired dimensions to the rows and columns, you can select the rows and columns from the left and top and the right click> row height or right click> column width to give the values you want.
  • Looking at the calendar of the computer, which day starts from the day according to him start the day. And fill in the calendar numbers with the auto-fill feature. For example, if you type 7 in the upper cell and hold the lower right point, the remaining days will be filled automatically.
  • You can add notes to the respective cells by right clicking on specific days such Chrismas,with right click> Add comments.
  • You can enrich your calendar visually by adding pictures or color fills to your calendar.

5. Four Process Calculator

With this activity,

  • Writing formula to cells,
  • Four basic process in spreadsheet,

will be learned. Design a calculator as follows,

.

Helpful informations:

  • Click on the cells to be processed and put them cell names. For example, type = D3 + D6 for addition. The subtraction, multiplication and division signs are -, *, /, respectively.


6.Score Table

With this activity,

  • Writing the average formula,
  • Conditional formatting

will be learned. Design a score table as follows,


Yardımcı bilgiler:

  • Click on the average cells to get the average and type the formula in the above example =average(f6: h6). In here means the cell range from cell F6 to H6 cell. On the average, type in the form of formula = average (e6; ı6). Here ; cell e6 and cell i6.
  • Select the average cells to perform conditional formatting. Then press the   button in the menu above. And specify the conditions. If the grade point averages are 45 and above, you can set the green fill. For the smaller 45 is the red fill.

7. Store Spreadsheet

With this activity,

  • Setting the cell format as currency unit,
  • Take a percentage,
  • Finding the largest and the smallest values,
  • Using the date formula  

will be learned. Design a store spreadsheet as follows,


Helpful niformations:

  • To set the cell unit as the currency, select the cells> right click> format cell> numbers> currency
  • For a 50 percent raise price, type = D5 + D5 * 50% and copy it to the lower cells.
  • For a 20% discount, type = D5-D5 * 50% and copy it to the lower cells.
  • For the general total, type =SUM(G5:G1048576).
  • For the lowest price, type =MIN(D5:D1048576).
  • For the highest price, type =MAX(D5: D1048576).
  • For the average selling price, type =AVERAGE(D5:D1048576).
  • Type the formula =TODAY() for the date of the day.

8. Expenses Table

With this activity,

  • will strenghten previous learnigs,
  • Creating, line, column, pie charts

will be learned. Design a expenses table

as follows,

Helpful informations:

  • When generating the electricity bill line by month, select the Months and Electricity columns as the end of December and follow Insert> Chart. Create the chart by making the necessary settings.
  • Select the January, February and Expense columns as you create the column chart of the February spending and follow Insert> Chart. Use the settings to remove the january from the selection.

  • When creating a pie chart based on the type of total spending, select the Monthly column and spend columns along with the total row below (do not select the monthly total sum column) and select Insert> Chart. Create the chart by making the necessary settings.
814 views
COMMENTS
User: Aly Chiman
Hello there, My name is Aly and I would like to know if you would have any interest to have your website here at codeforyoungs.com promoted as a resource on our blog alychidesign.com ? We are in the midst of updating our broken link resources to include current and up to date resources for our readers. Our resource links are manually approved allowing us to mark a link as a do-follow link as well . If you may be interested please in being included as a resource on our blog, please let me know. Thanks, Aly