Use of LibreOffice for an office automation environment

U12 - Calc - Basics

• Learning outcomes

  After the completion of the unit the students will be able to:

  • Identify the parts of Calc main window
  • Describe the spreadsheet layout and components
  • Manipulate components of a spreadsheet (sheets, rows, columns, cells)
  • List spreadsheet's data types and apply data formating to cells
  • Combine text and cell formating attributes to create visually appealing spreadsheets
• Introduction to Calc Page
• Calc Basics Quiz 1
• Navigating and Selecting within spreadsheets Page
• Calc Basics Quiz 2
• Working with columns, rows and sheets Page
• Working with rows, columns and sheets sample file
• Formatting Data Page
• Formatting Cells Page
• Calc Basics Quiz 3
• Calc basics exercise Assignment
• Create a weekly schedule Assignment
• Format data table Assignment
• U12 Self-evaluation Checklist