Year 8 Digital Literacy Assessment 2 - Filtering & Sorting

In this Year 8 Digital Literacy assignment focusing on “Star Wars,” students are to manipulate a “Star Wars Character Dataset” spreadsheet by resizing columns, adding borders, applying specific cell shading and text formatting, and setting the font to ‘Roboto.’ They’re tasked with calculating the total mass and average height of characters using SUM and AVERAGE functions, respectively. Part 2 requires filtering data for human characters with specific eye colors and mass, sorting by name, and creating bar and column charts with detailed customization, which are then added to a Google slideshow. Additionally, an IF statement is utilized to identify characters from ‘Tatooine.’ For the presentation component, filtered data and a character collage are to be included in the slideshow, which must be well-designed with an appropriate title, background color, font, and images. Students are advised to thoroughly review their work before submitting both the spreadsheet and the presentation.