Wikiversity

Computer Skills/Intermediate/Spreadsheets

< Computer Skills | Intermediate

Intermediate spreadsheet concepts include calculations, row and column management, formatting, graphs and charts.

Objectives and Skills

edit

Objectives and skills for spreadsheets include:[1]

  • Make simple calculations
  • Know how to insert/delete rows/ columns; sort
  • Know how to format data: font; color; number; text; etc
  • Understand that a change to one cell impacts on another
  • Know how to draw graphs and make charts

Multimedia

edit
  1. YouTube: Simple Formulas
  2. YouTube: Modifying Cells, Rows, and Columns
  3. YouTube: Sorting
  4. YouTube: Format Cells
  5. YouTube: Charts

Activities

edit
  1. Complete the tutorial Creating Simple Formulas.
  2. Complete the tutorial Modifying Columns, Rows, and Cells.
  3. Complete the tutorial Sorting Data.
  4. Complete the tutorial Formatting Cells.
  5. Complete the tutorial Working with Charts.

See Also

edit

References

edit
  1. ↑ University of New South Wales: Computer Skills Assessment Framework
Retrieved from "https://en.wikiversity.org/w/index.php?title=Computer_Skills/Intermediate/Spreadsheets&oldid=1987602"