YEAR 7
DIGITAL TECHNOLOGY
SPREADSHEETS TASK 2E: SPORTS BALL
LEARNING INTENTION
We will learn how to create a table of numerical data, use the AutoSum function, and apply
conditional formatting to the dataset.
SUCCESS CRITERIA
I can:
• create and format a table used for numerical data.
• enter numerical data accurately into cells and format those cells with various styles.
• use the AutoSum function to find the maximums and totals of a dataset.
• apply conditional formatting to a dataset to highlight high and low values of the totals.
SECTIONS
Click one of the links below to jump to that section:
• Creating a new spreadsheet Page 2
• Starting the dataset Page 2
• Using the AutoSum functions Page 2
• Conditional formatting Page 4
• Preparing the work for upload to Compass Page 5
• Task checklist Page 6
• Digital Technology subject rubric Page 7
INSTRUCTIONS BEGIN ON THE NEXT PAGE…
PAGE 1 OF 7 LAST UPDATED: 14 FEBRUARY 2025 CREATED BY PAVAN ROHIT
YEAR 7
DIGITAL TECHNOLOGY
SPREADSHEETS TASK 2E: SPORTS BALL
CREATING A NEW SPREADSHEET
1. Open Google Sheets, create a Blank spreadsheet and save it as Sports inside the
Spreadsheets folder.
Every time you want to access this file, you can open the Files app, click Google Drive, navigate to the
Spreadsheets folder, and then click the [Link] file to continue your work.
If you do not remember how to perform any of the actions to recreate the tables in step 2, you can
review the instructions document for Spreadsheets Task 1 and Spreadsheets Task 2 as a reminder.
STARTING THE DATASET
2. Using what you have learned from Spreadsheets Task 2, recreate the set of three tables to
match the one shown in the image below.
IMPORTANT: To add two more columns, move the mouse above the A column heading,
right-click, then select + Insert 1 column left. Do this twice to get the AA and AB columns.
USING THE AUTOSUM FUNCTIONS
3. Click on cell I4 and type =SUM(C4:H4) then hit Enter.
4. Fill in the empty cells from cell I5 to cell I13 using similar SUM formulas like the one written
in step 3.
INSTRUCTIONS CONTINUE ON THE NEXT PAGE…
PAGE 2 OF 7 LAST UPDATED: 14 FEBRUARY 2025 CREATED BY PAVAN ROHIT
YEAR 7
DIGITAL TECHNOLOGY
SPREADSHEETS TASK 2E: SPORTS BALL
5. Click on cell C14 and type =SUM(C4:C13) then hit Tab.
6. Fill in the empty cells from cell D14 to cell I14 using similar SUM formulas like the one
written in step 5.
7. Click on cell C15 and type =MAX(C4:C13) then hit Tab.
8. Fill in the empty cells from cell D15 to cell I15 using similar MAX formulas like the one
written in step 7.
9. Repeat step 3 to step 8 for the “Team Green” table and “Team Blue” table.
If done correctly, the table will look like the one in the image below.
Note how the numbers inside the red, green, and blue boxes are bolded, larger, and coloured white.
REMEMBER: Your teacher will know if you have entered the AutoSum functions correctly by looking
at the formula bar above the spreadsheet when marking your work. DO NOT copy the numbers as
they appear in the image above into the tables. Use step 3 to step 8 to input the correct formulas.
INSTRUCTIONS CONTINUE ON THE NEXT PAGE…
PAGE 3 OF 7 LAST UPDATED: 14 FEBRUARY 2025 CREATED BY PAVAN ROHIT
YEAR 7
DIGITAL TECHNOLOGY
SPREADSHEETS TASK 2E: SPORTS BALL
CONDITIONAL FORMATTING
10. Use what you have learned from the Spreadsheets Task 2 instructions to create conditional
formatting for each table to match the tables in the image below.
You have reached the end of the instructions!
If you have time, go back over the instructions again just to make sure you have done everything
correctly.
FIND OUT HOW TO PREPARE YOUR WORK FOR UPLOAD ON THE NEXT PAGE…
PAGE 4 OF 7 LAST UPDATED: 14 FEBRUARY 2025 CREATED BY PAVAN ROHIT
YEAR 7
DIGITAL TECHNOLOGY
SPREADSHEETS TASK 2E: SPORTS BALL
PREPARING THE WORK FOR UPLOAD TO COMPASS
26. Click on File on the menu bar at the top of Google Sheets, hover the mouse cursor over the
Download option, then click the Microsoft Excel (.xlsx) option on the menu that appears.
This will save a document called [Link] into your Downloads folder.
27. Go to Compass.
You can do this by typing Tarneit College into Google search and then clicking on the “Tarneit
P-9 College | An Inclusive School” website.
Scroll down on the school website and click on the large Login Into Compass button.
28. Log into Compass using your school ID as your username and your school password.
29. Once you have logged in, look at today’s timetable and click on this 7TECH class.
30. When the next page has loaded, click the Learning Tasks tab.
31. Click on Spreadsheets Task 2E: Sports Ball on the list of Learning Tasks.
32. From here, follow the instructions found under the UPLOADING YOUR WORK heading on the
Learning Task.
THE TASK CHECKLIST IS ON THE NEXT PAGE…
PAGE 5 OF 7 LAST UPDATED: 14 FEBRUARY 2025 CREATED BY PAVAN ROHIT
YEAR 7
DIGITAL TECHNOLOGY
SPREADSHEETS TASK 2E: SPORTS BALL
TASK CHECKLIST
You will be marked on the following criteria for this task:
Criteria Not shown Shown
Correct file uploaded
You have converted the Google
Sheets file into a Microsoft Excel file
and uploaded it to this Learning Task
with the correct file name:
[Link]
Tables created
You have accurately recreated the
tables shown in the instructions using
borders, and text input with correct
formatting.
Input dataset
You have input the numerical data
shown in the instructions accurately
without errors.
AutoSum
You have correctly used the AutoSum
functions.
Conditional Formatting
You have applied separate Conditional
Formatting for the Totals of each
dataset.
THE DIGITAL TECHNOLOGY SUBJECT RUBRIC IS ON THE NEXT PAGE…
PAGE 6 OF 7 LAST UPDATED: 14 FEBRUARY 2025 CREATED BY PAVAN ROHIT
YEAR 7
DIGITAL TECHNOLOGY
SPREADSHEETS TASK 2E: SPORTS BALL
DIGITAL TECHNOLOGY SUBJECT RUBRIC
Criteria Beginning Progressing Competent Proficient Highly Proficient
Spreadsheets Attempted to create Attempted to create Created a budgeting
Using the features and a budgeting table a budgeting table, table, worked out
functions of a spreadsheet to and work out the work out the the required
calculate a simple budget of required formulas to required formulas to formulas to fill in
N/A N/A
income and payments, and fill in the data. fill in the data, and the data, and used
applying conditional formatting use conditional conditional
to the data. formatting to formatting to
highlight the data. highlight the data.
Digital Systems Attempted to Attempted to Identified and Identified the
Investigating the internal and identify the different identify and explain explained the explained the
external parts of computer parts of computer the different parts different parts of different parts of
hardware and networks. hardware and of computer computer hardware computer hardware
networks. hardware and and networks. and networks
N/A
networks. including newer
technologies such as
Augmented Reality
(AR) and Virtual
Reality (VR) devices.
Data and Information Attempted to Attempted to Identified and Identified and
Investigating how computers explain how identify and explain explained how explained how
use binary code to represent computers use how computers computers computers
various types of data. binary to represent represent text and represent text and represent text and N/A
simple information images in binary. images in binary. images in binary and
such as text. explained data
compression.
Cyber Safety and Attempted to Attempted to Explained and found Used the Australian
explain ways people explain and find solutions for ways Privacy Principles to
Security can protect solutions for ways people can protect explain and find
Investigating and finding N/A
themselves online. people can protect themselves online. solutions for ways
solutions for ways people can themselves online. people can protect
protect themselves online. themselves online.
AI and Machine Attempted to Attempted to Identified and Identified and
identify the different identify and explain explained the explained the
Learning ways AI and the different ways AI different ways AI different ways AI
Investigating the different ways Machine Learning and Machine and Machine and Machine
AI and Machine Learning can can be used. Learning can be Learning can be Learning can be
be used. N/A
used. used. used while also
determining the
negative effects it
can have on
people's privacy.
Research Attempted to Attempted to Acquired data from
Acquiring data from a range of acquire data using a acquire data from a a range of sources
sources and evaluating their search engine. range of sources using a search
authenticity, accuracy, and using a search engine and
timeliness. engine and listed evaluated their
them in a reference authenticity by N/A N/A
table. ensuring the source
or author is a
reliable individual or
organisation in a
reference table.
Web Coding Attempted to create Attempted to plan Planned and created Planned and created Planned and created
Creating a full website using a web page using and create a full website a full website, a full website,
HTML and CSS to present the simple HTML and a full website using using HTML and CSS with correctly with correctly
information on a chosen topic. CSS. HTML and CSS to to present formatted code that formatted code that
present information information on a has no errors, using has no errors, using
on a chosen topic. chosen topic. HTML and CSS to advanced HTML and
present information CSS to present
on a chosen topic. information on a
chosen topic.
PAGE 7 OF 7 LAST UPDATED: 14 FEBRUARY 2025 CREATED BY PAVAN ROHIT