Students are tasked with rebranding Guernsey Photo Studio by creating a new logo and developing a series of digital documents to promote the company’s photographic products. The project begins with designing a logo using the abbreviation GPS and incorporating the colors of Guernsey. This logo will then be used across various digital documents to ensure brand consistency. The tasks include formatting sales data in a spreadsheet, creating a marketing presentation to showcase product prices and high-quality images, and developing a professional-looking product brochure. Advanced tasks involve calculating total sales and annual revenue in spreadsheets, creating visual representations of sales data, drafting a detailed customer letter with new deals and discounts, and compiling all documents with a cohesive design theme. This comprehensive project not only involves creative design but also the practical application of spreadsheet management, presentation skills, and professional communication, all while maintaining a consistent branding approach.

The tasks outlined for the theme park rides project cover a range of general skills that are essential for proficiently using spreadsheet software and conducting basic data analysis. Here’s a breakdown of these skills: Basic Spreadsheet Navigation and Formatting: Merging and centering cells to create titles or headers that span across multiple columns. Adding borders and shading to cells for visual enhancement and to improve readability. This skill involves understanding how to access and use formatting tools within the spreadsheet software. Formula and Function Application: Calculating values using basic arithmetic operations and formulas. This includes subtracting discounts from prices to find net costs. Utilizing built-in spreadsheet functions like SUM to aggregate data, which is fundamental for summarizing information, such as calculating total profit or loss. Understanding how to apply formulas to real-world scenarios, like calculating the profit or loss for a ride based on its operational data. Data Analysis: Applying formulas to calculate specific metrics, such as cost per ride for children and profit or loss for each ride. This requires an understanding of basic mathematical concepts and the ability to translate real-world situations into calculable formulas. Analyzing and summarizing data to understand the financial performance of different rides within the theme park. Chart Creation: Creating visual representations of data through charts, such as column charts, to illustrate the profit or loss associated with each ride. This involves selecting appropriate chart types, defining data ranges for the chart, and customizing the chart’s appearance. Presentation Skills: Integrating tables and charts into presentations. This skill is about summarizing and presenting data in a clear and visually appealing manner, which may involve using additional software like Microsoft PowerPoint or Google Slides. Communicating findings or insights effectively through visual aids, which requires an understanding of how to structure presentations to convey information logically and engagingly. Critical Thinking and Problem Solving: Interpreting the tasks and applying the appropriate spreadsheet tools and functions to complete them. This requires problem-solving skills to figure out how to execute each task and critical thinking to apply the correct formula or function based on the context. Attention to Detail: Ensuring accuracy in data entry, formula application, and function usage. Attention to detail is crucial to avoid errors that could lead to incorrect calculations or misinterpretations of the data. Through completing these tasks, students practice and enhance their skills in data management, analysis, and presentation, all of which are valuable in various academic and professional settings.

In the Year 7 Computing Digital Literacy End of Year Assessment titled “MOTHERBOARD RUNNER,” students navigate through a comprehensive evaluation encompassing online safety, spreadsheet proficiency, and data presentation skills. The assessment kicks off with an online safety questionnaire, encouraging thoughtful responses on digital well-being. It then transitions to practical spreadsheet tasks within a Google Sheet named “Motherboard Runner,” where students apply formatting techniques, utilize SUM and IF functions, and craft a pie chart to analyze achievements data. The project culminates in creating a Google Slides presentation that not only showcases the analyzed data but also incorporates creative elements such as a motherboard-themed design and a collage of images representing various achievements. This multifaceted assessment is designed to test students’ digital literacy skills in a holistic manner, preparing them for more advanced computing concepts while reinforcing the importance of online safety.

In the KS3 Computing - Digital Literacy - Progress Point 2 project, students tackle the task of calculating and presenting the upkeep costs for animals in an exotic zoo. This involves creating a detailed Google Sheet to itemize and analyze weekly and yearly maintenance and food expenses, employing formulas to compute total costs. Additionally, students craft a Google Document to summarize these findings and incorporate comparative charts. The assignment culminates in designing a visually engaging Google Slides presentation titled “Animals Scrapbook,” showcasing high-quality images of the zoo’s animals, enhancing understanding of the financial aspects of animal care through digital literacy skills, and providing a creative overview of the zoo’s inhabitants.

Students are tasked with comprehensive management tasks for the “Little Stars” toddler sports club, which involve designing a simple logo using Google Drawings, formatting and managing financials within a spreadsheet, and creating engaging promotional materials. Key tasks include the creation of a club logo incorporating sports equipment, formatting membership costs and discounts in a spreadsheet while integrating the logo, developing a Google Slides presentation to advertise memberships with detailed descriptions and visually appealing layouts, and employing formulas to calculate session costs, discounts for frequent attendees, and final payments due. Additionally, students will use conditional formatting, sorting, and filtering to manage club finances effectively, and compile a clear, well-formatted document outlining outstanding payments, all of which demonstrate practical applications of digital tools for business management and marketing in a real-world context.

In the Year 8 Digital Literacy Assessment 3, students are tasked with utilizing data from the “Mobile Phone Usage” spreadsheet across three Google applications: Sheets, Docs, and Slides. The assessment begins with Google Sheets, where students format data for visibility, calculate highest and lowest gaming usage, total device usage, average gaming usage, and categorize entertainment usage using functions and filters. They are also required to create and format bar and pie charts reflecting usage statistics. In Google Docs, students must create a document to summarize their findings, including charts and explanations within a structured table. Finally, in Google Slides, they are to present their data and analysis through a presentation that includes data visualization, a collage of flags from the data set, and appropriate formatting throughout. Students must adhere to specific formatting guidelines for font, font size, and headings across all tasks. The assessment emphasizes the application of digital literacy skills in data analysis, presentation, and documentation, requiring thoroughness and attention to detail before submission via Google Classroom.

For Guernsey Ices’ latest project, the task involves utilizing a blend of digital skills to analyze and determine the most popular new ice cream flavor from a trial range. This assessment encompasses creating a detailed Google Sheet to record and calculate sales data across different locations and dates, employing functions to summarize total sales per flavor. Additionally, visual enhancements and charts are crafted to present the data attractively and informatively. A Google Doc is prepared to compile and list ice cream flavors, incorporating sales data and graphical analyses. Furthermore, a Google Slides presentation is developed to showcase the new flavor, incorporating sales tables, pie charts for total sales visualization, and professional styling to effectively communicate the findings to the company directors. This comprehensive approach ensures a thorough evaluation and presentation of consumer preferences, aiding Guernsey Ices in making an informed decision on their next production focus.

In this assignment, students work with a “Top 200 Video Game Sales” spreadsheet, performing tasks that include formatting for visibility, calculating global sales, sorting data, and creating a column chart of top-selling games. They are to filter data for specific criteria, use an IF statement to identify high-selling games, and incorporate this data into a Google slideshow with a detailed chart and a collage of game images. The task emphasizes spreadsheet management, data analysis, and presentation skills, culminating in a thorough review before submission of both the spreadsheet and the presentation.

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.

Students are tasked with managing a guitar shop sale, involving three main components: spreadsheet management, word processing, and creating a marketing presentation. Firstly, they must use a Google Sheet to calculate the sales prices of guitars using formulas for discounts, types, and final prices, ensuring the sheet is well-formatted and visually appealing. Next, they are to create a Google Document titled “Sale Price Reference Sheet,” summarizing the discount and sale price information in a concise manner, formatted for easy in-shop reference. Lastly, they will design a stylish marketing presentation in Google Slides, adhering to the company’s black, grey, and white color scheme and incorporating high-quality images and detailed information about select guitar models and discounts. All components must reflect the company’s branding style, with attention to detail in formatting and content accuracy, and be submitted via Google Classroom.

Our Skills Tracker is an essential educational tool designed for teachers to enhance their students’ digital skills across four critical areas. In Digital Literacy, students learn to use key software applications, manage files, search the internet, and communicate via email. The Computer Science section introduces programming basics, game development, and hardware understanding. Digital Citizenship covers internet safety and ethical considerations in technology, including AI. Finally, Multimedia skills allow students to edit images, videos, sounds, and create animations. This tool provides a comprehensive and practical approach to digital education in the classroom.